home / aphis

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

15 rows where license_type = "Class B - Dealer" 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_name, site_city, site_zip, last_seen_date (date)

site_state 1

  • New Mexico · 15 ✖

license_type 1

  • Class B - Dealer · 15 ✖

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-B-0083 329356 Brian Overstreet   Brian Overstreet   ROSWELL New Mexico 88201 Class B - Dealer     2014-09-02
85-B-0073 43026 Cinda Moe   Cinda Moe   ROSWELL New Mexico 88201 Class B - Dealer     2023-05-10
85-B-0085 328735 F & C Marekting Corp   F & C Marekting Corp   ALBUQUERQUE New Mexico 87109 Class B - Dealer     2015-06-11
85-B-0093 28331 Frances Reed Higgins   FRANCES REED HIGGINS   SILVER CITY New Mexico 88061 Class B - Dealer     2023-04-12
85-B-0088 28331 Frances Reed Higgins   Frances Reed Higgins   SILVER CITY New Mexico 88061 Class B - Dealer     2016-04-18
85-B-0095 1072 Lovelace Biomedical Research Institute   Lovelace Biomedical Research Institute   Albuquerque New Mexico 87115 Class B - Dealer     2025-12-02
85-B-0068 321543 Pamela Mull   Pamela Mull   ALAMOGORDO New Mexico 88311 Class B - Dealer     2018-06-05
85-B-0092 335913 Petland Albuquerque, LLC   Petland Albuquerque, LLC   Albuquerque New Mexico 87122 Class B - Dealer     2024-12-18
85-B-0089 36781 VALERIE DIVETT   VALERIE DIVETT   ALBUQUERQUE New Mexico 87112 Class B - Dealer     2015-10-28
85-B-0094 34515 Vickie Lloyd   VICKIE LLOYD   CARLSBAD New Mexico 88220 Class B - Dealer     2022-07-26
85-B-0091 34515 Vickie Lloyd   Vickie Lloyd   CARLSBAD New Mexico 88220 Class B - Dealer     2016-11-01
85-B-0090 34515 Vickie Lloyd   VICKIE LLOYD   CARLSBAD New Mexico 88220 Class B - Dealer     2015-08-25
85-B-0086 34515 Vickie Lloyd   VICKIE LLOYD   CARLSBAD New Mexico 88220 Class B - Dealer     2014-08-11
85-B-0087 331303 WAGON TRAIL PETS AND SUPPLIES L L C   WAGON TRAIL PETS AND SUPPLIES L L C   ROSWELL New Mexico 88201 Class B - Dealer     2016-04-25
85-B-0084 330532 WALID BOUHAMDAN   WALID BOUHAMDAN   ALBUQUERQUE New Mexico 87109 Class B - Dealer     2014-06-11

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);
Powered by Datasette · Queries took 1153.6ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API