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 1694 176 63 4
.//activity-date/@type ActivityDateType 1720 4 4 3
.//activity-status/@code ActivityStatus 1721 6 6 1
.//activity-scope/@code ActivityScope 490 8 8 2
.//budget/@status BudgetStatus 1449 2 2 1
.//budget/@type BudgetType 1499 2 2 0
.//contact-info/@type ContactType 955 4 4 3
.//description/@type DescriptionType 1672 4 4 0
.//participating-org/@role OrganisationRole 1717 4 4 2
.//participating-org/@type OrganisationType 1652 16 16 6
.//policy-marker[@vocabulary = '1' or not(@vocabulary)]/@code PolicyMarker 724 12 12 5
.//policy-marker/@significance PolicySignificance 716 5 5 4
.//policy-marker/@vocabulary PolicyMarkerVocabulary 703 2 2 1
.//recipient-country/@code Country 1633 251 242 48
.//recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 746 26 26 7
.//recipient-region/@vocabulary RegionVocabulary 668 3 3 0
.//related-activity/@type RelatedActivityType 461 5 5 0
.//reporting-org/@type OrganisationType 1722 16 15 1
.//sector[@vocabulary = '1' or not(@vocabulary)]/@code Sector 1526 325 321 108
.//sector/@vocabulary SectorVocabulary 1681 14 14 13
.//transaction/provider-org/@type OrganisationType 1174 16 15 33
.//transaction/receiver-org/@type OrganisationType 1068 16 16 28
.//transaction/transaction-type/@code TransactionType 1587 13 13 10
.//transaction/value/@currency Currency 1440 176 96 5
.//@xml:lang Language 1717 181 98 9
.//budget/value/@currency Currency 1461 176 52 1
.//default-aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 1064 24 24 4
.//default-aid-type/@vocabulary AidTypeVocabulary 858 4 4 1
.//default-finance-type/@code FinanceType 1057 68 32 0
.//default-flow-type/@code FlowType 1076 10 9 0
.//default-tied-status/@code TiedStatus 1000 3 3 3
.//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 712 4 4 1
.//result/indicator/@measure IndicatorMeasure 710 5 5 2
.//result/indicator/reference/@vocabulary IndicatorVocabulary 270 10 10 1
.//collaboration-type/@code CollaborationType 602 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 804 1650 143 4
.//document-link/category/@code DocumentCategory 808 30 30 0
.//document-link/language/@code Language 720 181 22 0
.//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