home / aphis_reports

Semantic search

citation_inspection

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

3 rows where hash_id = "073363c14d964479"

✎ 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 facility does not employ a full-time veterinarian and there was no written program of veterinary care available at the time of inspection. A written program of veterinary care is required for facilities which do not employ a full-time veterinarian. That program of veterinary care must be made available for review during inspections to ensure adequate veterinary care is being provided. The licensee must follow a written program of veterinary care as directed by the attending veterinarian and make it available during inspections. To be corrected by:8/5/14

rowid 19140
desc ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS).
web_siteName Pets Plus
kind  
Incident hash_id 073363c14d964479
web_inspectionDate 2014-07-22
code 2.40(a)(1)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 55.0
web_certType Class B - Dealer
pdf_customer_id 31750.0
pdf_customer_name Pets Plus
pdf_customer_addr 6419 University Lubbock, TX 79413
customer_state TX
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23511193-aphis-inspection-203142146350071
lat  
lng  

**** No Record of Animals on Hand (APHIS Form 7019) or Record of Acquisition, Disposition, or Transport (APHIS Form 7020) were available at the time of inspection. Records with appropriate information of the covered species must be maintained at all times in order to properly identify and trace the origin/destination of the animal. A record keeping system must be established and kept up to date. APHIS Form 7019 and 7020 were provided to owner. Affects all covered species.

rowid 19141
desc RECORDS: DEALERS AND EXHIBITORS.
web_siteName Pets Plus
kind  
Incident hash_id 073363c14d964479
web_inspectionDate 2014-07-22
code 2.75(b)(1)
repeat 1
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 55.0
web_certType Class B - Dealer
pdf_customer_id 31750.0
pdf_customer_name Pets Plus
pdf_customer_addr 6419 University Lubbock, TX 79413
customer_state TX
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23511193-aphis-inspection-203142146350071
lat  
lng  

**** There was not an environmental enhancement plan (EEP) on hand to adequately address the psychological well-being of the nonhuman primates. The EEP must be reviewed and approved by the attending veterinarian. There are many sources that can assist in developing a plan for nonhuman primate enrichment. (cid:28)The Psychological Well-Being of Nonhuman Primates(cid:29) published by the National Research Council is one source. There is no plan denoting the enrichment and no log book or calendar showing that enrichment takes place. The animals do have different items in their enclosures, but there is no schedule of rotating or changing the items in the pens. The enrichment must be documented on the environmental enhancement plan, and the plan must be followed. To be corrected by:8/5/14 Additional Inspectors Cunningham Debbie, Veterinary Medical Officer

rowid 19142
desc ENVIRONMENT ENHANCEMENT TO PROMOTE PSYCHOLOGICAL WELL-BEING.
web_siteName Pets Plus
kind  
Incident hash_id 073363c14d964479
web_inspectionDate 2014-07-22
code 3.81
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 55.0
web_certType Class B - Dealer
pdf_customer_id 31750.0
pdf_customer_name Pets Plus
pdf_customer_addr 6419 University Lubbock, TX 79413
customer_state TX
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23511193-aphis-inspection-203142146350071
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 7023.241ms