american factfinder and census 2000

American Factfinder American Factfinder and Census 2000and Census 2000

Grace YorkGrace York

University of MichiganUniversity of Michigan

April 2008April 2008

Table of ContentsTable of Contents Census History and ApplicationsCensus History and Applications Census Questionnaire and Definitions – 100%Census Questionnaire and Definitions – 100% Census Questionnaire – SampleCensus Questionnaire – Sample Special Tabulations and PUMSSpecial Tabulations and PUMS Census GeographyCensus Geography Data FormatsData Formats American Factfinder Fact SheetsAmerican Factfinder Fact Sheets American Factfinder Reference MapsAmerican Factfinder Reference Maps Data Sets and Types of FilesData Sets and Types of Files Data Set Options BoxData Set Options Box Summary File 1Summary File 1

• DownloadingDownloading• Revising Geography and TablesRevising Geography and Tables• ExcelExcel

Tables of ContentsTables of Contents Summary File 2Summary File 2 Summary File 3Summary File 3

• Geography within GeographyGeography within Geography• Subject SearchingSubject Searching

Summary File 4Summary File 4 Saving and Loading SearchSaving and Loading Search Thematic MapsThematic Maps American Community Survey/Census American Community Survey/Census

UpdateUpdate Historic Census DataHistoric Census Data Custom Tables AddendumCustom Tables Addendum Getting HelpGetting Help

Survey of the United States Survey of the United States population every 10 yearspopulation every 10 years

Mandated by ConstitutionMandated by Constitution

Purpose: reapportionment Purpose: reapportionment of 435 seats in the House of of 435 seats in the House of RepresentativesRepresentatives

Census History Census History

Slavery last asked in 1860Slavery last asked in 1860Feeble-minded in 1840-Feeble-minded in 1840-18901890Income first asked in 1940Income first asked in 1940Televisions surveyed, 1950-Televisions surveyed, 1950-7070Detailed ancestry Detailed ancestry beginning 1980beginning 1980Multiple races and Multiple races and grandparents as caregivers grandparents as caregivers in 2000in 2000

Census Questions Vary Census Questions Vary Over Time Over Time

Reflects changes in society

In 1990 and 2000 Congress wanted to reduce paperwork

Grid of questions, 1790-2000http://www.lib.umich.edu/govdocs/census2/censubj.pdf

Census Questions Vary Census Questions Vary Over Time Over Time

Public health professionals identify vulnerable populations for chronic disease

Urban planners identify zoning, housing, sewage, and transportation issues

Social workers conduct needs assessments for services to the elderly, poor, children

Practical Applications for Practical Applications for Census Data Census Data

Marketers target likely buyers

Politicians use the census to determine voting districts and to assess constituent interests

Environmentalists map the spread of toxic effluents and population densities

Practical Applications for Practical Applications for Census Data Census Data

Occupation by age, race, and sex for equal employment opportunity

Librarians base collection development policy on community characteristics

Mayors use numbers to apply for federal grants.

Undercount costs money – the reason for lawsuitsRacial minorities and undocumented aliensShould missionaries be counted as U.S. residents

Practical Applications for Practical Applications for Census Data Census Data

Outline of PresentationOutline of Presentation

Census QuestionnaireCensus Questionnaire Census GeographyCensus Geography Reference MapsReference Maps Census DataCensus Data Thematic MappingThematic Mapping

Reference ToolsReference Tools

Census ToolkitCensus Toolkithttp://www.lib.umich.edu/govdocs/census2/centool.pdfhttp://www.lib.umich.edu/govdocs/census2/centool.pdf

Historic Census QuestionsHistoric Census Questionshttp://www.lib.umich.edu/govdocs/census2/censubj.pdfhttp://www.lib.umich.edu/govdocs/census2/censubj.pdf

2000 Questionnaires2000 Questionnaires100% Questionnaire

Age Sex Race (Multiple) Hispanic origin Household relationship Occupied v. vacant housing

units Owner v. renter occupied

housing

Primary Uses of Short Form Data

Race and sex for single years of age to 99; three groups after 100

Most detail by race (250 groups total)

Race Groups in 2000Race Groups in 2000 WhiteWhite Black or African-AmericanBlack or African-American American Indian or Alaskan American Indian or Alaskan

