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,169
inspected establishments in the imported dataset
75.9%
graded A, passed, or free of critical violations
6,003
graded C, failed, or cited for critical violations (10%)
2026-10-04
data refreshed

Inspection result across all cities and boroughs

A: 14,196 inspected establishments14,196AB: 927 inspected establishments927BC: 431 inspected establishments431CPass: 15,518 inspected establishments15,518PassPass with conditions: 2,007 inspected establishments2,007Pass w/ Condi…Fail: 2,946 inspected establishments2,946FailNo critical violations: 15,928 inspected establishments15,928No critical v…Critical violations: 2,626 inspected establishments2,626Critical viol…Not ready for inspection: 526 inspected establishments526Not ReadyNot yet graded (NYC): 1,648 inspected establishments1,648NGrade pending (NYC): 1,123 inspected establishments1,123ZGrade pending, re-opened (NYC): 82 inspected establishments82PBusiness not located: 3 inspected establishments3Business Not …No entry on visit: 1,141 inspected establishments1,141No EntryOut of business: 1,067 inspected establishments1,067Out of Busine…
Count of inspected establishments by inspection result, all areas in our data.
inspection resultCountShare
A14,19623.6%
B9271.5%
C4310.7%
Pass15,51825.8%
Pass with conditions2,0073.3%
Fail2,9464.9%
No critical violations15,92826.5%
Critical violations2,6264.4%
Not ready for inspection5260.9%
Not yet graded (NYC)1,6482.7%
Grade pending (NYC)1,1231.9%
Grade pending, re-opened (NYC)820.1%
Business not located30%
No entry on visit1,1411.9%
Out of business1,0671.8%

