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 …

Edmonton Pet Licenses: Un-leashing the Data Read more »

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 …

Going Back to Your Routes: NYC Bus Data Read more »

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 …

Hacking the Hacks, Part 2: A Week’s Worth of New York Taxi Rides Read more »

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 …

Hacking the Hacks, Part 1: A Week’s Worth of New York Taxi Rides Read more »

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 …

London Borough Data, Part 2: Another Look At Some LOOKUPS Read more »

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 …

London Borough Data, Part 1: A Look At Some LOOKUPs Read more »

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 …

Getting There: Australian Politician Housing Expense Data, Part 2 Read more »

Citizen journalism or free lunch? Admirable voluntarism or crowdfunded advantage-taking? It’s your call, but the Guardian wants you to donate your – and your, and your – analytical smarts to the data on nine spreadsheets itemizing Australian politicos’ expenses, in …

Getting There: Australian Politician Flight Expense Data, Part 1 Read more »

Now that we’ve established the fact of the relative French hegemony over the men’s rankings a breakout of said parameter would appear to be in order, that is, something like this: Row Labels: Rank (Grouped in bins of 100; needless …

ATP Tennis Rankings, Part 2: Some Baseline Data Read more »

DalYou may not need or want to know that you’re the world’s 1572nd best plyer of your favorite trade, but tennis plyers, er, players, can’t help but be reminded of precisely where they stand among their peers, and all the …

ATP Tennis Rankings, Part 1: Some Baseline Data Read more »