Trying to compare data on various job titles over the years to discuss job destruction and creation. Any advice?

I would like to recreate something like this with my own data, Cox and Alm created this in 1992 and then again in 2002. The data has been hard to gather through BLS and the Census and I would like to be able to use one specific year for “yesterday” as opposed to the varying year.

Thank you for any advice. I am working on a book with a professor on Creative Destruction.

|

|

|

People Employed

|
|

Destruction

|

|

Today

|

|

Yesterday

|
|

|

|

|

|

|
|

Railroad employees

|

|

231,000

|

|

2,076,000

|

|

1920

|
|

Carriage and harness makers

|

|

*

|

|

109,000

|

|

1900

|
|

Telegraph operators

|

|

8,000

|

|

75,000

|

|

1920

|
|

Boilermakers

|

|

*

|

|

74,000

|

|

1920

|
|

Milliners

|

|

*

|

|

100,000

|

|

1910

|
|

Cobblers

|

|

25,000

|

|

102,000

|

|

1900

|
|

Blacksmiths

|

|

*

|

|

238,000

|

|

1910

|
|

Watchmakers

|

|

*

|

|

101,000

|

|

1920

|
|

Switchboard operators

|

|

213,000

|

|

421,000

|

|

1970

|
|

Farm workers

|

|

851,000

|

|

11,533,000

|

|

1910

|
|

|

|

|

|

|

|

|
|

Creation

|

|

|

|

|

|

|
|

Airline pilots and mechanics

|

|

232,000

|

|

0

|

|

1900

|
|

Medical technicians

|

|

1,379,000

|

|

0

|

|

1910

|
|

Engineers

|

|

1,846,000

|

|

38,000

|

|

1900

|
|

Computer programmers/operators

|

|

1,287,000

|

|

*

|

|

1960

|
|

Fax machine workers

|

|

699,000

|

|

0

|

|

1980

|
|

Auto mechanics

|

|

864,000

|

|

0

|

|

1900

|
|

Truck, bus and taxi drivers

|

|

3,328,000

|

|

0

|

|

1900

|
|

Professional athletes

|

|

77,000

|

|

*

|

|

1920

|
|

TV and radio announcers

|

|

60,000

|

|

*

|

|

1930

|
|

Electricians/electronic repairers

|

|

711,000

|

|

51,000

|

|

1900

|
|

Optometrists

|

|

62,000

|

|

*

|

|

1910

|
|

|

|

|

|

|

|

|
|

*Less than 5,000

DATA SOURCE: U.S. Bureau of the Census

|

A table of this sort should be reproducible using data from IPUMS-CPS. The CPS includes annual and monthly surveys, performed by the BLS, that provides information on the US labor force, employment, unemployment, etc. In particular there is information on each individual’s primary occupation and industry of employment.

I hope this is helpful.