housing_cost_of_living_county_year
Regional price parities (RPP) by county and year via CBSA crosswalk. BEA RPP measures the cost of goods and services relative to the national average; counties assigned the RPP of their containing CBSA.
overview
3,144 counties x ~16 years = 11,064 rows. CBSA crosswalk used for non-metro counties (RPP not directly published below MSA).
current vintage — 2023 (released December 2024)
history — BEA RPP: 2008-present
source & licensing
fields
| name | type | definition |
|---|---|---|
| _ingested_at | timestamp | Timestamp when this record was written to BigQuery.Pipeline metadata field. |
| _ingestor_version | string | Version of the ingestor script that produced this record.Pipeline metadata field. |
| _reliability_tier | string | Data quality tier (A/B/C) assigned at ingestion.Pipeline metadata field. |
| _source_dataset_id | string | Internal dataset identifier linking to meta.datasets.Pipeline metadata field. |
| country_id | string | ISO alpha-2 country code (always 'US' for domestic tables). |
| county_idkey | string | 5-character FIPS code identifying the county.Joins dim.counties on county_id. |
| rpp_geo_name | string | Name of the geographic area (typically county or county-equivalent) to which the Regional Price Parity estimates apply. |
| rpp_overall | float64 · index (US=100) | Overall Regional Price Parity (RPP) for the geography, published by the BEA, measuring the price level of all consumption goods and services relative to the national average. Higher values indicate a higher local cost of living than the US average. |
| rpp_source | string | Label or identifier indicating the original data source or release from which the RPP estimate was drawn (e.g., BEA release version or vintage year). |
| state_id | string | 2-character FIPS code identifying the state.Joins dim.states on state_id. |
| yearkey | int64 | Reference year of the observation. |
joins
how to use this table
BEA computes RPP as price level relative to US average=100, using ACS rent + CPI item prices. Counties assigned RPP of containing MSA; non-metro counties use state non-metro RPP.
Sub-CBSA price differentials within a metro (not measured); short-run inflation tracking (annual only); luxury or specific-item pricing.
Within-metro price variation is invisible (county = MSA RPP). Non-metro state RPP smooths over rural variation.