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
101	101	HENDERSON	101	210094	77.88	17191.94	62.18	33.2	0.38	0.82	1.81	1.61
102	102	COLEMAN	102	208624	77.34	17269.27	52.04	43.83	0.33	0.5	1.87	1.44
103	103	SIMMONS	103	201650	74.75	17344.02	60.55	35.26	0.35	0.61	1.74	1.5
104	104	PATTERSON	104	198557	73.6	17417.63	70.09	25.66	0.37	0.61	1.67	1.61
105	105	JORDAN	105	197212	73.11	17490.73	64.3	30.06	0.44	0.68	1.67	2.86
106	106	REYNOLDS	106	195598	72.51	17563.24	83.28	12.5	0.42	0.61	1.55	1.65
107	107	HAMILTON	107	194331	72.04	17635.28	72.79	22.65	0.44	0.78	1.73	1.61
108	108	GRAHAM	108	194074	71.94	17707.22	72.84	22.72	0.42	0.77	1.61	1.64
109	109	KIM	109	194067	71.94	17779.16	2.6	0.36	94.52	0.03	1.99	0.5
110	110	GONZALES	110	193934	71.89	17851.05	10	0.86	3.1	0.76	0.84	84.44
111	111	ALEXANDER	111	193443	71.71	17922.76	60.91	33.22	0.91	0.7	2.05	2.21
112	112	RAMOS	112	193096	71.58	17994.34	7.2	0.92	5.04	0.25	1.18	85.42
113	113	WALLACE	113	190760	70.71	18065.06	71.76	23.73	0.43	0.73	1.72	1.64
114	114	GRIFFIN	114	190636	70.67	18135.72	66.46	29.77	0.34	0.5	1.56	1.36
115	115	WEST	115	188464	69.86	18205.59	77.69	17.8	0.39	0.81	1.64	1.66
116	116	COLE	116	187793	69.61	18275.2	77.59	18.2	0.43	0.68	1.61	1.48
117	117	HAYES	117	187473	69.5	18344.7	71.64	24.05	0.38	0.73	1.71	1.48
118	118	CHAVEZ	118	185865	68.9	18413.6	5.65	0.21	0.59	1.15	0.43	91.98
119	119	GIBSON	119	184420	68.36	18481.96	74.57	21.07	0.36	0.85	1.65	1.49
120	120	BRYANT	120	183761	68.12	18550.08	60.97	34.68	0.3	0.89	1.79	1.37
121	121	ELLIS	121	181934	67.44	18617.52	72.82	22.6	0.44	0.66	1.64	1.83
122	122	STEVENS	122	181417	67.25	18684.77	83.4	11.4	0.53	1.23	1.64	1.79
123	123	MURRAY	123	178414	66.14	18750.91	77.59	18.13	0.48	0.6	1.54	1.66
124	124	FORD	124	178397	66.13	18817.04	64.28	31.4	0.37	0.61	1.84	1.51
125	125	MARSHALL	125	177213	65.69	18882.73	68.89	26.35	0.42	0.88	1.82	1.64
126	126	OWENS	126	176334	65.37	18948.1	68.09	27.86	0.31	0.71	1.69	1.35
127	127	MCDONALD	127	176094	65.28	19013.38	79.19	16.26	0.43	0.76	1.51	1.85
128	128	HARRISON	128	175577	65.09	19078.46	71	23.76	0.42	1.35	1.69	1.78
129	129	RUIZ	129	175429	65.03	19143.49	6.12	0.48	1.01	0.28	0.41	91.7
130	130	KENNEDY	130	171636	63.62	19207.12	82.97	12.98	0.46	0.62	1.4	1.57
131	131	WELLS	131	170635	63.25	19270.37	76.31	19.34	0.37	0.8	1.61	1.56
132	132	ALVAREZ	132	168817	62.58	19332.95	6.61	0.64	1.15	0.47	0.47	90.66
133	133	WOODS	133	168814	62.58	19395.53	60.68	34.66	0.35	0.84	1.92	1.55
134	134	MENDOZA	134	168567	62.49	19458.02	4.93	0.38	5.2	0.29	0.64	88.57
135	135	CASTILLO	135	165473	61.34	19519.36	5.62	0.77	3.26	0.75	0.75	88.85
136	136	OLSON	136	163502	60.61	19579.97	96.03	0.36	0.54	0.64	1.04	1.38
137	137	WEBB	137	163481	60.6	19640.57	77.74	18.36	0.38	0.62	1.5	1.41
138	138	WASHINGTON	138	163036	60.44	19701.01	5.16	89.87	0.25	0.64	2.64	1.45
139	139	TUCKER	139	162933	60.4	19761.41	72.06	23.57	0.33	0.74	1.72	1.59
140	140	FREEMAN	140	162686	60.31	19821.71	67.96	27.47	0.37	0.95	1.76	1.49
141	141	BURNS	141	162153	60.11	19881.82	82.18	13.63	0.45	0.71	1.45	1.59
142	142	HENRY	142	161392	59.83	19941.65	65.06	28.76	0.57	1.71	2	1.9
143	143	VASQUEZ	143	159989	59.31	20000.96	5.49	0.5	0.69	0.37	0.49	92.46
144	144	SNYDER	144	159363	59.08	20060.03	95.37	1.28	0.46	0.51	1.11	1.28
145	145	SIMPSON	145	158241	58.66	20118.69	73.29	22.13	0.44	0.78	1.68	1.69
146	146	CRAWFORD	146	158121	58.61	20177.31	71.31	24.47	0.4	0.69	1.69	1.45
147	147	JIMENEZ	147	157475	58.38	20235.68	4.46	0.31	1.53	0.27	0.45	92.98
148	148	PORTER	148	156848	58.14	20293.83	71.19	24.44	0.42	0.75	1.62	1.58
149	149	MASON	149	155484	57.64	20351.47	70.99	24.48	0.42	0.73	1.7	1.68
150	150	SHAW	150	155172	57.52	20408.99	74.67	20.23	1.24	0.73	1.65	1.48
151	151	GORDON	151	154934	57.43	20466.42	67.75	27.22	0.45	0.69	1.89	2
152	152	WAGNER	152	154516	57.28	20523.7	93.97	2.5	0.43	0.49	1	1.6
153	153	HUNTER	153	154410	57.24	20580.94	62.92	32.3	0.4	0.97	1.87	1.54
154	154	ROMERO	154	153772	57.0	20637.94	10.44	0.46	1.34	0.95	0.66	86.13
155	155	HICKS	155	153618	56.95	20694.89	69.46	26.14	0.37	0.94	1.68	1.42
156	156	DIXON	156	152015	56.35	20751.24	57.05	38.21	0.38	0.89	1.84	1.62
157	157	HUNT	157	151986	56.34	20807.58	76.03	16.33	0.48	3.93	1.68	1.55
158	158	PALMER	158	150407	55.76	20863.33	77.87	17.31	0.45	0.83	1.62	1.93
159	159	ROBERTSON	159	150299	55.72	20919.05	75.35	20.24	0.41	0.87	1.55	1.58
160	160	BLACK	160	150186	55.67	20974.72	76.65	18.56	0.42	1.35	1.49	1.53
161	161	HOLMES	161	150166	55.67	21030.39	59.22	36.52	0.31	0.73	1.72	1.5
162	162	STONE	162	149802	55.53	21085.92	87.4	7.9	0.55	0.93	1.58	1.64
163	163	MEYER	163	149664	55.48	21141.4	96.07	0.45	0.57	0.24	1.13	1.55
164	164	BOYD	164	149476	55.41	21196.81	65.64	29.94	0.41	0.97	1.66	1.38
165	165	MILLS	165	147909	54.83	21251.64	79.7	16.09	0.4	0.79	1.5	1.52
166	166	WARREN	166	147906	54.83	21306.47	72.5	23.09	0.43	0.8	1.72	1.47
167	167	FOX	167	147357	54.62	21361.09	89.82	5.68	0.55	1.03	1.39	1.54
168	168	ROSE	168	146924	54.46	21415.56	84.23	10.86	0.52	0.61	1.83	1.95
169	169	RICE	169	146440	54.28	21469.84	79.65	16.26	0.4	0.65	1.51	1.52
170	170	MORENO	170	146088	54.15	21524.0	7.05	0.37	0.64	0.48	0.49	90.97
171	171	SCHMIDT	171	145565	53.96	21577.96	96.48	0.28	0.46	0.33	0.87	1.57
172	172	PATEL	172	145066	53.78	21631.73	1.55	0.26	91.37	0.41	5.84	0.57
173	173	FERGUSON	173	142256	52.73	21684.47	77.54	18.05	0.44	0.6	1.66	1.71
174	174	NICHOLS	174	141936	52.62	21737.08	84.29	11.36	0.41	0.69	1.57	1.69
175	175	HERRERA	175	140786	52.19	21789.27	5.6	0.37	1.01	0.68	0.41	91.93
176	176	MEDINA	176	139353	51.66	21840.93	6.39	0.53	1.95	0.39	0.64	90.1
177	177	RYAN	177	139335	51.65	21892.58	93.33	2.82	0.64	0.42	1.17	1.62
178	178	FERNANDEZ	178	139302	51.64	21944.22	11.35	1.28	5.17	0.22	1.29	80.7
179	179	WEAVER	179	138811	51.46	21995.68	85.71	10.02	0.4	1.07	1.4	1.41
180	180	DANIELS	180	138776	51.44	22047.12	57.17	37.83	0.44	0.86	1.92	1.78
181	181	STEPHENS	181	138742	51.43	22098.55	76.54	19.22	0.37	0.64	1.61	1.63
182	182	GARDNER	182	138660	51.4	22149.95	77.23	18.67	0.44	0.67	1.51	1.47
183	183	PAYNE	183	138028	51.17	22201.12	73.69	22.03	0.35	0.54	1.75	1.64
184	184	KELLEY	184	137555	50.99	22252.11	85.81	10.21	0.47	0.62	1.52	1.38
185	185	DUNN	185	136955	50.77	22302.88	82.35	13.48	0.63	0.54	1.48	1.53
186	186	PIERCE	186	136517	50.61	22353.48	82.72	12.63	0.4	1.01	1.61	1.64
187	187	ARNOLD	187	136315	50.53	22404.02	83.35	12.63	0.43	0.55	1.48	1.56
188	188	TRAN	188	136095	50.45	22454.47	1.56	0.16	95.61	0.07	1.98	0.62
189	189	SPENCER	189	134443	49.84	22504.3	71.71	22.55	0.69	1.33	1.97	1.75
190	190	PETERS	190	134231	49.76	22554.06	85.16	9.45	0.78	1.34	1.54	1.73
191	191	HAWKINS	191	134066	49.7	22603.76	63.6	32.07	0.37	0.65	1.72	1.58
192	192	GRANT	192	134034	49.69	22653.45	58.25	36.58	0.41	1.07	1.89	1.81
193	193	HANSEN	193	133474	49.48	22702.93	95.64	0.4	0.6	0.49	1.24	1.62
194	194	CASTRO	194	133254	49.4	22752.32	8.72	0.66	3.83	0.3	0.97	85.52
195	195	HOFFMAN	195	132645	49.17	22801.49	95.45	1.11	0.44	0.53	1.04	1.43
196	196	HART	196	132466	49.1	22850.6	82.71	12.92	0.46	0.73	1.48	1.7
197	197	ELLIOTT	197	132457	49.1	22899.7	83.87	12.16	0.42	0.62	1.48	1.45
198	198	CUNNINGHAM	198	131896	48.89	22948.59	75.56	20.4	0.41	0.47	1.53	1.63
199	199	KNIGHT	199	131860	48.88	22997.47	74.79	20.78	0.4	0.74	1.67	1.63
200	200	BRADLEY	200	131289	48.67	23046.14	71.21	24.39	0.4	0.82	1.62	1.56

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