Skip to content

Instantly share code, notes, and snippets.

View practicalparticipation's full-sized avatar

Tim Davies practicalparticipation

View GitHub Profile
@practicalparticipation
practicalparticipation / blog-post-draft.md
Last active August 29, 2015 14:10
Modelling concessions contracts with the Open Contracting Data Standard - initial notes

Exploring Resource Contracts in Open Contracting

The first version of the Open Contracting Data Standard was developed primarily with reference to procurement type contracts. However, our goal has been that the standard should also be able to meaningfully capture information about other kinds of contracts, including permits, and contracts for concessions (e.g. mining). Unlike procurement contracts, where we were able to turn to a large amount of ready-structured data already being published, in the case of concession contracts data is harder to come by.

The use cases for concessions contracts also place a lot of emphasis on the contract text. These are contracts that may be in force for decades, and that have complex terms dealing with how resources and responsibilities will be split between governments sand consortia of firms. They include not only payments out by government, but also revenue payments to governments and other actors in various forms.

So - as part of preliminary work on exploring how O

Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@practicalparticipation
practicalparticipation / gist:ca48ed2ffc0dee3dc872
Last active August 29, 2015 14:08
From Open Contracting Data Spec 0.3 to Trade Mapper Data
@practicalparticipation
practicalparticipation / gist:9471278
Last active August 29, 2015 13:57
Exploring IATI Data in Open Refine

This is a work in progress documenting one approach to analyse IATI data from the data store

Exploring Uganda's Aid Data with Open Refine

Zara Rahman recently shared notes on the Open Dev Toolkit blog of an exploration into aid funding going to Uganda. As Zara notes, whilst tools like AidView.net make it possible to find funding to a given country, the current codebase does not implement date or funding organisation type filters.

This note documents a brief exploration using the IATI Datastore and LOD Refine (a version of Open Refine) to explore the question of how much money is allocated to Uganda in 2013.

As it turns out, this is still a pretty tricky question to ask, and the current draft of this note by no means gets all the way to an answer - but hopefully some of the approaches here

Intro

Notes of a number of Open Refine expressions for working with transcripts from the Internet Governance Forum.

ToDo:

Get a working regexp to extract speaker names.

Explore outputting data to formats for import into SayIt.

@practicalparticipation
practicalparticipation / gist:8465919
Created January 16, 2014 23:59
Regular expressions for cleaning up HTML from Excel
# Replace each with ''
style=\"([a-zA-Z\-:;\.0-9\n# ]+)\"
class=\"[A-Za-z0-9]+\"
width=\"[A-Za-z0-9]+\"
height=\"[A-Za-z0-9]+\"
@practicalparticipation
practicalparticipation / iati-sparqls
Created May 31, 2013 11:09
Sparql queries for working with IATI Linked Data.
The query below run against the store at http://eculture.cs.vu.nl:1987/iati/user/query which uses the data model from http://iati2lod.appspot.com/model/activities retrieves URLs for all the transactions which include GB-1 as the providing organisation (currently 26,000 or so).
```sparql
PREFIX iati:<http://purl.org/collections/iati/>
SELECT ?transaction WHERE {
?transaction a iati:transaction.
?transaction iati:provider-org <http://purl.org/collections/iati/codelist/OrganisationIdentifier/GB-1> .
}
```