American Factfinder for Native American Profiles

1
American Factfinder for Native American Profiles

• Epidemiology 552
• September 2008

2
Ten States With the Largest American Indian
Populations 2000
AK 119,241
WA 158,940
NY 171,581
MI 124,412
CA 627,562
NC 131,736
OK 391,949
AZ 292,552
NM 191,495
TX 215,599
3
States With the Largest Percentage of American
Indians 2000
AK 15.6
SD 8.3
NM 9.5
4
Outline of Presentation

• Examples of Census Data
• Census Questionnaire
• Census Geography
• Creating a Profile of Native American area
• Updating the 2000 Census

5
Class Materials

• Census Guide
• http//www.lib.umich.edu/govdocs/epidem.html
• Powerpoint Presentation
• http//www.lib.umich.edu/govdocs/epidem/epidem08.
  ppt

6
Death Rates in IHS Areas
7
Characteristics of Navajo Reservation Compared to
the Nation

• Navajo National
• Median Age 24 35.6
• People in Families 94 83
• High School Graduates 56
  80
• Unemployment Male 28 6
• Unemployment Female 21
  6
• Median Household Inc 20,005
  41,994
• Poverty Rate 43
  12
• Homes w/o Full Plumbing 45
  1

8
Characteristics of Navajo Reservation Compared to
Tohono

• Navajo Tohono
• Median Age 24 26.2
• People in Families 94 93
• High School Graduates 56
  62.1
• Unemployment Male 28
  31
• Unemployment Female 21
  16
• Median Household Inc 20,005
  19,970
• Poverty Rate 43
  46.4
• Homes w/o Full Plumbing 45
  18.4

9
Two Questionnaires

• 100 Questionnaire
• Sent to all households
• SAMPLE Questionnaire
• Sent to one-sixth of households

10
2000 Questionnaire

• 100 Questionnaire
• Age
• Sex
• Race (Multiple)
• Hispanic origin
• Household relationship
• Occupied v. vacant housing units
• Owner v. renter occupied housing

11
Race Groups in 2000

• White
• Black or African-American
• American Indian or Alaskan Native
• Asian
• Hawaiian or Pacific Islander
• Other
• Two or More Races

12
Native Americans(AIAN)

• All files have overall American Indian table
  breakdowns
• Several files have breakdowns by 39 major tribal
  groups (e.g. Chippewa, Cherokee, Navajo)
• One file has breakdown by 1081 tribes, including
  Bay Mills Chippewa

13
Hispanic

• Not considered a race
• Can be Hispanic and any race
• Breakdowns in some tables
• Cuban
• Puerto Rican
• Mexican
• Spanish
• Various Latin American Countries

14
Calculating Minorities

• White, non-Hispanic found in Hispanic tables
• Subtract White, Non-Hispanic from total
• population to get total minority population
• Total Michigan 9,938444
• White Non-Hispanic -7,806,691
• Minority 2,131,753

15
Household Relationships

• Relationship to Householder
• Spouse
• Child
• Stepchild
• Grandchild
• Brother/Sister
• Parent
• Non-relative
• Unmarried partner is separate category

16
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
  (including 39 tribes) to neighborhood (tract)
  level

17
2000 Sample Questionnaire

• Marital status, housing value and rent
• Grandparents as caregivers (new)
• Ancestry
• Language
• Country of origin
• School enrollment and educational attainment (and
  dropouts)

18
2000 Sample Questionnaire

• Employment
• Industry and occupation
• Transportation to and place of work
• Disability and mental illness
• Veteran status
• Income and poverty

19
Sample Data Products

• Pre-Tabulated Data
• Summary File 3 socio-economic and housing
  characteristics to census tract or block group
  level 7 races including American Indian total
• Summary File 4 same data as Summary File 3 for
  210 racial and 125 ethnic groups to tract level,
  including 39 tribes
• Native American File same data as Summary File
  3 for 1081 tribes to metropolitan area or Indian
  reservation

