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 1638 176 61 3
.//activity-date/@type ActivityDateType 1661 4 4 3
.//activity-status/@code ActivityStatus 1662 6 6 1
.//activity-scope/@code ActivityScope 461 8 8 2
.//budget/@status BudgetStatus 1387 2 2 1
.//budget/@type BudgetType 1436 2 2 0
.//contact-info/@type ContactType 944 4 4 3
.//description/@type DescriptionType 1608 4 4 0
.//participating-org/@role OrganisationRole 1658 4 4 3
.//participating-org/@type OrganisationType 1611 16 16 6
.//policy-marker[@vocabulary = '1' or not(@vocabulary)]/@code PolicyMarker 727 12 12 5
.//policy-marker/@significance PolicySignificance 717 5 5 5
.//policy-marker/@vocabulary PolicyMarkerVocabulary 704 2 2 2
.//recipient-country/@code Country 1583 251 241 50
.//recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 726 26 26 7
.//recipient-region/@vocabulary RegionVocabulary 649 3 3 0
.//related-activity/@type RelatedActivityType 463 5 5 0
.//reporting-org/@type OrganisationType 1663 16 15 0
.//sector[@vocabulary = '1' or not(@vocabulary)]/@code Sector 1483 325 321 106
.//sector/@vocabulary SectorVocabulary 1627 14 14 13
.//transaction/provider-org/@type OrganisationType 1156 16 15 34
.//transaction/receiver-org/@type OrganisationType 1050 16 16 28
.//transaction/transaction-type/@code TransactionType 1543 13 13 10
.//transaction/value/@currency Currency 1395 176 95 5
.//@xml:lang Language 1658 181 96 9
.//budget/value/@currency Currency 1400 176 48 1
.//default-aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 1007 24 24 4
.//default-aid-type/@vocabulary AidTypeVocabulary 793 4 4 1
.//default-finance-type/@code FinanceType 999 68 32 0
.//default-flow-type/@code FlowType 1017 10 9 1
.//default-tied-status/@code TiedStatus 942 3 3 3
.//participating-org/@crs-channel-code CRSChannelCode 445 438 301 1
.//transaction/aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 484 24 21 5
.//transaction/aid-type/@vocabulary AidTypeVocabulary 375 4 4 0
.//transaction/disbursement-channel/@code DisbursementChannel 629 4 4 0
.//transaction/finance-type/@code FinanceType 538 68 29 1
.//transaction/flow-type/@code FlowType 503 10 10 0
.//result/@type ResultType 720 4 4 1
.//result/indicator/@measure IndicatorMeasure 718 5 5 3
.//result/indicator/reference/@vocabulary IndicatorVocabulary 277 10 10 1
.//collaboration-type/@code CollaborationType 584 7 7 0
.//other-identifier/@type OtherIdentifierType 296 6 6 2
.//planned-disbursement/@type BudgetType 139 2 2 0
.//planned-disbursement/provider-org/@type OrganisationType 120 16 13 7
.//planned-disbursement/receiver-org/@type OrganisationType 104 16 16 7
.//planned-disbursement/value/@currency Currency 141 176 17 0
.//result/reference/@vocabulary ResultVocabulary 81 1 1 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
.//@budget-not-provided BudgetNotProvided 29 3 3 0
.//document-link/@format FileFormat 803 1650 144 6
.//document-link/category/@code DocumentCategory 807 30 30 0
.//document-link/language/@code Language 724 181 23 5
.//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
.//location/feature-designation/@code LocationType 81 682 103 23
.//location/location-class/@code GeographicLocationClass 157 4 4 2
.//location/location-reach/@code GeographicLocationReach 255 2 2 0
.//location/exactness/@code GeographicExactness 222 2 2 0
.//sector[@vocabulary = '2']/@code SectorCategory 153 44 44 15
.//country-budget-items/@vocabulary BudgetIdentifierVocabulary 51 5 5 0
.//sector[@vocabulary = '7']/@code UNSDG-Goals 135 17 17 32
.//transaction/sector[@vocabulary = '7']/@code UNSDG-Goals 5 17 6 0
.//transaction/recipient-country/@code Country 154 251 213 34
.//transaction/recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 91 26 26 4
.//conditions/condition/@type ConditionType 63 3 3 0
.//location/administrative/@vocabulary GeographicVocabulary 74 6 6 1
.//location/location-id/@vocabulary GeographicVocabulary 133 6 6 2
.//humanitarian-scope/@type HumanitarianScopeType 68 2 2 1
.//humanitarian-scope/@vocabulary HumanitarianScopeVocabulary 68 3 3 1
.//transaction/recipient-region/@vocabulary RegionVocabulary 50 3 3 0
.//location/administrative[@vocabulary = 'A4']/@code Country 24 251 221 23
.//tag/@vocabulary TagVocabulary 105 5 5 0
.//transaction/sector[@vocabulary = '2']/@code SectorCategory 18 44 41 0
.//sector[@vocabulary = '8']/@code UNSDG-Targets 34 169 169 1
.//tag[@vocabulary = '3']/@code UNSDG-Targets 20 169 169 18
.//transaction/aid-type[@vocabulary = '4']/@code CashandVoucherModalities 12 2 2 0
.//default-aid-type[@vocabulary = '4']/@code CashandVoucherModalities 6 2 2 1
.//tag[@vocabulary = '2']/@code UNSDG-Goals 59 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
.//default-aid-type[@vocabulary = '2']/@code EarmarkingCategory 8 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 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
.//collaboration-type/@code CollaborationType 22 7 5 1
.//default-aid-type/@code AidType 39 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 67 4 4 6
.//participating-org/@type OrganisationType 60 16 11 1
.//recipient-country/@code Country 69 251 152 127
.//recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 20 26 16 2
.//reporting-org/@type OrganisationType 72 16 7 2
.//sector/@vocabulary Vocabulary 50 10 5 5
.//transaction/transaction-type/@code TransactionType 65 10 5 7
.//@xml:lang Language 72 181 9 3
.//budget/value/@currency Currency 43 176 6 105
.//default-tied-status/@code TiedStatus 27 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 46 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 42 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