Property Tax Fairness
From the Center for Municipal Finance

To generate the report, first download the data. This dataset is a raw public dataset we can use.

After downloading the dataset, please run the below R code, for example in RStudio. Remember to replace your output directory” with the path where you want to save the generated report.



sales <- fread(“/Maricopa County/PHX_Sales.csv”)
assessments <- fread(“/Maricopa County/PHX_assessments.csv”)

assessments <- assessments %>% filter(proptype==”RESIDENTIAL”)

joined <- assessments %>% left_join(sales, by = c(“parcelid” = “ParcelID”, “year” = “SaleYear”))
df <- joined %>% select(-proptype, -BuySellRelInd)

df <- df %>% mutate(ASSESSED_VALUE = lpv, MARKET_VALUE = totfcv, TAX_YEAR = year, SALE_YEAR = year, SALE_PRICE = SalePrice)

ratios <- cmfproperty::reformat_data(dfsale_col = “SALE_PRICE”assessment_col = “ASSESSED_VALUE”sale_year_col = “SALE_YEAR”)

cmfproperty::make_report(ratiosjurisdiction_name = “Maricopa County”output_dir = your output directory”) 

Below is a pre-generated example report: