Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

Open Restaurants Inspections (Historical)

4dx7-axuxTransportation20 columns
This is historical dataset program, is no longer accepting applications. Visit the permanent Dining Out website for information: https://www.diningoutnyc.info/ This historical Open Restaurant Inspection dataset contains the results of site setup inspections conducted as part of the temporary program established to promote open space, and to enhance social distancing. The inspections evaluated compliance of sidewalk and roadway setup requirements for food establishment locations throughout New York City.
View on NYC Open Data↗

Quality

B88.6 / 100

From a 500-row sample across 19 columns.

completeness91/ 25% weight
consistency74/ 20% weight
accuracy96/ 20% weight
timeliness93/ 15% weight
usability90/ 20% weight
  • · No obvious temporal column — limits time-series joins
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • Open Restaurant Applications (Historical)0.44
    joins onlatitudeboroughnta+3
  • Dining Out NYC Locations0.41
    joins onpostcodelatitudeborough+3
  • Sidewalk Management Database - Violations0.35
  • Parking Regulation Locations and Signs0.35
    joins onborough
  • Street Resurfacing Schedule0.34
    joins oncommunityboard

Geography

Mappable — coordinate pair `latitude` / `longitude`.

Open on the map →

Sample rows

boroughrestaurantnameseatingchoicelegalbusinessnamebusinessaddressrestaurantinspectionidisroadwaycompliantinspectedonagencycodepostcodelatitudelongitude
ManhattanOscar WildebothCamelot Castle LLC45 West 27th st72891Non-Compliant2021-12-20T16:06:58.000DOT1000140.744876-73.989657

Columns

20 queryable · 20 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
boroughcategoricalThe borough in which the restaurant or food service establishment is located.0%ManhattanBrooklynQueensof 5
restaurantnametextThe name of the restaurant or food service establishment0%SWEETGREENBareburgerTacombi
seatingchoicecategoricalThe type of seating for which the restaurant or food service establishment is configured for.0%bothsidewalkroadwayof 4
legalbusinessnametextThe business name as registered with the NYC Department of Consumer Affairs (DCA).0%

Query this from your own app

GET /api/datasets/4dx7-axux
GET /api/datasets/4dx7-axux/quality
GET /api/datasets/4dx7-axux/related
GET /api/columns?dataset=4dx7-axux
Street Sign Work Orders0.34
joins onborough
  • Bus Breakdown and Delays0.34
  • TLC Approved LabCorp Patient Services Drug Test Locations0.33
    joins onpostcodelatitudenta+3
    • Manhattan
    LA RUBIA RESTAURANT
    both
    LA RUBIA RESTAURANT INC
    3517 BROADWAY
    72892
    For HIQA Review
    2021-12-20T16:18:42.000
    DOT
    10031
    40.825863
    -73.950874
    ManhattanThai SliderssidewalkSilom Thai Inc150 8th Ave72893Non-Compliant2021-12-20T16:35:41.000DOT1001140.741906-74.000945
    BrooklynOtwaybothSt james 930 LLC930 Fulton street72894Cease and Desist2021-12-20T16:38:45.000DOT1123840.682833-73.963833
    BrooklynWILLIAMSBURG THAI CUISINEbothWILLIAMSBURG THAI CUISINE NY INC212 BEDFORD AVENUE72896Compliant2021-12-20T16:52:41.000DOT1124940.716913-73.958728
    ManhattanLURE FISHBARboth142 MERCER STREET LLC142 MERCER STREET72897Compliant2021-12-20T16:56:14.000DOT1001240.724837-73.998402
    ManhattanMojo omakasebothMojo chef inc177 9th avenue72898Compliant2021-12-20T17:00:10.000DOT1001140.744917-74.002487
    ManhattanDillersidewalkDillers Inc357 Grand Street72899Suspended and Deactivated2021-12-20T23:58:57.000—1000240.716662-73.989041
    BrooklynBK LobsterbothBENNET HOLDINGS & ACQUISITIONS LLC643 VANDERBILT AVENUE72900Suspended and Deactivated2021-12-20T23:58:57.000—1123840.677856-73.968778
    ManhattanKashmir9sidewalkKpk restaurant inc478 9th Ave72901Suspended and Deactivated2021-12-20T23:58:57.000—1001840.755078-73.995062

    Showing 12 of 18 columns. All of them are listed below.

    SWEETGREEN NEW YORK LLCPetite Boucherie LLCSTARBUCKS CORPORATION
    businessaddresstextThe address of the restaurant or food service establishment.0%222 Lafayette Street210 6th Avenue27 Avenue B
    restaurantinspectionidintegerThe unique ID that references the restaurant.0%244817031589745
    issidewaycomplianttextIndicates if the restaurant or food service establishment located on the sidewalk is compliant with the Open Restaurants sidewalk requirements. Please note that “Sidewalk” and “Sideway” are interchangeable terms.100%—
    isroadwaycompliantcategoricalThis is to validate if this restaurant is compliant for roadways.0%Skipped InspectionNon-CompliantCompliantof 12
    skippedreasoncategoricalThe reason a restaurant or food service establishment inspection was skipped75%No SeatingSidewalk Seating OnlyOpen Street Locationof 4
    inspectedondatetimeThe date and time of the inspection.0%2020-12-22T09:05:24.0002021-01-11T09:31:34.0002021-06-16T15:37:33.000
    agencycodecategoricalCity agency code.15%DOTDOBDEPof 8
    postcodetextZIP code of the restaurant.0%100031001410012
    latitudecoordinate—10%40.76330440.72069740.743727
    longitudecoordinate—10%-74.001819-73.928214-74.001404
    communityboardcategorical—10%123of 19
    councildistricttext—10%312
    censustracttext—10%386567
    bintext—10%300000040000001004589
    bbltext—10%100385000520579405091002377501
    ntatext—10%West VillageMidtown-Midtown SouthEast Village