home / aphis_reports

Semantic search

citation_inspection

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

2 rows where hash_id = "a081d348d2926556"

✎ 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

There were no records of rabbits sold at time of this inspection. Records must be kept and maintained to help keep track of animals, to help assess the animal care program, and to document changes in ownership. Licensee must ensure that deposition records are kept and maintained for rabbits sold, died, or euthanized. Correct by July 10, 2021.

rowid 35545
desc Records: Dealers and exhibitors.
web_siteName GIDEON FISHER
kind  
Incident hash_id a081d348d2926556
web_inspectionDate 2021-07-07
code 2.75(b)(1)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 54.0
web_certType Class A - Breeder
pdf_customer_id 501739.0
pdf_customer_name GIDEON FISHER
pdf_customer_addr 89 POND RD RONKS, PA 17572
customer_state PA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23547409-aphis-inspection-2016090000650509
lat  
lng  

Housekeeping. There is a buildup of hair, feces, and old feed in the bottom four enclosures along the wall that are no longer in use. Animal facilities must be kept clean to ensure good quality of air for the animals and to prevent disease risks. Ineffective cleaning can expose the rabbits to disease hazards and health problems. Correct by ensuring premises are kept clean including empty enclosures to help support a level of general cleanliness and to support good animal husbandry. Correct by July 10, 2021. This inspection and exit interview were conducted with the facility representative. End Section

rowid 35546
desc Sanitation.
web_siteName GIDEON FISHER
kind  
Incident hash_id a081d348d2926556
web_inspectionDate 2021-07-07
code 3.56(c)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 54.0
web_certType Class A - Breeder
pdf_customer_id 501739.0
pdf_customer_name GIDEON FISHER
pdf_customer_addr 89 POND RD RONKS, PA 17572
customer_state PA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23547409-aphis-inspection-2016090000650509
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 2710.657ms