About this Dataset

Assessor - Parcel Sales

Update 10/31/2023: Sales are no longer filtered out of this data set based on deed type, sale price, or recency of sale for a given PIN with the same price. If users wish to recreate the former filtering schema they should set sale_filter_same_sale_within_365 , sale_filter_less_than_10k , and sale_filter_deed_type to False. Parcel sales for real property in Cook County, from 1999 to present. The Assessor's Office uses this data in its modeling to estimate the fair market value of unsold properties. When working with Parcel Index Numbers (PINs) make sure to zero-pad them to 14 digits. Some datasets may lose leading zeros for PINs when downloaded. Sale document numbers correspond to those of the Cook County Clerk, and can be used on the Clerk's website to find more information about each sale. NOTE: These sales are filtered, but likely include non-arms-length transactions - sales less than $10,000 along with quit claims, executor deeds, beneficial interests are excluded. While the Data Department will upload what it has access to monthly, sales are reported on a lag, with many records not populating until months after their official recording date. Current property class codes, their levels of assessment, and descriptions can be found on the Assessor's website. Note that class codes details can change across time. For more information on the sourcing of attached data and the preparation of this dataset, see the Assessor's Standard Operating Procedures for Open Data on GitHub. Read about the Assessor's 2025 Open Data Refresh.
Organization: Cook County of Illinois
Last updated: 2022-05-26T02:14:34.676244
Tags: cook-county-assessor, property-tax

Tables

Table 1

@usgov.cook_county_of_illinois_assessor_parcel_sales.table_1

156.31 MB
2,571,929 rows
19 columns

CREATE TABLE table_1 (
  "pin" BIGINT,
  "year" BIGINT,
  "township_code" BIGINT,
  "neighborhood_code" BIGINT,
  "class" VARCHAR,
  "sale_date" VARCHAR,
  "is_mydec_date" BOOLEAN,
  "sale_price" BIGINT,
  "sale_document_num" VARCHAR,
  "sale_deed_type" VARCHAR,
  "mydec_deed_type" VARCHAR,
  "sale_seller_name" VARCHAR,
  "is_multisale" BOOLEAN,
  "num_parcels_sale" BIGINT,
  "sale_buyer_name" VARCHAR,
  "sale_type" VARCHAR,
  "sale_filter_same_sale_within_365" BOOLEAN,
  "sale_filter_less_than_10k" BOOLEAN,
  "sale_filter_deed_type" BOOLEAN
);