Skip to content

Instantly share code, notes, and snippets.

{"leastDeveloped": ["AF", "AO", "BD", "BF", "BI", "BJ", "BT", "CD", "CF", "DJ", "ER", "ET", "GM", "GN", "GW", "HT", "KH", "KI", "KM", "LA", "LR", "LS", "MG", "ML", "MM", "MR", "MW", "MZ", "NE", "NP", "RW", "SB", "SD", "SL", "SN", "SO", "SS", "ST", "TD", "TG", "TL", "TV", "TZ", "UG", "VU", "YE", "ZM"], "landLockedDeveloping": ["AF", "AM", "AZ", "BF", "BI", "BO", "BT", "BW", "CF", "ET", "KG", "KZ", "LA", "LS", "MD", "MK", "ML", "MN", "MW", "NE", "NP", "PY", "RW", "SS", "SZ", "TD", "TJ", "TM", "UG", "UZ", "ZM", "ZW"], "smallIslandDeveloping": ["AG", "AI", "AS", "AW", "BB", "BQ", "BS", "BZ", "CK", "CU", "CV", "CW", "DM", "DO", "FJ", "FM", "GD", "GU", "GW", "GY", "HT", "JM", "KI", "KM", "KN", "LC", "MH", "MP", "MS", "MU", "MV", "NC", "NR", "NU", "PF", "PG", "PR", "PW", "SB", "SC", "SG", "SR", "ST", "SX", "TL", "TO", "TT", "TV", "VC", "VG", "VI", "VU", "WS"], "developing": ["AE", "AF", "AG", "AI", "AM", "AO", "AR", "AS", "AW", "AZ", "BB", "BD", "BF", "BH", "BI", "BJ", "BL", "BN", "BO", "BQ", "BR", "BS", "BT", "BV",
{"attributes": {"name": "RegionM49", "complete": "1", "embedded": "0", "category-codelist": null}, "metadata": {"name": "Region (UN M49)", "description": "Standard country or area codes for statistical use", "category": "Replicated", "url": "https://unstats.un.org/unsd/methodology/m49/overview/", "last-updated-date": "2020-04-09"}, "data": [{"code": "012", "name": "Algeria", "codeforiati:iso-alpha-2-code": "DZ", "codeforiati:iso-alpha-3-code": "DZA", "codeforiati:global-code": "001", "codeforiati:global-name": "World", "codeforiati:region-code": "002", "codeforiati:region-name": "Africa", "codeforiati:sub-region-code": "015", "codeforiati:sub-region-name": "Northern Africa", "codeforiati:intermediate-region-code": null, "codeforiati:intermediate-region-name": null, "codeforiati:least-developed-countries": "0", "codeforiati:land-locked-developing-countries": "0", "codeforiati:small-island-developing-states": "0", "codeforiati:developed-developing": "Developing", "status": "active"}, {"code": "818", "name": "Eg
from datetime import date
import logging
import iatikit
from collections import defaultdict
logging.getLogger().setLevel(logging.ERROR)
## Get v1 publishers
publishers = [p for p in iatikit.data().publishers
for a in p.activities
import unicodecsv
import exchangerates
from exchangerates import UnknownCurrencyException
out_f = open("uganda/uganda-activity-clean.csv", "w")
class InvalidDataException(Exception):
pass
def get_any_date(row):
from bisect import bisect_left
import csv
import datetime
import pkg_resources
class UnknownCurrencyException(Exception):
pass
def make_date_from_iso(iso_str):
return datetime.date(int(iso_str[:4]), int(iso_str[5:7]),

Keybase proof

I hereby claim:

  • I am markbrough on github.
  • I am markbrough (https://keybase.io/markbrough) on keybase.
  • I have a public key whose fingerprint is C903 E36B F73F 3F87 DC9F 3379 00D5 EA34 EDAF 1348

To claim this, I am signing this object:

@markbrough
markbrough / someiaticodelists.htm
Created August 6, 2013 18:47
Some IATI codelists
<select name="recipient-country">
<option value=""></option>
<option value="AF">AFGHANISTAN</option>
<option value="AX">LAND ISLANDS</option>
<option value="AL">ALBANIA</option>
<option value="DZ">ALGERIA</option>
<option value="AS">AMERICAN SAMOA</option>
<option value="AD">ANDORRA</option>
<option value="AO">ANGOLA</option>
<option value="AI">ANGUILLA</option>
@markbrough
markbrough / gist:5131054
Created March 10, 2013 23:49
IATI Data Quality codelists lookup
## possibly at top of mapping.py:
def codelist_lookup(value, codelist, codelists=codelists):
""" codelists is a variable which looks like this:
'Sector': { '11100', '11110', '11120'},
'OrganisationType': { '10', '11', '12'} etc. (this is not 100% accurate data)
"""
if (value in codelists[codelist]):
return True
else:
return False
@markbrough
markbrough / gist:1669996
Created January 24, 2012 12:30
Uganda mapping with datatype problem
{
"sector": {
"description": "Sector of this transaction. Derived from SWG.",
"taxonomy": "uganda.sector",
"label": "Sector",
"facet": true,
"attributes": {
"name": {
"column": "sector",
"datatype": "id",
@markbrough
markbrough / ugandabudgetmodel.json
Created November 11, 2011 14:51
Uganda budget model
{
"sector": {
"taxonomy": "uganda.sector",
"attributes": {
"name": {
"column": "sector",
"datatype": "id",
"default_value": "",