inspections
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
2 rows where cert_number = "58-B-0723" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1dc2c4c324cfa35d | Double A Auction Inc 58-B-0723 | 2024-11-21 | 0 | 0 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068SJ00000Fb3fr&d=%2Fa%2FSJ000001Esw1%2FsB0wTHgkMyICx4q_bAmvKY.UwMEpo.ykI78x7nzyUM0&asPdf=false | pdfs/58-B-0723_2024-11-21_1dc2c4c324cfa35d.pdf | match | 2446eec73f52d3e8cccbf09e0588c8bd98316d6767d56b84259483d4803338e7 | |
| 2986544079408e25 | Double A Auction Inc 58-B-0723 | 2024-07-25 | 0 | 0 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=0683d00000EfgL5&d=%2Fa%2F3d000003E3xj%2FGokklGc9JuDq0s8jgwCSHU1VJmw_8idjmek6Gp03nks&asPdf=false | pdfs/58-B-0723_2024-07-25_2986544079408e25.pdf | no_cert_ok | 08f82e4044d198079de990ea4e480e4fdecb50f9ca896377791e7ceba5fcc0bd |
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);