From a 500-row sample across 24 columns.
average_square_feetmedian_square_feetmedian_years_for_construction+9reporting_year| reporting_year | aggregate_level_citywide | aggregate_level_id | total_storefronts | median_square_feet | average_square_feet | storefront_leased_to_tenants | median_monthly_rent_per_square | average_monthly_rent_per | median_years_leased | average_years_leased | storefronts_with_leases_ending |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2019 | CENSUS TRACT | 2.0089.00 | 57 | 850 | 1990 | 47 | 3 | 5.38 | 5 | 7.27 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
reporting_year | categorical | Storefront Registration Reporting Year | 0% | 202020192024of 6 |
aggregate_level_citywide | categorical | Available Aggregate Levels are Citywide, Borough, Council District and Census Tract | 0% | Census TractCENSUS TRACTCouncil Districtof 8 |
aggregate_level_id | text | Identifies the value for a selected level. | 0% | 282717 |
total_storefronts | integer | Total count of reported storefronts by row for the selected aggregate level | 0% |
GET /api/datasets/dxru-eun8 GET /api/datasets/dxru-eun8/quality GET /api/datasets/dxru-eun8/related GET /api/columns?dataset=dxru-eun8
| 36 |
| 2019 | CENSUS TRACT | 2.0244.00 | 22 | 950 | 1377 | 18 | 2.17 | 2.43 | 1.58 | 3.99 | * |
| 2019 | CENSUS TRACT | 3.0363.00 | 12 | 886 | 3515 | * | * | * | * | * | * |
| 2019 | CENSUS TRACT | 3.0364.00 | 17 | 2000 | 1881 | 13 | 4.14 | 4.32 | 6 | 6.87 | * |
| 2019 | CENSUS TRACT | 3.0366.00 | 13 | 800 | 1358 | 12 | 5.97 | 5.4 | 1 | 2.25 | * |
| 2019 | CENSUS TRACT | 3.0441.00 | 43 | 650 | 993 | 37 | 3 | 4.5 | 5 | 6.7 | 28 |
| 2019 | CITYWIDE | CITYWIDE | 69654 | 1220 | 3032 | 59,266 | 4.51 | 10.74 | 8 | 9.16 | 42,467 |
| 2019 | BOROUGH | MANHATTAN | 25282 | 1250 | 2959 | 22,068 | 9 | 19.51 | 10.01 | 10.97 | 17,753 |
| 2019 | BOROUGH | BRONX | 9944 | 1031 | 2854 | 8,721 | 3 | 4.75 | 7 | 8.79 | 6,435 |
| 2019 | BOROUGH | BROOKLYN | 16353 | 1250 | 2938 | 13,504 | 3.19 | 5.19 | 5 | 7.73 | 8,736 |
Showing 12 of 24 columns. All of them are listed below.
131015median_square_feet | text | Median reported size of storefronts, in square feet | 0% | 1,0001,200800 |
average_square_feet | text | Average reported size of storefronts, in square feet | 0% | 1,5771,0241,748 |
storefront_leased_to_tenants | text | Count of storefronts reported as being occupied by a tenant for this level. This is a subset of the total number of storefronts registered. | 0% | *1211 |
storefront_leased_and_not_operating_on_12_31 | text | A count of the storefronts reported leased to a tenant but not open for business on 12/31 of the reporting year | 17% | *- 00 |
median_monthly_rent_per_square | text | Median of reported rent received for leased storefronts, in monthly dollars per square foot | 0% | 3.004.003 |
average_monthly_rent_per | coordinate | Average of reported rent received for leased storefronts, in monthly dollars per square foot | 0% | *2.643.00 |
median_years_leased | text | Median duration of leases reported for leased storefronts, in years | 0% | 1.005.0010.01 |
average_years_leased | coordinate | Average duration of leases reported for leased storefronts, in months | 0% | *8.196.18 |
storefronts_with_leases_ending | text | Count of storefronts occupied by tenants with leases ending after 12/31/YY. | 0% | *1011 |
median_years_lease_term | coordinate | Median duration of leases reported for leased storefronts, in years | 0% | *3.004.00 |
average_years_lease_term | coordinate | Average duration of leases reported for leased storefronts, in years | 0% | *4.114.82 |
number_whose_lease_is_due | text | Count of leased storefronts with reported leases ending after 6/1 of the calendar year following the reporting year and set to expire within 2 years from 6/1 of the calendar year following the reporting year. | 0% | *100 |
storefront_reported_occupied | text | Count of storefronts reported occupied by the owner. This is a subset of the total number of storefronts registered. | 0% | *0- 0 |
median_years_occupied_by | text | Median duration owners occupied storefronts, in years | 0% | *00.00 |
average_years_occupied_by | coordinate | Average duration owners occupied the storefronts, in years | 0% | *00.00 |
storefront_reported_not_leased | text | Count of storefronts reported as not leased and not owner occupied. This is a subset of the total number of storefronts registered. | 0% | *0- 0 |
median_years_not_leased_and | coordinate | Median duration that storefronts were reported as not leased and not owner occupied, in years | 0% | *01.00 |
average_years_not_leased | coordinate | Average duration that storefronts were reported as not leased and not owner occupied, in years | 0% | *00.00 |
storefront_under_construction | text | This is the number of storefronts reported as under construction and DOB project numbers provided. | 0% | 0- 0* |
median_years_for_construction | coordinate | Median duration for construction projects reported in storefronts, in years | 0% | 00.00- 0 |
average_years_for_construction | coordinate | Average duration for construction projects reported in storefronts, in years | 0% | 00.00- 0 |