inspections
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
2 rows where cert_number = "84-R-0090" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 6f4651c8318d259f | MISSION READINESS TRAINING SOLUTIONS 84-R-0090 | 2018-10-17 | 0 | 1 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgbBA&d=%2Fa%2F3d000000pdY4%2F84Mu0_0jLp8a.zwp3srj4SdS7GktygQrz_3okQQUoGQ&asPdf=false | pdfs/84-R-0090_2018-10-17_6f4651c8318d259f.pdf | match | f936da491d6686ae998e8c3a34010a1b16e24de9f5d38000b8246c49182812db | |
| 1162c32f3567c573 | MISSION READINESS TRAINING SOLUTIONS 84-R-0090 | 2018-03-29 | 0 | 0 | 0 | 0 | https://aphis.file.force.com/sfc/dist/version/download/?oid=00Dt0000000GyZH&ids=068t000000EgmHu&d=%2Fa%2F3d000000pT48%2FwjXaYPcVoAH3sKl9abT6v1A_tH0TnUFWS3PoRpjIad0&asPdf=false | pdfs/84-R-0090_2018-03-29_1162c32f3567c573.pdf | match | 27aa601613ccebc1cf085d2f3930014b5d395025c17e2fb2b27d31f52b15a8b0 |
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);