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 = "Wisconsin" sorted by legal_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: last_seen_date (date)

site_state 1

  • Wisconsin · 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
31-T-0005 1780 AIRNET SYSTEMS INC   AIRNET   MILWAUKEE Wisconsin 35207 Class T - Carrier     2015-09-15
35-T-0013 330478 BORN READY BULLIES   BORN READY BULLIES   BELOIT Wisconsin 53511 Class T - Carrier     2014-12-16
35-T-0022 508188 Big Sky Pet Transport LLC   BIG SKY PET TRANSPORT LLC   DE PERE Wisconsin 54115 Class T - Carrier     2021-05-25
35-T-0020 507757 CHERYL HERNANDEZ   CHERYL A HERNANDEZ   WHITEWATER Wisconsin 53190 Class T - Carrier     2020-03-06
35-T-0019 507460 JANET BUSZKIEWICZ   JANET BUSZKIEWICZ   GERMANTOWN Wisconsin 53022 Class T - Carrier     2020-01-30
35-T-0015 503719 KAYLA LARSEN   KAYLA LARSEN   KENOSHA Wisconsin 53140 Class T - Carrier     2020-02-04
35-T-0017 504932 PATRICK COCHERL   PATRICK A COCHERL   EAU CLAIRE Wisconsin 54703 Class T - Carrier     2020-03-05
35-T-0016 504250 TIFFANY DOHERTY   TIFFANY DOHERTY   SHEBOYGAN Wisconsin 53081 Class T - Carrier     2020-03-09
35-T-0014 501391 TIMOTHY KREUTZ   TIMOTHY KREUTZ   PLYMOUTH Wisconsin 53073 Class T - Carrier     2017-12-07
35-T-0024 600303 Thomas Matthews   Thomas Matthews   MONDOVI Wisconsin 54755 Class T - Carrier     2021-02-18

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