American Factfinder for Native American Profiles Epidemiology 552 September 2008 Ten States With the Largest American Indian Populations: 2000 AK 119,241 WA 158,940 MI 124,412 CA NY 171,581 NC 627,562 AZ OK NM 292,552 191,495 391,949 TX 215,599 131,736
Download ReportTranscript American Factfinder for Native American Profiles Epidemiology 552 September 2008 Ten States With the Largest American Indian Populations: 2000 AK 119,241 WA 158,940 MI 124,412 CA NY 171,581 NC 627,562 AZ OK NM 292,552 191,495 391,949 TX 215,599 131,736
American Factfinder for Native American Profiles Epidemiology 552 September 2008 Ten States With the Largest American Indian Populations: 2000 AK 119,241 WA 158,940 MI 124,412 CA NY 171,581 NC 627,562 AZ OK NM 292,552 191,495 391,949 TX 215,599 131,736 States With the Largest Percentage of American Indians: 2000 AK 15.6% SD 8.3% NM 9.5% Outline of Presentation Examples of Census Data Census Questionnaire Census Geography Creating a Profile of Native American area Updating the 2000 Census Class Materials Census Guide http://www.lib.umich.edu/govdocs/epidem.html Powerpoint Presentation http://www.lib.umich.edu/govdocs/epidem/epidem08.ppt Death Rates in IHS Areas Characteristics of Navajo Reservation Compared to the Nation Navajo National Median Age People in Families High School Graduates Unemployment – Male Unemployment – Female 24 94% 56% 28% 21% 35.6 83% 80% 6% 6% Median Household Inc Poverty Rate Homes w/o Full Plumbing $20,005 43% 45% $41,994 12% 1% Characteristics of Navajo Reservation Compared to Tohono Navajo Median Age People in Families High School Graduates Unemployment – Male Unemployment – Female Median Household Inc Poverty Rate Homes w/o Full Plumbing Tohono 24 94% 56% 28% 21% $20,005 43% 45% 26.2 93% 62.1% 31% 16% $19,970 46.4% 18.4% Two Questionnaires 100% Questionnaire Sent to all households SAMPLE Questionnaire Sent to one-sixth of households 2000 Questionnaire 100% Questionnaire Age Sex Race (Multiple) Hispanic origin Household relationship Occupied v. vacant housing units Owner v. renter occupied housing Race Groups in 2000 White Black or African-American American Indian or Alaskan Native Asian Hawaiian or Pacific Islander Other Two or More Races 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 Hispanic Not considered a race Can be Hispanic and any race Breakdowns in some tables Cuban Puerto Rican Mexican Spanish Various Latin American Countries 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 Household Relationships Relationship to Householder Spouse Child Stepchild Grandchild Brother/Sister Parent Non-relative Unmarried partner is separate category 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 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) 2000 Sample Questionnaire Employment Industry and occupation Transportation to and place of work Disability and mental illness Veteran status Income and poverty 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 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. Census Geography Legal Areas Nation State Native American Areas Counties Cities Townships Congressional Districts School Districts Census Geography Census-Designated Areas Metropolitan Statistical Area Urbanized Area Census Tract Block Group Block Zip Code Tabulation Area Metropolitan Statistical Area •Central city of 50,000 or more •Its own county, and •Surrounding counties with heavy commuting patterns Detroit Consolidated Metropolitan Statistical Area 1990 Detroit PMSA 2000 Lapeer Lapeer Livingston Macomb Macomb Detroit PMSA Monroe Monroe Oakland Oakland St. Clair St. Clair Wayne Wayne Lenawee Ann Arbor PMSA Washtenaw Ann Arbor PMSA Livingston Washtenaw Flint PMSA Genesee Census Tracts Areas of about 4000 people Approximate neighborhoods Detroit Tract 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) Creating Age Groups Using American Factfinder Data Files http://factfinder.census.gov/ Data File Options http://factfinder.census.gov/ Data File Options http://factfinder.census.gov/ Select Geography http://factfinder.census.gov/ Select Table http://factfinder.census.gov/ Select Population Groups http://factfinder.census.gov/ Search Result - Download http://factfinder.census.gov/ Downloading http://factfinder.census.gov/ Downloading http://factfinder.census.gov/ Downloading http://factfinder.census.gov/ Single Years of Age by Race Detailed Tables http://factfinder.census.gov/ 1. For Navajos over 100 for U.S. and Navajo Reservation, choose SF2, Detailed Tables Single Years of Age by Race Detailed Tables http://factfinder.census.gov/ 2. Choose Geography, United States, Highlight and ADD, Then choose AI Areas, Navajo, and ADD. Single Years of Age by Race Detailed Tables http://factfinder.census.gov/ . 3. Choose Table. If you’re unsure of a table, highlight it and click What’s This for a sample. Single Years of Age by Race Detailed Tables http://factfinder.census.gov/ 4. Highlight table, ADD, and click on NEXT. Single Years of Age by Race Detailed Tables http://factfinder.census.gov/ 5. Choose Population Group. Total is automatic. You can highlight Navajo and ADD. Single Years of Age by Race Detailed Tables http://factfinder.census.gov/ Table has single years through 100 for both sexes and two population groups. Navigating Factfinder Detailed Tables http://factfinder.census.gov/ You can change geography, table, or population using breadcrumbs Navigating Factfinder Detailed Tables http://factfinder.census.gov/ Click on Tables in the top breadcrumb. Choose new table and remove the old. Navigating Factfinder Detailed Tables http://factfinder.census.gov/ You will need to re-choose your population group. Navigating Factfinder Detailed Tables http://factfinder.census.gov/ Family types in the U.S. and the Navajo Reservation Single Years of Age by Race Custom Tables http://factfinder.census.gov/ Custom tables allows you to choose individual values in one or more tables. Skip Examples Single Years of Age by Race Custom Tables http://factfinder.census.gov/ 1. Select Geography – same as before Single Years of Age by Race Custom Tables http://factfinder.census.gov/ 2. Select Table – same as before Single Years of Age by Race Custom Tables http://factfinder.census.gov/ 3. Select Data Elements – Check off items in middle box, ADD, and check them again before going to NEXT Single Years of Age by Race Custom Tables http://factfinder.census.gov/ 4. NEXT to skip filters. Filters is a spreadsheet function you can do with EXCEL. Single Years of Age by Race Custom Tables http://factfinder.census.gov/ 5. Choose Population Group. You can only choose one at a time. Single Years of Age by Race Custom 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. 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.gif 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 Summary File 4 http://factfinder.census.gov/ Most detailed socio-economic characteristics for Native Americans and 39 tribes Summary File 4-Subjects http://factfinder.census.gov/ Ancestry Education and school enrollment Commuting, occupation, industry Income and poverty Disability and veteran status Housing value, rent, mortgages, plumbing Summary File 4 1. Select Geography. You can mix the U.S., state, and individual reservations. Summary File 4 2. Select tables. Options include SHOW ALL TABLES (list), keyword, and subject searching. Table Naming Conventions http://factfinder.census.gov/ P H PCT HCT Population Housing Population (Detailed – Tract Level) Housing (Detailed – Tract Level) 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 Summary File 4 Subject Search Highlight a subject (e.g. Education) and search Results include all tables where the subject is a variable Summary File 4 Population Group Choose a population group (e.g. all American Indians) Summary File 4 Educational 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 Summary File 4 Educational Attainment Summary File 4 Occupation http://factfinder.census.gov/ Industry = where you work - Occupation = what you do Summary File 4 Labor 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 4 Labor Force Summary File 4 Income 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 Summary File 4 Income Summary File 4 Poverty 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/thresh99. 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 poverty=$12751 Summary File 4 Poverty 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) Determine Counties Covered by Reservation http://factfinder.census.gov Population Estimates by County http://www.census.gov/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) American Community Survey http://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 American Community Survey http://factfinder.census.gov Change in Navajo Reservation 2000 Median Age 24 High School Graduates 56% Unemployment – Male 28% Unemployment – Female 21% Median Household Inc $20,005 Poverty Rate 43% *both sexes 2005 25.2 60.5% 17%* 17%* $22,331 41% 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 American Community Survey Public Use Microdata Samples http://usa.ipums.org/usa/sda/ American Community Survey Public Use Microdata Samples Through PDQ Explore Educational Attainment of Tohono O’Oodham, 2005 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/citeweb.html CDC Wonder http://wonder.cdc.gov/ Many health files have racial breakdowns CDC Wonder http://wonder.cdc.gov/ Cause of AIAN Death by Age CDC Wonder http://wonder.cdc.gov/ Great source for mortality by underlying cause Use codes to specify state and disease EXAMPLE CDC Wonder Deaths for other race in Apache and Maricopa Counties Diabetes in Tohono counties; septicaemia in Navajo Counties EXAMPLE Centers for Disease Control Data and Statistics http://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 Indian Health Service http://www.ihs.gov/NonMedicalPrograms/IHS_Stats/index.cf m?module=hqPub&option=index Bureau of Indian Affairs http://www.doi.gov/bia/links.html Especially valuable are its links to education, justice, the environment and land rights Statistical Universe http://web.lexis-nexis.com/statuniv You can search 400,000 tables by row, column, title Statistical Universe http://web.lexis-nexis.com/statuniv Type in keyword; broken by race, frequency, time period, need for Excel version Statistical Universe http://web.lexis-nexis.com/statuniv Search Results Statistical Universe http://web.lexis-nexis.com/statuniv Illustration is GIF; also in Excel Getting Census Help Documents Center 203 Hatcher Library North, (734) 764-0410, [email protected] http://www.lib.umich.edu/govdocs/ Campus representative to the Census Bureau’s State Data Center program. Assistance with American Factfinder, Census CDROMS. Referrals to other sources. Getting Census Help Numeric and Spatial Data Service 203 Hatcher Library South, (734) 615-7419 [email protected] 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