PaSDC : The Commonwealth’s Official Source for Population and Socioeconomic Statistics

1. Class Overview: Intro to the Pennsylvania State Data Center Decennial Census The American Community Survey Population Estimates Program Extract and download data from American FactFinder PaSDC: The Commonwealth’s Official Source for Population and Socioeconomic Statistics

2. The PaSDC • Established in 1981 by Executive Order of the Governor • We are the Commonwealth’s Official Source for Population and Socio-Economic Statistics • Located at Penn State Harrisburg within the Institute of State and Regional Affairs (Church Hall) • We are a cost recovery operation PaSDC: The Commonwealth’s Official Source for Population and Socioeconomic Statistics

3. The Decennial Census • The census is a count of everyone living in the United States every 10 years. • Taken every 10 years since 1790. • Mandated by the U.S. Constitution and participation is required by law. Mission: Count everyone once, only once, and in the right place

4. Census Data are used to: • Distribute Congressional seats to states and determine state legislative boundaries • Make decisions at every level of government • Distribute $400 billion in federal funds to communities each year

5. Census 2010 • Census 2010 was short-form ONLY. • Shortest Census questionnaire in modern history. • Takes less than 10 minutes to complete. • American Community Survey • Now the premier source for Socio-economic data

6. American Community Survey • A large, continuous demographic survey • Produces annual and multi-year estimates of the characteristics of the population and housing • Produces characteristics,nota population count • Produces information for small areas including tracts, block groups and population subgroups - updated every year • Key component of re-engineered 2010 census

7. American Community SurveyHow Does it Work? • The American Community Survey uses moving averages to collect data for small areas: • Continuous surveying, ‘rolled up’ into one-year, three-year or five-year averages (multi-year estimates). • For example: Averages for 2007-2011 include results collected in 2007, 2008, 2009, 2010 and 2011. • January 1, 2007– December 31, 2011

8. What is a Survey? A survey uses data gathered from a sample of the target population to represent the rest of the population. • Survey-based datasets usually include much more detail.

9. American FactFinder The U.S. Census Bureau’s Online Data Dissemination Tool Link from www.census.gov Or, go directly to factfinder2.census.gov

10. The American FactFinder Sources of Data in FactFinder: Decennial Census American Community Survey Population Estimates Program Economic Census Annual Economic Surveys

11. The American FactFinder Archived Datasets: • 1990 Census • 2000-2004 American Community Survey • 2000-2001 Supplementary Survey • 1997 Economic Census • 2003 Annual Survey of Manufactures • 2003 Nonemployer Statistics

12. The American FactFinder Archive Business Rules: • Decennial Census and Economic Census • Retain and display the current and 1 prior • Ex. Census 2010 and Census 2000 • Econ 2007 and Econ 2000 • Annual Surveys • Retain and display the current and 4 prior (*5 for ACS) • Ex. ACS: 2010, 2009-2005 • County Business Patters: 2009, 2008-2005

13. The New American FactFinder New Interface is fundamentally different from Legacy AFF • Main/Search Pages are main interface of New FactFinder • Old Step-by-Step process replaced by a variety of search mechanisms • FACTSHEETS are NOT available; Demographic Profiles located at top of search

14. New FactFinder vs. Legacy New FactFinder Legacy FactFinder Linear – Step by Step – process to extracting data Searches require further knowledge of census bureau datasets Factsheets available on main page for quick access to community profiles • Numerous search mechanisms to get to the same data • Data searches are more topic-driven • Enhanced table manipulation features and mapping features * Legacy FactFinder deactivated on January 20, 2012

15. The New Census.gov

16. The New American FactFinder Main Page

17. Resources: Using FactFinder - provides useful resources for understanding AFF various search methods and more.

18. Data Search Methods can also be accessed on the Ribbon (*Ribbon can be accessed from any page in American FactFinder) • Data Search Methods • Community Facts – basics for one Geography • Guided Search – Step-by-Step with Breadcrumb trail • Advanced Search – multiple data products, tables and geographies • Download Options – access to FTP site for large data files and archived data sets.

