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 |
|---|---|---|---|
| Good Enough To Eat · 520 Columbus Ave., Ltd. | Sidewalk Cafe | 520 Columbus Ave, New York, NY 10024 | 2006-03-01 ~ 2020-09-15 |
| Maryann's Mexican · Mary Ann's Mexican Restaurant Inc | Sidewalk Cafe | 2452 Broadway, New York, NY 10024 | 2006-02-08 ~ 2008-12-15 |
| Fred's · Upper West Rest. Corp. | Sidewalk Cafe | 476 Amsterdam Ave, New York, NY 10024 | 2006-01-30 ~ 2020-12-15 |
| Le Pain Quotidien · Pq West 84th, Inc. | Sidewalk Cafe | 494 Amsterdam Ave, New York, NY 10024 | 2005-08-26 ~ 2020-12-15 |
| Hot and Crusty Bagel Cafe · Cafe 87, Inc. | Sidewalk Cafe | 2387 Broadway, New York, NY 10024 | 2005-07-13 ~ 2007-09-15 |
| Bulgarski & Bulgarski Realty, Inc. | Sidewalk Cafe | 393 Amsterdam Ave, New York, NY 10024 | 2005-04-29 ~ 2007-12-15 |
| Kiman Coffee Shop, Inc. | Sidewalk Cafe | 2173 Broadway, New York, NY 10024 | 2005-02-28 ~ 2013-12-15 |
| The Evelyn · West 78th Street Restaurant Corp. | Sidewalk Cafe | 380a Columbus Ave, New York, NY 10024 | 2005-02-28 ~ 2007-09-15 |
| Manhattan Diner · 2180 Broadway Rest. Inc. | Sidewalk Cafe | 2180 Broadway, New York, NY 10024 | 2005-02-15 ~ 2011-05-15 |
| Broadway Desserts, Ltd. | Sidewalk Cafe | 2340 Broadway, New York, NY 10024 | 2005-02-11 ~ 2020-06-30 |
| Basswood Restaurant Associates LLC | Sidewalk Cafe | 461 Columbus Ave, New York, NY 10024 | 2005-01-13 ~ 2007-04-15 |
| The Bella Luna · New Bella Luna, Inc. | Sidewalk Cafe | 584 Columbus Ave, New York, NY 10024 | 2005-01-06 ~ 2015-12-15 |
| Cosi, Inc. | Sidewalk Cafe | 2160 Broadway, New York, NY 10024 | 2004-04-16 ~ 2007-09-15 |
| Neo Japanese Restaurant · Chung Cheung Corp | Sidewalk Cafe | 2298 Broadway, New York, NY 10024 | 2003-03-18 ~ 2009-09-15 |
| Merchants N.y. · 521 Columbus Ave. Corp. | Sidewalk Cafe | 521 Columbus Ave, New York, NY 10024 | 1994-10-31 ~ 2003-02-28 |
| Ashoka · Shivhari, Inc | Sidewalk Cafe | 489 Columbus Ave, New York, NY 10024 | 2017-05-31 ~ 2019-12-15 |
| Hampton Chutney Company · Seva LLC | Sidewalk Cafe | 464 Amsterdam Ave, New York, NY 10024 | 2015-10-09 ~ 2017-12-15 |
| Bellini · Lvss Inc | Sidewalk Cafe | 483 Columbus Ave, New York, NY 10024 | 2015-07-11 ~ 2017-12-15 |
| Savory Indian Cuisine · Shree Laxmi Indian Cuisine Inc | Sidewalk Cafe | 489 Columbus Ave, New York, NY 10024 | 2015-04-01 ~ 2017-12-15 |
| Polpette · Nicky Meatballs Inc | Sidewalk Cafe | 483 Amsterdam Ave, New York, NY 10024 | 2014-05-08 ~ 2018-04-15 |
| Barley & Grain · B & G Restaurants, LLC | Sidewalk Cafe | 421 Amsterdam Ave, New York, NY 10024 | 2013-08-27 ~ 2019-04-15 |
| Casa Pomona · 507 Columbus Ave, LLC | Sidewalk Cafe | 507 Columbus Ave, New York, NY 10024 | 2013-03-18 ~ 2015-09-15 |
| On The Ave · Ny 2178 Broadway Operating LLC | Sidewalk Cafe | 2170 Broadway, New York, NY 10024 | 2013-03-04 ~ 2015-12-15 |
| Fratelli La Bufala · Flb Viktoria Corp | Sidewalk Cafe | 2161 Broadway, New York, NY 10024 | 2012-11-09 ~ 2014-04-17 |
| Bellini Restaurant · Ephesus Nyc Corp. | Sidewalk Cafe | 483 Columbus Ave, New York, NY 10024 | 2012-06-05 ~ 2014-12-15 |
| Island Burgers & Shakes · Amelia B 1 Corp. | Sidewalk Cafe | 422 Amsterdam Ave, New York, NY 10024 | 2012-04-17 ~ 2018-09-15 |
| Anemonas Rest. Corp. | Sidewalk Cafe | 447 Amsterdam Ave, New York, NY 10024 | 2012-03-23 ~ 2014-12-15 |
| Hummus Kitchen · Hummus Kitchen Amsterdam Avenue Inc. | Sidewalk Cafe | 416 Amsterdam Ave, New York, NY 10024 | 2012-02-24 ~ 2016-09-15 |
| Mamajuana Cafe · Rancho Vida LLC | Sidewalk Cafe | 570 Amsterdam Ave, New York, NY 10024 | 2012-02-14 ~ 2014-09-18 |
| Serafina 77 West, LLC | Sidewalk Cafe | 2178 Broadway, New York, NY 10024 | 2012-02-09 ~ 2020-12-15 |
| Cafe Con Leche · G & J Cafe Inc. | Sidewalk Cafe | 424 Amsterdam Ave, New York, NY 10024 | 2011-07-15 ~ 2015-09-15 |
| De La Fontaine LLC | Sidewalk Cafe | 519 Columbus Ave, New York, NY 10024 | 2011-06-13 ~ 2018-12-15 |
| Prime Ko · Broadway 21, LLC | Sidewalk Cafe | 217 W 85th St, New York, NY 10024 | 2011-01-14 ~ 2013-12-15 |
| 429 Amsterdam Avenue, LLC | Sidewalk Cafe | 429 Amsterdam Ave, New York, NY 10024 | 2010-07-09 ~ 2012-04-15 |
| Sushi Hana Fusion Inc. | Sidewalk Cafe | 466 Amsterdam Ave, New York, NY 10024 | 2010-06-03 ~ 2012-12-15 |
| Land Thai Kitchen · D & D Thai Restaurant Corp. | Sidewalk Cafe | 450 Amsterdam Ave, New York, NY 10024 | 2010-01-11 ~ 2020-04-15 |
| 5 Napkin Burger · Donizetti LLC | Sidewalk Cafe | 2315 Broadway, New York, NY 10024 | 2009-12-28 ~ 2020-07-17 |
| Gari · Gari International Inc. | Sidewalk Cafe | 370 Columbus Ave, New York, NY 10024 | 2009-10-27 ~ 2019-04-15 |
| 511 Amsterdam Vino Corp. | Sidewalk Cafe | 511 Amsterdam Ave, New York, NY 10024 | 2009-06-02 ~ 2013-12-15 |
| Amsterdam Ale House Incorporated | Sidewalk Cafe | 340 Amsterdam Ave, New York, NY 10024 | 2009-05-06 ~ 2011-09-15 |
| La Cocina · La Cocina Mexicana Inc. | Sidewalk Cafe | 217 W 85th St, New York, NY 10024 | 2009-04-24 ~ 2011-04-15 |
| B Cafe West · Jos Hospitality Group, LLC | Sidewalk Cafe | 566 Amsterdam Ave, New York, NY 10024 | 2009-03-31 ~ 2017-12-15 |
| Cheng Du, LLC | Sidewalk Cafe | 507 Columbus Ave, New York, NY 10024 | 2009-03-20 ~ 2009-12-15 |
| 480 Rest Amsterdam Inc. | Sidewalk Cafe | 480 Amsterdam Ave, New York, NY 10024 | 2009-01-20 ~ 2017-12-15 |
| Cgm Ota, LLC | Sidewalk Cafe | 2170 Broadway, New York, NY 10024 | 2008-05-13 ~ 2012-09-15 |
| Ns 77th Street LLC | Sidewalk Cafe | 2178 Broadway, New York, NY 10024 | 2008-04-30 ~ 2010-12-15 |
| Water Moon At Nyc Inc. | Sidewalk Cafe | 467 Columbus Ave, New York, NY 10024 | 2008-03-24 ~ 2010-12-15 |
| Sushi Hana Japanese Fusion Inc. | Sidewalk Cafe | 466 Amsterdam Ave, New York, NY 10024 | 2008-02-07 ~ 2010-12-15 |
| The Mermaid Inn · Mermaid 88, LLC | Sidewalk Cafe | 568 Amsterdam Ave, New York, NY 10024 | 2007-12-17 ~ 2015-09-15 |
| Senor Swanky's Speakeasy · Rls Inc. of N.y. | Sidewalk Cafe | 513 Columbus Ave, New York, NY 10024 | 2007-10-22 ~ 2011-09-15 |
| J of K Corp. | Sidewalk Cafe | 427 Amsterdam Ave, New York, NY 10024 | 2007-08-28 ~ 2015-12-15 |
| Vynl On Columbus, LLC | Sidewalk Cafe | 507 Columbus Ave, New York, NY 10024 | 2007-06-05 ~ 2009-12-15 |
| Ekd Tavern Inc. | Sidewalk Cafe | 450 Amsterdam Ave, New York, NY 10024 | 2007-05-31 ~ 2017-04-15 |
| Amsterdam Avenue Brother Jimmy's, LLC | Sidewalk Cafe | 428 Amsterdam Ave, New York, NY 10024 | 2007-05-28 ~ 2015-09-15 |
| Aix Restaurant & Bar · Sigma Group Inc. | Sidewalk Cafe | 2398 Broadway, New York, NY 10024 | 2007-04-16 ~ 2009-04-15 |
| Zeytin · Food 01 Corp. | Sidewalk Cafe | 519 Columbus Ave, New York, NY 10024 | 2007-04-07 ~ 2011-12-15 |
| Niko's Mediterrean Grill and Bistro · Broadway 76 Ltd. | Sidewalk Cafe | 2161 Broadway, New York, NY 10024 | 2007-03-02 ~ 2011-05-15 |
| Jackson Hole S/c #594 · Re Spec Corp. | Sidewalk Cafe | 517 Columbus Ave, New York, NY 10024 | 2007-03-01 ~ 2016-06-30 |
| Gilli Rest · Gilli, Inc. | Sidewalk Cafe | 417 Amsterdam Ave, New York, NY 10024 | 2007-03-01 ~ 2019-09-15 |
| Three Friends LLC | Sidewalk Cafe | 2418 Broadway, New York, NY 10024 | 2006-11-13 ~ 2012-09-15 |
| Emilio's Italian Eatery, Inc. | Sidewalk Cafe | 413 Amsterdam Ave, New York, NY 10024 | 2006-05-26 ~ 2012-12-15 |
| Monsoon Restaurant · Bowery/grand Foods Inc. | Sidewalk Cafe | 435 Amsterdam Ave, New York, NY 10024 | 2006-05-09 ~ 2008-05-15 |
| 340 Brew Pub Inc. | Sidewalk Cafe | 340 Amsterdam Ave, New York, NY 10024 | 2006-05-03 ~ 2008-04-15 |
| New Store Restaurant Corp. | Sidewalk Cafe | 447 Amsterdam Ave, New York, NY 10024 | 2006-03-02 ~ 2012-09-15 |
| Time Cafe · North On Broadway LLC | Sidewalk Cafe | 2330 Broadway, New York, NY 10024 | 2006-02-28 ~ 2008-04-15 |
| La Cocina · La Cocina Deli Grocery Inc. | Sidewalk Cafe | 217 W 85th St, New York, NY 10024 | 2006-02-27 ~ 2008-12-15 |
| Roppongi · Pensu Corp. | Sidewalk Cafe | 434 Amsterdam Ave, New York, NY 10024 | 2006-02-23 ~ 2008-09-15 |
| Savann Restaurant · Bek Enterprises, Inc. | Sidewalk Cafe | 414 Amsterdam Ave, New York, NY 10024 | 2006-02-03 ~ 2012-04-15 |
| Sol Y Sombre Ltd. | Sidewalk Cafe | 462 Amsterdam Ave, New York, NY 10024 | 2006-01-30 ~ 2014-12-15 |
| Mcaleer's Pub · 425 Amsterdam Cafe, Inc. | Sidewalk Cafe | 425 Amsterdam Ave, New York, NY 10024 | 2006-01-25 ~ 2016-12-15 |
| Global Village Grill, Inc. | Sidewalk Cafe | 421 Amsterdam Ave, New York, NY 10024 | 2005-11-23 ~ 2014-12-15 |
| Ark 474 Corp. | Sidewalk Cafe | 474 Columbus Ave, New York, NY 10024 | 2005-06-08 ~ 2009-12-15 |
| Darna · Ayyy Restaurant Corp. | Sidewalk Cafe | 600 Columbus Ave, New York, NY 10024 | 2005-05-03 ~ 2007-09-15 |
| Jean-luc · Wazoo, LLC | Sidewalk Cafe | 507 Columbus Ave, New York, NY 10024 | 2005-04-28 ~ 2007-04-15 |
| Luzia's Restaurant · Amorluz Corp. | Sidewalk Cafe | 429 Amsterdam Ave, New York, NY 10024 | 2005-04-28 ~ 2010-12-15 |
| 466 Amsterdam Avenue LLC | Sidewalk Cafe | 466 Amsterdam Ave, New York, NY 10024 | 2005-03-24 ~ 2008-04-15 |
| Shining Star Restaurant · Mridula Restaurant Corp. | Sidewalk Cafe | 377 Amsterdam Ave, New York, NY 10024 | 2005-03-22 ~ 2011-04-15 |
| Hale Hospitality, LLC | Sidewalk Cafe | 511 Amsterdam Ave, New York, NY 10024 | 2005-03-11 ~ 2009-12-15 |
| Rancho · Rancho West Corporation | Sidewalk Cafe | 570 Amsterdam Ave, New York, NY 10024 | 2005-03-10 ~ 2012-04-15 |
| Harco, Inc | Sidewalk Cafe | 355 Amsterdam Ave, New York, NY 10024 | 2005-03-04 ~ 2007-09-15 |
| Louie's Westside Cafe · Amsterdam Sloves, Inc. | Sidewalk Cafe | 441 Amsterdam Ave, New York, NY 10024 | 2005-03-02 ~ 2008-05-15 |
| Cafe Con Leche · Cafe Con Leche, Inc. | Sidewalk Cafe | 424 Amsterdam Ave, New York, NY 10024 | 2005-03-02 ~ 2011-09-15 |
| Westside Deli, LLC | Sidewalk Cafe | 2290 Broadway, New York, NY 10024 | 2005-02-22 ~ 2010-05-15 |
| Carmine's Broadway Feast Inc. | Sidewalk Cafe | 2450 Broadway, New York, NY 10024 | 2005-02-18 ~ 2020-04-03 |
| Good Enough To Eat Uptown, Ltd. | Sidewalk Cafe | 483 Amsterdam Ave, New York, NY 10024 | 2005-01-20 ~ 2014-04-15 |
| Monaco · Malka Restaurant Inc. | Sidewalk Cafe | 421 Amsterdam Ave, New York, NY 10024 | 2005-01-19 ~ 2006-02-28 |
| Franc-iano Corp. | Sidewalk Cafe | 485 Columbus Ave, New York, NY 10024 | 2004-12-30 ~ 2007-09-15 |
| 412 Amsterdam Corp. | Sidewalk Cafe | 412 Amsterdam Ave, New York, NY 10024 | 2004-12-29 ~ 2018-12-15 |
| Bistro Citron · Club America, Inc. | Sidewalk Cafe | 473 Columbus Ave, New York, NY 10024 | 2004-12-23 ~ 2017-09-15 |
| The Magical Duck LLC | Sidewalk Cafe | 413 Amsterdam Ave, New York, NY 10024 | 2004-08-31 ~ 2006-09-15 |
| Jacques-imo Restaurant Nyc, Inc. | Sidewalk Cafe | 366 Columbus Ave, New York, NY 10024 | 2004-03-19 ~ 2009-05-15 |
| Zeytin · 519 Columbus Restaurant Corp. | Sidewalk Cafe | 519 Columbus Ave, New York, NY 10024 | 2003-04-08 ~ 2007-02-28 |
| 513 Jjt Corp. | Sidewalk Cafe | 513 Columbus Ave, New York, NY 10024 | 2003-03-25 ~ 2005-02-28 |
| 100 West 79th Street Nyc Corporation | Sidewalk Cafe | 392 Columbus Ave, New York, NY 10024 | 2003-03-24 ~ 2007-12-15 |
| Cafe Monaco · Cafe Monaco, Inc. | Sidewalk Cafe | 421 Amsterdam Ave, New York, NY 10024 | 2003-03-18 ~ 2005-02-28 |
| Fujitama Mama · 467 U-yee Sushi Corp. | Sidewalk Cafe | 467 Columbus Ave, New York, NY 10024 | 2001-02-06 ~ 2003-02-28 |
| Seraj Food, Inc. | Sidewalk Cafe | 556 Columbus Ave, New York, NY 10024 | 2000-12-13 ~ 2003-02-28 |
| Cafe Salsa Entertainment, Inc. | Sidewalk Cafe | 462 Amsterdam Ave, New York, NY 10024 | 2000-05-25 ~ 2005-02-28 |
| The Greenhill Group, LLC | Sidewalk Cafe | 366 Columbus Ave, New York, NY 10024 | 1999-02-01 ~ 2005-02-28 |