This provides low income (<$40,000 salary) job loss estimates by industry for every 2018 Census tract 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 incomes jobs are lost in tract j
, this means that there are 100 workers who live in tract j
that have lost low income jobs.
- Every row in the CSV is a unique census tract.
Below is a description of each of the columns in the data:
- GEOID
: Census tract GEOID
- state_name
: Full state name
- county_name
: Human readable county name
- state_fips
: 2 digit FIPS code for the state
- county_fips
: The 4 digit FIPS code for the county
- cbsa
: The 5 digit FIPS code for the CBSA
-cbsa_name
: Human readable CBSA name. May be NA if a tract is not contained within a CBSA
-X01
- X20
: Number of estimated low income jobs lost in that particular industry by residents of that particular tract. The translation from X01 to human readable industries can be found in industry_code_translation_list.csv
.
- X000
: The total number of low income jobs lost by residents of that particular tract.
-total_li_workers_employed
: Total number of low income workers who live in that tract
- li_worker_unemp_rate
: The total low income worker unemployment rate, or X000
/total_li_workers_employed
. Note this number may be slightly off due to rounding errors.