Semantic search

citations

1 row where hash_id = "36c078d15856753c"

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ hash_id code kind repeat desc narrative
18252 36c078d15856753c 2.126(b)   0 ACCESS AND INSPECTION OF RECORDS AND PROPERTY; SUBMISSION OF ITINERARIES. Section 2.126(b) A responsible adult was not available to accompany APHIS Officials during the inspection process at 7:30pm on 8/20/2014 & 9:30am-10:15am on 08/21/2014. Inspectors made attempts to inspect the facility on both 8/20/14 and 8/21/2014. During each attempt inspectors knocked on both the residence door and the facility door as well as calling the licensee's phone and leaving multiple voice mails. At 7:30pm on 8/20/2014 the inspector called the attending veterinarian who confirmed that emergency treatment had been provided to the adult cat named "Junior" ID #31. Additional Inspectors Campitelli D.V.M Kathryn, Veterinary Medical Officer

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