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 - Urban Areas Population by County

Urban areas are defined by the Census Bureau at the block level, and do not respect political boundaries such as county or place (city) boundaries. Residential population density is one of the main criteria used to define urban areas (http://www.census.gov/geo/www/ua/urbanruralclass.html). Your agency may want to know the proportion of "urban" population for each county in your region. FHWA and AASHTO developed this cheatsheet using Washington, DC - VA - MD Urban Area as an example to assist transportation planners in using the Census Bureau's American Factfinder.If you have any questions,please contact Dr. Liang Long by e-mail at liang.long@dot.gov.

Example 1: I want to get Total Population for Washington, DC - VA - MD Urban Area by County

Census 2010 Summary File 1 Table P1 is the total population table.

1. Open American Factfinder web page. (http://factfinder2.census.gov/faces/nav/jsf/pages/index.xhtml)

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 all geographic types

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.

6. From "Select a geographic type" drop down menu, first find "Urban Area", then select County (or part) - 430.

An image of the AFF Topics menu.  From this page the Next step is selecting the defining geographical scope for the advanced search. This can be conducted, as shown in the image, by first selecting all geographic types and then selecting County (or part) - 430 from the Select a Geographic Type drop down menu in Geographies.

7. Then select Washington, DC--VA--MD from the "Select a urban area" drop down menu. Then select District of Columbia from "Select a state (or part)" drop down menu. Then select all areas in "Select one or more geographic areas" menu and click Add to your selections.

An image of the AFF Topics menu.  From this page the User should then select Washington, DC--VA--MD from the Select a urban area drop down menu, select District of Columbia from Select a state (or part) drop down menu and then select all areas in Select one or more geographic areas menu and click Add to your selections.

8. Then select Maryland from "Select a state (or part)" drop down menu. Then select all areas in "Select one or more geographic areas" menu and click Add to your selections.

An image of the AFF Topics menu.  From this page the User should then select Maryland from Select a state (or part) drop down menu. Then select all areas in Select one or more geographic areas menu and click Add to your selections. Note - Anne Arundel County (Part) and other imply that only a part of the county is classified as to be within Washington, DC - VA - MD Urban Area. Same holds true for all other areas too if identifier (Part) is present after the county name.

Note - Anne Arundel County (Part) and other imply that only a part of the county is classified as to be within Washington, DC - VA - MD Urban Area. Same holds true for all other areas too if identifier "(Part)" is present after the county name.

9. Then select Virginia from "Select a state (or part)" drop down menu. Then select all areas in "Select one or more geographic areas" menu and click Add to your selections.

An image of the AFF Topics menu.  From this page the User should then select Virginia from Select a state (or part) drop down menu. Then select all areas in Select one or more geographic areas menu and click Add to your selections. Note - Fairfax County (Part) and others imply that only a part of the county is classified as to be within Washington, DC - VA - MD Urban Area. Same holds true for all other areas too if identifier (Part) is present after the county name.

Note - Fairfax County (Part) and others imply that only a part of the county is classified as to be within Washington, DC - VA - MD Urban Area. Same holds true for all other areas too if identifier "(Part)" is present after the county name.

10. The results generated as per the search criteria are displayed. Select P1 or go to page 3, (OR, type in P1 in the search within results box and select go) and click View to view the table.

The results generated as per the search criteria are displayed. User should select P1 or go to page 3, (OR, type in P1 in the search within results box and select go) and click View to view the table.

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

 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.

12. Once all the modifications are complete, select option for Download. You can choose a comma-delimited .csv; .xls, or .pdf. American FactFinder2 will build your table and then click Download. Save the file to your computer.

Once all the modifications are complete, select option for Download. You can choose a comma-delimited .csv; .xls, or .pdf. American FactFinder2 will build your table and then click Download. Save the file to your computer.

Once all the modifications are complete, select option for Download. You can choose a comma-delimited .csv; .xls, or .pdf. American FactFinder2 will build your table and then click Download. Save the file to your computer.

Once all the modifications are complete, select option for Download. You can choose a comma-delimited .csv; .xls, or .pdf. American FactFinder2 will build your table and then click Download. Save the file to your computer.

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