BLS US Employment by Industry!/vizhome/BLSUSEmploymentbyIndustry/Dashboard1

The Index of Employees by Industry shows an Industry’s relative growth in employees since the data origin of January 1st 1990. In this way the growth rates of individual sectors are made more graphically comparable. In other words, an index value of 600, represents that the amount of employees in that industry has grown 600% since January 1st, 1990.

Raw data gathered with a bit of python code to collect various .xlsx files on each industry, then including only the most granular data-sets possible (i.e. removing broader categorizations).

Compiled the various excel files with Power Query and made an index of employees in each industry to better compare growth across different industries.

Would like to learn how to use the BLS’s API properly, but instructions weren’t that user friendly for my use case. Additionally, the API limits a data-set to having at most 20 years of data, and I wanted a bit more history than that.

My python code kind of ‘hacks’ the web interface, in that it uses a POST request that a browser normally sends to request data-sets via BLS webpage. The code sends the same requests but then just via a command-line process and saves the requested files. Since it’s 889 requests it’s not really feasible to download them all manually.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.