Commercial valuation data collected and maintained by the Cook County Assessor's Office, from 2021 to present. The office uses this data primarily for valuation and reporting. This dataset consolidates the individual Excel workbooks available on the Assessor's website into a single shared format. Properties are valued using similar valuation methods within each model group, per township, per year (in the year the township is reassessed). This dataset has been cleaned minimally, only enough to fit the source Excel workbooks together - because models are updated for each township in the year it is reassessed, users should expect inconsistencies within columns across time and townships. 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. This data is property-level. Each 14-digit key PIN represents one commercial property. Commercial properties can and often do encompass multiple PINs. Additional notes: 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. Data will be updated yearly, once the Assessor has finished mailing first pass values. If users need more up-to-date information they can access it through the Assessor's website. The Assessor's Office reassesses roughly one third of the county (a triad) each year. For commercial valuations, this means each year of data only contain the triad that was reassessed that year. Which triads and their constituent townships have been reassessed recently as well the year of their reassessment can be found in the Assessor's assessment calendar. One KeyPIN is one Commercial Entity. Each KeyPIN (entity) can be comprised of one single PIN (parcel), or multiple PINs as designated in the pins column. Additionally, each KeyPIN might have multiple rows if it is associated with different class codes or model groups. This can occur because many of Cook County's parcels have multiple class codes associated with them if they have multiple uses (such as residential and commercial). Users should not expect this data to be unique by any combination of available columns. Commercial properties are calculated by first determining a property’s use (office, retail, apartments, industrial, etc.), then the property is grouped with similar or like-kind property types. Next, income generated by the property such as rent or incidental income streams like parking or advertising signage is examined. Next, market-level vacancy based on location and property type is examined. In addition, new construction that has not yet been leased is also considered. Finally, expenses such as property taxes, insurance, repair and maintenance costs, property management fees, and service expenditures for professional services are examined. Once a snapshot of a property’s income statement is captured based on market data, a standard valuation metric called a “capitalization rate” to convert income to value is applied. This data was used to produce initial valuations mailed to property owners. It does not incorporate any subsequent changes to a property’s class, characteristics, valuation, or assessed value from appeals.Township codes can be found in the legend of this map. For more information on the sourcing of attached data and the preparation of this datase

Retail properties had the highest capitalization rates in the United States in 2023, followed by offices. The cap rate for office real estate was **** percent in the fourth quarter of the year and was forecast to rise further to **** percent in 2024. Cap rates measure the expected rate of return on investment, and show the net operating income of a property as a percentage share of the current asset value. While a higher cap rate indicates a higher rate of return, it also suggests a higher risk. Why have cap rates increased? The increase in cap rates is a consequence of a repricing in the commercial real estate sector. According to the National NCREIF Property Return Index, prices for commercial real estate declined across all property types in 2023. Rental growth was slow during the same period, resulting in a negative annual return. The increase in cap rates reflects the increased risk in the investment environment. Pricing uncertainty in the commercial real estate sector Between 2014 and 2021, commercial property prices in the U.S. enjoyed steady growth. Access to credit with low interest rates facilitated economic growth and real estate investment. As inflation surged in the following two years, lending policy tightened. That had a significant effect on the sector. First, it worsened sentiment among occupiers. Second, it led to a decline in demand for commercial spaces and commercial real estate investment volumes. Uncertainty about the future development of interest rates and occupier demand further contributed to the repricing of real estate assets.

Graph and download economic data for Commercial Real Estate Prices for United States (COMREPUSQ159N) from Q1 2005 to Q1 2025 about real estate, commercial, rate, and USA.

This is a preliminary version of a new open data asset and will be updated later this year once the Assessor's Office has finished reassessing commercial properties, then once annually. Use accordingly.

Commercial valuation data collected and maintained by the Cook County Assessor's Office, from 2021 to present. The office uses this data primarily for valuation and reporting. This dataset consolidates the individual Excel workbooks available on the Assessor's website into a single shared format. Properties are valued using similar valuation methods within each modelgroup, per township, per year (in the year the township is reassessed). This dataset has been cleaned minimally, only enough to fit the source Excel workbooks together - because models are updated for each township in the year it is reassessed, users should expect inconsistencies within columns across time and townships.

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.

This data is property-level. Each 14-digit key PIN represents one commercial property. Commercial properties can and often do encompass multiple PINs. Additional notes: 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.

Data will be updated yearly, once the Assessor has finished mailing first pass values. If users need more up-to-date information they can access it through the Assessor's website.

The Assessor's Office reassesses roughly one third of the county (a triad) each year. For commercial valuations, this means each year of data only contain the triad that was reassessed that year. Which triads and their constituent townships have been reassessed recently as well the year of their reassessment can be found in the Assessor's assessment calendar.

Commercial properties are calculated by first determining a property’s use (office, retail, apartments, industrial, etc.), then the property is grouped with similar or like-kind property types. Next, income generated by the property such as rent or incidental income streams like parking or advertising signage is examined. Next, market-level vacancy based on location and property type is examined. In addition, new construction that has not yet been leased is also considered. Finally, expenses such as property taxes, insurance, repair and maintenance costs, property management fees, and service expenditures for professional services are examined. Once a snapshot of a property’s income statement is captured based on market data, a standard valuation metric called a “capitalization rate” to convert income to value is applied.

This data was used to produce initial valuations mailed to property owners. It does not incorporate any subsequent changes to a property’s class, characteristics, valuation, or assessed value from appeals.Township codes can be found in the legend of this map.

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 2023 Open Data Refresh.

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

See the Splitgraph documentation for more information.