Snapshot of 29 September 2026
NYC restaurant grades by borough
For each of the five boroughs, how many restaurants’ latest graded inspection carried an A, a B, a C or a Grade Pending — counted from the city’s open data on 29 September 2026.
The snapshot
Latest grades, borough by borough
Computed 2026-09-29 00:46:16 UTC from NYC Open Data, dataset 43nn-pn8j — 52,943 graded inspections read in 2 requests, one latest grade kept for each of 25,399 establishments. The dataset’s newest inspection was dated 25 September 2026; its extract was dated 28 September 2026.
Share of latest grades, borough by borough
The counts
| Borough | A | B | C | Pending (Z) | With a grade | None yet | All |
|---|---|---|---|---|---|---|---|
| Manhattan | 8,704 87.6% | 629 6.3% | 183 1.8% | 415 4.2% | 9,931 | 2,596 | 12,527 |
| Brooklyn | 5,605 86.8% | 429 6.6% | 128 2.0% | 298 4.6% | 6,460 | 1,512 | 7,972 |
| Queens | 4,768 81.8% | 534 9.2% | 167 2.9% | 357 6.1% | 5,826 | 1,205 | 7,031 |
| Bronx | 1,925 85.2% | 178 7.9% | 50 2.2% | 106 4.7% | 2,259 | 378 | 2,637 |
| Staten Island | 780 87.2% | 71 7.9% | 14 1.6% | 30 3.4% | 895 | 223 | 1,118 |
| Borough missing in the data (code “0”) | 26 92.9% | 2 7.1% | 0 0.0% | 0 0.0% | 28 | 63 | 91 |
| All establishments | 21,808 85.9% | 1,843 7.3% | 542 2.1% | 1,206 4.7% | 25,399 | 5,977 | 31,376 |
“Pending (Z)” is the dataset’s Grade Pending code. “With a grade” counts establishments whose latest graded inspection carries one of these codes; “None yet” counts those with no graded inspection in the data; “All” is every establishment in the dataset. Percentages are shares of “With a grade” in that row. Boroughs are listed by number of establishments.
Method
How it was counted
In the city’s data one row is one violation, so nothing can be counted until the rows are grouped. The build script for this page asks the data service for the distinct combinations of establishment, borough, inspection date and grade among graded inspections, and keeps, for each establishment, the one with the newest inspection date. “Graded” follows the rule in the Health Department’s own notes for the dataset: re-inspections and reopening inspections, and initial inspections that scored 13 or less, carrying a grade of A, B, C or a Grade Pending code.
The query, sent 2 times with an offset of 50,000 rows:
GET https://data.cityofnewyork.us/resource/43nn-pn8j.json
$select = camis, boro, inspection_date, grade
$where = grade in('A','B','C','P','Z') AND (inspection_type in('Cycle Inspection / Re-inspection','Pre-permit (Operational) / Re-inspection','Pre-permit (Operational) / Reopening Inspection','Cycle Inspection / Reopening Inspection') OR (inspection_type in('Cycle Inspection / Initial Inspection','Pre-permit (Operational) / Initial Inspection') AND score <= 13))
$group = camis, boro, inspection_date, grade
$order = camis, inspection_date, grade
$limit = 50000
The number of establishments in each borough comes from a second query, $select=boro, count(distinct camis)&$group=boro. An establishment counted there and absent from the first result has no graded inspection in the data yet. A third query confirmed that no establishment has both a “not yet inspected” row and a real inspection, which the count of 3,800 not yet inspected depends on. The table is made again by labs.llc’s build (nyc/tools/harvest546.py --fresh, then nyc/tools/mkrecords546.py); until then it stays the snapshot of the date above.
What the table is not
- It is a count of records on one day, not a ranking of boroughs. The boroughs differ in how many restaurants they hold, of what kind and how recently opened, and the table measures none of that.
- It counts the latest grade in the data. When a re-inspection ended in a B or a C, the restaurant may be posting a Grade Pending card, and the data cannot tell.
- Grades are revised after hearings, and the dataset drops restaurants that close, so the same query gives different numbers on another day.
- No establishment had two different grades on its latest graded date.
- 91 establishments carry no borough in the data (the dataset’s code is “0”). They are in their own row of the table and are left out of the chart.
Licence: the dataset’s metadata states none, and none is claimed here. This page asks nothing of you and sends nothing anywhere; its figures are fixed in the page. To read one restaurant’s record, use the NYC restaurant inspection lookup. For what the letters stand for, read how NYC restaurant grades and points work. The city’s own lookup, ABCEats, is the authority on any one restaurant’s grade.
Sources
- DOHMH New York City Restaurant Inspection Results, NYC Open Data (dataset 43nn-pn8j). https://data.cityofnewyork.us/Health/DOHMH-New-York-City-Restaurant-Inspection-Results/43nn-pn8j. Read 28 September 2026.
- “About NYC Restaurant Inspection Data on NYC OpenData”, the Health Department’s notes attached to the dataset (file dated 2 May 2022). https://data.cityofnewyork.us/api/views/43nn-pn8j/files/0658bb14-1b0a-4fc6-b389-d42ae6e9d3be?download=true&filename=About_NYC_Restaurant_Inspection_Data_on_NYC_OpenData_050222.docx. Read 28 September 2026.
- Restaurant Inspection Data Dictionary, attached to the dataset (file dated 24 September 2018). https://data.cityofnewyork.us/api/views/43nn-pn8j/files/ec33d2c8-81f5-499a-a238-0213a38239cd?download=true&filename=RestaurantInspectionDataDictionary_09242018.xlsx. Read 28 September 2026.