Semantic search

citations

1 row where hash_id = "50a7d5fead3e63d8"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
22459 50a7d5fead3e63d8 3.1(c)(3)   0 HOUSING FACILITIES, GENERAL. Cleaning. * There is an accumulation of grime, dirt, dust and cobwebs on the doors and walls of the enclosures and feeders in the general building housing 19 dogs. These areas of organic matter can harbor disease organisms and cause illness in the dogs. Licensee must ensure that all surfaces of the housing facility are cleaned, sanitized and maintained to satisfy general husbandry standards and for the overall health of the dogs. * To be corrected by: 9/1/15 Inspection and exit interview conducted with facility representative and MDA personnel.

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
);