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 = "North Dakota" sorted by legal_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: site_zip, last_seen_date (date)

site_state 1

  • North Dakota · 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
45-A-0112 7137 AUDREY REBENITSCH   AUDREY REBENITSCH   FORT RICE North Dakota 58554 Class A - Breeder     2014-07-24
45-A-0052 4961 Betty Hiatt   BETTY HIATT   TOWER CITY North Dakota 58071 Class A - Breeder     2019-08-27
45-A-0076 5761 Charlet Vetsch   Charlet Vetsch   Hazelton North Dakota 58544 Class A - Breeder     2025-01-30
45-A-0032 4962 SUZANNE HIATT   SUZANNE HIATT   BOTTINEAU North Dakota 58318 Class A - Breeder     2021-07-28
45-A-0115 333886 Silver Barrel Labs L L C   Silver Barrel Labs L L C   FLASHER North Dakota 58535 Class A - Breeder     2022-07-11
45-A-0009 4966 TERENCE SERR SHIRLENE SERR   TERENCE AND SHIRLENE SERR   HAZELTON North Dakota 58544 Class A - Breeder     2017-11-30
45-A-0110 38136 VALORIE WRIGHT   VALORIE WRIGHT   MADDOCK North Dakota 58348 Class A - Breeder     2019-08-07

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