Median annual wage variance state to state
This repository contains data and methodlogy behind the Trend CT story:
- Adjusting income for inflation and cost of living
- The annual median wage data comes from the Bureau of Labor Statistic's Employment and Wages from Occupational Employment Statistics (OES) survey. The data goes back to 1988 but occupation codes changed around 1999, so started there to keep things as "apples to apples"" as possible.
- The inflation data is also from the Bureau of Labor Statistics' Consumer Price index.
- State-to-state cost of living adjustments was made by determining the relative value of $100 based on Bureau of Economic Analysis' Regional Price Parities for the years available: 2008-2014.
What's in this repo
datafolder - Folder with raw BLS data and formated data used in this analysis
jobs-wagesfolder - Folder of experimental Shiny app
storiesfolder - Folder with programatically generated stories in markdown for every state
compiler.R- Cleans and consolidates all the different BLS Excel sheets.
data_prep- Just preps and cleans the 2015 data
story_generator.R- Progromatically generates stories in markdown for every state and exports it to the stories folder
We believe in open data. Our scripts may be too technical for the average reader, but we make it accessible because we believe it is important to be as transparent as possible about our methodology so our work can be checked or expanded upon. Read more.
Check out the reproducible scripts and data behind many of our other stories in our central repo
This walkthrough explains the methodology behind adjusting income in the Trend CT story Would your job make you better or worse off in another state?