Where Workers Live

ECONOMIC SNAPSHOTS

Where Workers Live: Part 1

Where Workers Live is one of the most popular and effective Economic Snapshots . Published in two installments in the Wisconsin State Journal, these Snapshots dramatically demonstrate worker flow. Andy and I share worker flow data in most communities we visit. The reaction is always the same – surprise and a lively discussion.

These examples use Madison and Dane County. More information about worker flow and similar data for most Wisconsin communities is readily available through Community INDICATORS at: Understanding Worker Flow.

To create a similar SNAPSHOT for Wisconsin communities

step 1: getting the data This one is almost too easy. You can create similar data for any place in Wisconsin by going to the: Worker Flow Community INDICATOR or even easier, just click here and download the New! Exel worksheet* with worker flow data by place of residence for Wisconsin cities, towns and villages. (Note: This is a large file, around 13MB)

step 2: selecting the communities Open the Excel spreadsheet and go to the Instructions tab and follow the instructions.

Or, go directly to the data tabs and use the pivot tables to select the appropriate geography.

The data is organized alphabetically so, be sure you go to the right tab. The TOP25 Adams-Richland tab provides data for the top twenty five places workers in the selected community live. To view all the data, go to the Table Adams-Richland data tab.

To create a similar SNAPSHOT for any county in the United States

step 1: getting the data Data for counties outside of Wisconsin is availalble through the U.S. Census.

step 2: selecting the county Simply select the appropriate state and download the Excel spreadsheet.

If you have questions, contact Bill Pinkovitz.

If you would like to examine worker flow over time, simply go to: Where Workers Live Part 2

ECONOMIC SNAPSHOT

Wisconsin State Journal

March 13, 2005

Where the workers live

A total of 174,108 people worked in the City of Madison in 2000. Only about half (53.8%) also lived in the City. More than 80,000 people worked in Madison, but lived outside of the City. Similar data for every community in Wisconsin is available at Understanding Worker Flow.

MADISON WORKERS’ PLACE OF RESIDENCE

Residence	Number Working in Madison	Percent
Madison	93,887	53.8%
Dane County (not Madison)	59,763	34.3%
Outside of Dane County	20,458	11.7%
Total	174,108

QUESTIONS: Send questions, comments to UW-Extensionprofessor Bill Pinkovitz at: bill.pinkovitz@uwex.edu

THE OTHER SIDE OF THE COIN

Where Local Residents Work

The other side of the equation, where local residents work also provides some valuable information and insights.

An example: In 2000, Brillion, Wisconsin had a population of about 2,900. The New Excel™ Worksheet with worker flow data by place of residence shows that in 2000, over 600 Brillion residents worked outside of Calumet County.

The New Excel™ Worksheet with worker flow data by place of work (Where Workers Live) reveals that over 2,500 people worked in Brilllion, Wisconsin in 2000. However, 881 of the people working in Brillion also lived Brillion.

Each workday, 600 Brillion residents leave the county to work while over 2,500 people travel to work in Brillion from outside the City.

	© 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