Cook County 10-digit parcels with attached distances to various spatial features. When working with 10-digit Parcel Index Numbers (PINs) make sure to zero-pad them to 10 digits. Some datasets may lose leading zeros for PINs when downloaded. 10-digit PINs do not identify individual condominium units. Additional notes:<ul><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>Attached spatial data does NOT all go back to 2000. It is only available for more recent years, primarily those after 2012.</li> <li>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 <a href="https://www.cookcountyassessor.com/assessment-calendar-and-deadlines">review and certification of values by the Cook County Board of Review</a>, though there are a few rare circumstances where values may change for the current or past years after that.</li> <li>Rowcount for a given year is final once the Assessor <a href="https://www.cookcountyassessor.com/assessment-calendar-and-deadlines">has certified the assessment roll</a> all townships.</li> <li>Data will be updated annually as new parcel shapefiles are made available.</li></ul>For more information on the sourcing of attached data and the preparation of this dataset, see the <a href="https://github.com/ccao-data/wiki/blob/master/SOPs/Open-Data.md">Assessor's Standard Operating Procedures for Open Data</a> on GitHub. <a href="https://datacatalog.cookcountyil.gov/stories/s/9bqn-cfsv">Read about the Assessor's 2023 Open Data Refresh.</a>
This dataset has the following 70 columns:
| Column Name | API Column Name | Data Type | Description |
|---|---|---|---|
| pin10 | pin10 | text | Parcel Identification Number (10-digit) |
| year | year | number | Tax year |
| num_pin_in_half_mile | num_pin_in_half_mile | number | Number of PINs in half mile |
| num_bus_stop_in_half_mile | num_bus_stop_in_half_mile | number | Number of bus stops in half mile, including CTA and PACE |
| num_bus_stop_data_year | num_bus_stop_data_year | number | Number of bus stops data year |
| num_foreclosure_in_half_mile_past_5_years | num_foreclosure_in_half_mile | number | Number 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_years | num_foreclosure_per_1000 | number | Number of foreclosures per 1000 PINs (past 5 years), sourced from Illinois Public Records, reported on a long lag |
| num_foreclosure_data_year | num_foreclosure_data_year | text | Number of foreclosures data year |
| num_school_in_half_mile | num_school_in_half_mile | number | Number of schools in half mile, sourced from GreatSchools |
| num_school_data_year | num_school_data_year | number | Number of schools data year |
| airport_dnl_total | airport_dnl_total | number | Estimated DNL for a PIN, assuming a baseline DNL of 50 ("quiet suburban") and adding predicted noise from O'Hare and Midway airports to that baseline. |
| nearest_bike_trail_id | nearest_bike_trail_id | text | Nearest bike trail ID |
| nearest_bike_trail_name | nearest_bike_trail_name | text | Nearest bike trail name |
| nearest_bike_trail_dist_ft | nearest_bike_trail_dist_ft | number | Nearest bike trail distance (feet) |
| nearest_bike_trail_data_year | nearest_bike_trail_data_year | number | Nearest bike trail data year |
| nearest_cemetery_gnis_code | nearest_cemetery_gnis_code | text | Nearest cemetery GNIS code |
| nearest_cemetery_name | nearest_cemetery_name | text | Nearest cemetery name |
| nearest_cemetery_dist_ft | nearest_cemetery_dist_ft | number | Nearest cemetery distance (feet) |
| nearest_cemetery_data_year | nearest_cemetery_data_year | number | Nearest cemetery data year |
| nearest_cta_route_id | nearest_cta_route_id | text | Nearest CTA route ID |
| nearest_cta_route_name | nearest_cta_route_name | text | Nearest CTA route name |
| nearest_cta_route_dist_ft | nearest_cta_route_dist_ft | number | Nearest CTA route distance (feet) |
| nearest_cta_route_data_year | nearest_cta_route_data_year | number | Nearest CTA route data year |
| nearest_cta_stop_id | nearest_cta_stop_id | text | Nearest CTA stop ID |
| nearest_cta_stop_name | nearest_cta_stop_name | text | Nearest CTA stop name |
| nearest_cta_stop_dist_ft | nearest_cta_stop_dist_ft | number | Nearest CTA stop distance (feet) |
| nearest_cta_stop_data_year | nearest_cta_stop_data_year | number | Nearest CTA stop data year |
| nearest_golf_course_id | nearest_golf_course_id | text | Nearest golf course ID |
| nearest_golf_course_dist_ft | nearest_golf_course_dist | number | Nearest golf course distance (feet) |
| nearest_golf_course_data_year | nearest_golf_course_data | number | Nearest golf course data year |
| nearest_hospital_gnis_code | nearest_hospital_gnis_code | text | Nearest hospital GNIS code |
| nearest_hospital_name | nearest_hospital_name | text | Nearest hospital name |
| nearest_hospital_dist_ft | nearest_hospital_dist_ft | number | Nearest hospital distance (feet) |
| nearest_hospital_data_year | nearest_hospital_data_year | number | Nearest hospital data year |
| lake_michigan_dist_ft | lake_michigan_dist_ft | number | Lake Michigan distance (feet) |
| lake_michigan_data_year | lake_michigan_data_year | number | Lake Michigan data year |
| nearest_major_road_osm_id | nearest_major_road_osm_id | text | Nearest major road OSM ID |
| nearest_major_road_name | nearest_major_road_name | text | Nearest major road name |
| nearest_major_road_dist_ft | nearest_major_road_dist_ft | number | Nearest major road distance (feet) |
| nearest_major_road_data_year | nearest_major_road_data_year | number | Nearest major road data year |
| nearest_metra_route_id | nearest_metra_route_id | text | Nearest Metra route ID |
| nearest_metra_route_name | nearest_metra_route_name | text | Nearest Metra route name |
| nearest_metra_route_dist_ft | nearest_metra_route_dist | number | Nearest Metra route distance (feet) |
| nearest_metra_route_data_year | nearest_metra_route_data | number | Nearest Metra route data year |
| nearest_metra_stop_id | nearest_metra_stop_id | text | Nearest Metra stop ID |
| nearest_metra_stop_name | nearest_metra_stop_name | text | Nearest Metra stop name |
| nearest_metra_stop_dist_ft | nearest_metra_stop_dist_ft | number | Nearest Metra stop distance (feet) |
| nearest_metra_stop_data_year | nearest_metra_stop_data_year | number | Nearest Metra stop data year |
| nearest_park_osm_id | nearest_park_osm_id | text | Nearest park OSM ID |
| nearest_park_name | nearest_park_name | text | Nearest park name |
| nearest_park_dist_ft | nearest_park_dist_ft | number | Nearest park distance (feet) |
| nearest_park_data_year | nearest_park_data_year | number | Nearest park data year |
| nearest_railroad_id | nearest_railroad_id | number | Nearest railroad ID |
| nearest_railroad_name | nearest_railroad_name | text | Nearest railroad name |
| nearest_railroad_dist_ft | nearest_railroad_dist_ft | number | Nearest railroad distance (feet) |
| nearest_railroad_data_year | nearest_railroad_data_year | number | Nearest railroad data year |
| nearest_secondary_road_osm_id | nearest_secondary_road_osm_id | text | Nearest secondary road OSM ID |
| nearest_secondary_road_name | nearest_secondary_road_name | text | Nearest secondary road name |
| nearest_secondary_road_dist_ft | nearest_secondary_road_dist_ft | number | Nearest secondary road distance (feet) |
| nearest_secondary_road_data_year | nearest_secondary_road_data_year | number | Nearest secondary road data year |
| nearest_water_id | nearest_water_id | text | Nearest water ID |
| nearest_water_name | nearest_water_name | text | Nearest water name |
| nearest_water_dist_ft | nearest_water_dist_ft | number | Nearest water distance (feet) |
| nearest_water_data_year | nearest_water_data_year | number | Nearest water data year |
| nearest_neighbor_1_pin10 | nearest_neighbor_1_pin10 | text | Nearest neighbor 1 (PIN10) |
| nearest_neighbor_1_dist_ft | nearest_neighbor_1_dist_ft | number | Nearest neighbor 1 distance (feet) |
| nearest_neighbor_2_pin10 | nearest_neighbor_2_pin10 | text | Nearest neighbor 2 (PIN10) |
| nearest_neighbor_2_dist_ft | nearest_neighbor_2_dist_ft | number | Nearest neighbor 2 distance (feet) |
| nearest_neighbor_3_pin10 | nearest_neighbor_3_pin10 | text | Nearest neighbor 3 (PIN10) |
| nearest_neighbor_3_dist_ft | nearest_neighbor_3_dist_ft | number | Nearest neighbor 3 distance (feet) |