● Cross-Border Labour Tightness

Methodology

Every rule that turns two national surveys into one comparable series.

The five harmonization rules

01

Quarterly aggregation

JOLTS and the CES employment series are monthly. Each quarter is the mean of its three months. JVWS is already quarterly, so no aggregation is needed on the Canadian side.

02

Scope cut

The US series drops government openings (JOLTS series JTS9000JOL) and government employment (CES series USGOVT). The published US total includes them; the harmonized series does not, because the comparison targets the business labour market on both sides.

03

Identical rate formula

Vacancy rate equals openings divided by employment plus openings, times 100. Both agencies publish this formula. We recompute it from the quarterly levels after the scope cut instead of averaging published rates.

04

NAICS crosswalk

JOLTS industries map to JVWS NAICS sectors. Where one JOLTS industry spans several JVWS sectors, the Canadian side is composited by summing vacancies and payroll employees first, then recomputing the rate. Ten pairs survive the crosswalk.

05

Seasonal adjustment kept

Both series are used seasonally adjusted as published. No additional seasonal model is applied.

The reference recipe

The scope recipe follows Bauer, K. (2015), Comparison of U.S. and international labor turnover statistics, Monthly Labor Review, doi:10.21916/mlr.2015.26, which documents the definitional deltas between JOLTS and peer surveys including Canada's JVWS.

Bauer, K. (2015). Comparison of U.S. and international labor turnover statistics. Monthly Labor Review. https://doi.org/10.21916/mlr.2015.26

Honest limits

What was wrong with the raw data

Nothing was broken in either source. The problem was comparability: monthly versus quarterly, all-nonfarm-including-government versus all-industries, industry cuts that do not line up. The data-fixes entry for this project records the before and after of each harmonization step.

Download the harmonized series →