aphis: facilities: 7 rows where license_type = "Class T - Carrier" and site_state = "New Jersey" 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

7 rows where license_type = "Class T - Carrier" and site_state = "New Jersey" 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
22-T-0051	6003101	ADORABLE PUPPIES LLC	ADORABLE PUPPIES LLC	CARTERET	New Jersey	07008	Class T - Carrier	2021-12-02
22-T-0107	601802	Anthony Vallaro	Anthony Vallaro	Jackson	New Jersey	08527	Class T - Carrier	2023-08-23
22-T-0106	6015373	Candice Gonzalez	Candice Gonzalez	Jackson	New Jersey	08527	Class T - Carrier	2023-08-23
22-T-0023	333557	It's A Ruff Life Rescue	It's A Ruff Life Rescue	Trenton	New Jersey	08690	Class T - Carrier	2020-02-28
93-T-0036	40509	JET AIRWAYS	JET AIRWAYS	NEWARK	New Jersey	07114	Class T - Carrier	2015-10-02
22-T-0013	323792	JUST PUPS CORP	JUST PUPS CORP	EMERSON	New Jersey	07630	Class T - Carrier	2016-05-19
22-T-0120	6016553	Onur Mumcu	Onur Mumcu	Fort Lee	New Jersey	07024	Class T - Carrier	2024-01-29

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