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 A - Breeder" and site_state = "New Mexico" sorted by legal_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: customer_number, legal_name, site_city, site_zip, last_seen_date (date)

site_state 1

  • New Mexico · 7 ✖

license_type 1

  • Class A - Breeder · 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
85-A-0071 329503 Jasmine Travis Meghan Bentz   Jasmine Travis, Meghan Bentz   ALBUQUERQUE New Mexico 87123 Class A - Breeder     2014-06-10
85-A-0073 331904 Jasmine Travis   Jasmine Travis   ALBUQUERQUE New Mexico 87123 Class A - Breeder     2017-01-11
85-A-0070 324284 Lillian I. Lehman   Lillian I. Lehman   ARTESIA New Mexico 88210 Class A - Breeder     2018-08-21
85-A-0076 334812 Rodeo Doxies   RODEO DOXIES   ANTHONY New Mexico 88021 Class A - Breeder     2019-10-31
85-A-0074 334812 Rodeo Doxies   Rodeo Doxies   ANTHONY New Mexico 88021 Class A - Breeder     2017-03-16
85-A-0072 330739 Sandra Frische   Sandra Frische   STANLEY New Mexico 87056 Class A - Breeder     2021-03-30
85-A-0077 6011337 Thomas Emard   Thomas Emard   La Plata New Mexico 87418 Class A - Breeder     2025-05-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);