NativeNative AsianAsian Hawaiian or Pacific IslanderHawaiian or Pacific Islander OtherOther Two or More RacesTwo or More Races

(Based on Self-Identification)(Based on Self-Identification)

Individual RacesIndividual Races

Some files break the Asian, American Indian, and Pacific Islander into 250 specific categories

Includes Chippewa Indians, Hmong, Pakistanis

Black and white races are further delineated as ancestries in sample data

Racial definitions appear at:

http://www.lib.umich.edu/govdocs/census2/sf3td/sf3tdg7.pdf

HispanicHispanic

Not considered a raceCan be Hispanic and any race

Breakdowns in some tables• Cuban• Puerto Rican• Mexican• Spanish• Various Latin American Countries

Calculating MinoritiesCalculating Minorities Subtract White Non-Hispanic from White Subtract White Non-Hispanic from White

Alone to get White Hispanic; then add WH Alone to get White Hispanic; then add WH and WNH to other racesand WNH to other races

OROR

Subtract White, Non-Hispanic from total Subtract White, Non-Hispanic from total

population to get total minority populationpopulation to get total minority population

Total Michigan 9,938444Total Michigan 9,938444

White Non-Hispanic -7,806,691White Non-Hispanic -7,806,691

Minority = 2,131,753Minority = 2,131,753

New Race Category in 2000New Race Category in 2000

Respondents could choose up to Respondents could choose up to SIX racial backgroundsSIX racial backgrounds

Typical mixed race is 2-3% of Typical mixed race is 2-3% of populationpopulation

Race data not necessarily Race data not necessarily comparable with previous comparable with previous censusescensuses

Household RelationshipsHousehold Relationships

Relationship to Relationship to HouseholderHouseholder

Spouse Child Stepchild Grandchild Brother/Sister Parent Non-relative Unmarried partner is separate

category

Group QuartersGroup Quarters

College dormsCollege dorms PrisonsPrisons Mental hospitalsMental hospitals Shelters for abused Shelters for abused

spousesspouses Military barracksMilitary barracks Nursing homesNursing homes

100% Questionnaire Data Reports

Pre-Tabulated Data

Summary File 1 – most age, race, sex data to the smallest geographies, block and block group

Summary File 2 – same data by 250 races to neighborhood (tract) level

2000 Sample Questionnaire2000 Sample Questionnaire(generally 1/6 of population)

Marital status, housing value Marital status, housing value and rent and rent (100% in 1990)(100% in 1990)

Grandparents as caregivers Grandparents as caregivers (new)(new) AncestryAncestry LanguageLanguage Country of originCountry of origin School enrollment and School enrollment and

educational attainment (and educational attainment (and dropouts)dropouts)

2000 Sample Questionnaire2000 Sample Questionnaire

EmploymentEmployment Industry and occupationIndustry and occupation Transportation to and place of Transportation to and place of

workwork Disability and mental illnessDisability and mental illness Veteran statusVeteran status Income and povertyIncome and poverty

Sample Data ProductsSample Data Products

Pre-Tabulated Data

Summary File 3 – socio-economic and housing characteristics to census tract or block group level

Summary File 4 – same data as Summary File 3 for 210 racial and 125 ethnic groups to tract level

Special Tabulations (not on Factfinder)

School District Data File (Available)

Sample data for children, parents and families with school-age children for school districts

http://nces.ed.gov/surveys/sdds/index.asp

Equal Employment Opportunity File

Sex and race for 472 occupational groups for places of 50,000+

http://www.census.gov/eeo2000/index.html

Special Tabulations(not on Factfinder)

Census Transportation Planning Commuting and place of work data for counties, minor civil divisions, and traffic analysis zones

http://www.trbcensus.com/

County to County Worker Flowshttp://www.census.gov/population/www/cen2000/commuting.html

MCD to MCD (place) Worker Flows

http://www.census.gov/population/www/cen2000/mcdworkerflow.html

Special Tabulation on Aging (2004) http://www.aoa.gov/prof/Statistics/Tab/specialtab.htm

Sample data cross-tabulated by age for people 55+ for places of 2500+

Public Use Microdata Samples (not on Factfinder)

Create your own tables using raw data

Larger geographies: states, metro-areas, PUMAS and super PUMAS

Public Use Microdata Samples (not on Factfinder)

Races of the Arab population in large cities

