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 1598 176 74 3
.//activity-date/@type ActivityDateType 1622 4 4 3
.//activity-status/@code ActivityStatus 1623 6 6 1
.//activity-scope/@code ActivityScope 439 8 8 2
.//budget/@status BudgetStatus 1365 2 2 1
.//budget/@type BudgetType 1413 2 2 0
.//contact-info/@type ContactType 918 4 4 3
.//description/@type DescriptionType 1572 4 4 0
.//participating-org/@role OrganisationRole 1619 4 4 2
.//participating-org/@type OrganisationType 1577 16 16 6
.//policy-marker[@vocabulary = '1' or not(@vocabulary)]/@code PolicyMarker 703 12 12 5
.//policy-marker/@significance PolicySignificance 696 5 5 5
.//policy-marker/@vocabulary PolicyMarkerVocabulary 682 2 2 2
.//recipient-country/@code Country 1544 251 241 48
.//recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 710 26 26 7
.//recipient-region/@vocabulary RegionVocabulary 637 3 3 0
.//related-activity/@type RelatedActivityType 446 5 5 0
.//reporting-org/@type OrganisationType 1624 16 15 0
.//sector[@vocabulary = '1' or not(@vocabulary)]/@code Sector 1446 325 321 108
.//sector/@vocabulary SectorVocabulary 1588 14 14 12
.//transaction/provider-org/@type OrganisationType 1123 16 15 33
.//transaction/receiver-org/@type OrganisationType 1015 16 16 27
.//transaction/transaction-type/@code TransactionType 1504 13 13 10
.//transaction/value/@currency Currency 1367 176 102 7
.//@xml:lang Language 1619 181 96 9
.//budget/value/@currency Currency 1377 176 61 2
.//default-aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 971 24 24 4
.//default-aid-type/@vocabulary AidTypeVocabulary 755 4 4 0
.//default-finance-type/@code FinanceType 960 68 32 0
.//default-flow-type/@code FlowType 980 10 9 1
.//default-tied-status/@code TiedStatus 903 3 3 3
.//participating-org/@crs-channel-code CRSChannelCode 427 438 289 1
.//transaction/aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 421 24 21 5
.//transaction/aid-type/@vocabulary AidTypeVocabulary 312 4 4 0
.//transaction/disbursement-channel/@code DisbursementChannel 614 4 4 0
.//transaction/finance-type/@code FinanceType 476 68 29 1
.//transaction/flow-type/@code FlowType 443 10 10 0
.//result/@type ResultType 692 4 4 1
.//result/indicator/@measure IndicatorMeasure 690 5 5 2
.//result/indicator/reference/@vocabulary IndicatorVocabulary 269 10 10 1
.//collaboration-type/@code CollaborationType 572 7 7 0
.//other-identifier/@type OtherIdentifierType 276 6 6 2
.//planned-disbursement/@type BudgetType 136 2 2 0
.//planned-disbursement/provider-org/@type OrganisationType 107 16 13 7
.//planned-disbursement/receiver-org/@type OrganisationType 92 16 16 7
.//planned-disbursement/value/@currency Currency 138 176 18 0
.//result/reference/@vocabulary ResultVocabulary 79 1 1 0
.//transaction/sector[@vocabulary = '1' or not(@vocabulary)]/@code Sector 163 325 288 32
.//transaction/sector/@vocabulary SectorVocabulary 169 14 9 1
.//transaction/tied-status/@code TiedStatus 373 3 3 1
.//@budget-not-provided BudgetNotProvided 30 3 3 0
.//document-link/@format FileFormat 783 1650 141 6
.//document-link/category/@code DocumentCategory 787 30 30 0
.//document-link/language/@code Language 708 181 23 1
.//result/document-link/@format FileFormat 148 1650 57 0
.//result/document-link/category/@code DocumentCategory 149 30 14 0
.//result/document-link/language/@code Language 88 181 6 0
.//location/feature-designation/@code LocationType 81 682 103 23
.//location/location-class/@code GeographicLocationClass 157 4 4 2
.//location/location-reach/@code GeographicLocationReach 252 2 2 0
.//location/exactness/@code GeographicExactness 220 2 2 0
.//sector[@vocabulary = '2']/@code SectorCategory 149 44 44 10
.//country-budget-items/@vocabulary BudgetIdentifierVocabulary 47 5 4 0
.//sector[@vocabulary = '7']/@code UNSDG-Goals 129 17 17 31
.//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 59 3 3 0
.//location/administrative/@vocabulary GeographicVocabulary 73 6 6 0
.//location/location-id/@vocabulary GeographicVocabulary 133 6 6 2
.//humanitarian-scope/@type HumanitarianScopeType 65 2 2 1
.//humanitarian-scope/@vocabulary HumanitarianScopeVocabulary 65 3 3 1
.//transaction/recipient-region/@vocabulary RegionVocabulary 50 3 3 0
.//location/administrative[@vocabulary = 'A4']/@code Country 25 251 224 23
.//tag/@vocabulary TagVocabulary 99 5 5 0
.//transaction/sector[@vocabulary = '2']/@code SectorCategory 18 44 41 0
.//sector[@vocabulary = '8']/@code UNSDG-Targets 30 169 169 1
.//tag[@vocabulary = '3']/@code UNSDG-Targets 19 169 169 18
.//transaction/aid-type[@vocabulary = '4']/@code CashandVoucherModalities 12 2 2 0
.//tag[@vocabulary = '2']/@code UNSDG-Goals 56 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
.//default-aid-type[@vocabulary = '4']/@code CashandVoucherModalities 5 2 2 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 72 176 9 0
.//activity-date/@type ActivityDateType 70 4 4 4
.//activity-status/@code ActivityStatus 69 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 27 68 8 1
.//default-flow-type/@code FlowType 41 10 5 1
.//participating-org/@role OrganisationRole 66 4 4 6
.//participating-org/@type OrganisationType 59 16 11 1
.//recipient-country/@code Country 68 251 152 127
.//recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 20 26 16 2
.//reporting-org/@type OrganisationType 71 16 7 2
.//sector/@vocabulary Vocabulary 50 10 5 5
.//transaction/transaction-type/@code TransactionType 64 10 5 7
.//@xml:lang Language 71 181 9 3
.//budget/value/@currency Currency 42 176 6 105
.//default-tied-status/@code TiedStatus 27 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 41 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