Ready for your workflow

Flexible data delivery

Delivered files
UTF-8 CSV, JSON, SQLite, schemas, samples, statistics, documentation, and tier-specific ZIP bundles.
Updates
Current release 2.0.0 dated October 4, 2026. Update eligibility follows the selected license.
Preview sample data
Choose your licensePurchase once. Download immediately.
Secure checkout
NYC Restaurant DirectoryNYC Restaurant Directory: establishments. Matching CSV, JSON and SQLite.
$40.00
Complete NYC Restaurant DataComplete NYC Restaurant Data: establishments, inspections, violations, administrative_geography, historical_facts. Matching CSV, JSON and SQLite.Current update offer$10.00For eligible earlier Master purchases
$160.00
Records
31,462
Version
2.0.0
Release date
Oct 4, 2026
Before you choose
Explore the samples
NYC Restaurant Inspections Database List

NYC Restaurant Inspections Database v.2.0.0

31,462 Restaurant permits


NYC Restaurant Inspections Database catalog icon NYC Restaurant Inspections Database Download
NYC Restaurant Inspections Database artwork

New York City restaurant locations and inspection data

Explore 31,462 restaurant and college-cafeteria permit records from NYC DOHMH, captured with an October 2, 2026 source cutoff. Use published names, addresses, cuisine descriptions and qualified inspection summaries for research, mapping and directory projects.

Choose the detail your project needs

NYC Restaurant Directory includes establishments and latest inspection summaries. NYC Restaurant Inspection History adds 93,248 inspection observations and 289,225 violation records. Complete NYC Restaurant Data adds published administrative-geography identifiers and clearly marked matched historical facts.

Understand the inspection context

The source includes 3,865 permits not yet inspected. Related inspection and citation rows are not additional restaurants. Some source details are missing, and the history is not a complete archive. Scores, grades and citations can change through adjudication. A reported grade or historical closure is not a real-time safety or operating-status guarantee. Consult the current NYC Health Department information and the establishment for current conditions.

Formats for your workflow

Every tier provides its included tables in matching UTF-8 CSV, JSON and SQLite, with schemas, field definitions, samples, statistics and documentation. Codes retain leading zeros; missing values remain explicit.

31,462 Restaurant permits Records
SAMPLE DATA TABLE STRUCTURE RECORD INFO
Restaurants Drink Recipes Bars and Pubs Recipes Restaurant Profiles Starbucks

License Database Purchase Options

USAGE

NYC Restaurant Directory

$40.00

Internal work

Import, modify, combine and analyze within one organization, including work by supervised contractors.

Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.

Read the complete Oddity Software Usage License

Choose this package above

PUBLICATION

NYC Restaurant Inspection History

$80.00

Publish and build for clients

All Usage rights, plus customer-facing websites, apps, reports and client projects without bulk dataset handoff.

Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.

Read the complete Oddity Software Publication License

Choose this package above

MASTER

Complete NYC Restaurant Data

$160.00

Client dataset handoff

All Publication rights, plus raw or transformed dataset handoff within a genuine client project. Standalone dataset resale requires a separate addendum.

Current Master update offer$10.00For an eligible earlier Master purchase. The fee is checked again when a new release is available.

Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.

Read the complete Oddity Software Master License

Choose this package above

Table Schema Database Field Statistics

Release structure

NYC Restaurant Inspections Database

Review the published tables, record coverage, and field names included with release 2.0.0.

Database
#770
Version
2.0.0
Format
XML schema

Data dictionary

Tables and fields

Release-defined structure
TableRecordsFields
establishments31462camis, establishment_name, borough, address_line_1, state_code, postal_code, country_code, phone, cuisine_description, latitude, longitude, inspection_status, latest_inspection_date, latest_inspection_type, latest_inspection_action, latest_inspection_score, latest_observation_count, reported_grade, reported_grade_date, reported_grade_inspection_date, reported_grade_inspection_type, record_date
inspections93248inspection_id, camis, inspection_date, inspection_type, action, score, grade, grade_date, record_date, violation_count
violations289225violation_id, inspection_id, camis, violation_code, violation_description, critical_flag
administrative_geography31462geography_id, camis, community_board, council_district, census_tract, building_identification_number, borough_block_lot, neighborhood_tabulation_area, record_date
historical_facts34543historical_fact_id, camis, field_name, fact_value, verification_status, as_of_date, historical_version

Release at a glance

What is inside this database

Review verified record totals, geographic coverage, classifications, and field completeness for NYC Restaurant Inspections Database.

