Semantic search

citation_inspection

Table actions

3 rows where hash_id = "85d41b8e6ca65514"

✎ 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 large pens used during the day to display the puppies for sale are on concrete under a shelter roof. These pens are not exposed to direct sunlight and the concrete flooring is not impervious to moisture. Surfaces that are not sealed cannot be adequately sanitized which may permit the growth of bacteria and may allow the spread of disease. All hard surfaces that the puppies may come in contact with that are not exposed to direct sunlight shall be made impervious to moisture. Correct by July 21, 2015.

rowid 26936
desc SHELTERED HOUSING FACILITIES.
web_siteName LEM MINISH
kind  
Incident hash_id 85d41b8e6ca65514
web_inspectionDate 2015-06-30
code 3.3(e)(1)(2)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 155.0
web_certType Class B - Dealer
pdf_customer_id 325520.0
pdf_customer_name Lem Minish
pdf_customer_addr 146 Ridgeway Court Maysville, GA 30558
customer_state GA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23526413-aphis-inspection-182151057380062
lat  
lng  

On the outdoor enclosure constructed for the lemur, there are sharp points remaining where the wire fence material was cut and joined to cover the top of the enclosure. These points are accessible to the lemur and may cause puncture wounds or other injury upon contact. All sharp points (wire, nails, etc) shall be removed or covered to protect the lemur from injury. Correct by July 7, 2015.

rowid 26937
desc PRIMARY ENCLOSURES.
web_siteName LEM MINISH
kind  
Incident hash_id 85d41b8e6ca65514
web_inspectionDate 2015-06-30
code 3.80(a)(2)(1)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 155.0
web_certType Class B - Dealer
pdf_customer_id 325520.0
pdf_customer_name Lem Minish
pdf_customer_addr 146 Ridgeway Court Maysville, GA 30558
customer_state GA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23526413-aphis-inspection-182151057380062
lat  
lng  

There is very little shade provided for the Patagonian Cavy ("Roo"). The structure constructed to provide shade for "Roo) is very narrow and provides limited shade. There are no naturally shaded areas in this enclosure. Shade is required to protect the animals from overheating and discomfort. Additional shade shall be provided. Correct by July 7, 2015. Inspection and exit briefing conducted with the owner.

rowid 26938
desc FACILITIES, OUTDOOR.
web_siteName LEM MINISH
kind  
Incident hash_id 85d41b8e6ca65514
web_inspectionDate 2015-06-30
code 3.127(a)
repeat 0
pdf_insp_type ROUTINE INSPECTION
pdf_animals_total 155.0
web_certType Class B - Dealer
pdf_customer_id 325520.0
pdf_customer_name Lem Minish
pdf_customer_addr 146 Ridgeway Court Maysville, GA 30558
customer_state GA
pdf_site_id 001
doccloud_url https://www.documentcloud.org/documents/23526413-aphis-inspection-182151057380062
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);