From a 500-row sample across 16 columns.
building_idcommunity_boardlatitude+10boroughbuilding_idcommunity_board+6building_idstreet_namecommunity_board+7community_boardMappable — coordinate pair `latitude` / `longitude`.
Open on the map →| building_id | borough | phn | street_name | total_units | order_issue_date | current_status | postcode | latitude | longitude | community_board | council_district |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 119028 | Bronx | 1097 | WALTON AVENUE | 62 | 2022-12-12T00:00:00.000 | Discharged | 10452 | 40.832604 | -73.920926 | 4 | 16 |
| 19605 | Manhattan |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
building_id | integer | The Building ID is a unique numeric identifier assigned to each building by HPD. | 0% | 112079747442827 |
borough | categorical | The Borough is the borough where the building is located. | 0% | BronxBrooklynManhattanof 5 |
phn | text | PHN stands for Primary House Number. PHN is the street number in the building's address. E.g, the house number is '100' in '100 Gold Street.' | 0% | 1051401158 |
street_name | text | The Street Name is the name of the street in the building's address. E.g, the street name is 'Gold Street' in '100 Gold Street.' | 0% |
GET /api/datasets/xpbf-ithr GET /api/datasets/xpbf-ithr/quality GET /api/datasets/xpbf-ithr/related GET /api/columns?dataset=xpbf-ithr
latitudephnboroughbuilding_idstreet_name+8boroughbuilding_idstreet_name+7binlatitudentabin+4| 105 |
| EAST 116 STREET |
| 8 |
| 2015-10-21T00:00:00.000 |
| Discharged |
| 10029 |
| 40.799082 |
| -73.942684 |
| 11 |
| 8 |
| 42525 | Manhattan | 263 | WEST 152 STREET | 25 | 2024-02-16T00:00:00.000 | Discharged | 10039 | 40.82693 | -73.937934 | 10 | 9 |
| 284987 | Brooklyn | 308 | EAST 98 STREET | 4 | 2018-10-03T00:00:00.000 | Active | 11212 | 40.660368 | -73.917793 | 17 | 41 |
| 351643 | Brooklyn | 1682 | PARK PLACE | 20 | 2022-12-12T00:00:00.000 | Discharged | 11233 | 40.671847 | -73.921488 | 16 | 41 |
| 39842 | Manhattan | 405 | WEST 127 STREET | 18 | 2015-10-21T00:00:00.000 | Discharged | 10027 | 40.812854 | -73.953492 | 9 | 7 |
| 347226 | Brooklyn | 1464 | OCEAN AVENUE | 28 | 2015-10-21T00:00:00.000 | Discharged | 11230 | 40.626585 | -73.956565 | 14 | 44 |
| 41668 | Manhattan | 541 | WEST 142 STREET | 19 | 2016-10-24T00:00:00.000 | Discharged | 10031 | 40.823974 | -73.95055 | 9 | 7 |
| 66004 | Bronx | 620 | EAST 178 STREET | 47 | 2024-02-20T00:00:00.000 | Discharged | 10457 | 40.84676 | -73.892439 | 6 | 15 |
| 352685 | Brooklyn | 68 | PATCHEN AVENUE | 8 | 2015-11-12T00:00:00.000 | Discharged | 11221 | 40.689914 | -73.927467 | 3 | 36 |
Showing 12 of 16 columns. All of them are listed below.
GRAND CONCOURSEDECATUR AVENUEHERKIMER STREETtotal_units | integer | Total Units reflects the number of units in the building as of the report run date and may vary from the unit count reported when the building was selected for the Underlying Conditions program. HPD records indicated that all the buildings had at least three dwelling units at the time of selection. | 1% | 10166 |
order_issue_date | datetime | The date the building was issued an Underlying Conditions Order. | 0% | 2017-10-27T00:00:00.0002018-10-03T00:00:00.0002015-10-21T00:00:00.000 |
current_status | categorical | "Active" buildings are currently participating in program. "Discharged" buildings have met a statutory requirement for removal from the program. | 0% | DischargedActiveof 2 |
postcode | text | — | 0% | 104581121310456 |
latitude | float | — | 0% | 40.83457940.82217140.832934 |
longitude | float | — | 0% | -73.943925-73.930368-73.942245 |
community_board | categorical | — | 0% | 539of 18 |
council_district | integer | — | 0% | 15936 |
bin | integer | — | 0% | 200343010607641062752 |
bbl | integer | — | 0% | 102248009220252301613013910061 |
census_tract | integer | — | 0% | 389261188 |
nta | text | — | 0% | Harlem (North)Crown Heights (North)Belmont |