From a 500-row sample across 20 columns.
council_districtbincommunity_board+6bincommunity_boardlongitude+3council_districtbincommunity_board+4council_districtbincommunity_board+5Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| building_id | registration_id | boro_short_name | house_number | street_name | vacate_order_number | primary_vacate_reason | vacate_type | vacate_effective_date | actual_rescind_date | number_of_vacated_units | postoce |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 574773 | 401285 | QN | 89-21 | 169 STREET | 260021 | Fire Damage | Partial | 2025-10-15T00:00:00.000 | 2025-01-07T00:00:00.000 | 2 | 11432 |
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% | 120927806888106762 |
registration_id | text | The Registration ID is a number assigned to residential buildings as per the Housing Maintenance Code. All multiple dwellings (3 units or more) are required to have a registration number (the first digit of the number is the borough in which the building is located). Private dwellings are assigned a registration # if they are required to register. This number uniquely identifies all buildings except New York City Housing Authority (NYCHA) buildings (which are not required to register with HPD) a | 0% | 0214428222175 |
boro_short_name | categorical | The Boro Short Name is the abbreviated name of the borough where the building is located | 0% | BKBXQNof 5 |
GET /api/datasets/tb8q-a3ar GET /api/datasets/tb8q-a3ar/quality GET /api/datasets/tb8q-a3ar/related GET /api/columns?dataset=tb8q-a3ar
binregistration_idcommunity_board+7council_districtbincommunity_board+8council_districtbinnta+4council_districtbincommunity_board+5| 548080 | 924256 | QN | 115-30 | 135 STREET | 105899 | Illegal Occupancy | Partial | 2013-03-07T00:00:00.000 | 2021-10-04T00:00:00.000 | 1 | 11420 |
| 56804 | 215958 | BX | 1104 | CLAY AVENUE | 182231 | Habitability | Partial | 2021-11-16T00:00:00.000 | — | 1 | 10456 |
| 286430 | 0 | BK | 1418 | EAST 103 STREET | 95382 | Illegal Occupancy | Partial | 2012-06-14T00:00:00.000 | 2022-10-28T00:00:00.000 | 1 | 11236 |
| 43065 | 105271 | MN | 453 | WEST 166 STREET | 137788 | Fire Damage | Partial | 2017-06-08T00:00:00.000 | 2017-09-14T00:00:00.000 | 2 | 10032 |
| 398026 | 301338 | BK | 101 | WOODRUFF AVENUE | 226240 | Fire Damage | Partial | 2023-03-27T00:00:00.000 | 2023-09-14T00:00:00.000 | 4 | 11226 |
| 79276 | 204332 | BX | 1250 | FRANKLIN AVENUE | 258391 | Fire Damage | Partial | 2024-05-16T00:00:00.000 | 2024-05-30T00:00:00.000 | 1 | 10456 |
| 305444 | 817508 | BK | 1043 | HALSEY STREET | 113956 | Habitability | Entire Building | 2014-01-27T00:00:00.000 | — | 2 | 11207 |
| 892067 | 0 | SI | 112A | BROAD STREET | 153359 | Illegal Occupancy | Partial | 2020-02-20T00:00:00.000 | 2021-08-05T00:00:00.000 | 1 | 10304 |
| 94358 | 211590 | BX | 2557 | MARION AVENUE | 142636 | Fire Damage | Partial | 2018-02-02T00:00:00.000 | 2018-05-18T00:00:00.000 | 1 | 10458 |
Showing 12 of 20 columns. All of them are listed below.
house_number| 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% |
4012580 |
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% | GRAND CONCOURSEBROADWAYST NICHOLAS AVENUE |
vacate_order_number | integer | Unique number to identify each Vacate Order | 0% | 108149259435149029 |
primary_vacate_reason | categorical | Primary reason the unit/building is vacated. | 0% | Fire DamageIllegal OccupancyHabitabilityof 3 |
vacate_type | categorical | Area affected by the vacate. | 0% | PartialEntire Buildingof 2 |
vacate_effective_date | datetime | The date the Order to Repair/Vacate Order was made effective. | 0% | 2015-12-14T00:00:00.0002015-05-14T00:00:00.0002016-09-21T00:00:00.000 |
actual_rescind_date | datetime | The date the Order to Repair/Vacate Order was rescinded. | 51% | 2025-06-26T00:00:00.0002021-12-09T00:00:00.0002021-03-31T00:00:00.000 |
number_of_vacated_units | integer | Number of units vacated. | 0% | 123 |
postoce | integer | Zip Code of the building's location. | 0% | 104571120711226 |
latitude | float | Latitude of the building's location. | 0% | 40.83172600000000340.85219599999999940.851607000000001 |
longitude | float | Longitude of the building's location. | 0% | -73.922888-73.922326999999996-73.930336999999994 |
community_board | categorical | The Community Board field indicates the New York City Community District where the building is located. | 0% | 1294of 18 |
council_district | integer | The Council District field indicates the New York City Council District where the building is located. | 0% | 151617 |
census_tract | integer | The Census Tract field indicates the U.S. Census Tract where the building is located. | 0% | 379225261 |
bin | integer | The BIN (Building Identification Number) is a unique identifier for each building in the City. | 0% | 200000030000001000000 |
bbl | integer | The BBL (Borough, Block, and Lot) is a unique identifier for each tax lot in the City. | 0% | 202882022930130200012025240064 |
nta | text | The Neighborhood Tabulation Area field indicates the New York City Neighborhood area where the building is located. | 0% | Williamsbridge-OlinvilleSoundview-Bruckner-Bronx…Concourse-Concourse Vill… |