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:

And five output files:

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

100 rows

View and edit SQL

Link rowid ▼ Unnamed: 0 name perct2013
1 1 SMITH 0.0079990080146578
2 2 JOHNSON 0.0063458645024773
3 3 WILLIAMS 0.0053295674370504
4 4 BROWN 0.0047235884570789
5 5 JONES 0.004676242251048
6 6 GARCIA 0.0040634570220249
7 7 RODRIGUEZ 0.0038180941044345
8 8 MILLER 0.0037309036725912
9 9 MARTINEZ 0.0036690430961962
10 10 DAVIS 0.0036492404235937
11 11 HERNANDEZ 0.0033661976654512
12 12 LOPEZ 0.0029460205257417
13 13 GONZALEZ 0.0028469128477587
14 14 WILSON 0.0026511330447396
15 15 ANDERSON 0.002553837659158
16 16 THOMAS 0.0024610382125154
17 17 TAYLOR 0.0024435463182195
18 18 LEE 0.0024251780830328
19 19 MOORE 0.0023644616809932
20 20 JACKSON 0.0023333325427375
21 21 PEREZ 0.0023167653060916
22 22 MARTIN 0.002275557899871
23 23 THOMPSON 0.0021738775703762
24 24 WHITE 0.0021680983151543
25 25 SANCHEZ 0.0020922218747451
26 26 HARRIS 0.0020480756643154
27 27 RAMIREZ 0.0018551779652957
28 28 CLARK 0.0018385627957445
29 29 LEWIS 0.0017462320690416
30 30 ROBINSON 0.0017421330796411
31 31 WALKER 0.0017135399111017
32 32 YOUNG 0.0015960835940868
33 33 HALL 0.0015902925616684
34 34 ALLEN 0.0015674400692234
35 35 TORRES 0.0015413473838856
36 36 NGUYEN 0.0015219127169618
37 37 WRIGHT 0.0014920285501798
38 38 FLORES 0.0014842179251604
39 39 KING 0.0014823709429294
40 40 SCOTT 0.0014351795319443
41 41 RIVERA 0.0014186221907258
42 42 GREEN 0.0014169338549713
43 43 HILL 0.0013986179964607
44 44 ADAMS 0.0013870506948124
45 45 BAKER 0.0013758052760651
46 46 NELSON 0.0013757783888087
47 47 MITCHELL 0.0012538434787615
48 48 CAMPBELL 0.0012482457247209
49 49 GOMEZ 0.0012480284975074
50 50 CARTER 0.0012408127092266
51 51 ROBERTS 0.0012241114065395
52 52 DIAZ 0.001192425464098
53 53 PHILLIPS 0.0011771449341033
54 54 EVANS 0.0011559695019946
55 55 TURNER 0.0011384830440789
56 56 REYES 0.0011056728990693
57 57 CRUZ 0.0010962235851038
58 58 PARKER 0.0010938640349311
59 59 EDWARDS 0.0010793078027445
60 60 COLLINS 0.0010693629130505
61 61 STEWART 0.0010557553031458
62 62 MORRIS 0.0010473455793825
63 63 MORALES 0.0010331403450158
64 64 ORTIZ 0.0010188662030526
65 65 GUTIERREZ 0.0010126011130322
66 66 MURPHY 0.0009951108422894
67 67 ROGERS 0.0009862179688178
68 68 COOK 0.0009787770982529
69 69 KIM 0.0009474528664843
70 70 MORGAN 0.000925835535208
71 71 COOPER 0.0009127788982938
72 72 RAMOS 0.0009125854897344
73 73 PETERSON 0.0009099453048788
74 74 GONZALES 0.0009054855106362
75 75 BELL 0.0009026113715919
76 76 REED 0.0008998516473333
77 77 BAILEY 0.0008932291144739
78 78 CHAVEZ 0.0008807140665263
79 79 KELLY 0.0008683287639442
80 80 HOWARD 0.0008648571573188
81 81 RICHARDSON 0.000852491512614
82 82 WARD 0.0008507426874205
83 83 COX 0.0008415516679816
84 84 RUIZ 0.0008312862898094
85 85 BROOKS 0.0008219188720834
86 86 WATSON 0.0008214268960144
87 87 WOOD 0.0008150246005718
88 88 JAMES 0.0008074138300494
89 89 MENDOZA 0.000803190620324
90 90 GRAY 0.0007991837866574
91 91 BENNETT 0.00079903507082
92 92 ALVAREZ 0.000797940096602
93 93 CASTILLO 0.0007846115945919
94 94 PRICE 0.0007670093584246
95 95 HUGHES 0.0007646746581424
96 96 VASQUEZ 0.000759628036195
97 97 SANDERS 0.0007532525687315
98 98 JIMENEZ 0.0007509776955419
99 99 LONG 0.0007469874312165
100 100 FOSTER 0.0007463956216964

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "most-common-name/new-top-surnames" (
"Unnamed: 0" INTEGER,
  "name" TEXT,
  "perct2013" REAL
);