Education, occupation and citizenship status of people born in Senegal

Public Use Microdata Samples Alternative Software

PDQ Explore - http://www.pdq.com/

> Free password to academics> Sample search at:

http://www.lib.umich.edu/govdocs/census2/pdqexp.ppt

Integrated Public Use Microdata Samples IPUMS (free through University of IPUMS (free through University of

Minnesota)Minnesota)

Census GeographyCensus Geography

Legal AreasLegal Areas

Nation State Counties Cities Townships Congressional Districts School Districts Native American Reservations

Census GeographyCensus Geography

Census-Designated AreasCensus-Designated Areas

Metropolitan Statistical Area Urbanized Area and Urban

Cluster Census Tract Block Group Block Zip Code Tabulation Area PUMAS/Super-PUMAS Traffic Analysis Zones

Census Geography MapCensus Geography Map

Urban AreasUrban Areas

Urbanized = Densely settled area, 50,000+

Urban Cluster = Densely settled area,

2500-50,000; can be outside metro area

South Central Michigan has a surprising number of urban clusters

Metropolitan Statistical AreaMetropolitan Statistical Area

•Central city of 50,000 or more •Its own county, and •Surrounding counties with heavy commuting patterns

Detroit Consolidated Metropolitan Detroit Consolidated Metropolitan Statistical AreaStatistical Area

1990

Lapeer Livingston

Detroit PMSA Macomb

Monroe

Oakland

St. Clair

Wayne

Ann Arbor PMSA Washtenaw

2000

Lapeer Macomb

Detroit PMSA Monroe

Oakland

St. Clair

Wayne

Lenawee

Ann Arbor PMSA Livingston

Washtenaw

Flint PMSA Genesee

Detroit Metropolitan AreaDetroit Metropolitan Area2000-20032000-2003

MSA DefinitionsMSA Definitions

This is very complicatedThis is very complicated

Just consult the Just consult the definitions when you definitions when you need them need them

http://http://www.census.gov/population/www/ewww.census.gov/population/www/estimates/metrodef.htmlstimates/metrodef.html

Census TractsCensus Tracts

Areas of about 4000 peopleAreas of about 4000 people Approximate neighborhoodsApproximate neighborhoods

Detroit TractDetroit Tract

Block GroupBlock Group

Two – eight block groups per tract

All 2000s (2001, 2002, 2003) are BG 2

Smallest area for sample data

BlocksBlocks

All blocks in 2000 have 4-digit All blocks in 2000 have 4-digit numbersnumbersSome 100% data but no sample Some 100% data but no sample datadata

Technical DocumentationTechnical Documentation

Geographic and subject Geographic and subject definitionsdefinitions

Lists of tables and individual Lists of tables and individual components in tablescomponents in tables

Code lists Code lists (ancestry, race, occupation, (ancestry, race, occupation, group quarters, Hispanic, industry, group quarters, Hispanic, industry, language, country)language, country)

Original questionnaireOriginal questionnaire

Census Data FormatsCensus Data Formats20002000

American FactfinderAmerican Factfinder http://http://factfinder.census.govfactfinder.census.gov//

Prepared profilesPrepared profiles Data extraction to a spreadsheet,Data extraction to a spreadsheet, Reference and thematic mapsReference and thematic maps

FTPFTP Transfer all data for all geographies in a county and Transfer all data for all geographies in a county and

manipulate with SAS or SPSSmanipulate with SAS or SPSS

CD-ROM and DVD CD-ROM and DVD Download more geographies at a time (e.g. all tracts in Download more geographies at a time (e.g. all tracts in

country)country) Can mix and match data tablesCan mix and match data tables SF 1 and 3 in Documents CenterSF 1 and 3 in Documents Center

Initial Factfinder ScreenInitial Factfinder Screenhttp://factfinder.census.gov/

Use Mozilla on campus; Internet Explorer downloads are incomplete

http://factfinder.census.gov/Brief population, social, economic and housing profiles for Brief population, social, economic and housing profiles for

the U.S. or one state, county, place, zip codes and census the U.S. or one state, county, place, zip codes and census tracts in 2000; fewer geographies for the latest American tracts in 2000; fewer geographies for the latest American

Community SurveyCommunity Survey

Fact SheetsFact Sheets

