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 tractj
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 GEOIDstate_name
: Full state namecounty_name
: Human readable county namestate_fips
: 2 digit FIPS code for the statecounty_fips
: The 4 digit FIPS code for the countycbsa
: The 5 digit FIPS code for the CBSAcbsa_name
: Human readable CBSA name. May be NA if a tract is not contained within a CBSAX01
-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 inindustry_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 tractli_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.