Cost of Living Reality Check
Compare occupational wages and regional prices across U.S. states. Look up typical pay, or check a job offer after cost of living.
Problem & Outcome
People comparing a job offer or a move need typical pay in a state, and what that pay is worth after regional prices. An earlier version used SQL Server, Power BI, and a WordPress embed.
Outcome: a live site at costoflivingrealitycheck.com with two modes. Explore wages shows a map and a state table for an occupation. Evaluate an offer compares the offer with state and national medians after cost of living, and shows a rough take-home. The figures come from BLS and BEA, and the site labels how current they are.
What You Can Do on the Site
| Mode | Inputs | Outputs |
|---|---|---|
| Explore wages | Occupation; state optional | National medians, U.S. map, sortable state table |
| Evaluate an offer | Occupation + offer $ + state | COL-adjusted offer, vs state/national median, rough take-home |
Map color can show state median wage, COL-adjusted median, or BEA regional price parity (price level). Tax figures are simplified federal + employee FICA for illustration — not tax advice.
Architecture
Wage and price data are prepared with Polars and published as JSON. The public site serves those files through a small API and the web pages.
flowchart TB A["BLS OEWS · BEA RPP · MERIC"] --> B["Polars pipeline"] B --> C["Silver / gold Parquet"] C --> D["Published JSON"] D --> E["FastAPI"] E --> F["Web UI + MapLibre"]
Hosting & Operations
costoflivingrealitycheck.com serves the API and the web pages, with Cloudflare in front. The API reads the published JSON. The database is not on the public internet.
Tech Stack
| Layer | Choice | Why |
|---|---|---|
| Sources | BLS OEWS, BEA RPP, MERIC | Official public stats; annual vintage labeled in the product |
| Transform | Polars on the desktop | Builds the JSON the site publishes. |
| API | FastAPI + Pydantic | Clear contracts for search, market, compare, offer check |
| UI | HTML, CSS, JS + MapLibre | Interactive choropleth without a paid map vendor for MVP |
| Earlier path | SQL Server + Power BI + WordPress | First version. The live site replaced it. |
Takeaways
- Look up typical pay by occupation and state, or check one job offer
- A U.S. map for state medians, cost-of-living adjusted pay, or regional price levels
- BLS and BEA sources, with the data vintage shown on the site