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 1473 305 56 5
.//activity-date/@type ActivityDateType 1493 4 4 5
.//activity-status/@code ActivityStatus 1493 6 6 4
.//budget/@type BudgetType 1242 2 2 1
.//description/@type DescriptionType 1401 4 4 1
.//participating-org/@role OrganisationRole 1491 4 4 3
.//participating-org/@type OrganisationType 1476 16 16 8
.//recipient-country/@code Country 1410 257 238 71
.//reporting-org/@type OrganisationType 1493 16 16 1
.//sector[@vocabulary = '1' or not(@vocabulary)]/@code Sector 1359 325 322 167
.//sector/@vocabulary SectorVocabulary 1457 14 14 5
.//transaction/aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 383 23 20 16
.//transaction/disbursement-channel/@code DisbursementChannel 563 4 4 0
.//transaction/finance-type/@code FinanceType 432 68 31 2
.//transaction/sector[@vocabulary = '1' or not(@vocabulary)]/@code Sector 151 325 272 34
.//transaction/tied-status/@code TiedStatus 342 3 3 2
.//transaction/transaction-type/@code TransactionType 1388 13 13 6
.//transaction/value/@currency Currency 1234 305 97 5
.//@xml:lang Language 1476 184 73 12
.//budget/@status BudgetStatus 1202 2 2 1
.//budget/value/@currency Currency 1205 305 43 3
.//collaboration-type/@code CollaborationType 520 7 7 0
.//contact-info/@type ContactType 859 4 4 3
.//default-aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 876 23 23 27
.//default-aid-type/@vocabulary AidTypeVocabulary 629 4 4 0
.//default-finance-type/@code FinanceType 859 68 30 4
.//default-flow-type/@code FlowType 881 10 9 3
.//default-tied-status/@code TiedStatus 807 3 3 9
.//document-link/@format FileFormat 748 1665 135 14
.//document-link/category/@code DocumentCategory 751 30 30 2
.//document-link/language/@code Language 686 184 66 1
.//planned-disbursement/value/@currency Currency 114 305 14 0
.//transaction/flow-type/@code FlowType 404 10 10 0
.//transaction/provider-org/@type OrganisationType 1067 16 15 33
.//transaction/receiver-org/@type OrganisationType 946 16 16 26
.//planned-disbursement/@type BudgetType 109 2 2 0
.//recipient-region/@vocabulary RegionVocabulary 547 3 3 1
.//transaction/recipient-country/@code Country 126 257 199 32
.//transaction/recipient-region/@vocabulary RegionVocabulary 40 3 3 0
.//location/location-id/@vocabulary GeographicVocabulary 110 6 6 2
.//location/location-reach/@code GeographicLocationReach 215 2 2 0
.//activity-scope/@code ActivityScope 370 8 8 2
.//participating-org/@crs-channel-code CRSChannelCode 355 435 294 0
.//recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 661 26 26 56
.//transaction/sector/@vocabulary SectorVocabulary 157 14 9 1
.//policy-marker[@vocabulary = '1' or not(@vocabulary)]/@code PolicyMarker 689 12 12 4
.//policy-marker/@significance PolicySignificance 673 5 5 14
.//policy-marker/@vocabulary PolicyMarkerVocabulary 665 2 2 2
.//related-activity/@type RelatedActivityType 431 5 5 1
.//result/@type ResultType 657 4 4 1
.//result/indicator/@measure IndicatorMeasure 657 5 5 2
.//result/indicator/reference/@vocabulary IndicatorVocabulary 257 10 7 2
.//other-identifier/@type OtherIdentifierType 256 6 6 2
.//sector[@vocabulary = '2']/@code SectorCategory 124 44 44 10
.//transaction/aid-type/@vocabulary AidTypeVocabulary 269 4 4 0
.//sector[@vocabulary = '10']/@code HumanitarianGlobalClusters 20 15 15 35
.//transaction/recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 107 26 23 7
.//planned-disbursement/provider-org/@type OrganisationType 95 16 11 8
.//planned-disbursement/receiver-org/@type OrganisationType 85 16 16 7
.//location/administrative/@vocabulary GeographicVocabulary 65 6 6 0
.//location/feature-designation/@code LocationType 74 682 111 20
.//location/location-class/@code GeographicLocationClass 144 4 4 3
.//location/exactness/@code GeographicExactness 169 2 2 0
.//location/administrative[@vocabulary = 'A4']/@code Country 22 257 218 23
.//result/document-link/@format FileFormat 97 1665 46 0
.//result/document-link/category/@code DocumentCategory 99 30 14 0
.//result/document-link/language/@code Language 68 184 6 0
.//conditions/condition/@type ConditionType 52 3 3 0
.//transaction/aid-type[@vocabulary = '2']/@code EarmarkingCategory 12 4 4 0
.//sector[@vocabulary = '7']/@code UNSDG-Goals 99 17 17 35
.//transaction/sector[@vocabulary = '2']/@code SectorCategory 15 44 17 0
.//humanitarian-scope/@type HumanitarianScopeType 52 2 2 1
.//humanitarian-scope/@vocabulary HumanitarianScopeVocabulary 52 3 3 1
.//humanitarian-scope[@vocabulary = '1-2']/@code GLIDENumber 33 7808 401 104
.//humanitarian-scope[@vocabulary = '2-1']/@code HumanitarianPlan 31 431 316 68
.//tag[@vocabulary = '2']/@code UNSDG-Goals 35 17 17 1
.//tag/@vocabulary TagVocabulary 57 4 3 1
.//sector[@vocabulary = '8']/@code UNSDG-Targets 22 169 166 21
.//result/reference/@vocabulary ResultVocabulary 55 1 1 4
.//transaction/sector[@vocabulary = '7']/@code UNSDG-Goals 5 17 6 0
.//transaction/aid-type[@vocabulary = '3']/@code EarmarkingModality 7 12 5 1
.//country-budget-items/@vocabulary BudgetIdentifierVocabulary 34 5 4 0
.//crs-add/other-flags/@code CRSAddOtherFlags 5 4 3 1
.//transaction/aid-type[@vocabulary = '4']/@code CashandVoucherModalities 11 2 2 0
.//tag[@vocabulary = '3']/@code UNSDG-Targets 14 169 169 19
.//default-aid-type[@vocabulary = '2']/@code EarmarkingCategory 5 4 4 0
.//default-aid-type[@vocabulary = '4']/@code CashandVoucherModalities 4 2 2 0
.//default-aid-type[@vocabulary = '3']/@code EarmarkingModality 2 12 2 0
.//sector[@vocabulary = '9']/@code UNSDG-Indicators 9 247 36 28
.//result/indicator/reference[@vocabulary = '9']/@code UNSDG-Indicators 2 247 0 37
.//transaction/sector[@vocabulary = '10']/@code HumanitarianGlobalClusters 1 15 7 0
.//@budget-not-provided BudgetNotProvided 4 3 3 0
.//result/indicator/document-link/@format FileFormat 6 1665 7 0
.//result/indicator/document-link/category/@code DocumentCategory 8 30 3 0
.//result/indicator/document-link/language/@code Language 7 184 1 0
.//transaction/sector[@vocabulary = '8']/@code UNSDG-Targets 1 169 1 0
.//result/indicator/baseline/document-link/category/@code DocumentCategory 4 30 2 0
.//result/indicator/baseline/document-link/language/@code Language 4 184 1 0
.//result/indicator/period/actual/document-link/language/@code Language 2 184 1 0
.//result/indicator/period/target/document-link/language/@code Language 3 184 1 0
.//result/indicator/baseline/document-link/@format FileFormat 2 1665 2 0
.//crs-add/loan-status/@currency Currency 1 305 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
.//result/indicator/period/actual/document-link/@format FileFormat 1 1665 1 0
.//result/indicator/period/actual/document-link/category/@code DocumentCategory 1 30 1 0
.//result/indicator/period/target/document-link/@format FileFormat 1 1665 1 0
.//result/indicator/period/target/document-link/category/@code DocumentCategory 2 30 2 0
.//crs-add/channel-code/text() CRSChannelCode 2 435 102 3

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 79 176 9 1
.//activity-date/@type ActivityDateType 76 4 4 3
.//activity-status/@code ActivityStatus 76 6 5 3
.//budget/@type BudgetType 49 2 2 0
.//budget/value/@currency Currency 43 176 6 105
.//contact-info/@type ContactType 9 4 2 32
.//description/@type DescriptionType 49 4 3 0
.//document-link/@format FileFormat 21 1650 4 2
.//document-link/category/@code DocumentCategory 24 26 10 0
.//location/administrative/@country Country 5 251 18 0
.//location/location-type/@code LocationType 9 682 5 0
.//participating-org/@role OrganisationRole 72 4 4 5
.//participating-org/@type OrganisationType 64 16 10 2
.//recipient-country/@code Country 75 251 171 151
.//reporting-org/@type OrganisationType 78 16 8 2
.//result/@type ResultType 2 4 2 0
.//result/indicator/@measure IndicatorMeasure 2 5 1 0
.//sector[@vocabulary = 'DAC' or not(@vocabulary)]/@code Sector 52 325 174 86
.//sector[@vocabulary = 'DAC-3']/@code SectorCategory 1 44 1 0
.//sector/@vocabulary Vocabulary 51 10 5 2
.//@xml:lang Language 78 181 9 4
.//transaction/aid-type/@code AidType 38 24 14 0
.//transaction/finance-type/@code FinanceType 36 68 2 7
.//transaction/flow-type/@code FlowType 37 10 3 1
.//transaction/tied-status/@code TiedStatus 32 3 3 1
.//transaction/transaction-type/@code TransactionType 70 10 5 8
.//transaction/value/@currency Currency 46 176 9 2
.//transaction/disbursement-channel/@code DisbursementChannel 30 4 4 0
.//collaboration-type/@code CollaborationType 24 7 6 1
.//conditions/condition/@type ConditionType 3 3 2 0
.//default-aid-type/@code AidType 41 24 10 1
.//default-finance-type/@code FinanceType 30 68 8 1
.//default-flow-type/@code FlowType 44 10 5 1
.//default-tied-status/@code TiedStatus 30 3 3 0
.//planned-disbursement/value/@currency Currency 4 176 1 0
.//policy-marker/@significance PolicySignificance 5 5 4 0
.//policy-marker/@vocabulary Vocabulary 3 10 2 1
.//recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 23 26 17 2
.//activity-scope/@code ActivityScope 4 8 6 0
.//location/coordinates/@precision GeographicalPrecision 3 9 2 0
.//policy-marker[@vocabulary = '1' or not(@vocabulary)]/@code PolicyMarker 3 12 8 0
.//recipient-region/@vocabulary RegionVocabulary 5 3 1 3
.//document-link/language/@code Language 7 181 2 0
.//location/gazetteer-entry/@gazetteer-ref GazetteerAgency 2 3 2 0
.//related-activity/@type RelatedActivityType 2 5 3 1
.//result/description/@type DescriptionType 1 4 1 0
.//result/indicator/description/@type DescriptionType 1 4 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