Washtenaw County Age/Race/Sex

Census 2000 Summary File 1 Data
Plus Instructions for Doing It Yourself
Using American Factfinder
CSV Version at http://www.lib.umich.edu/govdocs/census2/washars.csv

All Races White Black Asian Amerind Hawaiian Other Two+ ............ Hispanic

Total: 322,895 249,916 39,697 20,338 1,161 126 3,364 8,293 8,839

Male: 160,558 124,044 19,553 10,374 582 54 1,793 4,158 4,640

Under 5 years 10,340 7,225 1,516 737 30 5 147 680 363

5 to 9 years 10,397 7,494 1,679 518 30 2 142 532 320

10 to 14 years 10,161 7,693 1,498 404 49 2 105 410 267

15 to 17 years 5,729 4,406 849 206 25 6 50 187 168

18 and 19 years 7,891 5,654 1,074 740 36 5 136 246 318

20 years 4,750 3,491 548 475 18 0 72 146 183

21 years 4,486 3,332 453 455 16 1 106 123 182

22 to 24 years 10,182 7,419 1,233 988 44 4 206 288 467

25 to 29 years 14,461 10,409 1,725 1,557 71 5 283 411 652

30 to 34 years 13,498 9,907 1,720 1,346 46 6 180 293 489

35 to 39 years 12,743 9,876 1,539 940 49 6 116 217 373

40 to 44 years 12,351 9,988 1,446 620 42 0 80 175 277

45 to 49 years 11,324 9,451 1,209 406 49 4 59 146 198

50 to 54 years 10,038 8,543 1,018 291 28 1 49 108 148

55 to 59 years 6,873 5,872 678 215 17 4 19 68 88

60 and 61 years 1,991 1,677 203 80 6 0 6 19 26

62 to 64 years 2,504 2,116 251 97 8 1 9 22 32

65 and 66 years 1,429 1,206 129 67 6 1 4 16 18

67 to 69 years 1,997 1,712 181 76 2 1 7 18 18

70 to 74 years 2,961 2,607 230 90 1 0 7 26 23

75 to 79 years 2,267 2,005 197 48 4 0 5 8 9

80 to 84 years 1,285 1,156 101 10 5 0 2 11 14

85 years and over 900 805 76 8 0 0 3 8 7

Female: 162,337 125,872 20,144 9,964 579 72 1,571 4,135 4,199

Under 5 years 9,790 6,730 1,487 665 34 6 162 706 410

5 to 9 years 9,899 6,988 1,687 526 43 3 129 523 322

10 to 14 years 9,469 7,105 1,450 415 38 6 105 350 264

15 to 17 years 5,503 4,098 833 253 29 2 62 226 166

18 and 19 years 8,864 6,380 1,322 749 31 5 121 256 274

20 years 4,753 3,538 596 419 9 1 56 134 164

21 years 4,703 3,475 581 432 15 3 69 128 161

22 to 24 years 9,570 6,920 1,299 855 45 8 164 279 368

25 to 29 years 13,244 9,478 1,646 1,470 72 5 219 354 551

30 to 34 years 12,410 9,199 1,509 1,203 45 9 148 297 416

35 to 39 years 12,560 9,831 1,464 903 49 4 109 200 294

40 to 44 years 12,373 10,058 1,398 599 43 8 71 196 252

45 to 49 years 11,948 9,983 1,338 409 37 5 44 132 175

50 to 54 years 10,150 8,542 1,054 360 34 2 35 123 110

55 to 59 years 6,957 5,919 696 222 20 2 26 72 90

60 and 61 years 2,085 1,779 211 63 5 0 6 21 19

62 to 64 years 2,627 2,242 235 110 7 0 6 27 31

65 and 66 years 1,615 1,360 164 62 1 1 5 22 21

67 to 69 years 2,301 1,989 204 76 8 0 5 19 27

70 to 74 years 3,696 3,194 368 97 3 2 11 21 37

75 to 79 years 3,207 2,867 270 36 3 0 8 23 21

80 to 84 years 2,314 2,094 173 20 7 0 6 14 13

85 years and over 2,299 2,103 159 20 1 0 4 12 13

