Semantic search
citation_inspection
2 rows where hash_id = "2a1309400b22c49c"
This data as json, CSV (advanced)
At this time the roof shingles behind the water wheel and the roof of the calf shelter are in need of attention. There are shingles missing and / or damaged. To ensure that the animal areas are maintained properly these roofs will need to be addressed. ***To Be Corrected By: August 2, 2014
| rowid | 13514 |
| desc | FACILITIES, GENERAL. |
| web_siteName | Stew Leonard's |
| kind | |
| Incident hash_id | 2a1309400b22c49c |
| web_inspectionDate | 2014-07-22 |
| code | 3.125(a) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 6.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 10174.0 |
| pdf_customer_name | Stew Leonards |
| pdf_customer_addr | 99 Federal Rd Danbury, CT 06811 |
| customer_state | CT |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23498706-aphis-inspection-203142137550631 |
| lat | |
| lng |
At the time of this inspection it was noted that the stream bed that runs through the calf, goat and sheep enclosures was in need of attention. This water feature is ~ 6-8(cid:29) deep. However, the water in this stream bed was brown and emitted an odor. At this time you could not see the bottom of this stream bed. To ensure that the areas are kept clean this water feature will need to be cleaned on a more frequent basis. ***To Be Corrected By: July 23, 2014
| rowid | 13515 |
| desc | SANITATION. |
| web_siteName | Stew Leonard's |
| kind | |
| Incident hash_id | 2a1309400b22c49c |
| web_inspectionDate | 2014-07-22 |
| code | 3.131(c) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 6.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 10174.0 |
| pdf_customer_name | Stew Leonards |
| pdf_customer_addr | 99 Federal Rd Danbury, CT 06811 |
| customer_state | CT |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23498706-aphis-inspection-203142137550631 |
| lat | |
| lng |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "citation_inspection" ( [rowid] INTEGER PRIMARY KEY, [narrative] TEXT, [desc] TEXT, [web_siteName] TEXT, [kind] TEXT, [hash_id] TEXT REFERENCES [inspections]([hash_id]), [web_inspectionDate] TEXT, [code] TEXT, [repeat] INTEGER, [pdf_insp_type] TEXT, [pdf_animals_total] FLOAT, [web_certType] TEXT, [pdf_customer_id] FLOAT, [pdf_customer_name] TEXT, [pdf_customer_addr] TEXT, [customer_state] TEXT, [pdf_site_id] TEXT, [doccloud_url] TEXT , lat double precision, lng double precision);