20
Questionnaires for Epidemiology 552

• Use 100 data for age and race.
• Summary File 2.
• Use sample data for
• ancestry, language, occupation, education,
• industry, income, poverty, and mental disability.
  
• Summary File 4.

21
Census Geography

• Legal Areas
• Nation
• State
• Native American Areas
• Counties
• Cities
• Townships
• Congressional Districts
• School Districts

22
Census Geography

• Census-Designated
• Areas
• Metropolitan Statistical Area
• Urbanized Area
• Census Tract
• Block Group
• Block
• Zip Code Tabulation Area

23
Metropolitan Statistical Area

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

24
Detroit Consolidated Metropolitan Statistical
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

25
Census Tracts

• Areas of about 4000 people
• Approximate neighborhoods

26
Detroit Tract
27

• American Factfinder
• http//factfinder.census.gov/
• Prepared profiles
• Data extraction to a spreadsheet
• Reference and thematic maps
• Do not use Internet Explorer on
• campus
• (downloading problems)

28
Creating Age Groups Using American Factfinder
29
Data Files
http//factfinder.census.gov/
30
Data File Options
http//factfinder.census.gov/
31
Data File Options
http//factfinder.census.gov/
32
Select Geography
http//factfinder.census.gov/
33
Select Table
http//factfinder.census.gov/
34
Select Population Groups
http//factfinder.census.gov/
35
Search Result - Download
http//factfinder.census.gov/
36
Downloading
http//factfinder.census.gov/
37
Downloading
http//factfinder.census.gov/
38
Downloading
http//factfinder.census.gov/
39
Single Years of Age by RaceDetailed Tables
http//factfinder.census.gov/

• For Navajos over 100 for U.S. and Navajo
  Reservation, choose SF2, Detailed Tables

40
Single Years of Age by RaceDetailed Tables
http//factfinder.census.gov/
2. Choose Geography, United States, Highlight and
ADD, Then choose AI Areas, Navajo, and ADD.
41
Single Years of Age by Race Detailed Tables
http//factfinder.census.gov/

• .

3. Choose Table. If youre unsure of a table,
highlight it and click Whats This for a sample.
42
Single Years of Age by RaceDetailed Tables
http//factfinder.census.gov/
4. Highlight table, ADD, and click on NEXT.
43
Single Years of Age by RaceDetailed Tables
http//factfinder.census.gov/
5. Choose Population Group. Total is automatic.
You can highlight Navajo and ADD.
44
Single Years of Age by RaceDetailed Tables
http//factfinder.census.gov/
Table has single years through 100 for both sexes
and two population groups.
45
Navigating FactfinderDetailed Tables
http//factfinder.census.gov/
You can change geography, table, or population
using breadcrumbs
46
Navigating FactfinderDetailed Tables
http//factfinder.census.gov/
Click on Tables in the top breadcrumb. Choose
new table and remove the old.
47
Navigating FactfinderDetailed Tables
http//factfinder.census.gov/
You will need to re-choose your population group.
48
Navigating FactfinderDetailed Tables
http//factfinder.census.gov/
Family types in the U.S. and the Navajo
Reservation
49
Single Years of Age by RaceCustom Tables
http//factfinder.census.gov/
Custom tables allows you to choose individual
values in one or more tables.
Skip Examples
50
Single Years of Age by RaceCustom Tables
http//factfinder.census.gov/
1. Select Geography same as before
51
Single Years of Age by RaceCustom Tables
http//factfinder.census.gov/
2. Select Table same as before
52
Single Years of Age by RaceCustom Tables
http//factfinder.census.gov/
3. Select Data Elements Check off items in
middle box, ADD, and check them again before
going to NEXT
53
Single Years of Age by RaceCustom Tables
http//factfinder.census.gov/
4. NEXT to skip filters. Filters is a spreadsheet
function you can do with EXCEL.
54
Single Years of Age by RaceCustom Tables
http//factfinder.census.gov/
5. Choose Population Group. You can only choose
one at a time.
55
Single Years of Age by RaceCustom Tables
http//factfinder.census.gov/
Search Result. There are two printable pages but
you can download as one spreadsheet. Use
Population Groups breadcrumb to select same data
for Total Population.
56
Choosing a Tribal Focus

