Skip Main Navigation Skip To Navigation Content

Longitudinal Employer-Household Dynamics

Skip top of page navigation

Job-to-Job Flows (J2J) Data (Beta)

Workers often build their careers through job-hopping. Job-to-job moves are a primary means by which workers move from lower-paying to better-paying employers, from dead-end jobs to new career ladders. Similarly, employers often seek experienced workers for jobs - workers who are often currently working at other firms. These flows of workers across employers, industries, and labor markets are subsequently quite large - about 1/2 of hires and separations in 2000 were job-to-job flows. Yet until now, they represented a gap in the set of available statistics on employment dynamics.

Job-to-Job Flows (J2J) is a beta release from the U.S. Census Bureau of new national statistics on job mobility in the United States. The data include new statistics on: (1) the job-to-job transition rate, (2) hires and separations to and from employment, and (3) characteristics of origin and destination jobs for job-to-job transitions. These statistics are available nationally and at the state level, by industry and worker characteristics. More information about the data and how they are generated is available in the documentation links provided on this page. More detailed tabulations are planned in later releases.

These data are beta and will become available via the LED Extraction Tool at a later date.

Description of Available J2J Data

J2J Data Series: These files contain count data about job-to-job flows as well as flows to/from nonemployment, nationally and by state. Data is available for all firms and workers as well as by firm characteristics (industry, age, size) and by worker demographics (sex by age, sex by education, race by ethnicity).

J2JR Data Series: These files contain rate data about job-to-job flows as well as flows to/from nonemployment, nationally and by state. Data is available for all firms and workers as well as by firm characteristics (industry, age, size) and by worker demographics (sex by age, sex by education, race by ethnicity).

Line charts showing national trends of the rate data series are provided below.

 

Seasonally Adjusted

Not Seasonally Adjusted

National rates, all firms, all workers

PDF

PDF

National rates, by industry of firm

PDF

PDF

National rates, by age of firm

PDF

PDF

National rates, by size of firm

PDF

PDF

National rates, by sex and age of worker

PDF

PDF

National rates, by sex and education of worker

PDF

PDF

National rates, by race and ethnicity of worker

PDF

PDF

 

J2JOD Data Series: These files contain origin and destination job characteristics data of job-to-job flows - specifically, job transitions that take place within the same quarter or in adjacent quarters. Data is available by

  • Origin state/destination state (including within-state job-to-job flows)
  • Origin state/destination state by worker demographics (sex by age, sex by education, race by ethnicity)
  • Origin state/destination state by origin industry/destination industry
  • Origin state/destination state by origin firm size/destination firm size
  • Origin state/destination state by origin firm age/destination firm age

Note about the data schema: Full descriptions of all categorical variables, measure layouts, and more can be found in the data schema. For the latest version, choose the Version, State/Territory, Type and Format of the data series desired and push the "View Files" button in the selector tool above. A list of files should subsequently appear with two links centered above it. Click on the left link.

Note about data file names: Data files have the following filename structure:

           [TYPE]_[GEOHI]_[CHAR]_[FAS]_[GEO]_[IND]_[OWN]_[SA].[EXT]

Description of Filename Components

Series type [TYPE]

  • j2j = Count data
  • j2jr = Rate data
  • j2jod = Origin-destination job characteristics data

Geographical unit of analysis [GEOHI]

  • us = Nation
  • st = Any 2-digit state postal code identifier

Demographic characteristics [CHAR]

  • d = No demographic detail
  • rh = Tabulations by race & ethnicity
  • sa = Tabulations by sex & age
  • se = Tabulations by sex & education

Firm Age/Size [FAS]

  • f = No firm size or age detail
  • fa = Tabulations by firm age
  • fs = Tabulations by firm size

Geography [GEO]

  • gn = National
  • gs = States

Industry detail [IND]

  • n = All NAICS sectors
  • ns = Tabulations by NAICS sectors

Ownership [OWN]

  • oslp = State, local, and private ownership categories (BLS codes: 2,3,5; QWI code A00)

Seasonal Adjustment [SA]

  • s = Seasonally adjusted
  • u = Not seasonally adjusted

Available file formats [EXT] :

  • .xlsx = Excel file (not available for larger files)
  • .csv = Comma delimited file

For example, the filename "j2j_us_se_f_gn_n_oslp_s.xlsx" is for an Excel file that contains J2J count data for the US with tabulations by sex & education for all firms and NAICS sectors in the nation, all of which has been seasonally adjusted.

Important information about available quarters: The initial and latest quarters of available data vary by state/territory. To see which quarters are available, choose the Version, State/Territory, Type and Format of the data series desired and push the "View Files" button in the selector tool above. A list of files should subsequently appear with two links centered above it. Click on the right link called "Metadata for [State/Territory]" to go to a new web page, which will have a line of descriptive information about the selected data series. The period of available quarters can be found in the fourth column after the type of data series, the 2-digit state postal code identifier, and the state/territory number. For example, the following line of descriptive information:

          J2J US 00 2000:2-2014:2 V4.1c-draft 2015Q2 j2jpu_us_20150706_1122

specifies that J2J count data is available for the US from the second quarter of 2000 until the second quarter of 2014.

For the J2JOD data series, data for a given state may be available before the state's initial quarter of available data if other states/territories have data from earlier quarters available and also have job-to-job flows with the given state during those quarters. In such cases, earlier data for the given state can be found in the data files of the other states/territories.

To browse the J2J data files in their directory structure or to access them with FTP program (must be able to access HTTP), go to: http://lehd.ces.census.gov/data/j2j/.

Please send questions and comments to CES.J2J.Feedback@census.gov.

[PDF] or PDF denotes a file in Adobe’s Portable Document Format. To view the file, you will need the Adobe® Acrobat® Reader This link to a non-federal Web site does not imply endorsement of any particular product, company, or content. available free from Adobe. This symbol Off site indicates a link to a non-government web site. Our linking to these sites does not constitute an endorsement of any products, services or the information found on them. Once you link to another site you are subject to the policies of the new site.