CompositeHWI.xlsx

	A	B	C
1	The data on this page were constructed as part of the paper "Building a composite Help-Wanted Index" (Barnichon, 2010). Anyone is free to download the data and use it in his/her own research, as long as he/she cites the aforementioned paper.
2	Update (02/2017):
3	Because of divergence in the online HWI series and the JOLTS (see Cajner and Radner 2016, "A Cautionary Note on the Help Wanted Online Data"), I now rely solely on the JOLTS V (number of non-farm ads) past 2001Q1.
4	The composite HWI index over 1951Q1-200Q4 was converted in units of job openings rate, ie #V/(size of the Labor Force).
5
6	See the paper for details and construction methods for the composite HWI over 1951-2000.
7
8	year	V_hwi	V/LF
9	1951.00	2313.197608	3.73
10	1951.08	2295.689006	3.72
11	1951.17	2554.677439	4.09
12	1951.25	2502.487739	4.05
13	1951.33	2534.983959	4.09
14	1951.42	2392.152707	3.88
15	1951.50	2388.251431	3.85
16	1951.58	2404.265856	3.88
17	1951.67	2478.510656	4.01
18	1951.75	2472.520638	3.97
19	1951.83	2430.5735	3.92
20	1951.92	2401.748939	3.85
21	1952.00	2550.836801	4.09
22	1952.08	2584.925183	4.14
23	1952.17	2476.143675	4.01
24	1952.25	2453.282325	3.97
25	1952.33	2409.351825	3.88
26	1952.42	2261.84041	3.64
27	1952.50	2153.606877	3.48
28	1952.58	2310.807517	3.73
29	1952.67	2598.045727	4.16
30	1952.75	2600.743454	4.20
31	1952.83	2726.54475	4.36
32	1952.92	2535.404554	4.05
33	1953.00	2650.622745	4.18
34	1953.08	2759.697654	4.34
35	1953.17	2824.493385	4.44
36	1953.25	2615.901714	4.14
37	1953.33	2581.465948	4.12
38	1953.42	2413.393424	3.83
39	1953.50	2226.639068	3.53
40	1953.58	2171.676027	3.46
41	1953.67	2122.21197	3.38
42	1953.75	1917.74047	3.05
43	1953.83	1734.036587	2.75
44	1953.92	1462.779153	2.33
45	1954.00	1493.239137	2.37
46	1954.08	1431.554149	2.24
47	1954.17	1379.88229	2.16
48	1954.25	1335.652473	2.09
49	1954.33	1306.697575	2.05
50	1954.42	1299.884484	2.05
51	1954.50	1275.636926	2.02
52	1954.58	1260.242393	1.98
53	1954.67	1234.560559	1.92
54	1954.75	1264.772437	1.98
55	1954.83	1367.359268	2.14
56	1954.92	1334.363141	2.11
57	1955.00	1524.199028	2.38
58	1955.08	1519.095311	2.38
59	1955.17	1688.875729	2.64
60	1955.25	1742.715273	2.70
61	1955.33	1856.801461	2.88
62	1955.42	1835.871892	2.85
63	1955.50	1999.27405	3.07
64	1955.58	2085.401272	3.18
65	1955.67	2062.629589	3.14
66	1955.75	2178.214575	3.31
67	1955.83	2221.988854	3.36
68	1955.92	2100.591331	3.16
69	1956.00	2345.356428	3.53
70	1956.08	2334.939527	3.53
71	1956.17	2165.461013	3.27
72	1956.25	2180.624079	3.29
73	1956.33	2220.366742	3.33
74	1956.42	2195.037838	3.29
75	1956.50	2097.955907	3.14
76	1956.58	2083.146696	3.12
77	1956.67	2084.427709	3.12
78	1956.75	2152.995673	3.24
79	1956.83	2131.940204	3.20
80	1956.92	2059.327683	3.09
81	1957.00	2186.021012	3.29
82	1957.08	2052.489818	3.07
83	1957.17	2041.162583	3.05
84	1957.25	1885.190266	2.83
85	1957.33	1923.539141	2.88
86	1957.42	1896.646176	2.83
87	1957.50	1904.679456	2.83
88	1957.58	1738.870198	2.61
89	1957.67	1686.209432	2.51
90	1957.75	1475.477253	2.20
91	1957.83	1389.86473	2.07
92	1957.92	1333.257206	1.98
93	1958.00	1327.263305	1.98
94	1958.08	1217.544839	1.81
95	1958.17	1155.803463	1.72
96	1958.25	1100.561626	1.63
97	1958.33	1129.700848	1.66
98	1958.42	1201.091885	1.77
99	1958.50	1253.910537	1.85
100	1958.58	1257.848419	1.85