Semantic search

citation_inspection

Table actions

2 rows where hash_id = "48d1c2305afecc7f"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ narrative desc web_siteName kind hash_id web_inspectionDate code repeat pdf_insp_type pdf_animals_total web_certType pdf_customer_id pdf_customer_name pdf_customer_addr customer_state pdf_site_id doccloud_url lat lng

The Dalmatian Pen: The entrance floor of the shelter has torn carpet. The dog has been chewing and shredding the rug. Primary enclosures for dogs have to be designed and constructed of suitable materials so that they are structurally sound and will not potentially create a health hazard. The enclosure shall be kept in good repair. A program of monitoring and repairing primary enclosures needs to be created. ************** To be corrected by: September 15, 2014

rowid 7018
desc PRIMARY ENCLOSURES.
web_siteName WORLDWIDE MOVIE ANIMALS, L.L.C.
kind  
Incident hash_id 48d1c2305afecc7f
web_inspectionDate 2014-08-20
code 3.6(a)(1)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 36.0
web_certType Class C - Exhibitor
pdf_customer_id 3601.0
pdf_customer_name Worldwide Movie Animals L L C
pdf_customer_addr Box 802474 Santa Clarita, CA 91380
customer_state CA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23487311-aphis-inspection-233141538240294
lat 34.5
lng -118.4

Kitchen area: Refrigerator has an accumulation of grime and food debris under the lower food bins. Premises where housing facilities are located, including buildings and surrounding grounds, must be kept clean to facilitate the husbandry practices required in this subpart. A system is needed to ensure that adequate, routine cleaning is being done. ************ To be corrected by 8/28/2014 Exit interview conducted with facility representative.

rowid 7019
desc CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL.
web_siteName WORLDWIDE MOVIE ANIMALS, L.L.C.
kind  
Incident hash_id 48d1c2305afecc7f
web_inspectionDate 2014-08-20
code 3.11(c)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 36.0
web_certType Class C - Exhibitor
pdf_customer_id 3601.0
pdf_customer_name Worldwide Movie Animals L L C
pdf_customer_addr Box 802474 Santa Clarita, CA 91380
customer_state CA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23487311-aphis-inspection-233141538240294
lat 34.5
lng -118.4

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);