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 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 tract -
li_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.