home / fivethirtyeight

Most Common Name: surnames.csv

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

151,671 rows

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array

CSV options:

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
)
Powered by Datasette · Query took 20.831ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub