Test Dabble DB - Swine Flu

This is a test-
an embedded map of Swine Flu lab-confirmed cases in the United States by the Centers for Disease Control.




The data is screen-scraped off the CDC swine flu Web site by Dabble DB and visualized in a Dabble DB page.

Egads Google does everything

Well, in addition to providing:

• the best search algorithm on the Internet for content, hands down, in text, pictures and video
  
• free email
• context-driven advertising
• aggregated news from over a thousand news outlets
  
• interactive mapping technology
• word processing and number crunching
• cloud computing
• personal syndication of any content you want
• photo-sharing communities
• API's to let developers harness Google's technology for their own uses
  
• and most of the above offered on mobile platforms in addition to desktop platforms
• not to mention free hosting of this very blog and thousands of others;

Google is introducing yet another interesting and free product: visualization of public data, vis a vis interactive graphs of unemployment statistics from the Bureau of Labor Statistics and the U.S. Census. So Google's taking publicly available data and visualizing it using technology from Trendalyzer, a firm it acquired two years ago.

To see one of the new graphs, and there's one for each county and many cities in the nation I'm pretty sure, just type "unemployment rate" and a city or county and state into Google's search box. The graph appears at the top of the search results. Pretty cool.

In its blog entry announcing the new feature, Google says: "We also hope that this will pave the way for public data to take a more central role in informed public conversations."

Sounds like Google is taking a cue straight from the mission statements of newspapers. Of course, this is something newspapers and their Web sites don't readily do. So it's only fitting Google is going to eat our lunch.

Visualization test

This is a test graph using Many Eyes, a social visualization site. Many Eyes lets you upload data and play with different ways of showing it via graphs, charts, maps, and eye-popping crazy variants of these. You can share them and discuss others' work on the site. It's free. The researchers at IBM, who run this Web site, tell me they have no plans to add advertising to the site. They do, however, use the site for their own research.

Below is a bar graph of high school graduation and dropout rates for all Virginia school districts. This uses data from the Virginia Dept. of Education web site, which has all sorts of stuff on it, organized pretty cleanly. I just pulled out the graduation and dropout rates.



I may use this on timesdispatch.com if I can get the right results. As far as I can tell Many Eyes works best on data sets with only two columns. It doesn't work so great if you have multiple variables or (what would be on excel) a pivot table. By that I mean it doesn't let you drill down through multiple sets of linked data very easily. Still, there are tons of possibilities for this, and you can't beat free.

Wordle test

I've never used the free wordle Web site before, it looks pretty neat. No login necessary.
It makes a text frequency map in an artistic way and shares it online. Cut and paste any text into the site and it analyzes each word, then displays a jumble of the words. The size of each word is relative to its frequency in your text. I just wish it had interactivity where the user could click on each buzzword in the Wordle and see the context of each instance of the word.