fivethirtyeight: most-common-name/surnames: 151,671 rows

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

151,671 rows

descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link	rowid ▼	name	rank	count	prop100k	cum_prop100k	pctwhite	pctblack	pctapi	pctaian	pct2prace	pcthispanic
1	1	SMITH	1	2376206	880.85	880.85	73.35	22.22	0.4	0.85	1.63	1.56
2	2	JOHNSON	2	1857160	688.44	1569.3	61.55	33.8	0.42	0.91	1.82	1.5
3	3	WILLIAMS	3	1534042	568.66	2137.96	48.52	46.72	0.37	0.78	2.01	1.6
4	4	BROWN	4	1380145	511.62	2649.58	60.71	34.54	0.41	0.83	1.86	1.64
5	5	JONES	5	1362755	505.17	3154.75	57.69	37.73	0.35	0.94	1.85	1.44
6	6	MILLER	6	1127803	418.07	3572.82	85.81	10.41	0.42	0.63	1.31	1.43
7	7	DAVIS	7	1072335	397.51	3970.33	64.73	30.77	0.4	0.79	1.73	1.58
8	8	GARCIA	8	858289	318.17	4288.5	6.17	0.49	1.43	0.58	0.51	90.81
9	9	RODRIGUEZ	9	804240	298.13	4586.62	5.52	0.54	0.58	0.24	0.41	92.7
10	10	WILSON	10	783051	290.27	4876.9	69.72	25.32	0.46	1.03	1.74	1.73
11	11	MARTINEZ	11	775072	287.32	5164.22	6.04	0.52	0.6	0.64	0.46	91.72
12	12	ANDERSON	12	762394	282.62	5446.83	77.6	18.06	0.48	0.7	1.59	1.58
13	13	TAYLOR	13	720370	267.04	5713.87	67.8	27.67	0.39	0.75	1.78	1.61
14	14	THOMAS	14	710696	263.45	5977.33	55.53	38.17	1.63	1.01	2	1.66
15	15	HERNANDEZ	15	706372	261.85	6239.18	4.55	0.38	0.65	0.27	0.35	93.81
16	16	MOORE	16	698671	259.0	6498.17	68.85	26.92	0.37	0.65	1.7	1.5
17	17	MARTIN	17	672711	249.37	6747.54	77.47	15.3	0.71	0.94	1.59	3.99
18	18	JACKSON	18	666125	246.93	6994.47	41.93	53.02	0.31	1.04	2.18	1.53
19	19	THOMPSON	19	644368	238.87	7233.34	72.48	22.53	0.44	1.15	1.78	1.62
20	20	WHITE	20	639515	237.07	7470.4	67.91	27.38	0.39	1.01	1.76	1.55
21	21	LOPEZ	21	621536	230.4	7700.81	5.85	0.61	1.04	0.47	0.52	91.51
22	22	LEE	22	605860	224.59	7925.4	40.09	17.41	37.83	1.03	2.3	1.34
23	23	GONZALEZ	23	597718	221.57	8146.97	4.76	0.37	0.38	0.18	0.33	93.99
24	24	HARRIS	24	593542	220.02	8366.99	53.88	41.63	0.36	0.65	2.02	1.45
25	25	CLARK	25	548369	203.28	8570.27	76.84	18.53	0.41	0.94	1.6	1.68
26	26	LEWIS	26	509930	189.03	8759.3	60.97	33.83	0.45	1.14	1.97	1.64
27	27	ROBINSON	27	503028	186.47	8945.77	51.34	44.1	0.37	0.51	1.99	1.68
28	28	WALKER	28	501307	185.83	9131.61	61.25	34.17	0.35	0.83	1.8	1.6
29	29	PEREZ	29	488521	181.09	9312.7	5.95	0.48	1.18	0.26	0.48	91.65
30	30	HALL	30	473568	175.55	9488.25	75.11	20.75	0.48	0.63	1.63	1.4
31	31	YOUNG	31	465948	172.73	9660.97	68.91	23.79	2.95	0.73	1.93	1.69
32	32	ALLEN	32	463368	171.77	9832.74	70.24	25.14	0.41	0.83	1.77	1.62
33	33	SANCHEZ	33	441242	163.57	9996.31	5.77	0.5	1.01	0.49	0.45	91.78
34	34	WRIGHT	34	440367	163.24	10159.55	68.3	27.36	0.4	0.66	1.75	1.52
35	35	KING	35	438986	162.73	10322.28	72.8	22.02	0.88	0.97	1.71	1.62
36	36	SCOTT	36	420091	155.73	10478.01	62.6	32.26	0.41	1.15	1.9	1.68
37	37	GREEN	37	413477	153.27	10631.29	59.33	36.23	0.34	0.61	1.78	1.71
38	38	BAKER	38	413351	153.23	10784.51	82.08	13.63	0.45	0.83	1.54	1.47
39	39	ADAMS	39	413086	153.13	10937.64	76.17	19.2	0.45	0.79	1.63	1.76
40	40	NELSON	40	412236	152.81	11090.46	80.29	14.93	0.51	1.09	1.49	1.68
41	41	HILL	41	411770	152.64	11243.1	66.83	28.42	0.42	0.91	1.78	1.64
42	42	RAMIREZ	42	388987	144.2	11387.3	4.4	0.29	0.97	0.27	0.4	93.67
43	43	CAMPBELL	43	371953	137.88	11525.18	76.47	19.13	0.43	0.65	1.67	1.65
44	44	MITCHELL	44	367433	136.21	11661.38	63.55	31.52	0.39	0.98	1.93	1.63
45	45	ROBERTS	45	366215	135.75	11797.14	79.56	15.86	0.47	0.85	1.67	1.58
46	46	CARTER	46	362548	134.4	11931.53	60.51	34.99	0.39	0.71	1.88	1.52
47	47	PHILLIPS	47	351848	130.43	12061.96	78.95	16.36	0.45	0.99	1.68	1.58
48	48	EVANS	48	342237	126.87	12188.83	70.65	25.05	0.4	0.68	1.67	1.55
49	49	TURNER	49	335663	124.43	12313.26	66.67	29.31	0.33	0.56	1.72	1.4
50	50	TORRES	50	325169	120.54	12433.8	6.05	0.58	1.42	0.26	0.53	91.16
51	51	PARKER	51	324246	120.2	12554.0	71.49	24.09	0.44	0.85	1.67	1.46
52	52	COLLINS	52	317848	117.83	12671.82	73.92	21.7	0.37	0.75	1.65	1.61
53	53	EDWARDS	53	317070	117.54	12789.36	65.16	30.21	0.4	0.75	1.84	1.63
54	54	STEWART	54	312899	115.99	12905.35	71.78	23.83	0.38	0.74	1.69	1.59
55	55	FLORES	55	312615	115.89	13021.23	5.57	0.47	2.15	0.43	0.54	90.84
56	56	MORRIS	56	311754	115.57	13136.8	75.92	19.29	0.43	0.93	1.7	1.73
57	57	NGUYEN	57	310125	114.96	13251.76	1.26	0.18	95.93	0.04	2.01	0.58
58	58	MURPHY	58	300501	111.39	13363.16	85.05	11.03	0.43	0.65	1.29	1.54
59	59	RIVERA	59	299463	111.01	13474.17	5.92	1.06	2.06	0.24	0.55	90.17
60	60	COOK	60	294795	109.28	13583.45	83.52	12.27	0.44	0.86	1.48	1.42
61	61	ROGERS	61	294403	109.13	13692.58	77.8	17.66	0.42	0.77	1.58	1.77
62	62	MORGAN	62	276400	102.46	13795.04	78.47	16.47	0.42	1.15	1.64	1.86
63	63	PETERSON	63	275041	101.96	13897.0	86.29	9.58	0.52	0.7	1.33	1.56
64	64	COOPER	64	270097	100.12	13997.12	70.36	25.26	0.4	0.76	1.69	1.54
65	65	REED	65	267443	99.14	14096.26	73.51	21.97	0.4	1	1.67	1.45
66	66	BAILEY	66	265916	98.57	14194.84	74.77	21.14	0.4	0.61	1.63	1.45
67	67	BELL	67	264752	98.14	14292.98	63.57	31.78	0.41	0.9	1.8	1.55
68	68	GOMEZ	68	263590	97.71	14390.69	6.1	0.81	1.04	0.34	0.54	91.16
69	69	KELLY	69	260385	96.52	14487.22	80.39	15.48	0.49	0.55	1.35	1.73
70	70	HOWARD	70	254779	94.45	14581.66	66.83	28.69	0.38	0.82	1.74	1.55
71	71	WARD	71	254121	94.2	14675.86	77.79	17.77	0.4	0.83	1.57	1.64
72	72	COX	72	253771	94.07	14769.94	84.48	11.55	0.39	0.64	1.42	1.52
73	73	DIAZ	73	251772	93.33	14863.27	6.17	0.73	1.19	0.22	0.47	91.22
74	74	RICHARDSON	74	249533	92.5	14955.77	62.25	32.77	0.36	1.05	1.82	1.75
75	75	WOOD	75	247299	91.67	15047.44	90.06	5.61	0.51	0.82	1.4	1.6
76	76	WATSON	76	242432	89.87	15137.31	68.58	26.85	0.47	0.8	1.72	1.58
77	77	BROOKS	77	240751	89.25	15226.56	62.72	32.67	0.41	0.75	1.83	1.62
78	78	BENNETT	78	239055	88.62	15315.17	79	16.51	0.41	0.89	1.54	1.65
79	79	GRAY	79	236713	87.75	15402.92	71.13	24.36	0.44	0.84	1.66	1.57
80	80	JAMES	80	233224	86.46	15489.38	54.45	38.09	0.81	2.51	2.1	2.04
81	81	REYES	81	232511	86.19	15575.57	5.26	0.75	6.02	0.3	0.76	86.9
82	82	CRUZ	82	231065	85.66	15661.22	5.95	0.83	5.61	0.38	0.99	86.24
83	83	HUGHES	83	229390	85.03	15746.26	80.6	15.45	0.39	0.52	1.46	1.58
84	84	PRICE	84	228756	84.8	15831.06	76.11	19.79	0.42	0.64	1.58	1.46
85	85	MYERS	85	224824	83.34	15914.4	86.59	9.75	0.38	0.53	1.35	1.4
86	86	LONG	86	223494	82.85	15997.25	82.35	11.75	1.78	1.21	1.44	1.47
87	87	FOSTER	87	221040	81.94	16079.19	72	23.19	0.46	0.86	1.78	1.7
88	88	SANDERS	88	220902	81.89	16161.07	63.44	31.9	0.33	0.85	1.73	1.76
89	89	ROSS	89	219961	81.54	16242.61	71.46	23.67	0.46	0.89	1.69	1.82
90	90	MORALES	90	217642	80.68	16323.29	5.6	0.6	1.24	0.25	0.44	91.88
91	91	POWELL	91	216553	80.28	16403.57	69.96	25.97	0.38	0.56	1.71	1.41
92	92	SULLIVAN	92	215640	79.94	16483.5	89.45	6.78	0.46	0.52	1.16	1.63
93	93	RUSSELL	93	215432	79.86	16563.36	79.45	15.79	0.43	1	1.7	1.63
94	94	ORTIZ	94	214683	79.58	16642.95	5.4	0.64	0.68	0.48	0.45	92.35
95	95	JENKINS	95	213737	79.23	16722.18	60.12	35.97	0.33	0.55	1.69	1.34
96	96	GUTIERREZ	96	212905	78.92	16801.1	5.21	0.25	1.4	0.33	0.42	92.39
97	97	PERRY	97	212644	78.83	16879.93	70.71	24.37	0.46	0.82	1.86	1.78
98	98	BUTLER	98	210879	78.17	16958.1	64.75	30.85	0.35	0.81	1.75	1.5
99	99	BARNES	99	210426	78.0	17036.1	67.45	28.23	0.4	0.72	1.71	1.49
100	100	FISHER	100	210279	77.95	17114.05	84.59	11.28	0.42	0.71	1.42	1.58

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "most-common-name/surnames" (
"name" TEXT,
  "rank" INTEGER,
  "count" INTEGER,
  "prop100k" REAL,
  "cum_prop100k" REAL,
  "pctwhite" TEXT,
  "pctblack" TEXT,
  "pctapi" TEXT,
  "pctaian" TEXT,
  "pct2prace" TEXT,
  "pcthispanic" TEXT
);

Most Common Name: surnames.csv

151,671 rows

Advanced export