What makes a dataset interesting? A slightly dangerous question, to be sure, exposing as it does the respondent to charges of extreme geekiness and other personality shortcomings likely to result in relegation to the B party list. But enough about…
Open Data Aha!
Signposting to open data being used in 'real life'
Tag: Spreadsheet Journalism
Edmonton Pet Licenses: Un-leashing the Data
Posted in Benefits of open data, Data Journalism, Journalism, Posts from feeds, Visualising data Tagged with: Abbott Katz, Edmonton, Excel, Pet licences, Spreadsheet Journalism
Going Back to Your Routes: NYC Bus Data
There are more expedient ways for getting around New York than on its buses, but if you like the slow, scenic route – provided you know what you’re looking at – the deal isn’t half bad. And nowadays the data…
Posted in Benefits of open data, Data Journalism, Journalism, Posts from feeds, Smart communities, Visualising data Tagged with: Abbott Katz, bus route, buses, data visualisation, New york, Spreadsheet Journalism, theopenbus.com, Transport, USA
From data crunching to storytelling: Lessons from six months of Urbs.London
Comments Credit: By Justgrimes on Flickr. Some rights reserved. Over the past six months, journalist Gary Rogers and media strategist Alan Renwick have run the experimental website Urbs.London, a news operation which turns open data into news stories. The site…
Posted in Benefits of open data, Commercial opportunities, Data Journalism, Innovation, Journalism, Posts from feeds Tagged with: Alan Renwick, Caroline Scott, Data Journalism, Data stories, Gary Rogers, hyperlocal, Hyperlocal Data Journalism conference, journalism, Journalism.co.uk, London Data Store, news, open data, Spreadsheet Journalism, Urbs.London
Chicago Story, Part 1: The Restaurant Inspection Episode
Hungry? Then here are about 28,000 dining suggestions aimed at your need to feed, courtesy of the Chicago Data Portal, and standing by for your download at the Food Inspections link on the Portal’s home page – as of this…
Posted in Benefits of open data, Data, Food, Informing Decision-making, Posts from feeds Tagged with: Food, food inspection, meal, open data, restaurant, Spreadsheet Journalism
Hacking the Hacks, Part 2: A Week’s Worth of New York Taxi Rides
I said it before, and I’m going to have to say it again. I closed last week’s installment on the data for fare activity between January 1 and 7 of New York’s green cab armada with a reminder (largely to…
Posted in Benefits of open data, Data, Data Journalism, Journalism, Posts from feeds, Smart communities, Visualising data Tagged with: Abbott Katz, hacking, New york, NYC Taxi & Limousine Commission, Spreadsheet Journalism, Taxis
Hacking the Hacks, Part 1: A Week’s Worth of New York Taxi Rides
Please understand the pun. If you don’t, you’ll have to indulge my word-playing nod at the slang for cab driver, apparently inspired by the Hackney horse, a London equine precursor to motorized livery. Etymology aside, the New York Open Data…
Posted in Benefits of open data, Journalism, Posts from feeds, Smart communities, Visualising data Tagged with: Abbott Katz, hacking, New york, NYC Taxi & Limousine Commission, Spreadsheet Journalism, Taxis
London Borough Data, Part 2: Another Look At Some LOOKUPS
Last week’s run through the London borough data workbook directed its eponymous scrutiny at a fleet of VLOOKUP formulas in the book’s Profile sheet, ones that retrieved a trove of per-borough attributes, e.g. its migrant population and employment numbers. We…
Posted in Benefits of open data, Data Journalism, Journalism, Posts from feeds Tagged with: Abbott Katz, Excel, London borough, open data, Spreadsheet Journalism, VLOOKUP
Writing Each Row of a Spreadsheet as a Press Release?
A few days ago, I saw via the @HSCICOpenData Twitter feed that an annually released dataset on Written Complaints in the NHS”> has just been published. The data comes in the form of a couple of spreadsheets in which each…
London Borough Data, Part 1: A Look At Some LOOKUPs
When the back end gets moved to the front things start getting interesting. One needn’t look too far into the London-borough-profiles workbook inlaid into the London Data Store site before you wind up shaking hands with the contributory data that…
Posted in Benefits of open data, Data Journalism, Informing Decision-making, Journalism, Posts from feeds Tagged with: Abbott Katz, Excel, London borough, London Data Store, open data, Spreadsheet Journalism
Getting There: Australian Politician Housing Expense Data, Part 2
We’re following the money down under, via the conduit of expenses-plotting spreadsheets flowing our way via the Guardian‘s and its piece on the spending activity of Australian politicians. Having spent last week counting the beans doled out for politicians’ flight…
Posted in Benefits of open data, Data Journalism, Informing Decision-making, Journalism, Posts from feeds, Transparency Tagged with: Abbott Katz, Australia, Excel, expenses, housing, politician, Spreadsheet Journalism