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

10 rows where license_type = "Class T - Carrier" and site_state = "Alabama" sorted by legal_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: site_city, last_seen_date (date)

site_state 1

  • Alabama · 10 ✖

license_type 1

  • Class T - Carrier · 10 ✖

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
64-T-0038 601044 Connie Bland   Connie Bland   Quinton Alabama 35130 Class T - Carrier     2022-06-23
64-T-0018 505104 DEBORAH ROBERTS TOMMY ROBERTS   DEBORAH ROBERTS   WAGARVILLE Alabama 36585 Class T - Carrier     2019-07-03
32-T-0009 605 ENVIGO R M S INC   ENVIGO R M S INC   PRATTVILLE Alabama 36067 Class T - Carrier     2018-11-27
41-T-0008 330366 Endeavor Air Inc   ENDEAVOR AIR INC   HUNTSVILLE Alabama 35824 Class T - Carrier     2025-11-19
64-T-0006 330556 MICHAEL BEATTY   MICHAEL BEATTY   SARALAND Alabama 36571 Class T - Carrier     2014-02-12
55-T-0154 505533 PATRICIA GUY FELICIA WILSON   EXOTIC ANGELS   PELHAM Alabama 35124 Class T - Carrier     2019-03-15
64-T-0026 507159 Roadside Plus LLC   ROADSIDE PLUS LLC   HUNTSVILLE Alabama 35804 Class T - Carrier     2021-03-08
64-T-0062 6002873 Robert Waterwall   Robert Waterwall   Huntsville Alabama 35811 Class T - Carrier     2023-09-20
64-T-0020 505268 SHELLEY MOODY   SHELLEY MOODY   BANKSTON Alabama 35542 Class T - Carrier     2019-08-21
64-T-0189 6020194 Tammy Gardner   Tammy Gardner   Mobile Alabama 36619 Class T - Carrier     2025-04-23

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);