City of New York

Historical Sidewalk Café Licenses and Applications

The NYC Department of Transportation will be responsible for regulating outdoor dining under the new Dining Out program, and will be publishing program data once its available. In the interim, please consult the Open Restaurants dataset. This dataset features detailed information about sidewalk café license app... Maintained by the City of New York.

Example records
Namelegal entityAlternate NamebrandCityaddressStateaddressZIP CodeaddressStreet AddressaddressLicense NbrregistrationLic StatusstatusBuildingaddressSwc TypeclassificationSwc Sq FtquantitySwc Tablesquantity
CASA AZUL. INCNULLBROOKLYNNY112157TH AVE2093559-DCAActive369Unenclosed2969
DIG INN 412 GREENWICH STREET, LLCDIG INNNEW YORKNY10013GREENWICH ST2093354-DCAActive412Unenclosed1784
CPW REST CORP.LILLY'S COCKTAIL & WINE BARNEW YORKNY10023W 72ND ST2095010-DCAInactive50Unenclosed1838
Use cases

Vendor Legitimacy Check for Food and Beverage Suppliers

A distributor onboarding a new restaurant account checks whether the operator holds a current, unexpired sidewalk cafe license to confirm the business is actively operating and not a shell or recently closed location before extending net-30 credit terms.

NameLicense NbrLic StatusExpiration DateStreet Address

Commercial Real Estate Underwriting for Ground-Floor Retail

A lender underwriting a mixed-use property loan reviews the density and footprint of licensed outdoor dining operations on the block to gauge foot traffic patterns and the viability of ground-floor restaurant tenants as income-producing assets.

Street AddressSwc Sq FtSwc TablesSwc ChairsLic Status

Fraud Signal Detection for Small Business Insurance Claims

An insurance investigator reviewing a business interruption claim from a restaurant cross-references the claimed outdoor seating capacity against the licensed table and chair counts to identify discrepancies that suggest inflated revenue figures.

NameLicense NbrSwc TablesSwc ChairsApp Tables
Related datasets
Sidewalk CafesDistrict of ColumbiaLicense ApplicationsCity of New YorkDOHMH New York City Restaurant Inspection ResultsCity of New YorkIssued LicensesCity of New YorkConsumer and Worker Protection Licensed VehiclesCity of New YorkDOHMH School Cafeteria InspectionsCity of New YorkDOB License InfoCity of New YorkDesignated and Calendared Buildings and SitesCity of New YorkBusiness Improvement DistrictsCity of New YorkHomeless Drop-In CentersCity of New YorkIntercity Bus Stop PermitsCity of New YorkDC StreateryDistrict of ColumbiaCitywide Public Computer CentersCity of New YorkConsumer and Worker Protection InspectionsCity of New YorkCase-Related Civil LitigationCity of New YorkParks ConcessionsCity of New YorkConsumer and Worker Protection ComplaintsCity of New YorkDepartment of Consumer and Worker Protection Archived ChargesSchool LocationsCity of New YorkOther Tobacco Products LicensesCity of New York