Definitions for the 2000 Census appear in the Appendix B to the Summary File 3 Technical Documentation

Chapter 7: Data Dictionary [http://www.lib.umich.edu/govdocs/census2/sf3td/sf3td7.pdf] - 1.6 M (all individual variables in all tables with codes).

Appendix G: CODE LISTS

• Ancestry [http://www.lib.umich.edu/govdocs/census2/sf3td/sf3tdg1.pdf] - 60K
• Group Quarters [http://www.lib.umich.edu/govdocs/census2/sf3td/sf3tdg2.pdf] - 56K
• Hispanic [http://www.lib.umich.edu/govdocs/census2/sf3td/sf3tdg3.pdf] - 26K
• Industry [http://www.lib.umich.edu/govdocs/census2/sf3td/sf3tdg4.pdf] - 59K
• Language [http://www.lib.umich.edu/govdocs/census2/sf3td/sf3tdg5.pdf] - 50K
• Occupation [http://www.lib.umich.edu/govdocs/census2/sf3td/sf3tdg6.pdf] - 92K
• Race [http://www.lib.umich.edu/govdocs/census2/sf3td/sf3tdg7.pdf] - 115K
• States and Foreign Countries [http://www.lib.umich.edu/govdocs/census2/sf3td/sf3tdg8.pdf] - 42K

• Multiple Races. The 2000 Census permitted people to choose multiple races. They are tabulated into six categories: white; black or African-American, American Indian or Alaska native; Asian; native Hawaiian or other Pacific Most tables also have a seventh category named Two or More Races. Approximately 2-3% of all people reported multiple races in the 2000 Census Many people believe the 2000 racial data is not comparable to 1990.

  There were only five (rather than seven) standard tabulations in 1990. These include white, black, Asian or Pacific Islander (Asian Indian, Chinese, Filipino, Guamanian, Hawaiian, Japanese, Korean, Samoan, Vietnamese, other) American Indian (or Alaska Native) and other.

• Hispanic. Hispanic is not a race so is usually covered in a separate table. Some tables provide data for Mexican, Puerto Rican, Cuban, and other. The Hispanic question was asked after the racial question in 1990. The Hispanic question was asked before the racial question in 2000 so may be more accurate.

• Arab. The Arab population is considered white in the 100% data (Summary File 1). Summary File 3 (sample data) lists Arab as an ancestry.

• Labor Force. Labor force participation includes people who have jobs or want them. Reasons for not participating in the labor force include age, disability, family matters, retirement, school enrollment, etc.

• Unemployment. Unemployment is calculated by dividing the people who want jobs but don't have them by the labor force.

• Income. Income is calculated for households (families, people living alone, people living together but not related), families (related by blood or marriage), individuals, and per capita (including children).

• Median = half below level and half above level; Mean = average.

• Poverty. Poverty rates are calculated by the Census Bureau using the family income, the size of family, and poverty levels it establishes annually inflated from the original 1964 figures. Poverty rates are available for families and persons but not for households.

• Group Quarters. The category includes institutionalized people (nursing homes, mental institutions, prisons) and non-institutionalized people (college dorms and military quarters).

State
	Metro Area
		County
			Place
				Census Tract
					Block Group
						Block

Primary vehicle for the distribution of 2000 Census data with numerous files from the 1990 Census of Population and Housing, American Community Survey, and the 2002 Economic Censuses (employment, payrolls and receipts of business establishments.

Use Mozilla for the best downloading.

Main navigation section is on the lefthand side. It includes Data Sets and Address Search.

REFERENCE MAPS provides mapping of states, counties, cities, census tracts, block groups, and blocks with the numbered areas identified. Also includes American Indian reservations, 3-5 digit zip codes, Congressional Districts, and state legislative districts.

Enter through ADDRESS SEARCH even if you don't know an address. Do a Name Search for a city or county if you don't know a geography number, such as tract or block group number.

Zoom in for more detail. Boundaries, features, and years can be changed by using the legend and updating it.

THEMATIC MAPS illustrate selected population and housing items using classes of numbers and percentages.

Enter through the Thematic Maps section of Data Sets/Summary File 3

Choose the largest geographic level you need and use a pulldown box to change the display to a subgeography (e.g. tract, county, county subdivision).

Use the legend to add features and boundaries.

Right-click on the mouse to download in gif format; use the download button at the top to download in pdf format.

DATA SETS is the major data access point. It includes links to 2000 and 1990 Decennial Censuses, American Community Survey, and 1997 Economic Census. Summary File 3 in the 2000 Census is the most important file.

1. Choose Geography. You can choose multiple levels using the List Geography method, e.g. state, county, city, several census tracts, and block groups. Whole census tracts are preferable to block groups.

2. Choose Tables. The best method to choose them is the Subject Search

3. In Summary File 3, the most important tables are:

   P6 and 7: Race and Hispanic Origin
   P10: Household Living Arrangements (P146A-I by race)
   P37: Educational Attainment of people 25+ (P148A-I by race)
   P41: Basic Disability Data
   P43: Employment Status
   P50: Occupation
   P53: Median Household Income (P152A-I by race)
   P87: Poverty Status by Age Group (P159A-I by race
   H6: Occupied v. Vacant Housing
   H54: Median Contract Rent
   H76: Median Housing Value
   PCT 16: Ancestry

4. Data can be downloaded in comma-delimited and EXCEL formats as is or with columns and rows transposed. All four formats label the rows and columns. Tables can also be downloaded in a comma delimited format ready for manipulation with large statistical packages. The rows and columns have coded rather than alphabetic header and are zipped. Spreadsheet Templates.

Michigan County and City Web Sites

http://www.lib.umich.edu/govdocs/michloc.html

Probably the most comprehensive web page for Michigan county and city government web sites.

Michigan County Profiles. http://medc.michigan.org/miinfo/places/

Extensive descriptive and statistical information on Michigan's 83 counties. Geography, current labor force data, transportation lines, earnings by industry and selected occupation, number of industrial establishments, names of banks, colleges, major employers and utilities. Hospitals are listed in terms of numbers and beds and also as major employers.

Geographic Area: Michigan counties

Time Period: Current issue includes data from various dates

County and City Data Book, 1944-2000 http://fisher.lib.virginia.edu/collections/stats/ccdb/

Summary demographic and vital statistics; employment, education, government, housing, production and weather data. The population and economic censuses form the basis data also includes copyrighted material on community hospital beds. For states, counties, and all cities of 25,000+. To choose multiple geographic areas, click on the first area with a mouse; press the control key and click on the next area. The output may be sorted geographically or by value of the variable. The 2000 data is available in pdf format from the Census Bureau at http://www.census.gov/statab/www/ccdb.html

Geographic Area: Nation , states, counties and large cities.

Time Period:1994 and 2000.

USA Counties

http://censtats.census.gov/usa/usa.shtml

Population and housing variables (age, ancestry, race, education, income, and poverty for each county in the nation with some updates from the Current Population Survey. 2002 economic census data (manufacturing, wholesale trade, retail trade, service industries) as well as government employment and finance. Non-Census data includes federal funds, current employment data from the Bureau of Labor Statistics, crime, election, health, Social Security beneficiaries, and vital statistics (births, marriages, deaths, 1960-94). Data may be retrieved for an individual county or comparisons between counties can be requested

Geographic Area: U.S., states and counties

Time Period: Primarily 2000 and 2002 with some data from selected years beginning 1960 and some as current as 2005.

Detroit Renaissance Zones

http://medc.michigan.org/services/sitedevelopment/renzone/WayneCounty/

Description of Detroit's 14 renaissance zones. Wayne State University provides an excellent map of tracts in Renaissance Zones at http://www.cus.wayne.edu/content/maps/Det-empzone-2000-HU.pdf.

Michigan County Profiles.

http://medc.michigan.org/miinfo/places/

Extensive descriptive and statistical information on Michigan's 83 counties. Geography, current labor force data, transportation lines, earnings by industry and selected occupation, number of industrial establishments, names of banks, colleges, major employers and utilities. Hospitals are listed in terms of numbers and beds and also as major employers.

Geographic Area: Michigan counties

Time Period: Current issue includes data from various dates

County Business Patterns

(http://censtats.census.gov/cbpnaic/cbpnaic.shtml)

Number of establishments, employees and payrolls in various private medical clinics (SIC 801-805) and hospitals (806) by county or zip code, 1998-2003.

Geographic Area: State, county, zip code.

Time Period: 1998-2003

Economic Census: 2002 (http://www.census.gov/econ/census02/guide/geosumm.htm

The Geographic Area Reports of the 2002 Economic Census usually provide state, county and city data by very small industry group. Private health care clinics appears in the Health Care and Social Assistance section. Data is available both through this link and through American Factfinder [http://factfinder.census.gov/] The zip code reports will not be published until later in 2006 so use County Business Patterns [http://censtats.census.gov/cbpnaic/cbpnaic.shtml] instead.

Geographic Area: Nation , states, counties and large cities.

Time Period: 2002

Yellow Pages

http://www.yellowpages.com/

Search by city and type of business or church.

Detroit Police Department

Doc. Cen. HV 7595 .D6 A23 - http://www.ci.detroit.mi.us/police/default.htm

The CompStat section has citywide data by type of crime for about then years. For tract level data use Wayne State University's Detroit Crime Barometer, October 2005 at: http://www.cus.wayne.edu/content/publications/Detroit%20Crime%20Barometer%20October%202005.pdf. Taking Stock of Neighborhoods [http://gis.culma.wayne.edu/] is being reconfigured to ultimately provide interactive mapping. See the Michigan Uniform Crime Report [http://www.michigan.gov/msp/0,1607,7-123-1645_3501_4621---,00.html] for Detroit arrests by crime, age, race, and sex.

Uniform Crime Reports

http://www.fbi.gov/ucr/ucr.htm

Full text of national, state, and place (10,000+ population) in Adobe Acrobat format. Preliminary data for the nation and places of 100,000 or more in text (ASCII)format.

Michigan Local Area Unemployment Statistics

(http://www.milmi.org/cgi/dataanalysis/AreaSelection.asp?tableName=Labforce)

Monthly employment and unemployment for counties and subcounty areas since 1990.

Geographic Area:Michigan and counties

Time Period: Monthly since 1990

Michigan County Profiles

http://medc.michigan.org/miinfo/places/

Extensive descriptive and statistical information on Michigan's 83 counties. Geography, current labor force data, transportation lines, earnings by industry and selected occupation, number of industrial establishments, names of banks, colleges, major employers and utilities. Hospitals are listed in terms of numbers and beds and also as major employers.

Geographic Area: Michigan counties

Time Period: Current issue includes data from various dates

Local Area Unemployment Statistics

http://data.bls.gov/cgi-bin/dsrv?la

State, county, and city employment and unemployment numbers as well as unemployment rates by month since 1990.

Chemical Scorecard/Environmental Defense Fund

http://www.scorecard.org/ranking/

Ranks states, counties and zip codes by amount of chemical pollution. The top 100 counties and zip codes are ranked for both the U.S. and individual states. Click on area to obtain data on pollution by chemical or health effect. Includes maps of an area and reports on individual polluters. Lists street address and zip code of facility. Example of map

Geographic Area: U.S., states, counties, and zip codes.

Time Period: Current.

Superfund National Priorities List

http://www.epa.gov/superfund/sites/index.htm

EPA's priorities for toxic waste cleanup. Click on state maps to identify concentrations of polluters. Example. By clicking on a symbol, you can obtain background information on the polluter. You can also search the data by address, zip code, or type of problem. The resulting maps (example) provide streets but not street names. Links to the individual polluter.

Geographic Area: U.S., city, zip code.

Time Period: Current.

Hispanic Community in Metropolitan Detroit

http://web.archive.org/web/20050830203634/http://comnet.org/hispanic/

Demographics and maps of the Hispanic community in Southeast Michigan as well as cultural values and public policy issues. Includes directories of Hispanic organizations (professional, cultural, health) and churches as well as museums and training programs. Prepared by United Way of Southeastern Michigan and Michigan Comnet.

Mosaic of Middle Eastern Communities Metropolitan Detroit

http://web.archive.org/web/20050105144729/comnet.org/mecs/

The report describes the difficulty in defining the community and public policy issues. Maps locate individual middle eastern communities (Lebanese, Iraqi) and social service organizations.

Detroit

http://www.ci.detroit.mi.us/

Main page links directly to police and fire precincts, libraries, and the municipal code. Links to city departments are at the top and city council at the bottom.

Detroit Municipal Code

http://www.municode.com/resources/gateway.asp?pid=10649&sid=22

Current city laws arranged by chapter.

Municipal Codes

http://www.municode.com/resources/online%20Library.asp

Full text of city codes and zoning ordinances for numerous places in the country. The Detroit code is available at http://www.municode.com/resources/gateway.asp?pid=10649&sid=22

Piper State and Local Government on the Net

http://www.statelocalgov.net/index.cfm

Most reliable list of local government web sites arranged by state.

American Hospital Directory.

(http://www.ahd.com/)

Search for hospitals by name, state, city, or three-digit zip code. Free data includes Medicare data on disease treated by type for individual hospitals. More detail available through license.

Geographic Area: Individual hospitals.

Time Period: Current

Detroit Health and Wellness Promotion Department

http://www.dethealth.org/

Statistics previously published by this agency are no longer available on the web. Primarily devoted to disease prevention and reporting. Use Michigan Community Health Indicators [http://www.mdch.state.mi.us/pha/osr/chi/index.asp] for city data.

Geographic Area: City of Detroit

Time Period: Current

Michigan Community Health Indicators

http://www.mdch.state.mi.us/pha/osr/chi/index.asp

County profiles provide marriage, divorce, and birth statistics, the latter by race and for mothers under 18. Also covers nursing care facilities, preventable hospitalizations and communicable diseases.

Geographic Area: Michigan, health regions, county.

Time Period: Current

Michigan Critical Health Indicators

( http://www.michigan.gov/mdch/0,1607,7-132--17501--,00.html)

Textual report compares Michigan with the nation on mortality causes and health risk behaviors (overweight, smoking). Some factsheets have county maps.

Geographic Area: U.S., Michigan and some county data.

Time Period: Primarily current with some data back to 1982.

Michigan Traffic Crash Facts (UMTRI)

( http://www.michigantrafficcrashfacts.org/index.htm

Annual county and community traffic accidents by age of driver and victim, cause of accident, severity, alcohol use, and seat belt use.

Geographic Area: Michigan, county and city data.

Time Period: Current.

Preventable Hospitalizations

http://www.mdch.state.mi.us/PHA/OSR/chi/hosp/frame.html

Preventable hospitalizations by age, 1991-98, by type: congestive heart failure, bacterial pneumonia, asthma, chronic obstructive pulmonary, kidney/urinary infections, dehydration, cellulitis, diabetes, angina, convulsions, all other.

Use the lefthand frame. Click on Community Trends/Your County. At the next frame, click on the second line, You can also select a county. Choose a county from the box and click on View. Then select a leading diagnosis.

Geographic Area: Michigan and County.

Time Period: 1991-2002.

American Hospital Directory.

(http://www.ahd.com/)

Search for hospitals by name, state, city, or three-digit zip code. Free data includes Medicare data on disease treated by type for individual hospitals. More detail available through license.

Geographic Area: Individual hospitals.

Time Period: Current

CDC Wonder. (http://wonder.cdc.gov/)

Subjects include mortality, natality, AIDS, STDs, fluoridation, Census. Some data broken down by state or local area (e.g. death of black women by age and county and disease) or American Indian (leading causes of death, cancer, AIDS, natality, tuberculosis.

Geographic Area: U.S., states, and counties.

Time Period: 1979 to present.

Assistance Payments Statistics. (Doc.Cen. HV 86 .M5)

Monthly data on people and social assistance payments by type and county. The most current month's data is also on the web at http://www.michigan.gov/dhs/0,1607,7-124-5458_7696_10830---,00.html

Geographic Area: Michigan and counties

Time Period: Monthly, 1980s to present.

American Community Survey

http://factfinder.census.gov/

Enter through DATA SETS/AMERICAN COMMUNITY SURVEY/2005 SURVEY/DETAILED TABLES. Choose place (Detroit or other place) and do a keyword search to identify income and poverty estimates. Place level is the lowest unit of geography for these updates.

CACI Sourcebook of Demographics for Every Zip Code

(Doc. Cen. HA 203 .S661 - Stat. Ref.)

Annual estimates and projections of households, race, age, sex, and household income for zip codes.

Demographics USA

(Documents Center Microfiche SRI)

Current population estimates and projections, occupation, employment by industry, and sales. Microfiche only.

States: SRI Fiche C1200-2
Cities: SRI Fiche C1200-7
Zip Codes: SRI Fiche C1200-6

Federal Financial Institutions Examination Council Census Reports

(http://www.ffiec.gov/webcensus/ffieccensus.htm)

Choose state and then county or MSA. Reports provide estimated family income data for the current year (e.g. 2005) by Census tract number with a comparison to 2000 data and a ranking (low, middle, moderate, etc.). Most of the remaining data comes from the 2000 Census. Reports meant to monitor fairness in granting mortgages.

Ann Arbor News

http://mlive.com/aanews/

Free news articles for past 14 days. The full text since July 1, 2004 is available to University of Michigan users through Newsbank, http://infoweb.newsbank.com/?db=AARB

Detroit News

http://www.detnews.com/

Selected articles only. The full text since 1999 is available to University of Michigan users through Newsbank, http://infoweb.newsbank.com/?db=DTNB

Detroit Free Press

http://www.freep.com/

Selected articles only. The full text since 1982 is available to University of Michigan users through Newsbank, http://infoweb.newsbank.com/?db=DFPB

Access World News

http://infoweb.newsbank.com/?db=AWNB

Index and full text of 600 U.S. Newspapers, roughly since 1999.

Lexis-Nexis Universe

http://web.lexis-nexis.com/universe

Use Guided News Search/U.S. News for the full text of numerous U.S. newspapers since the mid-1990s.

Detroit City Council

http://www3.ci. detroit.mi.us/legislative/CityCouncil/Default.htm

Rules of the council and biographies of council members. Extensive list of city services for neighborhoods. See also Newspapers.

Almanac of American Politics

http://nationaljournal.com/ubs/almanac

Information about Detroit's representatives to Congress includes election data, lobby group ratings, effectiveness, and political descriptions of their districts. See also Newspapers.

Southeast Michigan Council of Governments

(http://www.semcog.org/)

County and city census data and updates for Livingston, Macomb, Monroe, Oakland, St. Clair, Washtenaw, and Wayne Counties. Estimates and projections of population and housing, jobs. Land use summaries and residential construction.

CACI Sourcebook of Demographics for Every Zip Code

(Doc. Cen. HA 203 .S661 - Stat. Ref.)

Annual estimates and projections of households, race, age, sex, and household income for zip codes.

Census Bureau Population Estimates

http://www.census.gov/popest/estimates.php

Annual county population estimates by age, race and sex. Includes births, deaths, international, and domestic migration. Use top menu to access city and township estimates for total population.

Demographics USA

(Documents Center Microfiche SRI)

Current population estimates and projections, occupation, employment by industry, and sales. Microfiche only.

States: SRI Fiche C1200-2
Cities: SRI Fiche C1200-7
Zip Codes: SRI Fiche C1200-6

Best Places Net

http://www.bestplaces.net/default.aspx

Compare two U.S. cities by crime, housing, economic, education, health and climate factors.

Best Places to Live (Money Magazine)

http://money.cnn.com/best/bplive/

Ranks 300 cities to live by economy, health, crime, housing, education, weather,leisure, transit, arts. City pages include a description and relocation information as well as statistical data on the quality of life and the cost of living. Interactive interface permits the user to create own rankings.

Cost of Living Index. (American Chamber of Commerce)

Doc.Cen. HD 6983 .A67

Compares total costs between urban areas with component data ongroceries, housing, utilities, transportation, health care, and miscellaneous goods. 100=average so 1.25 would indicate an urban area was 25% more expensive than average. Individual prices for various goods and services also given Participation in the program is voluntary so not all urban areas are included.

Libraries

Michigan Library Directory [http://envoy.libofmich.lib.mi.us/isapi/4disapi.dll/directory/search.html] is a searchable directory of libraries in the state and links to their home pages. Libweb [http://lists.webjunction.org/libweb/] is a directory of library web pages around the country. The American Library Directory [Grad and Undergrad Reference Z 731 .A513] describes individual library collections and personnel in the United States and Canada.

Virtual Relocation

http://www.moving.com/Find_a_Place/Cityprofile/

Compares cost of living index (100=average) between any two of 800 U.S. cities. Includes comparisons on 2000 square foot homes, property and sales taxes, income tax, median household income, crime, education, auto insurance and the weather.

American Religion Data Archive

http://www.thearda.com/mapsReports/

Access church membership by county for 2000.

Geographic Area: Counties

Time Period: 1952-20000

Smart Pages

http://www.yellowpages.com/

Search by city and type of business or church.

Detroit Public Schools

http://www.detroit.k12.mi.us/index.shtml

Description of 2007 proposed school closings. School attendance districts and MEAP scores.

National Public School Locator

http://nces.ed.gov/ccd/schoolsearch/

Locate individual elementary or secondary schools or school districts by name, district, telephone number, or enrollment. Data includes location, number of teachers and students, student/teacher ratio, students by grade and ethnicity/race. Separate search engine for school districts.

Standard and Poor's School Evaluation Service

http://www.schoolmatters.com/

Evaluates individual schools and school districts. Factors include state test scores, drop-out rates, students per staff, school size, school building, financing, and demographics. Compares individual districts to the county and state. Temporarily down, February 2004

Inside Southwest Detroit

http://www.insidesouthwest.com/

Virtual tour of the area, culture, and historic buildings.

Southwest Counseling and Development Services

http://www.swcds.org/

Offers mental health services to the area.

Southwest Detroit Business Association

http://www.southwestdetroit.com/

Lists area businesses by subject and includes future business development plans.

Southwest Detroit Environmental Vision

http://www.sdevonline.org/

Organization fights toxic dumping, programs to green the schoolyards.

United Way of Southeast Michigan

http://www.uwsem.org/insideuw/agencies.html

Alphabetical list of social services, a brief description, and telephone number.

Associations Unlimited

http://galenet.galegroup.com/servlet/AU?locID=umuser

Do a CUSTOM SEARCH by city and the subject heading "Social Welfare Organizations."

Bus Schedules

http://www.detroitmi.gov/ddot/index.html

Detroit bus routes and schedules in pdf format.

Census Data

http://factfinder.census.gov

See Detailed Tables/Summary File 3. Vehicles available appears in tables H44, H45, and HCT33. Commuting to work appears in P30-35 and PCT65.

Statistical Abstract of the United States.

(Doc. Cen. HA 202) http://www.census.gov/compendia/statab/

Compendium of government and non-government statistics, primarily on the national and state levels. Population and vital statistics, health, economics, education, manufacturing, natural resources, transportation. Full text available in Adobe Acrobat format retrievable by chapter. State rankings and state/county profiles in HTML format.A searchable copy with individual tables in gif, xls and csv format is available through Statistical Universe. Historical pdf versions of Statistical Abstract are available from the Census Bureau web site for 1878-1929, 1953-58, and 1995+

Geographic Area: U.S. and states.

Time Period: Current volume at various years since 1960.

FedStats.

http://www.fedstats.gov/

Comprehensive listing to statistical programs of over 70 federal government agencies. Arranged by agency or program; includes explanatory material and contacts. Search engine indexes individual statistical tables by keyword or agency and provides direct connection

Geographic Area: All levels.

Time Period: Varies.

Statistical Resources on the Web.

http://www.lib.umich.edu/govdocs/stats.html)

Annotated guide to government and non-government web sites at a national and international level. Covers agriculture, energy, environment, demographic, and economics. Indicates substate geography when available.

Geographic Area International, Foreign, United States with some state and local.

Time Period: Primarily 1993+

Statistical Universe.

http://web.lexis-nexis.com/statuniv/ (U Mich Only)

Indexes federal government statistical tables since 1974, business and state government publications since 1980, and international agency publications since 1983. Keyword approach includes category searches (by type of geographic area, economic factor, or demographic characteristic). Only about 10% of the publications are linked via the Internet. All publications are available on microfiche in the Documents Center.

Geographic Area: Foreign, international, U.S., state, county, city, census tract, zip code, block group.

Time Period: Primarily 1973+

Illustrated guide to using Excel, including transposing rows and columns, ranking and filtering data, converting Adobe Acrobat files into Excel.

Grace York, Coordinator, Documents Center
The University of Michigan Library
govdocs@umich.edu

http://www.lib.umich.edu/govdocs/compsych.html