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
1KINGSTON144100%0 (0%)
2NEW ROCHELLE63100%0 (0%)
3SPENCERPORT61100%0 (0%)
4NEW PALTZ60100%0 (0%)
5ENDWELL33100%0 (0%)
6WESTBURY32100%0 (0%)
7YOUNGSTOWN30100%0 (0%)
8RYE30100%0 (0%)
9ROCKVILLE CENTRE30100%0 (0%)
10PAINTED POST30100%0 (0%)
11DUNKIRK30100%0 (0%)
12COHOES29100%0 (0%)
13ORANGEBURG27100%0 (0%)
14EAST ROCHESTER26100%0 (0%)
15WATERVLIET25100%0 (0%)
16MAMARONECK25100%0 (0%)
17Austin area6,31199.5%34 (0.5%)
18NORTH TONAWANDA15299.3%1 (0.7%)
19FAIRPORT11199.1%1 (0.9%)
20YONKERS13498.5%2 (1.5%)
21PITTSFORD5898.3%1 (1.7%)
22LOCKPORT21998.2%4 (1.8%)
23LEWISTON5798.2%1 (1.8%)
24SAUGERTIES5398.1%1 (1.9%)
25WHITE PLAINS9097.8%2 (2.2%)
26HILTON3897.4%1 (2.6%)
27BROCKPORT6897.1%2 (2.9%)
28ELLICOTTVILLE3597.1%1 (2.9%)
29ENDICOTT6697%2 (3%)
30NEW HARTFORD6496.9%2 (3.1%)
31NEW HYDE PARK3296.9%1 (3.1%)
32HENRIETTA3296.9%1 (3.1%)
33ROCHESTER1,70196.8%55 (3.2%)
34SCARSDALE3196.8%1 (3.2%)
35Darien Center3196.8%1 (3.2%)
36AUBURN9096.7%3 (3.3%)
37WAPPINGERS FALLS3096.7%1 (3.3%)
38ROME8096.3%3 (3.8%)
39COLD SPRING2796.3%1 (3.7%)
40CLINTON2796.3%1 (3.7%)
41NIAGARA FALLS37396.2%14 (3.8%)
42CORNING7896.2%3 (3.8%)
43BINGHAMTON22596%9 (4%)
44WEBSTER15196%6 (4%)
45WHITESBORO2596%1 (4%)
46LYNBROOK2596%1 (4%)
47POUGHKEEPSIE11995.8%5 (4.2%)
48WATKINS GLEN4195.1%2 (4.9%)
49SANBORN3994.9%2 (5.1%)
50Fayetteville3994.9%2 (5.1%)
51ALBANY19494.8%10 (5.2%)
52HEMPSTEAD3694.4%2 (5.6%)
53NEW WINDSOR4993.9%3 (6.1%)
54GOSHEN3393.9%2 (6.1%)
55MIDDLETOWN15693.6%10 (6.4%)
56NEWBURGH13893.5%9 (6.5%)
57MONROE4593.3%3 (6.7%)
58JAMESTOWN5793%4 (7%)
59PENFIELD4292.9%3 (7.1%)
60TARRYTOWN2892.9%2 (7.1%)
61STONY POINT2892.9%2 (7.1%)
62MOUNT KISCO2892.9%2 (7.1%)
63UTICA17692.6%13 (7.4%)
64RHINEBECK2792.6%2 (7.4%)
65JOHNSON CITY5292.3%4 (7.7%)
66OSSINING2692.3%2 (7.7%)
67BATH3892.1%3 (7.9%)
68ITHACA20192%16 (8%)
69FISHKILL2592%2 (8%)
70LATHAM4991.8%4 (8.2%)
71VESTAL7191.5%6 (8.5%)
72HUDSON3390.9%3 (9.1%)
73WEST NYACK5490.7%5 (9.3%)
74CARMEL4390.7%4 (9.3%)
75CHESTER3290.6%3 (9.4%)
76WARWICK4889.6%5 (10.4%)
77Wellsville2788.9%3 (11.1%)
78PEARL RIVER5388.7%6 (11.3%)
79HYDE PARK2688.5%3 (11.5%)
80SENECA FALLS2588%3 (12%)
81PORT JERVIS3287.5%4 (12.5%)
82WATERTOWN10387.4%13 (12.6%)
83MAHOPAC4687%6 (13%)
84MALONE5386.8%7 (13.2%)
85ELMIRA12186%17 (14%)
86BREWSTER5485.2%8 (14.8%)
87EAST MEADOW2785.2%4 (14.8%)
88Dewitt2785.2%4 (14.8%)
89Manlius4785.1%7 (14.9%)
90GLOVERSVILLE5084%8 (16%)
91NANUET4883.3%8 (16.7%)
92OWEGO3083.3%5 (16.7%)
93Plattsburgh10083%17 (17%)
94ROTTERDAM3582.9%6 (17.1%)
95HORNELL5282.7%9 (17.3%)
96HAVERSTRAW3482.4%6 (17.6%)
97HUDSON FALLS3381.8%6 (18.2%)
98LOWVILLE2781.5%5 (18.5%)
99Liverpool12981.4%24 (18.6%)
100FULTON4281%8 (19%)
101Massena4780.9%9 (19.1%)
102Baldwinsville7880.8%15 (19.2%)
103Syracuse88180.6%171 (19.4%)
104HORSEHEADS6280.6%12 (19.4%)
105HAMILTON4180.5%8 (19.5%)
106NYACK5680.4%11 (19.6%)
107JOHNSTOWN4580%9 (20%)
108NEW CITY6479.7%13 (20.3%)
109SPRING VALLEY9379.6%19 (20.4%)
110CANASTOTA3979.5%8 (20.5%)
111Bronx1,69778.9%38 (2.2%)
112ONEIDA6978.3%15 (21.7%)
113Manhattan6,96578.1%116 (1.7%)
114OLEAN7277.8%16 (22.2%)
115NORWICH3677.8%8 (22.2%)
116NEWARK2777.8%6 (22.2%)
117BATAVIA4977.6%11 (22.4%)
118Brooklyn4,84177.5%98 (2%)
119RENSSELAER3177.4%7 (22.6%)
120OSWEGO6076.7%14 (23.3%)

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