jobs

U.S. occupation counts by sex and census year

U.S. census data on occupations by sex and year across decades between 1850 and 2000. Obtained from IPUMS USA, which "collects, preserves and harmonizes U.S. census microdata" from as early as 1790.

Originally created for a 2006 data visualization project called sense.us by IBM Research (Jeff Heer, Martin Wattenberg and Fernanda Viégas), described here. The dataset is also referenced in this vega example.

Based on a tabulation of the OCC1950 variable by sex across IPUMS USA samples. Appears to be derived from Version 6.0 (2015) of IPUMS USA, according to 2024 correspondence with the IPUMS Project. IPUMS has made improvements to occupation coding since version 6, particularly for 19th-century samples, which may result in discrepancies between this dataset and current IPUMS data. Details on data revisions are available here.

IPUMS USA confirmed in 2024 correspondence that hosting this dataset on vega-datasets is permissible, stating:

We're excited to hear that this dataset made its way to this repository and is being used by students for data visualization. We allow for these types of redistributions of summary data so long as the underlying microdata records are not shared.

  1. Represents summary data. Underlying microdata records are not included.
  2. Users attempting to replicate or extend this data should use the PERWT (person weight) variable as an expansion factor when working with IPUMS USA extracts.
  3. Due to coding revisions, figures for earlier years (particularly 19th century) may not match current IPUMS USA data exactly.

When using this dataset, please refer to IPUMS USA terms of use. The organization requests use of the following citation for this json file:

Steven Ruggles, Katie Genadek, Ronald Goeken, Josiah Grover, and Matthew Sobek. Integrated Public Use Microdata Series: Version 6.0. Minneapolis: University of Minnesota, 2015. http://doi.org/10.18128/D010.V6.0

JSON 7,650 rows 5 fields 937 KB 2 gallery examples 2 examples License not specified

Fields

FieldTypeDistributionSummaryMissing
job

The occupation title

 string 255 distinct Accountant / Auditor 30 · Actor 30 · Advertising Agent 30 Missing 0
sex

Sex (men/women)

 string 2 distinct men 3,825 · women 3,825 Missing 0
year

Census year

 integer 1,850 – 2,000 · mean 1,927 Missing 0
count

Number of individuals in the occupation

 integer 0 – 11,270,000 · mean 125,400 Missing 0
perc

Percentage of the workforce in the occupation

 number 0 – 0.447 · mean 0.002 Missing 0

Profiled across all 7,650 rows.

Explore

Pick two fields. Scroll to zoom, drag to pan. Click the legend to isolate a sex. Both fields have values in 7,650 of 7,650 rows.Pick two fields. Tap the legend to isolate a sex. Both fields have values in 7,650 of 7,650 rows. Vega-Lite · input binding · scale binding · legend bindingVega-Lite · input binding · legend binding
Open This Chart in the Vega Editor

Preview

First 5 of 7,650 rows5 of 7,650 rows
jobsexyearcountperc
Accountant / Auditormen18507080.0001309607003215936
Accountant / Auditormen186018050.0002140036901112748
Accountant / Auditormen187013109.97788185410981e-05
Accountant / Auditormen188022950.00012535994554735403
Accountant / Auditormen1900117530.0003958602442571888

Scroll sideways for all 5 fields.

Examples

Vega and Vega-Lite examples open in the Editor with this dataset loaded. Altair examples link to their Python source.

Provenance

Source
License

Not specified. IPUMS Terms of Use (www.ipums.org). Check the source's terms before reuse.

File
data/jobs.json · 936,649 bytes · View on GitHub