Assessor - Parcel Universe
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>Non-taxing district data is attached via spatial join (st_contains) to each parcel's centroid.</li>
<li>Tax district data (school district, park district, municipality, etc.) are attached by a parcel's assigned tax code.</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>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 monthly.</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><li>Due to decrepencies between the systems used by the Assessor and Clerk's offices, <i>tax_district_code</i> is not currently up-to-date in this table.</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>
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on
this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \
-H "Content-Type: application/json" \
-d@-<<EOF
{"sql": "
SELECT *
FROM \"datacatalog-cookcountyil-gov/assessor-parcel-universe-nj4t-kc8j\".\"assessor_parcel_universe\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
