Semantic search

citations

1 row where hash_id = "8d83f57a191e0d5a"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
26207 8d83f57a191e0d5a 2.75(b)(1)   0 RECORDS: DEALERS AND EXHIBITORS. Since the previous inspection on March 8, 2016, records of animal births and deaths were not maintained for the guinea pigs. Records must be kept on animal births and deaths for animal tracking, assessment of the animal care program, and to comply with the Animal Welfare regulations. The licensee must ensure that records on animal births and deaths are kept and maintained. Correct from this day forward. This inspection and exit interview were conducted with the owner.

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