aphis: facilities: 6 rows where license_type = "Class T - Carrier" and site_state = "New Mexico" 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 T - Carrier" and site_state = "New Mexico" 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
85-T-0009	332285	Daisy Road Trip L L C	Daisy Road Trip L L C	SANTA FE	New Mexico	87505	Class T - Carrier	2016-02-23
85-T-0008	330550	Enchantment Courier of N M, L L C	Enchantment Courier of NM, L L C	ALBUQUERQUE	New Mexico	87113	Class T - Carrier	2017-02-15
85-T-0010	503327	KRYSTAL KIJU JAMEEL WILLIAMS VICTOR TAYLOR	JAMEEL WILLIAMS, KRYSTAL KIJU, VICTOR TAYLOR	ANTHONY	New Mexico	88021	Class T - Carrier	2020-03-17
85-T-0051	6018599	Paws, Claws, Boats, and Totes LLC	Paws, Claws, Boats, and Totes LLC	Los Lunas	New Mexico	87031	Class T - Carrier	2023-09-12
85-T-0012	507845	THOMAS JOPLIN JANET JOPLIN	JANET & THOMAS JOPLIN	FARMINGTON	New Mexico	87401	Class T - Carrier	2021-01-21
84-T-0027	501693	VIOLET GONZALEZ	WAGGIN TRAIN TRANSPORTATION	LAS CRUCES	New Mexico	88001	Class T - Carrier	2018-02-08

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