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

13 rows where license_type = "Class H - Intermediate Handler" and site_state = "Texas" sorted by legal_name

✎ View and edit SQL

This data as json, CSV (advanced)

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

site_state 1

  • Texas · 13 ✖

license_type 1

  • Class H - Intermediate Handler · 13 ✖

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
74-H-0098 504458 ASHLEY RAM   ASHLEE RAM   SCHERTZ Texas 78154 Class H - Intermediate Handler     2021-05-06
74-H-0200 6014906 Ameriflight LLC   Ameriflight LLC   DFW Airport Texas 75261 Class H - Intermediate Handler     2023-01-05
74-H-0108 506030 CHRISTOPHER MARTINEZ   CHRISTOPHER MARTINEZ   UNIVERSAL CITY Texas 78148 Class H - Intermediate Handler     2019-07-29
74-H-0085 328457 Hourglass Inc.   Hourglass Inc.   HOUSTON Texas 77032 Class H - Intermediate Handler     2021-08-26
74-H-0066 28563 Kevin O'Brien Angie O'Brien   Angie O'Brien & Kevin O'Brien   AUSTIN Texas 78701 Class H - Intermediate Handler     2016-06-30
74-H-0087 331425 Kirsten Merrington   Kirsten Merrington   KERRVILLE Texas 78028 Class H - Intermediate Handler     2015-03-25
74-H-0079 326360 LIVE ANIMAL TRANSPORTATION SERVICES LLC   Live Animal Transportation Services   HUMBLE Texas 77338 Class H - Intermediate Handler     2016-03-14
74-H-0065 27244 Onion Creek Kennels L L C   Onion Creek Kennels L L C   BUDA Texas 78610 Class H - Intermediate Handler     2016-05-16
74-H-0093 503850 PET RELOCATION LLC   PET RELOCATION LLC   AUSTIN Texas 78702 Class H - Intermediate Handler     2019-11-19
74-H-0109 506031 Patricia Martinez   PATRICIA MARTINEZ   UNIVERSAL CITY Texas 78148 Class H - Intermediate Handler     2019-07-29
74-H-0058 1721 Rob Cary Inc.   ROB CARY, INC   SAN ANTONIO Texas 78247 Class H - Intermediate Handler      
74-H-0114 504858 TLC Flight Nanny   002   CANTON Texas 75103 Class H - Intermediate Handler     2021-01-29
74-H-0088 42208 World Pet Travel U S A   World Pet Travel U S A   ROCKWALL Texas 75087 Class H - Intermediate Handler      

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