http://factfinder.census.gov/Search by all or part of address. Choose geographic Search by all or part of address. Choose geographic

result. Click on MORE to see one of four profiles.result. Click on MORE to see one of four profiles.

Fact SheetsFact Sheets

http://factfinder.census.gov/Same geography but also includes more Same geography but also includes more

detail, maps and comparative datadetail, maps and comparative data

People/Housing Fact SheetsPeople/Housing Fact Sheets

http://factfinder.census.gov/Maps and table types are coded with iconsMaps and table types are coded with icons

Population/Housing Fact SheetsPopulation/Housing Fact Sheets

Geographic AreaGeographic Area http://factfinder.census.gov/

If you know the geographic area or proceed If you know the geographic area or proceed directly todirectly to DATA SETSDATA SETS

If you need to determine the geographic area, go If you need to determine the geographic area, go toto ADDRESS SEARCHADDRESS SEARCH

Address SearchingAddress Searching http://factfinder.census.gov/

Search for a known address to find its county, city, tract, block group, block number, and map

Address SearchingAddress Searching

Choose the Reference Map from your search results

Address Map Address Map

Changing Boundaries Changing Boundaries

Changing BoundariesChanging Boundaries

Revised MapRevised Map

Move map around to choose block groups and census tracts in neighborhood.

Example of a NeighborhoodExample of a Neighborhood

Tract 5240; 5241-BG 2, and 5242-BG 1&2

(It is much easier to retrieve data if your neighborhood has whole tracts, e.g.5240, 5241,

5242)

Another SearchAnother Search

Click on Geography to Change to Another Search

Place Name SearchingPlace Name Searching

BESTBEST option for option for mappingmappingStatesStatesCountiesCountiesCitiesCitiesTownshipsTownshipsVillagesVillages

Name SearchName Search

Altering MapAltering Map

Place boundaries in green. You may need to add census geographies on your own.

Reading Tract NumbersReading Tract Numbers

Sometimes you have to zoom in to read all of the tract numbers.

Downloading MapsDownloading Maps

Use Download command to download in pdf formatLeft click on mouse to download in gif format

Data SetsData Setshttp://http://factfinder.census.govfactfinder.census.gov//

Once you’ve determined geography and used Basic Once you’ve determined geography and used Basic Facts, go to Facts, go to DATA SETSDATA SETS for the detail for the detail

Listing of Data SetsListing of Data SetsThe default display are files from the

2000 and 1990 Census

Data Files for 2000Data Files for 2000

Summary File 1: 100%Summary File 1: 100%• Race, sex, age, households and families, Race, sex, age, households and families,

housing tenurehousing tenure

Summary File 2: 100%Summary File 2: 100% • Detailed cross classifications by type of Detailed cross classifications by type of

Hispanic origin, Indian tribe, or Asian Hispanic origin, Indian tribe, or Asian subcategory (about 250 total)subcategory (about 250 total)

Data Files for 2000Data Files for 2000

Summary File 3: SampleSummary File 3: Sample• Income, language, ethnicity, Income, language, ethnicity,

occupation, commuting, housing occupation, commuting, housing value and rentvalue and rent

Summary File 4: SampleSummary File 4: Sample • Detailed cross classifications by Detailed cross classifications by

race and ethnicityrace and ethnicity• STF4 in 1990 not on FactfinderSTF4 in 1990 not on Factfinder

Data Sets Option BoxData Sets Option Box

Options box aligns with checked data set

Options for Data SetOptions for Data Set

Detailed TablesDetailed Tables = = most data for most data for most placesmost places• Download one entire table at a time

Custom TablesCustom Tables = = may mix and may mix and match variables in several tables, then match variables in several tables, then sort and filtersort and filter• If over 10 variables, use Detailed Tables and

manipulate with Excel

Options for Data SetOptions for Data Set

Quick TablesQuick Tables = = brief data for one brief data for one named placenamed placeSame as Basic Facts but includes tract dataSame as Basic Facts but includes tract data

Geographic Comparison TablesGeographic Comparison Tables = = brief data for all tracts in county, brief data for all tracts in county, counties in state, states in U.S.counties in state, states in U.S.

Options for Data SetOptions for Data Set

Technical DocumentationTechnical Documentation = = definitions, lists of tables, definitions, lists of tables,

interpretation of codesinterpretation of codes Thematic MapsThematic Maps = = subject subject

