[wdmmg-discuss] COINs data

Sat Jun 5 08:46:14 UTC 2010

On 3 June 2010 23:02, Jonathan Gray <jonathan.gray at okfn.org> wrote:
> In fact, just went ahead and started one here... ;-)
>
> http://pad.okfn.org/coins
<http://ckan.net/package/coins-data> -- CKAN package with extra info
<http://ckan.net/package/coins-programme-objects> -- CKAN package for
programme objects
There's now quite a lot of info in that pad plus several interfaces.
To summarize:

## Data sources

<http://data.gov.uk/dataset/coins> -- source data
<http://ckan.net/package/coins-data> -- CKAN package with extra info
<http://ckan.net/package/coins-programme-objects> -- CKAN package for
programme objects

Intro: http://www.wheredoesmymoneygo.org/data/coins/ -- we are
collecting faqs in etherpad to be used here and elsewhere

<http://spreadsheets.google.com<http://ckan.net/package/coins-data> --
CKAN package with extra info
<http://ckan.net/package/coins-programme-objects> -- CKAN package for
programme objects/ccc?key=0Ah8UkI7xG7eWdHpYMnhaWmR5NVdNUG9yTkNfQVlUTWc>
-- overview of schema

## Scripts

For people interested in playing around with the data there are now
python scripts:

<http://bitbucket.org/okfn/coins> -- scripts (including loaders for
sql, couchdb and mongodb)

## High level web interfaces

<http://coins.wheredoesmymoneygo.org/> -- basic coins search based on mongodb
<http://coins.guardian.co.uk/coins-explorer/search> -- Guardian
faceted interface based on solr

## API access

In addition if you'd like API access to the data we've made 2009-2010
data available in solr at (and plan to add 2008-2009):

<http://solr.okfn.org/solr/coins.wheredoesmymoneygo.org/>

For example here's a query to search for nuclear return first 10 rows
in JSON format:

<http://solr.okfn.org/solr/coins.wheredoesmymoneygo.org/select/?q=nuclear&start=0&rows=10&indent=on&wt=json>

(There  are *lots* of client libraries for Solr and a sample
querysolr.py script in the coins bitbucket repo).Plans

If you spot something interesting note it in this spreadsheet for the moment:

<http://spreadsheets1.google.com/ccc?key=tjXlULZnawbO7p5VQpwJG8g>

Hope there will be a flag-this feature in one of the interfaces soon ....

Rufus