New spreadsheet for compiling top 5000 surnames for Census 2000 and 2010

	A	B	C	D	E	F	G	H	I	J	K
1	year	name	rank	count	prop100k	pctwhite	pctblack	pctapi	pctaian	pct2prace	pcthispanic

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