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 B - Dealer" and site_state = "Connecticut" sorted by legal_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: site_zip, last_seen_date (date)

site_state 1

  • Connecticut · 8 ✖

license_type 1

  • Class B - Dealer · 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-B-0040 28025 All Pets Club Inc   All Pets Club Inc   Wallingford Connecticut 06492 Class B - Dealer     2026-01-06
16-B-0002 1937 FISH MART INC   FISH MART INC   WEST HAVEN Connecticut 06516 Class B - Dealer     2018-04-19
16-B-0042 322424 Lionshare Educational Organization   Lionshare Educational Organization   Stamford Connecticut 06903 Class B - Dealer     2025-09-12
16-B-0037 39179 Patricia Doubleday   PATRICIA DOUBLEDAY   DANIELSON Connecticut 06239 Class B - Dealer     2023-05-04
16-B-0036 9065 R PIERCE ONTHANK   R PIERCE ONTHANK   WILTON Connecticut 06897 Class B - Dealer     2014-09-29
16-B-0041 333337 SHARKEYS SUGAR BEARS LLC   SHARKEYS SUGAR BEARS LLC   SOUTHBURY Connecticut 06488 Class B - Dealer     2017-01-17
57-B-0146 35765 Sun Pet Ltd   Sun Pet Ltd   West Haven Connecticut 06516 Class B - Dealer     2025-05-28
16-B-0043 331348 Tamara Sevigny   TAMARA SEVIGNY   LYME Connecticut 06371 Class B - Dealer     2025-08-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);