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

8 rows where license_type = "Class H - Intermediate Handler" and site_state = "Minnesota" 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

  • Minnesota · 8 ✖

license_type 1

  • Class H - Intermediate Handler · 8 ✖

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
74-H-0082 1339 AEROGROUND INC.   Minneapolis International Airport   MINNEAPOLIS Minnesota 55450 Class H - Intermediate Handler     2014-08-28
41-H-0008 335109 CONCIERGE PET TRAVEL SERVICES   CONCIERGE PET TRAVEL SERVICES   MAPLEWOOD Minnesota 55106 Class H - Intermediate Handler     2018-11-19
41-H-0001 544 GOLDWOOD KENNELS, INC.   GOLDWOOD KENNELS, INC.   WHITE BEAR LAKE Minnesota 55115 Class H - Intermediate Handler     2020-02-20
41-H-0009 500985 M.S.P. COURIER INC   M.S.P. COURIER INC   STILLWATER Minnesota 55082 Class H - Intermediate Handler     2021-10-25
41-H-0007 329453 MICHAEL DENNIS CROWLEY   MIKE CROWLEY   WYOMING Minnesota 55092 Class H - Intermediate Handler     2015-10-05
74-H-0105 505385 PRIME FLIGHT AVIATION SERVICES INC   PRIME FLIGHT AVIATION SERVICES INC   MINNEAPOLIS Minnesota 55450 Class H - Intermediate Handler     2022-01-24
41-H-0003 26475 RIVERSIDE EXPRESS LLC   RIVERSIDE EXPRESS   HANCOCK Minnesota 56244 Class H - Intermediate Handler     2020-02-05
41-H-0010 507667 SOUTHVIEW ANIMAL HOSPITAL P A   MICHAEL FOSTER DVM   WEST SAINT PAUL Minnesota 55118 Class H - Intermediate Handler     2021-10-25

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