From a 500-row sample across 107 columns.
delchgyrbl_acre+114borocoop_numzoning+8bblezipHas borough codes (`boro`) — joinable, but needs boundary shapes to draw.
| bble | boro | block | lot | secvol | district | year4 | cur_fv_l | cur_fv_t | new_fv_l | new_fv_t | curavl |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2023480052 | 2 | 2348 | 52 | 903 | B1 | 2010 | 210 | 210 | 210 | 210 | 13 |
| 2023260046 | 2 | 2326 | 46 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
bble | text | — | 0% | 204840001320261300212055040006 |
boro | categorical | — | 0% | 435of 5 |
block | integer | — | 0% | 245034325843 |
lot | integer | — | 0% | 11615 |
ease | categorical | — | 100% |
GET /api/datasets/m8p6-tp4b GET /api/datasets/m8p6-tp4b/quality GET /api/datasets/m8p6-tp4b/related GET /api/columns?dataset=m8p6-tp4b
boroboroblockease+1borocoop_numreuc+3boroblocklot| 903 |
| B1 |
| 2010 |
| 375000 |
| 375000 |
| 375000 |
| 375000 |
| 4561 |
| 2023270005 | 2 | 2327 | 5 | 903 | B1 | 2010 | 238000 | 432000 | 238000 | 432000 | 14280 |
| 2023270006 | 2 | 2327 | 6 | 903 | B1 | 2010 | 286000 | 519000 | 286000 | 519000 | 17160 |
| 2023530034 | 2 | 2353 | 34 | 903 | B1 | 2010 | 240000 | 380000 | 240000 | 450000 | 5512 |
| 2023810023 | 2 | 2381 | 23 | 904 | B1 | 2010 | 255000 | 475000 | 255000 | 400000 | 4508 |
| 2023830031 | 2 | 2383 | 31 | 904 | B1 | 2010 | 271800 | 271800 | 272000 | 272000 | 16308 |
| 2024100003 | 2 | 2410 | 3 | 905 | B1 | 2010 | 95400 | 173000 | 95000 | 173000 | 5724 |
| 2024100004 | 2 | 2410 | 4 | 905 | B1 | 2010 | 95400 | 173000 | 95000 | 173000 | 5724 |
| 2024110100 | 2 | 2411 | 100 | 905 | B1 | 2010 | 1381035 | 1381035 | 1381000 | 1381000 | 9331 |
Showing 12 of 96 columns. All of them are listed below.
EFNof 7 |
secvol | integer | — | 0% | 240224011002 |
district | text | — | 0% | 060705 |
year4 | categorical | — | 0% | 201620132017of 8 |
cur_fv_l | integer | — | 0% | 224000215000222000 |
cur_fv_t | integer | — | 0% | 422000400000439000 |
new_fv_l | integer | — | 0% | 168000194000224000 |
new_fv_t | integer | — | 0% | 422000394000439000 |
fv_chgdt | datetime | — | 13% | 2015-12-16T00:00:00.0002016-12-08T00:00:00.0002011-01-08T00:00:00.000 |
curavl | integer | — | 0% | 0972010020 |
curavt | integer | — | 0% | 223942687221496 |
curexl | integer | — | 0% | 016201600 |
curext | integer | — | 0% | 016201600 |
curavl_a | integer | — | 0% | 0972010020 |
curavt_a | integer | — | 0% | 223942687221496 |
curexl_a | integer | — | 0% | 016201600 |
curext_a | integer | — | 0% | 016201600 |
chgdt | datetime | — | 13% | 2016-12-08T00:00:00.0002011-01-08T00:00:00.0002014-05-22T00:00:00.000 |
tn_avl | integer | — | 0% | 9720010020 |
tn_avt | integer | — | 0% | 214962687229859 |
tn_exl | integer | — | 0% | 015501610 |
tn_ext | integer | — | 0% | 015501610 |
tn_avl_a | integer | — | 0% | 9720010020 |
tn_avt_a | integer | — | 0% | 214962687229859 |
tn_exl_a | integer | — | 0% | 015501610 |
tn_ext_a | integer | — | 0% | 015501610 |
fchgdt | datetime | — | 80% | 2013-05-31T00:00:00.0002017-05-19T00:00:00.0002018-05-18T00:00:00.000of 15 |
fn_avl | integer | — | 0% | 9720936010020 |
fn_avt | integer | — | 0% | 214962687229859 |
fn_exl | integer | — | 0% | 016201600 |
fn_ext | integer | — | 0% | 016201600 |
fn_avl_a | integer | — | 0% | 9720936010020 |
fn_avt_a | integer | — | 0% | 214962687229859 |
fn_exl_a | integer | — | 0% | 016201600 |
fn_ext_a | integer | — | 0% | 016201600 |
txcl | categorical | — | 0% | 11B1Aof 5 |
o_txcl | categorical | — | 0% | 11B1Aof 11 |
cbn_txcl | categorical | — | 25% | 11B1Aof 5 |
bldgcl | text | — | 0% | A1A5B1 |
exmtcl | categorical | — | 100% | X1X5X2of 11 |
owner | text | — | 0% | PARKS AND RECREATIONDEPT OF ENVIRONMENTALDCAS |
hnum_lo | text | — | 3% | 000000000015000000000020000000000016 |
hnum_hi | text | — | 3% | 000000000015000000000020000000000016 |
str_name | text | — | 0% | 79 STREET78 STREET80 STREET |
zip | integer | — | 0% | 103141123410312 |
tot_unit | integer | — | 0% | 123 |
res_unit | integer | — | 0% | 123 |
lfrt_dec | integer | — | 0% | 20.0025.0040.00 |
ldep_dec | float | — | 0% | 100.0095.000.00 |
l_acre | text | — | 99% | Aof 1 |
irreg | categorical | — | 87% | IRof 2 |
bfrt_dec | float | — | 0% | 20.0018.0016.00 |
bdep_dec | integer | — | 0% | 40.000.0036.00 |
bld_var | text | — | 100% | — |
ext | categorical | — | 54% | GEGEof 3 |
story | float | — | 0% | 2.003.002.50 |
bldgs | integer | — | 0% | 102 |
corner | categorical | — | 91% | CRSENEof 6 |
lnd_area | integer | — | 0% | 200040002500 |
gr_sqft | integer | — | 0% | 024001800 |
zoning | text | — | 1% | R5R4R3-2 |
yrb | integer | — | 0% | 192019251930 |
yrb_flag | text | — | 23% | Eof 1 |
yrb_rng | integer | — | 0% | 020072006 |
yra1 | integer | — | 0% | 020082005 |
yra1_rng | integer | — | 0% | 020102012 |
yra2 | integer | — | 0% | 020082009 |
yra2_rng | integer | — | 0% | 020102011 |
cp_boro | categorical | — | 0% | 435of 5 |
cp_dist | integer | — | 0% | 3121 |
limit | integer | — | 16% | 1of 1 |
o_limit | integer | — | 17% | 1of 1 |
status1 | categorical | — | 0% | 10of 2 |
status2 | integer | — | 0% | 0of 1 |
newlot | categorical | — | 0% | 01of 2 |
droplot | categorical | — | 0% | 01of 2 |
delchg | categorical | — | 0% | 0ACof 6 |
corchg | integer | — | 0% | 0of 1 |
nodesc | integer | — | 0% | 0of 1 |
noav | categorical | — | 0% | 01of 2 |
valref | categorical | — | 0% | 023of 7 |
mbldg | integer | — | 0% | 0of 1 |
condo_nm | integer | — | 0% | 04752 |
condo_s1 | categorical | — | 97% | RCof 2 |
condo_s2 | categorical | — | 97% | 123of 8 |
condo_s3 | text | — | 100% | — |
condo_a | categorical | — | 99% | ABCof 14 |
comint_l | float | — | 0% | 0.0000000000.0040363460.500000000 |
comint_b | float | — | 0% | 0.0000000000.0040374060.500000000 |
aptno | text | — | 97% | 321 |
ap_boro | categorical | — | 0% | 053of 6 |
ap_block | integer | — | 0% | 057353432 |
ap_lot | integer | — | 0% | 0120 |
ap_ease | categorical | — | 100% | EACof 3 |
ap_date | datetime | — | 90% | 1986-12-25T00:00:00.0001987-04-20T00:00:00.0001997-05-06T00:00:00.000 |
ap_time | integer | — | 0% | 0233501230542 |
protest | categorical | — | 99% | 891of 11 |
at_grp | integer | — | 0% | 032118 |
applic | categorical | — | 99% | 179of 10 |
protest2 | categorical | — | 100% | 891of 6 |
at_grp2 | integer | — | 0% | 018498 |
applic2 | categorical | — | 100% | 714of 4 |
o_protst | categorical | — | 99% | 891of 12 |
o_at_grp | integer | — | 0% | 01814 |
o_applic | categorical | — | 99% | 179of 10 |
reuc | categorical | — | 100% | 1605-GA1810A356-12of 12 |
geo_rc | categorical | — | 0% | 01242of 13 |
coop_num | integer | — | 0% | 0324342 |
ex_inds | categorical | — | 31% | EEEEEEEEEof 8 |
ex_count | categorical | — | 0% | 102of 10 |
ex_chgdt | datetime | — | 100% | 2012-07-17T00:00:00.0002013-07-02T00:00:00.0002010-11-30T00:00:00.000 |
dchgdt | datetime | — | 12% | 1992-12-07T00:00:00.0002015-10-05T00:00:00.0002014-11-06T00:00:00.000 |
sm_chgdt | datetime | — | 12% | 2015-12-16T00:00:00.0002016-12-08T00:00:00.0002011-01-08T00:00:00.000 |