31,462Establishments
93,248Inspections
289,225Violations
31,462Administrative Geography
34,543Historical Facts

Borough

  • Manhattan12,562
  • Brooklyn8,002
  • Queens7,041
  • Bronx2,641
  • Staten Island1,123
  • Unknown93

Inspection Status

  • Inspected27,597
  • Not Yet Inspected3,865

Table and column statistics

Select a table to review its schema, record total and fields. Distinct and missing-value counts appear where measured.

establishments31,462 records · 22 fields
camis
Distinct
31,462
Missing
0 (0.0%)
establishment_name
Distinct
24,632
Missing
1 (0.0%)
borough
Distinct
5
Missing
93 (0.3%)
address_line_1
Distinct
25,738
Missing
0 (0.0%)
state_code
Distinct
1
Missing
0 (0.0%)
postal_code
Distinct
254
Missing
493 (1.6%)
country_code
Distinct
1
Missing
0 (0.0%)
phone
Distinct
27,750
Missing
112 (0.4%)
cuisine_description
Distinct
90
Missing
3,867 (12.3%)
latitude
Distinct
24,918
Missing
802 (2.5%)
longitude
Distinct
24,918
Missing
802 (2.5%)
inspection_status
Distinct
2
Missing
0 (0.0%)
latest_inspection_date
Distinct
1,060
Missing
3,865 (12.3%)
latest_inspection_type
Distinct
24
Missing
6,030 (19.2%)
latest_inspection_action
Distinct
5
Missing
3,975 (12.6%)
latest_inspection_score
Distinct
124
Missing
4,392 (14.0%)
latest_observation_count
Distinct
5
Missing
0 (0.0%)
reported_grade
Distinct
4
Missing
6,042 (19.2%)
reported_grade_date
Distinct
1,178
Missing
6,042 (19.2%)
reported_grade_inspection_date
Distinct
1,178
Missing
6,042 (19.2%)
reported_grade_inspection_type
Distinct
6
Missing
6,042 (19.2%)
record_date
Distinct
1
Missing
0 (0.0%)

Inspect the data

Representative sample data

Switch tables to review representative fields and rows from every table advertised for this release.

