About this Dataset

Assessor [Archived 05-11-2022] - Residential Modeling Characteristics (Chicago)

This data set contains characteristic data points used by the Cook County Assessor in the 2021 Chicago reassessment to produce initial estimates of the current market value of most Chicago homes (single-family homes, small multi-family homes, and condo units). You can use the "Filter" option to search for a property's PIN or address, and see what data the Assessor’s Office had about a home’s characteristics at the time of modeling*. To learn more about how the 2021 model used this data, read about our public Residential Automated Valuation Model here. Chicago properties not listed here are reassessed using different modeling procedures.

*Important Note: This dataset is, at the time of publication, an early snapshot of data. Data about a home might change later in the assessment process this year as Assessor’s Office staff and analysts review these properties. After this review, updated characteristics and market values are mailed to homeowners. If the data listed on the assessment notice is incorrect, an appeal can be filed to provide the correct characteristics.
Organization: Cook County of Illinois
Last updated: 2021-08-07T15:12:39.773380
Tags: archive, cook-county-assessor, property-tax

Tables

Table 1

@usgov.cook_county_of_illinois_cook_county_assessors_resident_88d88840.table_1

50.14 MB
678656 rows
80 columns


CREATE TABLE table_1 (
  "property_index_number" VARCHAR,
  "assessment_triad" VARCHAR,
  "property_class" BIGINT,
  "property_address" VARCHAR,
  "property_apartment_num" VARCHAR,
  "property_city" VARCHAR,
  "township_name" VARCHAR,
  "township_code" BIGINT,
  "neighborhood_code" BIGINT,
  "township_neighborhood_only" BIGINT,
  "modeling_group" VARCHAR,
  "proportion_assessed" DOUBLE,
  "key_pin" VARCHAR,
  "multi_code_indicator" BIGINT,
  "multi_code" DOUBLE,
  "number_of_active_288s_hies" DOUBLE,
  "number_of_ended_288s_hies" DOUBLE,
  "sale_date" VARCHAR,
  "sale_price" DOUBLE,
  "sale_document_number" VARCHAR,
  "land_square_feet" DOUBLE,
  "large_home_indicator" VARCHAR,
  "age" BIGINT,
  "apartments" VARCHAR,
  "wall_material" VARCHAR,
  "roof_material" VARCHAR,
  "rooms" DOUBLE,
  "bedrooms" DOUBLE,
  "basement" VARCHAR,
  "basement_finish" VARCHAR,
  "central_heating" VARCHAR,
  "central_air_conditioning" VARCHAR,
  "fireplaces" DOUBLE,
  "attic_type" VARCHAR,
  "full_baths" DOUBLE,
  "half_baths" DOUBLE,
  "design_plan" VARCHAR,
  "cathedral_ceiling" VARCHAR,
  "garage_1_size" VARCHAR,
  "garage_1_material" VARCHAR,
  "garage_1_attached" VARCHAR,
  "garage_1_area" VARCHAR,
  "building_square_feet" DOUBLE,
  "repair_condition" VARCHAR,
  "use" VARCHAR,
  "type_of_residence" VARCHAR,
  "attic_finish" VARCHAR,
  "renovation" VARCHAR,
  "porch" VARCHAR,
  "property_zip_code" VARCHAR,
  "tract_geoid" BIGINT,
  "municipality_fips_code" VARCHAR,
  "municipality_name" VARCHAR,
  "o_hare_noise_indicator" BIGINT,
  "fema_floodplain" BIGINT,
  "flood_risk_factor" BIGINT,
  "flood_risk_direction" BIGINT,
  "road_proximity_100_feet" BIGINT,
  "road_proximity_101_300_feet" BIGINT,
  "elementary_middle_school_district" VARCHAR,
  "high_school_district" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "geoposition" VARCHAR,
  "tax_rate" DOUBLE,
  "tract_median_income" BIGINT,
  "condo_model_building_pin" VARCHAR,
  "condo_model_modeled_unit_strata_of_10" VARCHAR,
  "condo_model_modeled_unit_strata_of_300" VARCHAR,
  "modeled_sale_year" BIGINT,
  "modeled_sale_month_of_year" VARCHAR,
  "modeled_sale_day_of_year" BIGINT,
  "modeled_sale_week_of_year" BIGINT,
  "modeled_sale_quarter_of_year" VARCHAR,
  "modeled_sale_quarter" BIGINT,
  "modeled_sale_month" BIGINT,
  "modeled_sale_week" BIGINT,
  "modeled_sale_day" BIGINT,
  "modeled_sale_during_school_year" BOOLEAN,
  "modeled_sale_during_holidays" BOOLEAN
);