Assessor - Parcel Universe

datacatalog.cookcountyil.gov | Last Updated 31 Jul 2022

A complete, historic 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:<ul><li>Data is attached via spatial join (st_contains) to each parcel's centroid.</li> <li>Centroids are based on <a href="https://datacatalog.cookcountyil.gov/Property-Taxation/ccgisdata-Parcel-2021/77tz-riq7">Cook County parcel shapefiles</a>.</li> <li>Older properties may be missing coordinates and thus also missing attached spatial data (usually they are missing a parcel boundary in the shapefile).</li> <li>Newer properties may be missing a mailing or property address, as they need to be assigned one by the postal service.</li> <li>Attached spatial data does NOT go all the way back to 1999. It is only available for more recent years, primarily those after 2012.</li> <li>The universe contains data for the current tax year, which may not be complete or final. PINs can still be added and removed to the universe up until the Board of Review closes appeals.</li> <li>Data will be updated monthly.</li> <li>Rowcount and characteristics for a given year are final once the Assessor <a href="https://www.cookcountyassessor.com/assessment-calendar-and-deadlines">has certified the assessment roll</a> for all townships.</li> <li>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.</li> <li>Current property class codes, their levels of assessment, and descriptions can be found <a href="https://prodassets.cookcountyassessor.com/s3fs-public/form_documents/classcode.pdf">on the Assessor's website</a>. Note that class codes details can change across time.</li></ul> For more information on the sourcing of attached data and the preparation of this dataset, see the <a href="https://gitlab.com/ccao-data-science---modeling/data-architecture">Assessor's data architecture repo</a> on GitLab. <a href="https://datacatalog.cookcountyil.gov/stories/s/i22y-9sd2">Read about the Assessor's 2022 Open Data Refresh.</a>

Tags: cook county assessor, property tax

This dataset has the following 187 columns:

