Last active
December 26, 2015 21:39
-
-
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
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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