To generate the report, first Download Data. This dataset is a cleaned 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.

library(tidyverse)
library(data.table)
library(cmfproperty)

df <- fread(“merged_properties.csv”))

df <- df %>% mutate(SALE_PRICE = SalePrice, SALE_YEAR = Year, TAX_YEAR = Year, ASSESSED_VALUE = AssessedValue) %>% mutate(TOTAL_AV = ASSESSED_VALUE / assessment_percentage)

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

cmfproperty::make_report(ratios, jurisdiction_name = “King County”, output_dir = “your output directory”) 

Below is a pre-generated example report:

Report