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 1708 176 62 4
.//activity-date/@type ActivityDateType 1732 4 4 3
.//activity-status/@code ActivityStatus 1733 6 6 1
.//activity-scope/@code ActivityScope 492 8 8 2
.//budget/@status BudgetStatus 1458 2 2 1
.//budget/@type BudgetType 1505 2 2 0
.//contact-info/@type ContactType 957 4 4 3
.//description/@type DescriptionType 1681 4 4 0
.//participating-org/@role OrganisationRole 1729 4 4 3
.//participating-org/@type OrganisationType 1663 16 16 6
.//policy-marker[@vocabulary = '1' or not(@vocabulary)]/@code PolicyMarker 733 12 12 5
.//policy-marker/@significance PolicySignificance 724 5 5 4
.//policy-marker/@vocabulary PolicyMarkerVocabulary 711 2 2 1
.//recipient-country/@code Country 1645 251 243 50
.//recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 756 26 26 7
.//recipient-region/@vocabulary RegionVocabulary 675 3 3 0
.//related-activity/@type RelatedActivityType 470 5 5 0
.//reporting-org/@type OrganisationType 1734 16 15 1
.//sector[@vocabulary = '1' or not(@vocabulary)]/@code Sector 1542 325 321 106
.//sector/@vocabulary SectorVocabulary 1690 14 14 13
.//transaction/provider-org/@type OrganisationType 1181 16 15 33
.//transaction/receiver-org/@type OrganisationType 1073 16 16 28
.//transaction/transaction-type/@code TransactionType 1600 13 13 10
.//transaction/value/@currency Currency 1453 176 95 5
.//@xml:lang Language 1729 181 98 9
.//budget/value/@currency Currency 1470 176 49 1
.//default-aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 1075 24 24 3
.//default-aid-type/@vocabulary AidTypeVocabulary 862 4 4 1
.//default-finance-type/@code FinanceType 1067 68 32 0
.//default-flow-type/@code FlowType 1085 10 9 1
.//default-tied-status/@code TiedStatus 1009 3 3 3
.//participating-org/@crs-channel-code CRSChannelCode 460 438 302 1
.//transaction/aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 493 24 21 5
.//transaction/aid-type/@vocabulary AidTypeVocabulary 384 4 4 0
.//transaction/disbursement-channel/@code DisbursementChannel 636 4 4 0
.//transaction/finance-type/@code FinanceType 548 68 29 1
.//transaction/flow-type/@code FlowType 516 10 10 0
.//result/@type ResultType 719 4 4 1
.//result/indicator/@measure IndicatorMeasure 717 5 5 3
.//result/indicator/reference/@vocabulary IndicatorVocabulary 274 10 10 1
.//collaboration-type/@code CollaborationType 601 7 7 0
.//other-identifier/@type OtherIdentifierType 307 6 6 2
.//planned-disbursement/@type BudgetType 153 2 2 0
.//planned-disbursement/provider-org/@type OrganisationType 132 16 13 7
.//planned-disbursement/receiver-org/@type OrganisationType 116 16 16 7
.//planned-disbursement/value/@currency Currency 155 176 17 0
.//result/reference/@vocabulary ResultVocabulary 81 1 1 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 439 3 3 1
.//@budget-not-provided BudgetNotProvided 33 3 3 0
.//document-link/@format FileFormat 806 1650 144 4
.//document-link/category/@code DocumentCategory 810 30 30 0
.//document-link/language/@code Language 724 181 22 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
.//location/feature-designation/@code LocationType 82 682 103 23
.//location/location-class/@code GeographicLocationClass 158 4 4 2
.//location/location-reach/@code GeographicLocationReach 261 2 2 0
.//location/exactness/@code GeographicExactness 224 2 2 0
.//sector[@vocabulary = '2']/@code SectorCategory 158 44 44 15
.//country-budget-items/@vocabulary BudgetIdentifierVocabulary 64 5 5 0
.//sector[@vocabulary = '7']/@code UNSDG-Goals 140 17 17 32
.//transaction/sector[@vocabulary = '7']/@code UNSDG-Goals 5 17 6 0
.//transaction/recipient-country/@code Country 155 251 216 34
.//transaction/recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 90 26 26 4
.//humanitarian-scope/@type HumanitarianScopeType 69 2 2 1
.//humanitarian-scope/@vocabulary HumanitarianScopeVocabulary 69 3 3 1
.//conditions/condition/@type ConditionType 67 3 3 0
.//location/administrative/@vocabulary GeographicVocabulary 78 6 6 1
.//location/location-id/@vocabulary GeographicVocabulary 138 6 6 2
.//transaction/recipient-region/@vocabulary RegionVocabulary 50 3 3 0
.//location/administrative[@vocabulary = 'A4']/@code Country 26 251 224 23
.//tag/@vocabulary TagVocabulary 120 5 5 0
.//transaction/sector[@vocabulary = '2']/@code SectorCategory 18 44 41 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 12 2 2 0
.//default-aid-type[@vocabulary = '4']/@code CashandVoucherModalities 6 2 2 1
.//default-aid-type[@vocabulary = '2']/@code EarmarkingCategory 11 4 4 0
.//tag[@vocabulary = '2']/@code UNSDG-Goals 70 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 10 1650 7 0
.//result/indicator/baseline/document-link/category/@code DocumentCategory 12 30 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
.//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