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 1699 176 63 4
.//activity-date/@type ActivityDateType 1725 4 4 3
.//activity-status/@code ActivityStatus 1726 6 6 1
.//activity-scope/@code ActivityScope 490 8 8 2
.//budget/@status BudgetStatus 1454 2 2 1
.//budget/@type BudgetType 1500 2 2 0
.//contact-info/@type ContactType 956 4 4 3
.//description/@type DescriptionType 1673 4 4 0
.//participating-org/@role OrganisationRole 1722 4 4 2
.//participating-org/@type OrganisationType 1657 16 16 6
.//policy-marker[@vocabulary = '1' or not(@vocabulary)]/@code PolicyMarker 730 12 12 5
.//policy-marker/@significance PolicySignificance 722 5 5 4
.//policy-marker/@vocabulary PolicyMarkerVocabulary 709 2 2 1
.//recipient-country/@code Country 1638 251 242 48
.//recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 748 26 26 7
.//recipient-region/@vocabulary RegionVocabulary 668 3 3 0
.//related-activity/@type RelatedActivityType 462 5 5 0
.//reporting-org/@type OrganisationType 1727 16 15 1
.//sector[@vocabulary = '1' or not(@vocabulary)]/@code Sector 1531 325 321 108
.//sector/@vocabulary SectorVocabulary 1686 14 14 13
.//transaction/provider-org/@type OrganisationType 1179 16 15 33
.//transaction/receiver-org/@type OrganisationType 1068 16 16 28
.//transaction/transaction-type/@code TransactionType 1592 13 13 10
.//transaction/value/@currency Currency 1445 176 96 5
.//@xml:lang Language 1722 181 98 9
.//budget/value/@currency Currency 1467 176 52 1
.//default-aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 1070 24 24 4
.//default-aid-type/@vocabulary AidTypeVocabulary 858 4 4 1
.//default-finance-type/@code FinanceType 1063 68 32 0
.//default-flow-type/@code FlowType 1082 10 9 1
.//default-tied-status/@code TiedStatus 1006 3 3 4
.//participating-org/@crs-channel-code CRSChannelCode 464 438 296 1
.//transaction/aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 490 24 21 5
.//transaction/aid-type/@vocabulary AidTypeVocabulary 381 4 4 0
.//transaction/disbursement-channel/@code DisbursementChannel 636 4 4 0
.//transaction/finance-type/@code FinanceType 546 68 29 1
.//transaction/flow-type/@code FlowType 513 10 10 0
.//result/@type ResultType 717 4 4 1
.//result/indicator/@measure IndicatorMeasure 715 5 5 3
.//result/indicator/reference/@vocabulary IndicatorVocabulary 275 10 10 1
.//collaboration-type/@code CollaborationType 603 7 7 0
.//other-identifier/@type OtherIdentifierType 308 6 6 2
.//planned-disbursement/@type BudgetType 152 2 2 0
.//planned-disbursement/provider-org/@type OrganisationType 131 16 13 7
.//planned-disbursement/receiver-org/@type OrganisationType 114 16 16 7
.//planned-disbursement/value/@currency Currency 154 176 17 0
.//result/reference/@vocabulary ResultVocabulary 82 1 1 0
.//transaction/sector[@vocabulary = '1' or not(@vocabulary)]/@code Sector 161 325 288 29
.//transaction/sector/@vocabulary SectorVocabulary 167 14 9 1
.//transaction/tied-status/@code TiedStatus 436 3 3 1
.//@budget-not-provided BudgetNotProvided 32 3 3 0
.//document-link/@format FileFormat 805 1650 143 4
.//document-link/category/@code DocumentCategory 809 30 30 0
.//document-link/language/@code Language 721 181 22 1
.//result/document-link/@format FileFormat 153 1650 58 0
.//result/document-link/category/@code DocumentCategory 154 30 14 0
.//result/document-link/language/@code Language 90 181 6 0
.//location/feature-designation/@code LocationType 82 682 101 23
.//location/location-class/@code GeographicLocationClass 158 4 4 0
.//location/location-reach/@code GeographicLocationReach 262 2 2 0
.//location/exactness/@code GeographicExactness 224 2 2 0
.//sector[@vocabulary = '2']/@code SectorCategory 161 44 44 15
.//country-budget-items/@vocabulary BudgetIdentifierVocabulary 62 5 5 0
.//sector[@vocabulary = '7']/@code UNSDG-Goals 140 17 17 32
.//transaction/sector[@vocabulary = '7']/@code UNSDG-Goals 5 17 6 0
.//transaction/recipient-country/@code Country 154 251 216 34
.//transaction/recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 89 26 26 4
.//conditions/condition/@type ConditionType 67 3 3 0
.//location/administrative/@vocabulary GeographicVocabulary 76 6 6 1
.//location/location-id/@vocabulary GeographicVocabulary 137 6 6 2
.//humanitarian-scope/@type HumanitarianScopeType 70 2 2 1
.//humanitarian-scope/@vocabulary HumanitarianScopeVocabulary 70 3 3 1
.//transaction/recipient-region/@vocabulary RegionVocabulary 49 3 3 0
.//location/administrative[@vocabulary = 'A4']/@code Country 25 251 224 23
.//tag/@vocabulary TagVocabulary 116 6 5 0
.//transaction/sector[@vocabulary = '2']/@code SectorCategory 18 44 41 0
.//sector[@vocabulary = '8']/@code UNSDG-Targets 33 169 169 1
.//tag[@vocabulary = '3']/@code UNSDG-Targets 20 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 12 4 4 0
.//tag[@vocabulary = '2']/@code UNSDG-Goals 68 17 17 0
.//transaction/aid-type[@vocabulary = '2']/@code EarmarkingCategory 13 4 4 0
.//result/indicator/document-link/@format FileFormat 26 1650 16 0
.//result/indicator/document-link/category/@code DocumentCategory 30 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 10 1650 7 0
.//result/indicator/baseline/document-link/category/@code DocumentCategory 12 30 6 0
.//result/indicator/baseline/document-link/language/@code Language 2 181 1 0
.//result/indicator/period/actual/document-link/@format FileFormat 13 1650 9 0
.//result/indicator/period/actual/document-link/category/@code DocumentCategory 14 30 6 0
.//result/indicator/period/actual/document-link/language/@code Language 2 181 1 0
.//result/indicator/period/target/document-link/@format FileFormat 14 1650 10 0
.//result/indicator/period/target/document-link/category/@code DocumentCategory 15 30 6 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 75 176 9 0
.//activity-date/@type ActivityDateType 73 4 4 4
.//activity-status/@code ActivityStatus 72 6 4 2
.//budget/@type BudgetType 50 2 2 0
.//collaboration-type/@code CollaborationType 23 7 5 1
.//default-aid-type/@code AidType 40 24 14 1
.//default-finance-type/@code FinanceType 29 68 9 1
.//default-flow-type/@code FlowType 42 10 5 1
.//participating-org/@role OrganisationRole 69 4 4 7
.//participating-org/@type OrganisationType 61 16 11 1
.//recipient-country/@code Country 71 251 195 43
.//recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 22 26 17 2
.//reporting-org/@type OrganisationType 74 16 7 2
.//sector/@vocabulary Vocabulary 51 10 5 4
.//transaction/transaction-type/@code TransactionType 67 10 5 7
.//@xml:lang Language 74 181 9 3
.//budget/value/@currency Currency 43 176 6 105
.//default-tied-status/@code TiedStatus 28 3 3 0
.//description/@type DescriptionType 50 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 34 10 6 0
.//transaction/tied-status/@code TiedStatus 31 3 3 1
.//transaction/value/@currency Currency 43 176 10 2
.//contact-info/@type ContactType 9 4 2 30
.//document-link/@format FileFormat 23 1650 12 2
.//document-link/category/@code DocumentCategory 26 26 14 1
.//document-link/language/@code Language 9 181 2 0
.//location/location-reach/@code GeographicLocationReach 2 2 2 0
.//policy-marker[@vocabulary = '1' or not(@vocabulary)]/@code PolicyMarker 6 12 12 0
.//policy-marker/@significance PolicySignificance 8 5 4 0
.//policy-marker/@vocabulary Vocabulary 5 10 2 2
.//recipient-region/@vocabulary RegionVocabulary 6 3 1 0
.//result/@type ResultType 5 4 3 0
.//result/indicator/@measure IndicatorMeasure 5 5 4 0
.//location/location-class/@code GeographicLocationClass 2 4 4 0
.//location/location-id/@vocabulary GeographicVocabulary 2 6 1 1
.//location/exactness/@code GeographicExactness 2 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 5 8 8 0
.//related-activity/@type RelatedActivityType 2 5 2 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
.//sector[@vocabulary = 'DAC-3']/@code SectorCategory 1 44 1 0