New York City Department of Transportation (DOT) / NYC Open Data: Dining Out NYC Locations

Category Inference

Food service establishments (restaurants, cafes, bars, etc.) licensed by NYC DOT to operate outdoor sidewalk or roadway dining as part of the Dining Out NYC program

Fallback category: eat_and_drink›restaurant

Source category mappings

(2)

Source category	Overture category	Confidence	Valid
Sidewalk	eat_and_drink›restaurant	0.72	✓
Roadway	eat_and_drink›restaurant	0.70	✓

Source Schema

(7 columns)

Name	Type	Null %	Unique	Sample values
id	object	0.0%	647	`3e6d1bae-353c-48ac-85a6-56e1cf04597f` `0e6c7dad-991b-4de1-a6ec-c65b6c6c3538` `a9b04465-85b9-489c-a8a7-0af9c7256161`
names	object	0.0%	—	`{'primary': 'ZOUK LTD'}` `{'primary': "RUBY'S WILLIAMSBURG LLC"}` `{'primary': 'OLIO RESTAURANTS LLC'}`
categories	object	0.0%	—	`{'primary': 'restaurant'}` `{'primary': 'restaurant'}` `{'primary': 'restaurant'}`
operating_status	object	0.0%	1	`open` `open` `open`
addresses	object	0.0%	—	`[{'region': None, 'country': 'US', 'freeform': '28 CORNELIA STREET, NEW YORK, Manhattan', 'locality': None, 'postcode': '10014'}]` `[{'region': None, 'country': 'US', 'freeform': '98 BERRY STREET, BROOKLYN, Brooklyn', 'locality': None, 'postcode': '11249'}]` `[{'region': None, 'country': 'US', 'freeform': '3 GREENWICH AVENUE, NEW YORK, Manhattan', 'locality': None, 'postcode': '10014'}]`
sources	object	0.0%	—	`[{'between': None, 'dataset': 'nyc-sidewalk-cafe-licenses', 'license': None, 'property': '', 'record_id': '0', 'confidence': None, 'update_time': '2025-01-01'}]` `[{'between': None, 'dataset': 'nyc-sidewalk-cafe-licenses', 'license': None, 'property': '', 'record_id': '1', 'confidence': None, 'update_time': '2025-01-01'}]` `[{'between': None, 'dataset': 'nyc-sidewalk-cafe-licenses', 'license': None, 'property': '', 'record_id': '2', 'confidence': None, 'update_time': '2025-01-01'}]`
source_properties	object	0.0%	—	{'BBL': '1005890013.0', 'BIN': '1076924.0', 'City': 'NEW YORK', 'Street': '28 CORNELIA STREET', 'Borough': 'Manhattan', 'Latitude': '40.731411566573', 'Location': 'POINT (-74.00213242586 40.731411566573)', 'Postcode': '10014', 'Longitude': '-74.00213242586', 'License Type': 'Roadway', 'License Status': 'Issued', 'Assumed Name(s)': 'PALMA', 'Community Board': '102', 'Council District': '3', 'License Issue Date': '10/03/2025 01:36:49 PM', 'Business Legal Name': 'ZOUK LTD', 'Census Tract (2020)': '67.0', 'License Expiration Date': '10/03/2029 11:59:59 PM', 'Neighborhood Tabulation Area (NTA) (2020)': 'MN0203'} {'BBL': '3023180017.0', 'BIN': '3324819.0', 'City': 'BROOKLYN', 'Street': '98 BERRY STREET', 'Borough': 'Brooklyn', 'Latitude': '40.719104784575', 'Location': 'POINT (-73.958513785716 40.719104784575)', 'Postcode': '11249', 'Longitude': '-73.958513785716', 'License Type': 'Roadway', 'License Status': 'Issued', 'Assumed Name(s)': "LITTLE RUBY'S WILLIAMSBURG", 'Community Board': '301', 'Council District': '33', 'License Issue Date': '03/06/2026 10:42:32 AM', 'Business Legal Name': "RUBY'S WILLIAMSBURG LLC", 'Census Tract (2020)': '557.0', 'License Expiration Date': '03/06/2030 11:59:59 PM', 'Neighborhood Tabulation Area (NTA) (2020)': 'BK0102'} {'BBL': '1005930013.0', 'BIN': '1010268.0', 'City': 'NEW YORK', 'Street': '3 GREENWICH AVENUE', 'Borough': 'Manhattan', 'Latitude': '40.733931279931', 'Location': 'POINT (-73.999635561442 40.733931279931)', 'Postcode': '10014', 'Longitude': '-73.999635561442', 'License Type': 'Sidewalk', 'License Status': 'Issued', 'Assumed Name(s)': 'OLIO E PIU', 'Community Board': '102', 'Council District': '3', 'License Issue Date': '02/27/2026 01:54:07 PM', 'Business Legal Name': 'OLIO RESTAURANTS LLC', 'Census Tract (2020)': '71.0', 'License Expiration Date': '02/27/2030 11:59:59 PM', 'Neighborhood Tabulation Area (NTA) (2020)': 'MN0203'}

Quality Report

✅ Dataset is usable

Geographic Bounds

Coordinates: Southwest (-74.1437, 40.5769) - Northeast (-73.7834, 40.8554)