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

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

  • Louisiana · 14 ✖

license_type 1

  • Class B - Dealer · 14 ✖

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
72-B-0146 505238 Acadiana Animal Aid   Acadiana Animal Aid   Carencro Louisiana 70520 Class B - Dealer     2024-11-14
72-B-0144 505238 Acadiana Animal Aid   ACADIANA ANIMAL AID   CARENCRO Louisiana 70520 Class B - Dealer     2022-04-20
72-B-0143 503587 CHARLES WINTERTON   CHARLES WINTERTON   GRAND CANE Louisiana 71032 Class B - Dealer     2022-03-09
31-B-0240 43897 Dave Linkhart   Dave Linkhart   Morse Louisiana 70559 Class B - Dealer     2025-01-27
72-B-0148 328293 John Fisher III   John Fisher III   Terrytown Louisiana 70056 Class B - Dealer     2024-08-20
72-B-0135 42572 KAREN GROSSENBACHER   KAREN GROSSENBACHER   SLIDELL Louisiana 70460 Class B - Dealer     2015-12-15
72-B-0142 333943 LTD SERVICES LLC   LTD SERVICES LLC   ABBEVILLE Louisiana 70510 Class B - Dealer     2024-08-13
72-B-0133 16249 MEMORY ALTAZAN   MEMORY ALTAZAN   DENHAM SPRINGS Louisiana 70726 Class B - Dealer     2019-07-30
72-B-0145 326361 Ronald C Guidry Jr   Ole Mack Ronald   DES ALLEMANDS Louisiana 70030 Class B - Dealer     2022-09-21
72-B-0134 43732 SILVERSTAKE LODE LLC   Silverstake Lode, LLC   GRAND CANE Louisiana 71032 Class B - Dealer     2015-12-03
72-B-0132 34551 The Lizard King Inc.   THE PET ZONE   SHREVEPORT Louisiana 71118 Class B - Dealer     2015-01-14
72-B-0140 333478 The Pet Shop   Lafonda Williams - Stelly   LEESVILLE Louisiana 71446 Class B - Dealer     2015-08-03
72-B-0030 4773 Tulane National Biomedical Research Center   Tulane National Primate Research Center   Covington Louisiana 70433 Class B - Dealer     2025-02-25
72-B-0005 4774 Waubun Laboratories Inc.   Waubun Laboratories, Inc   SCHRIEVER Louisiana 70395 Class B - Dealer     2024-09-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 1204.122ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API