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

11 rows where license_type = "Class T - Carrier" and site_state = "Iowa" sorted by legal_name

✎ View and edit SQL

This data as json, CSV (advanced)

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

site_state 1

  • Iowa · 11 ✖

license_type 1

  • Class T - Carrier · 11 ✖

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
42-T-0014 332579 Charles Katich   Charles Katich   DES MOINES Iowa 50320 Class T - Carrier     2015-02-18
42-T-0015 321436 Debra Pratt   Debra Pratt   TOLEDO Iowa 52342 Class T - Carrier     2024-04-12
42-T-0099 6022861 Hakuna Matata Transport LLC   Hakuna Matata Transport LLC   Toledo Iowa 52342 Class T - Carrier     2024-07-19
42-T-0007 7986 Helen Ketelsen Scott Ketelsen   HELEN KETELSEN & SCOTT KETELSEN   HULL Iowa 51239 Class T - Carrier     2019-09-17
42-T-0012 330389 Jaclyn Schelling   Jaclyn Schelling   ALTON Iowa 51003 Class T - Carrier     2016-10-14
42-T-0009 323865 Jan Budden   Jan Budden   MAURICE Iowa 51036 Class T - Carrier     2020-03-26
42-T-0017 42440 MARGARET CMELIK   MARGARET CMELIK   MARENGO Iowa 52301 Class T - Carrier     2019-05-08
42-T-0028 508428 SHERRY EASTBURN   Sherry Eastburn   MONTICELLO Iowa 52310 Class T - Carrier     2020-12-09
42-T-0068 504301 Subject Enterprise, Inc.   Subject Enterprise, Inc.   Britt Iowa 50423 Class T - Carrier     2025-01-16
42-T-0018 504301 Subject Enterprise, Inc.   SUBJECT ENTERPRISE INC   WESLEY Iowa 50483 Class T - Carrier     2018-12-18
42-T-0013 331202 Traveling Treasures Animal Transport L L C   Traveling Treasures Animal Transport, L L C   DES MOINES Iowa 50313 Class T - Carrier     2015-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);