About this Dataset

DOF Property Abatement Detail

Property tax abatement.

The Department of Finance administers a number of benefits for property owners in the form of exemptions and abatement. Exemptions lower the amount of taxes you owe by reducing your property's assessed value. Abatement reduce your taxes by applying credits to the amount of taxes you owe. This dataset includes only abatement data and exemption data is stored as a separate dataset on this portal. The abatement data is reported at the parcel, condominium, and cooperative level. The maximum EXTRACTDT value displays the current abatement data. All other records contain historical abatement data. Only columns applicable to the abatement type are populated.
Organization: City of New York
Last updated: 2020-11-10T17:04:58.391505
Tags: abatement, dof, property, tax

Tables

Table 1

@usgov.city_of_new_york_dof_property_abatement_detail.table_1

85.52 MB
2382456 rows
101 columns


CREATE TABLE table_1 (
  "parid" BIGINT,
  "condoid" VARCHAR,
  "taxyr" BIGINT,
  "caseno" VARCHAR,
  "tccode" VARCHAR,
  "tcsubcode" VARCHAR,
  "appseq" BIGINT,
  "appstat" VARCHAR,
  "yrbegdt" TIMESTAMP,
  "yrenddt" TIMESTAMP,
  "cybegdt" VARCHAR,
  "cyenddt" VARCHAR,
  "coopid" VARCHAR,
  "partpct" BIGINT,
  "commpct" DOUBLE,
  "applid" VARCHAR,
  "leasebegdt" TIMESTAMP,
  "leaseenddt" TIMESTAMP,
  "sublsbegdt" TIMESTAMP,
  "sublsenddt" TIMESTAMP,
  "leasearea" BIGINT,
  "no_years" BIGINT,
  "pct1_mos" BIGINT,
  "pct2_mos" BIGINT,
  "bldgsqft" BIGINT,
  "tenant" VARCHAR,
  "tenantstat" VARCHAR,
  "tenantrndt" TIMESTAMP,
  "owner_stat" VARCHAR,
  "owner_rndt" TIMESTAMP,
  "unit_elig" VARCHAR,
  "coop_elig" VARCHAR,
  "installdt" VARCHAR,
  "sqftroof" BIGINT,
  "newbldgtxb" BIGINT,
  "adjbldgtxb" BIGINT,
  "mintxyrate" DOUBLE,
  "curtxyrate" DOUBLE,
  "renew_stat" VARCHAR,
  "renew_dt" VARCHAR,
  "icip_appct" BIGINT,
  "pct_crc" DOUBLE,
  "rsnbl_cost" BIGINT,
  "cert1434flg" VARCHAR,
  "installcost" DOUBLE,
  "assess_val" BIGINT,
  "net_taxes" DOUBLE,
  "taxlessabt" DOUBLE,
  "baseyrvalu" BIGINT,
  "parteligav" BIGINT,
  "adjbase_av" BIGINT,
  "baseyrexmp" BIGINT,
  "baseyrtxbl" BIGINT,
  "baseyrrate" DOUBLE,
  "basetxbxrt" DOUBLE,
  "eligiblepct" DOUBLE,
  "calcb4phs" DOUBLE,
  "yearabtpct" DOUBLE,
  "actabtpyr" DOUBLE,
  "appliedabt" DOUBLE,
  "baseyrtax" DOUBLE,
  "sqftbldg" BIGINT,
  "calctxpsf" DOUBLE,
  "calcedrate" DOUBLE,
  "appliedrate" DOUBLE,
  "lsareatax" BIGINT,
  "abt_year1" DOUBLE,
  "abt_pct1" DOUBLE,
  "abt_pct2" DOUBLE,
  "net_av" BIGINT,
  "avg_unitav" DOUBLE,
  "unit_tax" BIGINT,
  "tot_othabt" BIGINT,
  "remain_tax" BIGINT,
  "rate_pct" DOUBLE,
  "rate_psf" DOUBLE,
  "max_abt" DOUBLE,
  "calced_abt" DOUBLE,
  "elig_abt" DOUBLE,
  "bldg_uaf" BIGINT,
  "abtxuaf" DOUBLE,
  "bldgav_org" BIGINT,
  "precnsttax" DOUBLE,
  "maxtaxinc" DOUBLE,
  "abtrate" BIGINT,
  "newbldgtax" DOUBLE,
  "adjtaxchg" DOUBLE,
  "appyr1tax" DOUBLE,
  "yrabtpct" DOUBLE,
  "actabtpcyc" DOUBLE,
  "abtyrcert" BIGINT,
  "orgabtpool" DOUBLE,
  "pryabtpool" DOUBLE,
  "orgpriorpl" DOUBLE,
  "abtpyrlim" DOUBLE,
  "remain_pool" DOUBLE,
  "applic_pct" DOUBLE,
  "mcicost" BIGINT,
  "newmcicst" BIGINT,
  "extractdt" TIMESTAMP
);