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 1701 176 63 4
.//activity-date/@type ActivityDateType 1727 4 4 3
.//activity-status/@code ActivityStatus 1728 6 6 1
.//activity-scope/@code ActivityScope 491 8 8 2
.//budget/@status BudgetStatus 1456 2 2 1
.//budget/@type BudgetType 1501 2 2 0
.//contact-info/@type ContactType 956 4 4 3
.//description/@type DescriptionType 1674 4 4 0
.//participating-org/@role OrganisationRole 1724 4 4 2
.//participating-org/@type OrganisationType 1658 16 16 6
.//policy-marker[@vocabulary = '1' or not(@vocabulary)]/@code PolicyMarker 731 12 12 5
.//policy-marker/@significance PolicySignificance 723 5 5 4
.//policy-marker/@vocabulary PolicyMarkerVocabulary 710 2 2 1
.//recipient-country/@code Country 1640 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 1729 16 15 1
.//sector[@vocabulary = '1' or not(@vocabulary)]/@code Sector 1533 325 321 108
.//sector/@vocabulary SectorVocabulary 1688 14 14 13
.//transaction/provider-org/@type OrganisationType 1181 16 15 33
.//transaction/receiver-org/@type OrganisationType 1069 16 16 28
.//transaction/transaction-type/@code TransactionType 1594 13 13 10
.//transaction/value/@currency Currency 1447 176 96 5
.//@xml:lang Language 1724 181 98 9
.//budget/value/@currency Currency 1469 176 52 1
.//default-aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 1072 24 24 4
.//default-aid-type/@vocabulary AidTypeVocabulary 859 4 4 1
.//default-finance-type/@code FinanceType 1065 68 32 0
.//default-flow-type/@code FlowType 1084 10 9 1
.//default-tied-status/@code TiedStatus 1008 3 3 4
.//participating-org/@crs-channel-code CRSChannelCode 464 438 296 1
.//transaction/aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 491 24 21 5
.//transaction/aid-type/@vocabulary AidTypeVocabulary 382 4 4 0
.//transaction/disbursement-channel/@code DisbursementChannel 638 4 4 0
.//transaction/finance-type/@code FinanceType 548 68 29 1
.//transaction/flow-type/@code FlowType 515 10 10 0
.//result/@type ResultType 718 4 4 1
.//result/indicator/@measure IndicatorMeasure 716 5 5 3
.//result/indicator/reference/@vocabulary IndicatorVocabulary 276 10 10 1
.//collaboration-type/@code CollaborationType 603 7 7 0
.//other-identifier/@type OtherIdentifierType 309 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 162 325 288 29
.//transaction/sector/@vocabulary SectorVocabulary 168 14 9 1
.//transaction/tied-status/@code TiedStatus 437 3 3 1
.//@budget-not-provided BudgetNotProvided 32 3 3 0
.//document-link/@format FileFormat 806 1650 143 4
.//document-link/category/@code DocumentCategory 810 30 30 0
.//document-link/language/@code Language 722 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 155 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 22
.//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