Revisions allow you to track differences between multiple versions of your content, and revert back to older versions.

sum_job_loss_county.csv

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:

  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 county j, this means that there are 100 workers who live in countyj that have lost low income jobs.
  3. The columns labelled max and tmax 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
  4. 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 county
  • county_name: Human readable county name
  • state_name: Full state name
  • X01 - 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 in industry_code_translation_list.csv.
  • X000: The total number of low income jobs lost by residents of that particular County
  • max and tmax: bucketed max values by tract and industry, can be safely ignored
  • total_li_workers_employed: Total number of low income workers who live in that County
  • 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.