From a 500-row sample across 19 columns.
total_unitscensus_tractphn+10total_unitscensus_tractlongitude+10census_tractlongitudestreet_address+6Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| building_id | boro | phn | street_address | total_units | aep_start_date | of_b_c_violations_at_start | current_status | discharge_date | aep_round | postcode | latitude |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 324094 | Brooklyn | 195 | LENOX ROAD | 12 | 2007-11-13T00:00:00.000 | 1106 | AEP Discharged | 2011-11-02T00:00:00.000 | Aep Round 1 | 11226 | 40.653949 |
| 43372 |
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% | 77585225293438 |
boro | categorical | The Borough is the borough where the building is located. | 0% | BrooklynBronxManhattanof 5 |
phn | text | The House Number is the street number in the building's address. E.g, the house number is '100' in '100 Gold Street.' | 0% | 18010520 |
street_address | 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/hcir-3275 GET /api/datasets/hcir-3275/quality GET /api/datasets/hcir-3275/related GET /api/columns?dataset=hcir-3275
census_tractlongitudecouncil_districtcensus_tractlongitudecouncil_district+6total_unitsborobinlongitudecouncil_districtcommunity_board+3| Manhattan |
| 512 |
| WEST 180 STREET |
| 21 |
| 2026-02-02T00:00:00.000 |
| 1222 |
| AEP Discharged |
| 2026-07-07T00:00:00.000 |
| Aep Round 19 |
| 10033 |
| 40.847696 |
| 876311 | Brooklyn | 1575 | EAST NEW YORK AVENUE | 3 | 2015-02-02T00:00:00.000 | 155 | AEP Discharged | 2016-09-21T00:00:00.000 | Aep Round 8 | 11212 | 40.672676 |
| 81496 | Bronx | 2118 | GRAND AVENUE | 3 | 2009-11-12T00:00:00.000 | 193 | AEP Discharged | 2016-10-26T00:00:00.000 | Aep Round 3 | 10453 | 40.855688 |
| 42732 | Manhattan | 605 | WEST 156 STREET | 41 | 2024-01-31T00:00:00.000 | 902 | AEP Discharged | 2024-06-11T00:00:00.000 | Aep Round 17 | 10032 | 40.83365 |
| 9836 | Manhattan | 940 | COLUMBUS AVENUE | 12 | 2016-02-01T00:00:00.000 | 283 | AEP Discharged | 2016-10-06T00:00:00.000 | Aep Round 9 | 10025 | 40.799394 |
| 675955 | Queens | 109-05 | LIVERPOOL STREET | 3 | 2011-01-31T00:00:00.000 | 82 | AEP Discharged | 2011-07-15T00:00:00.000 | Aep Round 4 | 11435 | 40.690334 |
| 287222 | Brooklyn | 1352 | EAST NEW YORK AVENUE | 10 | 2022-01-31T00:00:00.000 | 83 | AEP Discharged | 2023-09-22T00:00:00.000 | Aep Round 15 | 11212 | 40.669409 |
| 371875 | Brooklyn | 354 | SOUTH 1 STREET | 8 | 2021-02-01T00:00:00.000 | 247 | AEP Discharged | 2023-03-01T00:00:00.000 | Aep Round 14 | 11211 | 40.710642 |
| 366015 | Brooklyn | 134 | SACKMAN STREET | 4 | 2024-01-31T00:00:00.000 | 484 | AEP Active | — | Aep Round 17 | 11233 | 40.675066 |
Showing 12 of 19 columns. All of them are listed below.
AMSTERDAM AVENUEHANCOCK STREETST NICHOLAS AVENUEtotal_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 AEP program. HPD records indicated that all the buildings had at least three dwelling units at the time of selection. | 0% | 638 |
aep_start_date | datetime | The date the building was selected for participation in the AEP. All buildings in a particular round will have the same start date. | 0% | 2026-02-02T00:00:00.0002019-01-31T00:00:00.0002020-01-31T00:00:00.000of 19 |
of_b_c_violations_at_start | integer | The count of hazardous and immediately hazardous violations open on the date the building was selected for participation in the AEP. | 0% | 240292205 |
current_status | categorical | "Active" buildings are currenty participating in program. "Discharged" buildings have met a statutory requirement for removal from the program. | 0% | AEP DischargedAEP Activeof 2 |
discharge_date | datetime | The date the building was removed from the program. | 20% | 2011-04-06T00:00:00.0002016-06-14T00:00:00.0002018-06-19T00:00:00.000 |
aep_round | categorical | The round identifies a group of buildings selected for the AEP annually. | 0% | Aep Round 9Aep Round 10Aep Round 11of 19 |
postcode | integer | — | 0% | 112331122111207 |
latitude | float | — | 0% | 40.84266440.85858540.676487 |
longitude | float | — | 0% | -73.888943-73.891052-73.950205 |
community_board | categorical | — | 0% | 435of 18 |
council_district | integer | — | 0% | 374136 |
census_tract | integer | — | 0% | 369261269 |
bin | integer | — | 0% | 200000030000002010049 |
bbl | integer | — | 0% | 102248009220435200102029550040 |
nta | text | — | 0% | Crown Heights (North)Bedford-Stuyvesant (East…Bushwick (East) |