google fusion tables | Editors Blog

Some news outlets are reporting that today will see the biggest day of industrial action for 30 years. But the news landscape and tools used in reporting the strikes are a world away from the 1980s.

Here is a quick round-up to inspire ideas for coverage.

The Guardian is using Google Maps to plot where rallies are taking place. To build your own map or a timeline you can follow Journalism.co.uk’s how to use Google Fusion Tables. You can also use this tip on how to use Open Heat Map, which can also be embedded on your site;

The BBC has a live text blog running and student journalists are liveblogging on Elephant. To follow suit, read this how to guide on liveblogging;

The Telegraph is running a poll to gauge public opinion. Why not run one on your site’s Facebook page? Here’s how to set one up.

The nationals are providing an overview and inspiring debate, but many readers will be turning to local news sites to find out which schools are closed and which services disrupted.

A simple list is perhaps the most accessible way of accessing information, as created by hyperlocal Uckfield News;

KentOnline has started a Storify which it is updating throughout the day. You could also use Bundlr, which is similar in that you can collate video, photos and tweets, or Chirpstory presenting selected tweets.

For more tools and guidance on how to use Storify, Audioboo, OpenHeatMap, Many Eyes and Qik, check out this guide to livening up local election reporting.

For ideas in adding audio, follow these 10 tips.

How to: liveblog – lessons from news sites

How to: get started using Google Fusion tables

Google Fusion Tables allows you to create data visualisations including maps, graphs and timelines. It is currently in beta but is already being used by many journalists, including some from key news sites leading the way in data journalism.

To find out how to get started in data journalism using Google Fusion Tables click here.

Below are screengrabs of the various visualisations but click through to the stories to interact and get a real feel for why they are great examples of data journalism.

1. The Guardian: WikiLeaks Iraq war logs – every death mapped
What? A map with the location of every death in Iraq plotted as a datapoint.
Why? Impact. You must click the screen grab to link to the full visualisation and get the full scale of the story.

2. The Guardian: WikiLeaks embassy cables
What? This is a nifty storyline visualisation showing the cables sent in the weeks around 9/11.
Why? It’s a fantastic way of understanding the chronology.

3. The Telegraph: AV referendum – What if a general election were held today under AV?
What? A visual picture of using the hypothetical scenario of the outcomes of the 2010 general election if it had been held under the alternative vote system.
Why? A clear picture by area of the main beneficiaries. See how many areas are yellow.

4. WNYC: Mapping the storm clean-up
What? A crowdsourced project which asked a radio station’s listeners to text in details of the progress of a snow clean-up. The datapoints show which streets have been ploughed and which have not. There are three maps to show the progress of the snow ploughs over three days.
Why? As it uses crowsourced information. Remember this one next winter.

5. Texas Tribune: Census 2010 interactive map – Texas population by race, hispanic origin
What? The Texas Tribune is no stranger to Google Fusion Tables. This is map showing how many people of hispanic origin live in various counties in Texas.
Why? A nice use of an intensity map and a great use of census data.

You can find out much more about data journalism at news:rewired – noise to signal, an event held at Thomson Reuters, London on Friday 27 May.

Editors Blog | Journalism.co.uk

Online journalism news

Tag Archives: google fusion tables

Five great examples of data journalism using Google Fusion Tables