Top Housing Metros County Crosswalk

One row per county included in an AEI top housing metro, giving the metropolitan area name, county name, and USPS state abbreviation. The 584-row reference table covers 89 metro labels and 418 county names across 48 state or district abbreviations. It is a geographic crosswalk for joining or interpreting AEI metro housing tables, not a time series or additive measure table.

american-enterprise-institute-metro-counties·3 columns·9 KB·AEI.org and AEImarkettrends.com Terms of Use·updated 1mo ago
American Enterprise Institute

Source: American Enterprise Institute · connector code

Schema

metroVARCHAR
countyVARCHAR
stateVARCHAR

Get this dataset on your machine

subsets sync --bundle medium clones the mid-size tiers as queryable local tables — use --bundle large for the widest tier

pip install subsetsio
subsets sync --bundle small # or medium, or large
subsets serve # search + SQL at http://localhost:8080

Free and open — the data syncs straight from the public bucket, and search + SQL run entirely on your machine. See docs →

Query it locally

Full docs →
Bash
subsets serve   # local API on http://localhost:8080
curl -s -X POST "http://localhost:8080/query" \
  -H "Content-Type: application/json" \
  -d '{"sql": "SELECT * FROM \"american-enterprise-institute-metro-counties\" LIMIT 5"}'

No account, no API key — the data syncs straight from bundles.subsets.io and every query runs on your machine. See the local API reference.