Baselight

US Unemployment Rate By County, 1990-2016

Thanks to the US Department of Labor's Bureau of Labor Statistics

@kaggle.jayrav13_unemployment_by_county_us

About this Dataset

US Unemployment Rate By County, 1990-2016

Context

This is a dataset that I built by scraping the United States Department of Labor's Bureau of Labor Statistics. I was looking for county-level unemployment data and realized that there was a data source for this, but the data set itself hadn't existed yet, so I decided to write a scraper and build it out myself.

Content

This data represents the Local Area Unemployment Statistics from 1990-2016, broken down by state and month. The data itself is pulled from this mapping site:

https://data.bls.gov/map/MapToolServlet?survey=la&map=county&seasonal=u

Further, the ever-evolving and ever-improving codebase that pulled this data is available here:

https://github.com/jayrav13/bls_local_area_unemployment

Acknowledgements

Of course, a huge shoutout to bls.gov and their open and transparent data. I've certainly been inspired to dive into US-related data recently and having this data open further enables my curiosities.

Inspiration

I was excited about building this data set out because I was pretty sure something similar didn't exist - curious to see what folks can do with it once they run with it! A curious question I had was surrounding Unemployment vs 2016 Presidential Election outcome down to the county level. A comparison can probably lead to interesting questions and discoveries such as trends in local elections that led to their most recent election outcome, etc.

Next Steps

Version 1 of this is as a massive JSON blob, normalized by year / month / state. I intend to transform this into a CSV in the future as well.

Share link

Anyone who has the link will be able to view this.