More than $180 billion in property taxes collected from every property in Cook County can now be analyzed with software code created by the Cook County Assessor’s Office.
The Property Tax Simulator, or PTAXSIM, is a software code package implemented in the coding language R and designed to recalculate changes to Cook County property tax bills. It uses real assessment, exemption, TIF and levy data to generate historic, line-by-line tax bills for any Cook County property from tax years 2006 to 2020 (for bills issued from 2007 through 2021). PTAXSIM allows the user to recalculate and analyze single or multiple historic tax bills simultaneously.
According to Cook County Assessor Fritz Kaegi, his office’s data department created the database by extracting already-public tax levy and rate data published by the Cook County Clerk, then combined it with previously unpublished data.
“This is the first time that the data used to create tax bills in Cook County has been put together in one place,” Kaegi said. “Researchers and policymakers can now use the data to analyze the whole system of appeals, exemptions, and tax levies – an unprecedented resource for academics, journalists and policymakers.”
Researchers can analyze 15 years of tax data (tax years 2006-2020) including:
- Over $170 billion in property tax dollars levied to fund over 1,800 taxing districts. Taxing districts determine how many property tax dollars to collect from taxpayers every year.
- Over $13 billion in additional property tax revenue for over 600 TIF districts. TIFs are established by municipalities to fund development.
- Tax rates that range from below 2% to over 35%. Tax rates are calculated by the Cook County Clerk using assessed values, exemptions, the state equalizer and property tax levies.
- Over 1.8 million parcels with data about assessed value and exemptions applied by the Cook County Assessor and assessed value adjustments determined by the Cook County Board of Review.
Given some careful assumptions and data manipulation, PTAXSIM can provide hypothetical, but factually grounded, answers to counterfactual historical scenarios. The software documentation contains example scenarios that show how tax bills might have changed if, for example, a TIF district did not exist, if exemption amounts increased, or what could have happened if appeals did not occur.
PTAXSIM is an R package that can be downloaded here: www.cookcountyassessor.com/property-tax-simulator-tool. The Assessor’s Office Data Department welcomes questions at [email protected].