From a 500-row sample across 29 columns.
:@computed_region_f5dn_yrer:@computed_region_yeji_bk3qcap_rate+26bblcommunity_boardlongitude+5:@computed_region_f5dn_yrer:@computed_region_yeji_bk3qbbl+6Mappable — 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| BX | 2 | 3923 | 28 | 2039230028 | 1537 | 1537 | WHITE PLAINS ROAD | 2026000015133 | 1537 OWNERS LLC | 2025-12-30T00:00:00.000 | 1500000 |
| BX | 2 | 2456 |
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% | MNBXBKof 5 |
boro | categorical | Borough where property is located (numeric) | 0% | 123of 5 |
block | integer | Tax block | 0% | 245619222220 |
lot | integer | Tax lot | 0% | 1741 |
bbl | integer | Borough, block, and lot |
GET /api/datasets/8wi4-bsy4 GET /api/datasets/8wi4-bsy4/quality GET /api/datasets/8wi4-bsy4/related GET /api/columns?dataset=8wi4-bsy4
boroughbblcommunity_board+7bblblockcommunity_board+8bblcommunity_boardlongitude+5:@computed_region_f5dn_yrer:@computed_region_yeji_bk3qborough+14bblblockcommunity_board+8| 40 |
| 2024560040 |
| 1064 |
| 1064 |
| SHERIDAN AVENUE |
| 2026000013775 |
| SHERIDAN AVENUE PROPERTIES LLC |
| 2025-12-23T00:00:00.000 |
| 1173250 |
| BX | 2 | 2456 | 37 | 2024560037 | 1060 | 1060 | SHERIDAN AVENUE | 2026000013774 | SHERIDAN AVENUE PROPERTIES LLC | 2025-12-23T00:00:00.000 | 1914250 |
| BX | 2 | 2456 | 36 | 2024560036 | 1056 | 1056 | SHERIDAN AVENUE | 2026000013773 | SHERIDAN AVENUE PROPERTIES LLC | 2025-12-23T00:00:00.000 | 1111500 |
| BX | 2 | 2456 | 34 | 2024560034 | 1052 | 1052 | SHERIDAN AVENUE | 2026000013772 | SHERIDAN AVENUE PROPERTIES LLC | 2025-12-23T00:00:00.000 | 988000 |
| BX | 2 | 2456 | 32 | 2024560032 | 1048 | 1048 | SHERIDAN AVENUE | 2026000013771 | SHERIDAN AVENUE PROPERTIES LLC | 2025-12-23T00:00:00.000 | 988000 |
| BX | 2 | 4177 | 1 | 2041770001 | 1770 | 1770 | MAHAN AVENUE | 2026000013420 | 1770 PEPA REALTY LLC | 2025-12-30T00:00:00.000 | 3050000 |
| BX | 2 | 4162 | 41 | 2041620041 | 1741 | 1743 | PILGRIM AVENUE | 2026000013414 | 1741 PEPA REALTY LLC | 2025-12-30T00:00:00.000 | 5150000 |
| BX | 2 | 3060 | 45 | 2030600045 | 1975 | 1975 | LAFONTAINE AVENUE | 2026000008926 | 1975 LAFONTAINE PARTNERS LLC | 2025-12-30T00:00:00.000 | 1200000 |
| MN | 1 | 2074 | 44 | 1020740044 | 504 | 504 | WEST 143 STREET | 2026000007652 | POINT 504 REALTY LLC | 2025-12-29T00:00:00.000 | 2575000 |
Showing 12 of 29 columns. All of them are listed below.
| 0% |
101922002430017100491003790037 |
hnum_lo | text | Portion of street address: low house number | 0% | 110121230 |
hnum_hi | text | Portion of street address: high house number | 0% | NA121337 |
str_name | text | Portion of street address: street name | 0% | GRAND CONCOURSEBROADWAYAMSTERDAM AVENUE |
crfn | integer | City Register file number | 0% | 202000000000020180004234562018000281600 |
grantee | text | Name of buyer(s) | 0% | SSPF REIT 1 LLCSTATE PRESERVATION L.P.FORDWASH PARTNERS LLC*BE… |
deed_date | datetime | Execution date of transfer | 0% | 2025-05-16T00:00:00.0002018-12-10T00:00:00.0002019-10-31T00:00:00.000 |
price | integer | Price | 0% | 350000038000005000000 |
cap_rate | float | Capitalization rate | 0% | 0.0460.0410.038 |
borough_cap_rate | float | Borough capitalization rate | 0% | 0.0330.0340.037 |
yearqtr | text | Year and quarter | 0% | 2018Q42018Q32021Q4 |
postcode | integer | — | 3% | 112261045810033 |
latitude | float | — | 3% | 40.68799340.80370340.724379 |
longitude | float | — | 3% | -73.952707-73.985479-73.975536 |
community_board | integer | — | 3% | 112207103 |
council_district | integer | — | 3% | 101415 |
census_tract | integer | — | 3% | 218263291 |
bin | integer | — | 4% | 300054510583771004556 |
nta | text | — | 3% | Washington Heights SouthFlatbushWashington Heights North |
geocoded_column | coordinate | — | — | — |