home / aphis_reports

Semantic search

citation_inspection

Table actions
  • Semantic search against this table
  • Semantic search against this table

1 row where hash_id = "0032ba15f7b06737"

✎ 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 written program of veterinary care (PVC) was not available at time of inspection. A program for the care of the animals, approved by a qualified veterinarian, should be available for review at time of inspection. Each exhibitor shall, during business hours, allow APHIS officials to examine records required to be kept by the Act and the regulations in this part. This is a 1st Re-License Inspection for a Class “C” license. The inspection and exit briefing were conducted with the applicant. All items must be in compliance within 2 more inspections by 9/04/2022 or the Applicant will forfeit the license fee and must wait 6 months to reapply. Please contact your inspector to schedule your next Relicense Inspection. “Regulated activity can continue under your existing USDA license until it expires.” n

rowid 28055
desc Access and inspection of records and property; submission of itineraries.
web_siteName P W E C ENTERPRISES, INC.
kind  
Incident hash_id 0032ba15f7b06737
web_inspectionDate 2022-07-06
code 2.126(a)(2)
repeat 0
pdf_insp_type RE-LICENSE INSPECTION
pdf_animals_total 21.0
web_certType Class C - Exhibitor
pdf_customer_id 327034.0
pdf_customer_name PWEC Enterprises Inc.
pdf_customer_addr 2 Wildhorse Lane Rolling Hills Estate, CA 90274
customer_state CA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23528530-aphis-inspection-ins-0000804455
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);
Built by Noomatic and Geoff · Powered by Datasette · Queries took 5419.258ms