facilities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
5 rows where license_type = "Class G - Agricultural Research Facility ARS" and site_state = "Texas" sorted by legal_name
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 74-G-0004 | 335793 | Childrens Nutrition Research Center | CHILDRENS NUTRITION RESEARCH CENTER | HOUSTON | Texas | 77030 | Class G - Agricultural Research Facility ARS | 2025-02-25 | ||||
| 74-G-0005 | 335794 | Conservation And Production Research Laboratory | CONSERVATION & PRODUCTION RESEARCH LABORATORY | BUSHLAND | Texas | 79012 | Class G - Agricultural Research Facility ARS | 2026-01-06 | ||||
| 74-G-0002 | 6023308 | Knipling Bushland Us Livestock Insects Research | KNIPLING BUSHLAND US LIVESTOCK INSECTS RES LAB | KERRVILLE | Texas | 78028 | Class G - Agricultural Research Facility ARS | 2025-02-27 | ||||
| 74-G-0001 | 334102 | Livestock Issues Research Unit | USDA ARS LIRU | LUBBOCK | Texas | 79403 | Class G - Agricultural Research Facility ARS | 2025-02-20 | ||||
| 74-G-0003 | 334299 | Southern Plains Ag Research Center | USDA ARS SOUTHERN PLAINS AGRICULTURAL RES. CNT. | COLLEGE STATION | Texas | 77845 | Class G - Agricultural Research Facility ARS | 2025-01-28 |
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);