[okfn-labs] making open data consumable

Rufus Pollock rufus.pollock at okfn.org
Wed Apr 16 19:26:00 UTC 2014

On 15 April 2014 14:32, nilanjan bhattacharya <nilanjanb at live.com> wrote:

> I don't follow this group closely, however I am interested in the idea of
> open data.

Great to hear from you.

> I think open data should move beyond excel/pdf/spreadsheets.  I think
> technology (visualization/analytics) has progressed a lot in the last few
> years.  To take advantage of the technology, the data should be represented
> in a digitally consumable form.  I think you can convert excel/pdf to json
> with little effort (some effort is required).  The returns on that are many
> fold.
> I wrote a blog post on how I converted the Singapore 2014 budget to JSON
> files - http://revelutions.com/?p=461

This is fantastic :-)

> If you'd like to see how the data is used take a look at another blog post
> http://revelutions.com/?p=454  In this post I have created a
> visualization using the data.  Note this works better on a laptop/desktop,
> since I have tooltips which show the values.

I don't mean to move you around lists too much but I think you'd be very
interested in the OpenSpending project: http://openspending.org/ (and the
associated Where Does My Money Go <http://wheredoesmymoneygo.org/>!)

If you like treemaps (which I think you do!) you'll really like it (for
example here's world bank privatizations

Using OpenSpending it would be pretty fast to create something like
http://wheredoesmymoneygo.org/ for Singapore ...

In particular, the main mailing list is here:


and the more geeky list is here

(I note I'm also one of those finance data geeks so I also hang out there!)

> (The key concept in converting to JSON is preserving the heirarchy in the
> data.  See this sample : http://revelutions.com/budgets/moh.json - I
> think people on the okfn labs don't need to be told this).


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/okfn-labs/attachments/20140416/18834dbb/attachment-0004.html>

More information about the okfn-labs mailing list