From a 500-row sample across 23 columns.
registrationidlowhousenumbercommunityboard+10lotstreetnameblock+5lotstreetnameblock+6registrationidHas borough codes (`boro`) — joinable, but needs boundary shapes to draw.
| buildingid | boroid | boro | housenumber | lowhousenumber | highhousenumber | streetname | block | lot | communityboard | managementprogram | registrationid |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 859129 | 3 | BROOKLYN | 0 | 0 | 0 | 0 | 0 | 0 | 0 | PVT | 0 |
| 935913 | 2 | BRONX |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
buildingid | integer | Unique identifier of building | 0% | 475040881753461061 |
boroid | categorical | Unique number identifying a borough | 0% | 342of 5 |
boro | categorical | Boro code (1 = Manhattan, 2 = Bronx, 3 = Brooklyn, 4 = Queens, 5 = Staten Island) | 0% | BROOKLYNQUEENSBRONXof 5 |
housenumber | text | Address information for the building | 0% | 152011 |
GET /api/datasets/kj4p-ruqc GET /api/datasets/kj4p-ruqc/quality GET /api/datasets/kj4p-ruqc/related GET /api/columns?dataset=kj4p-ruqc
registrationidlowhousenumbercommunityboard+11lotblockbinbinboro| 00 |
| 00 |
| 00 |
| 00 |
| 0 |
| 0 |
| 0 |
| PVT |
| 0 |
| 510711 | 4 | QUEENS | 198-06 | 198-06 | 198-06 | 100 AVENUE | 10865 | 3 | 12 | PVT | 0 |
| 510865 | 4 | QUEENS | 219-40 | 219-40 | 219-40 | 100 AVENUE | 10773 | 121 | 13 | PVT | 0 |
| 510851 | 4 | QUEENS | 218-33 | 218-33 | 218-33 | 100 AVENUE | 10768 | 46 | 13 | PVT | 0 |
| 510888 | 4 | QUEENS | 222-18 | 222-18 | 222-18 | 100 AVENUE | 10803 | 8 | 13 | PVT | 0 |
| 833505 | 4 | QUEENS | 218-50 | 218-50 | 218-50 | 100 AVENUE | 10767 | 28 | 13 | PVT | 0 |
| 510823 | 4 | QUEENS | 217-40 | 217-40 | 217-40 | 100 AVENUE | 10761 | 25 | 13 | PVT | 418747 |
| 510665 | 4 | QUEENS | 193-01 | 193-01 | 193-01 | 100 AVENUE | 10840 | 1 | 12 | PVT | 0 |
| 510671 | 4 | QUEENS | 193-14 | 193-14 | 193-14 | 100 AVENUE | 10860 | 44 | 12 | PVT | 0 |
Showing 12 of 23 columns. All of them are listed below.
lowhousenumber |
| text |
| Address information for the building |
| 0% |
152011 |
highhousenumber | text | Address information for the building | 0% | 152019 |
streetname | text | Address information for the building | 0% | BROADWAY5 AVENUE3 AVENUE |
zip | text | Address information for the building | 0% | 112071122111208 |
block | integer | Tax block for building | 0% | 034325141 |
lot | integer | Tax lot for building | 0% | 175016 |
bin | integer | DCP Building Identification Number for building | 3% | 300000004000000 |
communityboard | integer | Unique number identifying a Community District/Board, which is a political geographical area within a borough of the City of NY | 0% | 1213 |
censustract | text | Geographic area defined by the U.S. Census Bureau for the various decennial censuses | 0% | 7512277 |
managementprogram | categorical | Contains the current active management program which determines who is responsible for the management of this building | 0% | PVTNYCHACENTRAL MGTof 15 |
dobbuildingclassid | integer | Unique number identifying DoB Building Class Code | 4% | 24252 |
dobbuildingclass | text | Stores DoB building classification codes as augmented by HPD for other than Multiple Dwellings (see DoBBuildingClass below) | 4% | NOT AVAILABLE2 FAMILY HOUSENEW LAW TENEMENT |
legalstories | integer | Number of legal stories in building | 4% | 234 |
legalclassa | integer | The number of apartments in a multiple dwelling | 4% | 231 |
legalclassb | integer | The number of rooms in a multiple dwelling without individual baths and kitchens | 6% | 078 |
registrationid | integer | Multiple dwelling registration number, used by HPD in the master building file to identify a building | 0% | 0399995199995 |
lifecycle | categorical | The stage in the building life cycle | 0% | BuildingDemolishedLandof 6 |
recordstatusid | categorical | Unique number for record status | 0% | 123of 3 |
recordstatus | categorical | "The numeric value of the status of this building code (1 = Active, 2 = Inactive, 3 = Pending)" | 0% | ActiveInactivePendingof 3 |