aphis: facilities: 6 rows where license_type = "Class H - Intermediate Handler" and site_state = "Michigan" 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

6 rows where license_type = "Class H - Intermediate Handler" and site_state = "Michigan" 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
34-H-0004	1743	BELLE CREEK KENNELS	BELLE CREEK KENNELS	LIVONIA	Michigan	48154	Class H - Intermediate Handler	2021-05-06
34-H-0006	9000	BRITT'S BOW WOW BED N BISCUIT INC	BRITT'S BOW WOW BED N BISCUIT	ROMULUS	Michigan	48174	Class H - Intermediate Handler	2016-12-06
34-H-0026	6010380	Central States Trucking	Central States Trucking	Romulus	Michigan	48174	Class H - Intermediate Handler	2023-06-28
34-H-0021	501543	KYLE JASON MAXIM	KYLE MAXIM	GRANDVILLE	Michigan	49418	Class H - Intermediate Handler	2018-07-12
34-H-0019	335843	PET TAXI PLUS LLC	PET TAXI PLUS LLC	CLINTON TOWNSHIP	Michigan	48038	Class H - Intermediate Handler	2017-02-21
34-H-0028	6010378	Pronto Freight Ways Inc.	Pronto Freight Ways Inc.	Taylor	Michigan	48180	Class H - Intermediate Handler	2022-07-12

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