Semantic search

citations

1 row where hash_id = "2e1bc86266cb54d8"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
25667 2e1bc86266cb54d8 2.8(h)   0 NOTIFICATION OF CHANGE OF NAME, ADDRESS, CONTROL, OR OWNERSHIP OF BUSINESS. I went to the theater in Branson, MO to conduct an inspection at the location where the exhibitor had last been performing. Staff there stated that the exhibitor is no longer performing at that location and that no regulated species of animals were present. A change of business address has not been submitted to the Regional Office. Licensees are required to notify the Regional Office within 10 days of a change in their business address so that inspectors know where to conduct inspections. The licensee must notify the Regional Office by certified mail of his change in business address. TO BE CORRECTED BY FEBRUARY 20, 2015.

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