home / aphis_reports

Semantic search

citation_inspection

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

2 rows where hash_id = "1f05dfe3fad60e8d"

✎ 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

Sec. 3.1 Housing facilities, general. At time of inspection one outside dog house housing two dogs had a hole in the top of the roof. This means the house is not in good repair. The licensee must ensure that all surfaces are kept in good repair and protect the animals from injury at all times. To be corrected by 10-10-16.

rowid 14918
desc HOUSING FACILITIES, GENERAL.
web_siteName MARILYN & JAMES ALEXANDER
kind  
Incident hash_id 1f05dfe3fad60e8d
web_inspectionDate 2016-09-21
code 3.1
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 51.0
web_certType Class A - Breeder
pdf_customer_id 14282.0
pdf_customer_name James Alexander
pdf_customer_addr Marilyn Alexander 3401 Sr Hwy 27 Dover, AR 72837
customer_state AR
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23501073-aphis-inspection-2016082567940759
lat  
lng  

Sec. 3.11 Cleaning, sanitization, housekeeping, and pest control. At time of inspection all fifteen outside dog houses housing twenty four adult dogs and feeding receptacles were dirty with dirt and grime. Cleaning and sanitization of surfaces that are in contact with dogs is necessary to prevent an accumulation of dirt, debris, food waste, excreta and other disease hazards. Unsanitary living conditions and potential transmission of diseases exists when surfaces are not cleaned and sanitized. The licensee must ensure that all surfaces are cleaned and sanitized at least once every two weeks or more often if needed. To be corrected by 10-10-16. This exit interview was conducted by Cathy Niebruegge, ACI and facility representative.

rowid 14919
desc CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL.
web_siteName MARILYN & JAMES ALEXANDER
kind  
Incident hash_id 1f05dfe3fad60e8d
web_inspectionDate 2016-09-21
code 3.11
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 51.0
web_certType Class A - Breeder
pdf_customer_id 14282.0
pdf_customer_name James Alexander
pdf_customer_addr Marilyn Alexander 3401 Sr Hwy 27 Dover, AR 72837
customer_state AR
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23501073-aphis-inspection-2016082567940759
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 3439.99ms