About this Dataset

Assessor - Parcel Universe (Current Year Only)

A current-year-only universe of Cook County parcels with attached geographic, governmental, and spatial data. 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. Additional notes:

Non-taxing district data is attached via spatial join (st_contains) to each parcel's centroid.
Tax district data (school district, park district, municipality, etc.) are attached by a parcel's assigned tax code.
Centroids are based on Cook County parcel shapefiles.
Older properties may be missing coordinates and thus also missing attached spatial data (usually they are missing a parcel boundary in the shapefile).
Newer properties may be missing a mailing or property address, as they need to be assigned one by the postal service.
This dataset contains data for the current tax year, which may not yet be complete or final. Assessed values for any given year are subject to change until review and certification of values by the Cook County Board of Review, though there are a few rare circumstances where values may change for the current or past years after that.
Rowcount for a given year is final once the Assessor has certified the assessment roll all townships.
Data will be updated monthly.
Depending on the time of year, some third-party and internal data will be missing for the most recent year. Assessments mailed this year represent values from last year, so this isn't an issue. By the time the Data Department models values for this year, those data will have populated.
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.
Due to discrepancies between the systems used by the Assessor and Clerk's offices, tax_district_code is not currently up-to-date in this table.

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: 2025-03-22T17:12:19.746080
Tags: cook-county-assessor, property-tax

Tables

Table 1

@usgov.cook_county_of_illinois_assessor_parcel_universe_curre_a75746f6.table_1

207.54 MB
1,863,600 rows
120 columns

CREATE TABLE table_1 (
  "pin" BIGINT,
  "pin10" BIGINT,
  "tax_year" BIGINT,
  "class" VARCHAR,
  "triad_name" VARCHAR,
  "triad_code" BIGINT,
  "township_name" VARCHAR,
  "township_code" BIGINT,
  "neighborhood_code" BIGINT,
  "tax_district_code" BIGINT,
  "zip_code" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "centroid_x_crs_3435" DOUBLE,
  "centroid_y_crs_3435" DOUBLE,
  "census_block_group_geoid" DOUBLE,
  "census_block_geoid" DOUBLE,
  "census_congressional_district_geoid" DOUBLE,
  "census_congressional_district_num" DOUBLE,
  "census_county_subdivision_geoid" DOUBLE,
  "census_place_geoid" DOUBLE,
  "census_puma_geoid" DOUBLE,
  "census_school_district_elementary_geoid" DOUBLE,
  "census_school_district_secondary_geoid" DOUBLE,
  "census_school_district_unified_geoid" DOUBLE,
  "census_state_representative_geoid" DOUBLE,
  "census_state_representative_num" DOUBLE,
  "census_state_senate_geoid" DOUBLE,
  "census_state_senate_num" DOUBLE,
  "census_tract_geoid" DOUBLE,
  "census_zcta_geoid" DOUBLE,
  "census_data_year" DOUBLE,
  "census_acs5_congressional_district_geoid" DOUBLE,
  "census_acs5_congressional_district_num" DOUBLE,
  "census_acs5_county_subdivision_geoid" DOUBLE,
  "census_acs5_place_geoid" DOUBLE,
  "census_acs5_puma_geoid" DOUBLE,
  "census_acs5_school_district_elementary_geoid" DOUBLE,
  "census_acs5_school_district_secondary_geoid" DOUBLE,
  "census_acs5_school_district_unified_geoid" DOUBLE,
  "census_acs5_state_representative_geoid" DOUBLE,
  "census_acs5_state_representative_num" DOUBLE,
  "census_acs5_state_senate_geoid" DOUBLE,
  "census_acs5_state_senate_num" DOUBLE,
  "census_acs5_tract_geoid" DOUBLE,
  "census_acs5_data_year" DOUBLE,
  "board_of_review_district_num" DOUBLE,
  "board_of_review_district_data_year" DOUBLE,
  "commissioner_district_num" DOUBLE,
  "commissioner_district_data_year" DOUBLE,
  "judicial_district_num" DOUBLE,
  "judicial_district_data_year" DOUBLE,
  "ward_num" DOUBLE,
  "ward_chicago_data_year" DOUBLE,
  "ward_evanston_data_year" DOUBLE,
  "chicago_community_area_num" DOUBLE,
  "chicago_community_area_name" VARCHAR,
  "chicago_community_area_data_year" DOUBLE,
  "chicago_industrial_corridor_num" DOUBLE,
  "chicago_industrial_corridor_name" VARCHAR,
  "chicago_industrial_corridor_data_year" DOUBLE,
  "chicago_police_district_num" DOUBLE,
  "chicago_police_district_data_year" DOUBLE,
  "coordinated_care_area_num" DOUBLE,
  "coordinated_care_area_data_year" DOUBLE,
  "enterprise_zone_num" DOUBLE,
  "enterprise_zone_data_year" DOUBLE,
  "industrial_growth_zone_num" DOUBLE,
  "industrial_growth_zone_data_year" DOUBLE,
  "qualified_opportunity_zone_num" DOUBLE,
  "qualified_opportunity_zone_data_year" DOUBLE,
  "central_business_district_num" DOUBLE,
  "central_business_district_data_year" DOUBLE,
  "flood_fema_sfha" VARCHAR,
  "flood_fema_data_year" DOUBLE,
  "flood_fs_factor" DOUBLE,
  "flood_fs_risk_direction" DOUBLE,
  "flood_fs_data_year" DOUBLE,
  "ohare_noise_contour_no_buffer_bool" VARCHAR,
  "ohare_noise_contour_half_mile_buffer_bool" VARCHAR,
  "ohare_noise_contour_data_year" DOUBLE,
  "airport_noise_dnl" DOUBLE,
  "airport_noise_data_year" VARCHAR,
  "school_elementary_district_geoid" DOUBLE,
  "school_elementary_district_name" VARCHAR,
  "school_secondary_district_geoid" DOUBLE,
  "school_secondary_district_name" VARCHAR,
  "school_unified_district_geoid" DOUBLE,
  "school_unified_district_name" VARCHAR,
  "school_year" VARCHAR,
  "school_data_year" DOUBLE,
  "tax_municipality_num" DOUBLE,
  "tax_municipality_name" VARCHAR,
  "tax_school_elementary_district_num" DOUBLE,
  "tax_school_elementary_district_name" VARCHAR,
  "tax_school_secondary_district_num" DOUBLE,
  "tax_school_secondary_district_name" VARCHAR,
  "tax_school_unified_district_num" DOUBLE,
  "tax_school_unified_district_name" VARCHAR,
  "tax_community_college_district_num" DOUBLE
);