• National Map of Tribal Areas
• http//www.census.gov/geo/www/maps/aian_wall_
• map/aian_wall_map.htm
• Michigan Map of Tribal Areas
• http//www.lib.umich.edu/govdocs/images/michind.gi
  f
• Native American Reservations by State
• http//www.lib.umich.edu/govdocs/xls/aires2.xls
• Native American Tribes by State
• http//www.lib.umich.edu/govdocs/xls/aistate2.xls

57
Summary File 4http//factfinder.census.gov/
Most detailed socio-economic characteristics for
Native Americans and 39 tribes
58
Summary File 4-Subjectshttp//factfinder.census.g
ov/

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

59
Summary File 4

• Select Geography. You can mix the U.S., state,
• and individual reservations.

60
Summary File 4
2. Select tables. Options include SHOW ALL
TABLES (list), keyword, and subject searching.
61
Table Naming Conventionshttp//factfinder.census.
gov/

• P Population
• H Housing
• PCT Population (Detailed Tract
• Level)
• HCT Housing (Detailed Tract
• Level)

62
Table Searches

• SHOW ALL TABLES
• Lists tables by number (can be long)
• KEYWORD SEARCH
• Have to know Census Bureau terms
• SUBJECT SEARCH
• Use predefined list of terms

63
Summary File 4Subject Search
Highlight a subject (e.g. Education) and search
Results include all tables where the subject
is a variable
64
Summary File 4Population Group
Choose a population group (e.g. all American
Indians)
65
Summary File 4Educational Attainment

• Population over 25 is counted
• Data is not cumulative
• Even though high school graduation rate may be
  0, people who completed bachelors or masters
  completed high school as well

66
Summary File 4Educational Attainment
67
Summary File 4Occupationhttp//factfinder.census
.gov/
Industry where you work - Occupation what you
do
68
Summary File 4Labor Force

• Labor Force either have a job or are looking
  for a job
• Not in Labor Force dont have job or want one
  (e.g. retiree)
• Unemployed in labor force but dont have job

69
Summary File 4Labor Force
70
Summary File 4Income

• 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

71
Summary File 4Income
72
Summary File 4Poverty

• Calculated variable based on income, size of
  family, and federal poverty guidelines
• Poverty guidelines for 1999 appear at
• http//www.census.gov/hhes/www/poverty/threshld/th
  resh99.html
• Example of ratio of income to poverty
• Poverty for one person in 1999 was 8501
• Under .50 earned less than 4250
• Earned 1.5 of poverty12751

73
Summary File 4Poverty
74
UPDATING THE CENSUS

• Five year American Indian age groups by county
  (Census Bureau)
• Social and economic characteristics of 14
  reservations for 2006 (Factfinder)
• Social and economic characteristics of many
  tribes on a national basis for 2006 (IPUMS)

75
Determine Counties Covered by Reservationhttp//f
actfinder.census.gov
76
Population Estimates by Countyhttp//www.census.g
ov/popest/datasets.html

• Five year age groups by broad race (Native
  Americans) and sex and by county)
• Example
• (Do not use American Factfinder for this)

77
American Community Surveyhttp//factfinder.census
.gov

• Annual survey of Census topics
• Access through Data Sets
• U.S. States, Counties, County Groups (PUMAS) and
• Places of 65,000
• Fourteen Native American Reservations
• Cherokee OTSA, OK
• Cherokees of Southeast Alabama SDAISA, AL
• Cheyenne-Arapaho OTSA, OK
• Chickasaw OTSA, OK
• Choctaw OTSA, OK
• Citizen Potawatomi Nation-Absentee Shawnee OTSA,
  OK
