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 1698 176 63 4
.//activity-date/@type ActivityDateType 1724 4 4 3
.//activity-status/@code ActivityStatus 1725 6 6 1
.//activity-scope/@code ActivityScope 489 8 8 2
.//budget/@status BudgetStatus 1453 2 2 1
.//budget/@type BudgetType 1499 2 2 0
.//budget/value/@currency Currency 1466 176 52 1
.//collaboration-type/@code CollaborationType 602 7 7 0
.//default-aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 1068 24 24 4
.//default-aid-type/@vocabulary AidTypeVocabulary 856 4 4 1
.//default-finance-type/@code FinanceType 1061 68 32 0
.//default-flow-type/@code FlowType 1080 10 9 1
.//default-tied-status/@code TiedStatus 1004 3 3 4
.//description/@type DescriptionType 1672 4 4 0
.//document-link/@format FileFormat 804 1650 142 4
.//document-link/category/@code DocumentCategory 808 30 30 0
.//document-link/language/@code Language 720 181 22 1
.//location/administrative/@vocabulary GeographicVocabulary 76 6 6 1
.//location/location-class/@code GeographicLocationClass 157 4 4 0
.//location/location-id/@vocabulary GeographicVocabulary 136 6 6 2
.//location/location-reach/@code GeographicLocationReach 260 2 2 0
.//location/exactness/@code GeographicExactness 222 2 2 0
.//participating-org/@role OrganisationRole 1721 4 4 2
.//participating-org/@type OrganisationType 1656 16 16 6
.//policy-marker[@vocabulary = '1' or not(@vocabulary)]/@code PolicyMarker 728 12 12 5
.//policy-marker/@significance PolicySignificance 720 5 5 4
.//policy-marker/@vocabulary PolicyMarkerVocabulary 707 2 2 1
.//recipient-country/@code Country 1637 251 242 48
.//recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 747 26 26 7
.//recipient-region/@vocabulary RegionVocabulary 667 3 3 0
.//related-activity/@type RelatedActivityType 461 5 5 0
.//reporting-org/@type OrganisationType 1726 16 15 1
.//result/@type ResultType 716 4 4 1
.//result/indicator/@measure IndicatorMeasure 714 5 5 3
.//result/indicator/reference/@vocabulary IndicatorVocabulary 273 10 10 1
.//sector[@vocabulary = '1' or not(@vocabulary)]/@code Sector 1530 325 321 108
.//sector[@vocabulary = '7']/@code UNSDG-Goals 140 17 17 32
.//sector/@vocabulary SectorVocabulary 1685 14 14 13
.//tag[@vocabulary = '3']/@code UNSDG-Targets 20 169 169 0
.//tag/@vocabulary TagVocabulary 116 6 5 0
.//transaction/provider-org/@type OrganisationType 1178 16 15 33
.//transaction/receiver-org/@type OrganisationType 1067 16 16 28
.//transaction/transaction-type/@code TransactionType 1591 13 13 10
.//transaction/value/@currency Currency 1444 176 96 5
.//@xml:lang Language 1721 181 98 9
.//sector[@vocabulary = '8']/@code UNSDG-Targets 33 169 169 1
.//location/administrative[@vocabulary = 'A4']/@code Country 25 251 224 23
.//location/feature-designation/@code LocationType 82 682 101 23
.//participating-org/@crs-channel-code CRSChannelCode 463 438 296 1
.//result/document-link/@format FileFormat 151 1650 58 0
.//result/document-link/category/@code DocumentCategory 152 30 14 0
.//result/document-link/language/@code Language 90 181 6 0
.//transaction/aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 490 24 21 5
.//transaction/aid-type/@vocabulary AidTypeVocabulary 381 4 4 0
.//transaction/disbursement-channel/@code DisbursementChannel 635 4 4 0
.//transaction/finance-type/@code FinanceType 546 68 29 1
.//transaction/flow-type/@code FlowType 513 10 10 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 436 3 3 1
.//conditions/condition/@type ConditionType 67 3 3 0
.//country-budget-items/@vocabulary BudgetIdentifierVocabulary 62 5 5 0
.//planned-disbursement/@type BudgetType 150 2 2 0
.//planned-disbursement/value/@currency Currency 152 176 17 0
.//other-identifier/@type OtherIdentifierType 307 6 6 2
.//contact-info/@type ContactType 954 4 4 3
.//planned-disbursement/provider-org/@type OrganisationType 131 16 13 7
.//planned-disbursement/receiver-org/@type OrganisationType 114 16 16 7
.//sector[@vocabulary = '2']/@code SectorCategory 161 44 44 15
.//transaction/aid-type[@vocabulary = '2']/@code EarmarkingCategory 14 4 4 0
.//transaction/recipient-country/@code Country 155 251 216 34
.//transaction/recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 90 26 26 4
.//transaction/recipient-region/@vocabulary RegionVocabulary 50 3 3 0
.//result/reference/@vocabulary ResultVocabulary 82 1 1 0
.//transaction/sector[@vocabulary = '2']/@code SectorCategory 18 44 41 0
.//default-aid-type[@vocabulary = '2']/@code EarmarkingCategory 12 4 4 0
.//tag[@vocabulary = '2']/@code UNSDG-Goals 68 17 17 0
.//result/indicator/document-link/@format FileFormat 25 1650 15 0
.//result/indicator/document-link/category/@code DocumentCategory 29 30 7 0
.//result/indicator/document-link/language/@code Language 5 181 4 0
.//@budget-not-provided BudgetNotProvided 32 3 3 0
.//result/indicator/baseline/document-link/@format FileFormat 10 1650 7 0
.//result/indicator/baseline/document-link/category/@code DocumentCategory 12 30 6 0
.//humanitarian-scope/@type HumanitarianScopeType 68 2 2 1
.//humanitarian-scope/@vocabulary HumanitarianScopeVocabulary 68 3 3 1
.//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 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
.//default-aid-type[@vocabulary = '4']/@code CashandVoucherModalities 6 2 2 1
.//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 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
.//budget/value/@currency Currency 43 176 6 105
.//description/@type DescriptionType 50 4 4 0
.//participating-org/@role OrganisationRole 69 4 4 7
.//participating-org/@type OrganisationType 61 16 11 1
.//recipient-country/@code Country 71 251 195 43
.//reporting-org/@type OrganisationType 74 16 7 2
.//sector[@vocabulary = 'DAC' or not(@vocabulary)]/@code Sector 45 325 171 74
.//@xml:lang Language 74 181 9 3
.//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
.//location/administrative/@country Country 5 251 18 0
.//location/location-type/@code LocationType 9 682 5 0
.//result/@type ResultType 5 4 3 0
.//result/indicator/@measure IndicatorMeasure 5 5 4 0
.//sector[@vocabulary = 'DAC-3']/@code SectorCategory 1 44 1 0
.//sector/@vocabulary Vocabulary 51 10 5 4
.//default-aid-type/@code AidType 40 24 14 1
.//default-flow-type/@code FlowType 42 10 5 1
.//document-link/language/@code Language 9 181 2 0
.//transaction/transaction-type/@code TransactionType 67 10 5 7
.//default-finance-type/@code FinanceType 29 68 9 1
.//default-tied-status/@code TiedStatus 28 3 3 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 = '1' or not(@vocabulary)]/@code Region 22 26 17 2
.//recipient-region/@vocabulary RegionVocabulary 6 3 1 0
.//transaction/disbursement-channel/@code DisbursementChannel 29 4 4 0
.//transaction/value/@currency Currency 43 176 10 2
.//activity-scope/@code ActivityScope 5 8 8 0
.//collaboration-type/@code CollaborationType 23 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 34 10 6 0
.//transaction/tied-status/@code TiedStatus 31 3 3 1
.//planned-disbursement/value/@currency Currency 4 176 1 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
.//related-activity/@type RelatedActivityType 2 5 2 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