This dataset includes 110 thousand businesses licensed with City of New York, Department of Consumer Affairs (DCA). Each business is registered with license number, legal business name, phone, location, license expiration date, etc.
| Business Name | License Category | Office Address | Creation/Expiration |
|---|---|---|---|
| The Consulate Nyc LLC | Sidewalk Cafe | 519 Columbus Ave, New York, NY 10024 | 2020-01-03 ~ 2022-12-15 |
| Tacombi · Tacos 'los Vaqueros' LLC | Sidewalk Cafe | 377 Amsterdam Ave, New York, NY 10024 | 2019-08-13 ~ 2021-09-15 |
| Tiki Chicki LLC | Sidewalk Cafe | 517 Amsterdam Ave, New York, NY 10024 | 2019-08-13 ~ 2021-04-15 |
| Carmine's · Carmine's Broadway Feast, Inc | Sidewalk Cafe | 2450 Broadway, New York, NY 10024 | 2019-07-30 ~ 2021-05-15 |
| Gari Columbus · Hld Columbus LLC | Sidewalk Cafe | 370 Columbus Ave, New York, NY 10024 | 2019-07-22 ~ 2021-12-15 |
| Made In New York Pizza · 421 Amsterdam Pizza Corp | Sidewalk Cafe | 421 Amsterdam Ave, New York, NY 10024 | 2019-06-26 ~ 2021-09-15 |
| Elea · 217 W85 LLC | Sidewalk Cafe | 217 W 85th St, New York, NY 10024 | 2019-05-20 ~ 2021-12-15 |
| Bettola · Bettola Nyc Corp. | Sidewalk Cafe | 412 Amsterdam Ave, New York, NY 10024 | 2019-05-20 ~ 2021-12-15 |
| Pizza 84 LLC | Sidewalk Cafe | 483 Amsterdam Ave, New York, NY 10024 | 2019-05-20 ~ 2021-12-15 |
| Frank Macs Pub · Frank Mac's Place, LLC | Sidewalk Cafe | 425 Amsterdam Ave, New York, NY 10024 | 2019-02-21 ~ 2021-12-15 |
| Mille-feuille Bakery Broadway LLC | Sidewalk Cafe | 2175 Broadway, New York, NY 10024 | 2018-12-13 ~ 2020-12-15 |
| Swagat · Shree Laxmi Restaurant Inc | Sidewalk Cafe | 411a Amsterdam Ave, New York, NY 10024 | 2018-09-04 ~ 2020-04-15 |
| Danica LLC | Sidewalk Cafe | 464 Amsterdam Ave, New York, NY 10024 | 2018-08-22 ~ 2020-09-15 |
| Bluestone Lane · Bl 417 Amsterdam Ny LLC | Sidewalk Cafe | 417 Amsterdam Ave, New York, NY 10024 | 2018-08-02 ~ 2020-07-01 |
| Joe & The Juice · Joe & The Juice New York LLC | Sidewalk Cafe | 343 Amsterdam Ave, New York, NY 10024 | 2018-05-23 ~ 2020-09-15 |
| The Viand Diner & Bar · Egs, LLC | Sidewalk Cafe | 517 Columbus Ave, New York, NY 10024 | 2018-05-09 ~ 2020-09-15 |
| Bellini · Michel Ge Inc | Sidewalk Cafe | 483 Columbus Ave, New York, NY 10024 | 2018-05-02 ~ 2020-12-15 |
| Caledonia · Brington Road LLC | Sidewalk Cafe | 424 Amsterdam Ave, New York, NY 10024 | 2018-03-22 ~ 2020-04-15 |
| Jumbo Bagel · 472 Columbus Bagel Corp | Sidewalk Cafe | 472 Columbus Ave, New York, NY 10024 | 2017-08-23 ~ 2019-04-15 |
| Maison Pickle · The Pickle People LLC | Sidewalk Cafe | 2309 Broadway, New York, NY 10024 | 2017-08-23 ~ 2020-05-02 |
| Amelie · La Petit Amelie, LLC | Sidewalk Cafe | 566 Amsterdam Ave, New York, NY 10024 | 2017-08-03 ~ 2020-03-31 |
| Bella Luna · B.l.t.g. Pizza Inc. | Sidewalk Cafe | 574 Columbus Ave, New York, NY 10024 | 2017-08-03 ~ 2022-09-15 |
| Jg Melon · Two Melons LLC | Sidewalk Cafe | 480 Amsterdam Ave, New York, NY 10024 | 2017-07-21 ~ 2020-09-15 |
| La Sirene Uws · Ain Jupiter LLC | Sidewalk Cafe | 416 Amsterdam Ave, New York, NY 10024 | 2017-07-13 ~ 2020-04-05 |
| Vive La Crepe · Vlc Columbus & 86th LLC | Sidewalk Cafe | 532 Columbus Ave, New York, NY 10024 | 2017-07-13 ~ 2019-04-15 |
| Bagels & Co · Amsterdam Ave Bagels Inc | Sidewalk Cafe | 172 W 79th St, Aka 391 Amsterdam Ave, New York, NY 10024 | 2017-06-15 ~ 2020-06-23 |
| Bodega 88 LLC | Sidewalk Cafe | 573 Columbus Ave, New York, NY 10024 | 2017-06-14 ~ 2021-09-15 |
| Beard Papa's · Muginoho International, Inc. | Sidewalk Cafe | 2167 Broadway, New York, NY 10024 | 2017-05-24 ~ 2019-04-15 |
| Westside Donut Amsterdam Ventures LLC | Sidewalk Cafe | 353 Amsterdam Ave, New York, NY 10024 | 2017-04-07 ~ 2021-09-15 |
| Chop't Creative Salad Company LLC | Sidewalk Cafe | 345 Amsterdam Ave, New York, NY 10024 | 2017-03-16 ~ 2019-12-15 |
| Lokal · Acs Columbus LLC | Sidewalk Cafe | 473 Columbus Ave, New York, NY 10024 | 2017-02-17 ~ 2020-01-20 |
| Arthouse Hotel New York City · Ny Broadway Hotel Owner LLC | Sidewalk Cafe | 2178 Broadway, New York, NY 10024 | 2016-12-29 ~ 2021-04-15 |
| Motorino 3 Inc | Sidewalk Cafe | 510 Columbus Ave, New York, NY 10024 | 2016-11-25 ~ 2019-12-26 |
| Benva Bakery, LLC | Sidewalk Cafe | 440 Amsterdam Ave, New York, NY 10024 | 2016-08-12 ~ 2020-09-15 |
| Saba's Pizza · Moshgab Corp. | Sidewalk Cafe | 403 Amsterdam Ave, New York, NY 10024 | 2016-07-26 ~ 2020-09-15 |
| Olma Caviar Boutique & Lounge · Olma Lounge LLC | Sidewalk Cafe | 420 Amsterdam Ave, New York, NY 10024 | 2016-05-24 ~ 2020-09-15 |
| Jin Ramen · Jin Upper West Side Corp | Sidewalk Cafe | 462 Amsterdam Ave, New York, NY 10024 | 2016-05-09 ~ 2020-12-15 |
| Beer Shop Nyc · Beer Shop LLC | Sidewalk Cafe | 422 Amsterdam Ave, New York, NY 10024 | 2016-04-20 ~ 2020-04-15 |
| Upper West Hospitality LLC | Sidewalk Cafe | 428 Amsterdam Ave, New York, NY 10024 | 2016-04-19 ~ 2020-12-15 |
| Pizzeria Sirenetta · 568 Amsterdam LLC | Sidewalk Cafe | 568 Amsterdam Ave, New York, NY 10024 | 2016-04-19 ~ 2020-07-14 |
| The Dead Poet · Gumbull LLC | Sidewalk Cafe | 450 Amsterdam Ave, New York, NY 10024 | 2016-04-06 ~ 2020-04-15 |
| Senn Thai Comfort Food · Pb Wealth Inc | Sidewalk Cafe | 452 Amsterdam Ave, New York, NY 10024 | 2016-03-15 ~ 2020-09-15 |
| Momoya Upper West · Taikai Inc | Sidewalk Cafe | 427 Amsterdam Ave, New York, NY 10024 | 2015-09-15 ~ 2021-12-15 |
| 2161 Broadway Bakery, LLC | Sidewalk Cafe | 2161 Broadway, New York, NY 10024 | 2015-08-03 ~ 2019-12-15 |
| The Mermaid Inn · Mermaid 88 LLC | Sidewalk Cafe | 570 Amsterdam Ave, New York, NY 10024 | 2015-06-04 ~ 2021-09-15 |
| Risotteria · Risotteria West LLC | Sidewalk Cafe | 375 Amsterdam Ave, New York, NY 10024 | 2015-04-30 ~ 2017-12-15 |
| Blossom On Columbus · Blossom West Inc | Sidewalk Cafe | 507 Columbus Ave, New York, NY 10024 | 2014-09-22 ~ 2015-06-05 |
| The Meatball Shop · 447 Amsterdam Restaurant LLC | Sidewalk Cafe | 447 Amsterdam Ave, New York, NY 10024 | 2014-07-07 ~ 2018-12-15 |
| Red Farm · Rf Broadway LLC | Sidewalk Cafe | 2170 Broadway, New York, NY 10024 | 2014-07-03 ~ 2020-04-15 |
| Tessa · Bt Restaurant Enterprises LLC | Sidewalk Cafe | 349 Amsterdam Ave, New York, NY 10024 | 2014-06-19 ~ 2020-04-15 |
| Lenwich · Lenwich 83rd LLC | Sidewalk Cafe | 469 Columbus Ave, New York, NY 10024 | 2014-06-09 ~ 2020-12-15 |
| E's Bar · Ee Bar LLC | Sidewalk Cafe | 511 Amsterdam Ave, New York, NY 10024 | 2014-05-21 ~ 2020-09-15 |
| Cibo E Vino · Bukefal LLC | Sidewalk Cafe | 2418 Broadway, New York, NY 10024 | 2014-04-25 ~ 2020-09-15 |
| Dls Chicken Corp. | Sidewalk Cafe | 355 Amsterdam Ave, New York, NY 10024 | 2013-10-15 ~ 2013-11-14 |
| Pinkberry · 4sk - 414 Amsterdam LLC | Sidewalk Cafe | 414 Amsterdam Ave, New York, NY 10024 | 2013-08-19 ~ 2015-09-15 |
| Caffi Noi · Caffe Noi Amsterdam LLC | Sidewalk Cafe | 387 Amsterdam Ave, New York, NY 10024 | 2013-06-24 ~ 2015-09-15 |
| Hey Mambo, LLC | Sidewalk Cafe | 487 Amsterdam Ave, New York, NY 10024 | 2013-06-18 ~ 2015-04-15 |
| Amaze · 466 Amaze Corp. | Sidewalk Cafe | 466 Amsterdam Ave, New York, NY 10024 | 2013-02-26 ~ 2015-09-15 |
| Sugar and Plumm (upper West), LLC | Sidewalk Cafe | 173 W 78th St, New York, NY 10024 | 2013-02-01 ~ 2017-12-15 |
| Gastronomie 491 · Nidaja LLC | Sidewalk Cafe | 491 Columbus Ave, New York, NY 10024 | 2012-08-10 ~ 2018-12-15 |
| Celeste · Romagica Corp. | Sidewalk Cafe | 502 Amsterdam Ave, New York, NY 10024 | 2012-05-17 ~ 2020-05-15 |
| Luke's Lobster · Lukes Lobster IIi LLC | Sidewalk Cafe | 426 Amsterdam Ave, New York, NY 10024 | 2012-05-08 ~ 2020-04-15 |
| Vai Uws, LLC | Sidewalk Cafe | 429 Amsterdam Ave, New York, NY 10024 | 2012-04-10 ~ 2020-04-15 |
| Coffee Bean & Tea Leaf · Cb-nact 2169, LLC | Sidewalk Cafe | 2169 Broadway, New York, NY 10024 | 2012-03-08 ~ 2014-12-15 |
| Camelias, LLC | Sidewalk Cafe | 473 Amsterdam Ave, New York, NY 10024 | 2012-03-07 ~ 2014-09-15 |
| Jacob's Pickles · New York Beer Co. LLC | Sidewalk Cafe | 509 Amsterdam Ave, New York, NY 10024 | 2012-01-04 ~ 2020-12-15 |
| Francesa La Vela Cucina Italiana · Sagi Restaurant Corp. | Sidewalk Cafe | 373 Amsterdam Ave, New York, NY 10024 | 2012-01-03 ~ 2018-09-15 |
| Spring Natural Kitchen · Spring Natural Corp. | Sidewalk Cafe | 474 Columbus Ave, New York, NY 10024 | 2011-12-21 ~ 2021-04-15 |
| Amsterdam Ale House Inc | Sidewalk Cafe | 340 Amsterdam Ave, New York, NY 10024 | 2011-11-14 ~ 2021-09-15 |
| Saravana Bhavan · Flagship S B Amsterdam Ny, LLC | Sidewalk Cafe | 413 Amsterdam Ave, New York, NY 10024 | 2011-06-15 ~ 2021-04-15 |
| Cafe Frida · Ixhel Corporation | Sidewalk Cafe | 368 Columbus Ave, New York, NY 10024 | 2011-05-24 ~ 2021-05-15 |
| Spice · 357 Hospitality Inc. | Sidewalk Cafe | 435 Amsterdam Ave, New York, NY 10024 | 2011-04-18 ~ 2021-04-15 |
| Canteen 82 Inc. | Sidewalk Cafe | 467 Columbus Ave, New York, NY 10024 | 2011-03-14 ~ 2017-09-15 |
| 513 Columbus, LLC | Sidewalk Cafe | 513 Columbus Ave, New York, NY 10024 | 2011-03-14 ~ 2019-09-15 |
| Tarallucci E Vino · Il Rifugio Inc. | Sidewalk Cafe | 475 Columbus Ave, New York, NY 10024 | 2011-02-09 ~ 2020-08-17 |
| The Tangled Vine · Mhbk Associates Inc. | Sidewalk Cafe | 434 Amsterdam Ave, New York, NY 10024 | 2010-06-04 ~ 2018-09-15 |
| Big Daddy's · Big Daddys IIi, LLC | Sidewalk Cafe | 2454 Broadway, New York, NY 10024 | 2010-05-11 ~ 2019-07-10 |
| Aged 88 Street LLC | Sidewalk Cafe | 2398 Broadway, New York, NY 10024 | 2010-04-26 ~ 2014-04-15 |
| Arties's Delicatessen · Corned Beef Express, LLC | Sidewalk Cafe | 2290 Broadway, New York, NY 10024 | 2010-04-23 ~ 2018-05-15 |
| Cafe Ducale · Open City Restaurant Group LLC | Sidewalk Cafe | 392 Columbus Ave, New York, NY 10024 | 2010-03-17 ~ 2012-12-15 |
| Thai Season · Nipa Thai Restaurant Corp. | Sidewalk Cafe | 612 Amsterdam Ave, New York, NY 10024 | 2010-02-25 ~ 2014-12-15 |
| Prohibition · J & D Operators, LLC | Sidewalk Cafe | 503 Columbus Ave, New York, NY 10024 | 2010-01-29 ~ 2013-12-15 |
| Via Restaurant · Pita Grill 77 LLC | Sidewalk Cafe | 225 W 77th St, New York, NY 10024 | 2009-06-04 ~ 2011-09-15 |
| Corner West LLC | Sidewalk Cafe | 2328 Broadway, New York, NY 10024 | 2009-06-01 ~ 2011-04-15 |
| Blossom Restaurant & Cafe Inc. | Sidewalk Cafe | 466 Columbus Ave, New York, NY 10024 | 2009-05-20 ~ 2015-04-15 |
| Jps Ventures Inc. | Sidewalk Cafe | 441 Amsterdam Ave, New York, NY 10024 | 2008-05-13 ~ 2020-04-15 |
| Shake Shack · Shake Shack 366 Columbus LLC | Sidewalk Cafe | 366 Columbus Ave, New York, NY 10024 | 2008-05-12 ~ 2020-05-15 |
| Papa Fresh Inc. | Sidewalk Cafe | 594 Amsterdam Ave, New York, NY 10024 | 2008-03-12 ~ 2010-04-15 |
| Cosi, Inc. | Sidewalk Cafe | 2186 Broadway, New York, NY 10024 | 2007-07-24 ~ 2011-12-15 |
| Hi-life Bar & Grill · 83/amsterdam Restaurant Corp. | Sidewalk Cafe | 477 Amsterdam Ave, New York, NY 10024 | 2007-05-11 ~ 2021-05-15 |
| Nice- Matin · Renolta LLC | Sidewalk Cafe | 201 W 79th St, New York, NY 10024 | 2007-04-16 ~ 2021-04-15 |
| 384 Columbus Avenue Associates, L.L.C. | Sidewalk Cafe | 384 Columbus Ave, New York, NY 10024 | 2007-04-15 ~ 2017-04-15 |
| Firehouse Restaurant · Barjer Corp. | Sidewalk Cafe | 522 Columbus Ave, New York, NY 10024 | 2007-04-15 ~ 2021-04-15 |
| 2350 Broadway Rest. Corp. | Sidewalk Cafe | 215 W 85th St, New York, NY 10024 | 2007-03-26 ~ 2011-09-15 |
| Cilantro West, LLC | Sidewalk Cafe | 485 Columbus Ave, New York, NY 10024 | 2007-03-12 ~ 2021-04-15 |
| Isabella's · 359 Columbus Avenue, LLC | Sidewalk Cafe | 359 Columbus Ave, New York, NY 10024 | 2007-03-01 ~ 2017-09-15 |
| Bodrum · Tb 584 Amsterdam Rest. Corp. | Sidewalk Cafe | 584 Amsterdam Ave, New York, NY 10024 | 2007-01-30 ~ 2020-03-17 |
| Bswr Corp. | Sidewalk Cafe | 423 Amsterdam Ave, New York, NY 10024 | 2006-12-07 ~ 2020-12-15 |
| Tolani · 317 Amsterdam Corp. | Sidewalk Cafe | 410 Amsterdam Ave, New York, NY 10024 | 2006-09-16 ~ 2016-09-15 |
| Haru · Haru Amsterdam Avenue Corp. | Sidewalk Cafe | 433 Amsterdam Ave, New York, NY 10024 | 2006-04-07 ~ 2020-09-18 |