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

9 rows where license_type = "Class H - Intermediate Handler" and site_state = "Connecticut" sorted by legal_name

✎ View and edit SQL

This data as json, CSV (advanced)

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

site_state 1

  • Connecticut · 9 ✖

license_type 1

  • Class H - Intermediate Handler · 9 ✖

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-H-0007 699 BEST FRIENDS PET CARE INC   BEST FRIENDS NORWALK   NORWALK Connecticut 06851 Class H - Intermediate Handler     2016-12-07
16-H-0008 14 COSMOPOLITAN CANINE CARRIERS INC   COSMOPOLITAIN CANINE CARRIERS INC   STRATFORD Connecticut 06614 Class H - Intermediate Handler     2022-07-19
16-H-0016 327738 DAY HILL KENNELS LLC   DAY HILL KENNELS L L C   WINDSOR Connecticut 06095 Class H - Intermediate Handler     2022-12-12
16-H-0001 62 EDGEWOOD EAST L L C   CANDLEWICK KENNELS   GLASTONBURY Connecticut 06033 Class H - Intermediate Handler     2017-02-16
16-H-0011 65 JET A PET INC   TOWN HOUSE FOR DOGS & CATS   WESTPORT Connecticut 06880 Class H - Intermediate Handler     2017-11-01
16-H-0017 332664 MARIA SACCO   MARIA SACCO   BETHLEHEM Connecticut 06751 Class H - Intermediate Handler     2020-01-30
16-H-0018 333917 PREMIER EXPRESS   Premiere Express   WINDSOR Connecticut 06095 Class H - Intermediate Handler     2018-04-25
74-H-0181 6013480 Total Airport Services   Total Airport Services   Granby Connecticut 06026 Class H - Intermediate Handler     2022-12-12
16-H-0015 12805 WorldCare Pet Transport LLC   WorldCare Pet Transport LLC   Darien Connecticut 06820 Class H - Intermediate Handler     2016-12-07

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