4 ms·
Sure. What you're asking for is ... The graphic itself is powered by CSV's of the relevant data, pub'd out here: Jobs: http://graphics8.nytimes.com/newsgraphic
by jashkenas 12y ago
Sure. What you're asking for is ... The graphic itself is powered by CSV's of the relevant data, pub'd out here:
Jobs: http://graphics8.nytimes.com/newsgraphics/2014/03/05/state-of-the-economy/42f91284773cf307436fcef82a49a9bdf176a391/data/ces.csv http://graphics8.nytimes.com/newsgraphics/2014/03/05/state-o...
Wages: http://graphics8.nytimes.com/newsgraphics/2014/03/05/state-of-the-economy/42f91284773cf307436fcef82a49a9bdf176a391/data/wages.csv http://graphics8.nytimes.com/newsgraphics/2014/03/05/state-o...
(Note that you'll want to adjust those wages for inflation, and those jobs for population growth, depending on what you're doing.)
But our versions aren't really "cleaned up" in any meaningful way. The BLS already seasonally adjusts the jobs numbers for their CES series, which is super handy. Instead, go to the original source here:
http://data.bls.gov/cgi-bin/dsrv?ce http://data.bls.gov/cgi-bin/dsrv?ce
... and walk through the wizard to pick which data points you'd like to include in your query. One big tip, once you're on the results screen, is to click on "More Formatting Options", and then choose the "Multi-series table" format. That'll give you something much easier to pipe into Excel or into a database.
Enjoy!
- devbug 12y agoAwesome! Thanks.