From a 132-row sample across 12 columns.
median_years_for_constructionreporting_yearmedian_square_feet+9| reporting_year | aggregate_level_citywide | aggregate_level_id | total_storefronts | median_square_feet | average_square_feet | storefront_leased_to_tenants | storefront_reported_occupied | storefront_reported_not_leased | storefront_under_construction | median_years_for_construction | average_years_for_construction |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2024 | Council District | 30 | 12 | 1240 | 1273 | 0 | * | * | * | * |
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% | 202020212019of 6 |
aggregate_level_citywide | categorical | Available Aggregate Levels are Citywide, Borough, Council District and Census Tract | 0% | Council DistrictBoroughCOUNCIL DISTRICTof 6 |
aggregate_level_id | text | Identifies the value for a selected level. | 0% | 343047 |
total_storefronts | integer | Total count of reported storefronts by row for the selected aggregate level | 0% |
GET /api/datasets/x3n4-h56k GET /api/datasets/x3n4-h56k/quality GET /api/datasets/x3n4-h56k/related GET /api/columns?dataset=x3n4-h56k
| * |
| 2024 | Council District | 38 | 12 | 1200 | 1321 | 0 | * | * | 0 | 0.00 | 0.00 |
| 2024 | Borough | Brooklyn | 133 | 1080 | 1135 | 0 | 33 | 100 | * | * | * |
| 2024 | Council District | 27 | 11 | 900 | 938 | 0 | * | * | 0 | 0.00 | 0.00 |
| 2024 | Council District | 32 | 14 | 1200 | 1385 | 0 | * | * | * | * | * |
| 2024 | Council District | 34 | 14 | 1095 | 1106 | 0 | * | * | * | * | * |
| 2024 | Citywide | Citywide | 238 | 1100 | 1157 | 0 | 73 | 165 | 13 | 0.92 | 1.32 |
| 2024 | Borough | Manhattan | 13 | 1200 | 1214 | 0 | * | * | * | * | * |
| 2024 | Borough | Queens | 75 | 1100 | 1208 | 0 | 34 | 41 | * | * | * |
| 2024 | Council District | 39 | 12 | 950 | 960 | 0 | * | * | 0 | 0.00 | 0.00 |
101219median_square_feet | text | Median reported size of storefronts, in square feet | 0% | 1000.0011001100.00 |
average_square_feet | coordinate | Average reported size of storefronts, in square feet | 0% | 1156.161088.591424 |
storefront_leased_to_tenants | categorical | 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% | *036of 15 |
storefront_reported_occupied | text | Count of storefronts reported occupied by the owner. This is a subset of the total number of storefronts registered. | 0% | *130 |
storefront_reported_not_leased | text | Count of storefronts reported occupied by the owner. This is a subset of the total number of storefronts registered. | 0% | *1116 |
storefront_under_construction | categorical | Count of storefronts reported as under construction | 0% | *026of 11 |
median_years_for_construction | coordinate | Median duration owners occupied storefronts, in years | 0% | *0.000of 14 |
average_years_for_construction | coordinate | Average duration owners occupied the storefronts, in years | 0% | *0.000of 12 |