EARN 101: How to use JobWatch, SWXX, and other EARN tools

EARN 101:

How to use JobWatch, SWXX, and other EARN tools


Janelle Jones & Jessica Schieder

Economic Policy Institute/ Economic Analysis and Research Network
Thursday, October 26, 2017


  • How does State Jobs Day look at EPI?
  • Accessing data by state within the workbook
  • Best practices


  • Accessing the workbooks and log-in process
  • EARN member pages
  • Sample SWXX reports

Additional EARN resources

  • Periodic calls and webinars with EPI’s experts
  • SWXX microdata
  • EARN technical support

State Jobs Day at EPI

  • State unemployment and jobs data is released
  • State and local government jobs data is released
  • State population numbers released
  • Updating rankings, RecessionWatch, and maps
  • JobsWatch email sent out to list

Accessing data by state within the workbook

  • Tabs are organized as follows:
    • Headline
      • Jobs deficit
      • State and Local jobs deficit
      • Rankings
      • Recent Trends
      • Unemployment Rate
      • Job Numbers
      • Labor force
      • Industry Trends
    • LF
      • Unemployment rate, and labor force level
    • Jobs
      • Total nonfarm
      • Construction; manufacturing; trade, transportation, and utilities; financial; professional business services; education and health; leisure and hospitality; government (total, state, local, and combined state and local)
    • Monthly Population
    • Reference Sheet

Best practices: State Jobs Day

Application Exercise #1

  • In the previously displayed COWS Wisconsin Jobs at a Glance data update, it mentions there were 2,947,100 jobs in Wisconsin in March of 2017. Can you locate this number for Wisconsin in your copy of the updated workbook?
  • Wisconsin gained 8,600 jobs over the “last month” according to preliminary data, or between August 2017 and September 2017. Find that number in your copy of the workbook.
  • Can you find for your state:
    • Total number of jobs created over the past three months?
    • Unemployment rate for your state in December 2007 and for September 2017?
      • Bonus Question: Why do we frequently use December 2007 as a comparison point?
    • How does your state rank based on it’s unemployment rate?
  • #StateJobsDay

State of Working XX (SWXX): Accessing the data

Old website…

to be deleted

New website…

Data Workbooks:

  • Jobs
    • Total nonfarm employment
    • Employment by industry
  • Labor Force
    • Unemployment
    • Labor force participation
    • Part-time employment for economic reasons
    • Employment-to-population ratio
  • Wages
    • Wages by decile
    • Wages by gender
    • Wages by race and ethnicity
  • Immigration
    • Foreign-born share of work force
    • Count of prime-age working people by immigration status
  • Miscellaneous
    • Median family income
    • Median household income
    • Poverty rates
    • Health insurance coverage

Best practices: SWXX

Application Exercise #2

  • Can you find for your state:
    • Median wages for women, 1979–2016, in your state?
    • Wage gap between median white and black workers in 2016 in your state?

Additional EARN resources

Thank you!

Economic Policy Institute: epi.org