camisestablishment_nameboroughaddress_line_1state_codepostal_codecountry_codephonecuisine_descriptionlatitudelongitudeinspection_statuslatest_inspection_datelatest_inspection_typelatest_inspection_actionlatest_inspection_scorelatest_observation_countreported_gradereported_grade_datereported_grade_inspection_datereported_grade_inspection_typerecord_date
30075445MORRIS PARK BAKE SHOPBronx1007 MORRIS PARK AVENUENY10462US7188924968Bakery Products/Desserts40.848231224526-73.855971889932inspected2026-02-27Cycle Inspection / Initial InspectionViolations were cited in the following area(s).71A2026-02-272026-02-27Cycle Inspection / Initial Inspection2026-10-02
40936610JACK DEMSEY'S PUBManhattan36 WEST 33 STREETNY10001US2126299899Irish40.748387159231-73.986556145104inspected2025-10-22Cycle Inspection / Initial InspectionViolations were cited in the following area(s).131A2025-10-222025-10-22Cycle Inspection / Initial Inspection2026-10-02
41384689WASABI POINTQueens76-18 WOODSIDE AVENUENY11373US7182051056Asian/Asian Fusion40.743426250014-73.888620995926inspected2025-09-12Cycle Inspection / Re-inspectionViolations were cited in the following area(s).161B2025-09-122025-09-12Cycle Inspection / Re-inspection2026-10-02
41643403DON ANTONIO RESTAURANTManhattan309 WEST 50 STREETNY10019US6467191043Italian40.762555628615-73.986730157337inspected2025-07-01Cycle Inspection / Initial InspectionViolations were cited in the following area(s).71A2025-07-012025-07-01Cycle Inspection / Initial Inspection2026-10-02
50011573GRAN VILLABrooklyn4002 3 AVENUENY11232US3472605568Latin American40.653190707078-74.008862036378inspected2026-08-31Cycle Inspection / Initial InspectionViolations were cited in the following area(s).121A2026-08-312026-08-31Cycle Inspection / Initial Inspection2026-10-02
50048257PATE PALOManhattan251 DYCKMAN STREETNY10034US6469186242Latin American40.866428089872-73.928333163048inspected2026-08-26Cycle Inspection / Initial InspectionViolations were cited in the following area(s).101A2026-08-262026-08-26Cycle Inspection / Initial Inspection2026-10-02
50071055BAO BAO NOODLEManhattan106 GREENWICH STREETNY10006US9172617122Chinese40.708434354251-74.013399696944inspected2025-10-02Cycle Inspection / Initial InspectionViolations were cited in the following area(s).131A2025-10-022025-10-02Cycle Inspection / Initial Inspection2026-10-02
50088233CAFE HESTIAManhattan513 7 AVENUENY10018US2127683838American40.753267599463-73.988951767419inspected2026-07-28Cycle Inspection / Initial InspectionViolations were cited in the following area(s).291B2025-07-152025-07-15Cycle Inspection / Re-inspection2026-10-02
50103690GENESISQueens78-04 WOODSIDE AVENUENY11373US7184262080Tex-Mex40.743679867795-73.886938852936inspected2026-06-08Cycle Inspection / Re-inspectionViolations were cited in the following area(s).271B2026-06-082026-06-08Cycle Inspection / Re-inspection2026-10-02
50113143HUNGRY GHOSTManhattan315 BLEECKER STREETNY10014US3475299448American40.732822328898-74.003911334621inspected2026-06-08Cycle Inspection / Initial InspectionViolations were cited in the following area(s).91A2026-06-082026-06-08Cycle Inspection / Initial Inspection2026-10-02
50122983DIANE'SBrooklyn425 GRAHAM AVENUENY11211US9175667699American40.717732167889-73.944921874537inspected2025-12-17Cycle Inspection / Initial InspectionViolations were cited in the following area(s).71A2025-12-172025-12-17Cycle Inspection / Initial Inspection2026-10-02
50132265LOBSTER STEAKHOUSE RESTAURANTManhattan701 WEST 179 STREETNY10033US6469344029Latin American40.848993333747-73.937348683074inspected2026-06-15Cycle Inspection / Re-inspectionViolations were cited in the following area(s).291Z2026-06-152026-06-15Cycle Inspection / Re-inspection2026-10-02
50142234LOBSTER PLACE SUSHIManhattan75 9 AVENUENY10011US2122555672Seafood40.741869040229-74.004713006739inspected2025-08-13Cycle Inspection / Initial InspectionViolations were cited in the following area(s).91A2025-08-132025-08-13Cycle Inspection / Initial Inspection2026-10-02
50150049FABRIQUEManhattan550 5 AVENUENY10036US9295034149Bakery Products/Desserts40.755618529926-73.979335716143inspected2026-07-30Cycle Inspection / Initial InspectionViolations were cited in the following area(s).221A2025-03-262025-03-26Cycle Inspection / Initial Inspection2026-10-02
50160140XING SHUN 8Brooklyn5014 7 AVENUENY11220US6465783777Chinese40.642302344613-74.006068005125inspected2025-03-28Pre-permit (Operational) / Initial InspectionViolations were cited in the following area(s).51A2025-03-282025-03-28Pre-permit (Operational) / Initial Inspection2026-10-02
50166919CHAYANNQueens40-09 PRINCE STREETNY11354US9178158896Coffee/Tea40.758823806017-73.831822402698inspected2025-09-25Pre-permit (Operational) / Re-inspectionViolations were cited in the following area(s).121A2025-09-252025-09-25Pre-permit (Operational) / Re-inspection2026-10-02
50174791STUFFED NYC PIZZABronx3073 BAILEY AVENUENY10463US347863738540.877544714923-73.902823815109not_yet_inspected02026-10-02
50180514BOCA DEL CIELOBrooklyn8511 3 AVENUENY11209US3475606899American40.624125164536-74.030774819771inspected2026-09-17Pre-permit (Operational) / Initial InspectionViolations were cited in the following area(s).2012026-10-02
50186801BARK BARBECUEBrooklyn25 THAMES STREETNY11206US347881579940.704868781233-73.932085391566not_yet_inspected02026-10-02
50193232100%Brooklyn602 NOSTRAND AVENY11216US973432462340.677948907245-73.94974625156not_yet_inspected02026-10-02

31,462 establishments; 93,248 inspections; 289,225 violations; 31,462 administrative geography; 34,543 historical facts. Establishment permits are the primary count; related rows are not extra restaurants.

Designed for business research, directory applications, mapping, and market analysis. Review permitted uses.

Need a closer fit?

Data shaped around your project.

Tell us your topic, geography, and required fields. We can help find a match or scope a custom package.

A clear path from download to project

Get more from your data

Understand the files, check the sample coverage, and choose the license that fits your use.

Oddity Support

How can we help?

Oddity Data Updates

Know when fresh data arrives.

Receive occasional notices about new and substantially updated database releases. No third-party mailing list.

Oddity Software

Details