home / fivethirtyeight / most-common-name/adjusted-name-combinations-matrix

Menu
  • GraphQL API

most-common-name/adjusted-name-combinations-matrix: 18

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 source: https://github.com/fivethirtyeight/data/blob/master/most-common-name/adjusted-name-combinations-matrix.csv

This data as json, copyable

rowid Unnamed: 0 FirstName SMITH JOHNSON WILLIAMS BROWN JONES GARCIA RODRIGUEZ MILLER MARTINEZ DAVIS HERNANDEZ LOPEZ GONZALEZ WILSON ANDERSON THOMAS TAYLOR LEE MOORE JACKSON
18 62 Linda 12092.3871413313 9247.16067328123 7285.96356716985 6681.56538038965 6714.39475381551 2447.51357394225 1969.25343313059 5927.6774072773 2175.14665328952 5382.55632903655       3910.36799242412 3809.25155959413 3425.72249945994 3725.86633274598 3062.37921608242 3624.90418083418 3211.99295442603
Powered by Datasette · Queries took 1526.8ms · Data source: https://github.com/fivethirtyeight/data/blob/master/most-common-name/adjusted-name-combinations-matrix.csv