Semantic search

citations

2 rows where hash_id = "48d1c2305afecc7f"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
7018 48d1c2305afecc7f 3.6(a)(1)   0 PRIMARY ENCLOSURES. The Dalmatian Pen: The entrance floor of the shelter has torn carpet. The dog has been chewing and shredding the rug. Primary enclosures for dogs have to be designed and constructed of suitable materials so that they are structurally sound and will not potentially create a health hazard. The enclosure shall be kept in good repair. A program of monitoring and repairing primary enclosures needs to be created. ************** To be corrected by: September 15, 2014
7019 48d1c2305afecc7f 3.11(c)   0 CLEANING, SANITIZATION, HOUSEKEEPING, AND PEST CONTROL. Kitchen area: Refrigerator has an accumulation of grime and food debris under the lower food bins. Premises where housing facilities are located, including buildings and surrounding grounds, must be kept clean to facilitate the husbandry practices required in this subpart. A system is needed to ensure that adequate, routine cleaning is being done. ************ To be corrected by 8/28/2014 Exit interview conducted with facility representative.

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "citations" (
   [rowid] INTEGER PRIMARY KEY,
   [hash_id] TEXT REFERENCES [inspections]([hash_id]),
   [code] TEXT,
   [kind] TEXT,
   [repeat] INTEGER,
   [desc] TEXT,
   [narrative] TEXT
);