aphis
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
Queries
- Search Facilities
- Inspection History for a Facility
- Facilities by State
- Recent Inspections
- Inspections with Critical Violations
- Facilities with Most Violations
- Facilities by License Type
- Inspection Trends by Year
Tables
annual_reports
id, cert_number, report_year, species, total_animals, animals_pain_cat_c, animals_pain_cat_d, animals_pain_cat_e
0 rows
enforcement_actions
id, cert_number, action_date, action_type, penalty_amount, description, outcome, pdf_url, pdf_local_path
0 rows
facilities
cert_number, customer_number, legal_name, dba_name, site_name, site_address, site_city, site_state, site_zip, license_type, status, first_seen_date, last_seen_date
Many rows
inspections
id, cert_number, inspection_date, inspection_type, critical_count, noncritical_count, direct_count, teachable_moment_count, pdf_url, pdf_local_path
110,400 rows
... and 5 hidden tables