From a 500-row sample across 23 columns.
streetnamehousenumberbin+2streetnamelongitudehousenumber+8longitudentabbl+5streetnamelongitudehousenumber+9Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| bldg_id | boro_id | block | lot | housenumber | streetname | borough | vacateagency | vacatenumber | vacatecode | vacatereason | monthlyrelocationtotal |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 171001 | 3 | 5919 | 59 | 447 | 74 STREET | Brooklyn | DOB | 0548/23 | BDV | STRUCTURAL | 2015 |
| 993889 | 2 | 5245 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
bldg_id | integer | The Building ID is a unique numeric identifier assigned to each building by HPD. | 0% | 11277380586753671 |
boro_id | categorical | The Borough ID of the borough where the building is located. | 0% | 243of 5 |
block | integer | The number of the Block where the building is located. | 0% | 7005300012350 |
lot | text | The number of the Lot where the building is located. | 0% | 102460 |
GET /api/datasets/3bkg-usya GET /api/datasets/3bkg-usya/quality GET /api/datasets/3bkg-usya/related GET /api/columns?dataset=3bkg-usya
longitudentabbl+5longitudebbllatitude+7longitudentabbl+7streetnamelongitudehousenumber+10| 41 |
| 3310 |
| ROMBOUTS AVENUE |
| Bronx |
| DOB |
| 0673/23 |
| BDV |
| ILLEGAL DWELLING UNITS |
| 437.89 |
| 81668 | 2 | 2464 | 23 | 1235 | GRAND CONCOURSE | Bronx | DOB | 0519/23 | BDV | ILLEGAL DWELLING UNITS | 4500 |
| 290539 | 3 | 4281 | 17 | 659 | EUCLID AVENUE | Brooklyn | HPD | 1697/22 | CEV | ILLEGAL DWELLING UNITS | 4030 |
| 651903 | 4 | 1554 | 11 | 41-12 | ELBERTSON STREET | Queens | DOB | 0621/22 | BDV | ILLEGAL DWELLING UNITS | 437.89 |
| 667233 | 4 | 9187 | 33 | 102-55 | JAMAICA AVENUE | Queens | DOB | 1752/22 | BDV | ILLEGAL DWELLING UNITS | 1950 |
| 46670 | 2 | 3287 | 38 | 2702 | BAINBRIDGE AVENUE | Bronx | DOB | 1203/22 | BDV | ILLEGAL DWELLING UNITS | 4455 |
| 385420 | 3 | 3932 | 36 | 52 | VAN SICLEN AVENUE | Brooklyn | DOB | 0481/23 | BDV | STRUCTURAL | 437.89 |
| 676156 | 4 | 12251 | 39 | 121-06 | LONG STREET | Queens | DOB | 0714/22 | BDV | ILLEGAL DWELLING UNITS | 1829.05 |
| 62468 | 2 | 2319 | 98 | 220 | EAST 134 STREET | Bronx | FDNY | 1343/23 | FDV | STRUCTURAL | 4063.4 |
Showing 12 of 23 columns. All of them are listed below.
housenumber |
| 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% |
12421256244 |
streetname | 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% | BRYANT AVENUENEPTUNE AVENUEUNIVERSITY AVENUE |
borough | categorical | The Borough is the borough where the building is located. | 0% | BronxQueensBrooklynof 5 |
vacateagency | categorical | The Vacate Agency is the agency which issued the Vacate Order. | 0% | HPDDOBFDNYof 3 |
vacatenumber | text | The Vacate Number is the number of the vacate order. | 0% | 0080/220456/220516/22 |
vacatecode | categorical | The Vacate Code is the type of the vacate order. | 0% | CEVBDVFDVof 3 |
vacatereason | categorical | The Vacate Reason is the reason the vacate order was issued. | 0% | ILLEGAL DWELLING UNITSSTRUCTURALESSENTIAL SERVICESof 4 |
monthlyrelocationtotal | float | The Monthly Relocation Total is the sum of all building expense payments aggregated for the referenced building by Vacate Order for the appropriate month and year. | 0% | 20151950437.89 |
month | categorical | The calendar month (numeric) during which the payment was made. | 0% | 658of 12 |
year | categorical | The calendar year during which the payment was made. | 0% | 202520242023of 8 |
postcode | text | Zipcode where the building is located | 0% | 114341046910472 |
latitude | float | Latitude of the building's location | 0% | 40.83364540.80395940.832175 |
longitude | float | Longitude of the building's location | 0% | -73.910796-73.9543-73.887667 |
community_board | categorical | The Community Board field indicates the New York City Community District where the building is located | 0% | 12139of 18 |
council_district | integer | The Council District field indicates the New York City Council District where the building is located | 0% | 121728 |
census_tract | integer | The Census Tract field indicates the U.S. Census Tract where the building is located | 0% | 32812317701 |
bin | integer | The BIN (Building Identification Number) is a unique identifier for each building in the City | 0% | 200216810815732010847 |
bbl | integer | The BBL (Borough, Block, and Lot) is a unique identifier for each tax lot in the City | 0% | 101831005320243100122030000010 |
nta | text | The Neighborhood Tabulation Area field indicates the New York City Neighborhood area where the building is located | 0% | Williamsbridge-OlinvilleBaisley ParkCrotona Park East |