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

7 rows where license_type = "Class H - Intermediate Handler" and site_state = "Pennsylvania" sorted by legal_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: site_city, site_zip, last_seen_date (date)

site_state 1

  • Pennsylvania · 7 ✖

license_type 1

  • Class H - Intermediate Handler · 7 ✖

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
23-H-0030 326513 Frames Animal Transport Inc   FRAMES KENNELS   RIDLEY PARK Pennsylvania 19078 Class H - Intermediate Handler     2020-03-02
74-H-0071 35830 G2 Secure Staff LLC   G2 SECURE STAFF LLC   PHILADELPHIA Pennsylvania 19153 Class H - Intermediate Handler     2025-04-22
23-H-0036 40556 HENRY SWAREY   HENRY SWAREY   MIFFLINTOWN Pennsylvania 17059 Class H - Intermediate Handler     2018-07-16
23-H-0046 603804 Jane Godfry & Jennifer Myers   Professional Pet Transport, LLC   Chester Springs Pennsylvania 19425 Class H - Intermediate Handler     2024-03-26
23-H-0056 506597 NATIONAL GREYHOUND ADOPTION PROGRAM   Gateway Animal Care   PHILADELPHIA Pennsylvania 19154 Class H - Intermediate Handler     2024-07-02
23-H-0028 17976 TRIPLE F FARMS INC   TRIPLE F FARMS INC   GILLETT Pennsylvania 16925 Class H - Intermediate Handler     2019-11-19
23-H-0047 6003116 Triple F Farms LLC   Triple F Farms LLC   Gillett Pennsylvania 16925 Class H - Intermediate Handler     2025-07-30

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