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 B - Dealer" and site_state = "Kentucky" 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

  • Kentucky · 17 ✖

license_type 1

  • Class B - Dealer · 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
61-B-0145 6003396 Aaron A Miller   Aaron A Miller   Irvington Kentucky 40146 Class B - Dealer     2022-03-16
61-B-0146 6011391 Ainsley Willow Hedgehogs   Ainsley Willow Hedgehogs   Shepherdsville Kentucky 40165 Class B - Dealer     2022-04-14
61-B-0142 334354 Amanda & Hunter Smith   UNIQUE PAWS N CLAWS   CADIZ Kentucky 42211 Class B - Dealer     2018-04-23
61-B-0148 6011172 Ethan Pike   Ethan Pike   Columbia Kentucky 42728 Class B - Dealer     2022-05-12
61-B-0147 6011774 Holly Webb   Holly Young   Bowling Green Kentucky 42101 Class B - Dealer     2022-04-28
61-B-0149 6015111 Jason ONeill   Jason ONeill   Dry Ridge Kentucky 41035 Class B - Dealer     2023-06-14
61-B-0116 3193 Jeff & Margaret McClanahan   Jeff & Margaret McClanahan   Georgetown Kentucky 40324 Class B - Dealer     2025-02-18
61-B-0151 6025837 Jeff McClanahan   Jeff McClanahan   Georgetown Kentucky 40324 Class B - Dealer     2026-01-28
61-B-0131 321859 John and Teresa Babb   JOHN AND TERESA BABB   BEREA Kentucky 40403 Class B - Dealer     2023-06-08
61-B-0139 334263 KRYSTAL LESLIE   KRYSTAL LESLIE   SUMMER SHADE Kentucky 42166 Class B - Dealer     2017-10-10
61-B-0141 335162 Martin M. Miller   Martin M. Miller   Horse Cave Kentucky 42749 Class B - Dealer     2021-12-07
61-B-0140 335214 Michael Troyer   Michael Troyer   HORSE CAVE Kentucky 42749 Class B - Dealer     2019-12-27
61-B-0150 6021106 Murray Stevens   Murray Stevens   Greensburg Kentucky 42743 Class B - Dealer     2025-07-29
61-B-0143 506696 Nathan Miller   NATHAN P MILLER   HORSE CAVE Kentucky 42749 Class B - Dealer     2022-10-11
61-B-0138 324018 RAY STIPE   RAY STIPE   FRENCHBURG Kentucky 40322 Class B - Dealer     2014-08-07
61-B-0144 503465 Sue Stevens   Sue Stevens   GREENSBURG Kentucky 42743 Class B - Dealer     2023-06-14
61-B-0152 6014294 William D Byler   William D Byler   Munfordville Kentucky 42765 Class B - Dealer     2025-12-17

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