Skip to content

Instantly share code, notes, and snippets.

@Bjwebb

Bjwebb/reporting-org.csv

Created November 6, 2013 10:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Bjwebb/7333799 to your computer and use it in GitHub Desktop.
Save Bjwebb/7333799 to your computer and use it in GitHub Desktop.
Download ZIP
IFS=$'\n'; for f in *; do for line in `xmllint --xpath "//reporting-org/@ref" $f/* | sed 's/ \?ref="/\n/g' | sed 's/"$//' | tail -n +2 | sort | uniq -c`; do xmlid=`echo $line | awk '{ print $2 }'`; cat ../IATI-Registry-Refresher/ckan/$f | grep -oE '\{[^}]*publisher_iati_id[^}]*\}' | sed -e 's/.*"value": "\\"//' -e 's/\\".*//' | head -n 1 > tmp; …
Raw
reporting-org.csv
acaa GB-CHC-1096908
apt GB-CHC-290836 GB-CHC-290836				
bracintl NL-CCI-20081098 NL-CCI-20081098
cafod GB-CC-285776 GB-CHC-285776
caid GB-CHC-110585 GB-CHC-1105851
caid GB-CHC-110585 GB-CHC-110858
cdc GB-2 GB-COH-03877777
cif 47134
cif 47135
cprojects GB-CC-326568 GB-CHC-326568
ctc GB-CHC-327654 gb_chc_327654
dapp GPAF-IMP-031 dm
deccadmin GB-4 DECC
doh DoH GB-10
ec-elarg EU-5 EC-ELARG
ec-fpi EU-6 EC-FPI
ec-fpi EU-6 EU
ewb_canada CA-CRA-89980-1815-RR0001
fyf GB-CHC-250456 GB-CHC-250456
gb-cc-220949 GB-CC-220949 gb-cc-220949
hooda GB-GOVUK-uk_Home Office GB-GOVUK-uk_Home
hp_12 GB-COH-4887855
hsa ZA-NPO-013484 IATI
icauk GB-CHC-1090745 GB-CC-1090745
international-alert GB-COH-21531930 GB-COH-2153193
livingearth12 GB-CHC-800672 LIVINGEARTH
maec 50
maec ES-5
mamta_himc IN-
mfat To be confirmed. NZ-1
mic-uk GB-CC-1120413 mic-uk
msi GB-COH-1102208 MSI
oxfamindia oxfam_india
pdorg GB-CHC-1123241
power GB-CHC-1059996 GB_CHC
pri GB-COH-04154075 GB-CH-04154075
sacbc ZA-NPO-061870 ZA-DSD-061-870-NPO
sacu SACU sacu
sciaf SCIAF GB-OSCR-SC012302
sida SE-6 SE-2
sida SE-6 SE-99
spuk GB-CHC-1001349
taf US-AGO-CA-941191246 US-AGO-941191246
tearfund GB CHC 265464 GB-CHC-265464
theict GB-CC-254781 GB
twin-iati GB-CHC-291824 twin
ycare GB-CHC-1109789 1109789
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment