From a 500-row sample across 23 columns.
boroughbinlatitude+3boroughbinlatitude+5boroughbin:@computed_region_yeji_bk3q+9Mappable — Socrata point column `location`.
Open on the map →| business_legal_name | assumed_name_s | street | city | postcode | license_type | license_status | latitude | longitude | council_district | community_board | location |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 113 FRANKLIN DINING LLC | SERENECO | 113 FRANKLIN ST | JERSEY CITY | 07307 | Sidewalk | Issued | 40.742486524741 | -74.049745655642 | 33 | 301 | 40.74249, -74.04975 |
| BAKED CLAMS LLC |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
business_legal_name | text | The official registered name of the food establishment. | 0% | BLANK STREET INC.SWEETGREEN NEW YORK, LLCSWEETGREEN NEW YORK LLC |
assumed_name_s | text | If applicable, alternative business name. | 0% | SWEETGREENLE PAIN QUOTIDIENWESTVILLE |
street | text | The street address of the business. | 0% | 3612 BROADWAY3 GREENWICH AVENUE55 3 AVENUE |
city | text | The New York City neighborhood where the business is located. | 0% |
GET /api/datasets/fpeh-f7ci GET /api/datasets/fpeh-f7ci/quality GET /api/datasets/fpeh-f7ci/related GET /api/columns?dataset=fpeh-f7ci
borough:@computed_region_yeji_bk3q:@computed_region_f5dn_yrer+3:@computed_region_yeji_bk3q:@computed_region_f5dn_yrer:@computed_region_sbqj_enih+1binlatitudecommunity_board+5| LIMO BAR |
| 33 AVENUE B |
| NEW YORK |
| 10009 |
| Sidewalk |
| Issued |
| 40.7225118046 |
| -73.983065541094 |
| 2 |
| 103 |
| 40.72251, -73.98307 |
| SICILY STREET FOOD INC | VISIT SICILY NYC | 86 EAST 7 STREET | NEW YORK | 10003 | Sidewalk | Issued | 40.727145388761 | -73.986185221784 | 2 | 103 | 40.72715, -73.98619 |
| WATCHHOUSE COFFEE LLC | WATCHHOUSE COFFEE | 287 PARK AVENUE SOUTH | NEW YORK | 10010 | Sidewalk | Issued | 40.739678047559 | -73.986720296845 | 2 | 105 | 40.73968, -73.98672 |
| PINEAPPLE HOSPITALITY CONSULTING LLC | CAFE COMMERCE | 964 LEXINGTON AVENUE | NEW YORK | 10021 | Roadway | Issued | 40.769327240196 | -73.963009605719 | 4 | 108 | 40.76933, -73.96301 |
| 44 & X HELL'S KITCHEN CORP | 44 & X | 626 10 AVENUE | NEW YORK | 10036 | Sidewalk | Issued | 40.761255237502 | -73.994271265642 | 3 | 104 | 40.76126, -73.99427 |
| FELLINI UES CORP. | Fellini Coffee | 1335 LEXINGTON AVENUE | NEW YORK | 10128 | Roadway | Issued | 40.781261035584 | -73.954282681023 | 5 | 108 | 40.78126, -73.95428 |
| DUMBO RESTAURANT GROUP CORP | 7 OLD FULTON | 7 OLD FULTON STREET | BROOKLYN | 11201 | Sidewalk | Issued | 40.702772523621 | -73.994095980165 | 33 | 302 | 40.70277, -73.99410 |
| SICILY STREET FOOD INC | VISIT SICILY NYC | 86 EAST 7 STREET | NEW YORK | 10003 | Roadway | Issued | 40.727145388761 | -73.986185221784 | 2 | 103 | 40.72715, -73.98619 |
| MORALES 29TH STREET CORP | IL DIVINO | 739 9 AVENUE | NEW YORK | 10019 | Sidewalk | Issued | 40.763387532713 | -73.989025890247 | 3 | 104 | 40.76339, -73.98903 |
Showing 12 of 23 columns. All of them are listed below.
NEW YORKBROOKLYNASTORIAborough | categorical | "The borough in New York City where the business is located. " | 0% | ManhattanBrooklynQueensof 5 |
postcode | text | The five digit zip code of the business location. | 0% | 100121001410003 |
license_type | categorical | The type of permit issued to the food establishment for the participation of the outdoor dining program. | 0% | SidewalkRoadwayof 2 |
license_status | text | The current status of the food establishment. | 0% | Issuedof 1 |
license_issue_date | datetime | The date and time the license was issued to the food establishment. | 0% | 2026-03-27T08:20:14.0002026-07-31T13:17:27.0002026-05-22T08:47:00.000 |
license_expiration_date | datetime | The date and time the license cease for the food establishment. | 0% | 2030-07-31T23:59:59.0002030-08-07T23:59:59.0002030-08-14T23:59:59.000 |
latitude | float | The latitude in decimal degree for the food establishment's location. | 0% | 40.82872361390140.73393127993140.703049225092 |
longitude | float | The longitude in decimal degree for the food establishment's location. | 0% | -73.948757479918-73.987582391545-73.999635561442 |
council_district | integer | The Council District for the food establishment's location. | 0% | 231 |
community_board | integer | Community Boards are volunteer-run neighborhood organizations that work on all kinds of issues pertinent to their communities, often working with elected city officials in doing so. Community Board members, who can be as young as 16, are appointed by Borough Presidents and City Council representatives. They serve two-year terms. There are 59 Community Boards in NYC, each of which represents a unique geographical area, known as a Community District. | 0% | 102103301 |
bin | integer | The BIN (Building Identification Number) is a unique 7-digit number assigned to every known building by the Department of City Planning (DCP), the first digit of which is the borough code. BINs allow city agencies to process and match building-related data easily and in a consistent manner. | 2% | 106650830000904078033 |
bbl | integer | The BBL (Borough, Block, and Lot) is a combination of three numeric codes - a 1-digit borough number, a block number (up to 5 digits) and a lot number (up to 4 digits) - designated and modified by the Department of Finance (DOF). BBLs are used by various city agencies to identify real estate for taxes, zoning, construction, and other purposes. | 1% | 110023775010 |
ct2020 | integer | The Census Tract (Census 2020) is a small, relatively permanent statistical subdivisions of a county uniquely numbered in each county with a numeric code. Note: as part of the geocoding process, leading and trailing zeros are dropped. | 0% | 416567 |
nta2020 | text | The Neighborhood Tabulation Area (Census 2020) are small area boundaries, created by the Department of City Planning (DCP) to aggregate population projections in a small area. Each NTA approximates a minimum population of 15,000. While NTAs were initially created to support PlaNYC, the thirty-year (2000-2030) sustainability plan for NYC, NTAs are now also being used to present data from the Decennial Census and American Community Survey. NTA boundaries and their associated names do not definitiv | 0% | MN0201MN0203MN0303 |
location | coordinate | System-generated column for mapping. | 0% | {'coordinates': [-73.948…{'coordinates': [-73.988…{'coordinates': [-73.999… |