inspections
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
2 rows where cert_number = "35-R-0142" sorted by inspection_date descending
This data as json, CSV (advanced)
inspection_type 0
| id | cert_number | inspection_date ▲ | inspection_type | critical_count | noncritical_count | direct_count | teachable_moment_count | pdf_url | pdf_local_path | cert_verification | pdf_sha256 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 02b87c6f9edb032a | Carroll University 35-R-0142 | 2024-06-18 | 0 | 0 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000EDBk2&d=%2Fa%2F3d0000036Fka%2Fa.efvHCjFDHzwX0fJf.p63DXUuhqmZQrk9p3c5mxAaI&asPdf=false | pdfs/35-R-0142_2024-06-18_02b87c6f9edb032a.pdf | match | 332b17ea9c2697784d098c2a6d0f84a1551bdcdd2935644fbafb0b5d8e615e42 | |
| ad32416117b8f68a | Carroll University 35-R-0142 | 2023-09-12 | 0 | 0 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d000009yvrN&d=%2Fa%2F3d000001q2JU%2F3nOjauXLw6mM4PNoUG7hJvgFsF3d3j5qgdJk5Y_8Dtk&asPdf=false | pdfs/35-R-0142_2023-09-12_ad32416117b8f68a.pdf | match | a1760f69230c781248f62ad3b41ebc8babecc5fdc122f781eb50a3784add565f |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE inspections (
id TEXT PRIMARY KEY,
cert_number TEXT REFERENCES facilities(cert_number),
inspection_date TEXT,
inspection_type TEXT,
critical_count INTEGER,
noncritical_count INTEGER,
direct_count INTEGER,
teachable_moment_count INTEGER,
pdf_url TEXT,
pdf_local_path TEXT
, cert_verification TEXT, pdf_sha256 TEXT);
CREATE INDEX idx_inspections_date ON inspections(inspection_date);
CREATE INDEX idx_inspections_cert ON inspections(cert_number);