Calculates median AV, EAV, and MV for residential properties in each municipality. Finds the breakeven value of residential properties that claimed the GHE in 2021. Home values above breakeven point would experience a lower taxbill if the GHE were eliminated.

Identifies properties with major classes 6, 7, or 8 (types of incentive classes) summed at the assessor neighborhood level and municipality level. Maps the assessed value and number PINs with incentive classes.

Calculates tax bill / AV for all properties for scenarios where the General Homeowner Exemption is worth 0 EAV up to 50,000 EAV. Compares tax burden of homes at the 25th percentile to homes at 75th percentile of assessed value. (does same for homes valued at 10 & 90 percentile within each Municipality)

Examines how tax bills would change for properties with different Assessed Values. Increase or decrease in bill depends on if homeowner currently claims the general homeowner exemption. Properties with AV's equal to the Cook County quartile breaks and Municipality level quartile breaks are used to show property tax bill change and how the composite tax rate would change at the municipality level.

Adds all General Homestead exempt EAV back to tax base, recalculates new tax rates, and creates hypothetical tax bills for all properties in Cook County. Current tax bill data from PTAXSIM. For Major Class 2 properties: if someone currently claims an General Homestead exemption, they would expect their bill to go up. If they do not current claim that exemption, their tax bills would go down from the new, lower tax rates.

Contains various ways to fid "similar" properties in Chicago and Dolton (median AVs, median taxbills, properties with similar AVs, properties with similar taxbills). Uses property class 203 for comparisons.

Code for images and data used for working paper.

Adds FY23 expenditures and revenue to FY22 code and research. Preliminary data received July 24 2023 from IOC; does not include lapse period expenditures.

Research for David Merriman on revenue elasticity for municipalities and other taxing districts.

One small part of the CMAP and UIC research on property taxes.

Replication code for "Work from Home in Illinois: Who Can and Who Does?" by Alea Wilbur-Mujtaba, Francis Choi, Xiaoyan Hu, and David Merriman. Research funded by the Institute of Government and Public Affairs & the UIC Department of Public Policy, Management, and Analytics. Code written and posted by Alea.

Original data from PTAXSIM. Looks at the relationship between EAV and levy requested by a taxing agency. Work in progress.

Uses PTAXSIM. Part of Summer 2023 research assignment

Bridgeview output of code using PTAXSIM

Pulls data from PTAXSIM for the 6 communities used as case studies. Part of CMAP and UIC research appointment for Summer 2023

Detailed documentation of coding steps and thought process for Fiscal Futures Project. To be used by future researchers working on the project.

A comparison of unemployment insurance trust fund balances for 50 states. Net Reserve Balances are calculated using reserve balances as of 1/1/2022 net amount owed to federal government after COVID-19 pandemic and historic levels of unemployment insurance benefits paid to residents.

This is a very rough start to what could be a final project. It is not complete and all expectations for the project have not been met in this document. You need to calculate the statistics that make sense for your topic and variables. You also need to DISCUSS those statistics and what they mean in the context of you topic.

Pivoting data structures with pivot_wider() and pivot_longer(), tables with made with packages kable() and kableExtra(), and rmarkdown formatting tips

Week 13 Lab on Multivariate Regression.