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.
Source: American Enterprise Institute · connector code
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 subsetsiosubsets sync --bundle small # or medium, or largesubsets serve # search + SQL at http://localhost:8080Free 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 →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.