aphis: facilities: 89 rows where license_type = "Class C - Exhibitor" and site_state = "Connecticut" sorted by legal

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

89 rows where license_type = "Class C - Exhibitor" and site_state = "Connecticut" sorted by legal_name

descending

✎ View and edit SQL

This data as json, CSV (advanced)

cert_number	customer_number	legal_name ▼	site_name	site_city	site_state	site_zip	license_type	last_seen_date
12-C-0060	508003	841 Centre St LLC	841 Centre Street LLC	STAMFORD	Connecticut	06907	Class C - Exhibitor	2025-02-19
16-C-0181	6021013	A Place Called Hope, Inc	A Place Called Hope, Inc	Killingworth	Connecticut	06419	Class C - Exhibitor	2025-08-06
16-C-0095	16986	ANTHONY DIBELLA	ANTHONY DIBELLA	PLYMOUTH	Connecticut	06782	Class C - Exhibitor	2014-08-01
16-C-0165	500536	AUSSAKITA ACRES FARM LLC	AUSSAKITA ACRES FARM LLC	MANCHESTER	Connecticut	06042	Class C - Exhibitor	2019-11-14
16-C-0057	7817	Action Wildlife Foundation Inc	Action Wildlife Foundation, Inc.	Goshen	Connecticut	06756	Class C - Exhibitor	2025-12-15
16-C-0175	6012621	Autumn Olive Farm LLC	Autumn Olive Farm LLC	Lebanon	Connecticut	06249	Class C - Exhibitor	2025-08-21
16-C-0105	34241	BETHANNE COUTURE	BETHANNE COUTURE	SOUTH GLASTONBURY	Connecticut	06073	Class C - Exhibitor	2014-10-08
16-C-0186	6021400	Blue Moon Raptors	Blue Moon Raptors	Guilford	Connecticut	06437	Class C - Exhibitor	2025-05-15
16-C-0170	502032	Bradley Mountain Farm	Bradley Mountain Farm	Southington	Connecticut	06489	Class C - Exhibitor	2025-05-21
16-C-0160	502032	Bradley Mountain Farm	BRADLEY MOUNTAIN SOAPS LLC	SOUTHINGTON	Connecticut	06489	Class C - Exhibitor	2017-05-31
16-C-0168	42898	Bret Haughwout	Bret Haughwout	Clinton	Connecticut	06413	Class C - Exhibitor	2025-03-20
16-C-0107	36547	CHARLEENS PORTRAIT STUDIO	CHARLEENS PORTRAIT STUDIO	DAYVILLE	Connecticut	06241	Class C - Exhibitor	2014-03-27
16-C-0147	330579	CHESHIRE HOLLOW FARM LLC	CHESHIRE HOLLOW FARM LLC	CHESHIRE	Connecticut	06410	Class C - Exhibitor	2018-05-09
16-C-0141	329215	CINDY KING	CINDY KING	PORTLAND	Connecticut	06480	Class C - Exhibitor	2017-07-18
16-C-0119	321503	Carol Bacon, John Hardisty and Tammy Hardisty	Carol Bacon John Hardisty and Tammy Hardisty	Woodbury	Connecticut	06798	Class C - Exhibitor	2025-05-20
16-C-0180	6020624	Christine's Critters, Inc	Christine's Critters, Inc	WESTON	Connecticut	06883	Class C - Exhibitor	2025-08-06
16-C-0102	31452	City of Ansonia	City of Ansonia	Ansonia	Connecticut	06401	Class C - Exhibitor	2026-01-09
16-C-0020	2344	City of Torrington	Christmas Village	Torrington	Connecticut	06790	Class C - Exhibitor	2025-11-25
16-C-0146	16024	Connecticut Audubon Society	CONNECTICUT AUDUBON CENTER AT FAIRFIELD	FAIRFIELD	Connecticut	06824	Class C - Exhibitor	2025-01-29
16-C-0053	7007	Connecticut Zoological Society	Connecticut Zoological Society	Bridgeport	Connecticut	06610	Class C - Exhibitor	2025-04-14
16-C-0076	16613	Darien Nature Center	Darien Nature Center	Darien	Connecticut	06820	Class C - Exhibitor	2025-05-13
16-C-0179	1945	Denison Pequotsepos Nature Center	Denison Pequotsepos Nature Center	Mystic	Connecticut	06355	Class C - Exhibitor	2025-03-10
16-C-0103	34061	EDEN FARMS L L C	EDEN FARMS LLC	STAMFORD	Connecticut	06902	Class C - Exhibitor	2014-11-18
16-C-0019	1944	Earthplace, Inc.	Earthplace, The Nature Discovery Center	Westport	Connecticut	06881	Class C - Exhibitor	2025-09-25
16-C-0185	6019650	Environmental Learning Centers of Connecticut	Environmental Learning Centers of Connecticut	Bristol	Connecticut	06010	Class C - Exhibitor	2025-05-14
16-C-0084	20896	FARMER MINOR & DAISY L L C	FARMER MINOR & DAISY LLC	BRISTOL	Connecticut	06010	Class C - Exhibitor	2018-08-08
16-C-0167	502945	FERNCROFT WILDLIFE RESCUE	FERNCROFT WILDLIFE RESCUE	WOODSTOCK	Connecticut	06281	Class C - Exhibitor	2025-03-26
16-C-0056	7357	FISH BOWL PET SHOP	FISH BOWL PET SHOP	STAMFORD	Connecticut	06907	Class C - Exhibitor	2019-02-14
16-C-0139	25334	FOSTER FAMILY FARM L L C	FOSTER FAMILY FARM L L C	SOUTH WINDSOR	Connecticut	06074	Class C - Exhibitor	2017-10-11
16-C-0158	500575	FRIENDS OF AMBLER FARM INC	FRIENDS OF AMBLER FARM	WILTON	Connecticut	06897	Class C - Exhibitor	2017-06-29
16-C-0173	6004058	Farm River Wildlife Rescue & Rehabilitation Inc	Farm River Wildlife Rescue & Rehabilitation Inc	East Haven	Connecticut	06512	Class C - Exhibitor	2025-11-18
16-C-0178	6016124	Farm on Wheels LLC	Farm on Wheels LLC	Prospect	Connecticut	06712	Class C - Exhibitor	2025-05-27
16-C-0077	9261	Flamig Farms Inc	Flamig Farms Inc	West Simsbury	Connecticut	06092	Class C - Exhibitor	2025-06-27
16-C-0183	6020952	Freedom First Wildlife Rehab Inc	Freedom First Wildlife Rehab Inc	Waterford	Connecticut	06385	Class C - Exhibitor	2025-08-22
16-C-0080	17856	Geraldine E Griswold	Geraldine Griswold	Winsted	Connecticut	06098	Class C - Exhibitor	2022-08-22
16-C-0166	6234	Gleanna Doyle	Gleanna Doyle	Stonington	Connecticut	06378	Class C - Exhibitor	2025-04-18
16-C-0162	502040	Goatboy Soaps LLC	Goatboy Soaps LLC	New Milford	Connecticut	06776	Class C - Exhibitor	2026-01-05
16-C-0137	327434	Heather Rorke	HEATHER RORKE	NORWICH	Connecticut	06360	Class C - Exhibitor	2025-12-16
16-C-0182	6020812	Horizon Wings Inc	Horizon Wings Inc	Ashford	Connecticut	06278	Class C - Exhibitor	2025-01-15
16-C-0171	505758	JCs Pony Parties Yee Haa LLC	JC's Pony Parties Yee Haa LLC	Seymour	Connecticut	06483	Class C - Exhibitor	2025-07-30
16-C-0145	41964	JOAN ZENKO	JOAN ZENKO	MONROE	Connecticut	06468	Class C - Exhibitor	2016-03-17
16-C-0176	329065	John Dzen	JOHN DZEN JR	SOUTH WINDSOR	Connecticut	06074	Class C - Exhibitor	2024-12-13
16-C-0153	329065	John Dzen	JOHN DZEN JR	SOUTH WINDSOR	Connecticut	06074	Class C - Exhibitor	2021-12-23
16-C-0159	331575	KELLY CRONIN	KELLY CRONIN	PROSPECT	Connecticut	06712	Class C - Exhibitor	2022-08-23
16-C-0150	331575	KELLY CRONIN	KELLY CRONIN	PROSPECT	Connecticut	06712	Class C - Exhibitor	2016-12-22
16-C-0172	331137	Kathryn Langham	Kathryn Langham	Fairfield	Connecticut	06825	Class C - Exhibitor	2026-01-13
16-C-0130	325249	Kristen Coronis	Kristen Coronis	Newtown	Connecticut	06470	Class C - Exhibitor	2024-12-19
16-C-0120	322424	Lionshare Educational Organization	Lionshare Educational Organization	Stamford	Connecticut	06903	Class C - Exhibitor	2021-09-15
16-C-0151	1955	Lutz Children's Museum, Inc.	Lutz Children's Museum	Manchester	Connecticut	06040	Class C - Exhibitor	2025-04-30
16-C-0093	1955	Lutz Children's Museum, Inc.	LUTZ CHILDREN MUSEUM	MANCHESTER	Connecticut	06040	Class C - Exhibitor	2014-10-07
16-C-0187	6018515	Marisa Nitsch	Marisa Nitsch	Prospect	Connecticut	06712	Class C - Exhibitor	2025-06-11
16-C-0030	1948	Maritime Aquarium at Norwalk	Maritime Center at Norwalk	South Norwalk	Connecticut	06854	Class C - Exhibitor	2025-02-12
16-C-0163	502575	Maureen Heidtmann	Maureen Heidtmann	East Hampton	Connecticut	06424	Class C - Exhibitor	2024-09-27
16-C-0022	1946	New Britain Institute	New Britain Institute	Kensington	Connecticut	06037	Class C - Exhibitor	2025-12-16
16-C-0074	15788	New Canaan Nature Center	New Canaan Nature Center	New Canaan	Connecticut	06840	Class C - Exhibitor	2025-11-20
21-C-0454	10958	PONY EXPRESS ENTERTAINMENT INC	PONY EXPRESS ENTERTAINMENT INC	WOODBURY	Connecticut	06798	Class C - Exhibitor	2021-06-04
16-C-0149	327913	PORTRAITS BY NAN L L C	PORTRAITS BY NAN L L C	POMFRET	Connecticut	06258	Class C - Exhibitor	2014-03-27
14-C-0105	36052	Portrait Simple of Massachusetts Inc	WESTFIELD SHOPPING CENTER TRUMBALL MALL	TRUMBULL	Connecticut	06611	Class C - Exhibitor	2015-03-11
16-C-0135	43864	RAY OF LIGHT FARM INC	RAY OF LIGHT FARM INC	EAST HADDAM	Connecticut	06423	Class C - Exhibitor	2020-01-30
16-C-0152	330291	RICHARD JONES	RICHARD JONES	GRANBY	Connecticut	06035	Class C - Exhibitor	2015-05-13
16-C-0169	503978	ROBERT TRONSKI	ROBERT TRONSKI	STAFFORD SPRINGS	Connecticut	06076	Class C - Exhibitor	2018-07-31
16-C-0132	44917	ROWANWOOD FARM LLC	ROWANWOOD FARM LLC	SANDY HOOK	Connecticut	06482	Class C - Exhibitor	2019-07-17
16-C-0006	1940	RW Commerford and Sons Inc	Red Unit	Goshen	Connecticut	06756	Class C - Exhibitor	2025-09-16
16-C-0188	6022111	Ripley Waterfowl Conservancy	Ripley Waterfowl Conservancy	Litchfield	Connecticut	06759	Class C - Exhibitor	2025-08-12
16-C-0155	333911	Riverview Farms LLC	Riverview Farms LLC	Glastonbury	Connecticut	06033	Class C - Exhibitor	2025-09-10
16-C-0091	19999	Ron Delucia	RON DE LUCIA	BRANFORD	Connecticut	06405	Class C - Exhibitor	2025-06-12
16-C-0115	43488	SHARON FAMILY FARM LLC	SHARON FAMILY FARM LLC	TOLLAND	Connecticut	06084	Class C - Exhibitor	2018-04-12
16-C-0025	56	Sea Research Foundation, Inc	Mystic Life Aquarium	Mystic	Connecticut	06355	Class C - Exhibitor	2025-07-08
16-C-0177	6014233	SeaQuest Trumbull LLC	SeaQuest Trumbull LLC	Trumbull	Connecticut	06611	Class C - Exhibitor	2023-08-21
16-C-0184	6020674	Sharon Audubon Center	Sharon Audubon Center	Sharon	Connecticut	06069	Class C - Exhibitor	2025-09-30
16-C-0157	10815	Sherry Farquharson	Sherry Farquharson	Killingworth	Connecticut	06419	Class C - Exhibitor	2024-06-26
16-C-0121	10815	Sherry Farquharson	SHERRY FARQUHARSON	KILLINGWORTH	Connecticut	06419	Class C - Exhibitor	2016-06-09
16-C-0174	6012236	Sherry Harmon	Sherry Harmon	Moosup	Connecticut	06354	Class C - Exhibitor	2025-09-24
16-C-0013	2294	Silverman's Farm Inc	Silverman's Farm Inc	Easton	Connecticut	06612	Class C - Exhibitor	2025-12-29
16-C-0018	1943	Stamford Museum and Nature Center	Stamford Museum and Nature Center	Stamford	Connecticut	06903	Class C - Exhibitor	2025-02-19
16-C-0085	10174	Stew Leonard's	Stew Leonard's	Danbury	Connecticut	06811	Class C - Exhibitor	2025-07-30
16-C-0156	23335	Susan Perry	Sue Perry	Plantsville	Connecticut	06479	Class C - Exhibitor	2024-08-06
16-C-0142	321136	T M C PHOTOGRAPHY	T M C PHOTOGRAPHY	VERNON	Connecticut	06066	Class C - Exhibitor	2014-03-29
16-C-0073	2499	TED KROGH	TED KROGH	EAST HAMPTON	Connecticut	06424	Class C - Exhibitor	2023-03-08
16-C-0164	502925	THE FAMILY CENTER INC	THE FAMILY CENTER INC	BRISTOL	Connecticut	06010	Class C - Exhibitor	2018-04-24
16-C-0154	323004	TMK Sports & Entertainment LLC	TMK Sports & Entertainment LLC	Greenwich	Connecticut	06830	Class C - Exhibitor	2024-12-04
16-C-0134	323004	TMK Sports & Entertainment LLC	T M K SPORTS & ENTERTAINMENT L L C	GREENWICH	Connecticut	06830	Class C - Exhibitor	2014-12-15
16-C-0007	1941	The Children's Museum	Roaring Brook Nature Center	Canton	Connecticut	06019	Class C - Exhibitor	2025-08-18
16-C-0003	9039	Town Of Hamden	Town Of Hamden CT	Hamden	Connecticut	06518	Class C - Exhibitor	2025-04-21
16-C-0008	1942	Town of West Hartford	Town of West Hartford	West Hartford	Connecticut	06117	Class C - Exhibitor	2025-07-23
16-C-0148	9042	Town of Windsor	Town of Windsor	Windsor	Connecticut	06095	Class C - Exhibitor	2025-06-03
16-C-0092	24702	Waterford Country School Inc	Waterford Country School Inc	Quaker Hill	Connecticut	06375	Class C - Exhibitor	2025-07-31
16-C-0143	330029	William Berloni Theatrical Animals	William Berloni Theatrical Animals	HIGGANUM	Connecticut	06441	Class C - Exhibitor	2024-10-07
16-C-0161	501138	Zenko Farm LLC	ZENKO FARM LLC	MONROE	Connecticut	06468	Class C - Exhibitor	2025-09-17

Advanced export

JSON shape: default, array, newline-delimited, object

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