• American Community Survey
• Census Transportation Planning Products (CTPP)
  • Data Products
  • Training
  • Articles
  • CTPP Status Report
  • FAQ
  • Contacts
  • Related Links
  • Archives
• Environmental Justice
• Longitudinal Employment and Household Dynamics (LEHD)
• Census Urbanized Areas and MPO/TMA Designation
• Standard Decennial Census Products
• Archives

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.

• Geographic level:
  • Currently county and place flows are available in AFF.
  • EEO does not provide residence flows, where you select residence locations and find all flows out.
• Limitation on number of flows reported:
  • For county flows, a maximum of 9 separate residence counties are reported, and commuting flows from all remaining counties are aggregated as "All Other Counties." The consortium of four Federal agencies (Equal Employment Opportunity Commission (EEOC), the Department of Justice (DOJ), the Office of Federal Contract Compliance Programs (OFCCP) at the Department of Labor (DOL) and the Office of Personnel Management (OPM)) who requested EEO tabulations only need the top flows resulting in the cap of 9 individual county reporting.
  • Additional suppression rules: depending on the table contents, there is either a 50,000 or 100,000 residence population threshold. Population thresholds are always based on the residence population, even for tabulations at worksite geography. Additionally, there must be at least 50 unweighted cases per residence-to-worksite commuter flows.[i]

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.

Select "Advanced Search" option. 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.

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.

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.

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.

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.

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