IATI Tools

IATI Dashboard

Codelists

How are codelists used in IATI data?

Checking usage of codelists across IATI data files.

Count of the different values used by all reporting orgs, per codelist.

Note: some Elements/Attributes may use the same codelist. In each case, the values counted are different for each use.

Click the up and down arrow icons icons to sort the table by a column. Selecting further columns whilst holding the shift key will enable secondary (tertiary etc) sorting by the desired column/s.

Codelists for version 2.xx

Element/Attribute on codelist Codelist Total Values Used (J) Total Values on Codelist Values used, on Codelist Values used, not on Codelist
.//@default-currency Currency 1752 176 64 3
.//activity-date/@type ActivityDateType 1782 4 4 3
.//activity-status/@code ActivityStatus 1783 6 6 1
.//activity-scope/@code ActivityScope 512 8 8 2
.//budget/@status BudgetStatus 1505 2 2 1
.//budget/@type BudgetType 1551 2 2 0
.//contact-info/@type ContactType 970 4 4 3
.//description/@type DescriptionType 1727 4 4 0
.//participating-org/@role OrganisationRole 1779 4 4 2
.//participating-org/@type OrganisationType 1701 16 16 6
.//policy-marker[@vocabulary = '1' or not(@vocabulary)]/@code PolicyMarker 743 12 12 6
.//policy-marker/@significance PolicySignificance 735 5 5 4
.//policy-marker/@vocabulary PolicyMarkerVocabulary 722 2 2 1
.//recipient-country/@code Country 1686 251 242 47
.//recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 770 26 26 9
.//recipient-region/@vocabulary RegionVocabulary 692 3 3 0
.//related-activity/@type RelatedActivityType 472 5 5 0
.//reporting-org/@type OrganisationType 1784 16 15 1
.//sector[@vocabulary = '1' or not(@vocabulary)]/@code Sector 1585 325 321 110
.//sector/@vocabulary SectorVocabulary 1737 14 14 13
.//transaction/provider-org/@type OrganisationType 1207 16 15 34
.//transaction/receiver-org/@type OrganisationType 1090 16 16 28
.//transaction/transaction-type/@code TransactionType 1642 13 13 10
.//transaction/value/@currency Currency 1494 176 96 5
.//@xml:lang Language 1780 181 99 9
.//budget/value/@currency Currency 1517 176 52 1
.//default-aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 1124 24 24 4
.//default-aid-type/@vocabulary AidTypeVocabulary 905 4 4 1
.//default-finance-type/@code FinanceType 1119 68 31 0
.//default-flow-type/@code FlowType 1138 10 10 2
.//default-tied-status/@code TiedStatus 1061 3 3 4
.//participating-org/@crs-channel-code CRSChannelCode 474 438 323 2
.//transaction/aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 496 24 21 9
.//transaction/aid-type/@vocabulary AidTypeVocabulary 387 4 4 0
.//transaction/disbursement-channel/@code DisbursementChannel 644 4 4 0
.//transaction/finance-type/@code FinanceType 556 68 29 1
.//transaction/flow-type/@code FlowType 520 10 10 0
.//result/@type ResultType 729 4 4 1
.//result/indicator/@measure IndicatorMeasure 727 5 5 3
.//result/indicator/reference/@vocabulary IndicatorVocabulary 281 10 10 1
.//collaboration-type/@code CollaborationType 619 7 7 0
.//other-identifier/@type OtherIdentifierType 313 7 6 2
.//planned-disbursement/@type BudgetType 158 2 2 0
.//planned-disbursement/provider-org/@type OrganisationType 135 16 13 7
.//planned-disbursement/receiver-org/@type OrganisationType 117 16 16 7
.//planned-disbursement/value/@currency Currency 160 176 17 0
.//result/reference/@vocabulary ResultVocabulary 80 1 1 0
.//transaction/sector[@vocabulary = '1' or not(@vocabulary)]/@code Sector 164 325 287 30
.//transaction/sector/@vocabulary SectorVocabulary 170 14 9 1
.//transaction/tied-status/@code TiedStatus 444 3 3 1
.//@budget-not-provided BudgetNotProvided 35 3 3 0
.//document-link/@format FileFormat 815 1650 143 4
.//document-link/category/@code DocumentCategory 819 30 30 0
.//document-link/language/@code Language 723 181 22 1
.//result/document-link/@format FileFormat 159 1650 58 0
.//result/document-link/category/@code DocumentCategory 160 30 14 0
.//result/document-link/language/@code Language 91 181 6 0
.//location/feature-designation/@code LocationType 82 682 101 23
.//location/location-class/@code GeographicLocationClass 159 4 4 0
.//location/location-reach/@code GeographicLocationReach 267 2 2 0
.//location/exactness/@code GeographicExactness 225 2 2 0
.//sector[@vocabulary = '2']/@code SectorCategory 163 44 44 15
.//country-budget-items/@vocabulary BudgetIdentifierVocabulary 70 5 5 0
.//sector[@vocabulary = '7']/@code UNSDG-Goals 142 17 17 44
.//transaction/sector[@vocabulary = '7']/@code UNSDG-Goals 5 17 6 0
.//transaction/recipient-country/@code Country 157 251 216 34
.//transaction/recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 91 26 26 6
.//humanitarian-scope/@type HumanitarianScopeType 76 2 2 0
.//humanitarian-scope/@vocabulary HumanitarianScopeVocabulary 76 3 3 0
.//transaction/recipient-region/@vocabulary RegionVocabulary 51 3 3 0
.//location/administrative/@vocabulary GeographicVocabulary 77 6 6 1
.//location/administrative[@vocabulary = 'A4']/@code Country 25 251 221 22
.//location/location-id/@vocabulary GeographicVocabulary 139 6 6 2
.//tag/@vocabulary TagVocabulary 124 6 5 0
.//transaction/sector[@vocabulary = '2']/@code SectorCategory 18 44 41 0
.//conditions/condition/@type ConditionType 69 3 3 0
.//sector[@vocabulary = '8']/@code UNSDG-Targets 31 169 169 1
.//tag[@vocabulary = '3']/@code UNSDG-Targets 21 169 169 0
.//transaction/aid-type[@vocabulary = '4']/@code CashandVoucherModalities 12 2 2 0
.//default-aid-type[@vocabulary = '4']/@code CashandVoucherModalities 7 2 2 1
.//default-aid-type[@vocabulary = '2']/@code EarmarkingCategory 11 4 4 0
.//tag[@vocabulary = '2']/@code UNSDG-Goals 72 17 17 0
.//transaction/aid-type[@vocabulary = '2']/@code EarmarkingCategory 14 4 4 0
.//result/indicator/document-link/@format FileFormat 27 1650 16 0
.//result/indicator/document-link/category/@code DocumentCategory 31 30 7 0
.//result/indicator/document-link/language/@code Language 5 181 4 0
.//transaction/sector[@vocabulary = '8']/@code UNSDG-Targets 1 169 1 0
.//result/indicator/baseline/document-link/@format FileFormat 11 1650 7 0
.//result/indicator/baseline/document-link/category/@code DocumentCategory 13 30 6 0
.//result/indicator/baseline/document-link/language/@code Language 2 181 1 0
.//result/indicator/period/actual/document-link/@format FileFormat 14 1650 9 0
.//result/indicator/period/actual/document-link/category/@code DocumentCategory 15 30 7 0
.//result/indicator/period/actual/document-link/language/@code Language 2 181 1 0
.//result/indicator/period/target/document-link/@format FileFormat 15 1650 10 0
.//result/indicator/period/target/document-link/category/@code DocumentCategory 16 30 7 0
.//result/indicator/period/target/document-link/language/@code Language 2 181 1 0
.//crs-add/channel-code/text() CRSChannelCode 2 438 109 3
.//crs-add/other-flags/@code CRSAddOtherFlags 2 4 3 0

