From a 500-row sample across 35 columns.
binntaborough+3binboroughlongitude+5boroughboroughMappable — coordinate pair `latitude` / `longitude`.
Open on the map →| objectid | globalid | seating_interest_sidewalk | restaurant_name | legal_business_name | doing_business_as_dba | bulding_number | street | borough | zip | business_address | food_service_establishment |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 100 | c4b3155b-31a0-4e95-846f-fce09f245437 | sidewalk | Pomp and Circumstance Hospitality | Pomp and Circumstance Hospitality LLC | Pomp and Circumstance Hospitality LLC | 577 | Lorimer Street | Brooklyn | 11211 | 577 Lorimer Street, Brooklyn, NY |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
objectid | text | — | 0% | 7067129217066 |
globalid | text | — | 0% | {98116B37-C5FA-4989-81B1…{590A6C15-466C-4B8E-811F…{A045EE75-D9FC-4786-8884… |
seating_interest_sidewalk | categorical | — | 0% | bothsidewalkroadwayof 4 |
restaurant_name | text | — | 0% | PRET A MANGERJUST SALADSWEETGREEN |
GET /api/datasets/pitm-atqc GET /api/datasets/pitm-atqc/quality GET /api/datasets/pitm-atqc/related GET /api/columns?dataset=pitm-atqc
| 50094274 |
| 1000 | 753495d8-4429-43e5-85a3-dcf6230ef749 | both | Charm Kao | 193 Schemerhorn INC | Charm Kao | 193 | Schermerhorn St. | Brooklyn | 11201 | 193 Schermerhorn St., Brooklyn, NY | 50087605 |
| 10000 | {3842B5C5-EF04-41A4-8216-D6EA627DCE5E} | openstreets | SAKE BAR HAGI 46 | HAMA NEW YORK, INC. | SAKE BAR HAGI 46 | 358 | W. 46TH STREET | Manhattan | 10036 | 358 W. 46TH STREET, Manhattan, NY | 50041331 |
| 10001 | {C212A0FC-C115-4425-8F95-931B12C5F86A} | openstreets | Yum yum too | Boythaicorp | Boythaicorp | 662 | 9ave | Manhattan | 10036 | 662 9ave, Manhattan, NY | 50088036 |
| 10002 | {DA48265D-7730-416F-8E1C-EBC8C8ACE2C2} | openstreets | Xochil Pizza Corp | Xochil Pizza Corp | Xochil Pizza Corp | 4632 | 5th Avenue | Brooklyn | 11220 | 4632 5th Avenue , Brooklyn, NY | 50011100 |
| 10003 | {46F009AC-1DF9-4F39-8973-01E407466B67} | openstreets | BECKETTS BAR | 81 PEARL STREET V ENTURE LTD | 81 PEARL STREET V ENTURE LTD | 81 | PEARL STREET | Manhattan | 10004 | 81 PEARL STREET, Manhattan, NY | 50004654 |
| 10004 | {DA22A48D-3C12-4E33-895C-2E6F02CA4370} | openstreets | Rico Pollo 3 | Rico Pollo 3 | Rico Pollo 3 | 4523 | 5th Avenue | Brooklyn | 11220 | 4523 5th Avenue , Brooklyn, NY | 50090510 |
| 10005 | {B9E7740C-95B7-4992-81F5-437B17FF0627} | both | Patisserie Fouet | Patisserie Fouet | YS Pastry LLC | 1009402 | 13th Street | Manhattan | 10003 | 1009402 13th Street, Manhattan, NY | 50088038 |
| 10006 | {D90EC6E8-6D48-4A26-8DD0-2C64E4CB168A} | openstreets | Tropical Sensation Restaurant | Tropical Sensation | Tropical Sensation | 953 | Amsterdam Ave. | Manhattan | 10025 | 953 Amsterdam Ave., Manhattan, NY | 41297129 |
| 10007 | {D727EBEB-48A4-4BAE-85E1-44F3355A8DDA} | sidewalk | MANHATTANVILLE COFFEE | MANHATTANVILLE COFFEE, LLC | MANHATTANVILLE COFFEE, LLC | 142 | EDGECOMBE AVE | Manhattan | 10030 | 142 EDGECOMBE AVE, Manhattan, NY | 50074795 |
Showing 12 of 35 columns. All of them are listed below.
legal_business_name | text | — | 0% | SWEETGREEN NEW YORK LLCSTARBUCKS CORPORATIONPRET A MANGER (USA) LIMI… |
doing_business_as_dba | text | — | 0% | PRET A MANGERSWEETGREENJUST SALAD |
bulding_number | text | — | 11% | undefined1200 |
street | text | — | 0% | Broadway5th Avenue3rd Avenue |
borough | categorical | — | 0% | ManhattanBrooklynQueensof 5 |
zip | text | — | 0% | 100031001210014 |
business_address | text | — | 0% | 445 Albee Square West, B…4101 KISSENA BLVD, Queen…6802 4 AVENUE, Brooklyn,… |
food_service_establishment | text | — | 0% | 0PENDING50053940 |
sidewalk_dimensions_length | integer | — | 16% | 201525 |
sidewalk_dimensions_width | integer | — | 16% | 864 |
sidewalk_dimensions_area | integer | — | 16% | 120240300 |
roadway_dimensions_length | integer | — | 37% | 202518 |
roadway_dimensions_width | integer | — | 37% | 867 |
roadway_dimensions_area | integer | — | 37% | 160200144 |
approved_for_sidewalk_seating | categorical | — | 0% | yesnoof 2 |
approved_for_roadway_seating | categorical | — | 0% | yesnoof 2 |
qualify_alcohol | categorical | — | 0% | yesnoof 2 |
sla_serial_number | text | — | 35% | ########################…Nov-06Oct-06 |
sla_license_type | categorical | — | 35% | OPRWTWof 7 |
landmark_district_or_building | categorical | — | 0% | noyesof 2 |
landmarkdistrict_terms | text | — | 85% | yesof 1 |
healthcompliance_terms | text | — | 0% | yesof 1 |
time_of_submission | datetime | — | 0% | 2021-10-19T16:36:00.0002021-10-19T16:31:00.0002020-06-19T13:03:00.000 |
latitude | float | — | 9% | 40.69083340.70276340.741876 |
longitude | float | — | 9% | -73.983452-73.986681-74.004713 |
community_board | categorical | — | 9% | 213of 19 |
council_district | text | — | 9% | 312 |
census_tract | text | — | 9% | 386765 |
bin | text | — | 10% | 300000040000003397861 |
bbl | text | — | 10% | 300149750130004000011007130001 |
nta | text | — | 9% | West VillageMidtown-Midtown SouthSoHo-TriBeCa-Civic Cente… |