Semantic search

citation_inspection

Table actions

1 row where hash_id = "a520878c34b1abd5"

✎ 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 puppies did not have proper identification. All regulated animals at the facility must be properly identified to aid USDA in the tracking of animals if necessary. A cage card can be used to identify the puppies. The card must have the Licensee's certificate number, the letters USDA, the puppies individual identification numbers, the date of birth, sex and brief description. If litters are mixed then the identification must be on the puppies. The owner must ensure that all regulated animals at the facility are properly identified. To be corrected by: 02-24-15. This inspection and exit briefing conducted with the owner. End of report.

rowid 14046
desc TIME AND METHOD OF IDENTIFICATION.
web_siteName EMMA L. TILLERY
kind  
Incident hash_id a520878c34b1abd5
web_inspectionDate 2015-02-10
code 2.50(a)(1)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 58.0
web_certType Class A - Breeder
pdf_customer_id 11245.0
pdf_customer_name Emma L Tillery
pdf_customer_addr 260 R And R Lane Booneville, AR 72927
customer_state AR
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23499397-aphis-inspection-41151511070842
lat  
lng  

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