Semantic search
citation_inspection
2 rows where hash_id = "82a82d4a52bcb2b0"
This data as json, CSV (advanced)
Suggested facets: web_inspectionDate (date)
**** A prairie dog located in the back of the museum had approximately 30 to 40% hair loss on its left side and flank area at the time of inspection. The skin did not appear to be red or irritated. The licensee stated the animal had been evaluated by a veterinarian in February of this year but there was no supporting medical documentation. The licensee stated that the hair loss has worsened since the evaluation by the veterinarian. Hair loss can be an indication of bacterial, fungal, or parasitic infections as well as a psychological stress. This prairie dog must be examined by a licensed veterinarian to ensure that an accurate diagnosis is obtained and an appropriate treatment plan is developed and followed. The licensee must document this information and make it available to the inspector upon request. **** To be corrected by 8/5/2014.
| rowid | 9579 |
| desc | ATTENDING VETERINARIAN AND ADEQUATE VETERINARY CARE (DEALERS AND EXHIBITORS). |
| web_siteName | SCIENCE SPECTRUM |
| kind | |
| Incident hash_id | 82a82d4a52bcb2b0 |
| web_inspectionDate | 2014-07-22 |
| code | 2.40(b)(2) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 5.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 5323.0 |
| pdf_customer_name | Science Spectrum |
| pdf_customer_addr | 2579 South Loop 289 #250 Lubbock, TX 79423 |
| customer_state | TX |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23491464-aphis-inspection-203141941320515 |
| lat | |
| lng |
**** On the bottom edge of the keeper's door of a prairie dog enclosure, were numerous scattered insect excrement as well as a live roach-like insect on the inside edge of the keeper's door. Lack of an effective pest control program can create unsanitary conditions and lead to the potential spread of disease. No bait, bait traps or other means to control or eliminate the insects were viewed during the inspection. The licensee must establish an effective program of pest control and ensure the excrement is removed and the area is properly cleaned and sanitized for the health and well being of the prairie dogs. **** To be corrected by 8/5/2014. Additional Inspectors Cunningham Debbie, Veterinary Medical Officer
| rowid | 9580 |
| desc | SANITATION. |
| web_siteName | SCIENCE SPECTRUM |
| kind | |
| Incident hash_id | 82a82d4a52bcb2b0 |
| web_inspectionDate | 2014-07-22 |
| code | 3.31(d) |
| repeat | 0 |
| pdf_insp_type | ROUTINE INSPECTION |
| pdf_animals_total | 5.0 |
| web_certType | Class C - Exhibitor |
| pdf_customer_id | 5323.0 |
| pdf_customer_name | Science Spectrum |
| pdf_customer_addr | 2579 South Loop 289 #250 Lubbock, TX 79423 |
| customer_state | TX |
| pdf_site_id | 001 |
| doccloud_url | https://www.documentcloud.org/documents/23491464-aphis-inspection-203141941320515 |
| lat | |
| lng |
Advanced export
JSON shape: default, array, newline-delimited, object
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);