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

19 rows where license_type = "Class T - Carrier" and site_state = "Ohio" 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

  • Ohio · 19 ✖

license_type 1

  • Class T - Carrier · 19 ✖

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
31-T-0222 6012119 A & L Pet Service   A & L PET SERVICE   FRESNO Ohio 43824 Class T - Carrier     2024-11-07
31-T-0029 331994 Air Transport International Inc.   AIR TRANSPORT INTERNATIONAL INC   WILMINGTON Ohio 45177 Class T - Carrier     2021-04-22
31-T-0025 330087 BARBARA WRIGHT   BARB WRIGHT   WEST SALEM Ohio 44287 Class T - Carrier     2016-01-04
31-T-0076 600145 BestCare Pet Transport   Heldman Logistics LLC   Ada Ohio 45810 Class T - Carrier     2021-01-22
31-T-0042 501479 Deeanne Hefner   DEEANNE HOSMER   BLOOMDALE Ohio 44817 Class T - Carrier     2018-03-29
31-T-0211 601413 Dependable Driver Solutions LLC   Dependable Driver Solutions LLC   Mentor Ohio 44060 Class T - Carrier     2025-07-29
31-T-0011 45457 GREG MAHLE   GREG MAHLE   MOUNT PERRY Ohio 43760 Class T - Carrier     2015-06-27
31-T-0037 324575 Irma Miller   IRMA MILLER   MILLERSBURG Ohio 44654 Class T - Carrier     2016-11-03
31-T-0045 503396 JOHN HIXON   JOHN PAUL HIXON   WAPAKONETA Ohio 45895 Class T - Carrier     2018-10-01
31-T-0031 332534 JULIE BINGHAM   JULIE BINGHAM   CLAYTON Ohio 45315 Class T - Carrier     2018-08-29
31-T-0092 602160 Jordan Castle   Jordan Castle   Ada Ohio 45810 Class T - Carrier     2021-01-22
31-T-0075 600515 Joseph Pittenger   Joseph Pittenger   Holland Ohio 43528 Class T - Carrier     2021-01-04
31-T-0077 600364 Mary Jo L Favitta   Mary Jo L Favitta   Strongsville Ohio 44149 Class T - Carrier     2021-01-07
31-T-0086 601026 Randolph Hester   Randolph Hester   Greenfield Ohio 45123 Class T - Carrier     2023-11-02
31-T-0034 333175 Regina Miller   Regina Miller   Dundee Ohio 44624 Class T - Carrier     2021-02-01
31-T-0074 600037 Rex L Gaylord   Rex L Gaylord   BRECKSVILLE Ohio 44141 Class T - Carrier     2021-01-07
32-T-0007 34228 SHUTTLE AMERICA   CINCINNATI/NORTHERN KY INTL AIRPORT   CINCINNATI Ohio 45275 Class T - Carrier     2017-02-16
31-T-0019 327532 TOO ZOO LOGISTICS LLC   TOO ZOO LOGISTICS LLC   OAK HARBOR Ohio 43449 Class T - Carrier     2019-05-29
31-T-0090 601112 Vicky Chelchowski   Vicky Chelchowski   Toledo Ohio 43611 Class T - Carrier     2021-01-07

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