aphis: facilities: 4 rows where license_type = "Class H - Intermediate Handler" and site_state = "Georgia" sorted by legal

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

4 rows where license_type = "Class H - Intermediate Handler" and site_state = "Georgia" sorted by legal_name

descending

✎ View and edit SQL

This data as json, CSV (advanced)

cert_number	customer_number	legal_name ▼	site_name	site_city	site_state	site_zip	license_type	last_seen_date
57-H-0112	1006	Camp Paradise Pet Resort	Camp Paradise Pet Resort	Conyers	Georgia	30094	Class H - Intermediate Handler	2020-03-12
67-H-0024	504723	Feathers and Fur Express LLC	Feathers and Fur Express LLC	CONLEY	Georgia	30288	Class H - Intermediate Handler	2022-12-07
57-H-0138	505230	PAWS ON A PLANE	PAWS ON A PLANE	ATLANTA	Georgia	30312	Class H - Intermediate Handler	2019-09-19
67-H-0023	502305	Pets Connect Kennels LLC	Pets Connect Kennels LLC	East Point	Georgia	30344	Class H - Intermediate Handler	2024-05-02

Advanced export

JSON shape: default, array, newline-delimited, object

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