Public health departments publish every restaurant inspection they carry out. These free pages bring New York City, Chicago, New York State and Austin together and break the results down by city and borough, so you can compare areas, see who failed recently, and download the full list for any area.
| inspection result | Count | Share |
|---|---|---|
| A | 13,975 | 26.8% |
| B | 977 | 1.9% |
| C | 498 | 1% |
| Pass | 14,317 | 27.5% |
| Pass with conditions | 2,005 | 3.8% |
| Fail | 2,929 | 5.6% |
| No critical violations | 16,066 | 30.8% |
| Critical violations | 2,560 | 4.9% |
| Not ready for inspection | 542 | 1% |
| Not yet graded (NYC) | 1,648 | 3.2% |
| Grade pending (NYC) | 1,045 | 2% |
| Grade pending, re-opened (NYC) | 93 | 0.2% |
| Business not located | 2 | 0% |
| No entry on visit | 1,170 | 2.2% |
| Out of business | 1,071 | 2.1% |
| # | city or borough | inspected establishments | graded A, passed, or free of critical violations | graded C, failed, or cited for critical violations |
|---|---|---|---|---|
| 1 | NEW ROCHELLE | 70 | 100% | 0 (0%) |
| 2 | BROCKPORT | 68 | 100% | 0 (0%) |
| 3 | NEW PALTZ | 55 | 100% | 0 (0%) |
| 4 | LEWISTON | 51 | 100% | 0 (0%) |
| 5 | WARWICK | 48 | 100% | 0 (0%) |
| 6 | SANBORN | 36 | 100% | 0 (0%) |
| 7 | CHESTER | 32 | 100% | 0 (0%) |
| 8 | HILTON | 31 | 100% | 0 (0%) |
| 9 | PORT CHESTER | 25 | 100% | 0 (0%) |
| 10 | NEW HYDE PARK | 25 | 100% | 0 (0%) |
| 11 | MAMARONECK | 25 | 100% | 0 (0%) |
| 12 | LYNBROOK | 25 | 100% | 0 (0%) |
| 13 | Austin area | 5,379 | 99.4% | 31 (0.6%) |
| 14 | KINGSTON | 143 | 99.3% | 1 (0.7%) |
| 15 | NORTH TONAWANDA | 144 | 98.6% | 2 (1.4%) |
| 16 | SPENCERPORT | 61 | 98.4% | 1 (1.6%) |
| 17 | SAUGERTIES | 54 | 98.1% | 1 (1.9%) |
| 18 | NEW WINDSOR | 51 | 98% | 1 (2%) |
| 19 | PENFIELD | 49 | 98% | 1 (2%) |
| 20 | LOCKPORT | 211 | 97.6% | 5 (2.4%) |
| 21 | YONKERS | 122 | 97.5% | 3 (2.5%) |
| 22 | WESTBURY | 40 | 97.5% | 1 (2.5%) |
| 23 | ROCHESTER | 1,664 | 97.3% | 45 (2.7%) |
| 24 | GOSHEN | 35 | 97.1% | 1 (2.9%) |
| 25 | PORT JERVIS | 33 | 97% | 1 (3%) |
| 26 | WHITE PLAINS | 96 | 96.9% | 3 (3.1%) |
| 27 | NEW HARTFORD | 64 | 96.9% | 2 (3.1%) |
| 28 | SCARSDALE | 32 | 96.9% | 1 (3.1%) |
| 29 | ENDWELL | 31 | 96.8% | 1 (3.2%) |
| 30 | NIAGARA FALLS | 366 | 96.7% | 12 (3.3%) |
| 31 | CLINTON | 30 | 96.7% | 1 (3.3%) |
| 32 | POUGHKEEPSIE | 119 | 96.6% | 4 (3.4%) |
| 33 | AUBURN | 88 | 96.6% | 3 (3.4%) |
| 34 | PITTSFORD | 59 | 96.6% | 2 (3.4%) |
| 35 | DUNKIRK | 29 | 96.6% | 1 (3.4%) |
| 36 | COHOES | 29 | 96.6% | 1 (3.4%) |
| 37 | ROME | 81 | 96.3% | 3 (3.7%) |
| 38 | YOUNGSTOWN | 27 | 96.3% | 1 (3.7%) |
| 39 | RHINEBECK | 26 | 96.2% | 1 (3.8%) |
| 40 | OCEANSIDE | 26 | 96.2% | 1 (3.8%) |
| 41 | Marcellus | 26 | 96.2% | 1 (3.8%) |
| 42 | BINGHAMTON | 207 | 96.1% | 8 (3.9%) |
| 43 | WEBSTER | 151 | 96% | 6 (4%) |
| 44 | FREDONIA | 25 | 96% | 1 (4%) |
| 45 | MIDDLETOWN | 155 | 95.5% | 7 (4.5%) |
| 46 | ENDICOTT | 66 | 95.5% | 3 (4.5%) |
| 47 | FAIRPORT | 109 | 94.5% | 6 (5.5%) |
| 48 | ELLICOTTVILLE | 35 | 94.3% | 2 (5.7%) |
| 49 | ALBANY | 209 | 93.8% | 13 (6.2%) |
| 50 | CORNING | 79 | 93.7% | 5 (6.3%) |
| 51 | UTICA | 168 | 93.5% | 11 (6.5%) |
| 52 | WAPPINGERS FALLS | 31 | 93.5% | 2 (6.5%) |
| 53 | TARRYTOWN | 31 | 93.5% | 2 (6.5%) |
| 54 | MONROE | 45 | 93.3% | 3 (6.7%) |
| 55 | NEWBURGH | 142 | 93% | 10 (7%) |
| 56 | Wellsville | 27 | 92.6% | 2 (7.4%) |
| 57 | SENECA FALLS | 26 | 92.3% | 2 (7.7%) |
| 58 | OSSINING | 26 | 92.3% | 2 (7.7%) |
| 59 | HICKSVILLE | 25 | 92% | 2 (8%) |
| 60 | FISHKILL | 25 | 92% | 2 (8%) |
| 61 | JOHNSON CITY | 49 | 91.8% | 4 (8.2%) |
| 62 | JAMESTOWN | 60 | 91.7% | 5 (8.3%) |
| 63 | CARMEL | 48 | 91.7% | 4 (8.3%) |
| 64 | HEMPSTEAD | 36 | 91.7% | 3 (8.3%) |
| 65 | VESTAL | 71 | 91.5% | 6 (8.5%) |
| 66 | LATHAM | 47 | 91.5% | 4 (8.5%) |
| 67 | MONSEY | 34 | 91.2% | 3 (8.8%) |
| 68 | WEST NYACK | 56 | 91.1% | 5 (8.9%) |
| 69 | SPRING VALLEY | 94 | 90.4% | 9 (9.6%) |
| 70 | BREWSTER | 51 | 90.2% | 5 (9.8%) |
| 71 | MOUNT KISCO | 29 | 89.7% | 3 (10.3%) |
| 72 | Fayetteville | 38 | 89.5% | 4 (10.5%) |
| 73 | MAHOPAC | 47 | 89.4% | 5 (10.6%) |
| 74 | HYDE PARK | 28 | 89.3% | 3 (10.7%) |
| 75 | Dewitt | 28 | 89.3% | 3 (10.7%) |
| 76 | NYACK | 59 | 88.1% | 7 (11.9%) |
| 77 | ITHACA | 191 | 88% | 23 (12%) |
| 78 | LEVITTOWN | 25 | 88% | 3 (12%) |
| 79 | FULTON | 39 | 87.2% | 5 (12.8%) |
| 80 | HENRIETTA | 30 | 86.7% | 4 (13.3%) |
| 81 | PAINTED POST | 29 | 86.2% | 4 (13.8%) |
| 82 | Baldwinsville | 77 | 85.7% | 11 (14.3%) |
| 83 | HAVERSTRAW | 35 | 85.7% | 5 (14.3%) |
| 84 | MALONE | 48 | 85.4% | 7 (14.6%) |
| 85 | LOWVILLE | 27 | 85.2% | 4 (14.8%) |
| 86 | EAST MEADOW | 26 | 84.6% | 4 (15.4%) |
| 87 | Plattsburgh | 102 | 84.3% | 16 (15.7%) |
| 88 | PEARL RIVER | 51 | 84.3% | 8 (15.7%) |
| 89 | NORWICH | 36 | 83.3% | 6 (16.7%) |
| 90 | WATERTOWN | 107 | 83.2% | 18 (16.8%) |
| 91 | Manlius | 47 | 83% | 8 (17%) |
| 92 | GLOVERSVILLE | 47 | 83% | 8 (17%) |
| 93 | ELMIRA | 122 | 82.8% | 21 (17.2%) |
| 94 | WATERLOO | 29 | 82.8% | 5 (17.2%) |
| 95 | Syracuse | 873 | 82.2% | 155 (17.8%) |
| 96 | STONY POINT | 28 | 82.1% | 5 (17.9%) |
| 97 | SUFFERN | 50 | 82% | 9 (18%) |
| 98 | JOHNSTOWN | 44 | 81.8% | 8 (18.2%) |
| 99 | HUDSON FALLS | 33 | 81.8% | 6 (18.2%) |
| 100 | NEW CITY | 71 | 81.7% | 13 (18.3%) |
| 101 | Liverpool | 124 | 81.5% | 23 (18.5%) |
| 102 | HORSEHEADS | 59 | 81.4% | 11 (18.6%) |
| 103 | CANASTOTA | 43 | 81.4% | 8 (18.6%) |
| 104 | BATH | 37 | 81.1% | 7 (18.9%) |
| 105 | ORANGEBURG | 26 | 80.8% | 5 (19.2%) |
| 106 | WATKINS GLEN | 41 | 80.5% | 8 (19.5%) |
| 107 | ROTTERDAM | 34 | 79.4% | 7 (20.6%) |
| 108 | BATAVIA | 48 | 79.2% | 10 (20.8%) |
| 109 | NANUET | 56 | 78.6% | 12 (21.4%) |
| 110 | HORNELL | 51 | 78.4% | 11 (21.6%) |
| 111 | HUDSON | 41 | 78% | 9 (22%) |
| 112 | Bronx | 1,673 | 77.9% | 47 (2.8%) |
| 113 | Manhattan | 6,900 | 77.8% | 166 (2.4%) |
| 114 | WANTAGH | 27 | 77.8% | 6 (22.2%) |
| 115 | Brooklyn | 4,743 | 77% | 125 (2.6%) |
| 116 | ONEIDA | 69 | 76.8% | 16 (23.2%) |
| 117 | NEWARK | 25 | 76% | 6 (24%) |
| 118 | OSWEGO | 58 | 75.9% | 14 (24.1%) |
| 119 | CAZENOVIA | 29 | 75.9% | 7 (24.1%) |
| 120 | GARDEN CITY | 33 | 75.8% | 8 (24.2%) |
| 121 | Staten Island | 669 | 75.5% | 12 (1.8%) |
| 122 | SARATOGA SPRINGS | 220 | 75% | 55 (25%) |
| 123 | Camillus | 52 | 75% | 13 (25%) |
| 124 | RENSSELAER | 32 | 75% | 8 (25%) |
| 125 | HAMILTON | 39 | 74.4% | 10 (25.6%) |
| 126 | ALBION | 31 | 74.2% | 8 (25.8%) |
| 127 | OLEAN | 77 | 74% | 20 (26%) |
| 128 | Queens | 4,234 | 73.9% | 148 (3.5%) |
| 129 | TROY | 128 | 73.4% | 34 (26.6%) |
| 130 | East Syracuse | 60 | 73.3% | 16 (26.7%) |
| 131 | LITTLE FALLS | 26 | 73.1% | 7 (26.9%) |
| 132 | ALEXANDRIA BAY | 26 | 73.1% | 7 (26.9%) |
| 133 | VICTOR | 59 | 72.9% | 16 (27.1%) |
| 134 | Ogdensburg | 40 | 72.5% | 11 (27.5%) |
| 135 | Cicero | 79 | 72.2% | 22 (27.8%) |
| 136 | HERKIMER | 36 | 72.2% | 10 (27.8%) |
| 137 | Massena | 43 | 72.1% | 12 (27.9%) |
| 138 | Skaneateles | 39 | 71.8% | 11 (28.2%) |
| 139 | SARANAC LAKE | 46 | 71.7% | 13 (28.3%) |
| 140 | AMSTERDAM | 63 | 69.8% | 19 (30.2%) |
| 141 | SCHENECTADY | 124 | 69.4% | 38 (30.6%) |
| 142 | PENN YAN | 36 | 69.4% | 11 (30.6%) |
| 143 | Canton | 36 | 69.4% | 11 (30.6%) |
| 144 | CHITTENANGO | 29 | 69% | 9 (31%) |
| 145 | CLIFTON PARK | 80 | 68.8% | 25 (31.3%) |
| 146 | COOPERSTOWN | 32 | 68.8% | 10 (31.3%) |
| 147 | TUPPER LAKE | 25 | 68% | 8 (32%) |
| 148 | North Syracuse | 70 | 67.1% | 23 (32.9%) |
| 149 | QUEENSBURY | 72 | 66.7% | 24 (33.3%) |
| 150 | CANANDAIGUA | 72 | 66.7% | 24 (33.3%) |
| 151 | CORTLAND | 94 | 64.9% | 33 (35.1%) |
| 152 | ONEONTA | 55 | 63.6% | 20 (36.4%) |
| 153 | MEDINA | 33 | 63.6% | 12 (36.4%) |
| 154 | BALLSTON SPA | 40 | 60% | 16 (40%) |
| 155 | LAKE GEORGE | 89 | 58.4% | 37 (41.6%) |
| 156 | Monticello | 42 | 54.8% | 19 (45.2%) |
| 157 | Chicago | 16,617 | 53.8% | 2,895 (17.4%) |
| 158 | GENEVA | 54 | 53.7% | 25 (46.3%) |
| 159 | LAKE PLACID | 87 | 51.7% | 42 (48.3%) |
| 160 | Potsdam | 39 | 51.3% | 19 (48.7%) |
| 161 | GLENS FALLS | 60 | 50% | 30 (50%) |
| 162 | CATSKILL | 33 | 42.4% | 19 (57.6%) |
| 163 | Liberty | 35 | 34.3% | 23 (65.7%) |
Preview the rows free. When they are right, download the full list for £4.99 one-off (no account), or go unlimited at £19/mo; it opens in Excel and imports into Google Sheets or any CRM. Or pull it straight into your code or your AI agent via the API or MCP.
Preview and download About this datasetcurl "https://datascoop.io/v1/datasets/us-food-inspections/query?format=csv" \ -H "Authorization: Bearer YOUR_KEY"
Or connect an MCP client (setup) and call query_dataset for this dataset. Google Sheets: =IMPORTDATA("https://datascoop.io/v1/datasets/us-food-inspections/query?format=csv&api_key=YOUR_KEY").