From a 500-row sample across 67 columns.
extractdtperiodparid+2boroblockbldg_class+8blocklotHas borough codes (`boro`) — joinable, but needs boundary shapes to draw.
| parid | boro | block | lot | rectype | year | period | exmp_code | exmp_code_suffix | exmp_seq | nys_exmp_code | pstatus |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1000010010 | 1 | 1 | 10 | 1 | 2024 | 1 | 2231 | 22311 | 6 | 13356 | A |
| 1000010101 | 1 | 1 | 101 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
parid | text | Property ID key | 0% | 416350040041635003004163400050 |
boro | categorical | Borough | 0% | 342of 5 |
block | text | Block Number | 0% | 1639443943 |
lot | text | Lot Number | 0% | 12012 |
ease | categorical | Easement; Blank = No easement; E= Land easement; F thru M are duplicates of E; A = Air; B = Non-air rights; N = Transit; P = Piers ; R = Railroad, S = Street; U = U.S. govt. |
GET /api/datasets/muvi-b6kx GET /api/datasets/muvi-b6kx/quality GET /api/datasets/muvi-b6kx/related GET /api/columns?dataset=muvi-b6kx
blocklotboroblocklot| 1 |
| 2024 |
| 1 |
| 4600 |
| 46001 |
| 4 |
| 14106 |
| A |
| 1000010201 | 1 | 1 | 201 | 1 | 2024 | 1 | 4600 | 46001 | 4 | 14106 | A |
| 1000020001 | 1 | 2 | 1 | 1 | 2024 | 1 | 2191 | 21911 | 4 | 13356 | A |
| 1000020002 | 1 | 2 | 2 | 1 | 2024 | 1 | 2351 | 23511 | 5 | 13356 | A |
| 1000020003 | 1 | 2 | 3 | 1 | 2024 | 1 | 2191 | 21911 | 4 | 13356 | A |
| 1000020023 | 1 | 2 | 23 | 1 | 2024 | 1 | 2191 | 21911 | 4 | 13356 | A |
| 1000030001 | 1 | 3 | 1 | 1 | 2024 | 1 | 2231 | 22311 | 5 | 13356 | A |
| 1000030002 | 1 | 3 | 2 | 1 | 2024 | 1 | 2231 | 22311 | 4 | 13356 | A |
| 1000030003 | 1 | 3 | 3 | 1 | 2024 | 1 | 2231 | 22311 | 4 | 13356 | A |
Showing 12 of 63 columns. All of them are listed below.
| 99% |
EFGof 9 |
rectype | integer | Record Type; 1 = ORE (Ordinary Real Estate); 2 = REUC Ident Records | 0% | 1of 1 |
year | categorical | Example 2020 (exemptions being generated to be used for the 2019/2020 tax bill) | 0% | 202320242025of 7 |
reuc | text | IDENT / SUBIDENT for reference | 100% | — |
period | categorical | 0 = Prior to the tentative roll being published (file only contains prior year value); 1 = Values as of the Tentative Roll; 3 = Values as of the Final Roll | 0% | 31of 2 |
exmp_code | text | NYC Exemption Code | 0% | 101510105113 |
exmp_code_suffix | text | NYC EXEMPTION CODE with a two digit sequence # used when one property has more than one exemptions | 0% | 101011015110152 |
exmp_seq | integer | Sequence number is for more than one exemptions | 0% | 345 |
nys_exmp_code | text | New York State Exemption Code | 0% | 418064880648076 |
pstatus | categorical | Current Status; A = Approved - Government; AC = Approved/Court Order; AK = Approved - Government Reinstated; AL = Approved - Government Lessee; AM = Approved Mid year; AO = Approved - Government Owned; AR = Approved/Restored; AS = Approved/Senior Ex; AT = Approval Tax Commission | 10% | ADLPRof 19 |
coop_num | integer | Borough + Coop Number | 0% | 0400539400826 |
condo_number | integer | 4 digit condominium number | 65% | 200023200002302850 |
condo_sfx | categorical | C = Commercial; R = Residential; Blank = The entire condo development, suffix1 sequence number, not used | 65% | R1C1C2of 18 |
pyexmptot | integer | Actual Exemption Amount (Value from the Prior Year's Final Roll) | 0% | 028804800 |
pyexmptrn | integer | Transitional Exemption Amount, Value form the Prior Year's Final Roll) | 0% | 028804800 |
pyexmptxbl | integer | Exemption Amount use for Billing (Value from the Prior Year's Final Roll) | 0% | 028804800 |
tenexmptot | integer | Actual Exemption Amount (Value as of the end of the Tentative Period) | 0% | 028804800 |
tenexmptrn | integer | Transitional Exemption Amount (Value as of the end of the Tentative Period) | 0% | 028804800 |
tenexmptxbl | integer | Exemption Amount used for Billing (Value as of the end of the Tentative Period) | 0% | 028804800 |
cbnexmptot | integer | Actual Exemption Amount (Value as of the end of the Change By Notice Period) | 0% | 028804800 |
cbnexmptrn | integer | Transitional Exemption Amount (Value as of the end of the Change By Notice Period) | 0% | 028804800 |
cbnexmptxbl | integer | Actual Exemption Amount (Value as of the end of the Change By Notice Period) | 0% | 028804800 |
finexmptot | integer | Actual Exemption Amount (Value as of the end of the Final Period) | 0% | 028804800 |
finexmptrn | integer | Transitional Exemption Amount (Value as of the end of the Final Period) | 0% | 028804800 |
finexmptxbl | integer | Exemption Amount used for Billing (Value as of the end of the Final Period) | 0% | 028804800 |
curexmptot | integer | Actual exemption amount (Most current value including Remissions as of the File Creation Date for prior year data) | 0% | 028804800 |
curexmptrn | integer | Transitional Exemption Amount (Most current value including Remissions as of the File Creation Date for prior year data) | 0% | 028804800 |
curexmptxbl | integer | Exemption Amount used for billing (Most current value including Remissions as of the File Creation Date for prior year data) | 0% | 028804800 |
create_date | datetime | Exemption creation date | 0% | 1984-01-01T00:00:00.0002018-01-01T00:00:00.0002020-01-01T00:00:00.000 |
exname | text | Name | 3% | UNAVAILABLE OWNERPARKCHESTER PRESERVATION…PARKS AND RECREATION (GE… |
percent_1 | float | — | 0% | 0.00000010050 |
percent_2 | integer | — | 0% | 0.00000010010 |
enter_date | text | — | 68% | 202011282022112020201206 |
percent_3 | categorical | — | 0% | +000.0000000of 2 |
percent_4 | integer | — | 0% | 0.00000010025 |
owner2 | text | — | 69% | NYC DEPT OF EDUCATIONMEMORIAL SLOAN-KETTERING…MEMORIAL HOSPITAL FOR CA… |
pyincrpct1 | integer | Prior Year Percentage 1 | 0% | 0.000000of 1 |
pyincrpct2 | integer | Prior Year Percentage 2 | 0% | 0.000000of 1 |
pyincrpct3 | integer | Prior Year Percentage 3 | 0% | 0.000000of 1 |
pyincrpct4 | integer | Prior Year Percentage 4 | 0% | 0.000000of 1 |
status | text | Exemption Status Code. Current status of the property in the exemption cycle; A = Approved - Government; AC = Approved/Court Order; AK = Approved/Government Reinstated; AL = Approved - Government Lessee; AM = Approved Mid year; AO = Approved - Government Owned; AR = Approved/Restored; AS = Approved/Senior Ex; AT = Approval Tax Commission | 11% | ADLPR |
compute_flg | categorical | For DOF internal use | 0% | AMof 2 |
pypartialpct | text | Exemption partial percentage factor | 0% | +100100+000 |
no_years | integer | Number of years per given exemption | 0% | 152534 |
baseyr | text | Pre-Exemption Assessment Year Start and End | 0% | +00000+2003 |
basetot | text | Pre-exemption Actual Assessed land plus building amount | 0% | +000000000000+00000005255 |
basetrntot | text | Pre-exemption Transitional Assesses Land plus building value | 0% | +000000000000+00000004385 |
gargcomact | categorical | Non-residential 421A exemption Actual Assessed land plus building value amount | 0% | +0000000000001064of 3 |
gargcompct | text | Non-residential 421A exemption percentage factor | 0% | +000.00000000+000.3900000 |
gargcomtrn | categorical | Non-residential 421A exemption transitional assessed land plus building value amount | 0% | +000000000000of 2 |
benftstart | text | — | 0% | +1984+2018+2020 |
icip_appno | integer | — | 0% | 01094712150 |
_421g_cert | text | — | 100% | +00000of 1 |
eff_date | integer | — | 0% | 198420182020 |
prelimdate | integer | — | 0% | 020032007 |
_421g_base_value_act | categorical | — | 0% | 0-59378-2137968of 6 |
j51_prev_exmpt_act | integer | — | 0% | 01220811126 |
j51_prev_exmpt_trn | integer | — | 0% | 01397813027 |
j51_base_val_act | integer | — | 0% | 024641754 |
j51_vase_val_trn | integer | — | 0% | 010581104 |
j51_govt_financed | categorical | Possible values: Y or blank | 3% | NY+00000000000of 3 |
caseno | text | — | 0% | 270077821990514160100132 |
lline | text | — | 0% | +00011+0002 |
extractdt | categorical | Data creation date: YYYYMMDD | 0% | 202205172023051720240514of 15 |
bldg_class | text | Building class | 0% | R4A1A5 |
fintaxclass | categorical | Current tax class | 0% | 124of 12 |