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

16 rows where license_type = "Class B - Dealer" and site_state = "Oregon" sorted by legal_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: customer_number, legal_name, site_city, site_zip, last_seen_date (date)

site_state 1

  • Oregon · 16 ✖

license_type 1

  • Class B - Dealer · 16 ✖

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
92-B-0253 328095 Ashland Pets L L C   Ashland Pets, L L C   ASHLAND Oregon 97250 Class B - Dealer     2014-11-28
92-B-0257 326618 CASSANDRA JOHNSON   CASSANDRA LEONARD JOHNSON   ROSEBURG Oregon 97471 Class B - Dealer     2019-05-28
92-B-0258 24069 CRITTER CABANA L L C   CRITTER CABANA L L C   WILSONVILLE Oregon 97070 Class B - Dealer     2017-03-10
92-B-0247 24069 CRITTER CABANA L L C   CRITTER CABANA, L L C   NEWBERG Oregon 97132 Class B - Dealer     2015-02-26
92-B-0146 3650 Carol Dye Mike Dye   Carol Dye Mike Dye   Salem Oregon 97317 Class B - Dealer     2025-07-30
92-B-0252 326518 Carsons Critters L L C   Carsons Critters L L C   BROOKINGS Oregon 97415 Class B - Dealer     2019-05-16
92-B-0262 6023575 Cody Wood   Cody Wood   Junction City Oregon 97448 Class B - Dealer     2025-07-28
92-B-0249 324282 Helen Marie Nelson   Helen Marie Nelson   ROSEBURG Oregon 97471 Class B - Dealer     2024-07-17
92-B-0250 326554 Janet Kraker Richard Kraker   Janet Kraker, Richard Kraker   Forest Grove Oregon 97116 Class B - Dealer     2023-08-29
92-B-0261 6020271 Jolly Farmers   Jolly Farmers   Corvallis Oregon 97333 Class B - Dealer     2025-12-10
92-B-0208 8136 Jungle Fever Exotics   JUNGLE FEVER EXOTICS   SALEM Oregon 97305 Class B - Dealer     2025-07-21
92-B-0256 332765 Kellie Caron Raegan Royale   Kellie Caron & Raegan Royale   RAINIER Oregon 97048 Class B - Dealer     2017-11-15
92-B-0235 14447 LUCY CROSS   LUCY CROSS   DALLAS Oregon 97338 Class B - Dealer     2025-06-05
92-B-0260 6012525 Rafter B Livestock Inc   Rafter B Livestock Inc   Junction City Oregon 97448 Class B - Dealer     2024-02-01
92-B-0259 502224 TONY A MARLOW II   TONY A MARLOW II   PORTLAND Oregon 97217 Class B - Dealer     2019-12-10
92-B-0230 27401 ZANY ZOO PETS L L C   ZANY ZOO PETS L L C   EUGENE Oregon 97402 Class B - Dealer     2018-07-05

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