Census 2000 Gateway | Glossary |
MCD/County-To-MCD/County Worker Flow Files |
These files were compiled from Census 2000 responses to the long-form (sample) questions on where people worked. The files present data at the county subdivision or minor civil division (MCD) level for residents of 12 states: Connecticut, Maine, Massachusetts, Michigan, Minnesota, New Hampshire, New Jersey, New York, Pennsylvania, Rhode Island, Vermont, and Wisconsin. The MCDs in these states serve as general-purpose local governments and perform many governmental functions. For the other 38 states and the District of Columbia (DC) data are presented at the county level. Data are also provided in this release for Puerto Rico, where the county equivalent is the municipio.
A set of files similar to those listed below, but containing county-level data for all 50 states and DC may be found at http://www.census.gov/population/www/cen2000/commuting/. The main journey to work and place of work subject matter page may be found at http://www.census.gov/population/www/socdemo/journey.html.
For any state, or for the entire nation, there are a number of files to choose from, depending on the sort order and format you may find most useful.
The sort order refers to whether the MCD/county of residence or the MCD/county of work is the main focus. If you are interested in the number of people who live in an MCD/county, and want to know where they work, you should download one of the files sorted by MCD/county of residence. These files will show you all the work destinations for people who live in each MCD/county.
On the other hand, if you are interested in the people who work in an MCD/county, and want to know where they come from, download one of the files sorted by MCD/county of work. These files will show you all the origins for people who work in each MCD/county.
The files have been created in two formats: plain text and Excel spreadsheet format. The Excel files and the uncompressed plain text files are directly viewable. To look at the data on your screen, click on the underlined link "Excel" or "Uncompressed" for the format, state, and sort order you want. For six states the data in Excel format are available either for the entire state, or in separate files that have been split alphabetically by county name. MI, MN, NJ, NY, and WI were split into two files, while PA was divided into three pieces. To download an Excel or uncompressed plain text file, hold down the shift key and click on the underlined link.
The compressed plain text files are not viewable; they have been zipped for faster downloading. To download one of the files simply click on the underlined link "Compressed" for the state and sort order you want. For information on using PKZIP/PKUNZIP see our PKZIP information page.
The documentation for the files is available below. To view the file, just click on the underlined link "record layout" and the file will be displayed on the screen. You can then print the page from your browser. To download the record layout, hold down the shift key and click on the underlined link.
Note: In reviewing the Census 2000 MCD/County-to-MCD/County Worker Flow Files before release, some errors were discovered in a number of the MCD/county-to-MCD/county flows. These errors have been corrected. However, as a result of the corrections the data in these files may not agree with data previously released in Summary File 3 (SF3) and related products. In particular, there may be differences in the number of people working in the state and/or MCD/county of residence between SF3 and similar estimates derived from these files.
Click on one of the state abbreviations below to go directly to that area of the list of files.
US | AL | AK | AZ | AR | CA | CO | CT | DE | DC | FL | GA | HI |
ID | IL | IN | IA | KS | KY | LA | ME | MD | MA | MI | MN | MS |
MO | MT | NE | NV | NH | NJ | NM | NY | NC | ND | OH | OK | OR |
PA | RI | SC | SD | TN | TX | UT | VT | VA | WA | WV | WI | WY |
PR |
Area | Sort Order | File Format | |
---|---|---|---|
United States | Residence MCD/County | Plain text Compressed (7.5M) | Uncompressed (100.9M) |
|
Work MCD/County | Plain text Compressed (8.5M) | Uncompressed (100.9M) |
||
Alabama | Residence County | Excel (846k) | Plain text Compressed (48k) | Uncompressed (571k) |
Work County | Excel (689k) | Plain text Compressed (38k) | Uncompressed (459k) |
|
Alaska | Residence County | Excel (111k) | Plain text Compressed (5k) | Uncompressed (64k) |
Work County | Excel (199k) | Plain text Compressed (11k) | Uncompressed (120k) |
|
Arizona | Residence County | Excel (284k) | Plain text Compressed (19k) | Uncompressed (175k) |
Work County | Excel (319k) | Plain text Compressed (22k) | Uncompressed (195k) |
|
Arkansas | Residence County | Excel (723k) | Plain text Compressed (39k) | Uncompressed (486k) |
Work County | Excel (693k) | Plain text Compressed (37k) | Uncompressed (462k) |
|
California | Residence County | Excel (1.1M) | Plain text Compressed (71k) | Uncompressed (745k) |
Work County | Excel (1.2M) | Plain text Compressed (85k) | Uncompressed (813k) |
|
Colorado | Residence County | Excel (593k) | Plain text Compressed (35k) | Uncompressed (394k) |
Work County | Excel (602k) | Plain text Compressed (37k) | Uncompressed (392k) |
|
Connecticut | Residence MCD | Excel (3.0M) | Plain text Compressed (141k) | Uncompressed (2.0M) |
Work MCD | Excel (3.2M) | Plain text Compressed (169k) | Uncompressed (2.1M) |
|
Delaware | Residence County | Excel (184k) | Plain text Compressed (13k) | Uncompressed (101k) |
Work County | Excel (205k) | Plain text Compressed (14k) | Uncompressed (111k) |
|
District of Columbia | Residence County | Excel (70k) | Plain text Compressed (4k) | Uncompressed (33k) |
Work County | Excel (204k) | Plain text Compressed (14k) | Uncompressed (112k) |
|
Florida | Residence County | Excel (1.3M) | Plain text Compressed (95k) | Uncompressed (904k) |
Work County | Excel (1.2M) | Plain text Compressed (88k) | Uncompressed (808k) |
|
Georgia | Residence County | Excel (1.7M) | Plain text Compressed (96k) | Uncompressed (1.1M) |
Work County | Excel (1.7M) | Plain text Compressed (103k) | Uncompressed (1.2M) |
|
Hawaii | Residence County | Excel (69k) | Plain text Compressed (4k) | Uncompressed (33k) |
Work County | Excel (82k) | Plain text Compressed (5k) | Uncompressed (40k) |
|
Idaho | Residence County | Excel (303k) | Plain text Compressed (16k) | Uncompressed (195k) |
Work County | Excel (215k) | Plain text Compressed (10k) | Uncompressed (135k) |
|
Illinois | Residence County | Excel (1.4M) | Plain text Compressed (89k) | Uncompressed (964k) |
Work County | Excel (1.7M) | Plain text Compressed (110k) | Uncompressed (1.1M) |
|
Indiana | Residence County | Excel (1.0M) | Plain text Compressed (59k) | Uncompressed (694k) |
Work County | Excel (1.2M) | Plain text Compressed (75k) | Uncompressed (805k) |
|
Iowa | Residence County | Excel (888k) | Plain text Compressed (50k) | Uncompressed (596k) |
Work County | Excel (945k) | Plain text Compressed (55k) | Uncompressed (625k) |
|
Kansas | Residence County | Excel (701k) | Plain text Compressed (36k) | Uncompressed (473k) |
Work County | Excel (747k) | Plain text Compressed (40k) | Uncompressed (501k) |
|
Kentucky | Residence County | Excel (1.1M) | Plain text Compressed (61k) | Uncompressed (760k) |
Work County | Excel (1.0M) | Plain text Compressed (60k) | Uncompressed (705k) |
|
Louisiana | Residence County | Excel (813k) | Plain text Compressed (45k) | Uncompressed (551k) |
Work County | Excel (800k) | Plain text Compressed (44k) | Uncompressed (536k) |
|
Maine | Residence MCD | Excel (3.5M) | Plain text Compressed (154k) | Uncompressed (2.3M) |
Work MCD | Excel (3.2M) | Plain text Compressed (144k) | Uncompressed (2.1M) |
|
Maryland | Residence County | Excel (623k) | Plain text Compressed (44k) | Uncompressed (399k) |
Work County | Excel (813k) | Plain text Compressed (62k) | Uncompressed (517k) |
|
Massachusetts | Residence MCD | Excel (6.4M) | Plain text Compressed (308k) | Uncompressed (4.3M) |
Work MCD | Excel (7.1M) | Plain text Compressed (407k) | Uncompressed (4.8M) |
|
Michigan | Residence MCD | Entire State Excel (16.1M) |
Plain text - Entire State Compressed (737k) | Uncompressed (10.9M) |
County Names A - L Excel (7.9M) |
|||
County Names M - Z Excel (8.3M) |
|||
Work MCD | Entire State Excel (15.9M) |
Plain text - Entire State Compressed (845k) | Uncompressed (10.8M) |
|
County Names A - L Excel (7.9M) |
|||
County Names M - Z Excel (8.3M) |
|||
Minnesota | Residence MCD | Entire State Excel (14.2M) |
Plain text - Entire State Compressed (648k) | Uncompressed (9.6M) |
County Names A - L Excel (6.9M) |
|||
County Names M - Z Excel (7.5M) |
|||
Work MCD | Entire State Excel (14.7M) |
Plain text - Entire State Compressed (839k) | Uncompressed (8.9M) |
|
County Names A - L Excel (6.9M) |
|||
County Names M - Z Excel (7.5M) |
|||
Mississippi | Residence County | Excel (799k) | Plain text Compressed (41k) | Uncompressed (542k) |
Work County | Excel (675k) | Plain text Compressed (34k) | Uncompressed (453k) |
|
Missouri | Residence County | Excel (1.3M) | Plain text Compressed (70k) | Uncompressed (857k) |
Work County | Excel (1.2M) | Plain text Compressed (70k) | Uncompressed (805k) |
|
Montana | Residence County | Excel (346k) | Plain text Compressed (18k) | Uncompressed (224k) |
Work County | Excel (252k) | Plain text Compressed (12k) | Uncompressed (160k) |
|
Nebraska | Residence County | Excel (561k) | Plain text Compressed (27k) | Uncompressed (375k) |
Work County | Excel (651k) | Plain text Compressed (36k) | Uncompressed (431k) |
|
Nevada | Residence County | Excel (155k) | Plain text Compressed (9k) | Uncompressed (90k) |
Work County | Excel (190k) | Plain text Compressed (12k) | Uncompressed (112k) |
|
New Hampshire | Residence MCD | Excel (2.8M) | Plain text Compressed (133k) | Uncompressed (1.9M) |
Work MCD | Excel (2.4M) | Plain text Compressed (114k) | Uncompressed (1.6M) |
|
New Jersey | Residence MCD | Entire State Excel (13.8M) |
Plain text - Entire State Compressed (715k) | Uncompressed (9.3M) |
County Names A - L Excel (6.5M) |
|||
County Names M - Z Excel (7.3M) |
|||
Work MCD | Entire State Excel (14.7M) |
Plain text - Entire State Compressed (938k) | Uncompressed (9.9M) |
|
County Names A - L Excel (6.5M) |
|||
County Names M - Z Excel (7.3M) |
|||
New Mexico | Residence County | Excel (273k) | Plain text Compressed (14k) | Uncompressed (174k) |
Work County | Excel (255k) | Plain text Compressed (14k) | Uncompressed (160k) |
|
New York | Residence MCD | Entire State Excel (11.3M) |
Plain text - Entire State Compressed (590k) | Uncompressed (7.6M) |
County Names A - N Excel (5.7M) |
|||
County Names O - Z Excel (5.8M) |
|||
Work MCD | Entire State Excel (11.5M) |
Plain text - Entire State Compressed (656k) | Uncompressed (7.7M) |
|
County Names A - N Excel (5.7M) |
|||
County Names O - Z Excel (5.8M) |
|||
North Carolina | Residence County | Excel (1.4M) | Plain text Compressed (83k) | Uncompressed (937k) |
Work County | Excel (1.3M) | Plain text Compressed (77k) | Uncompressed (869k) |
|
North Dakota | Residence County | Excel (322k) | Plain text Compressed (17k) | Uncompressed (204k) |
Work County | Excel (396k) | Plain text Compressed (23k) | Uncompressed (247k) |
|
Ohio | Residence County | Excel (1.5M) | Plain text Compressed (99k) | Uncompressed (1.0M) |
Work County | Excel (1.7M) | Plain text Compressed (114k) | Uncompressed (1.1M) |
|
Oklahoma | Residence County | Excel (921k) | Plain text Compressed (51k) | Uncompressed (625k) |
Work County | Excel (695k) | Plain text Compressed (36k) | Uncompressed (464k) |
|
Oregon | Residence County | Excel (369k) | Plain text Compressed (20k) | Uncompressed (241k) |
Work County | Excel (307k) | Plain text Compressed (16k) | Uncompressed (196k) |
|
Pennsylvania | Residence MCD | Entire State Excel (31.3M) |
Plain text - Entire State Compressed (1.5M) | Uncompressed (21.2M) |
County Names A - CH Excel (10.6M) |
|||
County Names CL - L Excel (10.2M) |
|||
County Names M - Z Excel (10.7M) |
|||
Work MCD | Entire State Excel (29.8M) |
Plain text - Entire State Compressed (1.6M) | Uncompressed (20.2M) |
|
County Names A - CH Excel (10.6M) |
|||
County Names CL - L Excel (10.2M) |
|||
County Names M - Z Excel (10.7M) |
|||
Rhode Island | Residence MCD | Excel (784k) | Plain text Compressed (38k) | Uncompressed (507k) |
Work MCD | Excel (632k) | Plain text Compressed (33k) | Uncompressed (401k) |
|
South Carolina | Residence County | Excel (650k) | Plain text Compressed (37k) | Uncompressed (432k) |
Work County | Excel (607k) | Plain text Compressed (35k) | Uncompressed (399k) |
|
South Dakota | Residence County | Excel (365k) | Plain text Compressed (19k) | Uncompressed (235k) |
Work County | Excel (370k) | Plain text Compressed (20k) | Uncompressed (235k) |
|
Tennessee | Residence County | Excel (1.0M) | Plain text Compressed (62k) | Uncompressed (703k) |
Work County | Excel (1.0M) | Plain text Compressed (63k) | Uncompressed (700k) |
|
Texas | Residence County | Excel (2.7M) | Plain text Compressed (174k) | Uncompressed (1.9M) |
Work County | Excel (2.6M) | Plain text Compressed (163k) | Uncompressed (1.8M) |
|
Utah | Residence County | Excel (282k) | Plain text Compressed (16k) | Uncompressed (179k) |
Work County | Excel (267k) | Plain text Compressed (15k) | Uncompressed (166k) |
|
Vermont | Residence MCD | Excel (1.9M) | Plain text Compressed (86k) | Uncompressed (1.3M) |
Work MCD | Excel (1.7M) | Plain text Compressed (74k) | Uncompressed (1.1M) |
|
Virginia | Residence County | Excel (1.5M) | Plain text Compressed (93k) | Uncompressed (1.1M) |
Work County | Excel (1.6M) | Plain text Compressed (105k) | Uncompressed (1.1M) |
|
Washington | Residence County | Excel (484k) | Plain text Compressed (29k) | Uncompressed (320k) |
Work County | Excel (417k) | Plain text Compressed (24k) | Uncompressed (268k) |
|
West Virginia | Residence County | Excel (706k) | Plain text Compressed (43k) | Uncompressed (463k) |
Work County | Excel (486k) | Plain text Compressed (27k) | Uncompressed (314k) |
|
Wisconsin | Residence MCD | Entire State Excel (14.8M) |
Plain text - Entire State Compressed (653k) | Uncompressed (10.0M) |
County Names A - L Excel (6.7M) |
|||
County Names M - Z Excel (8.2M) |
|||
Work MCD | Entire State Excel (14.2M) |
Plain text - Entire State Compressed (714k) | Uncompressed (9.5M) |
|
County Names A - L Excel (6.7M) |
|||
County Names M - Z Excel (8.2M) |
|||
Wyoming | Residence County | Excel (190k) | Plain text Compressed (10k) | Uncompressed (116k) |
Work County | Excel (187k) | Plain text Compressed (10k) | Uncompressed (114k) |
|
Puerto Rico | Residence Municipio | Excel (531k) | Plain text Compressed (20k) | Uncompressed (359k) |
Work Municipio | Excel (548k) | Plain text Compressed (21k) | Uncompressed (369k) |