Semantic search

citation_inspection

Table actions

2 rows where hash_id = "d46f1fae8e8db2b1"

✎ 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

***During the inspection, the licensee stated to the Veterinary Medical Officer that she had recently, within a couple days, preventatively dewormed the kittens (6 animals) using Nemex-2. The licensee could not supply any prescriptions or directions on medication usage from the AV nor was the usage detailed in the program of veterinary care. Injuries and diseases that are not treated properly (as directed by a veterinarian or detailed in the program of veterinary care) may be painful and can lead to prolonged suffering, infection, and other veterinary care problems. The licensee must use appropriate methods to prevent, control, diagnose, and treat diseases and injuries. All medications used by the licensee in regulated animals, must have detailed directions regarding their usage, from a veterinarian. To be corrected by 10/14/15.

rowid 31134
desc ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS).
web_siteName BARBARA MILSOM
kind  
Incident hash_id d46f1fae8e8db2b1
web_inspectionDate 2015-10-06
code 2.40(b)(2)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 14.0
web_certType Class A - Breeder
pdf_customer_id 330790.0
pdf_customer_name Barbara J Milsom
pdf_customer_addr 10595 N. Salmonson Rd Maricopa, AZ 85239
customer_state AZ
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23535185-aphis-inspection-279151828070568
lat  
lng  

***At the time of inspection, none of the animals (13 cats) had any form of identification. Official identification is needed to ensure that each animal(cid:25)s' identity can be known with certainty and to facilitate the inspection process. The licensee must ensure that all regulated animals are officially identified by an approved method as described under the Animal Welfare Act. To be corrected by 10/14/15. Inspection was conducted with the owner on 10/6/15. Exit briefing was conducted with the owner on 10/7/15.

rowid 31135
desc TIME AND METHOD OF IDENTIFICATION.
web_siteName BARBARA MILSOM
kind  
Incident hash_id d46f1fae8e8db2b1
web_inspectionDate 2015-10-06
code 2.50(a)(1)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 14.0
web_certType Class A - Breeder
pdf_customer_id 330790.0
pdf_customer_name Barbara J Milsom
pdf_customer_addr 10595 N. Salmonson Rd Maricopa, AZ 85239
customer_state AZ
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23535185-aphis-inspection-279151828070568
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);