About this Dataset

Assessor [Archived 05-11-2022] - Residential Property Characteristics

Assessment dataset used by the Cook County Assessor in their Computer Assisted Mass Appraisal (CAMA) system used to assess residential properties in Northern Triennial Townships. This dataset contains property information for every residential PIN in the northern triennial townships where class is within a specified list of classes. For disclaimers, see dataset narrative at https://datacatalog.cookcountyil.gov/stories/s/p2kt-hk36
Organization: Cook County of Illinois
Last updated: 2020-11-10T16:57:21.845192
Tags: archive, cook-county-assessor, property-tax

Tables

Table 1

@usgov.cook_county_of_illinois_cook_county_assessors_resident_2e14975d.table_1

96.63 MB
1,995,108 rows
82 columns

CREATE TABLE table_1 (
  "pin" BIGINT,
  "property_class" BIGINT,
  "tax_year" BIGINT,
  "neighborhood_code" BIGINT,
  "land_square_feet" BIGINT,
  "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" DOUBLE,
  "half_baths" DOUBLE,
  "design_plan" DOUBLE,
  "cathedral_ceiling" DOUBLE,
  "construction_quality" DOUBLE,
  "renovation" DOUBLE,
  "site_desireability" 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,
  "prior_tax_year_market_value_estimate_land" DOUBLE  -- Prior Tax Year Market Value Estimate (Land),
  "prior_tax_year_market_value_estimate_building" DOUBLE  -- Prior Tax Year Market Value Estimate (Building),
  "date_of_most_recent_sale" TIMESTAMP,
  "deed_no" DOUBLE  -- Deed No.,
  "sale_price" DOUBLE,
  "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" DOUBLE,
  "condition_desirability_and_utility" VARCHAR  -- Condition, Desirability And Utility,
  "deed_type" VARCHAR,
  "o_hare_noise" DOUBLE,
  "floodplain" DOUBLE,
  "near_major_road" DOUBLE,
  "total_units" DOUBLE,
  "condo_strata" DOUBLE,
  "age_squared" BIGINT,
  "age_decade" DOUBLE,
  "age_decade_squared" DOUBLE,
  "lot_size_squared" BIGINT,
  "improvement_size_squared" DOUBLE,
  "location_factor" DOUBLE,
  "garage_indicator" DOUBLE,
  "residential_share_of_building" DOUBLE,
  "pure_market_sale" BIGINT,
  "pure_market_filter" BIGINT,
  "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
);