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 Self Tutorial

Notes on AMERICAN FACTFINDER 2: http://factfinder2.census.gov courtesy of Linda Clark, US Census Bureau and modified by Elaine Murakami, FHWA (August 18, 2011) for Summary File 1

Example 1: I want to get P28 data for all the Tracts in Galveston County, Texas

Table P28 is Household type and Household Size (16 cells)

1. 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

2. 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.

3. 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.

4. Expand Dataset by clicking on the "+" sign. Select 2010 SF1 100% Data by clicking on it.

An image of the AFF Topics menu.  From this page a user should select 2010 SF1 100% Data which refers to 2010 US Census data. AFF has multiple and multi-year databases and users can select appropriate database to meet their search criteria. 2010 SF1 100% Data should be used in this particular example.<

5. Open Geographies in left navigation bar and select Census Tract from the "Select a geographic type" drop down menu

An image of the AFF Topics menu.  From this page the Next step is defining geographical scope for the advanced search. This can be conducted, as shown in the image, by first selecting all geographic types and select Census Tract from the Select a geographic type” drop down menu

6. Select Texas and Galveston from the respective drop down menus. Select All Census Tracts within Galveston County, Texas and click on Add to your selections.

6. To further refine the results and to match the geographical search criteria, user should select Texas as state, Galveston as County and then select option All Census Tracts within Galveston county, Texas. Upon adding Datasets (step 3) and Geographical Scope (step 4-6), the search results table is populated.

7. The results generated as per the search criteria are displayed. Select P28 or go to page 6, (OR, type in P28 in the search within results box and select go) and select Household Type by Household Size table and click View to view the table.

 For the final step in defining the geographical scope of the advanced search, user should first check the radio button Groups of geographies below the Geography Filter Options. Then in the Geography Results pane, select All Blocks within Multnomah County, Oregon. Then click Add (to move this selection up into Your Selections box)

8. To make modifications, click on Modify Table option on the screen. Modifications like transposing rows/columns and omitting fields can be performed to attain the desired results.

A screen image that allows the user To make modifications, by clicking on Modify Table option on the screen. Modifications like transposing rows/columns and omitting fields can be performed to attain the desired results. 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.

9. Once all the modifications are complete, select option for Download. You can choose a comma-delimited .csv; .xls, or .pdf. Save the file to your computer.

A screenshot image. 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.Select "Download" Click "OK"

Example 2: I want the H12 table for all the census blocks in Multnomah County, OR.

(H12 table is Average Household size by Tenure)

1. Follow steps 1 to 4 from Example 1, if starting Example 2 afresh. Else clear up all “Your Selections” and start a new searh(upper left corner of page). This illustration continues after Example 1.

1. Follow steps 1 to 4 from Example 1,

if starting Example 2 afresh.

Else clear up all "Your Selections"

and start a new searh(upper left corner of page). This

illustration continues after Example 1.

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

Clearing all previous selections resets the Advanced Search window. In this step user is asked to click Topics button in order to access its menu.

3. Expand Dataset by clicking on the "+" sign. Select 2010 SF1 100% Data by clicking on it.

From the Topics menu, select 2010 SF1 100% Data which refers to 2010 US Census data. AFF has multiple and multi-year databases and users can select appropriate database to meet their search criteria. 2010 SF1 100% Data should be used in this particular example.

4. Open Geographies in left navigation bar and select Name tab. Minimize the Geographic Type filter by clicking on the "-" sign.

Next step is selecting the appropriate geographical scope for the advanced search. This can be conducted, as shown in the images 4-7, by first selecting Name tab from Geographies menu, and selecting - sign to minimize the Geographic Type menu.

5. Expand Within State by clicking on the "+" sign. Scroll down the list and click on Oregon (from the choices immediately underneath, not from the Geography Results pane).

User should expand Within State menu by clicking on the + sign. Scroll down the list and click on Oregon (from the choices immediately underneath, not from the Geography Results pane).

6. Expand Within County by clicking on the "+" sign. Scroll down the list and click on Multnomah (from the choices immediately underneath, not from the Geography Results pane).

