From a 500-row sample across 29 columns.
blockcouncil_district:@computed_region_sbqj_enih+26block:@computed_region_sbqj_enihlongitude+6council_districtbinlongitude+7Mappable — Socrata point column `geocoded_column`.
Open on the map →| borough | boro | block | lot | bbl | hnum_lo | hnum_hi | str_name | crfn | grantee | deed_date | price |
|---|---|---|---|---|---|---|---|---|---|---|---|
| MN | 1 | 2180 | 505 | 1021800505 | 4441 | 4443 | BROADWAY | 2023000150044 | GETTY INDUSTRIES LLC | 2023-05-22T00:00:00.000 | 3200000 |
| BK | 3 | 2443 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
borough | categorical | Borough where property is located (text) | 0% | MNBKBXof 5 |
boro | categorical | Borough where property is located (numeric) | 0% | 132of 5 |
block | integer | Tax block | 0% | 222024562139 |
lot | integer | Tax lot | 0% | 1235 |
bbl | integer | Borough, block, and lot |
GET /api/datasets/adax-9mit GET /api/datasets/adax-9mit/quality GET /api/datasets/adax-9mit/related GET /api/columns?dataset=adax-9mit
blockcouncil_districtbin+8longitudeboroughpostcode+2council_districtbinlongitude+5council_districtbinlongitude+5blockcouncil_districtbin+7| 23 |
| 3024430023 |
| 364 |
| 364 |
| BEDFORD AVENUE |
| 2021000295453 |
| SOUTH 4 HOLDINGS LLC |
| 2021-07-09T00:00:00.000 |
| 14959501 |
| BK | 3 | 5840 | 13 | 3058400013 | 6647 | 6647 | BERGEN PLACE | 2021000172576 | 6647 BERGEN PLACE MANAGEMENT LLC | 2021-04-28T00:00:00.000 | 3750000 |
| MN | 1 | 495 | 31 | 1004950031 | 239 | 239 | MULBERRY STREET | 2022000162370 | OR 239 MULBERRY, LLC | 2022-04-07T00:00:00.000 | 9613000 |
| BX | 2 | 3982 | 1 | 2039820001 | 2501 | 2509 | TRATMAN AVENUE | 2022000208808 | TRATMAN GARDENS LLC | 2022-05-03T00:00:00.000 | 19900000 |
| MN | 1 | 792 | 20 | 1007920020 | 125 | 129 | WEST 16 STREET | 2018000129524 | AAK ACQUISITIONS, LLC | 2018-04-05T00:00:00.000 | 41409879 |
| BX | 2 | 2703 | 50 | 2027030050 | 957 | 959 | KELLY STREET | 2019000033374 | 957 KELLY REALTY LLC | 2019-01-22T00:00:00.000 | 7800000 |
| BX | 2 | 3355 | 1 | 2033550001 | 3242 | 3242 | DECATUR AVENUE | 2020000347786 | 3242 DECATUR ASSOCIATES LLC | 2020-11-24T00:00:00.000 | 3500000 |
| QN | 4 | 3075 | 23 | 4030750023 | 92-40 | 92-40 | QUEENS BOULEVARD | 2022000066463 | 92-40 QUEENS BOULEVARD, LLC | 2022-02-01T00:00:00.000 | 15000000 |
| MN | 1 | 460 | 19 | 1004600019 | 216 | 216 | EAST 5 STREET | 2020000217944 | MOLL, STEPHAN | 2020-07-20T00:00:00.000 | 4000000 |
Showing 12 of 29 columns. All of them are listed below.
| 0% |
202456003640197700291015220037 |
hnum_lo | text | Portion of street address: low house number | 0% | 10011130 |
hnum_hi | text | Portion of street address: high house number | 0% | NA100111 |
str_name | text | Portion of street address: street name | 0% | BROADWAYGRAND CONCOURSEAMSTERDAM AVENUE |
crfn | integer | City Register file number | 0% | 203000000000020200000000002018000242005 |
grantee | text | Name of buyer(s) | 0% | 545-553-557 46TH STREET …HF ROCKAWAY LLC1048-1064 SHERIDAN INVES… |
deed_date | datetime | Execution date of transfer | 0% | 2025-05-16T00:00:00.0002023-09-13T00:00:00.0002018-12-10T00:00:00.000 |
price | integer | Price | 0% | 350000028000005500000 |
cap_rate | float | Capitalization rate | 0% | 0.0320.0290.030 |
borough_cap_rate | float | Borough capitalization rate | 0% | 0.0340.0330.050 |
yearqtr | text | Year and quarter | 0% | 2018Q42018Q22022Q1 |
postcode | integer | — | 1% | 104581003311226 |
latitude | float | — | 1% | 40.83066440.83072240.841551 |
longitude | float | — | 1% | -73.918706-73.86182-73.972129 |
community_board | text | — | 1% | 112207103 |
council_district | text | — | 1% | 101440 |
census_tract | text | — | 1% | 291218263 |
bin | integer | — | 2% | 200273341215101000000 |
nta | text | — | 1% | Washington Heights SouthWashington Heights NorthFlatbush |
geocoded_column | coordinate | — | 1% | {'coordinates': [-73.918…{'coordinates': [-73.914…{'coordinates': [-73.861… |