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 →

60,365
inspected establishments in the imported dataset
76.1%
graded A, passed, or free of critical violations
5,952
graded C, failed, or cited for critical violations (9.9%)
2026-10-24
data refreshed

Inspection result across all cities and boroughs

A: 14,277 inspected establishments14,277AB: 886 inspected establishments886BC: 390 inspected establishments390CPass: 15,556 inspected establishments15,556PassPass with conditions: 1,986 inspected establishments1,986Pass w/ Condi…Fail: 2,952 inspected establishments2,952FailNo critical violations: 16,096 inspected establishments16,096No critical v…Critical violations: 2,610 inspected establishments2,610Critical viol…Not ready for inspection: 531 inspected establishments531Not ReadyNot yet graded (NYC): 1,685 inspected establishments1,685NGrade pending (NYC): 1,162 inspected establishments1,162ZGrade pending, re-opened (NYC): 83 inspected establishments83PUnknown: 2 inspected establishments2UnknownBusiness not located: 3 inspected establishments3Business Not …No entry on visit: 1,122 inspected establishments1,122No EntryOut of business: 1,024 inspected establishments1,024Out of Busine…
Count of inspected establishments by inspection result, all areas in our data.
inspection resultCountShare
A14,27723.7%
B8861.5%
C3900.6%
Pass15,55625.8%
Pass with conditions1,9863.3%
Fail2,9524.9%
No critical violations16,09626.7%
Critical violations2,6104.3%
Not ready for inspection5310.9%
Not yet graded (NYC)1,6852.8%
Grade pending (NYC)1,1621.9%
Grade pending, re-opened (NYC)830.1%
Unknown20%
Business not located30%
No entry on visit1,1221.9%
Out of business1,0241.7%

