From a 500-row sample across 30 columns.
boroughlongitudecouncil_district+6longitudecouncil_districtcensus_tract+6longitudecouncil_districtcensus_tract+6longitudecouncil_districtcensus_tract+6Mappable — Socrata point column `lat_long`.
Open on the map →| filing_due_date | reporting_year | borough_block_lot | property_street_address_or | borough | zip_code | construction_reported | primary_business_activity | expir_dt_of_most_recent_lease | property_number | property_street | borough_1 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2024-06-03T00:00:00.000 | 2023 | 5051430020 | 3996 AMBOY ROAD | STATEN ISLAND | 10308 | N | EDUCATIONAL SERVICES | 2023-12-31T00:00:00.000 | 3996 | AMBOY ROAD |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
filing_due_date | datetime | The filing due date for the information shown from the primary registration and/ or supplemental storefront registration. | 0% | 2021-08-15T00:00:00.0002020-08-15T00:00:00.0002023-08-15T00:00:00.000of 11 |
reporting_year | categorical | Year of the reporting period's end date on the primary registration and supplemental storefront registration. For example; primary registrations whose reporting period that ended on December 31, 2019 and their corresponding supplemental storefront registration that ended the following year on June 30, 2020, would have ""2019 and 2020"" in this column. | 0% | 2020 and 20212019 and 20202024of 7 |
borough_block_lot | text | 10 digit Borough-Block-Lot of the property where the storefront is located | 0% | 20392910011007551003 |
GET /api/datasets/92iy-9c3n GET /api/datasets/92iy-9c3n/quality GET /api/datasets/92iy-9c3n/related GET /api/columns?dataset=92iy-9c3n
boroughlongitudebbl+6boroughlongitudecouncil_district+6boroughbincommunity_board+1| STATEN ISLAND |
| 2024-06-03T00:00:00.000 | 2023 | 5005430010 | 271 BROAD STREET | STATEN ISLAND | 10304 | N | NO BUSINESS ACTIVITY IDENTIFIED | — | 271 | BROAD STREET | STATEN ISLAND |
| 2024-06-03T00:00:00.000 | 2023 | 5051430017 | 3 NELSON AVENUE | STATEN ISLAND | 10308 | N | EDUCATIONAL SERVICES | 2023-12-31T00:00:00.000 | 3 | NELSON AVENUE | STATEN ISLAND |
| 2024-06-03T00:00:00.000 | 2023 | 5006550014 | 1366 CLOVE ROAD | STATEN ISLAND | 10301 | N | NO BUSINESS ACTIVITY IDENTIFIED | — | 1366 | CLOVE ROAD | STATEN ISLAND |
| 2024-06-03T00:00:00.000 | 2023 | 5001730034 | 693 HENDERSON AVENUE | STATEN ISLAND | 10310 | N | NO BUSINESS ACTIVITY IDENTIFIED | — | 693 | HENDERSON AVENUE | STATEN ISLAND |
| 2024-06-03T00:00:00.000 | 2023 | 5080280095 | 449 CRAIG AVENUE | STATEN ISLAND | 10307 | — | LEGAL SERVICES | 2023-12-31T00:00:00.000 | 449 | CRAIG AVENUE | STATEN ISLAND |
| 2024-06-03T00:00:00.000 | 2023 | 3012540138 | 796 NOSTRAND AVENUE | BROOKLYN | 11216 | N | NO BUSINESS ACTIVITY IDENTIFIED | — | 796 | NOSTRAND AVENUE | BROOKLYN |
| 2024-06-03T00:00:00.000 | 2023 | 3055350006 | 6211 20 AVENUE | BROOKLYN | 11204 | N | BROADCASTING/TELECOMM | 2023-12-31T00:00:00.000 | 6211 | 20 AVENUE | BROOKLYN |
| 2024-06-03T00:00:00.000 | 2023 | 3029070076 | 813 METROPOLITAN AVENUE | BROOKLYN | 11211 | — | WHOLESALE | 2023-12-31T00:00:00.000 | 813 | METROPOLITAN AVENUE | BROOKLYN |
| 2024-06-03T00:00:00.000 | 2023 | 4036770027 | 65-55 MYRTLE AVENUE | QUEENS | 11385 | N | NO BUSINESS ACTIVITY IDENTIFIED | — | 65-55 | MYRTLE AVENUE | QUEENS |
Showing 12 of 28 columns. All of them are listed below.
3006870001property_street_address_or | address | Reported street address for the storefront or the property address where the storefront is located | 0% | 90-15 QUEENS BOULEVARD2660 HYLAN BOULEVARD75 9 AVENUE |
borough | categorical | Borough where the storefront is located | 0% | MANHATTANBROOKLYNQUEENSof 5 |
zip_code | text | ZIP code where the storefront is located | 1% | 100021001310001 |
sold_date | datetime | MM/DD/YYYY; Date property was reported sold if between 1/1 and 6/30, otherwise blank. | 100% | 2021-06-18T00:00:00.0002021-06-10T00:00:00.0002022-03-24T00:00:00.000 |
vacant_on_12_31 | categorical | YES - the storefront was reported vacant on 12/31 of the reporting year. NO - the storefront was reported owner-occupied or leased on 12/31 of the reporting year. | 1% | NOYESYof 3 |
construction_reported | categorical | YES - construction is reported in the storefront as of 12/31. | 97% | NNOYESof 4 |
vacant_6_30_or_date_sold | text | For Classes 2 and 4: YES - following 12/31 of the reporting year, the storefront was reported vacant on 6/30 or the date the property was sold if earlier than 6/30. Blank means there is no reported information. | 96% | YESof 1 |
primary_business_activity | categorical | For Classes 2 and 4: Local Law 157 requires owners to submit a supplemental registration to report any property ownership changes or storefronts that become vacant between 1/1 and 6/30 after the reporting year, and for the Department of Finance to identify storefronts reported vacant as of 6/30. Some property owners who did not submit main registrations or submitted main registrations with missing information used the supplemental registration to provide information on the vacancy status of sto | 2% | RETAILFOOD SERVICESNO BUSINESS ACTIVITY IDE…of 19 |
expir_dt_of_most_recent_lease | datetime | The expiration date of the most recent lease for vacant premises, as reported by owner. | 83% | 2023-12-31T00:00:00.0002024-12-31T00:00:00.0002025-12-31T00:00:00.000 |
property_number | text | Address number for the building. | 0% | 2001100 |
property_street | text | Street name or number for the building. | 0% | BROADWAY3 AVENUE5 AVENUE |
unit | text | Unit number for the property. | 89% | COMM1C1 |
borough_1 | categorical | ZIP Code for the building where the storefront is located. | 0% | MANHATTANBROOKLYNQUEENSof 10 |
postcode | text | ZIP Code for the building where the storefront is located. | 0% | 100021001310001 |
latitude | float | Latitude | 1% | 040.657114540.834087 |
longitude | float | Longitude | 1% | 0-74.0068046-73.9798403 |
lat_long | coordinate | Combined Latitude and Longitude | 1% | {'coordinates': [0.0, 0.…{'coordinates': [-74.006…{'coordinates': [-73.870… |
community_board | text | Community board for the building where the storefront is located and designated within borough. | 0% | 125 |
council_district | text | Council district for the building where the storefront is located. | 0% | 0441 |
census_tract | text | Census tract designated within the borough for the building where the storefront is located. | 0% | 9618002100 |
bin | text | Building Identification Number (BIN) for the building where the storefront is located. | 0% | 300000040000001084820 |
bbl | text | BBL (Borough, Block and Lot) for the building where the storefront is located. | 0% | 203929100110075510033006870001 |
nta | text | Neighborhood Tabulation Area (NTA) code for the building where the storefront is located. | 0% | MN17MN0502MN24 |
nbhd | text | Neighborhood name associated with Neighborhood Tabulation Area (NTA) for the building where the storefront is located. | 0% | Midtown-Midtown SouthMidtown-Times SquareUpper East Side-Carnegie… |