19. Community Facts • Enter a state, county, city, town, or zip code in the Community Facts text box, then click GO. • Cannot select lower-level census geographies such as tracts and blocks • Receive the central statistic for the nine categories listed as the blue buttons on left hand side. • Example, click Age to view Area’s “Median Age” • Click the links under "Popular tables for this Geography" to see tables containing other commonly requested data for your community. • (i.e. DP-1 thru DP-5) Click the categories and data value will change

20. Start • Topics relating to People, Housing, or Businesses and Industries. • Directed to novice users (must be aware that multiple datasets will be included in results.) • Search using Dataset or Specific Table Number • Requires understanding about Census Bureau datasets and table number conventions • Click the radio button, then Next to continue the guided search. Guided Search

21. Topics • Depending on the universe option selected in Step 1, “Topics” will display a listing of characteristics relevant to that universe. • Select one or more topics to add to Your Selections. As you add and remove topics, the number of tables matching Your Selections is updated. • Topics are also updated when search is refined. • Subcategories display a number in parenthesis to indicate number of products for a specific search

22. Geographies • Functions identical to List Tab in Advanced Search (see advanced search section for details). • Only most commonly selected geographic areas area available. • Text Search is only available for the geographies listed • You may add more than one text search result, but no psuedo-georaphies are available in text search (i.e. all counties within Pennsylvania)

23. Race/Ethnic Groups • Search for Census data for one or more race or ethnic groups, tribes, or ancestries. • Both Text Search and Filter Search Options Available. • Selection of Race/Ethnicity may not be possible because of items in “Your Selections “. • In this case, you would have to remove a search criteria so that a data product containing race/ethnic group filter is available.

24. Search Results • Click on 5 Search Result button in breadcrumb at anytime during Guided Search to view results. • Provides only the top ten Search Results. • Must got to Advanced Search to view all results • Users can select one table at a time • Again, must go to Advanced to select multiple tables (i.e. Zipping multiple files for download)

26. Table Types

27. Guided Search Notes • Series of questions used to get user to data they’re seeking. A "breadcrumb" trail provided at top of the page. • Breadcrumb trail is clickable so that user can go back to specific step to change search criteria. • Offers insight as to how the Census Bureau structures its data. • Each step allows user to understand another aspect of data organization • “People”, “Housing” and “Businesses or Industries” define a data universe. “Dataset” limits search to one particular dataset. • If “specific dataset” radio button is not selected in IMAGEE, you cannot select a specific dataset later in the search • This may cause data users to mistakenly select figures from different dataset (i.e. Want = Census Data, Result = Population Estimate)

28. Advanced Search • Data Selection Tools: • Topics (people, housing, specific data set) • Geographies (geo type, summary level) • Population Groups (ancestry, race, ethnicity) • Industry Codes (search by NAICS code) • EEO Occupation Codes (search by EEO occ.)

29. Advanced Search Text Box Features: • Type-ahead overlay will appear with common search terms • This occurs in all text boxes in American FactFinder • Spell correction feature (alert if correction is made) • A “Did you mean..” function for searches that closely match common searches • Wild Card search by using “*” in your search • Topics, populationgroups, or industries radio buttons • Drop down list appears for suggest search terms within each category

30. Your Selections: • All search filters must appear in “Your Selections” • Number and type of search results will change as • “Your Selections” is updated • Selections can be added or removed at any time • Helps to track and manage your search criteria • Provides an outline of your data search

31. Topics Filters: • Selected from the Topics Menu • to narrow search to age-related • data items from 2010 Census • Summary File – 1 • Geography Filters: • Selected from the Geography Menu to narrow search to Geographic area(s) specified.

32. Click on the to remove a single selection from “Your Selections” • Click on the “clear all selections”to remove all search criteria from • “Your Selections” • Once cleared, filters cannot be recovered.

33. Topic Filters Include: • People– Characteristics of people such as age, and sex • Survey– Characteristics of data surveys such as program, year, and survey name • Dataset –select the dataset you wish to retrieve data from • Housing– Characteristics of housing such as count, and owner costs • Business and Industry – Measurements of businesses and industries such as expenses, capital expenditures and assets

34. Search by Topics • Use the Dataset Filter in Topics Menu to mimic a Legacy FactFinder search • Limit search results to a specific data set • Expand search categories and select items to add to “Your Selections” • Results will be refined each time an item is added or removed • Topics are also updated when search is refined. • Subcategories display a number in parenthesis to indicate number of products for a specific search

