your table is waiting n.
Skip this Video
Download Presentation
Your Table Is Waiting!

Loading in 2 Seconds...

play fullscreen
1 / 36

Your Table Is Waiting! - PowerPoint PPT Presentation

  • Uploaded on

Your Table Is Waiting!. Census 2010 Accessing and Using the Data. Linda Clark Information Services Specialist U.S. Census Bureau Seattle Region April 19, 2011. Agenda. Overview Three things you need to know Census geography Ethnicity and race What ’ s on the questionnaire?

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Your Table Is Waiting!' - donal

Download Now An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
your table is waiting

Your Table Is Waiting!

Census 2010

Accessing and Using the Data

Linda Clark

Information Services Specialist

U.S. Census Bureau Seattle Region

April 19, 2011

  • Overview
  • Three things you need to know
    • Census geography
    • Ethnicity and race
    • What’s on the questionnaire?
      • What happened to all the other questions?
  • Data release schedule
  • Resources
  • Population Estimates Program
  • Accessing the data: American FactFinder
dec ennial cen sus
Decennial Census
  • Deconstructing the name
    • “Dec” = 10 (every ten years)
    • “Cen” = 100 (100% count)
  • The 2010 Census
    • Counts the population to support apportionment and redistricting
    • Basis of the allocation of over $400 billion annually to states for programs wholly or partially dependent on census population counts
    • Vital for planning at state and local levels
decennial census
Decennial Census
  • Establishes framework
    • Mandated in 1787 by Constitutional Convention
    • Conducted every ten years since 1790
      • 2010 Census the 23rd decennial
    • Only source of complete demographic information for small geographic areas
      • Counties
      • Cities and towns
      • Zip codes
      • Neighborhoods
    • Participation is mandatory
    • Results (individual) confidential for 72 years
    • Workers take lifetime confidentiality oath

2010 Census Ethnicity Question

2010 Census Race Question

2010 census questionnaire topics



Date of birth



Relationship of people within household

Rent / own house (tenure)

2010 Census Questionnaire Topics


useful resources
Useful Resources
  • 2010 Census technical documentation
    • Redistricting dataset
  • Census in the Schools
    • Kid’s page
    • Lesson plans
    • Interesting facts
  • Maps (large format pdf map files)
  • California Department of Finance
    • 2010 Census tables and maps

Home page > Maps > Map Products > (select type of map) > (select state) > (select county) > open 000.pdf (index map) to determine map sheet (or inset) > back out > select map sheet (or inset)

california department of finance www dof ca gov
California Department of Finance

Enter 2010 Census

in search box

then open SDC site


Sample table and graph

2010 Census

Every state has a lead agency that is part of the Census Bureau’s State Data Center network. Many repackage census data and display tables and maps on their websites.

population estimates annual releases in the intercensal years
Population EstimatesAnnual Releases in the Intercensal Years
  • Population counts
    • Nation - - age, sex, race, and Hispanic origin
    • States - - age, sex, race, and Hispanic origin
    • Counties - - age, sex, race, and Hispanic origin
    • Incorporated places - - total population only
  • Housing unit counts
    • States
    • Counties

Accessing and Using the 2010 Census Data

(The New) American FactFinder (AFF2)

census bureau home page www census go v
Census Bureau Home Page

American FactFinder is the single entry point for census data

Simple searches are available on the home page


AFF Transition Page

toNew (AFF2) fromLegacy (AFF)

These are the FAQs just for AFF2, the new version (see next slide)


Notice that answers are annotated as “new” or “updated.” It pays to check this site frequently.


AFF Transition Page

This opens a 2010 Census release schedule with hyperlinks to table shells - - a preview of coming data products


2010 Census Data Products

Release Schedule

SF 1 shell for the P23 table:

Households by Presence of People 60 Years and Over By Household Type


AFF Transition Page

Click the link to enter AFF2


Quick Start Text Box

(only available from the Main tab)

Enter a topic / table name or geography alone, or Enter a topic / table name and geography


Search Results = number of data products currently available, before filters are applied

“i” icon opens a table shell

similar to “What’s This?”

on Legacy AFF


Search Results

Select data to view or download

Search within Results

Refine your search results by entering keywords

Search by Topic

Expand any of the topics and make a selection

  • Advanced Search Options
    • Geographies
    • Population Groups
    • Industry Codes

Very Important . . .

All the filters you choose must appear in the Your Selections box before you make your final selection of a data product


Search Using Geography:

Name tab

Search Results updated under geo overlay

Geographic selections added to “Your Selections” box

Enter text or use geo filters

Close overlay after verifying Your Selections


Search using Geography: Address tab

Search for geographies by entering an address

Select geographies to add to Your Selections


Search using Geography: Map tab

Select a single geography by clicking on the map

Select multiple geographies by drawing a rectangle or circle on the map

Add the selected geographic areas to “Your Selections”


Search using

Population Groups

Population Groups overlay functions like Geography overlay


Search using Industry Codes

. . . As does the Industry Codes overlay


View a Table

  • View your selected search results
  • Bookmark the data for future use
  • Download the data in multiple formats
    • Excel
    • Comma-Delimited
    • PDF
  • Create a thematic map from the table

Modify a Table

Collapse or expand groups of data in the table

Reorder rows and columns

Show or hide rows and columns

Transpose rows and columns

Reset table to its original view


Create a

Thematic Map

  • Customize the map:
  • - - change colors and transparency
  • - - select / deselect labels, boundaries, features
  • - modify number of classes
  • - - revise classing method

Thank you!

And stay tuned!

Additional Infopeople webinars!

US Census – The American Community Survey, Part 1 on Tuesday, June 21, 2011

US Census – The American Community Survey, Part 2 on Tuesday, July 26, 2011

Further questions . . .

Linda Clark

Information Services Specialist


Seattle Regional Census Center

Partnership & Data Services

19820 North Creek Parkway

Bothell, WA 98011