Local government data exercise

I. State and local

Using the online resource www.census.gov, answer the following questions:

1. What’s the population of Washington state?-6,664,195

a. What's the percent change since 2000?- 11.56%

b. Go back to the main page. Now look at 'Washington' under the 'Area Profile with QuickFacts.' What's the median household income?- 58,081

2. Now look at Whitman County.

a. What's the population?- 41,664

b. Percent white?- 86.6%

c. Percent with bachelor’s degree?-44%

d. Median household income?- $39,691

e. Persons below poverty?- 23.7%

3. Let's go deeper. Click on 'Browse data sets for Whitman County.' You'll find a slew of entry points into the U.S. Census Bureau database. This is a great area if you're interested in finding a particular fact (how much federal $ came into the county last year), as well as if you're just browsing, looking for a little light reading.

Click on the 'Building Permits 2009.'

a. Find the annual construction costs for building permits for Pullman from 2004 to 2008. Report it for each individual year.

2004-26,250,489

2005-46,479,544

2006-40,499,193

2007- 38,770,838

2008-20,019,498

b. What’s the most current construction cost for 2009? (Obviously the annual report isn’t yet available, but we can look at the December 2009 report to get the cumulative construction cost.)- 10,398,856

c. Write a lede based on this information.

Annual construction costs for building permits in Pullman, Wa. have dropped by about $30 million since 2006.

4. Let’s take another big national issue: Health insurance. Return to census.gov.

Click on the QuickFacts page, and then Washington state. Click on 'Browse data sets for Whitman County.'

a. Under People Quick Links, locate “2005 Health Insurance Coverage.

b. Choose Washington and then ‘Submit.’

1. Which two counties have the highest percent of uninsured people?- king and pierce

2. What’s the percentage in Whitman County?-9,118

II. Federal grants and insurance

Who needs government? Well, Whitman County certainly received some federal help last year. But we want to know how much.

But fumbling through this site can be cumbersome. Plus, the Census Bureau isn't the only government site with information on Whitman County. If only there were an easier way to search all these sites at once (ah, but there is!)

Google/unclesam is a powerful tool that let’s us search all “.gov” Web sites. Go to the search bar and type “Whitman County Consolidated Federal Funds Report.”

a. Click on the first two links and try to find the the report. Any luck? Let's try the third, which takes us to the Office of Financial Management, which overseas $ going into and out of the state of Washington.

b. Click or search for 'Consolidated Federal Funds Report.' At the top of the page, click on 'Online Query System.'

c. Under ‘Available Data,’ choose 2008 and Geography (Federal data almost always lags a year behind). Click ‘Submit.’

d. On the next page, choose ‘Washington’ and ‘Yes’ on County. We want ‘All Fund Types.’

e. On the next page, choose Whitman County.

1. How much did Whitman County farmers receive in Crop Insurance?

5,191,477

2. How much did Whitman County receive in grants (block, formula, project,

etc.)? - 122,982,596

3. Name three of the grants.- FORMULA, PROJECT, AND COOPERATIVE AGREEMENTS

III. Population

Is Whitman County’s population growing? Let’s look at population trends.

1. Type “Whitman County population" into Google Uncle Sam. We've looked at the Census data so let's try the second link, the Office of Financial Management.

2. On the top, click on the 'Population' tab, then 'County GMA Projections.' (That's Growth Management Act.)

3. We want 2007 projections, which are the most recent. On the next page, we want projections by 'Single Year After 2010.'

a. What’s the 2010 project population for Whitman County?- 51,349

b. What’s the 2030 projection?-67,031

c. What's the projected state population in 2030?- 10,026,660

d. What's the percent increase for Washington state from 2000 to 2030? What's the increase in Whitman County during that same time period? WA- 41.22% Whitman- 39.23%

Spokane City Council Agenda

1. The city of Spokane provides all its City Council information online. Google “Spokane City Council.” Choose the first Google result, which will take us directly to the Council’s home page.

2. Let’s look at the Sept. 14 agenda. Under ‘Current Agendas,’ choose Sept. 14.

3. What’s the number of the ordinance that would create a new alcohol-impact area?- ORD C34475

4. We want to know more about this ordinance. In fact, we want to see the actual document. Under the ‘Services’ tab at the top of the page, scroll down to ‘Documents and Forms.’ Navigate to ‘City Clerk Records.’

5. Type in the keyword ‘alcohol.’ That will bring up the actual ordinance. We have several different listings for the same ordinance. So, under ‘Sub Type,’ find the ordinance designated ‘SMC.’

6. Click ‘View’ and open with Adobe Acrobat.

7. What will the ordinance do? Write a lede based on the City Council’s approval of this ordinance.

Further restrictions of the sale of alcohol are soon to come in Spokane if the city council approves ordinance C34475.

8. Google 'alcohol-impact area.' Are other Washington cities enacting similar ordinances. Why?

Tacoma and Seattle are also looking to put an ordinance like this in place due to stats and surveys that show a high level of unsafety when it comes to the sale of alcohol.