Most Common Name: adjustments.csv

Table actions

This directory contains the code and data behind the story Dear Mona, What’s The Most Common Name In America?

The main script file is most-common-name.R

There are four input files:

  • state-pop.csv - Total population and Hispanic population by state.
  • surnames.csv - Data on surnames from the U.S. Census Bureau, including a breakdown by race/ethnicity.
  • aging-curve.csv - Data from the Social Security Administration on the chances that someone born in the decade shown was still alive in 2013: http://www.ssa.gov/oact/NOTES/as120/LifeTables_Tbl_7.html
  • adjustments.csv - Taken directly from Lee Hartman's article: http://mypage.siu.edu/lhartman/johnsmith.html.

And five output files:

  • adjusted-name-combinations-list.csv - Adjusted estimates for the most common full names.
  • adjusted-name-combinations-matrix.csv - The same data from the file adjusted-name-combinations-list.csv but in matrix form. These are the estimates presented in the second (and final) table of the article.
  • independent-name-combinations-by-pop.csv - Matrix of estimates for the top 100 most common first names by top 100 most common surnames. These were calculated using independent odds, and displayed in the first table presented in the article.
  • new-top-firstNames.csv - Final estimated ranking of top first names.
  • new-top-surnames.csv - Final estimated ranking of top surnames.

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

20 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Martin, Wilson, Williams

Link rowid ▼ Unnamed: 0 Miller Anderson Martin Smith Thompson Wilson Moore White Taylor Davis Johnson Brown Jones Thomas Williams Jackson Lee Garcia Martinez Rodriguez
1 1 John 8.4 6.9 13.4 -23.5 3.6 2.5 3.6 1.7 0.4 -3.8 -35.2 -34.3 -26.5 5.1 -11.3 -27.7 -8.3 -66.4 -63.6 -69.5
2 2 Michael 18.1 2.4 13.0 5.6 6.7 2.6 15.7 -1.7 0.6 2.5 -4.8 4.2 -2.4 2.9 -8.1 -16.8 -9.8 -54.7 -54.4 -63.2
3 3 James 20.3 24.0 35.9 21.1 33.6 40.9 43.0 41.0 37.4 32.8 9.6 25.4 8.9 24.8 20.7 19.8 12.2 -84.4 -83.9 -87.4
4 4 Robert 29.6 27.0 16.8 8.7 18.0 22.0 17.2 18.1 39.2 7.2 5.9 14.2 12.6 4.8 -1.3 -1.8 12.1 -57.4 -55.1 -61.0
5 5 David 27.9 28.1 15.8 10.8 11.0 12.6 8.8 16.2 -1.5 -44.7 3.5 10.3 5.0 0.9 -7.3 -15.4 10.1 -30.5 -28.5 -31.7
6 6 Mary 21.5 18.2 26.2 14.7 18.5 18.9 22.8 22.5 16.0 14.8 11.7 13.1 12.2 18.9 13.1 8.7 -16.4 -42.4 -41.3 -54.0
7 7 William 22.5 7.0 33.3 16.6 29.3 21.5 31.9 38.2 29.2 23.1 4.3 22.3 15.4 19.8 -59.1 9.6 -11.4 -82.3 -80.2 -74.2
8 8 Richard 24.1 22.9 12.6 6.2 8.4 1.7 7.3 12.2 5.0 5.2 -2.0 3.9 -4.6 -2.3 -17.0 -21.6 -6.6 -43.2 -43.0 -47.7
9 9 Thomas 12.9 3.0 22.1 -2.6 -3.5 9.7 32.2 13.2 4.3 -5.9 -15.0 1.8 -3.5 -81.1 -11.5 -11.0 -8.9 -77.8 -75.6 -84.2
10 10 Jennifer 24.9 17.3 22.5 16.7 15.2 14.8 11.5 14.8 14.9 8.7 10.3 6.5 24.0 -1.6 -7.4 -6.3 22.5 -32.9 -32.2 -33.2
11 11 Patricia 20.9 10.7 25.3 17.1 16.7 6.7 19.0 17.2 19.4 11.8 7.1 15.2 11.2 15.9 10.6 8.8 -22.9 -16.0 -16.9 -23.3
12 12 Joseph -8.9 -34.8 0.1 -27.6 -24.8 -26.1 -20.4 -10.6 -23.9 -26.7 -33.9 -23.9 -39.0 -7.5 -26.4 -26.0 -26.4 -45.8 -40.3 -52.8
13 13 Linda 34.0 25.8 29.6 27.5 24.8 24.4 29.3 26.1 28.6 24.4 22.9 19.3 21.1 17.4 15.3 16.1 6.5 -49.2 -50.0 -56.5
14 14 Maria -77.6 -77.3 -52.1 -78.8 -76.4 -77.4 -79.3 -77.7 -80.3 -79.7 -78.3 -78.5 -79.4 -75.6 -79.4 -80.9 -77.5 663.9 614.1 639.8
15 15 Charles 36.3 25.7 29.3 38.4 38.1 45.7 49.0 43.4 41.2 43.6 24.8 39.9 30.5 37.0 33.3 29.0 4.6 -83.7 -84.5 -88.5
16 16 Barbara 35.5 25.3 25.1 24.0 20.6 25.8 24.6 25.2 24.7 24.2 20.3 26.7 16.2 16.6 14.8 18.5 -18.7 -66.9 -67.5 -67.9
17 17 Mark 42.1 45.9 -38.5 4.1 32.4 22.0 -23.1 -16.8 11.0 7.3 14.7 -14.0 -16.7 2.5 -7.3 -23.4 -33.6 -67.0 -63.0 -71.3
18 18 Daniel 19.9 -19.1 10.3 -5.2 -6.4 -13.9 -8.5 -5.0 21.3 -22.2 -17.8 -15.5 -25.1 -25.3 -28.7 -32.3 -1.3 35.1 33.2 24.0
19 19 Susan 32.1 28.4 15.8 3.9 5.4 3.5 3.5 -0.9 3.0 -5.8 -6.5 -4.6 -17.1 -1.5 -24.2 -31.9 3.7 -68.2 -68.0 -71.7
20 20 Elizabeth 13.3 7.4 13.5 1.7 9.1 7.9 8.4 4.0 1.7 -2.4 -3.7 -3.4 -5.5 -3.3 -13.9 -18.2 -20.2 16.3 23.4 22.5

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "most-common-name/adjustments" (
"Unnamed: 0" TEXT,
  "Miller" REAL,
  "Anderson" REAL,
  "Martin" REAL,
  "Smith" REAL,
  "Thompson" REAL,
  "Wilson" REAL,
  "Moore" REAL,
  "White" REAL,
  "Taylor" REAL,
  "Davis" REAL,
  "Johnson" REAL,
  "Brown" REAL,
  "Jones" REAL,
  "Thomas" REAL,
  "Williams" REAL,
  "Jackson" REAL,
  "Lee" REAL,
  "Garcia" REAL,
  "Martinez" REAL,
  "Rodriguez" REAL
);