Using the Advanced Search feature of American FactFinder

1. Using the Advanced Search feature of American FactFinder Jodie Meyer Research Analyst Kermit Spade Research Analyst http://factfinder2.census.gov 12/12/2013

2. American FactFinder homepage: From Census hompage, click Data, then American FactFinder.

3. American FactFinder homepage: From Census hompage, click Data, then American FactFinder. There are two options to access the advanced search function.

4. American FactFinder homepage: From Census hompage, click Data, then American FactFinder. There are two options to access the advanced search function. Both options will take you to the advanced search page.

5. American FactFinder advanced search page:

6. American FactFinder advanced search page: There are 5 “tabs” on the left-hand side of the page. Clicking on a tab will open a pop-up window with search options.

7. Start with the Geographies tab, and choose the areas for which you want data.

8. Alternatively, you can use the map tool to choose geographies.

9. Alternatively, you can use the map tool to choose geographies. Once geographies are selected, close the geographies pop-up window.

10. Results will display every table available for the selected geographies. There are many ways to refine the results.

11. You can refine your results by using the tabs on the left

12. You can refine your results by using the tabs on the left, or the search box above the results.

13. You can refine your results by using the tabs on the left, or the search box above the results. Or you can choose a table displayed in results list. How do you know which one to choose?

14. There are many different table types in the American FactFinder. Some of the more popular tables are: Data Profile tables (DP) (also known as Demographic Profiles) Provide broad social, economic, housing, and demographic profiles. Subject Tables (S) Similar to data profiles but include more detailed ACSdata, classified by subject. Narrative Profile table (NP) Summarize the information in the data profiles using concise, nontechnical text. American Fact Finder table types http://www.census.gov/acs/www/data_documentation/product_descriptions/ http://factfinder2.census.gov/help/en/tables/tables_overview.htm

15. Once a table is chosen, the view option will become available. Click the view button to see the data contained in the table.

16. Use the download option to save the table in a more useful format.

17. The download pop-up window provides several options for saving your table.

18. The download pop-up window provides several options for saving your table. • .csv format • Useful for importing into excel or an access database for further analysis.

19. The download pop-up window provides several options for saving your table. • .csv format • Useful for importing into excel or an access database for further analysis. • Make sure to include the descriptive data element names.

20. The download pop-up window provides several options for saving your table. • .csv format • Useful for importing into excel or an access database for further analysis. • Make sure to include the descriptive data element names. • Presentation ready format • Useful as a stand alone product • Available in 3 formats • .xls (Excel) • .pdf (Acrobat) • .rtf (Word)

21. The Narrative Profile: Summarizes the information in the data profiles using concise, nontechnical text.

22. Narrative Profiles contain information on several topics, including: • Households and Families • Nativity and Foreign Born • Language • Geographic Mobility • Education • Disability • Employment Status • Industries • Occupations • Commuting to Work • Income • Poverty and Government Programs • Health Insurance • Population • Housing and Occupied Housing Characteristics and Housing Costs

23. Narrative Profiles contain information on several topics, including: • Households and Families • Nativity and Foreign Born • Language • Geographic Mobility • Education • Disability • Employment Status • Industries • Occupations • Commuting to Work • Income • Poverty and Government Programs • Health Insurance • Population • Housing and Occupied Housing Characteristics and Housing Costs • The Narrative Profile can be downloaded in .pdf or .rtf formats.

24. Narrative Profiles contain information on several topics, including: • Households and Families • Nativity and Foreign Born • Language • Geographic Mobility • Education • Disability • Employment Status • Industries • Occupations • Commuting to Work • Income • Poverty and Government Programs • Health Insurance • Population • Housing and Occupied Housing Characteristics and Housing Costs • The Narrative Profile can be downloaded in .pdf or .rtf formats. • If more than one geography is selected, • it can be changed here.

25. Equal Employment Opportunity Tabulation The EEO Tabulation is a custom tabulation of data from the American Community Survey. It serves as the primary external benchmark for comparing the race, ethnicity, and sex composition of an organization's internal workforce, to the analogous external labor market, within a specified geography and occupation. The Census Bureau produces the EEO Tabulation 2006-2010 (5-year ACS data) for Federal agencies responsible for monitoring employment practices and enforcing civil rights laws in the workforce, and for all employers so they can measure their compliance with the laws. To find the EEO tabulations, after choosing a geography: Topics…Program…EEO Tabulation This will display all EEO Tabulation tables available for the selected geography.