35. Click the to expand or contract the filter Collapse Button Topic Filter Group Topic Filter Group Subgroup Topic Filters Expand Button

36. Topics Allows Users to • Search and Select Topic Filters • Expand categories to select items to add to “Your Selections” • Topics categories will also update each time a search is refined. • Each subcategory displays a number in parenthesis that indicate the number of corresponding products for a search topic. • Each time a Topic Filter is added “Search Results” are updated.

37. Geographies Allows Users to • Select Geographic Areas • Click on Geographies from the Data Selection Tools • The Geographies Overlay appears over the Search Results Page

38. Search by Geographies • Search by List • Revival of Legacy FactFinder Geography Search Mechanism • User does not have access to all Geographic Summary Levels! • Search for Geographic Area by Name • Note – You must clear your geography filters before searching for additional, unrelated geographies • Search by Address • Provides the Census Geographic areas for a given address • Search by Map • Select Geographic Areas from a map

39. Search Using Geography: List • List is the default Tab when Geography Overlay Opens • Restores Legacy FactFinder Geography Search Chose the level of Geography you wish to get data for from the drop down list (Caution! Not all Summary Levels are available)

40. Next, narrow your search by selecting higher geographic areas from the dropdowns provided. • Finally, select your geographies from the list provided and click “ADD TO YOUR SELECTIONS”. • Hold Control Key while clicking to select multiple geographies from the list

41. Search Using Geography: Name • Geography Index Selector • Three levels of detail available • System performance declines as level of detail increases Geography Results shows how many geographies match the Geography Filters – up to 75 displayed per page

42. Text Search • Type in name of geographic area • Select Your Geographic Filters • Select the geographic level you want to end up with First! • Then, Trim away at the geography results using the “Within” Filter (Similar to the drop down list functionality)

43. Select Your Geographic Filters • Select the geographic level you want to end up with First! • Then, Trim away at the geography results using the “Within” Filter • Must go back and remove Geographic Filters to expand search options • This will reveal geographies that are not filtered out by the geography filters previously put in place Notice that Geography Results are updated each time a filter is applied No Geographies are selected until you click on the “Geography Name” or check the box, then click “Add” to send it to “Your Selections”

44. Other Geography Search Options • Include in Results Selector • Use the radio buttons under “Include in results” to display all geographies, only individual geographies, or only groups of geographies in the Geography Results Pane. • Geographic Components • Enable searching and selection of geographic components • Search using Geo Codes • Enable users to search using Federal Information Processing Standard (FIPS) Code

45. Close Geography Overlay by Clicking the • Search Geographies Using • Address Tab • Search census geographies by entering an address and clicking “GO” • Select geographies to add to “Your Selections” • Note: search uses the latest available data beginning with 2010 and working backwards.

46. Search Geographies Using • Map Tab • Search a single geography by clicking the map • Select multiple geographies by drawing with Map Selection Tools • Add the selected geographic areas to “Your Selections”

47. Geography Search – Reference Maps Map Selection Tools: Point – Click on the map to add individual geographic areas to the selection results. Rectangle – Click on the map and drag the mouse pointer to draw a rectangle on the map. Areas that intersect this rectangle will be added to the selection results. Polygon – Click on the map to define the borders of a polygon. To finish drawing the polygon, double-click the last point. Areas that intersect this polygon will be added to the selection results. Radius - Click on the map and drag the mouse pointer to draw a circle on the map. Areas that intersect this circle will be added to the selection results.

48. Reference Maps and Address • Geography Search • Can be assessed on the American FactFinder Main Page • Note: Only 2010 Census Geography is available via Maps and Address searches

49. Race and Ethnic Groups • Enter a population group name in the population group search box or select population group filters Race and Ethnic Groups are only available for data files that have separate records for individual race groups such as Summary File 2 and the ACS.

50. Search by Race & Ethnic Groups Race and Ethnic Groups filters include: • Basic Race Category • White, Black, AIAN, Asian, NHOPI, Some Other Race and Two or more Races • Ethnic Category • Hispanic and Not Hispanic • Race combinations • Alone, Alone or in combination • Ancestry Group • German, Irish, Italian, ect. • Country of Birth • Native, Foreign Born, Specific County