home / aphis

Facilities by State

Count of APHIS-licensed facilities in each state, broken down by license type.

Custom SQL query returning 320 rows (hide)

SELECT site_state, license_type, COUNT(*) AS facility_count FROM facilities WHERE site_state <> '' GROUP BY site_state, license_type ORDER BY site_state, facility_count DESC

Edit SQL

This data as json, CSV

site_statelicense_typefacility_count
Alabama Class C - Exhibitor 77
Alabama Class B - Dealer 25
Alabama Class A - Breeder 16
Alabama Class T - Carrier 10
Alabama Class R - Research Facility 9
Alabama Class H - Intermediate Handler 2
Alabama Class G - Agricultural Research Facility ARS 1
Alaska Class C - Exhibitor 24
Alaska Class R - Research Facility 7
Alaska Class A - Breeder 4
Alaska Class T - Carrier 2
Alaska Class B - Dealer 1
Arizona Class C - Exhibitor 49
Arizona Class T - Carrier 18
Arizona Class A - Breeder 17
Arizona Class R - Research Facility 16
Arizona Class B - Dealer 16
Arizona Class H - Intermediate Handler 5
Arizona Class V - Veteran's Administration Hospital 1
Arkansas Class A - Breeder 242
Arkansas Class C - Exhibitor 50
Arkansas Class B - Dealer 40
Arkansas Class R - Research Facility 19
Arkansas Class T - Carrier 10
Arkansas Class G - Agricultural Research Facility ARS 3
Arkansas Class H - Intermediate Handler 1
California Class C - Exhibitor 401
California Class R - Research Facility 187
California Class T - Carrier 79
California Class B - Dealer 47
California Class A - Breeder 26
California Class H - Intermediate Handler 25
California Class G - Agricultural Research Facility ARS 1
Colorado Class C - Exhibitor 68
Colorado Class A - Breeder 33
Colorado Class B - Dealer 27
Colorado Class R - Research Facility 25
Colorado Class T - Carrier 20
Colorado Class H - Intermediate Handler 10
Colorado Class G - Agricultural Research Facility ARS 1
Connecticut Class C - Exhibitor 91
Connecticut Class R - Research Facility 21
Connecticut Class B - Dealer 10
Connecticut Class H - Intermediate Handler 9
Connecticut Class T - Carrier 8
Connecticut Class A - Breeder 8
Delaware Class C - Exhibitor 5
Delaware Class B - Dealer 4
Delaware Class R - Research Facility 3
District of Columbia Class R - Research Facility 4
District of Columbia Class T - Carrier 2
District of Columbia Class F - Federal Research Facility 1
Florida Class C - Exhibitor 483
Florida Class B - Dealer 189
Florida Class A - Breeder 121
Florida Class R - Research Facility 49
Florida Class T - Carrier 32
Florida Class H - Intermediate Handler 7
Georgia Class C - Exhibitor 144
Georgia Class A - Breeder 43
Georgia Class B - Dealer 32
Georgia Class R - Research Facility 29
Georgia Class T - Carrier 10
Georgia Class H - Intermediate Handler 5
Georgia Class G - Agricultural Research Facility ARS 1
Guam Class C - Exhibitor 5
Guam Class T - Carrier 1
Hawaii Class C - Exhibitor 19
Hawaii Class T - Carrier 4
Hawaii Class R - Research Facility 2
Idaho Class C - Exhibitor 24
Idaho Class R - Research Facility 8
Idaho Class A - Breeder 3
Idaho Class T - Carrier 1
Idaho Class H - Intermediate Handler 1
Idaho Class G - Agricultural Research Facility ARS 1
Idaho Class B - Dealer 1
Illinois Class C - Exhibitor 201
Illinois Class A - Breeder 135
Illinois Class T - Carrier 42
Illinois Class R - Research Facility 42
Illinois Class B - Dealer 32
Illinois Class H - Intermediate Handler 20
Illinois Class E - Exhibitor 1
Indiana Class A - Breeder 815
Indiana Class C - Exhibitor 114
Indiana Class B - Dealer 84
Indiana Class R - Research Facility 29
Indiana Class T - Carrier 22
Indiana Class G - Agricultural Research Facility ARS 1
Iowa Class A - Breeder 462
Iowa Class B - Dealer 93
Iowa Class C - Exhibitor 75
Iowa Class R - Research Facility 27
Iowa Class T - Carrier 11
Iowa Class H - Intermediate Handler 2
Iowa Class G - Agricultural Research Facility ARS 2
Kansas Class A - Breeder 261
Kansas Class B - Dealer 54
Kansas Class C - Exhibitor 49
Kansas Class T - Carrier 24
Kansas Class R - Research Facility 18
Kansas Class H - Intermediate Handler 2
Kansas Class G - Agricultural Research Facility ARS 2
Kentucky Class C - Exhibitor 43
Kentucky Class A - Breeder 22
Kentucky Class B - Dealer 17
Kentucky Class T - Carrier 13
Kentucky Class R - Research Facility 9
Kentucky Class H - Intermediate Handler 2
Kentucky Class G - Agricultural Research Facility ARS 1
Louisiana Class C - Exhibitor 72
Louisiana Class A - Breeder 30
Louisiana Class R - Research Facility 15
Louisiana Class B - Dealer 14
Louisiana Class T - Carrier 5
Louisiana Class H - Intermediate Handler 1
Maine Class R - Research Facility 20
Maine Class C - Exhibitor 10
Maine Class A - Breeder 3
Maine Class B - Dealer 2
Maine Class G - Agricultural Research Facility ARS 1
Maryland Class C - Exhibitor 64
Maryland Class R - Research Facility 32
Maryland Class B - Dealer 19
Maryland Class A - Breeder 18
Maryland Class T - Carrier 3
Maryland Class H - Intermediate Handler 2
Maryland Class G - Agricultural Research Facility ARS 1
Massachusetts Class R - Research Facility 76
Massachusetts Class C - Exhibitor 65
Massachusetts Class B - Dealer 16
Massachusetts Class A - Breeder 11
Massachusetts Class T - Carrier 5
Massachusetts Class H - Intermediate Handler 4
Massachusetts Class G - Agricultural Research Facility ARS 1
Massachusetts Class F - Federal Research Facility 1
Michigan Class C - Exhibitor 183
Michigan Class A - Breeder 72
Michigan Class B - Dealer 50
Michigan Class R - Research Facility 40
Michigan Class T - Carrier 21
Michigan Class H - Intermediate Handler 6
Michigan Class G - Agricultural Research Facility ARS 1
Minnesota Class C - Exhibitor 117
Minnesota Class A - Breeder 71
Minnesota Class B - Dealer 44
Minnesota Class R - Research Facility 40
Minnesota Class T - Carrier 31
Minnesota Class H - Intermediate Handler 8
Mississippi Class C - Exhibitor 47
Mississippi Class B - Dealer 18
Mississippi Class A - Breeder 15
Mississippi Class T - Carrier 10
Mississippi Class R - Research Facility 7
Mississippi Class H - Intermediate Handler 1
Mississippi Class G - Agricultural Research Facility ARS 1
Missouri Class A - Breeder 1654
Missouri Class B - Dealer 214
Missouri Class C - Exhibitor 141
Missouri Class T - Carrier 85
Missouri Class R - Research Facility 31
Missouri Class H - Intermediate Handler 31
Missouri Class G - Agricultural Research Facility ARS 1
Montana Class C - Exhibitor 23
Montana Class A - Breeder 10
Montana Class B - Dealer 5
Montana Class R - Research Facility 4
Montana Class T - Carrier 2
Montana Class G - Agricultural Research Facility ARS 1
Nebraska Class A - Breeder 99
Nebraska Class C - Exhibitor 29
Nebraska Class B - Dealer 19
Nebraska Class R - Research Facility 14
Nebraska Class T - Carrier 3
Nebraska Class H - Intermediate Handler 1
Nebraska Class G - Agricultural Research Facility ARS 1
Nevada Class C - Exhibitor 48
Nevada Class T - Carrier 16
Nevada Class A - Breeder 15
Nevada Class B - Dealer 8
Nevada Class R - Research Facility 5
Nevada Class H - Intermediate Handler 2
New Hampshire Class C - Exhibitor 30
New Hampshire Class A - Breeder 12
New Hampshire Class B - Dealer 6
New Hampshire Class R - Research Facility 4
New Hampshire Class T - Carrier 3
New Jersey Class C - Exhibitor 82
New Jersey Class R - Research Facility 25
New Jersey Class B - Dealer 25
New Jersey Class H - Intermediate Handler 9
New Jersey Class T - Carrier 7
New Jersey Class A - Breeder 5
New Mexico Class C - Exhibitor 28
New Mexico Class B - Dealer 15
New Mexico Class R - Research Facility 11
New Mexico Class A - Breeder 7
New Mexico Class T - Carrier 6
New Mexico Class H - Intermediate Handler 2
New Mexico Class G - Agricultural Research Facility ARS 1
New Mexico Class F - Federal Research Facility 1
New York Class C - Exhibitor 228
New York Class R - Research Facility 98
New York Class A - Breeder 98
New York Class B - Dealer 53
New York Class T - Carrier 44
New York Class H - Intermediate Handler 17
New York Class G - Agricultural Research Facility ARS 2
North Carolina Class C - Exhibitor 132
North Carolina Class B - Dealer 48
North Carolina Class R - Research Facility 42
North Carolina Class A - Breeder 20
North Carolina Class T - Carrier 14
North Carolina Class H - Intermediate Handler 1
North Dakota Class C - Exhibitor 21
North Dakota Class A - Breeder 7
North Dakota Class B - Dealer 6
North Dakota Class R - Research Facility 3
North Dakota Class G - Agricultural Research Facility ARS 3
North Dakota Class T - Carrier 1
North Dakota Class F - Federal Research Facility 1
Ohio Class A - Breeder 710
Ohio Class C - Exhibitor 127
Ohio Class B - Dealer 98
Ohio Class R - Research Facility 50
Ohio Class T - Carrier 20
Ohio Class H - Intermediate Handler 4
Oklahoma Class A - Breeder 356
Oklahoma Class C - Exhibitor 110
Oklahoma Class B - Dealer 57
Oklahoma Class R - Research Facility 18
Oklahoma Class T - Carrier 13
Oklahoma Class G - Agricultural Research Facility ARS 2
Oklahoma Class H - Intermediate Handler 1
Oregon Class C - Exhibitor 56
Oregon Class A - Breeder 28
Oregon Class B - Dealer 16
Oregon Class R - Research Facility 14
Oregon Class T - Carrier 7
Oregon Class H - Intermediate Handler 1
Pennsylvania Class A - Breeder 309
Pennsylvania Class C - Exhibitor 170
Pennsylvania Class B - Dealer 69
Pennsylvania Class R - Research Facility 66
Pennsylvania Class T - Carrier 18
Pennsylvania Class H - Intermediate Handler 7
Puerto Rico Class C - Exhibitor 27
Puerto Rico Class R - Research Facility 5
Puerto Rico Class B - Dealer 3
Rhode Island Class C - Exhibitor 10
Rhode Island Class R - Research Facility 8
Rhode Island Class B - Dealer 2
Rhode Island Class T - Carrier 1
Rhode Island Class A - Breeder 1
South Carolina Class C - Exhibitor 89
South Carolina Class B - Dealer 24
South Carolina Class A - Breeder 19
South Carolina Class T - Carrier 17
South Carolina Class R - Research Facility 14
South Carolina Class H - Intermediate Handler 2
South Dakota Class A - Breeder 67
South Dakota Class C - Exhibitor 17
South Dakota Class B - Dealer 15
South Dakota Class R - Research Facility 10
Tennessee Class C - Exhibitor 127
Tennessee Class B - Dealer 37
Tennessee Class A - Breeder 33
Tennessee Class T - Carrier 28
Tennessee Class R - Research Facility 25
Tennessee Class H - Intermediate Handler 2
Texas Class C - Exhibitor 390
Texas Class B - Dealer 180
Texas Class A - Breeder 173
Texas Class R - Research Facility 107
Texas Class T - Carrier 45
Texas Class H - Intermediate Handler 13
Texas Class G - Agricultural Research Facility ARS 5
Utah Class C - Exhibitor 48
Utah Class A - Breeder 19
Utah Class R - Research Facility 11
Utah Class B - Dealer 11
Utah Class T - Carrier 1
Utah Class H - Intermediate Handler 1
Utah Class G - Agricultural Research Facility ARS 1
Vermont Class R - Research Facility 7
Vermont Class C - Exhibitor 7
Vermont Class B - Dealer 1
Vermont Class A - Breeder 1
Virgin Islands, US Class C - Exhibitor 1
Virginia Class C - Exhibitor 125
Virginia Class A - Breeder 37
Virginia Class R - Research Facility 29
Virginia Class B - Dealer 26
Virginia Class T - Carrier 3
Virginia Class H - Intermediate Handler 2
Washington Class C - Exhibitor 55
Washington Class A - Breeder 34
Washington Class R - Research Facility 33
Washington Class B - Dealer 19
Washington Class T - Carrier 10
Washington Class H - Intermediate Handler 3
West Virginia Class C - Exhibitor 11
West Virginia Class R - Research Facility 7
West Virginia Class B - Dealer 7
West Virginia Class A - Breeder 6
West Virginia Class T - Carrier 2
West Virginia Class G - Agricultural Research Facility ARS 1
Wisconsin Class A - Breeder 223
Wisconsin Class C - Exhibitor 165
Wisconsin Class B - Dealer 47
Wisconsin Class R - Research Facility 36
Wisconsin Class T - Carrier 10
Wisconsin Class H - Intermediate Handler 7
Wisconsin Class G - Agricultural Research Facility ARS 2
Wyoming Class C - Exhibitor 8
Wyoming Class A - Breeder 5
Wyoming Class T - Carrier 4
Wyoming Class R - Research Facility 3
Wyoming Class B - Dealer 2
Powered by Datasette · Queries took 6.76ms · Privacy