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 1731 176 64 3
.//activity-date/@type ActivityDateType 1758 4 4 3
.//activity-status/@code ActivityStatus 1759 6 6 2
.//activity-scope/@code ActivityScope 501 8 8 2
.//budget/@status BudgetStatus 1480 2 2 1
.//budget/@type BudgetType 1526 2 2 0
.//budget/value/@currency Currency 1473 176 52 1
.//collaboration-type/@code CollaborationType 607 7 7 0
.//contact-info/@type ContactType 959 4 4 3
.//default-aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 1101 24 24 4
.//default-aid-type/@vocabulary AidTypeVocabulary 885 4 4 1
.//default-finance-type/@code FinanceType 1094 68 31 0
.//description/@type DescriptionType 1703 4 4 0
.//humanitarian-scope/@type HumanitarianScopeType 74 2 2 1
.//humanitarian-scope/@vocabulary HumanitarianScopeVocabulary 74 3 3 1
.//participating-org/@role OrganisationRole 1755 4 4 2
.//participating-org/@type OrganisationType 1681 16 16 7
.//planned-disbursement/@type BudgetType 156 2 2 0
.//planned-disbursement/value/@currency Currency 158 176 17 0
.//policy-marker[@vocabulary = '1' or not(@vocabulary)]/@code PolicyMarker 729 12 12 5
.//policy-marker/@significance PolicySignificance 722 5 5 3
.//policy-marker/@vocabulary PolicyMarkerVocabulary 715 2 2 1
.//recipient-country/@code Country 1665 251 243 48
.//recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 753 26 26 9
.//recipient-region/@vocabulary RegionVocabulary 677 3 3 0
.//reporting-org/@type OrganisationType 1760 16 15 1
.//result/@type ResultType 723 4 4 1
.//result/indicator/@measure IndicatorMeasure 721 5 5 3
.//sector[@vocabulary = '1' or not(@vocabulary)]/@code Sector 1562 325 321 98
.//sector[@vocabulary = '2']/@code SectorCategory 163 44 44 15
.//sector/@vocabulary SectorVocabulary 1717 14 14 13
.//@xml:lang Language 1755 181 99 9
.//@budget-not-provided BudgetNotProvided 35 3 3 0
.//default-flow-type/@code FlowType 1114 10 10 2
.//default-tied-status/@code TiedStatus 1038 3 3 4
.//participating-org/@crs-channel-code CRSChannelCode 475 438 314 2
.//transaction/transaction-type/@code TransactionType 1620 13 13 10
.//transaction/value/@currency Currency 1466 176 96 5
.//transaction/disbursement-channel/@code DisbursementChannel 640 4 4 0
.//transaction/finance-type/@code FinanceType 496 68 29 1
.//transaction/flow-type/@code FlowType 463 10 10 0
.//transaction/recipient-country/@code Country 156 251 216 34
.//transaction/recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 90 26 26 6
.//transaction/recipient-region/@vocabulary RegionVocabulary 50 3 3 0
.//transaction/provider-org/@type OrganisationType 1195 16 15 33
.//transaction/receiver-org/@type OrganisationType 1075 16 16 28
.//transaction/sector[@vocabulary = '1' or not(@vocabulary)]/@code Sector 163 325 287 30
.//transaction/sector/@vocabulary SectorVocabulary 169 14 9 1
.//document-link/@format FileFormat 812 1650 143 6
.//document-link/category/@code DocumentCategory 816 30 30 0
.//document-link/language/@code Language 722 181 21 1
.//other-identifier/@type OtherIdentifierType 300 6 6 2
.//planned-disbursement/provider-org/@type OrganisationType 133 16 13 7
.//planned-disbursement/receiver-org/@type OrganisationType 116 16 16 7
.//related-activity/@type RelatedActivityType 462 5 5 0
.//transaction/aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 439 24 21 5
.//transaction/aid-type/@vocabulary AidTypeVocabulary 330 4 4 0
.//result/document-link/@format FileFormat 158 1650 58 0
.//result/document-link/category/@code DocumentCategory 159 30 14 0
.//result/document-link/language/@code Language 91 181 6 0
.//transaction/tied-status/@code TiedStatus 386 3 3 1
.//country-budget-items/@vocabulary BudgetIdentifierVocabulary 67 5 5 0
.//location/location-class/@code GeographicLocationClass 158 4 4 0
.//location/location-id/@vocabulary GeographicVocabulary 138 6 6 2
.//location/location-reach/@code GeographicLocationReach 264 2 2 0
.//location/exactness/@code GeographicExactness 190 2 2 0
.//result/indicator/reference/@vocabulary IndicatorVocabulary 278 10 10 1
.//sector[@vocabulary = '7']/@code UNSDG-Goals 140 17 17 32
.//transaction/aid-type[@vocabulary = '2']/@code EarmarkingCategory 14 4 4 0
.//conditions/condition/@type ConditionType 67 3 3 0
.//tag[@vocabulary = '2']/@code UNSDG-Goals 69 17 17 0
.//tag/@vocabulary TagVocabulary 121 6 5 0
.//location/administrative/@vocabulary GeographicVocabulary 78 6 6 1
.//location/administrative[@vocabulary = 'A4']/@code Country 26 251 224 22
.//location/feature-designation/@code LocationType 82 682 101 23
.//result/reference/@vocabulary ResultVocabulary 82 1 1 0
.//sector[@vocabulary = '8']/@code UNSDG-Targets 33 169 169 1
.//tag[@vocabulary = '3']/@code UNSDG-Targets 20 169 169 0
.//default-aid-type[@vocabulary = '4']/@code CashandVoucherModalities 7 2 2 1
.//transaction/sector[@vocabulary = '2']/@code SectorCategory 18 44 41 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/document-link/@format FileFormat 27 1650 16 0
.//result/indicator/document-link/category/@code DocumentCategory 31 30 7 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/target/document-link/@format FileFormat 15 1650 10 0
.//result/indicator/period/target/document-link/category/@code DocumentCategory 16 30 7 0
.//default-aid-type[@vocabulary = '2']/@code EarmarkingCategory 12 4 4 0
.//transaction/aid-type[@vocabulary = '4']/@code CashandVoucherModalities 12 2 2 0
.//result/indicator/baseline/document-link/language/@code Language 2 181 1 0
.//result/indicator/document-link/language/@code Language 5 181 4 0
.//result/indicator/period/actual/document-link/language/@code Language 2 181 1 0
.//result/indicator/period/target/document-link/language/@code Language 2 181 1 0
.//transaction/sector[@vocabulary = '7']/@code UNSDG-Goals 5 17 6 0
.//crs-add/channel-code/text() CRSChannelCode 2 438 109 3
.//transaction/sector[@vocabulary = '8']/@code UNSDG-Targets 1 169 1 0
.//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
.//budget/value/@currency Currency 43 176 6 105
.//collaboration-type/@code CollaborationType 22 7 5 1
.//conditions/condition/@type ConditionType 3 3 2 0
.//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
.//default-tied-status/@code TiedStatus 28 3 3 0
.//description/@type DescriptionType 49 4 4 0
.//document-link/@format FileFormat 22 1650 12 2
.//document-link/category/@code DocumentCategory 25 26 14 0
.//location/location-type/@code LocationType 9 682 5 0
.//planned-disbursement/value/@currency Currency 4 176 1 0
.//policy-marker/@significance PolicySignificance 7 5 4 0
.//policy-marker/@vocabulary Vocabulary 4 10 2 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/aid-type/@code AidType 35 24 14 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/transaction-type/@code TransactionType 66 10 5 7
.//transaction/value/@currency Currency 43 176 10 2
.//@xml:lang Language 73 181 9 3
.//participating-org/@role OrganisationRole 68 4 4 6
.//participating-org/@type OrganisationType 60 16 11 1
.//sector[@vocabulary = 'DAC' or not(@vocabulary)]/@code Sector 45 325 171 74
.//transaction/disbursement-channel/@code DisbursementChannel 29 4 4 0
.//policy-marker[@vocabulary = '1' or not(@vocabulary)]/@code PolicyMarker 5 12 9 0
.//result/@type ResultType 4 4 3 0
.//result/description/@type DescriptionType 1 4 1 0
.//result/indicator/@measure IndicatorMeasure 4 5 4 0
.//result/indicator/description/@type DescriptionType 1 4 2 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
.//document-link/language/@code Language 8 181 1 0
.//contact-info/@type ContactType 8 4 2 30
.//location/location-reach/@code GeographicLocationReach 1 2 1 0
.//recipient-region/@vocabulary RegionVocabulary 5 3 1 0
.//location/administrative/@country Country 5 251 18 0
.//sector[@vocabulary = 'DAC-3']/@code SectorCategory 1 44 1 0
.//activity-scope/@code ActivityScope 4 8 6 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