About this Dataset

Assessor [Archived 05-11-2022] - Residential Sales Data

This is the data set of residential sales used by the Cook County Assessor in their Computer Assisted Mass Appraisal system used to assess residential property values. This data set contains property information for every arm's-length residential sale in Cook County where class is within a specified list of classes. For disclaimers, see data set narrative at https://datacatalog.cookcountyil.gov/stories/s/p2kt-hk36

This data set was replaced by the more comprehensive data set Cook County Assessor's Sales.
Organization: Cook County of Illinois
Last updated: 2020-11-10T16:57:12.578829
Tags: archive, cook-county-assessor, property-tax

Tables

Table 1

@usgov.cook_county_of_illinois_cook_county_assessors_resident_99048ee7.table_1

54.43 MB
583,370 rows
83 columns

CREATE TABLE table_1 (
  "pin" BIGINT,
  "property_class" BIGINT,
  "neighborhood_code" BIGINT,
  "land_square_feet" DOUBLE,
  "town_code" BIGINT,
  "type_of_residence" DOUBLE,
  "apartments" DOUBLE,
  "wall_material" DOUBLE,
  "roof_material" DOUBLE,
  "rooms" DOUBLE,
  "bedrooms" DOUBLE,
  "basement" DOUBLE,
  "basement_finish" DOUBLE,
  "central_heating" DOUBLE,
  "other_heating" DOUBLE,
  "central_air" DOUBLE,
  "fireplaces" DOUBLE,
  "attic_type" DOUBLE,
  "attic_finish" BIGINT,
  "half_baths" DOUBLE,
  "design_plan" DOUBLE,
  "cathedral_ceiling" DOUBLE,
  "construction_quality" DOUBLE,
  "renovation" DOUBLE,
  "site_desirability" DOUBLE,
  "garage_1_size" DOUBLE,
  "garage_1_material" DOUBLE,
  "garage_1_attachment" DOUBLE,
  "garage_1_area" DOUBLE,
  "garage_2_size" DOUBLE,
  "garage_2_material" DOUBLE,
  "garage_2_attachment" DOUBLE,
  "garage_2_area" DOUBLE,
  "porch" BIGINT,
  "other_improvements" DOUBLE,
  "building_square_feet" DOUBLE,
  "repair_condition" DOUBLE,
  "multi_code" DOUBLE,
  "number_of_commercial_units" DOUBLE,
  "estimate_land" BIGINT  -- Estimate (Land),
  "estimate_building" BIGINT  -- Estimate (Building),
  "sale_date" TIMESTAMP,
  "deed_no" BIGINT  -- Deed No.,
  "sale_price" BIGINT,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "census_tract" DOUBLE,
  "total_building_square_feet" DOUBLE,
  "multi_property_indicator" BIGINT,
  "property_address" VARCHAR,
  "modeling_group" VARCHAR,
  "full_baths" DOUBLE,
  "age" BIGINT,
  "use" BIGINT,
  "number_of_units" DOUBLE,
  "percent_ownership" DOUBLE,
  "condo_class_factor" DOUBLE,
  "multi_family_indicator" DOUBLE,
  "large_lot" VARCHAR,
  "condition_desirability_and_utility" VARCHAR  -- Condition, Desirability And Utility,
  "o_hare_noise" DOUBLE,
  "floodplain" DOUBLE,
  "road_proximity" DOUBLE,
  "condo_strata" DOUBLE,
  "sale_year" BIGINT,
  "sale_quarter" BIGINT,
  "sale_half_year" BIGINT,
  "sale_quarter_of_year" BIGINT,
  "sale_month_of_year" BIGINT,
  "sale_half_of_year" BIGINT,
  "most_recent_sale" DOUBLE,
  "age_squared" BIGINT,
  "age_decade" DOUBLE,
  "age_decade_squared" DOUBLE,
  "lot_size_squared" DOUBLE,
  "improvement_size_squared" DOUBLE,
  "pure_market_filter" BIGINT,
  "garage_indicator" DOUBLE,
  "neigborhood_code_mapping" BIGINT  -- Neigborhood Code (mapping),
  "square_root_of_lot_size" DOUBLE,
  "square_root_of_age" DOUBLE,
  "square_root_of_improvement_size" DOUBLE,
  "town_and_neighborhood" BIGINT
);