Skip to content

Instantly share code, notes, and snippets.

@Bjwebb
Last active December 26, 2015 21:39
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/7217809 to your computer and use it in GitHub Desktop.
Save Bjwebb/7217809 to your computer and use it in GitHub Desktop.
for f in *; do echo $f; cat ../IATI-Registry-Refresher/ckan/$f | grep -oE '\{[^}]*publisher_iati_id[^}]*\}' | sed -e 's/.*"value": "\\"//' -e 's/\\".*//' | head -n 1; xmllint --xpath "//reporting-org/@ref" $f/* | sed 's/ \?ref="/\n/g' | sed 's/"$//' | tail -n +2 | sort | uniq -c; done > reporting-orgs
aa
21020
17 21020
aai
NL-KVK-27264198
15 NL-KVK-27264198
aauk
GB-CHC-274467
35 GB-CHC-274467
acaa
2 GB-CHC-1096908
acord
GB-CHC-283302
1 GB-CHC-283302
addinternational
GB-COH-294860
9 GB-COH-294860
adrauk
GB-CHC-1074937
4 GB-CHC-1074937
aet
GB-CHC-313139
1 GB-CHC-313139
afdb
46002
287 46002
afghanaid
GB-CHC-105348
2 GB-CHC-105348
afrikids
gb-chc-1093624
1 gb-chc-1093624
ai_1064413
GB-CHC-1064413
3 GB-CHC-1064413
akfuk73
GB-COH-1100897
2 GB-COH-1100897
akvo
NL-KVK-27327087
24 NL-KVK-27327087
amrefuk
GB-CHC-261488
1 GB-CHC-261488
apt
GB-CHC-290836
2 GB-CHC-290836
1 GB-CHC-290836				
arfh
NG-CAC-5938
3 NG-CAC-5938
art19
GB-CHC-327421
1 GB-CHC-327421
asdb
46004
2619 46004
ausaid
AU-5
1113 AU-5
basicneeds
GB-CHC-1079599
5 GB-CHC-1079599
blueventures
GB-CC-1098893
2 GB-CC-1098893
bmz
DE-1
2401 DE-1
bond
GB-CHC-1068839
4 GB-CHC-1068839
bracintl
NL-CCI-20081098
4 NL-CCI-20081098
buildafrica
GB-CHC-298316
2 GB-CHC-298316
cafod
GB-CC-285776
1039 GB-CHC-285776
caid
GB-CHC-110585
68 GB-CHC-1105851
131 GB-CHC-110858
camfed
GB-CHC-1029161
3 GB-CHC-1029161
canoncollinstrust
GB-CHC-1102028
1 GB-CHC-1102028
cda
US-IRS-562339052
4 US-IRS-562339052
cdc
GB-2
321 GB-2
259 GB-COH-03877777
cecily
GB-CHC-CF
2 GB-CHC-CF
childhopeuk
GB-CHC-328434
3 GB-CHC-328434
cic
GB-CHC-1020488
2 GB-CHC-1020488
cif
57 47134
47 47135
ciks
ciks
2 ciks
ciuk
GB-CHC-292506
23 GB-CHC-292506
concernuk
GB-CHC-1092236
3 GB-CHC-1092236
cord
GB-CHC-1070684
2 GB-CHC-1070684
cprojects
GB-CC-326568
3 GB-CHC-326568
cr
GB-CHC-1055436
2 GB-CHC-1055436
ctc
GB-CHC-327654
2 gb_chc_327654
cu
GB-CHC-272465
49 GB-CHC-272465
cuammtrustees
TN-TIN-102123727
1 TN-TIN-102123727
danida
DK-1
2596 DK-1
dapp
GPAF-IMP-031
1 dm
dc
gb-coh-07629751
2 gb-coh-07629751
deccadmin
GB-4
1 DECC
11 GB-4
dfatd-maecd
CA-3
2772 CA-3
dfid
GB-1
12489 GB-1
diltuk
GB-CHC-1122924
1 GB-CHC-1122924
dipr
GB-COH-06368740
23 GB-COH-06368740
doh
DoH
1 GB-10
dthfxx12
ZA-ROC-1999/05072/08
3 ZA-ROC-1999/05072/08
dwp
GB-9
1 GB-9
ec-echo
EU-4
1244 EU-4
ec-elarg
EU-5
729 EC-ELARG
ec-fpi
EU-6
1 EC-FPI
414 EU
eti
GB-COH-3578127
8 GB-COH-3578127
eu
EU
8239 EU
evc
GB-CC-1089879
2 GB-CC-1089879
ewb_canada
6 CA-CRA-89980-1815-RR0001
fa
GB-COH-01926828
24 GB-COH-01926828
fco
GB-3
3836 GB-3
ff
NP-DAO-27-127/062/063
2 NP-DAO-27-127/062/063
ffi_publisher
GB-COH-0277068
1 GB-COH-0277068
finland_mfa
FI-3
2752 FI-3
fm
GB-COH-3008440
2 GB-COH-3008440
foe_ewni
GB-CHC-281681
1 GB-CHC-281681
fyf
GB-CHC-250456
3 GB-CHC-250456
gain
30001
8 30001
gavi
47122
1749 47122
gb-cc-220949
GB-CC-220949
1 gb-cc-220949
5 GB-CC-220949
gl
ZA-CIPC-2001/005850/08
12 ZA-CIPC-2001/005850/08
globalgiving
US-EIN-300108263
10379 US-EIN-300108263
globalintegrity
US-EIN-26-0126537
9 US-EIN-26-0126537
goal
CHY6271
1 CHY6271
helpage_international
GB-COH-1762840
11 GB-COH-1762840
hewlett-foundation
US-EIN-941655673
1002 US-EIN-941655673
hfhgb
GB-CHC-1043641
1 GB-CHC-1043641
hhc
GB-CHC-1089490
2 GB-CHC-1089490
hi
GB-CHC-1017255
10 GB-CHC-1017255
hifed
FR-PDR-W691075333
2 FR-PDR-W691075333
hooda
GB-GOVUK-uk_Home Office
2 GB-GOVUK-uk_Home Office
hp_12
1 GB-COH-4887855
hpa
GB-CHC-1837621
5 GB-CHC-1837621
hsa
ZA-NPO-013484
1 IATI
1 ZA-NPO-013484
iadb
IADB
868 IADB
icauk
GB-CHC-1090745
1 GB-CC-1090745
icn
ICN
1 ICN
indtrust
GB-CHC-1075920
95 GB-CHC-1075920
international-alert
GB-COH-21531930
44 GB-COH-2153193
ippf
GB-CHC-21023
29 GB-CHC-21023
irishaid
IE-1
1 IE-1
irw
GB-CHC-328158
1 GB-CHC-328158
iww_publish
GB-CHC-1001698
4 GB-CHC-1001698
jeevika_trust
GB-CHC-291167
1 GB-CHC-291167
karuna
karuna_admin
1 karuna_admin
lcd_admin
GB-CHC-218186
2 GB-CHC-218186
lcds
GB-SC-037959
1 GB-SC-037959
lead_international
GB-COH-4075590
1 GB-COH-4075590
livingearth12
GB-CHC-800672
1 LIVINGEARTH
maec
16392 50
12592 ES-5
malariaconsortium
GB-CHC-1099776
2 GB-CHC-1099776
mamta_himc
1 IN-
manxtimes
IM-CR-017899B
37 IM-CR-017899B
mapaction
mapaction
1 mapaction
mcs
GB-CHC-SC030289
3 GB-CHC-SC030289
mfat
To be confirmed.
71 NZ-1
mic-uk
GB-CC-1120413
1 mic-uk
minbuza_nl
NL-1
3772 NL-1
mlf
GB/CHC/1104287
motivation
GB-CHC-1079358
2 GB-CHC-1079358
mrc
GB-COH-RC000346
167 GB-COH-RC000346
mrc-sierra-leone
SL-NRA-1001562-8
1 SL-NRA-1001562-8
mrdf
GB-CHC-291691
2 GB-CHC-291691
msi
GB-COH-1102208
21 GB-COH-1102208
2 MSI
network4africa
GB-CHC-1120932
nfn
NP-DAO-27-689/063/064
1 NP-DAO-27-689/063/064
nrc
NO-BRC-977538319
56 NO-BRC-977538319
ocha_fts
41127-FTS
9924 41127-FTS
opportunity-international-uk
GB-COH-05322719
1 GB-COH-05322719
oxfamgb
GB-CHC-202918
1643 GB-CHC-202918
oxfamindia
2 oxfam_india
pa
GB-COH-871954
313 GB-COH-871954
pact
US-EIN-13-2702768
33 US-EIN-13-2702768
pdorg
1 GB-CHC-1123241
peopleinaid
GB-CHC-1078768
1 GB-CHC-1078768
plan_uk
GB-COH-1364201
26 GB-COH-1364201
plan_usa
US-IRS-13-5661832
11 US-IRS-13-5661832
pont
GB-CHC-1125948
1 GB-CHC-1125948
pontis
pontis
12 pontis
power
GB-CHC-1059996
1 GB_CHC
pragya
IN-AR-775
2 IN-AR-775
pri
GB-COH-04154075
3 GB-CH-04154075
2 GB-COH-04154075
progressio
GB-CHC-294329
6 GB-CHC-294329
psi
21032
54 21032
pwyf
GB-COH-07676886
3 GB-COH-07676886
rc
GB-CHC-1058991
2 GB-CHC-1058991
README.md
rem
GB-COH-4905100
5 GB-COH-4905100
reporting-orgs
restless
GB-CHC-1127488
11 GB-CHC-1127488
rfuk
GB-CHC-1138287
2 GB-CHC-1138287
ri-uk
GB-CHC-1098106
1 GB-CHC-1098106
rspb_
GB-CHC-207076
1 GB-CHC-207076
sacbc
ZA-NPO-061870
1 ZA-DSD-061-870-NPO
sacu
SACU
2 sacu
saferworld
GB-CHC-3015948
24 GB-CHC-3015948
sciaf
SCIAF
1 GB-OSCR-SC012302
1 SCIAF
scuk
GB-COH-213890
183 GB-COH-213890
self-help-africa
IE-6663
65 IE-6663
sendacow
GB-CHC-299717
2 GB-CHC-299717
sense_international
GB-CHC-1076497
2 GB-CHC-1076497
sida
SE-6
349 SE-2
27087 SE-6
175 SE-99
sossaheluk
GB-COH-2100867
1 GB-COH-2100867
spark
NL-KVK-41213450
100 NL-KVK-41213450
spuk
1 GB-CHC-1001349
ss-org
GB-CHC-207544
1055 GB-CHC-207544
stichting_hivos
NL-KVK-41198677
1531 NL-KVK-41198677
surf
GB-CHC-1065705
1 GB-CHC-1065705
taf
US-AGO-CA-941191246
89 US-AGO-941191246
tao-03473165
GB-CHC-1069208
1 GB-CHC-1069208
tbalert
GB-CHC-1071886
1 GB-CHC-1071886
tearfund
GB CHC 265464
8 GB-CHC-265464
theglobalfund
47045
842 47045
theict
GB-CC-254781
1 GB - CC - 254781
tlmew
GB-CHC-1050327
2 GB-CHC-1050327
traidcraft
GB-COH-3031674
4 GB-COH-3031674
transparency-international
21033
13 21033
troc
GB-COH-NI21482
2 GB-COH-NI21482
twin-iati
GB-CHC-291824
1 twin
uncdf
41111
181 41111
undp
41114
13482 41114
unfpa
41119
719 41119
unhabitat
41120
173 41120
unicef
41122
5923 41122
unops
41AAA
857 41AAA
unw
411124
55 411124
vfan
GB-CHC-1140123
2 GB-CHC-1140123
vso
GB-CHC-313757
44 GB-CHC-313757
wacc-uk
GB-COH-2082273
1 GB-COH-2082273
waronwant
GB-CHC-208724
2 GB-CHC-208724
wateraid
GB-CHC-288701
62 GB-CHC-288701
wfp
41140
463 41140
wfwiuk
GB-CHC-1115109
1 GB-CHC-1115109
womankindworld
GBCHC328206
29 GBCHC328206
worldbank
44000
5769 44000
wsup
GB-COH-5419428
2 GB-COH-5419428
wvuk
GB-CHC-285908
63 GB-CHC-285908
wwfpakistan
21-PK-WWF
3 21-PK-WWF
wwf-uk
GB-COH-1081247
201 GB-COH-1081247
ycare
GB-CHC-1109789
1 1109789
1 GB-CHC-1109789
yipl
NP-CRO-45995/063/064
2 NP-CRO-45995/063/064
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment