Indicators 1

Community Indicators

The following issues provide you with links to the discussion of the indicator as well as Excel Worksheets that allow you to do community comparisons and create customized bar charts. If you are using Windows 98 or earlier versions of Microsoft Excel, the Pivot Chart functions will not work (this is what allows you to select communities from a drop-down menu):

Mobility: A Culture On the Move - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here.
- PowerPoint presentation demonstrating how to download and manipulate this data from the Census Factfinder Web site
- Excel Worksheet*: Median Number of Years householder lived in current dwelling (You pick the Wisconsin communities you are interested in viewing)*.
  - Prior version (before 4/1/2004)
  - New! version
- Excel Worksheet*: Year householder moved into current dwelling (You pick the Wisconsin communities you are interested in viewing).
  - Prior version (before 4/1/2004)
  - New! version
- Excel Worksheet*: Where Did People Move From? (Data on WI communities which shows where people moved from between 1995-2000)
  - Prior version (before 4/1/2004)
  - New! version
Age COHORTS: New Insights on Population Data - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here.
- Excel Worksheet*: Age COHORTS (You pick the Wisconsin communities you are interested in viewing).
  - Prior version (before 4/1/2004)
  - New! version
- PowerPoint presentation demonstrating how to use the Excel Spreadsheet to obtain data and charts for any Wisconsin county or community.
Understanding Worker Flow Data - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here.
- An Excel Worksheet that calculates "self sufficiency" and the exporting/importing of jobs for all Wisconsin counties*
- Exel worksheet* with worker flow data by place of residence for Wisconsin cities, towns and villages. (Note: This is a large file, around 13MB)
- Exel worksheet* with worker flow data by place of work for Wisconsin cities, towns and villages. (Note: This is a large file, around 10 MB)
- County to county worker flow files for Wisconsin (Wisconsin Department of Workforce Development web site)
- U.S. Census worker flow files for all U.S. Counties (U.S. Census web site)
- The Regional Village: A report of a study of values and behaviors of residents of small Wisconsin villages, Robert N. Dick, University of Wisconsin Extension , August 1992 (This is a large 4 meg pdf file, as it is a scanned image of the report)
- Labor Market Resources (Authored by Gary Green, Department of Rural Sociology, U.W. Madison/U.W. Extension)
Location Quotients - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here.
- Excel Worksheet*: Location Quotients Pick any Wisconsin county or community. Then, pick up to ten other Wisconsin counties or communities as Comparison Communities.
- Power Point presentation: demonstrating how to use the Excel worksheet
- Community Economic Analysis: A How To Manual, Hustedde, Shaffer, and Pulver, Revised Edition, December 1993, NCRCRD. This manual is available in pdf file format on the EPA web site, or it may be ordered from the NCRCRD for $12.
- Location Quotient Calculator, U.S. Department of Labor
- Shift-Share Analysis Calculator, University of Georgia
Philanthropy: Does Charity Begin at Home? - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here.
- Excel Worksheet*: Philanthropy in Wisconsin
- The Catalogue for Philanthropy publishes an annual "Generosity Index" for all 50 states based on IRS tax return data. There is always a two year lag in the data, so the 2005 report is based on 2003 data. Unlike the Chronicle of Philanthropy study, this index makes no attempt to determine giving as a percentage of discretionary income. It would however, give you a sense as to whether chartitable giving was going up or down at the state and national level.
- "Center on Wealth and Philanthropy Charitable Giving Indices: Social Indicators of Philanthropy by State, Boston College, November 3, 2006
- Data on 501(c)(3) and Non-501(c)(3) organizations for all Wisconsin Counties (2005)
- Data on Revenues for 501(c)(3) organizations for all Wisconsin Counties (2004)
Get an Education and Double Your Salary (Part 1 of a 2-part series) - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here.
Get an Education and Double Your Salary (Part 2 of a 2-part series) - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here.
- Excel Worksheet*: Data on educational attainment levels for all Wisconsin Counties and Municipalities
- Job Training Publications (Authored by Gary Green, Department of Rural Sociology, U.W. Madison/U.W. Extension):
Increased Fuel Expenditures Flowing Out-of-State - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here.
- Excel Worksheet*: Estimated added fuel expenditures for all Wisconsin Counties, Cities, and Villages
- For an updated version of this issue (9-2-05, Click Here!)
- See Also, "The Impact of Rising Gas Costs on Wisconsin's Commuters"...The first issue of "Mapping Wisconsin's Economy"
- Sample News Release for this Community Indicator Issue - To be customized for your community (Microsoft Word file)
Self-Sufficiency: Defining Poverty - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here
- Excel Worksheet* includes the self-sufficiency estimates for all Wisconsin Counties and
  Tribes (2000 & 2004)
Keeping Them Down on the Farm - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here
- Excel Worksheet* includes national, state, and Wisconsin County data on the number of days that the principal farm operator worked off of farm (You have the option of selecting the county you are interested in from the drop-down menu and creating a pie chart to illustrate the data).
- Excel Worksheet * This worksheet includes national, state and Wisconsin County data on nontraditional ag sales for the years 1997 & 2002
- Map of the U.S. Data (Off Farm Employment Days) on the National Ag Statististics Service Web Site For access to dozens of Agricultural Atlas Maps, click here.
- Link to: Health Status, Use of Medical Services and Health Insurance Coverage: A Comparison Between Farmers, Other Self-Employed, and Wage/Salary Workers in Wisconsin
- For a copy of a County or State Profile on Agriculture, click here.
Increased Fuel Expenditures Flowing Out-of-State...Revisited (Updated to reflect increased fuel prices as of 9-2-05) - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here.
- Excel Worksheet*: Estimated added fuel expenditures for all Wisconsin Counties, Cities, and Villages (Updated to reflect increased fuel prices as of 9-2-05)
- New! Excel Worksheet*: Estimated added fuel expenditures for all Wisconsin Counties, Cities, and Villages (Updated to reflect increased fuel prices as of 6-30-08)
It's Tax Time: Do you know where Your Federal Tax Dollars are Going? -If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here.
- Excel Worksheet*: Federal expenditures and obligations data for Wisconsin Counties (2000-2004).
High Speed Internet Access - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here.
Increasing Public Investments in Economic Development - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here.
- Excel Worksheet* with data and charts on County expenditures for economic development activities
Lending Data Offers Insight Into Housing issues - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here
- A brief Powerpoint presentation illustrating how to access the data highlighted in this issue of the "Community Indicator Series"
County Foreclosure Data - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here
County Civil Court Data Is the Key to Understanding Foreclosure Issues - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here
- Excel Worksheet with Wisconsin County Foreclosure data from the Wisconsin’s Consolidated Court Automation Programs (CCAP) system. Includes data for Wisconsin's 72 Counties for the years 2000-2007 (now includes data for Portage County) .
  We will be providing quarterly updates on foreclosures by County for 2008. The first set of data is for Jan-April, future updates will be done in 3 month increments. A big thank-you to Dr. Russ Kashian, U.W. Whitewater and Ryan Wade, a student at Marquette University for their work on this effort. The updates are being funded by the UWEX Affordable Housing Team (Thank-you Laurie Boyce!):
  
  Data for 71 counties from Jan. 1 - April 30, 2008. This worksheet includes pivot charts which compares Jan-April, 2007 to the same period in 2008. The data includes the total number of civil mortgage foreclosure cases (all) as well as adjusted numbers which subtract multiple cases for the same property.
  
  Data for 71 counties for Jan-June, 2008 This worksheet includes pivot charts which compares Jan-June, 2007 to the same period in 2008. The data includes the total number of civil mortgage foreclosure cases (all) as well as adjusted numbers which subtract multiple cases for the same property.
  
  Data for 71 Counties for Jan-September, 2008. This worksheet includes pivot charts which compare January-September 2007 to January-September 2008 and the third quarter (July-Sept) 2007 to 2008. Simply select the counties you are interested in analzing from the drop down menu on each chart. Interestingly, while foreclosure civil cases were up 31.1% over 2007 for the period of January - September, foreclosure cases for the last quarter (July-September) were only up 6% over 2007.
  
  Maps providing insight into the foreclosure issue in Wisconsin (These maps were created by Matt Kures, Center for Community and Economic Development, UWEX):
  - Map showing properties facing foreclosure by county (2008 compared to 2007) (PDF Version, 300KB) (JPEG Version, 710 KB)
  - Map showing county ratios of the share of state foreclosure cases relative to the share of state housing units (PDF Version, 220 KB) (JPEG Version, 900 KB)
  - 2008 Foreclosure Data by County (with pivot charts making comparisons to 2000-2007 data).
  - Properties facing foreclosure by county (2007 compared to 2006)
  - Propeties facing foreclosure by zip code - 2007 (southern tier only)
  - HUD Neighborhood Stabilization Program estimated home foreclosure and Abandonment Risks by Census tract For an exanded view of Milwaukee County data see:
    - Milwaukee 18 month foreclosure rate for Milwaukee (HUD) & Milwaukee Abondonment Risks by Census tract
    - For more information on this data generated for the neighborhood Stabilization program , click here.
  - Subprime & High Interest Mortgages in 2006 by County (2006 HMDA Data) Maps - Data in Spreadsheet format.
  - Subprime & High Interest Mortgages in 2007 by County (2007 HMDA Data) Maps
  - Subprime & High Interest Mortgages in 2007 by Census Tract (2007 HMDA Data)
  - Maps: Foreclosure civil case data by census tract - These County maps show the number of foreclosure cases per 100 housing units by census tract (2005-2007). The first maps that will be available will be the Counties that have a CDBG entitlement area. The remaining counties will be posted the week of 12-8-09. There is also a link on this page to A spreadsheet containing the number of foreclosure cases by census tract (2005-2007). Or you can click here.
  - HUD Users Neighborhood Stabilization Program Data
  - Federal Reserve Bank of New York - Dynamic maps showing data from the second quarter of 2008 on mortgage delinquencies, bank card delinquencies, and nonprime mortgage conditions.
  - News release on 2008 foreclosures in Wisconsin
  - Presentation from Dr. Russ Kashian, University of Wisconsin-Whitewater Economics Department, to the Assembly Committee on Financial Institutions - February 11, 2009 (Power Point, 300 KB)
