facilities

USDA APHIS-licensed animal welfare facilities including breeders, dealers, exhibitors, and research labs. 15,000+ facilities across all 50 states.

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

7 rows where license_type = "Class T - Carrier" and site_state = "Oregon" sorted by legal_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: customer_number, legal_name, site_name, site_city, site_zip, last_seen_date (date)

site_state 1

  • Oregon · 7 ✖

license_type 1

  • Class T - Carrier · 7 ✖

status 0

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
92-T-0040 6003051 JENNIFER BARNES   JENNIFER BARNES   BLY Oregon 97622 Class T - Carrier     2023-05-25
92-T-0018 505229 Jonathon Williams   JONATHON WILLIAMS   Keizer Oregon 97303 Class T - Carrier     2022-06-02
92-T-0021 505797 NANCY RUSSELL   NANCY RUSSELL   MEDFORD Oregon 97504 Class T - Carrier     2019-04-02
92-T-0075 6013234 Rose A Vivier   Rose A Vivier   Vernonia Oregon 97064 Class T - Carrier     2023-11-30
92-T-0014 333591 Stuart Allen   Stuart Allen   TERREBONNE Oregon 97760 Class T - Carrier     2016-06-14
92-T-0067 505525 Willamette Valley Rabbitry   Willamette Valley Rabbitry   Dallas Oregon 97338 Class T - Carrier     2023-11-28
92-T-0020 505525 Willamette Valley Rabbitry   Willamette Valley Rabbitry   Dallas Oregon 97338 Class T - Carrier     2022-03-29

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE facilities (
    cert_number TEXT PRIMARY KEY,
    customer_number TEXT,
    legal_name TEXT,
    dba_name TEXT,
    site_name TEXT,
    site_address TEXT,
    site_city TEXT,
    site_state TEXT,
    site_zip TEXT,
    license_type TEXT,
    status TEXT,
    first_seen_date TEXT,
    last_seen_date TEXT
);
CREATE INDEX idx_facilities_state ON facilities(site_state);
CREATE INDEX idx_facilities_type ON facilities(license_type);
CREATE INDEX idx_facilities_name ON facilities(legal_name);