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 1773 176 78 3
.//activity-date/@type ActivityDateType 1805 4 4 3
.//activity-status/@code ActivityStatus 1806 6 6 1
.//activity-scope/@code ActivityScope 520 8 8 2
.//budget/@status BudgetStatus 1526 2 2 1
.//budget/@type BudgetType 1572 2 2 0
.//contact-info/@type ContactType 974 4 4 3
.//description/@type DescriptionType 1752 4 4 0
.//participating-org/@role OrganisationRole 1802 4 4 2
.//participating-org/@type OrganisationType 1720 16 16 6
.//policy-marker[@vocabulary = '1' or not(@vocabulary)]/@code PolicyMarker 743 12 12 5
.//policy-marker/@significance PolicySignificance 736 5 5 4
.//policy-marker/@vocabulary PolicyMarkerVocabulary 724 2 2 1
.//recipient-country/@code Country 1710 251 242 47
.//recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 770 26 26 8
.//recipient-region/@vocabulary RegionVocabulary 697 3 3 0
.//related-activity/@type RelatedActivityType 471 5 5 0
.//reporting-org/@type OrganisationType 1807 16 15 2
.//sector[@vocabulary = '1' or not(@vocabulary)]/@code Sector 1605 325 321 107
.//sector/@vocabulary SectorVocabulary 1759 14 14 13
.//transaction/provider-org/@type OrganisationType 1218 16 15 34
.//transaction/receiver-org/@type OrganisationType 1101 16 16 28
.//transaction/transaction-type/@code TransactionType 1665 13 13 10
.//transaction/value/@currency Currency 1518 176 102 5
.//@xml:lang Language 1804 181 100 9
.//budget/value/@currency Currency 1538 176 65 1
.//default-aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 1146 24 24 4
.//default-aid-type/@vocabulary AidTypeVocabulary 927 4 4 0
.//default-finance-type/@code FinanceType 1141 68 31 0
.//default-flow-type/@code FlowType 1161 10 10 2
.//default-tied-status/@code TiedStatus 1085 3 3 3
.//participating-org/@crs-channel-code CRSChannelCode 480 438 326 2
.//transaction/aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 497 24 21 9
.//transaction/aid-type/@vocabulary AidTypeVocabulary 388 4 4 0
.//transaction/disbursement-channel/@code DisbursementChannel 645 4 4 0
.//transaction/finance-type/@code FinanceType 559 68 29 1
.//transaction/flow-type/@code FlowType 523 10 10 0
.//document-link/@format FileFormat 821 1650 145 4
.//document-link/category/@code DocumentCategory 824 30 30 0
.//document-link/language/@code Language 724 181 23 1
.//result/@type ResultType 728 4 4 1
.//result/indicator/@measure IndicatorMeasure 726 5 5 3
.//result/indicator/reference/@vocabulary IndicatorVocabulary 281 10 10 1
.//collaboration-type/@code CollaborationType 628 7 7 0
.//other-identifier/@type OtherIdentifierType 320 7 7 2
.//planned-disbursement/@type BudgetType 162 2 2 0
.//planned-disbursement/provider-org/@type OrganisationType 138 16 13 7
.//planned-disbursement/receiver-org/@type OrganisationType 121 16 16 7
.//planned-disbursement/value/@currency Currency 165 176 17 0
.//result/reference/@vocabulary ResultVocabulary 80 1 1 0
.//transaction/sector[@vocabulary = '1' or not(@vocabulary)]/@code Sector 165 325 288 29
.//transaction/sector/@vocabulary SectorVocabulary 170 14 9 1
.//transaction/tied-status/@code TiedStatus 445 3 3 1
.//@budget-not-provided BudgetNotProvided 37 3 3 0
.//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 92 181 6 0
.//location/feature-designation/@code LocationType 83 682 98 23
.//location/location-class/@code GeographicLocationClass 160 4 4 2
.//location/location-reach/@code GeographicLocationReach 270 2 2 0
.//location/exactness/@code GeographicExactness 226 2 2 0
.//sector[@vocabulary = '2']/@code SectorCategory 162 44 44 15
.//country-budget-items/@vocabulary BudgetIdentifierVocabulary 73 5 5 0
.//sector[@vocabulary = '7']/@code UNSDG-Goals 146 17 17 31
.//transaction/sector[@vocabulary = '7']/@code UNSDG-Goals 5 17 6 0
.//transaction/recipient-country/@code Country 160 251 216 34
.//transaction/recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 92 26 26 5
.//humanitarian-scope/@type HumanitarianScopeType 76 2 2 0
.//humanitarian-scope/@vocabulary HumanitarianScopeVocabulary 76 3 3 0
.//transaction/recipient-region/@vocabulary RegionVocabulary 53 3 3 0
.//result/indicator/baseline/document-link/@format FileFormat 12 1650 8 0
.//result/indicator/baseline/document-link/category/@code DocumentCategory 14 30 7 0
.//result/indicator/document-link/@format FileFormat 28 1650 16 0
.//result/indicator/document-link/category/@code DocumentCategory 32 30 8 0
.//location/administrative/@vocabulary GeographicVocabulary 77 6 6 1
.//location/administrative[@vocabulary = 'A4']/@code Country 25 251 221 22
.//location/location-id/@vocabulary GeographicVocabulary 141 6 6 2
.//tag/@vocabulary TagVocabulary 126 6 5 0
.//transaction/sector[@vocabulary = '2']/@code SectorCategory 18 44 41 0
.//conditions/condition/@type ConditionType 70 3 3 0
.//sector[@vocabulary = '8']/@code UNSDG-Targets 33 169 169 1
.//tag[@vocabulary = '3']/@code UNSDG-Targets 21 169 169 0
.//transaction/aid-type[@vocabulary = '4']/@code CashandVoucherModalities 13 2 2 0
.//default-aid-type[@vocabulary = '2']/@code EarmarkingCategory 11 4 4 0
.//tag[@vocabulary = '2']/@code UNSDG-Goals 73 17 17 0
.//transaction/aid-type[@vocabulary = '2']/@code EarmarkingCategory 14 4 4 0
.//result/indicator/document-link/language/@code Language 5 181 4 0
.//default-aid-type[@vocabulary = '4']/@code CashandVoucherModalities 6 2 2 0
.//transaction/sector[@vocabulary = '8']/@code UNSDG-Targets 1 169 1 0
.//result/indicator/baseline/document-link/language/@code Language 2 181 1 0
.//result/indicator/period/actual/document-link/@format FileFormat 15 1650 9 0
.//result/indicator/period/actual/document-link/category/@code DocumentCategory 16 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
.//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 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
.//collaboration-type/@code CollaborationType 22 7 5 1
.//default-aid-type/@code AidType 39 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 68 4 4 6
.//participating-org/@type OrganisationType 60 16 11 1
.//recipient-country/@code Country 70 251 166 43
.//recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 21 26 16 2
.//reporting-org/@type OrganisationType 73 16 7 2
.//sector/@vocabulary Vocabulary 50 10 5 4
.//transaction/transaction-type/@code TransactionType 66 10 5 7
.//@xml:lang Language 73 181 9 3
.//budget/value/@currency Currency 43 176 6 105
.//default-tied-status/@code TiedStatus 28 3 3 0
.//description/@type DescriptionType 49 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 33 10 4 0
.//transaction/tied-status/@code TiedStatus 30 3 3 1
.//transaction/value/@currency Currency 43 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