- Update on Foreclosure Issues in Wisconsin (2009) - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here
  - 2008 Foreclosure Data by County (with pivot charts for making comparisons to 2000-2007 data).
  - Data for 71 Counties for January - March 2009 (compared to first quarter 2008)
  - Maps: Foreclosure civil case data by census tract - These county maps show the number of foreclosure cases per 100 housing units by census tract (2005-2007). The first maps that will be available will be the Counties that have a CDBG entitlement area. The remaining counties will be posted the week of 12-8-09. There is also a link on this page to A spreadsheet containing the number of foreclosure cases by census tract (2005-2007). Or you can click here
  - Local and Regional Analysis of Foreclosure Cases (PDF, 5.8 MB) - Presentation by Dr. Russ Kashian, Andy Lewis and Matt Kures at the June 12, 2009 Milwaukee Community Development Forum. The Milwaukee Community Development Forum is sponsored by the Federal Reserve Bank of Chicago in cooperation with the University of Wisconsin-Milwaukee’s School of Continuing Education.
  - Second Quarter (Jan-June) 2009 Foreclosure Case Data for 71 Counties
  - Third Quarter (July-September) 2009 Data for 71 Counties
  - Fourth Quarter 2009 Data for 71 Counties with supplemental 2000-2009 data
  - First Quarter (Jan-March) 2010 Data for 71 Counties
  - Second Quarter (April-June) 2010 Data for 71 Counties
  - Third Quarter (July-September) 2010 Data for 71 Counties
  - Foreclosure Filing Trends and Distributions: State and Local Perspectives 2000 through 2010 - Presentation by CCED Specialist Matt Kures to the Dane County Foreclosure Task Force Meeting - December 8, 2010 (Power Point, 34.3 MB) (PDF, 8.9 MB)
  - Foreclosures in Dane County - Presentation by Jeff Becker, GIS Certificate Student at UW-Madison, to the Dane County Foreclosure Task Force Meeting - December 8, 2010 (Power Point, 19.7 MB) (PDF, 6.8 MB)
  - Map of County-by-County Annual Foreclosure Case Filings 2009 to 2010 (JPEG, 1.2 MB) (PDF, 0.4 MB)
- Bankruptcy: A Growing Problem - If you would prefer a Microsoft Word version of the document that you could edit for pieces like your own newsletter, click here
  - Bankruptcy Data by County (with pivot charts for making comparisons from 2006-2008)

*Note: Excel worksheets are best viewed by saving the file to disk and then viewing the file within Excel rather then opening the file from its current location. If your browser is not configured in a way that prompts you for the option you would prefer, you can right click on an Excel hypertext link, and select "save target as", and then determine where you would like to place the file on your system (file name and directory).

	© 2001-2006 Board of Regents of the University of Wisconsin System, doing business as the Division of Cooperative Extension of University of Wisconsin-Extension. For more information, questions and comments, please contact the web manager at: cced@uwex.edu
If you have trouble accessing this page, require this information in an alternative format or wish to request a reasonable accommodation because of a disability contact: cced@uwex.edu. University of Wisconsin-Extension - Cooperative Extension, University of Wisconsin-Extension