• Coharie SDAISA, NC
• Creek OTSA, OK
• Echota Cherokee SDAISA, AL
• Four Winds Cherokee SDAISA, LA
• Kiowa-Comanche-Apache-Fort Sill Apache OTSA, OK
• Lumbee SDAISA, NC
• Navajo Nation Reservation and Off-Reservation
  Trust Land, AZ--NM--UT
• United Houma Nation SDAISA, LA

78
American Community Surveyhttp//factfinder.census
.gov
79
Change in Navajo Reservation
2000 2005 Median Age 24
25.2 High School Graduates 56
60.5 Unemployment Male 28
17 Unemployment Female 21
17 Median Household Inc 20,005
22,331 Poverty Rate 43
41 both sexes
80
American Community Survey Public Use
Microdata Samples

• Untabulated data so you can create your own
• More detailed on Native American tribes at a
  national level
• Resources
• Integrated Public Use Microdata Samples
• Assistance from Documents Center or Numeric and
  Spatial Data

81
American Community Survey Public Use
Microdata Samples
http//usa.ipums.org/usa/sda/
82
American Community Survey Public Use
Microdata Samples
Through PDQ Explore Educational
Attainment of Tohono OOodham, 2005
83
Citing Census Data

• Census Bureau
• http//www.census.gov/main/www/citation.html
• APA Style - Purdue
• http//owl.english.purdue.edu/handouts/research/r_
  apa.html
• Government Documents - Univ. of Memphis
• http//exlibris.memphis.edu/resource/unclesam/cite
  web.html

84
CDC Wonderhttp//wonder.cdc.gov/

• Many health files have racial breakdowns

85
CDC Wonderhttp//wonder.cdc.gov/

• Cause of AIAN Death by Age

86
CDC Wonderhttp//wonder.cdc.gov/

• Great source for mortality by underlying cause
• Use codes to specify state and disease
• EXAMPLE

87
CDC Wonder

• Deaths for other race in Apache and Maricopa
  Counties
• Diabetes in Tohono counties septicaemia in
  Navajo Counties
• EXAMPLE

88
Centers for Disease ControlData and
Statisticshttp//www.cdc.gov/DataStatistics/

• More comprehensive than CDC Wonder
• Subject approach by disease which brings in all
  surveys (e.g. asthma)
• Approach by survey for microdata
• Behavioral Risk Factor Surveillance System
• National Ambulatory Medical Care Survey
  National Hospital Discharge Survey
• National Health Interview Survey

89
Indian Health Servicehttp//www.ihs.gov/NonMed
icalPrograms/IHS_Stats/index.cfm?modulehqPubopti
onindex
90
Bureau of Indian Affairshttp//www.doi.gov/bia/
links.html
Especially valuable are its links to education,
justice, the environment and land rights
91
Statistical Universehttp//web.lexis-nexis.com/st
atuniv
You can search 400,000 tables by row, column,
title
92
Statistical Universehttp//web.lexis-nexis.com/st
atuniv
Type in keyword broken by race, frequency, time
period, need for Excel version
93
Statistical Universehttp//web.lexis-nexis.com/st
atuniv
Search Results
94
Statistical Universehttp//web.lexis-nexis.com/st
atuniv
Illustration is GIF also in Excel
95
Getting Census Help

• Documents Center
• 203 Hatcher Library North, [phone],
  govdocs_at_umich.edu
• http//www.lib.umich.edu/govdocs/
• Campus representative to the Census Bureaus
  State Data Center program.
• Assistance with American Factfinder, Census
  CD-ROMS.
• Referrals to other sources.

96
Getting Census Help

• Numeric and Spatial Data Service
• 203 Hatcher Library South, [phone]
• sand_at_umich.edu
• http//www.lib.umich.edu/sand/
• Experts in ArcView for the creation of Census
  maps
• Assistance in importing your own data to a Census
  map
• Downloads of boundary files