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

17 rows where license_type = "Class C - Exhibitor" and site_state = "South Dakota" 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

  • South Dakota · 17 ✖

license_type 1

  • Class C - Exhibitor · 17 ✖

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
46-C-0056 33491 BIRCH TREE ENTERPRISES INC.   BIRCH TREE ENTERPRISES, INC.   KEYSTONE South Dakota 57751 Class C - Exhibitor     2019-09-25
46-C-0005 5015 Bear Country USA   Bear Country USA   Rapid City South Dakota 57702 Class C - Exhibitor     2025-12-09
46-C-0012 5017 Black Hills Reptile Gardens Inc   Black Hills Reptile Gardens Inc   RAPID CITY South Dakota 57701 Class C - Exhibitor     2025-08-13
46-C-0061 7710 CARLA KNECHT DAVID KNECHT   CARLA KNECHT & DAVE KNECHT   BOWDLE South Dakota 57428 Class C - Exhibitor     2018-03-29
46-C-0068 330046 Chris Five Inc   CHRIS 5 INC.   SPEARFISH South Dakota 57783 Class C - Exhibitor     2024-09-18
46-C-0065 330046 Chris Five Inc   CHRIS 5 INC   SPEARFISH South Dakota 57783 Class C - Exhibitor     2014-07-28
46-C-0006 5016 City Of Aberdeen Parks Rec And Forestry Dept   City Of Aberdeen Parks Rec And Forestry Dept   Aberdeen South Dakota 57401 Class C - Exhibitor     2025-06-26
46-C-0001 5019 City Of Watertown   Bramble Park Zoo   Watertown South Dakota 57201 Class C - Exhibitor     2025-11-19
46-C-0054 5018 DR. BEN KRAZY L L C   DR. BEN KRAZY, L L C   NEW UNDERWOOD South Dakota 57761 Class C - Exhibitor     2014-09-05
46-C-0067 332815 Dr. Ben Krazy L L C   Dr. Ben Krazy L L C   NEW UNDERWOOD South Dakota 57761 Class C - Exhibitor     2018-08-20
46-C-0057 5020 Great Plains Zoo and Delbridge Museum   Great Plains Zoo and Delbridge Museum   Sioux Falls South Dakota 57104 Class C - Exhibitor     2025-12-11
46-C-0069 6082 HIGH PLAINS WESTERN HERITAGE CENTER   HIGH PLAINS WESTERN HERITAGE CENTER   SPEARFISH South Dakota 57783 Class C - Exhibitor     2019-06-06
46-C-0059 6082 HIGH PLAINS WESTERN HERITAGE CENTER   HIGH PLAINS WESTERN HERITAGE CENTER   SPEARFISH South Dakota 57783 Class C - Exhibitor     2015-08-18
46-C-0060 321638 JEFF RUEB   JEFF RUEB   TYNDALL South Dakota 57066 Class C - Exhibitor     2019-04-16
46-C-0071 331492 Old MacDonalds Farm LLC   Old MacDonald's Farm LLC   Rapid City South Dakota 57702 Class C - Exhibitor     2025-06-11
46-C-0066 331492 Old MacDonalds Farm LLC   Old MacDonald's Farm, LLC   Rapid City South Dakota 57702 Class C - Exhibitor     2022-08-30
46-C-0053 10912 SPIRIT OF THE HILLS WILDLIFE SANCTUARY   SPIRIT OF THE HILLS WILDLIFE SANCTUARY   SPEARFISH South Dakota 57783 Class C - Exhibitor     2016-10-04

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 1322.043ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API