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

12 rows where license_type = "Class B - Dealer" and site_state = "South Dakota" sorted by legal_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: last_seen_date (date)

site_state 1

  • South Dakota · 12 ✖

license_type 1

  • Class B - Dealer · 12 ✖

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
47-B-0119 332782 Chris Nelson   Mitchel Livestock   Mitchell South Dakota 57301 Class B - Dealer     2023-01-20
46-B-0068 4995 DOROTHY SANBORN GARY SANBORN   GARY AND DOROTHY SANBORN   MADISON South Dakota 57042 Class B - Dealer     2019-06-25
46-B-0084 39291 JILL STROBEL   JILL A STROBEL   HERREID South Dakota 57632 Class B - Dealer     2021-08-12
46-B-0060 8343 Jan Strenger   Jan Strenger   Yankton South Dakota 57078 Class B - Dealer     2025-12-19
46-B-0092 507692 KYLE PETTY   KYLE PETTY   BOX ELDER South Dakota 57719 Class B - Dealer     2020-02-26
46-B-0077 5002 Karen Veurink   Karen Veurink   Harrison South Dakota 57344 Class B - Dealer     2025-12-16
46-B-0086 5011 Kevin and Jolynne Parmely   Kevin and Jolynne Parmely   Huron South Dakota 57350 Class B - Dealer     2025-03-26
46-B-0069 5013 RONALD WAGNER   RONALD WAGNER   WATERTOWN South Dakota 57201 Class B - Dealer     2018-06-11
46-B-0090 331626 SAB Biotherapeutics Inc.   SAB Biotherapeutics Inc. - 008   CANTON South Dakota 57013 Class B - Dealer     2025-11-17
46-B-0066 5110 SCOTT STROBEL   SCOTT STROBEL   EUREKA South Dakota 57437 Class B - Dealer     2017-02-13
46-B-0088 326984 Sasha Kelly   SASHA KELLY   RAPID CITY South Dakota 57701 Class B - Dealer     2018-03-28
46-B-0065 10378 Tamara Schanzenbach   TAMARA SCHANZENBACH   MOBRIDGE South Dakota 57601 Class B - Dealer     2023-11-27

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