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

8 rows where license_type = "Class T - Carrier" and site_state = "Connecticut" sorted by legal_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: site_city, last_seen_date, last_seen_date (date)

site_state 1

  • Connecticut · 8 ✖

license_type 1

  • Class T - Carrier · 8 ✖

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
16-T-0008 500827 ANIMAL KINGDOM PREMIER PET RELOCATION SERVICES LLC   ALEK NEDOSHYTKO   CHESHIRE Connecticut 06410 Class T - Carrier     2018-04-04
16-T-0007 335226 ELAINE JONES   ELAINE JONES   MIDDLETOWN Connecticut 06457 Class T - Carrier     2019-02-25
21-T-0058 412 FISHERS ISLAND FERRY DISTRICT   FISHERS ISLAND FERRY DISTRICT   NEW LONDON Connecticut 06320 Class T - Carrier     2019-03-27
16-T-0012 508151 Joseph Clough   HOME STRETCH TRAVEL SERVICES LLC   EAST HARTFORD Connecticut 06118 Class T - Carrier     2025-12-16
16-T-0010 506484 Open Road Hauling LLC   Open Road Hauling LLC   Newton Connecticut 06470 Class T - Carrier     2020-03-06
16-T-0014 508192 PAVLO KHURTENKO   PAVLO KHURTENKO   STAMFORD Connecticut 06905 Class T - Carrier     2021-01-22
16-T-0016 600128 Take Me Home Transports LLC   TAKE ME HOME TRANSPORTS LLC   Stafford Springs Connecticut 06076 Class T - Carrier     2021-01-08
16-T-0013 506018 YULIYA ZAUHOLNOVA   YULIYA ZAUHOLNOVA   STAMFORD Connecticut 06907 Class T - Carrier     2021-01-22

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