This provides low income (<$40,000 salary) job loss estimates by industry for every 2018 Census county in the US (excluding Puerto Rico, Guam, and other territories) due to Covid-19. Couple of notes about the data:
- The attributes in the file starting with
X
correspond to LEHD industry codes, and the translation list can be found in industry_code_translation_list.csv. - These estimates for jobs loss are based on place of residence for workers. So when we report that 100 low income jobs are lost in county
j
, this means that there are 100 workers who live in countyj
that have lost low income jobs. - The columns labelled
max
andtmax
are the max values by tract and industry within counties/cbsas and only used for data visualization. Most users can safely ignore these columns as they were for our internal use in the data viz - Every row in the CSV is a unique census county.
Below is a description of each of the columns in the data:
county_fips
: The 4 digit FIPS code for the countycounty_name
: Human readable county namestate_name
: Full state nameX01
-X20
: Number of estimated low income jobs lost in that particular industry by residents of that particular County. The translation from X01 to human readable industries can be found inindustry_code_translation_list.csv
.X000
: The total number of low income jobs lost by residents of that particular Countymax
andtmax
: bucketed max values by tract and industry, can be safely ignoredtotal_li_workers_employed
: Total number of low income workers who live in that Countyli_worker_unemp_rate
: The total low income worker unemployment rate, orX000
/total_li_workers_employed
. Note this number may be slightly off due to rounding errors.