mapsmaps

Summary File 1Summary File 1

Most data by age, race, sex, households, Most data by age, race, sex, households, group quarters down to block levelgroup quarters down to block level

Detailed Tables GeographyDetailed Tables GeographyDefault is LIST geography. Others include name Default is LIST geography. Others include name

search, address search, and geography within search, address search, and geography within geography.geography.

Detailed Tables GeographyDetailed Tables Geography

You can chooseYou can choose • All states• All counties in a state• All tracts in a county • All 5 digit zip codes in a 3-digit zip

code• All block groups in a tract

• All blocks in a block group.• To choose all 5 digit zip codes or tracts in

state, block groups in city, use Geography within Geography

Detailed Tables GeographyDetailed Tables Geography

1. Choose lowest level of geography you want2. Follow pop-up menus to choose place3. Once you select a geographic area, be sure to

add it

The default for Detailed Tables is the List of All Tables.

List of Tables - SF1List of Tables - SF1http://http://factfinder.census.govfactfinder.census.gov//

Population (P) Tables by Population (P) Tables by SubjectSubject

RaceRace AgeAge Households by Age, Type, and Households by Age, Type, and

RelationshipRelationship Families and Family TypeFamilies and Family Type Group QuartersGroup Quarters Imputations of data when Imputations of data when

questionnaire not answeredquestionnaire not answered

Housing (H) Tables Housing (H) Tables Clustered by SubjectClustered by Subject

Housing Units (occupied and vacant)Housing Units (occupied and vacant) Occupied Housing Units by race and Occupied Housing Units by race and

household sizehousehold size Owner/Renter Occupied by RaceOwner/Renter Occupied by Race Imputations of data when Imputations of data when

questionnaires not answeredquestionnaires not answered

PCT Tables Clustered by PCT Tables Clustered by SubjectSubject

• American Native Tribes• Asian Races (e.g. Asian Indian, Hmong)• Hawaiian and Pacific Islander Races• Hispanic Origin Details (e.g. Cuban)• Single years of age by race to 99; three

groups over 100• Unmarried partners• Nonrelatives by household type (foster

child, boarder) and race• Group quarters population by age, race,

sex and type (dorm, prison)

To preview a table, highlight it and click on What’s This?

List of Tables - SF1List of Tables - SF1http://http://factfinder.census.govfactfinder.census.gov//

We’re choosing P12 – sex by age; we know it won’t We’re choosing P12 – sex by age; we know it won’t be as detailed as PCT but could give data to the be as detailed as PCT but could give data to the block levelblock level

List of Tables - SF1List of Tables - SF1http://http://factfinder.census.govfactfinder.census.gov//

Detailed SpreadsheetDetailed Spreadsheetand Geocodesand Geocodes

Options include Geographic and Other FIPS Codes

Detailed Spreadsheet Detailed Spreadsheet and Printing and Printing

•Use print button or web browser for printing•When result is multiple pages, you will need to print each page individually

Detailed Spreadsheet Detailed Spreadsheet and Downloading Optionsand Downloading Options

ALWAYS use Factfinder’s button for downloading data

On campus, use Mozilla browser. Internet Explorer downloads are incomplete

Downloading OptionsDownloading Options Comma, tab, rtf, zippedComma, tab, rtf, zipped

• Comma-delimited spreadsheets easily export to EXCEL• You can also transpose rows and columns• Default is downloading entire spreadsheet• Data compatible formats are zipped; no English headers

Detailed TablesDetailed TablesRevising GeographyRevising Geography

Change Geography Using a BreadcrumbChange Geography Using a Breadcrumb

Detailed TablesDetailed TablesRevising GeographyRevising Geography

REMOVE all counties except Washtenaw or ADD state of Michigan You cannot change tables at this point.

Detailed TablesDetailed TablesRevising TablesRevising Tables

Once you show the new geography, you can Once you show the new geography, you can change TABLES.change TABLES.

Detailed TablesDetailed TablesRevising TablesRevising Tables

Remove the old table by highlighting it and pressing the remove button.Remove the old table by highlighting it and pressing the remove button.

Detailed TablesDetailed TablesKeyword SearchingKeyword Searching

You can search by using multiple termsYou can search by using multiple terms

Keyword SearchingKeyword Searching

