Facilities with Most Violations

Facilities ranked by total critical + noncritical + direct violations across all inspections.

Custom SQL query returning 100 rows (hide) 

SELECT f.cert_number, f.legal_name, f.site_city, f.site_state, f.license_type, COUNT(*) AS total_inspections, SUM(i.critical_count) AS total_critical, SUM(i.noncritical_count) AS total_noncritical, SUM(i.direct_count) AS total_direct, SUM(i.critical_count) + SUM(i.noncritical_count) + SUM(i.direct_count) AS total_violations FROM inspections i JOIN facilities f ON f.cert_number = i.cert_number GROUP BY i.cert_number HAVING total_violations > 0 ORDER BY total_violations DESC LIMIT 100

Edit SQL

This data as json, CSV

cert_numberlegal_namesite_citysite_statelicense_typetotal_inspectionstotal_criticaltotal_noncriticaltotal_directtotal_violations
34-C-0227 SUMMER WIND FARM SANCTUARY BROWN CITY Michigan Class C - Exhibitor 44 26 185 33 244
42-A-1632 DANIEL GINGERICH SEYMOUR Iowa Class A - Breeder 26 3 175 24 202
34-C-0169 Richard Evola Hillsdale Michigan Class C - Exhibitor 53 3 143 10 156
55-B-0069 Henry Hampton MOORESVILLE North Carolina Class B - Dealer 58 2 144 9 155
51-C-0111 DEER HAVEN MINI ZOO KEYMAR Maryland Class C - Exhibitor 17 11 133 9 153
31-A-0031 Craig Kokas PROSPECT Ohio Class A - Breeder 38 9 85 32 126
41-B-0239 DAN MOULTON CHATFIELD Minnesota Class B - Dealer 48 2 68 50 120
42-C-0084 THOMAS SELLNER PAMELA SELLNER MANCHESTER Iowa Class C - Exhibitor 31 1 113 6 120
63-B-0180 Wilson Horse and Mule Sale Inc Cookeville Tennessee Class B - Dealer 36 2 98 5 105
74-B-0708 Daniel Pradon Bobbi Pradon ODESSA Texas Class B - Dealer 21 10 69 26 105
91-C-0138 Kirsty Lee L L C KENMORE Washington Class C - Exhibitor 17 5 83 17 105
21-C-0384 SALLY REAVES WALWORTH New York Class C - Exhibitor 23 6 81 17 104
63-C-0201 Shirley Farms OBION Tennessee Class C - Exhibitor 35 2 89 7 98
34-B-0225 Zachery Keeler Temperance Michigan Class B - Dealer 44 13 70 11 94
73-C-0122 William Meadows Tuttle Oklahoma Class C - Exhibitor 41 19 68 7 94
73-C-0190 Arbuckle Adventures LLC DAVIS Oklahoma Class C - Exhibitor 46 20 63 10 93
42-A-1471 Carolyn Anderson MASON CITY Iowa Class A - Breeder 24 2 85 4 91
86-C-0102 TERRILL AL-SAIHATI YUMA Arizona Class C - Exhibitor 29 4 73 11 88
64-R-0102 Blue Ridge Kennel WETUMPKA Alabama Class R - Research Facility 30 3 71 13 87
34-C-0146 CRITTER BARN ZEELAND Michigan Class C - Exhibitor 31 0 83 3 86
42-A-1329 HENRY SOMMERS CINCINNATI Iowa Class A - Breeder 41 1 72 11 84
92-C-0181 West Coast Game Park Inc Bandon Oregon Class C - Exhibitor 31 7 69 6 82
94-C-0114 Zoologico De Puerto Rico Dr Juan A Rivero MAYAGUEZ Puerto Rico Class C - Exhibitor 17 3 74 4 81
52-B-0175 Elena and Andrey Mikirtichev RICHMOND Virginia Class B - Dealer 19 3 62 15 80
52-C-0035 KARL MOGENSEN NATURAL BRIDGE Virginia Class C - Exhibitor 26 0 68 11 79
74-A-1451 Tyler Cleckley SWEENY Texas Class A - Breeder 15 1 71 6 78
74-C-0153 Clinton Wolston I I I ALVIN Texas Class C - Exhibitor 24 6 62 9 77
74-C-1052 Peeps And Creeps MIDLAND Texas Class C - Exhibitor 25 5 69 0 74
64-C-0178 THE MOBILE ZOO WILMER Alabama Class C - Exhibitor 12 1 70 1 72
67-C-0003 Marek Lipold BOGART Georgia Class C - Exhibitor 12 2 68 1 71
31-B-0031 Mount Hope Auction Inc MOUNT HOPE Ohio Class B - Dealer 24 7 58 5 70
64-B-0103 256 Exotics LLC Huntsville Alabama Class B - Dealer 12 5 61 4 70
43-A-2656 Wilma Jinson STELLA Missouri Class A - Breeder 19 1 57 9 67
58-C-1252 MS Leisure Company, Inc. Miami Florida Class C - Exhibitor 28 9 54 4 67
52-C-0294 Christy Davis GLEN ALLEN Virginia Class C - Exhibitor 17 0 57 9 66
55-C-0322 Patrick Milcendeau Vass North Carolina Class C - Exhibitor 15 3 57 5 65
32-C-0224 VERNON MILLER SHIPSHEWANA Indiana Class C - Exhibitor 25 2 54 8 64
84-C-0069 NICK SCULAC CALHAN Colorado Class C - Exhibitor 17 5 55 4 64
42-B-0052 Ruby Fur Farm Inc New Sharon Iowa Class B - Dealer 39 1 49 12 62
55-C-0272 Zootastic of Lake Norman Inc Cameron North Carolina Class C - Exhibitor 63 2 57 3 62
73-C-0230 JEFFREY LOWE THACKERVILLE Oklahoma Class C - Exhibitor 15 3 49 10 62
41-A-0298 S GLENICE VIKEN ROSEAU Minnesota Class A - Breeder 16 6 54 0 60
64-C-0003 Montgomery Zoo Montgomery Alabama Class C - Exhibitor 30 8 51 1 60
87-C-0061 Sherrie Ivie GRANTSVILLE Utah Class C - Exhibitor 32 6 48 6 60
63-C-0247 BRIARWOOD RANCH BYBEE Tennessee Class C - Exhibitor 16 0 45 14 59
64-C-0185 MIKE MC CLELLAND BANKS Alabama Class C - Exhibitor 12 0 57 2 59
23-A-0641 MALINDA KING DAVID KING KIRKWOOD Pennsylvania Class A - Breeder 20 1 49 8 58
35-B-0214 Dawn Hofferber Weyauwega Wisconsin Class B - Dealer 33 6 45 7 58
34-C-0440 April Cicchelli Ryan Cicchelli LAKE CITY Michigan Class C - Exhibitor 15 5 44 8 57
57-C-0374 Carousel Properties LLC Loganville Georgia Class C - Exhibitor 6 2 55 0 57
63-B-0182 Six Shooters Investment Group LLC Madison Florida Class B - Dealer 21 1 50 6 57
32-A-0774 Envigo RMS LLC Greenfield Indiana Class A - Breeder 36 4 30 22 56
34-C-0183 Terry Anderson Stanton Michigan Class C - Exhibitor 38 7 44 4 55
84-C-0088 WILLIAM LEE IDAHO SPRINGS Colorado Class C - Exhibitor 23 5 48 2 55
23-C-0019 Pymatuning Deer Park Jamestown Pennsylvania Class C - Exhibitor 24 7 42 5 54
31-C-0221 ROBERT SAWMILLER PORTLAND Indiana Class C - Exhibitor 31 3 34 17 54
43-A-5445 Ellen Roberts WEST PLAINS Missouri Class A - Breeder 35 0 49 4 53
58-C-0992 Gulf World Marine Park Inc Panama City Beach Florida Class C - Exhibitor 24 5 48 0 53
58-C-1117 Single Vision Inc. MELROSE Florida Class C - Exhibitor 26 6 45 2 53
88-C-0216 SeaQuest Holdings, LLC LAYTON Utah Class C - Exhibitor 81 6 47 0 53
63-B-0183 DAVID MANSER DAYTON Tennessee Class B - Dealer 16 1 46 5 52
33-B-0435 Thomas Edmonds WEST UNION Illinois Class B - Dealer 14 3 46 2 51
58-C-1007 The Care Foundation APOPKA Florida Class C - Exhibitor 19 0 50 1 51
23-C-0153 East Coast Exotic Animal Rescue Inc Fairfield Pennsylvania Class C - Exhibitor 30 2 47 1 50
72-C-0238 Barn Hill Preserve Inc ETHEL Louisiana Class C - Exhibitor 35 5 40 5 50
85-C-0006 City Of Clovis CLOVIS New Mexico Class C - Exhibitor 25 3 46 1 50
93-C-0504 Roberta Kirshner OROVILLE California Class C - Exhibitor 40 3 43 4 50
23-B-0200 Real Pets Corp Reading Pennsylvania Class B - Dealer 29 0 41 8 49
51-A-0016 JERRY HOLLY UPPER MARLBORO Maryland Class A - Breeder 21 1 48 0 49
71-C-0151 Wild Wilderness Inc GENTRY Arkansas Class C - Exhibitor 29 1 46 2 49
43-A-4762 PAMELA L. BALDWIN EDGAR SPRINGS Missouri Class A - Breeder 33 0 45 3 48
55-C-0294 Exotic Animal Exhibits LLC Pinetops North Carolina Class C - Exhibitor 26 3 45 0 48
56-C-0115 Hollywild Animal Park Inc Wellford South Carolina Class C - Exhibitor 31 5 40 3 48
57-C-0037 Noahs Ark Animal Rehab Center and Sanctuary Inc LOCUST GROVE Georgia Class C - Exhibitor 19 2 42 4 48
58-C-1052 Emerald Coast Wildlife Refuge Navarre Florida Class C - Exhibitor 22 1 46 1 48
23-A-0577 MOSE ZOOK DELTA Pennsylvania Class A - Breeder 37 2 39 6 47
52-C-0166 Virginia Safari Park NATURAL BRIDGE Virginia Class C - Exhibitor 49 4 42 1 47
52-C-0038 WILSONS WILD ANIMAL PARK WINCHESTER Virginia Class C - Exhibitor 16 1 44 1 46
55-C-0138 Terry K Beal Maiden North Carolina Class C - Exhibitor 28 2 43 1 46
23-A-0596 Levi King MILL HALL Pennsylvania Class A - Breeder 28 0 40 5 45
31-C-0050 Stump Hill Farm Navarre Ohio Class C - Exhibitor 18 1 43 1 45
43-B-3620 JOSH L. SOUZA PHILLIPSBURG Missouri Class B - Dealer 20 0 37 8 45
65-C-0566 John Mark Johnson BLUE SPRINGS Mississippi Class C - Exhibitor 25 4 32 9 45
48-C-0140 City of Dodge City DODGE CITY Kansas Class C - Exhibitor 23 0 43 1 44
58-C-0667 Jungle Friends Primate Sanctuary GAINESVILLE Florida Class C - Exhibitor 20 5 38 1 44
58-C-1114 James Oleson Brooksville Florida Class C - Exhibitor 24 2 40 2 44
74-C-0939 Jason Clay Franklin Texas Class C - Exhibitor 33 1 41 2 44
43-A-5947 CORY MINCEY ELKLAND Missouri Class A - Breeder 22 1 32 10 43
58-B-0579 A & A Exotics LLC LAKE CITY Florida Class B - Dealer 7 1 42 0 43
58-C-0460 Zooworld Zoological & Botanical Conservatory PANAMA CITY BEACH Florida Class C - Exhibitor 21 1 42 0 43
73-C-0139 JOSEPH MALDONADO PASSAGE WYNNEWOOD Oklahoma Class C - Exhibitor 23 7 36 0 43
42-B-0182 Steve Kruse WEST POINT Iowa Class B - Dealer 52 1 30 11 42
48-C-0017 City of Clay Center Clay Center Kansas Class C - Exhibitor 27 1 39 2 42
48-C-0163 Jessica Mason Janell Knudsen LIBERAL Kansas Class C - Exhibitor 10 0 42 0 42
74-A-1531 Patricia Bingham ALVIN Texas Class A - Breeder 17 0 33 9 42
91-C-0151 Ellen Strom Ray Strom Arlington Washington Class C - Exhibitor 16 2 40 0 42
21-C-0432 Hidden Valley Animal Adventure VARYSBURG New York Class C - Exhibitor 20 1 39 1 41
74-C-0728 Megan Guardiola RED OAK Texas Class C - Exhibitor 17 0 40 1 41
84-R-0003 Colorado State University FORT COLLINS Colorado Class R - Research Facility 25 6 34 1 41
85-R-0003 Lovelace Biomedical Research Institute Albuquerque New Mexico Class R - Research Facility 28 14 27 0 41