annual_reports

Annual animal usage reports submitted by research facilities, broken down by species and USDA pain categories (C, D, E).

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

0 rows where cert_number = "42-A-0894" sorted by report_year descending

✎ View and edit SQL

This data as json

0 records

CREATE TABLE annual_reports (
    id TEXT PRIMARY KEY,
    cert_number TEXT REFERENCES facilities(cert_number),
    report_year INTEGER,
    species TEXT,
    total_animals INTEGER,
    animals_pain_cat_c INTEGER,
    animals_pain_cat_d INTEGER,
    animals_pain_cat_e INTEGER
);
CREATE INDEX idx_annual_cert_year ON annual_reports(cert_number, report_year);