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 1375 305 65 5
.//activity-date/@type ActivityDateType 1388 4 4 4
.//activity-status/@code ActivityStatus 1388 6 6 2
.//budget/@status BudgetStatus 1122 2 2 1
.//budget/@type BudgetType 1158 2 2 1
.//budget/value/@currency Currency 1124 305 49 4
.//description/@type DescriptionType 1323 4 4 0
.//participating-org/@role OrganisationRole 1388 4 4 3
.//participating-org/@type OrganisationType 1373 16 16 8
.//recipient-country/@code Country 1321 257 238 70
.//reporting-org/@type OrganisationType 1388 16 16 0
.//sector[@vocabulary = '7']/@code UNSDG-Goals 90 17 17 44
.//sector/@vocabulary SectorVocabulary 1348 14 13 4
.//@xml:lang Language 1371 184 69 10
.//document-link/@format FileFormat 707 1665 127 12
.//document-link/category/@code DocumentCategory 707 30 30 2
.//document-link/language/@code Language 638 184 18 9
.//sector[@vocabulary = '1' or not(@vocabulary)]/@code Sector 1249 325 322 168
.//participating-org/@crs-channel-code CRSChannelCode 305 432 269 0
.//contact-info/@type ContactType 777 4 4 3
.//default-aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 773 23 23 82
.//default-aid-type/@vocabulary AidTypeVocabulary 542 4 4 0
.//default-finance-type/@code FinanceType 755 68 32 3
.//default-flow-type/@code FlowType 772 10 9 2
.//default-tied-status/@code TiedStatus 724 3 3 7
.//policy-marker[@vocabulary = '1' or not(@vocabulary)]/@code PolicyMarker 625 12 12 4
.//policy-marker/@significance PolicySignificance 607 5 5 55
.//policy-marker/@vocabulary PolicyMarkerVocabulary 596 2 2 2
.//result/@type ResultType 601 4 4 1
.//result/indicator/@measure IndicatorMeasure 601 5 5 2
.//transaction/disbursement-channel/@code DisbursementChannel 505 4 4 0
.//transaction/provider-org/@type OrganisationType 973 16 15 34
.//transaction/receiver-org/@type OrganisationType 860 16 16 26
.//transaction/transaction-type/@code TransactionType 1289 13 13 6
.//transaction/value/@currency Currency 1149 305 84 4
.//recipient-region/@vocabulary RegionVocabulary 501 3 3 1
.//recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 595 26 26 76
.//transaction/aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 354 23 23 15
.//transaction/aid-type/@vocabulary AidTypeVocabulary 233 4 4 0
.//transaction/finance-type/@code FinanceType 401 68 31 3
.//transaction/flow-type/@code FlowType 377 10 9 0
.//transaction/recipient-country/@code Country 109 257 194 33
.//transaction/recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 76 26 21 3
.//transaction/sector/@vocabulary SectorVocabulary 134 14 9 1
.//transaction/tied-status/@code TiedStatus 321 3 3 1
.//result/document-link/@format FileFormat 85 1665 44 0
.//result/document-link/category/@code DocumentCategory 85 30 14 0
.//conditions/condition/@type ConditionType 47 3 3 0
.//result/indicator/reference/@vocabulary IndicatorVocabulary 217 10 7 1
.//transaction/sector[@vocabulary = '1' or not(@vocabulary)]/@code Sector 128 325 265 36
.//activity-scope/@code ActivityScope 328 8 8 2
.//collaboration-type/@code CollaborationType 459 7 7 1
.//humanitarian-scope/@type HumanitarianScopeType 45 2 2 0
.//humanitarian-scope/@vocabulary HumanitarianScopeVocabulary 45 3 3 0
.//location/location-class/@code GeographicLocationClass 142 4 4 3
.//location/location-id/@vocabulary GeographicVocabulary 110 6 6 2
.//location/location-reach/@code GeographicLocationReach 206 2 2 1
.//location/exactness/@code GeographicExactness 167 2 2 0
.//related-activity/@type RelatedActivityType 412 5 5 1
.//location/administrative/@vocabulary GeographicVocabulary 64 6 6 0
.//location/feature-designation/@code LocationType 73 682 162 26
.//location/administrative[@vocabulary = 'A4']/@code Country 22 257 218 22
.//other-identifier/@type OtherIdentifierType 247 6 6 2
.//result/document-link/language/@code Language 50 184 4 0
.//sector[@vocabulary = '10']/@code HumanitarianGlobalClusters 20 15 15 31
.//result/reference/@vocabulary ResultVocabulary 73 1 1 5
.//sector[@vocabulary = '2']/@code SectorCategory 126 44 44 11
.//transaction/recipient-region/@vocabulary RegionVocabulary 31 3 3 0
.//planned-disbursement/value/@currency Currency 103 305 14 0
.//tag[@vocabulary = '2']/@code UNSDG-Goals 29 17 17 0
.//tag[@vocabulary = '3']/@code UNSDG-Targets 10 169 169 17
.//tag/@vocabulary TagVocabulary 46 4 3 0
.//planned-disbursement/provider-org/@type OrganisationType 86 16 11 9
.//planned-disbursement/receiver-org/@type OrganisationType 78 16 12 8
.//planned-disbursement/@type BudgetType 98 2 2 0
.//country-budget-items/@vocabulary BudgetIdentifierVocabulary 30 5 4 0
.//transaction/aid-type[@vocabulary = '3']/@code EarmarkingModality 4 12 3 1
.//humanitarian-scope[@vocabulary = '1-2']/@code GLIDENumber 29 7558 348 145
.//transaction/aid-type[@vocabulary = '4']/@code CashandVoucherModalities 9 2 2 0
.//transaction/sector[@vocabulary = '10']/@code HumanitarianGlobalClusters 1 15 7 0
.//transaction/aid-type[@vocabulary = '2']/@code EarmarkingCategory 10 4 4 0
.//humanitarian-scope[@vocabulary = '2-1']/@code HumanitarianPlan 28 381 285 67
.//sector[@vocabulary = '8']/@code UNSDG-Targets 22 169 165 23
.//country-budget-items/budget-item[../@vocabulary = '1']/@code BudgetIdentifier 18 152 119 1
.//sector[@vocabulary = '9']/@code UNSDG-Indicators 9 247 36 28
.//transaction/sector[@vocabulary = '2']/@code SectorCategory 13 44 22 0
.//crs-add/other-flags/@code CRSAddOtherFlags 5 4 3 1
.//transaction/sector[@vocabulary = '7']/@code UNSDG-Goals 5 17 6 0
.//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
.//crs-add/channel-code/text() CRSChannelCode 4 432 94 3
.//result/indicator/reference[@vocabulary = '9']/@code UNSDG-Indicators 2 247 0 37
.//default-aid-type[@vocabulary = '2']/@code EarmarkingCategory 5 4 4 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/document-link/language/@code Language 1 184 1 0
.//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
.//budget/@type BudgetType 51 2 2 0
.//budget/value/@currency Currency 44 176 6 105
.//default-aid-type/@code AidType 43 23 10 1
.//default-flow-type/@code FlowType 45 10 5 1
.//description/@type DescriptionType 51 4 3 0
.//participating-org/@role OrganisationRole 74 4 4 5
.//participating-org/@type OrganisationType 65 16 10 2
.//reporting-org/@type OrganisationType 80 16 8 2
.//sector[@vocabulary = 'DAC' or not(@vocabulary)]/@code Sector 53 325 180 86
.//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
.//transaction/transaction-type/@code TransactionType 71 10 5 8
.//transaction/value/@currency Currency 46 176 9 2
.//@xml:lang Language 80 181 9 4
.//contact-info/@type ContactType 10 4 2 33
.//recipient-country/@code Country 76 251 171 171
.//collaboration-type/@code CollaborationType 25 7 6 1
.//default-finance-type/@code FinanceType 32 68 8 1
.//default-tied-status/@code TiedStatus 31 3 3 0
.//policy-marker[@vocabulary = '1' or not(@vocabulary)]/@code PolicyMarker 3 12 8 0
.//policy-marker/@significance PolicySignificance 5 5 4 0
.//recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 24 26 17 2
.//sector/@vocabulary Vocabulary 53 10 5 2
.//document-link/category/@code DocumentCategory 25 26 10 0
.//related-activity/@type RelatedActivityType 2 5 3 1
.//document-link/@format FileFormat 21 1650 4 2
.//document-link/language/@code Language 7 181 2 0
.//location/administrative/@country Country 5 251 18 0
.//location/location-type/@code LocationType 9 682 5 0
.//result/@type ResultType 2 4 2 0
.//result/indicator/@measure IndicatorMeasure 2 5 1 0
.//sector[@vocabulary = 'DAC-3']/@code SectorCategory 1 44 1 0
.//policy-marker/@vocabulary Vocabulary 3 10 2 1
.//recipient-region/@vocabulary RegionVocabulary 5 3 1 3
.//activity-scope/@code ActivityScope 4 8 6 0
.//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
.//location/gazetteer-entry/@gazetteer-ref GazetteerAgency 2 3 2 0
.//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