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 1751 176 64 3
.//activity-date/@type ActivityDateType 1781 4 4 3
.//activity-status/@code ActivityStatus 1782 6 6 1
.//activity-scope/@code ActivityScope 510 8 8 2
.//budget/@status BudgetStatus 1503 2 2 1
.//budget/@type BudgetType 1549 2 2 0
.//budget/value/@currency Currency 1515 176 52 1
.//collaboration-type/@code CollaborationType 618 7 7 0
.//default-aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 1123 24 24 4
.//default-aid-type/@vocabulary AidTypeVocabulary 904 4 4 1
.//default-finance-type/@code FinanceType 1118 68 31 0
.//default-flow-type/@code FlowType 1137 10 10 2
.//default-tied-status/@code TiedStatus 1060 3 3 4
.//description/@type DescriptionType 1726 4 4 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
.//location/administrative/@vocabulary GeographicVocabulary 77 6 6 1
.//location/location-class/@code GeographicLocationClass 159 4 4 0
.//location/location-id/@vocabulary GeographicVocabulary 139 6 6 2
.//location/location-reach/@code GeographicLocationReach 267 2 2 0
.//location/exactness/@code GeographicExactness 225 2 2 0
.//participating-org/@role OrganisationRole 1778 4 4 2
.//participating-org/@type OrganisationType 1700 16 16 6
.//policy-marker[@vocabulary = '1' or not(@vocabulary)]/@code PolicyMarker 742 12 12 6
.//policy-marker/@significance PolicySignificance 734 5 5 4
.//policy-marker/@vocabulary PolicyMarkerVocabulary 721 2 2 1
.//recipient-country/@code Country 1685 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 471 5 5 0
.//reporting-org/@type OrganisationType 1783 16 15 1
.//result/@type ResultType 729 4 4 1
.//result/indicator/@measure IndicatorMeasure 727 5 5 3
.//result/indicator/reference/@vocabulary IndicatorVocabulary 281 10 10 1
.//sector[@vocabulary = '1' or not(@vocabulary)]/@code Sector 1583 325 321 110
.//sector[@vocabulary = '7']/@code UNSDG-Goals 142 17 17 44
.//sector/@vocabulary SectorVocabulary 1736 14 14 13
.//tag[@vocabulary = '3']/@code UNSDG-Targets 20 169 169 0
.//tag/@vocabulary TagVocabulary 122 6 5 0
.//transaction/provider-org/@type OrganisationType 1206 16 15 34
.//transaction/receiver-org/@type OrganisationType 1088 16 16 28
.//transaction/transaction-type/@code TransactionType 1641 13 13 10
.//transaction/value/@currency Currency 1492 176 96 5
.//@xml:lang Language 1779 181 99 9
.//location/administrative[@vocabulary = 'A4']/@code Country 25 251 221 22
.//location/feature-designation/@code LocationType 82 682 101 23
.//participating-org/@crs-channel-code CRSChannelCode 474 438 325 2
.//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
.//transaction/aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 495 24 21 9
.//transaction/aid-type/@vocabulary AidTypeVocabulary 386 4 4 0
.//transaction/disbursement-channel/@code DisbursementChannel 644 4 4 0
.//transaction/finance-type/@code FinanceType 554 68 29 1
.//transaction/flow-type/@code FlowType 519 10 10 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 442 3 3 1
.//conditions/condition/@type ConditionType 69 3 3 0
.//country-budget-items/@vocabulary BudgetIdentifierVocabulary 68 5 5 0
.//planned-disbursement/@type BudgetType 158 2 2 0
.//planned-disbursement/value/@currency Currency 160 176 17 0
.//other-identifier/@type OtherIdentifierType 313 7 6 2
.//contact-info/@type ContactType 970 4 4 3
.//planned-disbursement/provider-org/@type OrganisationType 135 16 13 7
.//planned-disbursement/receiver-org/@type OrganisationType 117 16 16 7
.//sector[@vocabulary = '2']/@code SectorCategory 162 44 44 15
.//transaction/aid-type[@vocabulary = '2']/@code EarmarkingCategory 14 4 4 0
.//transaction/recipient-country/@code Country 157 251 216 34
.//transaction/recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 91 26 26 6
.//transaction/recipient-region/@vocabulary RegionVocabulary 51 3 3 0
.//result/reference/@vocabulary ResultVocabulary 80 1 1 0
.//transaction/sector[@vocabulary = '2']/@code SectorCategory 18 44 41 0
.//default-aid-type[@vocabulary = '2']/@code EarmarkingCategory 11 4 4 0
.//tag[@vocabulary = '2']/@code UNSDG-Goals 71 17 17 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
.//sector[@vocabulary = '8']/@code UNSDG-Targets 30 169 169 1
.//@budget-not-provided BudgetNotProvided 35 3 3 0
.//result/indicator/baseline/document-link/@format FileFormat 11 1650 7 0
.//result/indicator/baseline/document-link/category/@code DocumentCategory 13 30 6 0
.//default-aid-type[@vocabulary = '4']/@code CashandVoucherModalities 7 2 2 1
.//humanitarian-scope/@type HumanitarianScopeType 76 2 2 0
.//humanitarian-scope/@vocabulary HumanitarianScopeVocabulary 76 3 3 0
.//crs-add/other-flags/@code CRSAddOtherFlags 2 4 3 0
.//transaction/sector[@vocabulary = '7']/@code UNSDG-Goals 5 17 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
.//transaction/aid-type[@vocabulary = '4']/@code CashandVoucherModalities 12 2 2 0
.//crs-add/channel-code/text() CRSChannelCode 2 438 109 3
.//transaction/sector[@vocabulary = '8']/@code UNSDG-Targets 1 169 1 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
.//description/@type DescriptionType 49 4 4 0
.//participating-org/@role OrganisationRole 68 4 4 6
.//participating-org/@type OrganisationType 60 16 11 1
.//recipient-country/@code Country 70 251 166 43
.//reporting-org/@type OrganisationType 73 16 7 2
.//sector[@vocabulary = 'DAC' or not(@vocabulary)]/@code Sector 45 325 171 74
.//@xml:lang Language 73 181 9 3
.//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
.//location/administrative/@country Country 5 251 18 0
.//location/location-type/@code LocationType 9 682 5 0
.//result/@type ResultType 4 4 3 0
.//result/indicator/@measure IndicatorMeasure 4 5 4 0
.//sector[@vocabulary = 'DAC-3']/@code SectorCategory 1 44 1 0
.//sector/@vocabulary Vocabulary 50 10 5 4
.//default-aid-type/@code AidType 39 24 10 1
.//default-flow-type/@code FlowType 42 10 5 1
.//document-link/language/@code Language 8 181 1 0
.//transaction/transaction-type/@code TransactionType 66 10 5 7
.//default-finance-type/@code FinanceType 28 68 8 1
.//default-tied-status/@code TiedStatus 28 3 3 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 = '1' or not(@vocabulary)]/@code Region 21 26 16 2
.//recipient-region/@vocabulary RegionVocabulary 5 3 1 0
.//transaction/disbursement-channel/@code DisbursementChannel 29 4 4 0
.//transaction/value/@currency Currency 43 176 10 2
.//activity-scope/@code ActivityScope 4 8 6 0
.//collaboration-type/@code CollaborationType 22 7 5 1
.//location/coordinates/@precision GeographicalPrecision 3 9 2 0
.//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
.//planned-disbursement/value/@currency Currency 4 176 1 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
.//location/gazetteer-entry/@gazetteer-ref GazetteerAgency 2 3 2 0
.//related-activity/@type RelatedActivityType 1 5 1 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