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

7 rows where license_type = "Class B - Dealer" and site_state = "West Virginia" 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

  • West Virginia · 7 ✖

license_type 1

  • Class B - Dealer · 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
54-B-0052 6023510 By Design Poodles LLC   By Design Poodles LLC   Jumping Branch West Virginia 25969 Class B - Dealer     2025-07-08
54-B-0049 330167 DANIELLE MOORE   DANIELLE MOORE   MILTON West Virginia 25541 Class B - Dealer     2016-11-30
54-B-0048 330167 DANIELLE MOORE   DANIELLE MOORE   MILTON West Virginia 25541 Class B - Dealer     2014-04-18
54-B-0051 6013071 Jonathan D. Chapman   Reptile Villa   Danville West Virginia 25053 Class B - Dealer     2025-02-27
54-B-0050 28783 MICHAEL DAVIS   MICHAEL DAVIS   BUNKER HILL West Virginia 25413 Class B - Dealer     2026-01-29
54-B-0047 330295 SOUTH FORK EXOTICS   SOUTH FORK EXOTICS   MOOREFIELD West Virginia 26836 Class B - Dealer     2016-07-25
54-B-0046 330297 SUSANS WORLD OF PETS L L C   SUSANS WORLD OF PETS L L C   LEWISBURG West Virginia 24901 Class B - Dealer     2018-04-30

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