Primary tabs

job_loss_by_tract.csv

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:

  1. 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.
  2. 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 tract j, this means that there are 100 workers who live in tract j that have lost low income jobs.
  3. 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
  • low_income_worker_job_loss_rate: The percentage of all low income jobs that are lost, or X000 / total_li_workers_employed. The numerator is our estimated jobs lost and the denominator is the total number of low income (<$40k salary) jobs as estimated by the Census LODES data. Note this number may be slightly off due to rounding