most-common-name/surnames

151,671 rows sorted by pctapi

View and edit SQL

Link rowid name rank count prop100k cum_prop100k pctwhite pctblack pctapi ▼ pctaian pct2prace pcthispanic
3228 STOLTZFUS 3228 10159 3.77 54816.85 98.74 0.12 (S) (S) 0.62 0.45
3658 FREEDMAN 3658 8926 3.31 56333.04 95.43 1.29 (S) (S) 1.33 1.21
3962 BIANCO 3961 8228 3.05 57291.29 82.6 0.43 (S) (S) 0.78 15.78
4277 RUVALCABA 4274 7673 2.84 58220.04 2.06 (S) (S) 0.17 0.1 97.55
4740 MIRAMONTES 4740 6841 2.54 59466.23 4.72 (S) (S) 0.2 0.56 94.3
4747 MCKOY 4746 6825 2.53 59481.42 12.09 84.18 (S) (S) 1.96 1.44
4774 FISHMAN 4774 6777 2.51 59552.09 96.55 0.56 (S) (S) 1.24 1.18
4827 GINGERICH 4826 6674 2.47 59684.11 97.86 (S) (S) 0.27 1.02 0.69
4855 FRANKEL 4855 6633 2.46 59753.16 95.37 0.77 (S) (S) 1.58 1.52
4917 SANABRIA 4917 6566 2.43 59904.87 6.88 1.23 (S) (S) 0.58 91.14
5047 VALDOVINOS 5047 6375 2.36 60219.0 2.87 0.13 (S) (S) 0.13 96.74
5215 ROSENFELD 5215 6152 2.28 60607.12 95.42 0.46 (S) (S) 2.03 1.63
5335 MOUTON 5335 6015 2.23 60877.44 47.08 48.71 (S) (S) 1.83 1.93
5469 PLASCENCIA 5469 5846 2.17 61172.06 2.14 (S) (S) 0.19 0.14 97.43
5595 RESTREPO 5595 5692 2.11 61441.64 8.26 0.25 (S) (S) 0.6 90.76
5605 ETIENNE 5603 5678 2.1 61458.5 14.83 73.88 (S) (S) 8.14 2.59
5624 BORREGO 5622 5662 2.1 61498.43 9.41 (S) (S) 0.3 0.39 89.56
5825 SERVIN 5824 5437 2.02 61916.04 10.06 0.55 (S) (S) 0.33 88.73
5892 CARRASQUILLO 5892 5378 1.99 62050.43 6.12 1.23 (S) (S) 0.22 92.19
5901 DEASON 5901 5369 1.99 62068.36 91.6 4.19 (S) (S) 1.4 1.71
6028 DACOSTA 6028 5252 1.95 62318.53 57.24 21.55 (S) (S) 9.29 10
6123 TURCOTTE 6123 5160 1.91 62501.91 95.37 (S) (S) 1.47 1.49 0.97
6229 LEGRAND 6227 5058 1.87 62702.53 71.95 21.51 (S) (S) 2.31 3.56
6242 BENALLY 6240 5042 1.87 62723.13 1.43 (S) (S) 95.99 1.23 1.15
6260 BUENROSTRO 6259 5018 1.86 62758.58 2.65 (S) (S) 0.3 0.1 96.87
6329 NAPOLI 6329 4958 1.84 62889.78 95.99 0.34 (S) (S) 0.95 2.48
6426 LEIJA 6426 4879 1.81 63066.53 6.03 0.14 (S) (S) 0.31 93.34
6441 CARRIZALES 6439 4863 1.8 63089.99 6 (S) (S) 0.29 0.37 93.15
6457 TSOSIE 6456 4849 1.8 63120.6 1.07 (S) (S) 96.23 1.3 1.28
6514 NEARY 6514 4806 1.78 63222.61 95.92 1.31 (S) (S) 1.02 1.19
6573 RASCON 6573 4754 1.76 63327.12 6.37 (S) (S) 0.32 0.84 92.18
6580 SOUTHWORTH 6580 4750 1.76 63342.98 96.61 0.59 (S) (S) 0.91 1.49
6643 HUIZAR 6641 4693 1.74 63446.3 5.41 (S) (S) 0.11 0.36 93.95
6645 MCAVOY 6645 4691 1.74 63455.0 97.21 0.58 (S) (S) 0.75 0.98
6663 HOLMBERG 6661 4676 1.73 63482.78 94.61 (S) (S) 1.9 1.37 1.48
6665 LANDAU 6664 4675 1.73 63489.71 95.98 0.3 (S) (S) 1.78 1.65
6699 LUEVANO 6698 4652 1.72 63546.73 5.59 (S) (S) 0.26 0.37 93.64
6722 ENDICOTT 6722 4630 1.72 63586.3 96.31 (S) (S) 0.5 1.21 1.51
6789 LATTIMORE 6787 4578 1.7 63702.25 29.45 66.45 (S) (S) 1.94 1.38
6797 SANDLER 6796 4573 1.7 63714.12 96.37 1.12 (S) (S) 0.77 1.27
6860 AGOSTO 6860 4519 1.68 63820.17 10.51 2.26 (S) (S) 0.51 86.17
6910 BLOCH 6910 4478 1.66 63903.55 95.24 1.34 (S) (S) 0.89 2.01
6952 FALCO 6952 4449 1.65 63973.05 93.01 0.7 (S) (S) 1.08 4.63
6975 CHAPARRO 6973 4431 1.64 64009.26 5.87 (S) (S) 0.36 0.38 93.07
7013 ARREGUIN 7013 4406 1.63 64074.78 5.56 0.23 (S) 0.3 (S) 93.83
7037 CHAIREZ 7036 4391 1.63 64110.65 2.39 (S) (S) 0.14 0.2 97.13
7079 ESQUEDA 7077 4360 1.62 64178.73 3.88 (S) (S) 0.18 0.46 95.3
7102 ANTONELLI 7102 4339 1.61 64217.42 95.94 0.37 (S) (S) 1.04 2.44
7130 ACREE 7129 4322 1.6 64260.76 80.8 16.01 (S) (S) 1.32 1.06
7157 VIRAMONTES 7157 4302 1.59 64305.53 4.51 (S) (S) 0.14 0.46 94.77
7243 FRITSCH 7242 4248 1.57 64440.23 97.6 (S) (S) 0.19 0.45 1.55
7261 BOJORQUEZ 7258 4239 1.57 64465.39 5.83 (S) (S) 0.71 0.5 92.78
7269 SANTANGELO 7269 4229 1.57 64484.23 95.86 0.38 (S) (S) 0.83 2.53
7304 RUBALCAVA 7302 4208 1.56 64537.39 4.73 (S) (S) 0.29 0.38 94.44
7331 THARPE 7330 4187 1.55 64579.38 60 36.68 (S) (S) 1.46 1.1
7345 MALAVE 7344 4178 1.55 64602.63 7.59 2.01 (S) (S) 0.62 89.54
7416 SUBER 7415 4144 1.54 64710.63 32.19 64.43 (S) (S) 1.59 1.35
7451 TURCIOS 7450 4118 1.53 64764.22 3.57 0.34 (S) (S) 0.66 95.24
7485 SABOL 7485 4104 1.52 64817.56 97.12 0.34 (S) (S) 0.95 1.27
7503 BOOZER 7502 4095 1.52 64841.88 69.01 27.79 (S) (S) 1.51 1.29
7505 KIRSCHNER 7504 4094 1.52 64844.91 96.24 (S) (S) 0.46 1.07 1.83
7517 GROSSO 7517 4083 1.51 64864.62 93.56 0.32 (S) (S) 0.61 5.17
7527 OCEGUERA 7525 4078 1.51 64879.74 3.24 (S) (S) 0.2 0.34 96.17
7538 BEACHY 7538 4069 1.51 64896.35 98.55 0.17 (S) (S) 0.61 0.57
7562 DONEGAN 7560 4056 1.5 64929.48 88.49 8.75 (S) (S) 1.06 1.26
7660 PERAZA 7660 4005 1.48 65081.82 6.07 0.37 (S) (S) 0.55 92.68
7702 MANDUJANO 7702 3983 1.48 65145.48 2.46 0.18 (S) (S) 0.35 96.84
7704 DIMARCO 7702 3983 1.48 65142.53 94.78 0.35 (S) (S) 1.03 3.62
7705 BERUMEN 7702 3983 1.48 65141.05 6.75 (S) (S) 0.3 0.63 91.99
7749 SEEGER 7749 3953 1.47 65213.12 96.56 0.81 (S) (S) 0.96 1.21
7769 SOILEAU 7769 3944 1.46 65240.93 92.17 6.06 (S) (S) 0.63 0.71
7784 BOVE 7782 3937 1.46 65262.83 92.3 2.51 (S) (S) 1.09 3.51
7829 TOWNLEY 7826 3921 1.45 65331.27 93.29 2.63 (S) (S) 1.81 1.35
7872 PASTORE 7871 3900 1.45 65389.24 95.51 0.49 (S) (S) 0.69 2.95
7886 GRIBBLE 7886 3895 1.44 65409.47 93.76 2.49 (S) (S) 1.51 1.54
7890 MOULTRIE 7889 3893 1.44 65415.24 13.67 82.89 (S) (S) 2.26 0.9
7897 FAVORS 7896 3889 1.44 65423.9 19.39 77.19 (S) (S) 1.8 1.23
7906 ABATE 7905 3885 1.44 65436.86 90.66 4.58 (S) (S) 1.62 2.42
7968 KAUTZ 7966 3853 1.43 65527.18 95.2 (S) (S) 0.91 0.99 2.21
7978 LUBIN 7977 3847 1.43 65541.45 53.94 37.85 (S) (S) 4.76 2.57
8013 ZUCKER 8011 3818 1.42 65592.59 96.2 0.63 (S) (S) 1.1 1.49
8014 SCHLESINGER 8011 3818 1.42 65591.17 95.1 1.39 (S) (S) 1.13 1.68
8027 DEAS 8027 3812 1.41 65610.97 44.65 48.82 (S) (S) 2.07 4.12
8057 SARAVIA 8057 3795 1.41 65653.27 5.64 0.47 (S) (S) 0.5 93.04
8062 ROSEMAN 8061 3792 1.41 65660.3 79.54 17.56 (S) (S) 0.71 1.61
8066 AWAD 8066 3789 1.4 65665.92 72.95 3.59 (S) (S) 18.05 3.62
8093 DILLER 8092 3774 1.4 65702.35 96.32 1.09 (S) (S) 0.56 1.46
8112 CIFUENTES 8111 3766 1.4 65730.3 5.5 0.56 (S) (S) 0.32 93.28
8120 STETSON 8119 3762 1.39 65742.86 94.63 1.49 (S) (S) 1.06 1.89
8124 CATER 8124 3759 1.39 65747.04 76.46 19.23 (S) (S) 1.44 2.08
8152 PAVLIK 8152 3745 1.39 65785.99 97.7 (S) (S) 0.32 0.32 1.42
8227 DIORIO 8227 3706 1.37 65890.95 96.9 0.24 (S) (S) 0.89 1.75
8233 HANSEL 8231 3704 1.37 65897.82 94.84 1.92 (S) (S) 1.65 1.16
8250 MIELE 8249 3695 1.37 65922.5 97.16 0.49 (S) (S) 0.87 1
8262 QUESENBERRY 8260 3689 1.37 65936.18 95.74 (S) (S) 0.46 0.98 2.28
8274 MCELVEEN 8273 3683 1.37 65952.58 66.63 31.17 (S) (S) 1.06 0.87
8297 HEINS 8296 3673 1.36 65985.29 95.43 1.36 (S) (S) 1.2 1.69
8303 HERSH 8302 3669 1.36 65992.1 95.97 1.06 (S) (S) 1.01 1.2
8313 HORGAN 8312 3666 1.36 66005.69 92.36 4.01 (S) (S) 1.42 1.69
8319 CELAYA 8319 3662 1.36 66015.2 11.82 (S) (S) 1.86 0.82 85.2

Next page

Advanced export

JSON shape: default, array, newline-delimited

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 1916.611ms