PCT Tables have single years of agePCT Tables have single years of age

Multiple Table SpreadsheetMultiple Table Spreadsheet Although the spreadsheet has nine tables, Although the spreadsheet has nine tables,

they are separate tablesthey are separate tables You must combine them with a spreadsheet You must combine them with a spreadsheet

programprogram

Excel AssistanceExcel Assistance

For assistance in using Excel see

http://www.lib.umich.edu/govdocs/census2/excel/xlguide.pdf

Includes manipulating spreadsheets, transposing rows and columns, filtering, ranking, and converting

pdf to Excel

Age, sex, households, families, and owner v. rented occupied housing units

State, counties, places, MSAs, and census tracts

For 250 races; e.g. single years of age by sex for the Pakistani population rather than the Asian population at large

Brief guide available at: http://www.lib.umich.edu/govdocs/census2/sf2.htm

Summary File 2Summary File 2http://http://factfinder.census.govfactfinder.census.gov//

2000 is the first time for this file on format other than magnetic tape

There are limits for racial data – must have 100 or more people of race in the geographic area

Summary File 2Summary File 2http://http://factfinder.census.govfactfinder.census.gov//

Summary File 2Summary File 2http://http://factfinder.census.govfactfinder.census.gov//

Mark Box with Summary File 2

Summary File 2 – GeographySummary File 2 – Geography http://http://factfinder.census.govfactfinder.census.gov//

1. Choose geography1. Choose geography

Summary File 2 – SubjectSummary File 2 – Subjecthttp://http://factfinder.census.govfactfinder.census.gov//

2. Choose Table2. Choose Table

Summary File 2Summary File 2http://http://factfinder.census.govfactfinder.census.gov//

3. Choose race or races

Summary File 2Summary File 2http://http://factfinder.census.govfactfinder.census.gov//

4. Results handle multiple races as separate tables

Summary File 3Summary File 3http://http://factfinder.census.govfactfinder.census.gov//

Most social and economic characteristics for the smallest geographic areas

Summary File 3-SubjectsSummary File 3-Subjectshttp://http://factfinder.census.govfactfinder.census.gov//

Ancestry Education and school enrollment Commuting, occupation, industry Income and poverty Disability and veteran status Housing value, rent, mortgages Race and household status

Geography Within GeographyGeography Within GeographyDefault List ViewDefault List View

Choose one indentation down from the previous geography, e.g. tracts in county, 5-digit zip codes within a 3-digit zip code

Geography Within GeographyGeography Within GeographyChoose Geo within Geo for best

mass-downloading options

Geography Within GeographyGeography Within Geography

Choose the SMALLEST geography you want; then the LARGEST geography you want; then follow instructions

Summary File 3Summary File 3List of TablesList of Tables

http://http://factfinder.census.govfactfinder.census.gov//

P – Population Tables to Block Group Level

P 1-93 Sample data for total populationP 94-144 ImputationsP 145-160 Sample data by race

Summary File 3Summary File 3List of TablesList of Tables

http://http://factfinder.census.govfactfinder.census.gov//

H – Housing Tables to Block Group Level

H 1-98 Sample data for total populationH 99-121 Imputations

Note: no sample housing tables by race at the block group level

Summary File 3Summary File 3List of TablesList of Tables

http://http://factfinder.census.govfactfinder.census.gov//

PCT – Population Tables to Tracts

PCT 1-76 – very detailed sample data broken down by race; includes ancestry as separate categories but does not break other data down by ancestry

HCT – Housing Tables to TractsHCT 1-48 – very detailed housing sample

data broken down by race but not ancestry

Summary File 3Summary File 3Subject SearchSubject Search

Highlight a subject (e.g. commuting) and search Results include all tables where the subject is a variable Choose P30 and P31; Add; Show Table

Summary File 3Summary File 3http://http://factfinder.census.govfactfinder.census.gov//

Summary File 3Summary File 3AncestryAncestry

http://http://factfinder.census.govfactfinder.census.gov//

Primarily countries with which white and some black races identify

Tables PCT 16, 17, and 18

List of Ancestrieshttp://www.lib.umich.edu/govdocs/census2/sf3td/

sf3tdg1.pdf

Summary File 3Summary File 3AncestryAncestry

http://factfinder.census.gov/http://factfinder.census.gov/

Ancestry is another tract only variable