METHODOLOGY FOR CREATING TABLE
1. Access American Factfinder http://factfinder.census.gov/
2. Choose DATA SETS
3. Choose 2000 CENSUS/SUMMARY FILE 1
4. Choose DETAILED TABLES
5. Choose Geography using the default LIST Geography screen
a. Choose County (as geographic level)
b. Choose State (Michigan)
c. Choose Washtenaw County and ADD
d. NEXT
6. Use the default SUBJECT search screen
a. Page down the subjects, highlight AGE, and search
b. Choose Tables 12, 12A-12G, in order. ADD.
c. Choose Table 12H and ADD.
d. SHOW Table.
7. Click on PRINT/DOWNLOAD instruction at top of screen.
a. Choose DOWNLOAD.
b. Check off CSV format and OK.
c. Name drive location and file.
8. Open up spreadsheet in EXCEL.
a. Alter the first of the tables to incorporate all of the tables.
b. Remove the county name at the head of the second column (e.g. Washtenaw) and make it the title of the table.
c. Replace the "Washtenaw" heading at the top of the second column with the variable that column represents (e.g. "total")
d. Leave the leftmost column intact.
e. CUT and PASTE the data in the remaining tables into columns that line up with the correct ages.
f. Be sure to name the top of each column correctly.
g. Leave a blank column between 2+ Races and Hispanic to indicate that Hispanic should not be added to the total.
h. Highlight the remnants of the columns you cut and delete them.

Last Updated on 8/9/01
By Grace York
Email: graceyor@umich.edu
http://www.lib.umich.edu/govdocs/census2/washars.htm

	All Races	White	Black	Asian	Amerind	Hawaiian	Other	Two+	............	Hispanic
Total:	322,895	249,916	39,697	20,338	1,161	126	3,364	8,293		8,839
Male:	160,558	124,044	19,553	10,374	582	54	1,793	4,158		4,640
Under 5 years	10,340	7,225	1,516	737	30	5	147	680		363
5 to 9 years	10,397	7,494	1,679	518	30	2	142	532		320
10 to 14 years	10,161	7,693	1,498	404	49	2	105	410		267
15 to 17 years	5,729	4,406	849	206	25	6	50	187		168
18 and 19 years	7,891	5,654	1,074	740	36	5	136	246		318
20 years	4,750	3,491	548	475	18	0	72	146		183
21 years	4,486	3,332	453	455	16	1	106	123		182
22 to 24 years	10,182	7,419	1,233	988	44	4	206	288		467
25 to 29 years	14,461	10,409	1,725	1,557	71	5	283	411		652
30 to 34 years	13,498	9,907	1,720	1,346	46	6	180	293		489
35 to 39 years	12,743	9,876	1,539	940	49	6	116	217		373
40 to 44 years	12,351	9,988	1,446	620	42	0	80	175		277
45 to 49 years	11,324	9,451	1,209	406	49	4	59	146		198
50 to 54 years	10,038	8,543	1,018	291	28	1	49	108		148
55 to 59 years	6,873	5,872	678	215	17	4	19	68		88
60 and 61 years	1,991	1,677	203	80	6	0	6	19		26
62 to 64 years	2,504	2,116	251	97	8	1	9	22		32
65 and 66 years	1,429	1,206	129	67	6	1	4	16		18
67 to 69 years	1,997	1,712	181	76	2	1	7	18		18
70 to 74 years	2,961	2,607	230	90	1	0	7	26		23
75 to 79 years	2,267	2,005	197	48	4	0	5	8		9
80 to 84 years	1,285	1,156	101	10	5	0	2	11		14
85 years and over	900	805	76	8	0	0	3	8		7
Female:	162,337	125,872	20,144	9,964	579	72	1,571	4,135		4,199
Under 5 years	9,790	6,730	1,487	665	34	6	162	706		410
5 to 9 years	9,899	6,988	1,687	526	43	3	129	523		322
10 to 14 years	9,469	7,105	1,450	415	38	6	105	350		264
15 to 17 years	5,503	4,098	833	253	29	2	62	226		166
18 and 19 years	8,864	6,380	1,322	749	31	5	121	256		274
20 years	4,753	3,538	596	419	9	1	56	134		164
21 years	4,703	3,475	581	432	15	3	69	128		161
22 to 24 years	9,570	6,920	1,299	855	45	8	164	279		368
25 to 29 years	13,244	9,478	1,646	1,470	72	5	219	354		551
30 to 34 years	12,410	9,199	1,509	1,203	45	9	148	297		416
35 to 39 years	12,560	9,831	1,464	903	49	4	109	200		294
40 to 44 years	12,373	10,058	1,398	599	43	8	71	196		252
45 to 49 years	11,948	9,983	1,338	409	37	5	44	132		175
50 to 54 years	10,150	8,542	1,054	360	34	2	35	123		110
55 to 59 years	6,957	5,919	696	222	20	2	26	72		90
60 and 61 years	2,085	1,779	211	63	5	0	6	21		19
62 to 64 years	2,627	2,242	235	110	7	0	6	27		31
65 and 66 years	1,615	1,360	164	62	1	1	5	22		21
67 to 69 years	2,301	1,989	204	76	8	0	5	19		27
70 to 74 years	3,696	3,194	368	97	3	2	11	21		37
75 to 79 years	3,207	2,867	270	36	3	0	8	23		21
80 to 84 years	2,314	2,094	173	20	7	0	6	14		13
85 years and over	2,299	2,103	159	20	1	0	4	12		13