Codelists for version 1.xx

Element/Attribute on codelist Codelist Total Values Used (J) Total Values on Codelist Values used, on Codelist Values used, not on Codelist
.//@default-currency Currency 74 176 9 0
.//activity-date/@type ActivityDateType 72 4 4 4
.//activity-status/@code ActivityStatus 71 6 4 2
.//budget/@type BudgetType 49 2 2 0
.//collaboration-type/@code CollaborationType 22 7 5 1
.//default-aid-type/@code AidType 39 24 10 1
.//default-finance-type/@code FinanceType 28 68 8 1
.//default-flow-type/@code FlowType 42 10 5 1
.//participating-org/@role OrganisationRole 68 4 4 6
.//participating-org/@type OrganisationType 60 16 11 1
.//recipient-country/@code Country 70 251 166 43
.//recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 21 26 16 2
.//reporting-org/@type OrganisationType 73 16 7 2
.//sector/@vocabulary Vocabulary 50 10 5 4
.//transaction/transaction-type/@code TransactionType 66 10 5 7
.//@xml:lang Language 73 181 9 3
.//budget/value/@currency Currency 43 176 6 105
.//default-tied-status/@code TiedStatus 28 3 3 0
.//description/@type DescriptionType 49 4 4 0
.//planned-disbursement/value/@currency Currency 4 176 1 0
.//sector[@vocabulary = 'DAC' or not(@vocabulary)]/@code Sector 45 325 171 74
.//transaction/aid-type/@code AidType 35 24 14 0
.//transaction/disbursement-channel/@code DisbursementChannel 29 4 4 0
.//transaction/finance-type/@code FinanceType 33 68 2 0
.//transaction/flow-type/@code FlowType 33 10 4 0
.//transaction/tied-status/@code TiedStatus 30 3 3 1
.//transaction/value/@currency Currency 43 176 10 2
.//contact-info/@type ContactType 8 4 2 30
.//document-link/@format FileFormat 22 1650 12 2
.//document-link/category/@code DocumentCategory 25 26 14 0
.//document-link/language/@code Language 8 181 1 0
.//location/location-reach/@code GeographicLocationReach 1 2 1 0
.//policy-marker[@vocabulary = '1' or not(@vocabulary)]/@code PolicyMarker 5 12 9 0
.//policy-marker/@significance PolicySignificance 7 5 4 0
.//policy-marker/@vocabulary Vocabulary 4 10 2 1
.//recipient-region/@vocabulary RegionVocabulary 5 3 1 0
.//result/@type ResultType 4 4 3 0
.//result/indicator/@measure IndicatorMeasure 4 5 4 0
.//location/location-class/@code GeographicLocationClass 1 4 4 0
.//location/location-id/@vocabulary GeographicVocabulary 1 6 0 1
.//location/exactness/@code GeographicExactness 1 2 2 0
.//location/location-type/@code LocationType 9 682 5 0
.//conditions/condition/@type ConditionType 3 3 2 0
.//result/description/@type DescriptionType 1 4 1 0
.//result/indicator/description/@type DescriptionType 1 4 2 0
.//activity-scope/@code ActivityScope 4 8 6 0
.//location/administrative/@country Country 5 251 18 0
.//location/coordinates/@precision GeographicalPrecision 3 9 2 0
.//location/gazetteer-entry/@gazetteer-ref GazetteerAgency 2 3 2 0
.//related-activity/@type RelatedActivityType 1 5 1 0
.//sector[@vocabulary = 'DAC-3']/@code SectorCategory 1 44 1 0