After selecting Oregon, user is asked to expand Within County menu by clicking on the + sign. Scroll down the list and click on Multnomah (from the choices immediately underneath, not from the Geography Results pane).

7. Check the radio button "Groups of geographies" below the Geography Filter Options. In the Geography Results pane, select "All Blocks within Multnomah County, Oregon". Then click Add (to move this selection up into Your Selections box)

IMPORTANT:

If you don't click "Add", Blocks won't be selected.

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

7. Check the radio button “Groups of geographies” below the Geography Filter Options. In the Geography Results pane, select “All Blocks within Multnomah County, Oregon”. Then click Add (to move this selection up into Your Selections box) IMPORTANT: If you don’t click “Add”, Blocks won’t be selected. Close Geographies by clicking on "X" in upper right of Select Geographies frame) TIP: Never close the geography overlay (or the population groups overlay or the industry code overlay) until you make sure your final choice has been moved to the "Your Selections" box. Once you close any of the overlays, your selections in the overlay are erased.

TIP: Never close the geography overlay (or the population groups overlay or the industry code overlay) until you make sure your final choice has been moved to the "Your Selections" box.

Once you close any of the overlays, your selections in the overlay are erased.

8. Look at the table list and put a check in checkbox next to H12 (OR, type in "H12" in the search within results box and select "go")

Then select "View" (if there are a lot of blocks, you will not be able to view it online. So instead, go to download). In the Action list, you can select "Download" the file, and select the file format you want (refer to steps 8 and 9 in Example 1 to review the procedure).

8. Look at the table list and put a check in checkbox next to H12 (OR, type in “H12” in the search within results box and select “go”) Then select “View” (if there are a lot of blocks, you will not be able to view it online. So instead, go to download). In the Action list, you can select “Download” the file, and select the file format you want (refer to steps 8 and 9 in Example 1 to review the procedure).

Example 3: I want to get percent of persons at or below the poverty level for all the Tracts in Galveston County, Texas

1. Follow steps 1 to 3 from Example 1, if starting Example 3 afresh. Else clear up all “Your Selections” and start a new searh(upper left corner of page). This illustration continues after Example 2.

1. Follow steps 1 to 3 from Example 1,

if starting Example 3 afresh.

Else clear up all "Your Selections"

and start a new searh(upper left corner of page). This

illustration continues after Example 2.

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

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

3. Expand Dataset by clicking on the "+" sign. Select 2010 ACS 5-year estimates by clicking on it.

3. Expand Dataset by clicking on the “+” sign. Select 2010 ACS 5-year estimates by clicking on it.

4. Open Geographies in left navigation bar and select List tab.

4. Open Geographies in left navigation bar and select List tab.

5. Select Census Tract from the "Select a geographic type" drop down menu. Select Texas from the "Select a state" drop down menu. Select Galveston from "Select a county" drop down menu. Select All Census Tracts within Galveston County, Texas from "Select one or more geographic areas" list.

5. Select Census Tract from the “Select a geographic type” drop down menu. Select Texas from the “Select a state” drop down menu. Select Galveston from “Select a county” drop down menu. Select All Census Tracts within Galveston County, Texas from “Select one or more geographic areas” list.

6. Type B17001 in the search box and select B17001: Poverty status in the past 12 months by sex and by age. Then click on GO.

6. Type B17001 in the search box and select B17001: Poverty status in the past 12 months by sex and by age. Then click on GO.

7. 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".

7. 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”. Percent of persons at or below the poverty level can be derived by dividing persons below poverty level by total population. For the first row in the following table, Census Tract 7201, Percent of persons at or below the poverty level is 137/5690=2.4% For downloading you can choose a comma-delimited .csv; .xls, or .pdf. Save the .zip file to your computer, and then unzip it (refer to steps 8 and 9 in Example 1 for to review the procedure).

Percent of persons at or below the poverty level can be derived by dividing persons below poverty level by total population. For the first row in the following table, Census Tract 7201, Percent of persons at or below the poverty level is 137/5690=2.4%

For downloading you can choose a comma-delimited .csv; .xls, or .pdf. Save the .zip file to your computer, and then unzip it (refer to steps 8 and 9 in Example 1 for to review the procedure).

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