Codelists

How are codelists used in IATI data?

Checking usage of codelists across IATI data files.

Count of the different values used by all publishers, per codelist.

Note: some Elements/Attributes may use the same codelist. In each case, the values counted are different for each use.

Click the 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 1398 305 59 5
.//activity-date/@type ActivityDateType 1412 4 4 3
.//activity-status/@code ActivityStatus 1412 6 6 3
.//budget/@status BudgetStatus 1145 2 2 1
.//budget/@type BudgetType 1180 2 2 1
.//description/@type DescriptionType 1343 4 4 0
.//document-link/@format FileFormat 726 1665 128 13
.//document-link/category/@code DocumentCategory 726 30 30 2
.//document-link/language/@code Language 656 184 19 9
.//participating-org/@role OrganisationRole 1412 4 4 3
.//participating-org/@type OrganisationType 1397 16 16 8
.//recipient-country/@code Country 1347 257 238 71
.//reporting-org/@type OrganisationType 1412 16 16 0
.//sector[@vocabulary = '1' or not(@vocabulary)]/@code Sector 1272 325 322 170
.//sector/@vocabulary SectorVocabulary 1371 14 14 4
.//transaction/provider-org/@type OrganisationType 986 16 15 33
.//transaction/receiver-org/@type OrganisationType 876 16 16 26
.//transaction/transaction-type/@code TransactionType 1312 13 13 6
.//transaction/value/@currency Currency 1173 305 79 4
.//@xml:lang Language 1393 184 70 11
.//activity-scope/@code ActivityScope 333 8 8 2
.//budget/value/@currency Currency 1142 305 43 4
.//collaboration-type/@code CollaborationType 469 7 7 1
.//contact-info/@type ContactType 797 4 4 2
.//default-aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 790 23 23 82
.//default-tied-status/@code TiedStatus 742 3 3 7
.//related-activity/@type RelatedActivityType 421 5 5 1
.//result/@type ResultType 623 4 4 1
.//result/indicator/@measure IndicatorMeasure 623 5 5 2
.//transaction/finance-type/@code FinanceType 409 68 27 2
.//sector[@vocabulary = '2']/@code SectorCategory 127 44 44 10
.//recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 608 26 26 76
.//default-aid-type/@vocabulary AidTypeVocabulary 558 4 4 0
.//default-finance-type/@code FinanceType 776 68 33 3
.//default-flow-type/@code FlowType 791 10 9 2
.//other-identifier/@type OtherIdentifierType 250 6 6 2
.//policy-marker[@vocabulary = '1' or not(@vocabulary)]/@code PolicyMarker 645 12 12 4
.//policy-marker/@significance PolicySignificance 625 5 5 55
.//policy-marker/@vocabulary PolicyMarkerVocabulary 617 2 2 2
.//country-budget-items/@vocabulary BudgetIdentifierVocabulary 31 5 4 0
.//location/location-reach/@code GeographicLocationReach 208 2 2 0
.//location/exactness/@code GeographicExactness 170 2 2 0
.//participating-org/@crs-channel-code CRSChannelCode 312 432 271 0
.//planned-disbursement/@type BudgetType 102 2 2 0
.//planned-disbursement/provider-org/@type OrganisationType 90 16 10 9
.//planned-disbursement/value/@currency Currency 107 305 14 0
.//recipient-region/@vocabulary RegionVocabulary 515 3 3 1
.//tag[@vocabulary = '2']/@code UNSDG-Goals 29 17 17 0
.//tag/@vocabulary TagVocabulary 48 4 3 0
.//transaction/disbursement-channel/@code DisbursementChannel 519 4 4 0
.//transaction/aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 363 23 23 15
.//transaction/aid-type/@vocabulary AidTypeVocabulary 245 4 4 0
.//location/location-class/@code GeographicLocationClass 146 4 4 3
.//tag[@vocabulary = '3']/@code UNSDG-Targets 11 169 169 17
.//transaction/flow-type/@code FlowType 386 10 10 0
.//transaction/recipient-country/@code Country 111 257 194 32
.//transaction/recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 78 26 21 3
.//transaction/recipient-region/@vocabulary RegionVocabulary 33 3 3 0
.//transaction/sector[@vocabulary = '1' or not(@vocabulary)]/@code Sector 132 325 265 32
.//transaction/sector/@vocabulary SectorVocabulary 138 14 9 1
.//transaction/tied-status/@code TiedStatus 330 3 3 1
.//planned-disbursement/receiver-org/@type OrganisationType 82 16 12 8
.//sector[@vocabulary = '7']/@code UNSDG-Goals 91 17 17 37
.//result/indicator/reference/@vocabulary IndicatorVocabulary 233 10 7 1
.//humanitarian-scope/@type HumanitarianScopeType 46 2 2 1
.//humanitarian-scope/@vocabulary HumanitarianScopeVocabulary 46 3 3 1
.//humanitarian-scope[@vocabulary = '1-2']/@code GLIDENumber 29 7640 354 149
.//conditions/condition/@type ConditionType 47 3 3 0
.//location/administrative/@vocabulary GeographicVocabulary 66 6 6 0
.//location/feature-designation/@code LocationType 75 682 165 26
.//location/location-id/@vocabulary GeographicVocabulary 111 6 6 2
.//result/document-link/@format FileFormat 90 1665 45 0
.//result/document-link/category/@code DocumentCategory 90 30 14 0
.//result/reference/@vocabulary ResultVocabulary 57 1 1 4
.//transaction/sector[@vocabulary = '2']/@code SectorCategory 13 44 21 0
.//sector[@vocabulary = '8']/@code UNSDG-Targets 22 169 165 23
.//sector[@vocabulary = '10']/@code HumanitarianGlobalClusters 21 15 15 33
.//transaction/aid-type[@vocabulary = '2']/@code EarmarkingCategory 10 4 4 0
.//humanitarian-scope[@vocabulary = '2-1']/@code HumanitarianPlan 29 382 293 68
.//result/document-link/language/@code Language 56 184 4 0
.//location/administrative[@vocabulary = 'A4']/@code Country 23 257 219 23
.//crs-add/channel-code/text() CRSChannelCode 4 432 96 3
.//crs-add/other-flags/@code CRSAddOtherFlags 5 4 3 1
.//default-aid-type[@vocabulary = '4']/@code CashandVoucherModalities 4 2 2 0
.//@budget-not-provided BudgetNotProvided 3 3 2 0
.//result/indicator/document-link/@format FileFormat 2 1665 2 0
.//result/indicator/document-link/category/@code DocumentCategory 2 30 2 0
.//result/indicator/document-link/language/@code Language 1 184 1 0
.//transaction/aid-type[@vocabulary = '4']/@code CashandVoucherModalities 9 2 1 0
.//sector[@vocabulary = '9']/@code UNSDG-Indicators 9 247 36 28
.//transaction/aid-type[@vocabulary = '3']/@code EarmarkingModality 5 12 4 1
.//default-aid-type[@vocabulary = '2']/@code EarmarkingCategory 5 4 4 0
.//transaction/sector[@vocabulary = '10']/@code HumanitarianGlobalClusters 1 15 7 0
.//transaction/sector[@vocabulary = '7']/@code UNSDG-Goals 5 17 6 0
.//default-aid-type[@vocabulary = '3']/@code EarmarkingModality 2 12 2 0
.//crs-add/loan-status/@currency Currency 1 305 2 0
.//crs-add/loan-terms/repayment-plan/@code LoanRepaymentPeriod 1 4 1 0
.//crs-add/loan-terms/repayment-type/@code LoanRepaymentType 1 4 1 0
.//result/indicator/reference[@vocabulary = '9']/@code UNSDG-Indicators 2 247 0 37
.//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 81 176 9 1
.//activity-date/@type ActivityDateType 78 4 4 3
.//activity-status/@code ActivityStatus 78 6 5 3
.//participating-org/@role OrganisationRole 74 4 4 5
.//participating-org/@type OrganisationType 65 16 10 2
.//recipient-country/@code Country 76 251 171 171
.//reporting-org/@type OrganisationType 80 16 8 2
.//sector[@vocabulary = 'DAC' or not(@vocabulary)]/@code Sector 53 325 180 86
.//transaction/transaction-type/@code TransactionType 71 10 5 8
.//@xml:lang Language 80 181 9 4
.//budget/@type BudgetType 51 2 2 0
.//collaboration-type/@code CollaborationType 25 7 6 1
.//default-aid-type/@code AidType 43 23 10 1
.//default-finance-type/@code FinanceType 32 68 8 1
.//default-flow-type/@code FlowType 45 10 5 1
.//recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 24 26 17 2
.//sector/@vocabulary Vocabulary 53 10 5 2
.//budget/value/@currency Currency 44 176 6 105
.//transaction/value/@currency Currency 46 176 9 2
.//default-tied-status/@code TiedStatus 31 3 3 0
.//description/@type DescriptionType 51 4 3 0
.//planned-disbursement/value/@currency Currency 4 176 1 0
.//transaction/aid-type/@code AidType 39 23 14 0
.//transaction/disbursement-channel/@code DisbursementChannel 31 4 4 0
.//transaction/finance-type/@code FinanceType 37 68 2 7
.//transaction/flow-type/@code FlowType 38 10 3 1
.//transaction/tied-status/@code TiedStatus 33 3 3 1
.//document-link/@format FileFormat 21 1650 4 2
.//document-link/category/@code DocumentCategory 25 26 10 0
.//document-link/language/@code Language 7 181 2 0
.//location/location-type/@code LocationType 9 682 5 0
.//conditions/condition/@type ConditionType 3 3 2 0
.//policy-marker/@significance PolicySignificance 5 5 4 0
.//policy-marker/@vocabulary Vocabulary 3 10 2 1
.//result/@type ResultType 2 4 2 0
.//result/description/@type DescriptionType 1 4 1 0
.//result/indicator/@measure IndicatorMeasure 2 5 1 0
.//result/indicator/description/@type DescriptionType 1 4 2 0
.//policy-marker[@vocabulary = '1' or not(@vocabulary)]/@code PolicyMarker 3 12 8 0
.//contact-info/@type ContactType 10 4 2 33
.//activity-scope/@code ActivityScope 4 8 6 0
.//location/administrative/@country Country 5 251 18 0
.//location/gazetteer-entry/@gazetteer-ref GazetteerAgency 2 3 2 0
.//recipient-region/@vocabulary RegionVocabulary 5 3 1 3
.//location/coordinates/@precision GeographicalPrecision 3 9 2 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
.//related-activity/@type RelatedActivityType 2 5 3 1
.//sector[@vocabulary = 'DAC-3']/@code SectorCategory 1 44 1 0