DataScoop.io
Build a list
Home / Lists and statistics / Restaurant inspection statistics by city and borough

Restaurant inspection statistics by city and borough

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.

Download the full inspected establishments list · $1.99Free 25-row preview · CSV, API or MCP · or $9.99 paid once for 12 months, no automatic renewal; up to 10 CSV downloads per day

Start with a popular city or borough

Restaurant inspection data across cities, in one table →

59,786
inspected establishments in the imported dataset
76.2%
graded A, passed, or free of critical violations
5,853
graded C, failed, or cited for critical violations (9.8%)
2026-11-14
data refreshed

Inspection result across all cities and boroughs

A: 14,298 inspected establishments14,298AB: 884 inspected establishments884BC: 388 inspected establishments388CPass: 15,071 inspected establishments15,071PassPass with conditions: 1,939 inspected establishments1,939Pass w/ Condi…Fail: 2,891 inspected establishments2,891FailNo critical violations: 16,216 inspected establishments16,216No critical v…Critical violations: 2,574 inspected establishments2,574Critical viol…Not ready for inspection: 525 inspected establishments525Not ReadyNot yet graded (NYC): 1,693 inspected establishments1,693NGrade pending (NYC): 1,152 inspected establishments1,152ZGrade pending, re-opened (NYC): 70 inspected establishments70PUnknown: 2 inspected establishments2UnknownBusiness not located: 3 inspected establishments3Business Not …No entry on visit: 1,078 inspected establishments1,078No EntryOut of business: 1,002 inspected establishments1,002Out of Busine…
Count of inspected establishments by inspection result, all areas in our data.
inspection resultCountShare
A14,29823.9%
B8841.5%
C3880.6%
Pass15,07125.2%
Pass with conditions1,9393.2%
Fail2,8914.8%
No critical violations16,21627.1%
Critical violations2,5744.3%
Not ready for inspection5250.9%
Not yet graded (NYC)1,6932.8%
Grade pending (NYC)1,1521.9%
Grade pending, re-opened (NYC)700.1%
Unknown20%
Business not located30%
No entry on visit1,0781.8%
Out of business1,0021.7%

The total and full download include all 59,786 matching records in this import. Type charts show up to eight categories; date charts use the displayed period and exclude missing or future dates. The area directory covers 52,965 records in 164 named cities and boroughs with at least 25 records each.

League table: cities and boroughs ranked by share graded A, passed, or free of critical violations

#city or boroughinspected establishmentsgraded A, passed, or free of critical violationsgraded C, failed, or cited for critical violations
121WATERLOO3076.7%7 (23.3%)
122AMSTERDAM6476.6%15 (23.4%)
123SARATOGA SPRINGS23876.5%56 (23.5%)
124MONSEY3476.5%8 (23.5%)
125Staten Island64176.4%3 (0.5%)
126ALEXANDRIA BAY2576%6 (24%)
127Queens4,33675.5%133 (3.1%)
128SUFFERN4975.5%12 (24.5%)
129TROY11275%28 (25%)
130GARDEN CITY3275%8 (25%)
131East Syracuse5974.6%15 (25.4%)
132LITTLE FALLS2774.1%7 (25.9%)
133Ogdensburg4173.2%11 (26.8%)
134Canton3773%10 (27%)
135Camillus5572.7%15 (27.3%)
136Skaneateles3470.6%10 (29.4%)
137QUEENSBURY7170.4%21 (29.6%)
138CANANDAIGUA7269.4%22 (30.6%)
139SCHENECTADY12369.1%38 (30.9%)
140VICTOR5768.4%18 (31.6%)
141CLIFTON PARK8268.3%26 (31.7%)
142CAZENOVIA2568%8 (32%)
143HERKIMER3767.6%12 (32.4%)
144SARANAC LAKE4667.4%15 (32.6%)
145TUPPER LAKE2766.7%9 (33.3%)
146ALBION2965.5%10 (34.5%)
147CORTLAND9364.5%33 (35.5%)
148GLENS FALLS5964.4%21 (35.6%)
149CHITTENANGO2864.3%10 (35.7%)
150ONEONTA4663%17 (37%)
151Cicero7962%30 (38%)
152COOPERSTOWN3161.3%12 (38.7%)
153PENN YAN3661.1%14 (38.9%)
154GENEVA5660.7%22 (39.3%)
155LAKE GEORGE9460.6%37 (39.4%)
156North Syracuse6857.4%29 (42.6%)
157BALLSTON SPA5056%22 (44%)
158MEDINA3455.9%15 (44.1%)
159Chicago16,15954.3%2,854 (17.7%)
160Monticello4553.3%21 (46.7%)
161Potsdam4052.5%19 (47.5%)
162LAKE PLACID8850%44 (50%)
163Liberty3250%16 (50%)
164CATSKILL3444.1%19 (55.9%)

Inspected establishments inspected per month

2025-11: 2,061 inspected establishments2025-12: 4,783 inspected establishments2026-01: 4,282 inspected establishments2026-02: 4,569 inspected establishments2026-03: 5,171 inspected establishments2026-04: 5,741 inspected establishments2026-05: 4,975 inspected establishments2026-06: 4,950 inspected establishments2026-07: 5,104 inspected establishments2026-08: 5,412 inspected establishments2026-09: 5,633 inspected establishments2026-10: 5,844 inspected establishments2026-11: 1,261 inspected establishments2025-112026-012026-032026-052026-072026-092026-111,261
Records by the month they were inspected, all areas.

Get every one of the 59,786 inspected establishments in this dataset as a list.

Preview the rows free. When they are right, download the full list for $1.99 one-off (no account), or get annual access at $9.99 paid once for 12 months, no automatic renewal and up to 10 CSV downloads per day; 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.

What the download contains: every matching row, 13 columns including Type, Address, Source, Inspection result, as a CSV dated 2026-11-14 with the source attribution. Not what you previewed? Email within 14 days for a fix or a refund.

Preview and download View inspected establishments dataset and CSV sample

Get the inspected establishments list in your code or your agent

curl "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").

Want wider coverage, or a heads-up when this list changes?

Leave your email and tell us what a full, filtered list of inspected establishments is worth to you — it shapes what we build and price next. No spam.

Find any of the 164 cities and boroughs

The ranked directory is split into fast, crawlable pages. Use the page links above, or search and filter the complete dataset in the explorer.

Search the complete dataset