Column NameAPI Column NameData TypeDescription
pinpintextParcel Identification Number (PIN)
pin10pin10textParcel Identification Number (10-digit)
tax_yearyearnumberTax year
classclasstextProperty class
triad_nametriad_nametextTriad name. Reassessment of property in Cook County is done within a triennial cycle, meaning it occurs every three years. The Cook County Assessor's Office alternates reassessments between triads: the north and west suburbs, the south and west suburbs and the City of Chicago.
triad_codetriad_codetextTriad code. Reassessment of property in Cook County is done within a triennial cycle, meaning it occurs every three years. The Cook County Assessor's Office alternates reassessments between triads: the north and west suburbs, the south and west suburbs and the City of Chicago.
township_nametownship_nametextTownship name
township_codetownship_codetextTownship code
neighborhood_codenbhd_codetextAssessor neighborhood code, first two digits are township, last three are neighborhood
tax_district_codetax_codetextTax district code, as seen on individual property tax bills
proration_key_pintieback_key_pintextTieback key PIN. Prorated properties (whose value is split across multiple PINs) have a "main" or key PIN
proration_ratetieback_proration_ratenumberTieback proration rate. Prorated properties (whose value is split across multiple PINs) pay taxes on the proportion of value on their PIN. In other words, assessed value is multiplied by proration rate to determine taxable assessed value
longitudelonnumberParcel centroid longitude
latitudelatnumberParcel centroid latitude
centroid_x_crs_3435x_3435numberParcel centroid X coordinate (CRS 3435)
centroid_y_crs_3435y_3435numberParcel centroid Y coordinate (CRS 3435)
property_addressprop_address_fulltextProperty street address
property_cityprop_address_city_nametextProperty city
property_stateprop_address_statetextProperty state
property_zipprop_address_zipcode_1textProperty zip code
mailing_namemail_address_nametextTaxpayer mailing name
mail_addressmail_address_fulltextTaxpayer mailing street address
mailing_citymail_address_city_nametextTaxpayer mailing city
mailing_statemail_address_statetextTaxpayer mailing state
mailing_zipmail_address_zipcode_1textTaxpayer mailing zip code
census_block_group_geoidcensus_block_group_geoidtextCensus block group GEOID
census_block_geoidcensus_block_geoidtextCensus block GEOID
census_congressional_district_geoidcensus_congressional_district_geoidtextCensus congressional district GEOID
census_county_subdivision_geoidcensus_county_subdivision_geoidtextCensus county subdivision GEOID
census_place_geoidcensus_place_geoidtextCensus place GEOID
census_puma_geoidcensus_puma_geoidtextCensus PUMA GEOID
census_school_district_elementary_geoidcensus_school_district_elementary_geoidtextCensus school district (elementary) GEOID
census_school_district_secondary_geoidcensus_school_district_secondary_geoidtextCensus school district (secondary) GEOID
census_school_district_unified_geoidcensus_school_district_unified_geoidtextCensus school district (unified) GEOID
census_state_representative_geoidcensus_state_representative_geoidtextCensus state representative GEOID
census_state_senate_geoidcensus_state_senate_geoidtextCensus state senate GEOID
census_tract_geoidcensus_tract_geoidtextCensus tract GEOID
census_zcta_geoidcensus_zcta_geoidtextCensus ZCTA GEOID
census_data_yearcensus_data_yearnumberCensus data year
census_acs5_congressional_district_geoidcensus_acs5_congressional_district_geoidtextCensus ACS5 congressional district GEOID
census_acs5_county_subdivision_geoidcensus_acs5_county_subdivision_geoidtextCensus ACS5 county subdivision GEOID
census_acs5_place_geoidcensus_acs5_place_geoidtextCensus ACS5 place GEOID
census_acs5_puma_geoidcensus_acs5_puma_geoidtextCensus ACS5 PUMA GEOID
census_acs5_school_district_elementary_geoidcensus_acs5_school_district_elementary_geoidtextCensus ACS5 school district (elementary) GEOID
census_acs5_school_district_secondary_geoidcensus_acs5_school_district_secondary_geoidtextCensus ACS5 school district (secondary) GEOID
census_acs5_school_district_unified_geoidcensus_acs5_school_district_unified_geoidtextCensus ACS5 school district (unified) GEOID
census_acs5_state_representative_geoidcensus_acs5_state_representative_geoidtextCensus ACS5 state representative GEOID
census_acs5_state_senate_geoidcensus_acs5_state_senate_geoidtextCensus ACS5 state senate GEOID
census_acs5_tract_geoidcensus_acs5_tract_geoidtextCensus ACS5 tract GEOID
census_acs5_data_yearcensus_acs5_data_yearnumberCensus ACS5 data year
board_of_review_district_numcook_board_of_review_district_numtextBoard of Review district number
board_of_review_district_data_yearcook_board_of_review_district_data_yearnumberBoard of Review district data year
commissioner_district_numcook_commissioner_district_numtextCommissioner district number
commissioner_district_data_yearcook_commissioner_district_data_yearnumberCommissioner district data year
judicial_district_numcook_judicial_district_numtextJudicial district number
judicial_district_data_yearcook_judicial_district_data_yearnumberJudicial district data year
municipality_numcook_municipality_numtextMunicipality number
municipality_namecook_municipality_nametextMunicipality name
municipality_data_yearcook_municipality_data_yearnumberMunicipality data year
ward_numward_numtextWard number
ward_data_yearward_data_yearnumberWard data year
chicago_community_area_numchicago_community_area_numtextChicago community area number
chicago_community_area_namechicago_community_area_nametextChicago community area name
chicago_community_area_data_yearchicago_community_area_data_yearnumberChicago community area data year
chicago_industrial_corridor_numchicago_industrial_corridor_numtextChicago industrial corridor number
chicago_industrial_corridor_namechicago_industrial_corridor_nametextChicago industrial corridor name
chicago_industrial_corridor_data_yearchicago_industrial_corridor_data_yearnumberChicago industrial corridor data year
chicago_police_district_numchicago_police_district_numtextChicago police district number
chicago_police_district_data_yearchicago_police_district_data_yearnumberChicago police district data year
coordinated_care_area_numecon_coordinated_care_area_numtextCoordinated Care Area number
coordinated_care_area_data_yearecon_coordinated_care_area_data_yearnumberCoordinated Care Area data year
enterprise_zone_numecon_enterprise_zone_numtextEnterprise Zone number
enterprise_zone_data_yearecon_enterprise_zone_data_yearnumberEnterprise Zone data year
industrial_growth_zone_numecon_industrial_growth_zone_numtextIndustrial Growth Zone number
industrial_growth_zone_data_yearecon_industrial_growth_zone_data_yearnumberIndustrial Growth Zone data year
qualified_opportunity_zone_numecon_qualified_opportunity_zone_numtextQualified Opportunity Zone number
qualified_opportunity_zone_data_yearecon_qualified_opportunity_zone_data_yearnumberQualified Opportunity Zone data year
flood_fema_sfhaenv_flood_fema_sfhacheckboxFEMA Special Flood Hazard Area (SFHA) indicator
flood_fema_data_yearenv_flood_fema_data_yearnumberFEMA Special Flood Hazard Area (SFHA) data year
flood_fs_factorenv_flood_fs_factornumberFirst Street Flood Factor
flood_fs_risk_directionenv_flood_fs_risk_directionnumberFirst Street flood risk direction
flood_fs_data_yearenv_flood_fs_data_yearnumberFirst Street data year
ohare_noise_contour_no_buffer_boolenv_ohare_noise_contour_no_buffer_boolcheckboxO'Hare noise contour indicator (no buffer). Indicates whether or not a parcel's centroid is within O'Hare's 65 DNL noise contour
ohare_noise_contour_half_mile_buffer_boolenv_ohare_noise_contour_half_mile_buffer_boolcheckboxO'Hare noise contour indicator (1/2 mile buffer). Indicates whether or not a parcel's centroid is within O'Hare's 65 DNL noise contour, buffered by 1/2 mile
ohare_noise_contour_data_yearenv_ohare_noise_contour_data_yearnumberO'Hare noise contour data year. The "omp" value corresponds to the projected noise contour upon completion of the O'Hare Modernization Project
airport_noise_dnlenv_airport_noise_dnlnumberAirport continuous noise surface estimated DNL
airport_noise_data_yearenv_airport_noise_data_yeartextAirport continuous noise surface estimated data year
school_elementary_district_geoidschool_elementary_district_geoidtextSchool district (elementary) GEOID. Chicago Public Schools are associated with attendance areas where suburban schools are associated with districts.
school_elementary_district_nameschool_elementary_district_nametextSchool district (elementary) name. Chicago Public Schools are associated with attendance areas where suburban schools are associated with districts.
school_secondary_district_geoidschool_secondary_district_geoidtextSchool district (secondary) GEOID. Chicago Public Schools are associated with attendance areas where suburban schools are associated with districts.
school_secondary_district_nameschool_secondary_district_nametextSchool district (secondary) name. Chicago Public Schools are associated with attendance areas where suburban schools are associated with districts.
school_unified_district_geoidschool_unified_district_geoidtextSchool district (unified) GEOID. Chicago Public Schools are associated with attendance areas where suburban schools are associated with districts.
school_unified_district_nameschool_unified_district_nametextSchool district (unified) name. Chicago Public Schools are associated with attendance areas where suburban schools are associated with districts.
school_yearschool_school_yeartextSchool year
school_data_yearschool_data_yearnumberSchool data year
community_college_district_numtax_community_college_districttextCommunity college district number
community_college_district_nametax_community_college_district_nametextCommunity college district name
community_college_district_data_yeartax_community_college_district_data_yearnumberCommunity College district data year
fire_protection_district_numtax_fire_protection_district_numtextFire protection district number
fire_protection_district_nametax_fire_protection_district_nametextFire protection district name
fire_protection_district_data_yeartax_fire_protection_district_data_yearnumberFire protection district data year
library_district_numtax_library_district_numtextLibrary district number
library_district_nametax_library_district_nametextLibrary district name
library_district_data_yeartax_library_district_data_yearnumberLibrary district data year
park_district_numtax_park_district_numtextPark district number
park_district_nametax_park_district_nametextPark district name
park_district_data_yeartax_park_district_data_yearnumberPark district data year
sanitation_district_numtax_sanitation_district_numtextSanitation district number
sanitation_district_nametax_sanitation_district_nametextSanitation district name
sanitation_district_data_yeartax_sanitation_district_data_yearnumberSanitation district data year
special_service_area_numtax_special_service_area_numtextSpecial Service Area number
special_service_area_nametax_special_service_area_nametextSpecial Service Area name
special_service_area_data_yeartax_special_service_area_data_yearnumberSpecial Service Area data year
tif_district_numtax_tif_district_numtextTIF district number
tif_district_nametax_tif_district_nametextTIF district name
tif_district_data_yeartax_tif_district_data_yearnumberTIF district data year
cmap_walkability_grid_idaccess_cmap_walk_idtextCMAP walkability grid ID. From CMAP's ON TO 2050 spatial data files
cmap_walkability_no_transit_scoreaccess_cmap_walk_nta_scorenumberCMAP walkability score (no transit). From CMAP's ON TO 2050 spatial data files
cmap_walkability_total_scoreaccess_cmap_walk_total_scorenumberCMAP walkability total score. From CMAP's ON TO 2050 spatial data files
cmap_walkability_data_yearaccess_cmap_walk_data_yearnumberCMAP walkability data year
subdivision_idmisc_subdivision_idtextSubdivision ID
subdivision_data_yearmisc_subdivision_data_yearnumberSubdivision data year
unincorporated_area_boolmisc_unincorporated_area_boolcheckboxUnincorporated area indicator
unincorporated_area_data_yearmisc_unincorporated_area_data_yearnumberUnincorporated area data year
num_pin_in_half_milenum_pin_in_half_milenumberNumber of PINs in half mile
num_bus_stop_in_half_milenum_bus_stop_in_half_milenumberNumber of bus stops in half mile, including CTA and PACE
num_bus_stop_data_yearnum_bus_stop_data_yearnumberNumber of bus stops data year
num_foreclosure_in_half_mile_past_5_yearsnum_foreclosure_in_half_mile_past_5_yearsnumberNumber of foreclosures in half mile (past 5 years), sourced from Illinois Public Records, reported on a long lag
num_foreclosure_per_1000_pin_past_5_yearsnum_foreclosure_per_1000_pin_past_5_yearsnumberNumber of foreclosures per 1000 PINs (past 5 years), sourced from Illinois Public Records, reported on a long lag
num_foreclosure_data_yearnum_foreclosure_data_yeartextNumber of foreclosures data year
num_school_in_half_milenum_school_in_half_milenumberNumber of schools in half mile, sourced from GreatSchools
num_school_with_rating_in_half_milenum_school_with_rating_in_half_milenumberNumber of schools with rating in half mile, sourced from GreatSchools
avg_school_rating_in_half_mileavg_school_rating_in_half_milenumberAverage school rating in half mile, sourced from GreatSchools
num_school_data_yearnum_school_data_yearnumberNumber of schools data year
num_school_rating_data_yearnum_school_rating_data_yearnumberNumber of schools rating data year
nearest_bike_trail_idnearest_bike_trail_idtextNearest bike trail ID
nearest_bike_trail_namenearest_bike_trail_nametextNearest bike trail name
nearest_bike_trail_dist_ftnearest_bike_trail_dist_ftnumberNearest bike trail distance (feet)
nearest_bike_trail_data_yearnearest_bike_trail_data_yearnumberNearest bike trail data year
nearest_cemetery_gnis_codenearest_cemetery_gnis_codetextNearest cemetery GNIS code
nearest_cemetery_namenearest_cemetery_nametextNearest cemetery name
nearest_cemetery_dist_ftnearest_cemetery_dist_ftnumberNearest cemetery distance (feet)
nearest_cemetery_data_yearnearest_cemetery_data_yearnumberNearest cemetery data year
nearest_cta_route_idnearest_cta_route_idtextNearest CTA route ID
nearest_cta_route_namenearest_cta_route_nametextNearest CTA route name
nearest_cta_route_dist_ftnearest_cta_route_dist_ftnumberNearest CTA route distance (feet)
nearest_cta_route_data_yearnearest_cta_route_data_yearnumberNearest CTA route data year
nearest_cta_stop_idnearest_cta_stop_idtextNearest CTA stop ID
nearest_cta_stop_namenearest_cta_stop_nametextNearest CTA stop name
nearest_cta_stop_dist_ftnearest_cta_stop_dist_ftnumberNearest CTA stop distance (feet)
nearest_cta_stop_data_yearnearest_cta_stop_data_yearnumberNearest CTA stop data year
nearest_hospital_gnis_codenearest_hospital_gnis_codetextNearest hospital GNIS code
nearest_hospital_namenearest_hospital_nametextNearest hospital name
nearest_hospital_dist_ftnearest_hospital_dist_ftnumberNearest hospital distance (feet)
nearest_hospital_data_yearnearest_hospital_data_yearnumberNearest hospital data year
lake_michigan_dist_ftlake_michigan_dist_ftnumberLake Michigan distance (feet)
lake_michigan_data_yearlake_michigan_data_yearnumberLake Michigan data year
nearest_major_road_osm_idnearest_major_road_osm_idtextNearest major road OSM ID
nearest_major_road_namenearest_major_road_nametextNearest major road name
nearest_major_road_dist_ftnearest_major_road_dist_ftnumberNearest major road distance (feet)
nearest_major_road_data_yearnearest_major_road_data_yearnumberNearest major road data year
nearest_metra_route_idnearest_metra_route_idtextNearest Metra route ID
nearest_metra_route_namenearest_metra_route_nametextNearest Metra route name
nearest_metra_route_dist_ftnearest_metra_route_dist_ftnumberNearest Metra route distance (feet)
nearest_metra_route_data_yearnearest_metra_route_datanumberNearest Metra route data year
nearest_metra_stop_idnearest_metra_stop_idtextNearest Metra stop ID
nearest_metra_stop_namenearest_metra_stop_nametextNearest Metra stop name
nearest_metra_stop_dist_ftnearest_metra_stop_dist_ftnumberNearest Metra stop distance (feet)
nearest_metra_stop_data_yearnearest_metra_stop_data_yearnumberNearest Metra stop data year
nearest_park_osm_idnearest_park_osm_idtextNearest park OSM ID
nearest_park_namenearest_park_nametextNearest park name
nearest_park_dist_ftnearest_park_dist_ftnumberNearest park distance (feet)
nearest_park_data_yearnearest_park_data_yearnumberNearest park data year
nearest_railroad_idnearest_railroad_idtextNearest railroad ID
nearest_railroad_namenearest_railroad_nametextNearest railroad name
nearest_railroad_dist_ftnearest_railroad_dist_ftnumberNearest railroad distance (feet)
nearest_railroad_data_yearnearest_railroad_data_yearnumberNearest railroad data year
nearest_water_idnearest_water_idtextNearest water ID
nearest_water_namenearest_water_nametextNearest water name
nearest_water_dist_ftnearest_water_dist_ftnumberNearest water distance (feet)
nearest_water_data_yearnearest_water_data_yearnumberNearest water data year
nearest_neighbor_1_pin10nearest_neighbor_1_pin10textNearest neighbor 1 (PIN10)
nearest_neighbor_1_dist_ftnearest_neighbor_1_dist_ftnumberNearest neighbor 1 distance (feet)
nearest_neighbor_2_pin10nearest_neighbor_2_pin10textNearest neighbor 2 (PIN10)
nearest_neighbor_2_dist_ftnearest_neighbor_2_dist_ftnumberNearest neighbor 2 distance (feet)
nearest_neighbor_3_pin10nearest_neighbor_3_pin10textNearest neighbor 3 (PIN10)
nearest_neighbor_3_dist_ftnearest_neighbor_3_dist_ftnumberNearest neighbor 3 distance (feet)