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 1642 176 60 3
.//activity-date/@type ActivityDateType 1665 4 4 3
.//activity-status/@code ActivityStatus 1666 6 6 1
.//activity-scope/@code ActivityScope 464 8 8 2
.//budget/@status BudgetStatus 1393 2 2 1
.//budget/@type BudgetType 1439 2 2 0
.//budget/value/@currency Currency 1405 176 47 0
.//collaboration-type/@code CollaborationType 583 7 7 0
.//default-aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 1011 24 24 4
.//default-aid-type/@vocabulary AidTypeVocabulary 800 4 4 1
.//default-finance-type/@code FinanceType 1003 68 32 0
.//default-flow-type/@code FlowType 1021 10 9 1
.//default-tied-status/@code TiedStatus 946 3 3 3
.//description/@type DescriptionType 1614 4 4 0
.//document-link/@format FileFormat 799 1650 144 4
.//document-link/category/@code DocumentCategory 803 30 30 0
.//document-link/language/@code Language 722 181 22 5
.//location/administrative/@vocabulary GeographicVocabulary 74 6 6 1
.//location/location-class/@code GeographicLocationClass 157 4 4 2
.//location/location-id/@vocabulary GeographicVocabulary 133 6 6 2
.//location/location-reach/@code GeographicLocationReach 255 2 2 0
.//location/exactness/@code GeographicExactness 222 2 2 0
.//participating-org/@role OrganisationRole 1662 4 4 3
.//participating-org/@type OrganisationType 1613 16 16 6
.//policy-marker[@vocabulary = '1' or not(@vocabulary)]/@code PolicyMarker 724 12 12 5
.//policy-marker/@significance PolicySignificance 715 5 5 5
.//policy-marker/@vocabulary PolicyMarkerVocabulary 702 2 2 2
.//recipient-country/@code Country 1584 251 242 50
.//recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 727 26 26 7
.//recipient-region/@vocabulary RegionVocabulary 649 3 3 0
.//related-activity/@type RelatedActivityType 462 5 5 0
.//reporting-org/@type OrganisationType 1667 16 15 1
.//result/@type ResultType 717 4 4 1
.//result/indicator/@measure IndicatorMeasure 715 5 5 3
.//result/indicator/reference/@vocabulary IndicatorVocabulary 276 10 10 1
.//sector[@vocabulary = '1' or not(@vocabulary)]/@code Sector 1485 325 321 106
.//sector[@vocabulary = '7']/@code UNSDG-Goals 137 17 17 32
.//sector/@vocabulary SectorVocabulary 1630 14 14 13
.//tag[@vocabulary = '3']/@code UNSDG-Targets 21 169 169 18
.//tag/@vocabulary TagVocabulary 107 5 5 0
.//transaction/provider-org/@type OrganisationType 1160 16 15 34
.//transaction/receiver-org/@type OrganisationType 1053 16 16 28
.//transaction/transaction-type/@code TransactionType 1545 13 13 10
.//transaction/value/@currency Currency 1399 176 95 4
.//@xml:lang Language 1662 181 95 9
.//sector[@vocabulary = '8']/@code UNSDG-Targets 34 169 169 1
.//location/administrative[@vocabulary = 'A4']/@code Country 24 251 221 23
.//location/feature-designation/@code LocationType 81 682 103 23
.//participating-org/@crs-channel-code CRSChannelCode 445 438 301 1
.//result/document-link/@format FileFormat 150 1650 58 0
.//result/document-link/category/@code DocumentCategory 151 30 14 0
.//result/document-link/language/@code Language 88 181 6 0
.//transaction/aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 485 24 21 5
.//transaction/aid-type/@vocabulary AidTypeVocabulary 376 4 4 0
.//transaction/disbursement-channel/@code DisbursementChannel 629 4 4 0
.//transaction/finance-type/@code FinanceType 539 68 29 1
.//transaction/flow-type/@code FlowType 506 10 10 0
.//transaction/sector[@vocabulary = '1' or not(@vocabulary)]/@code Sector 164 325 288 31
.//transaction/sector/@vocabulary SectorVocabulary 170 14 9 1
.//transaction/tied-status/@code TiedStatus 433 3 3 1
.//conditions/condition/@type ConditionType 63 3 3 0
.//country-budget-items/@vocabulary BudgetIdentifierVocabulary 53 5 5 0
.//planned-disbursement/@type BudgetType 140 2 2 0
.//planned-disbursement/value/@currency Currency 142 176 17 0
.//other-identifier/@type OtherIdentifierType 296 6 6 2
.//contact-info/@type ContactType 941 4 4 3
.//planned-disbursement/provider-org/@type OrganisationType 122 16 13 7
.//planned-disbursement/receiver-org/@type OrganisationType 106 16 16 7
.//sector[@vocabulary = '2']/@code SectorCategory 154 44 44 15
.//transaction/aid-type[@vocabulary = '2']/@code EarmarkingCategory 14 4 4 0
.//transaction/recipient-country/@code Country 154 251 216 34
.//transaction/recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 91 26 26 4
.//transaction/recipient-region/@vocabulary RegionVocabulary 50 3 3 0
.//result/reference/@vocabulary ResultVocabulary 81 1 1 0
.//transaction/sector[@vocabulary = '2']/@code SectorCategory 18 44 41 0
.//default-aid-type[@vocabulary = '2']/@code EarmarkingCategory 8 4 4 0
.//tag[@vocabulary = '2']/@code UNSDG-Goals 60 17 17 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
.//result/indicator/baseline/document-link/@format FileFormat 10 1650 7 0
.//result/indicator/baseline/document-link/category/@code DocumentCategory 12 30 6 0
.//default-aid-type[@vocabulary = '4']/@code CashandVoucherModalities 6 2 2 1
.//humanitarian-scope/@type HumanitarianScopeType 66 2 2 1
.//humanitarian-scope/@vocabulary HumanitarianScopeVocabulary 66 3 3 1
.//@budget-not-provided BudgetNotProvided 30 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 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 13 1650 10 0
.//result/indicator/period/target/document-link/category/@code DocumentCategory 14 30 6 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 73 176 9 0
.//activity-date/@type ActivityDateType 71 4 4 4
.//activity-status/@code ActivityStatus 70 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 67 4 4 6
.//participating-org/@type OrganisationType 60 16 11 1
.//recipient-country/@code Country 69 251 152 127
.//reporting-org/@type OrganisationType 72 16 7 2
.//sector[@vocabulary = 'DAC' or not(@vocabulary)]/@code Sector 46 325 171 74
.//@xml:lang Language 72 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 5
.//default-aid-type/@code AidType 39 24 10 1
.//default-flow-type/@code FlowType 41 10 5 1
.//document-link/language/@code Language 8 181 1 0
.//transaction/transaction-type/@code TransactionType 65 10 5 7
.//default-finance-type/@code FinanceType 27 68 8 1
.//default-tied-status/@code TiedStatus 27 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 20 26 16 2
.//recipient-region/@vocabulary RegionVocabulary 5 3 1 0
.//transaction/disbursement-channel/@code DisbursementChannel 29 4 4 0
.//transaction/value/@currency Currency 42 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