cbsas
Canonical Core-Based Statistical Area (CBSA) dimension. Covers Metropolitan and Micropolitan Statistical Areas per OMB 2023 delineation. Primary key is cbsa_code (5-character, zero-padded). Use for metro-level joins.
tier acensus
overview
overview
929 CBSAs (metropolitan and micropolitan statistical areas) per OMB 2023 delineations.
current vintage — OMB 2023 delineations
history — Prior delineations (2013, 2018) differ; this table reflects 2023 only
provenance
source & licensing
authority
U.S. Office of Management and Budget
dataset
OMB Bulletin 23-01 — Revised Delineations of Metropolitan Statistical Areas
license
Public domain (U.S. Federal Government work)
citation
U.S. Office of Management and Budget, Bulletin 23-01, July 2023.
schema
fields
| name | type | definition |
|---|---|---|
| cbsa_codekey | string | 5-character Core-Based Statistical Area (CBSA) code, zero-padded, assigned by the U.S. Office of Management and Budget. Serves as the primary key for this dimension table.Joins dim.cbsas on cbsa_code. |
| cbsa_name | string | Official name of the Core-Based Statistical Area as designated by the U.S. Office of Management and Budget (e.g., "Los Angeles-Long Beach-Anaheim, CA"). |
| country_id | string | ISO alpha-2 country code (always 'US' for domestic tables). |
relationships
joins
primary key
cbsa_code
common joins
Any fact table with cbsa_code
usage
how to use this table
do not use for
County-level joins; CBSA boundaries do not align 1-to-1 with counties in all cases
← previous—next →dimension.counties
last updated · May 5, 2026