Summary File 3Summary File 3OccupationOccupation

http://http://factfinder.census.govfactfinder.census.gov//

Industry = where you workOccupation = what you do

Summary File 3Summary File 3Educational AttainmentEducational Attainment

Population over 25 is countedPopulation over 25 is counted

Data is not cumulative; Data is not cumulative; Even though high school graduation rate may be 0%, people who completed bachelors or masters completed high school as well

Main table is P37Main table is P37

Table by race is P148Table by race is P148Many tables in this data set are split so racial breakdowns appear in a later number

Summary File 3Summary File 3Educational AttainmentEducational Attainment

Summary File 3Summary File 3DisabilityDisability

Disabilities count overall limitations,

not individual diseases• Sensory• Physical• Mental• Self-care• Go outside the home• Employment

Summary File 3Summary File 3DisabilityDisability

Summary File 3Summary File 3RentRent

Contract rent = amount paid to landlord

Gross rent = amount paid to landlord

AND amount for utilities

Summary File 3Summary File 3Labor ForceLabor Force

Labor Force = either have a job or are looking for a job

Not in Labor Force = don’t have job or want one (e.g. retiree)

Unemployed = in labor force but don’t have job

Summary File 3Summary File 3Labor ForceLabor Force

Summary File 3Summary File 3IncomeIncome

Income calculated for households (related, unrelated, single), families (related), and individuals

Income includes salaries, interest, social security, retirement, public assistance

Median means half earn below and half earn above

Aggregate means all of the income in that geographic area

Summary File 3Summary File 3IncomeIncome

Summary File 3Summary File 3PovertyPoverty

Calculated variable based on income, size of family, and federal poverty guidelines

Poverty guidelines for 1999 appear at:http://www.census.gov/hhes/poverty/histpovhttp://www.census.gov/hhes/poverty/histpov/hstpov1.html/hstpov1.html

Example of ratio of income to povertyPoverty for one person in 1999 was $8501Under .50 = earned less than $4250

Earned 1.5 of poverty=$12751

Summary File 3Summary File 3PovertyPoverty

Summary File 4Summary File 4http://factfinder.census.gov/http://factfinder.census.gov/

Sample data for 350 races and ancestries

Summary File 4Summary File 4http://factfinder.census.gov/http://factfinder.census.gov/

List geography shows county, city, tract levels

Summary File 4Summary File 4http://factfinder.census.gov/http://factfinder.census.gov/

Subject search for poverty by by age

Summary File 4Summary File 4http://factfinder.census.gov/http://factfinder.census.gov/

Use ancestry tab for Arab; race and ancestry can be mixed in same operation

Summary File 4Summary File 4http://factfinder.census.gov/http://factfinder.census.gov/

Result is two tables: total population and ethnic population.

CUSTOM TABLESCUSTOM TABLES(Available for SF1-4)(Available for SF1-4)

•Allows you to pick elements you want from a table

•Better for comparing less than 10 variables

•Filter and sort spreadsheet options similar to EXCEL

•Tips for Using Custom Tables

•Easier to download entire tables and manipulate with EXCEL

Saving Your QuerySaving Your Query

When conducting a large project, you may When conducting a large project, you may want to save your query by pulling down want to save your query by pulling down the Print/Download menu.the Print/Download menu.

Saving QuerySaving Query

The file on your hard drive will have an The file on your hard drive will have an xql extension.xql extension.

Loading QueryLoading Query

You can load your query again from You can load your query again from the main Data Files menu.the main Data Files menu.

Loading QueryLoading Query

Loading QueryLoading Query

The result will gave you the last table The result will gave you the last table you looked at.you looked at.

Thematic maps can be accessed through Data Sets for Summary File 1 and 3.

Thematic MapsThematic Mapshttp://factfinder.census.gov/http://factfinder.census.gov/

Thematic MapsThematic MapsChoosing New GeographyChoosing New Geography

You can choose a map through the List method, using the HIGHEST LEVEL of geography you want

(e.g. Wayne County, Mich)

Thematic MapsThematic MapsChoosing Theme (Subject)Choosing Theme (Subject)

You can choose a theme by subject, keyword, or list

Not all Census variables are represented

In this case, race appears in SF1 maps; ancestry in SF3 maps

Thematic MapsThematic MapsChoosing Theme (Subject)Choosing Theme (Subject)