The total and full download include all 60,169 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,378 records in 163 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
1KINGSTON141100%0 (0%)
2BROCKPORT68100%0 (0%)
3NEW ROCHELLE61100%0 (0%)
4PITTSFORD54100%0 (0%)
5LEWISTON54100%0 (0%)
6PENFIELD42100%0 (0%)
7SANBORN34100%0 (0%)
8HENRIETTA31100%0 (0%)
9RYE30100%0 (0%)
10ENDWELL29100%0 (0%)
11DUNKIRK29100%0 (0%)
12NEW HYDE PARK27100%0 (0%)
13YOUNGSTOWN26100%0 (0%)
14WHITESBORO25100%0 (0%)
15MAMARONECK25100%0 (0%)
16LYNBROOK25100%0 (0%)
17Austin area6,51099.5%32 (0.5%)
18ENDICOTT6198.4%1 (1.6%)
19YONKERS11998.3%2 (1.7%)
20SAUGERTIES5498.1%1 (1.9%)
21NORTH TONAWANDA14197.9%3 (2.1%)
22WHITE PLAINS9397.8%2 (2.2%)
23LOCKPORT21797.7%5 (2.3%)
24POUGHKEEPSIE11997.5%3 (2.5%)
25WESTBURY3797.3%1 (2.7%)
26ELLICOTTVILLE3597.1%1 (2.9%)
27SCARSDALE3497.1%1 (2.9%)
28GOSHEN3397%1 (3%)
29NEW HARTFORD6596.9%2 (3.1%)
30Darien Center3196.8%1 (3.2%)
31SPENCERPORT6096.7%2 (3.3%)
32WAPPINGERS FALLS3096.7%1 (3.3%)
33WEBSTER14696.6%5 (3.4%)
34NEW PALTZ5996.6%2 (3.4%)
35COHOES2996.6%1 (3.4%)
36ROME8396.4%3 (3.6%)
37ROCHESTER1,65896.3%62 (3.7%)
38NIAGARA FALLS35696.3%13 (3.7%)
39FREDONIA2696.2%1 (3.8%)
40CLINTON2696.2%1 (3.8%)
41OCEANSIDE2596%1 (4%)
42Marcellus2596%1 (4%)
43BINGHAMTON19595.9%8 (4.1%)
44WARWICK4895.8%2 (4.2%)
45FAIRPORT11294.6%6 (5.4%)
46AUBURN8794.3%5 (5.7%)
47HILTON3594.3%2 (5.7%)
48NEW WINDSOR5194.1%3 (5.9%)
49CORNING8093.8%5 (6.3%)
50PORT JERVIS3293.8%2 (6.3%)
51CHESTER3293.8%2 (6.3%)
52ALBANY19993.5%13 (6.5%)
53CARMEL4693.5%3 (6.5%)
54TARRYTOWN3193.5%2 (6.5%)
55MONROE4593.3%3 (6.7%)
56JAMESTOWN5993.2%4 (6.8%)
57PAINTED POST2993.1%2 (6.9%)
58MIDDLETOWN15893%11 (7%)
59STONY POINT2892.9%2 (7.1%)
60WATKINS GLEN4192.7%3 (7.3%)
61UTICA17492.5%13 (7.5%)
62VESTAL6792.5%5 (7.5%)
63OSSINING2692.3%2 (7.7%)
64COLD SPRING2692.3%2 (7.7%)
65Fayetteville3892.1%3 (7.9%)
66HICKSVILLE2592%2 (8%)
67LATHAM4891.7%4 (8.3%)
68HEMPSTEAD3691.7%3 (8.3%)
69WEST NYACK5691.1%5 (8.9%)
70BREWSTER5290.4%5 (9.6%)
71JOHNSON CITY5190.2%5 (9.8%)
72NEWBURGH14190.1%14 (9.9%)
73HYDE PARK2889.3%3 (10.7%)
74MAHOPAC4689.1%5 (10.9%)
75SENECA FALLS2788.9%3 (11.1%)
76Wellsville2688.5%3 (11.5%)
77EAST MEADOW2688.5%3 (11.5%)
78MONSEY3488.2%4 (11.8%)
79FULTON4288.1%5 (11.9%)
80FISHKILL2588%3 (12%)
81HAVERSTRAW3387.9%4 (12.1%)
82SPRING VALLEY9487.2%12 (12.8%)
83Manlius4687%6 (13%)
84MALONE5286.5%7 (13.5%)
85HUDSON3686.1%5 (13.9%)
86MOUNT KISCO2885.7%4 (14.3%)
87ITHACA19785.3%29 (14.7%)
88LOWVILLE2785.2%4 (14.8%)
89Dewitt2785.2%4 (14.8%)
90GLOVERSVILLE4684.8%7 (15.2%)
91Plattsburgh10284.3%16 (15.7%)
92Baldwinsville7684.2%12 (15.8%)
93BATH3884.2%6 (15.8%)
94NANUET5084%8 (16%)
95NEW CITY6883.8%11 (16.2%)
96WATERTOWN10483.7%17 (16.3%)
97Liverpool12682.5%22 (17.5%)
98CANASTOTA4082.5%7 (17.5%)
99ELMIRA12382.1%22 (17.9%)
100HORSEHEADS6182%11 (18%)
101ROTTERDAM3881.6%7 (18.4%)
102WATERLOO2781.5%5 (18.5%)
103JOHNSTOWN4381.4%8 (18.6%)
104Syracuse88181%167 (19%)
105RENSSELAER3080%6 (20%)
106GARDEN CITY3080%6 (20%)
107NYACK5479.6%11 (20.4%)
108NORWICH3479.4%7 (20.6%)
109HUDSON FALLS3479.4%7 (20.6%)
110BATAVIA4879.2%10 (20.8%)
111PEARL RIVER4778.7%10 (21.3%)
112OWEGO2878.6%6 (21.4%)
113Bronx1,68878.4%41 (2.4%)
114Manhattan6,93678.2%131 (1.9%)
115SUFFERN5078%11 (22%)
116HORNELL5078%11 (22%)
117Brooklyn4,82977.5%101 (2.1%)
118CAZENOVIA2676.9%6 (23.1%)
119ALEXANDRIA BAY2576%6 (24%)
120SARATOGA SPRINGS23775.9%57 (24.1%)

Inspected establishments inspected per month

2025-10: 3,675 inspected establishments2025-11: 4,068 inspected establishments2025-12: 4,994 inspected establishments2026-01: 4,513 inspected establishments2026-02: 4,955 inspected establishments2026-03: 5,777 inspected establishments2026-04: 6,312 inspected establishments2026-05: 5,313 inspected establishments2026-06: 5,114 inspected establishments2026-07: 5,049 inspected establishments2026-08: 5,357 inspected establishments2026-09: 4,979 inspected establishments2026-10: 63 inspected establishments2025-102025-122026-022026-042026-062026-082026-1063
Records by the month they were inspected, all areas.

Get every one of the 60,169 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-04 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 163 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