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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: last_seen_date, last_seen_date (date)

site_state 1

  • Mississippi · 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
65-T-0015 503428 CHRISTOPHER BATES   CHRISTOPHER BATES   GULFPORT Mississippi 39503 Class T - Carrier     2021-01-14
65-T-0009 501776 JACK LANGFORD   JACK LANGFORD   MYRTLE Mississippi 38650 Class T - Carrier     2019-02-25
65-T-0019 600990 Jim Mull   Jim Mull   Pontotoc Mississippi 38863 Class T - Carrier     2021-01-25
65-T-0004 335808 KIRK SHUMPERT   KIRK SHUMPERT   TUPELO Mississippi 38801 Class T - Carrier     2020-03-20
65-T-0013 505335 Lead Me Home Animal Rescue and Transport   Lead Me Home Animal Rescue and Transport   CORINTH Mississippi 38834 Class T - Carrier     2021-01-15
65-T-0012 504992 RANDY KING   RANDY L KING   WATER VALLEY Mississippi 38965 Class T - Carrier     2020-03-05
65-T-0006 501713 RED ROCKET PET TRANSPORT INC   JOHN MARK FRANKLIN   MORTON Mississippi 39117 Class T - Carrier     2017-09-26
65-T-0022 602222 Scarlett Benedict   Scarlett Benedict   Moss Point Mississippi 39562 Class T - Carrier     2021-01-26
65-T-0003 331673 TINA BURROUGHS   TINA BURROUGHS   MERIDIAN Mississippi 39301 Class T - Carrier     2021-01-15
65-T-0014 508025 The Homeward Bound Project of MS   MS UNIVERSITY COLLEGE OF VETERINARY MEDICINE   MISS STATE Mississippi 39762 Class T - Carrier     2021-01-19

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