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.

1. Open American Factfinder web page.

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

2. Select “Advanced Search” option. 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.

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

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

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

5. Open Geographies in left navigation bar 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. 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.

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.

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.

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.

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

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.

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

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

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

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

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

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

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

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

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

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

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: 2/11/2015
HEP Home Planning Environment Real Estate
Federal Highway Administration | 1200 New Jersey Avenue, SE | Washington, DC 20590 | 202-366-4000