From a 324-row sample across 47 columns.
statecitybusiness_namestatecitybusiness_name+2statecityzip+1business_nameHas zip codes (`zip`) — joinable, but needs boundary shapes to draw.
| lic_status | business_name | business_name2 | building | street | city | state | zip | swc_type | swc_sq_ft | swc_tables | swc_chairs |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Inactive | ELEVEN FOOD AND BEVERAGE INC. | NULL | 11 | 6TH AVE | NEW YORK | NY | 10013 | Enclosed | 263 | 6 | 26 |
| Inactive | GEORGE'S SCC, INC. |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
license_nbr | text | An identification number issued to businesses/individuals to operate legally for the duration of their license term. | 1% | 1312044-DCA2051463-DCA1463548-DCA |
lic_status | categorical | This indicates whether a sidewalk café license is active or inactive. | 0% | InactiveActiveof 2 |
business_name | text | The legal business name as filed with the New York State Secretary of State or County Clerk | 0% | THE YORK RESTAURANT BAR …151 BLEECKER LLCST. JAMES ASSOCIATES, L.… |
business_name2 | text | If applicable, the Doing-Business-As (DBA)/trade name. | 0% |
GET /api/datasets/qcdj-rwhu GET /api/datasets/qcdj-rwhu/quality GET /api/datasets/qcdj-rwhu/related GET /api/columns?dataset=qcdj-rwhu
city_council_districtstatecitybusiness_name2business_namebusiness_namelicense_nbrstatecitybusiness_name| GEORGE'S RESTAURANT |
| 3000 |
| BUHRE AVE |
| BRONX |
| NY |
| 10461 |
| Enclosed |
| 511 |
| 11 |
| 44 |
| Inactive | DMF GRAMERCY ENTERPRISES, INC. | PETE'S TAVERN S/C #111 | 129 | E 18TH ST | NEW YORK | NY | 10003 | Unenclosed | 611 | 16 | 54 |
| Inactive | 1616 SECOND AVENUE RESTAURANT INC. | DORRIAN'S RED HAND | 1616 | 2ND AVE | NEW YORK | NY | 10028 | Enclosed | 435 | 15 | 34 |
| Inactive | FIRST 69TH ST. REALTY CORP. | WESTSIDE RESTAURANT E/S/C #417 | 2020 | BROADWAY | NEW YORK | NY | 10023 | Enclosed | 422 | 17 | 34 |
| Inactive | CAVALLACCI, FABRIZIO | CAFE REGGIO | 119 | MACDOUGAL ST | NEW YORK | NY | 10012 | Unenclosed | 43 | 4 | 8 |
| Inactive | MEZZALUNA ASSOCIATES | NULL | 1295 | 3RD AVE | NEW YORK | NY | 10021 | Unenclosed | 63 | 2 | 4 |
| Inactive | FRIEND OF A FARMER CORP. | NULL | 77 | IRVING PL | NEW YORK | NY | 10003 | Unenclosed | 252 | 8 | 14 |
| Inactive | TOTORE PIZZERIA & RESTAURANT, INC. | NULL | 3620 | DITMARS BLVD | ASTORIA | NY | 11105 | Enclosed | 395 | 8 | 32 |
| Active | LAMARCA INC. | LAMARCA CHEESE SHOP | 161 | E 22ND ST | NEW YORK | NY | 10010 | Enclosed | 142 | 5 | 10 |
Showing 12 of 46 columns. All of them are listed below.
NULLLE PAIN QUOTIDIENSARABETH'S |
building | text | The building number of the business’s address. | 0% | 20087201 |
street | text | The street name of the business’s address. | 0% | 2ND AVEBROADWAY1ST AVE |
city | categorical | The city where the business is located. | 0% | NEW YORKBROOKLYNASTORIAof 12 |
state | text | The state where the business is located. | 0% | NYof 1 |
zip | text | The zip code where the business is located. | 0% | 100141001310003 |
swc_type | categorical | A sidewalk café is a portion of a legal restaurant that operates on the public sidewalk. There are three types: Enclosed, Unenclosed, and Small Unenclosed. | 0% | UnenclosedEnclosedSmall Unenclosedof 4 |
swc_sq_ft | integer | This indicates the size of the sidewalk café space by square footage as permitted by the business’s DCA license. | 0% | 253280126 |
swc_tables | integer | This indicates the maximum number of tables for the sidewalk café space as permitted by the business’s DCA license. | 0% | 6108 |
swc_chairs | integer | This indicates the maximum number of chairs for the sidewalk café space as permitted by the business’s DCA license. | 0% | 16128 |
dohmh | text | An identification number used by the Department of Health and Mental Hygiene (DOHMH) to permit a food service establishment to operate its business. | 0% | NULL4088792650000549 |
final_x | integer | X coordinate of business’s address using New York Long Island State Plane. | 0% | 987362987083992331 |
final_y | integer | Y coordinate of business’s address using New York Long Island State Plane. | 0% | 202804204072226016 |
community_district | integer | The New York City Community District where a business is located. | 0% | 102108107 |
city_council_district | integer | The New York City Council District where a business is located. | 0% | 316 |
cd_url | url | The URL for the website of the NYC Community District where a business is located. | 0% | http://www.nyc.gov/manha…http://www.cb8m.com/http://www.nyc.gov/mcb7 |
app_id | text | An identification number assigned by DCA to record each application received. | 0% | 35260-2019-RSWC33312-2019-RSWC26478-2019-RSWC |
app_swc_type | categorical | A sidewalk café is a portion of a legal restaurant that operates on the public sidewalk. There are three types: Enclosed, Unenclosed, and Small Unenclosed. | 0% | UnenclosedEnclosedSmall Unenclosedof 4 |
app_sq_ft | integer | The business applied for this amount of square footage space for its sidewalk café. | 0% | 126253200 |
app_tables | integer | The business applied for this number of tables for its sidewalk café space. | 0% | 6104 |
app_chairs | integer | The business applied for this number of chairs for its sidewalk café space. | 0% | 16128 |
app_status | categorical | This indicates the status of a business’s DCA sidewalk café application. | 0% | Pending ReviewApplication Review Compl…Application Withdrawnof 4 |
app_status_date | datetime | The date when a business’s DCA sidewalk café application reached its APP_STATUS. | 0% | 2020-05-28T00:00:00.0002021-10-07T00:00:00.0002020-06-05T00:00:00.000 |
expiration_date | datetime | Expiration date of Temporary Operating Letter or DCA License. | 1% | 2020-06-30T00:00:00.0002020-03-31T00:00:00.0002020-08-28T00:00:00.000 |
app_too_date | datetime | Expiration date of Temporary Operating Letter. DCA may issue a Temporary Operating Letter to certain applicants while their license application is being reviewed. This allows the business to legally operate for a specific time period. | 4% | 2020-03-31T00:00:00.0002020-06-30T00:00:00.0002020-08-28T00:00:00.000 |
submit_date | datetime | Latest date when a business pays (a portion of) its submission fee for a DCA sidewalk café license application. | 0% | 2019-12-19T00:00:00.0002020-02-12T00:00:00.0002019-12-12T00:00:00.000 |
intake | categorical | Status of DCA receipt of a sidewalk café license application. | 0% | Ready For ReviewNULLof 2 |
intake_dd | datetime | The date when an application’s intake reached its current status. | 2% | 2019-12-12T00:00:00.0002020-02-12T00:00:00.0002019-12-19T00:00:00.000 |
dpqa | categorical | Status of DCA review of a sidewalk café license application. | 0% | Issued Temp Op LetterUnder ReviewApprovedof 7 |
send_package_dd | datetime | Date when the sidewalk café license application was sent to the relevant Borough President, Community Board, City Council Member, and Speaker of the Council. | 8% | 2019-11-26T00:00:00.0002019-09-16T00:00:00.0002019-12-23T00:00:00.000 |
cp | categorical | Status of the NYC Department of City Planning’s review of enclosed sidewalk café applications. | 0% | Pending ReviewNULLProceedof 4 |
cp_dd | datetime | Date when the application’s Department of City Planning review reached its current status. | 7% | 2020-02-25T00:00:00.0002019-09-13T00:00:00.0002020-02-12T00:00:00.000 |
cb | categorical | Status of the relevant Community Board’s review of a sidewalk café license application. | 0% | Review Period ExpiredPending ReviewRecommend Approvalof 5 |
cb_dd | datetime | Date when the application’s Community Board review reached its current status. | 7% | 2020-02-13T00:00:00.0002020-04-17T00:00:00.0002020-01-24T00:00:00.000 |
hearing | categorical | Status of the public hearing for reviewing sidewalk café license applications. | 0% | WaivedPending ReviewRecommendation Issuedof 4 |
hearing_dd | datetime | Date when the application’s public hearing reached its current status. | 40% | 2020-02-13T00:00:00.0002020-04-17T00:00:00.0002019-11-07T00:00:00.000 |
hearing_public | categorical | If a public hearing is scheduled, value will be “SWC Public Hearing”. | 0% | NULLSWC Public Hearingof 2 |
hearing_public_dd | datetime | If applicable, the date when a public hearing is scheduled. | 80% | 2020-04-01T00:00:00.0002020-03-25T00:00:00.0002019-12-18T00:00:00.000 |
cc | categorical | Status of City Council review of a business’s sidewalk café license application. | 0% | Review Period ExpiredPending ReviewNULLof 4 |
cc_dd | datetime | Date when the application’s City Council review reached its current status. | 42% | 2020-03-05T00:00:00.0002020-05-08T00:00:00.0002020-02-19T00:00:00.000 |
moo | categorical | Status of Mayor’s Office of Contract Services (MOCS) review of a business’s sidewalk café license application. | 0% | Pending ReviewApprovedNULLof 3 |
moo_dd | datetime | Date when the application’s MOCS review reached its current status. | 90% | 2020-06-22T00:00:00.0002015-06-01T00:00:00.0002020-03-11T00:00:00.000 |
issuance | categorical | Status of DCA sidewalk café license issuance. | 0% | Pending ReviewIssuedNULLof 3 |
issuance_dd | datetime | Date when the application’s issuance reached its current status. | 94% | 2020-06-22T00:00:00.0002016-11-17T00:00:00.0002018-07-25T00:00:00.000of 16 |