Skip to content U.S. Department of Transportation/Federal Highway AdministrationU.S. Department of Transportation/Federal Highway Administration

Office of Planning, Environment, & Realty (HEP)
Planning · Environment · Real Estate

HEP Events Guidance Publications Glossary Awards Contacts

American FactFinder 2 Equal Employment Opportunity (EEO) Self Tutorial

Access Equal Employment Opportunity Tabulation

2006-2010 County to County Flows

This document was prepared by the Federal Highway Administration (FHWA) (January 24, 2013) with help from Melissa Chiu at the U.S. Census Bureau. If you have any questions, please contact Dr. Liang Long by e-mail at liang.long@dot.gov.

Example 1: I want to get work flows to Montgomery County, MD

EEO tabulations have information on workplace flows, where you select workplace locations and find all flows into them. Workplace flows are included in tables EEO 1w through EEO 7w.

For Montgomery County, MD, a total of nine residence counties has been listed as separate and all remaining counties are aggregated as All Other Counties:

  1. Washington, District of Columbia
  2. Anne Arundel County, MD
  3. Carroll County, MD
  4. Frederick County, MD
  5. Howard County, MD
  6. Montgomery County, MD
  7. Prince George's County, MD
  8. Arlington County, VA
  9. Fairfax County, VA
  10. All Other Counties

This particular example focuses on using Table EEO 1W: Detailed Census Occupation by Sex and Race/Ethnicity for Worksite Geography Universe: Civilians employed at work 16 years. This table has the flows by gender and race.

The steps to extract this information from AFF2:

Open American Factfinder web page.

An image of the Open American Factfinder website's Title page. This page can be found at the following URL. http://factfinder2.census.gov/faces/nav/jsf/pages/index.xhtml

Select "Advanced Search" option. Then click on "Show me all". This will take you to main Advanced Search window.

An image of the AFF homepage.  From here a user can select the Advanced Search option to go to the Advanced Search window (required selections are shown in the image).  Then click on Show me all. This will take you to main Advanced Search window.

Open Topics in left navigation bar by clicking right facing arrow head.

An image of the AFF Advanced Search window. Once in the Advanced Search window, users can choose from a variety of options to match their search criteria. In this step user is asked to click Topics button in order to access its menu. Open Topics in left navigation bar by clicking right facing arrow head.

From the Topics menu, user should select EEO Tabulation 2006-2010 (5-year ACS data). AFF has multiple and multi-year databases and users can select appropriate database to meet their search criteria. EEO Tabulation 2006-2010 (5-year ACS data) should be used in this particular example. Expand Dataset by clicking on the + sign. Select EEO Tabulation 2006-2010 (5-year ACS data) by clicking on it.

Expand Dataset by clicking on the "+" sign.

Select "EEO Tabulation 2006-2010 (5-year ACS data)" by clicking on it.

Open Geographies in left navigation bar.

Open Geographies in left navigation bar.

Next step is defining geographical scope for the advanced search. This can be conducted, as shown in the image, by selecting County - 050 option from Geographies menu.

The Geography selection pane will open in the middle of your screen.

Click Drop down arrow and click County.

Select Maryland as state and then select Montgomery County, Maryland.

CLICK "Add to your Selection" (to move this selection up into Your Selections box) IMPORTANT! If you don't click "Add to your Selection", County won't be selected.

To further refine the results and to match the geographical search criteria, user should select Maryland as state, Montgomery County as County. Upon adding Datasets and Geographical Scope, the search results table is populated.

Close Geographies by clicking on "X" in upper right of Select Geographies frame)

Then, Select Table EEO 1w in the table list and then select "view". (or, type in "EEO 1w" in the search within results box and select "go") You will see a screen similar to below. As you scroll down, you will see other counties.

The results generated as per the search criteria are displayed. User should select Table EEO 1w and click View to view the table.

Once you see the table, if you prefer to see the geographic units as rows, then select Actions: "Modify Table", then select "Transpose Rows and Columns". Another choice in the list of Actions is "Download". You can choose a comma-delimited .csv; .xls, or .pdf. Save the .zip file to your computer, and then unzip it.

To make modifications, user can click on Modify Table option on the screen. Modifications like transposing rows/columns and omitting fields can be performed to attain the desired format of the results tabulation. Once all the modifications are complete, user selects option for Download. Users can choose a comma-delimited .csv; .xls, or .pdf and save the file to the computer.


[i] Census Bureau: http://www.census.gov/people/eeotabulation/about/faq5year.html

Updated: 04/16/2013
HEP Home Planning Environment Real Estate
Federal Highway Administration | 1200 New Jersey Avenue, SE | Washington, DC 20590 | 202-366-4000