facilities
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
This data as json, CSV (advanced)
Suggested facets: customer_number, legal_name, site_name, site_city, site_zip, last_seen_date (date)
| 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
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);