The total and full download include all 60,365 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 53,539 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
1BROCKPORT68100%0 (0%)
2SPENCERPORT60100%0 (0%)
3NEW ROCHELLE59100%0 (0%)
4LEWISTON55100%0 (0%)
5PITTSFORD54100%0 (0%)
6HENRIETTA32100%0 (0%)
7ENDWELL32100%0 (0%)
8RYE30100%0 (0%)
9DUNKIRK30100%0 (0%)
10YOUNGSTOWN29100%0 (0%)
11COHOES29100%0 (0%)
12EAST ROCHESTER26100%0 (0%)
13MAMARONECK25100%0 (0%)
14Austin area6,56899.5%33 (0.5%)
15KINGSTON14599.3%1 (0.7%)
16NORTH TONAWANDA14499.3%1 (0.7%)
17WHITE PLAINS8898.9%1 (1.1%)
18ENDICOTT6598.5%1 (1.5%)
19YONKERS12798.4%2 (1.6%)
20NEW PALTZ6098.3%1 (1.7%)
21LOCKPORT21898.2%4 (1.8%)
22FAIRPORT11098.2%2 (1.8%)
23SAUGERTIES5498.1%1 (1.9%)
24PENFIELD4497.7%1 (2.3%)
25SANBORN3697.2%1 (2.8%)
26GOSHEN3497.1%1 (2.9%)
27ELLICOTTVILLE3497.1%1 (2.9%)
28SCARSDALE3397%1 (3%)
29ROCHESTER1,69096.9%53 (3.1%)
30NEW HARTFORD6596.9%2 (3.1%)
31TARRYTOWN3296.9%1 (3.1%)
32Darien Center3196.8%1 (3.2%)
33NIAGARA FALLS36296.7%12 (3.3%)
34WEBSTER15396.7%5 (3.3%)
35WAPPINGERS FALLS3096.7%1 (3.3%)
36ROCKVILLE CENTRE3096.7%1 (3.3%)
37PAINTED POST3096.7%1 (3.3%)
38AUBURN8996.6%3 (3.4%)
39ROME8296.3%3 (3.7%)
40CORNING8096.3%3 (3.8%)
41CLINTON2796.3%1 (3.7%)
42Marcellus2696.2%1 (3.8%)
43COLD SPRING2696.2%1 (3.8%)
44WHITESBORO2596%1 (4%)
45BINGHAMTON21295.8%9 (4.2%)
46POUGHKEEPSIE11995%6 (5%)
47HILTON4095%2 (5%)
48MIDDLETOWN15894.9%8 (5.1%)
49WESTBURY3794.6%2 (5.4%)
50ALBANY19693.9%12 (6.1%)
51WARWICK4893.8%3 (6.3%)
52NEWBURGH13893.5%9 (6.5%)
53PORT JERVIS3193.5%2 (6.5%)
54CARMEL4593.3%3 (6.7%)
55NEW HYDE PARK3093.3%2 (6.7%)
56JAMESTOWN5692.9%4 (7.1%)
57STONY POINT2892.9%2 (7.1%)
58WATKINS GLEN4192.7%3 (7.3%)
59UTICA17692.6%13 (7.4%)
60OSSINING2692.3%2 (7.7%)
61Fayetteville3892.1%3 (7.9%)
62NEW WINDSOR5092%4 (8%)
63FISHKILL2592%2 (8%)
64HEMPSTEAD3691.7%3 (8.3%)
65LATHAM4791.5%4 (8.5%)
66VESTAL7091.4%6 (8.6%)
67CHESTER3290.6%3 (9.4%)
68WEST NYACK5290.4%5 (9.6%)
69JOHNSON CITY5290.4%5 (9.6%)
70HUDSON3190.3%3 (9.7%)
71HYDE PARK2889.3%3 (10.7%)
72BREWSTER5488.9%6 (11.1%)
73MONROE4588.9%5 (11.1%)
74Wellsville2788.9%3 (11.1%)
75SENECA FALLS2688.5%3 (11.5%)
76RHINEBECK2688.5%3 (11.5%)
77EAST MEADOW2688.5%3 (11.5%)
78FREDONIA2588%3 (12%)
79MAHOPAC4687%6 (13%)
80ITHACA19986.9%26 (13.1%)
81BATH3886.8%5 (13.2%)
82WATERTOWN10486.5%14 (13.5%)
83MALONE5286.5%7 (13.5%)
84MOUNT KISCO2785.2%4 (14.8%)
85Dewitt2785.2%4 (14.8%)
86Manlius4684.8%7 (15.2%)
87HAVERSTRAW3384.8%5 (15.2%)
88ELMIRA12284.4%19 (15.6%)
89Plattsburgh10284.3%16 (15.7%)
90NANUET5084%8 (16%)
91HORNELL5084%8 (16%)
92OWEGO2982.8%5 (17.2%)
93GLOVERSVILLE4682.6%8 (17.4%)
94WATERLOO2882.1%5 (17.9%)
95Liverpool12882%23 (18%)
96Baldwinsville7781.8%14 (18.2%)
97JOHNSTOWN4481.8%8 (18.2%)
98HUDSON FALLS3381.8%6 (18.2%)
99Syracuse87481%166 (19%)
100FULTON4281%8 (19%)
101NEW CITY6880.9%13 (19.1%)
102Massena4780.9%9 (19.1%)
103ROTTERDAM3680.6%7 (19.4%)
104HORSEHEADS6180.3%12 (19.7%)
105LOWVILLE2580%5 (20%)
106SPRING VALLEY9479.8%19 (20.2%)
107PEARL RIVER4979.6%10 (20.4%)
108CANASTOTA3979.5%8 (20.5%)
109MONSEY3479.4%7 (20.6%)
110Bronx1,70179.2%40 (2.4%)
111Manhattan6,96878.1%119 (1.7%)
112NYACK5377.4%12 (22.6%)
113RENSSELAER3177.4%7 (22.6%)
114GARDEN CITY3177.4%7 (22.6%)
115Brooklyn4,85477.2%97 (2%)
116BATAVIA4877.1%11 (22.9%)
117NORWICH3577.1%8 (22.9%)
118HAMILTON3976.9%9 (23.1%)
119ONEIDA6876.5%16 (23.5%)
120Staten Island63676.4%3 (0.5%)

Inspected establishments inspected per month

2025-10: 1,120 inspected establishments2025-11: 3,981 inspected establishments2025-12: 4,888 inspected establishments2026-01: 4,373 inspected establishments2026-02: 4,716 inspected establishments2026-03: 5,459 inspected establishments2026-04: 6,044 inspected establishments2026-05: 5,176 inspected establishments2026-06: 5,040 inspected establishments2026-07: 5,160 inspected establishments2026-08: 5,323 inspected establishments2026-09: 5,668 inspected establishments2026-10: 3,417 inspected establishments2025-102025-122026-022026-042026-062026-082026-103,417
Records by the month they were inspected, all areas.

Get every one of the 60,365 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-10-24 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