Thematic MapsThematic MapsChanging Geographic DisplayChanging Geographic Display

The default for a county is county subdivisionThe default for a county is county subdivision This can be changed to census tract or BGThis can be changed to census tract or BG

Thematic MapsThematic MapsSame Map – Tract LevelSame Map – Tract Level

Same map at tract level. You can change the display by choosing DATA CLASSES.

Thematic MapsThematic MapsSame Map – Tract LevelSame Map – Tract Level

Natural breaks = equal number of people counted

Equal interval means equal percent intervals

Thematic MapsThematic MapsSame Map – Tract LevelSame Map – Tract Level

This is probably more accurate. Click on legend to add geographic boundaries

Thematic MapsThematic MapsSame Map – Tract LevelSame Map – Tract Level

Click on legend to add geographic boundaries

Thematic MapsThematic MapsSame Map – Tract LevelSame Map – Tract Level

Same map with tract numbers

Thematic MapsThematic MapsSame Map – Tract LevelSame Map – Tract Level

Use identify button and click on map to obtain data

Thematic MapsThematic MapsLimitations of Factfinder MapsLimitations of Factfinder Maps

Only pre-selected variables; not entire Only pre-selected variables; not entire data setdata set

Maps download as gifs (pictures); the Maps download as gifs (pictures); the download feature does not workdownload feature does not work

Maps cannot be exported into another Maps cannot be exported into another programprogram

Maps can not be manipulated, e.g. Maps can not be manipulated, e.g. showing layersshowing layers

Geolytics Geolytics allows you to create your allows you to create your own variables and import them into own variables and import them into ArcviewArcview

American Community SurveyAmerican Community Surveyhttp://factfinder.census.govhttp://factfinder.census.gov

Annual survey of Census topicsAnnual survey of Census topics Access through Data SetsAccess through Data Sets U.S. States, Counties, County U.S. States, Counties, County

Groups (PUMAS) andGroups (PUMAS) and

Places of 65,000+Places of 65,000+

American Community SurveyAmerican Community Surveyhttp://factfinder.census.govhttp://factfinder.census.gov

Historic Census PublicationsHistoric Census Publications

Printed publications since 1790Printed publications since 1790 Most printed also available in pdfMost printed also available in pdf Some extraction capabilities through Some extraction capabilities through

the National Historic Geographic the National Historic Geographic Information SystemInformation System

For a full list of data available see:For a full list of data available see:http://www.lib.umich.edu/govdocs/http://www.lib.umich.edu/govdocs/

hiscenpubl.htmlhiscenpubl.html

CUSTOM TABLESCUSTOM TABLES(Available for SF1-4)(Available for SF1-4)

Allows you to pick elements you want from a tableBetter for comparing less than 10 variablesFilter and sort spreadsheet options similar to EXCEL

CUSTOM TABLESCUSTOM TABLESGeographyGeography

Choose geography the same way as regular tables

CUSTOM TABLESCUSTOM TABLESSubjectsSubjects

Select a table and press GO.

CUSTOM TABLESCUSTOM TABLESSubjectsSubjects

Check off data elements and ADD.You can choose from multiple tables

CUSTOM TABLESCUSTOM TABLESFiltersFilters

.It is more efficient to choose a filter first – if you know you want one – rather than choosing a race or ancestry

CUSTOM TABLESCUSTOM TABLESFiltersFilters

Males with PhDs greater than 0

CUSTOM TABLESCUSTOM TABLESRace or AncestryRace or Ancestry

Then choose Population Group for race or ancestry

CUSTOM TABLESCUSTOM TABLESRace or AncestryRace or Ancestry

You can only choose one ancestry or racial group in custom tables. You could have chosen multiples with detailed tables. 350 races/ancestries is unique to Summary File 4

CUSTOM TABLESCUSTOM TABLES

Getting Census HelpGetting Census Help

Documents Center 203 Hatcher Library North, (734) 764-0410,

govdocs@umich.eduhttp://www.lib.umich.edu/govdocs/

Campus representative to the Census Bureau’s State Data Center program.

Assistance with American Factfinder, Census CD-ROMS.Paper tract maps of Michigan.

Referrals to other sources. Census 2000 web page

http://www.lib.umich.edu/govdocs/census2/centool.pdf