Semantic search

citation_inspection

Table actions

1 row where hash_id = "b7431501e3d1512e"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: web_inspectionDate (date)

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 written Program of Veterinary Care (PVC) and the List of Animals on Hand forms were not available for review at time of inspection. The required records should be made available to APHIS officials at time of inspection. To be corrected for all future inspections. An exit briefing was conducted with the facility representative.

rowid 27945
desc ACCESS AND INSPECTION OF RECORDS AND PROPERTY; SUBMISSION OF ITINERARIES.
web_siteName DANNIELLE MC GILL
kind  
Incident hash_id b7431501e3d1512e
web_inspectionDate 2014-08-20
code 2.126(b)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 1.0
web_certType Class C - Exhibitor
pdf_customer_id 326889.0
pdf_customer_name Dannielle Mcgill
pdf_customer_addr Sandy Mcgill P.O. Box 8554 Northridge, CA 91327
customer_state CA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23528341-aphis-inspection-233142217490646
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);