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 1610 176 72 3
.//activity-date/@type ActivityDateType 1633 4 4 3
.//activity-status/@code ActivityStatus 1635 6 6 1
.//activity-scope/@code ActivityScope 442 8 8 2
.//budget/@status BudgetStatus 1362 2 2 1
.//budget/@type BudgetType 1411 2 2 0
.//contact-info/@type ContactType 931 4 4 3
.//description/@type DescriptionType 1584 4 4 0
.//participating-org/@role OrganisationRole 1630 4 4 2
.//participating-org/@type OrganisationType 1591 16 16 5
.//policy-marker[@vocabulary = '1' or not(@vocabulary)]/@code PolicyMarker 718 12 12 5
.//policy-marker/@significance PolicySignificance 712 5 5 5
.//policy-marker/@vocabulary PolicyMarkerVocabulary 699 2 2 2
.//recipient-country/@code Country 1558 251 241 48
.//recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 715 26 26 7
.//recipient-region/@vocabulary RegionVocabulary 633 3 3 1
.//related-activity/@type RelatedActivityType 459 5 5 0
.//reporting-org/@type OrganisationType 1636 16 15 0
.//sector[@vocabulary = '1' or not(@vocabulary)]/@code Sector 1457 325 321 108
.//sector/@vocabulary SectorVocabulary 1599 14 14 3
.//transaction/provider-org/@type OrganisationType 1136 16 15 35
.//transaction/receiver-org/@type OrganisationType 1032 16 16 27
.//transaction/transaction-type/@code TransactionType 1516 13 13 10
.//transaction/value/@currency Currency 1367 176 97 6
.//@xml:lang Language 1630 181 95 9
.//budget/value/@currency Currency 1373 176 59 2
.//default-aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 983 24 24 4
.//default-aid-type/@vocabulary AidTypeVocabulary 768 4 4 1
.//default-finance-type/@code FinanceType 972 68 32 0
.//default-flow-type/@code FlowType 991 10 9 1
.//default-tied-status/@code TiedStatus 915 3 3 4
.//participating-org/@crs-channel-code CRSChannelCode 425 438 297 1
.//transaction/aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 423 24 21 5
.//transaction/aid-type/@vocabulary AidTypeVocabulary 313 4 4 0
.//transaction/disbursement-channel/@code DisbursementChannel 616 4 4 0
.//transaction/finance-type/@code FinanceType 478 68 29 1
.//transaction/flow-type/@code FlowType 444 10 10 0
.//result/@type ResultType 709 4 4 1
.//result/indicator/@measure IndicatorMeasure 707 5 5 2
.//result/indicator/reference/@vocabulary IndicatorVocabulary 274 10 10 1
.//collaboration-type/@code CollaborationType 576 7 7 0
.//other-identifier/@type OtherIdentifierType 293 6 6 2
.//planned-disbursement/@type BudgetType 136 2 2 0
.//planned-disbursement/provider-org/@type OrganisationType 117 16 13 7
.//planned-disbursement/receiver-org/@type OrganisationType 101 16 16 7
.//planned-disbursement/value/@currency Currency 138 176 18 0
.//result/reference/@vocabulary ResultVocabulary 78 1 1 0
.//transaction/sector[@vocabulary = '1' or not(@vocabulary)]/@code Sector 164 325 288 32
.//transaction/sector/@vocabulary SectorVocabulary 170 14 9 1
.//transaction/tied-status/@code TiedStatus 374 3 3 1
.//@budget-not-provided BudgetNotProvided 29 3 3 0
.//document-link/@format FileFormat 798 1650 144 6
.//document-link/category/@code DocumentCategory 802 30 30 0
.//document-link/language/@code Language 722 181 23 1
.//result/document-link/@format FileFormat 146 1650 57 0
.//result/document-link/category/@code DocumentCategory 147 30 14 0
.//result/document-link/language/@code Language 87 181 6 0
.//location/feature-designation/@code LocationType 80 682 102 24
.//location/location-class/@code GeographicLocationClass 154 4 4 3
.//location/location-reach/@code GeographicLocationReach 251 2 2 0
.//location/exactness/@code GeographicExactness 218 2 2 0
.//sector[@vocabulary = '2']/@code SectorCategory 149 44 44 10
.//country-budget-items/@vocabulary BudgetIdentifierVocabulary 46 5 4 0
.//sector[@vocabulary = '7']/@code UNSDG-Goals 129 17 17 32
.//transaction/sector[@vocabulary = '7']/@code UNSDG-Goals 5 17 6 0
.//transaction/recipient-country/@code Country 154 251 212 34
.//transaction/recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 90 26 26 3
.//conditions/condition/@type ConditionType 61 3 3 0
.//location/administrative/@vocabulary GeographicVocabulary 73 6 6 0
.//location/location-id/@vocabulary GeographicVocabulary 132 6 6 2
.//humanitarian-scope/@type HumanitarianScopeType 64 2 2 1
.//humanitarian-scope/@vocabulary HumanitarianScopeVocabulary 64 3 3 1
.//transaction/recipient-region/@vocabulary RegionVocabulary 49 3 3 0
.//location/administrative[@vocabulary = 'A4']/@code Country 24 251 224 23
.//tag/@vocabulary TagVocabulary 97 5 5 0
.//transaction/sector[@vocabulary = '2']/@code SectorCategory 18 44 41 0
.//sector[@vocabulary = '8']/@code UNSDG-Targets 31 169 169 1
.//tag[@vocabulary = '3']/@code UNSDG-Targets 17 169 169 18
.//transaction/aid-type[@vocabulary = '4']/@code CashandVoucherModalities 11 2 2 0
.//default-aid-type[@vocabulary = '4']/@code CashandVoucherModalities 5 2 2 1
.//tag[@vocabulary = '2']/@code UNSDG-Goals 57 17 17 0
.//transaction/aid-type[@vocabulary = '2']/@code EarmarkingCategory 14 4 4 0
.//result/indicator/document-link/@format FileFormat 25 1650 16 0
.//result/indicator/document-link/category/@code DocumentCategory 29 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 9 1650 7 0
.//result/indicator/baseline/document-link/category/@code DocumentCategory 11 30 6 0
.//result/indicator/baseline/document-link/language/@code Language 2 181 1 0
.//result/indicator/period/actual/document-link/@format FileFormat 12 1650 9 0
.//result/indicator/period/actual/document-link/category/@code DocumentCategory 13 30 6 0
.//result/indicator/period/actual/document-link/language/@code Language 2 181 1 0
.//result/indicator/period/target/document-link/@format FileFormat 12 1650 10 0
.//result/indicator/period/target/document-link/category/@code DocumentCategory 13 30 6 0
.//result/indicator/period/target/document-link/language/@code Language 2 181 1 0
.//default-aid-type[@vocabulary = '2']/@code EarmarkingCategory 9 4 4 0
.//crs-add/loan-status/@currency Currency 1 176 2 0
.//crs-add/loan-terms/repayment-plan/@code LoanRepaymentPeriod 1 4 1 1
.//crs-add/loan-terms/repayment-type/@code LoanRepaymentType 1 4 1 1
.//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 73 176 9 0
.//activity-date/@type ActivityDateType 71 4 4 4
.//activity-status/@code ActivityStatus 70 6 4 2
.//budget/@type BudgetType 48 2 2 0
.//collaboration-type/@code CollaborationType 22 7 5 1
.//default-aid-type/@code AidType 38 24 10 1
.//default-finance-type/@code FinanceType 28 68 8 1
.//default-flow-type/@code FlowType 42 10 5 1
.//participating-org/@role OrganisationRole 67 4 4 6
.//participating-org/@type OrganisationType 59 16 11 1
.//recipient-country/@code Country 69 251 166 127
.//recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 21 26 16 2
.//reporting-org/@type OrganisationType 72 16 7 2
.//sector/@vocabulary Vocabulary 50 10 5 4
.//transaction/transaction-type/@code TransactionType 65 10 5 7
.//@xml:lang Language 72 181 9 3
.//budget/value/@currency Currency 42 176 6 105
.//default-tied-status/@code TiedStatus 28 3 3 0
.//description/@type DescriptionType 48 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 34 24 14 0
.//transaction/disbursement-channel/@code DisbursementChannel 28 4 4 0
.//transaction/finance-type/@code FinanceType 32 68 2 0
.//transaction/flow-type/@code FlowType 32 10 4 0
.//transaction/tied-status/@code TiedStatus 29 3 3 1
.//transaction/value/@currency Currency 42 176 10 2
.//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
.//document-link/language/@code Language 8 181 1 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 RegionVocabulary 5 3 1 0
.//result/@type ResultType 4 4 3 0
.//result/indicator/@measure IndicatorMeasure 4 5 4 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
.//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 4 8 6 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
.//related-activity/@type RelatedActivityType 1 5 1 0
.//sector[@vocabulary = 'DAC-3']/@code SectorCategory 1 44 1 0