v1.0.0latest·414,343 records·0 files·153.4 MiB
Nov 14, 20261
README

NYC Restaurant Inspections, November 2026

This collection holds the New York City Department of Health and Mental Hygiene (DOHMH) Restaurant Inspection Results for all five boroughs, as the city published them on 12 November 2026. It also holds the restaurants that appear in earlier copies of the same table and have since been removed from it.

The collection belongs to the Underlay organization system-community (System Inc. Community), where teams in the System Public Challenge of November 2026 publish their work. Team Hypergraph (Jeff Nickerson and Ida Benedetto) built it for Build Challenge 4. Knowledge Futures seeded the collection nyc/restaurant-inspections v1.0.0 for the challenge; it covers Manhattan restaurants inspected since January 2024 and was pushed on 12 June 2026. This collection is a later and wider copy of the same city table: all five boroughs, every inspection the city listed on 12 November 2026, and a record for each restaurant the city has since removed. The section "Record types" lists the differences.

Source

The source is the NYC Open Data dataset "DOHMH New York City Restaurant Inspection Results", dataset id 43nn-pn8j (https://data.cityofnewyork.us/d/43nn-pn8j). The dataset's rowsUpdatedAt was 2026-11-12T23:06:40Z when the rows were fetched, and it was unchanged when the fetch ended. The rows were fetched at 2026-11-13T14:51:05-0500 through the Socrata API (https://data.cityofnewyork.us/resource/43nn-pn8j.json) with this query, paged by $offset in steps of 50,000:

$limit=50000&$select=camis,dba,boro,building,street,zipcode,phone,cuisine_description,inspection_date,action,violation_code,violation_description,critical_flag,score,grade,grade_date,record_date,inspection_type,latitude,longitude,community_board,council_district,census_tract,bin,bbl,nta&$order=:id

The fetch returned 294,845 rows. The city's own counts, queried by SoQL aggregation at the same time, were 294,845 rows, 31,482 distinct CAMIS numbers, 92,745 distinct inspections (CAMIS, date and type, dated after 1901) and 287,728 rows that cite a violation code on a dated inspection.

The collection was built by analyses/underlay_publish/build.py in the repository nyc-concordance, at git commit 7b50945f05a82177e14e3331f07d1dfa2ef94753. The code is in the public pull request https://github.com/SystemPublic/system-public-challenge-2026/pull/3, under projects/hypergraph/ (analyses/underlay_publish/; the drift audit is docs/underlay_drift.md). The working repository, nyc-concordance on GitHub, is private for now.

Record types

Type Records Id
Restaurant 31,482 CAMIS
Inspection 92,745 CAMIS, inspection date and inspection type in slug form, for example 30191841-2024-11-20-cycle-inspection-initial-inspection
Violation 287,728 inspection id plus violation code
RemovedRestaurant 2,388 CAMIS

Restaurant, Inspection and Violation use the same ids and the same field names as the Underlay collection nyc/restaurant-inspections v1.0.0 (version hash ulv2:07a7f08a0d5c85649920f8adc6946d27c17f5e2d75e9ee07c0ad4ae0fcc6739c). A record in the two collections with the same type and id describes the same restaurant, inspection or violation, so the two versions can be compared record by record. Where the city has not changed an inspection or a violation since June 2026, the record is identical and has the same hash in both collections.

This collection differs from v1.0.0 in four ways. It covers all five boroughs and every inspection the city lists, not only Manhattan inspections from 2024 onward. Restaurant records keep the city's NTA, community board, BBL and BIN fields, which v1.0.0 dropped, and an inspected flag. Restaurants that the city lists only with the placeholder date 1900-01-01 are included as Restaurant records with inspected set to false and no inspections; there are 4,038 of them. A violation code that the city cites more than once in one inspection keeps a record for each citation. The first citation has the id used in v1.0.0, and later ones add -2, -3 and an occurrence field. There are 225 such later citations; v1.0.0 kept one record for each code.

As in v1.0.0, a blank grade or grade date is an empty string and a blank score is left out. Dates are YYYY-MM-DD. Latitude and longitude are 0 where the city has not geocoded the address, and are left out where the city gives no value.

Removed restaurants

The live table holds only restaurants in active status on the day it is written. A RemovedRestaurant record is a CAMIS listed in an earlier copy of the table and absent from the live table at the fetch above. Each record says which copies show it (shownBy), takes its name, address, cuisine and last inspection from one of them (source), and states the evidence in one sentence.

Two earlier copies were used. The first is nyc/restaurant-inspections v1.0.0, pushed on 12 June 2026, which covers Manhattan. Of its 10,536 restaurants, 519 are absent from the live table. A further 24 are missing from the live Manhattan rows but are still listed under another borough, so they are not counted as removed; the earlier audit's figure of 543 included them. For the 519 removed restaurants, the last inspection in the snapshot was in 2024 for 133, in 2025 for 323 and in 2026 for 63. These records give the snapshot's version hash and the hash of the snapshot's Restaurant record. The second is the copy of the full table that the Internet Archive captured at 20260403010027 (UTC, 3 April 2026), at https://web.archive.org/web/20260403010027id_/https://data.cityofnewyork.us/api/views/43nn-pn8j/rows.csv?accessType=DOWNLOAD. Of its 30,917 restaurants, 2,388 are absent from the live table: 2 with the borough code 0, 177 in Bronx, 635 in Brooklyn, 880 in Manhattan, 593 in Queens and 101 in Staten Island. Of these, 327 were listed only with the placeholder date and have no last inspection. Both copies show 519 of the removed restaurants, the snapshot alone shows 0 and the archive copy alone shows 1,869. Where both copies list a restaurant, the details come from the snapshot, which is the later copy.

The city does not say why a restaurant leaves the table. Most of these restaurants probably closed or lost their permit, and the data cannot separate the two.

How the city changes this table

A comparison of v1.0.0 with the live table (docs/underlay_drift.md in the repository) found three things. First, the city rewrites the whole table every day: every row of the November fetch carries the same record_date, 2026-11-12, and rowsUpdatedAt records when the table was last written, not which rows changed. A citation of the dataset id and its update time therefore cannot be checked after the next day's rewrite. Second, the city lowers scores when violations are dismissed on adjudication. Of 24,030 Manhattan inspections present in both copies, 485 had a different score in November, and every one of the 485 was lower (median change −8 points). In 302 inspections violation codes were removed and none were added, and 202 grades of Z (grade pending) became final grades. Third, the city deletes a restaurant from the table, with all of its inspections, when the restaurant leaves active status. The 519 Manhattan restaurants described above had 1,263 inspections in the snapshot, and none of them is in the live table.

Licence

The data are public records of the City of New York, published through NYC Open Data under the Open Data Law (Local Law 11 of 2012, now Title 23, Chapter 5 of the NYC Administrative Code, https://codelibrary.amlegal.com/codes/newyorkcity/latest/NYCadmin/0-0-0-216807). The city attaches no licence to the dataset and states no restriction on the use of the data. The NYC Open Data site refers its users to the City of New York Terms of Use (https://www.nyc.gov/main/terms-of-use), which govern the city's websites. This collection is not published or endorsed by the City of New York.