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 1596 306 71 3
.//activity-date/@type ActivityDateType 1619 4 4 3
.//activity-status/@code ActivityStatus 1620 6 6 1
.//activity-scope/@code ActivityScope 430 8 8 2
.//collaboration-type/@code CollaborationType 573 7 7 0
.//contact-info/@type ContactType 923 4 4 3
.//default-aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 971 25 25 3
.//default-finance-type/@code FinanceType 959 68 31 0
.//default-flow-type/@code FlowType 979 11 9 1
.//default-tied-status/@code TiedStatus 905 3 3 3
.//description/@type DescriptionType 1570 4 4 0
.//participating-org/@role OrganisationRole 1616 4 4 2
.//participating-org/@type OrganisationType 1579 16 16 5
.//recipient-country/@code Country 1542 257 239 25
.//reporting-org/@type OrganisationType 1621 16 15 0
.//sector[@vocabulary = '1' or not(@vocabulary)]/@code Sector 1445 326 322 100
.//sector/@vocabulary SectorVocabulary 1587 14 14 3
.//transaction/disbursement-channel/@code DisbursementChannel 613 4 4 0
.//transaction/recipient-country/@code Country 152 257 213 11
.//transaction/receiver-org/@type OrganisationType 1029 16 16 28
.//transaction/sector[@vocabulary = '1' or not(@vocabulary)]/@code Sector 162 326 289 31
.//transaction/sector/@vocabulary SectorVocabulary 170 14 9 1
.//transaction/transaction-type/@code TransactionType 1504 13 13 10
.//@xml:lang Language 1615 184 95 8
.//recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 728 26 26 10
.//transaction/recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 108 26 26 7
.//document-link/@format FileFormat 797 1665 144 6
.//document-link/category/@code DocumentCategory 801 30 30 0
.//related-activity/@type RelatedActivityType 458 5 5 0
.//result/@type ResultType 704 4 4 1
.//result/indicator/@measure IndicatorMeasure 702 5 5 2
.//sector[@vocabulary = '2']/@code SectorCategory 149 44 44 10
.//tag[@vocabulary = '3']/@code UNSDG-Targets 16 169 169 18
.//tag/@vocabulary TagVocabulary 94 5 5 0
.//transaction/sector[@vocabulary = '2']/@code SectorCategory 19 44 41 0
.//@budget-not-provided BudgetNotProvided 29 3 3 0
.//crs-add/other-flags/@code CRSAddOtherFlags 3 4 3 0
.//humanitarian-scope/@type HumanitarianScopeType 64 2 2 1
.//humanitarian-scope/@vocabulary HumanitarianScopeVocabulary 64 3 3 1
.//policy-marker[@vocabulary = '1' or not(@vocabulary)]/@code PolicyMarker 714 12 12 5
.//policy-marker/@significance PolicySignificance 706 5 5 5
.//policy-marker/@vocabulary PolicyMarkerVocabulary 692 2 2 2
.//sector[@vocabulary = '10']/@code HumanitarianGlobalClusters 23 15 15 42
.//transaction/sector[@vocabulary = '10']/@code HumanitarianGlobalClusters 2 15 14 1
.//humanitarian-scope[@vocabulary = '2-1']/@code HumanitarianPlan 33 474 374 132
.//budget/@status BudgetStatus 1352 2 2 1
.//budget/@type BudgetType 1397 2 2 0
.//budget/value/@currency Currency 1359 306 58 1
.//default-aid-type/@vocabulary AidTypeVocabulary 757 4 4 1
.//transaction/value/@currency Currency 1355 306 99 3
.//document-link/language/@code Language 725 184 23 1
.//participating-org/@crs-channel-code CRSChannelCode 419 437 298 2
.//transaction/aid-type[@vocabulary = '1' or not(@vocabulary)]/@code AidType 422 25 21 5
.//transaction/aid-type/@vocabulary AidTypeVocabulary 313 4 4 0
.//transaction/flow-type/@code FlowType 441 11 10 0
.//transaction/provider-org/@type OrganisationType 1135 16 15 36
.//result/indicator/reference/@vocabulary IndicatorVocabulary 276 10 10 1
.//country-budget-items/@vocabulary BudgetIdentifierVocabulary 45 5 4 0
.//location/feature-designation/@code LocationType 82 682 102 24
.//location/location-class/@code GeographicLocationClass 155 4 4 3
.//location/location-id/@vocabulary GeographicVocabulary 130 6 6 2
.//location/location-reach/@code GeographicLocationReach 250 2 2 0
.//location/exactness/@code GeographicExactness 219 2 2 0
.//other-identifier/@type OtherIdentifierType 290 6 6 0
.//crs-add/channel-code/text() CRSChannelCode 3 437 110 3
.//recipient-region/@vocabulary RegionVocabulary 630 3 3 1
.//conditions/condition/@type ConditionType 62 3 3 0
.//transaction/finance-type/@code FinanceType 476 68 28 0
.//transaction/tied-status/@code TiedStatus 373 3 3 1
.//planned-disbursement/value/@currency Currency 138 306 17 0
.//tag[@vocabulary = '2']/@code UNSDG-Goals 54 17 17 0
.//transaction/aid-type[@vocabulary = '4']/@code CashandVoucherModalities 10 2 2 0
.//sector[@vocabulary = '7']/@code UNSDG-Goals 129 17 17 32
.//result/document-link/@format FileFormat 146 1665 57 0
.//result/document-link/category/@code DocumentCategory 147 30 14 0
.//result/document-link/language/@code Language 88 184 6 0
.//transaction/recipient-region/@vocabulary RegionVocabulary 49 3 3 0
.//transaction/aid-type[@vocabulary = '2']/@code EarmarkingCategory 15 4 4 0
.//transaction/aid-type[@vocabulary = '3']/@code EarmarkingModality 6 12 6 1
.//location/administrative/@vocabulary GeographicVocabulary 74 6 6 0
.//location/administrative[@vocabulary = 'A4']/@code Country 24 257 224 23
.//planned-disbursement/@type BudgetType 137 2 2 0
.//result/reference/@vocabulary ResultVocabulary 78 1 1 0
.//planned-disbursement/provider-org/@type OrganisationType 117 16 13 7
.//planned-disbursement/receiver-org/@type OrganisationType 101 16 16 7
.//humanitarian-scope[@vocabulary = '1-2']/@code GLIDENumber 34 8331 426 120
.//sector[@vocabulary = '8']/@code UNSDG-Targets 31 169 169 50
.//crs-add/loan-status/@currency Currency 2 306 3 0
.//crs-add/loan-terms/repayment-plan/@code LoanRepaymentPeriod 2 4 2 1
.//crs-add/loan-terms/repayment-type/@code LoanRepaymentType 2 4 2 1
.//default-aid-type[@vocabulary = '2']/@code EarmarkingCategory 9 4 4 0
.//fss/forecast/@currency Currency 1 306 1 0
.//result/indicator/baseline/document-link/@format FileFormat 10 1665 7 0
.//result/indicator/baseline/document-link/category/@code DocumentCategory 12 30 6 0
.//result/indicator/baseline/document-link/language/@code Language 3 184 1 0
.//result/indicator/document-link/@format FileFormat 26 1665 16 0
.//result/indicator/document-link/category/@code DocumentCategory 30 30 7 0
.//result/indicator/document-link/language/@code Language 6 184 4 0
.//result/indicator/period/actual/document-link/@format FileFormat 13 1665 9 0
.//result/indicator/period/actual/document-link/category/@code DocumentCategory 14 30 6 0
.//result/indicator/period/actual/document-link/language/@code Language 3 184 1 0
.//result/indicator/period/target/document-link/@format FileFormat 13 1665 11 0
.//result/indicator/period/target/document-link/category/@code DocumentCategory 14 30 6 0
.//result/indicator/period/target/document-link/language/@code Language 3 184 1 0
.//result/indicator/reference[@vocabulary = '9']/@code UNSDG-Indicators 5 247 1 47
.//sector[@vocabulary = '9']/@code UNSDG-Indicators 11 247 49 11
.//default-aid-type[@vocabulary = '4']/@code CashandVoucherModalities 5 2 2 1
.//default-aid-type[@vocabulary = '3']/@code EarmarkingModality 4 12 3 0
.//transaction/sector[@vocabulary = '7']/@code UNSDG-Goals 5 17 6 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 74 176 9 0
.//activity-date/@type ActivityDateType 71 4 4 3
.//activity-status/@code ActivityStatus 71 6 4 2
.//budget/@type BudgetType 48 2 2 0
.//description/@type DescriptionType 49 4 3 0
.//document-link/@format FileFormat 21 1650 5 2
.//document-link/category/@code DocumentCategory 24 26 11 0
.//participating-org/@role OrganisationRole 67 4 4 6
.//participating-org/@type OrganisationType 59 16 11 1
.//recipient-country/@code Country 70 251 166 127
.//reporting-org/@type OrganisationType 73 16 7 2
.//sector[@vocabulary = 'DAC' or not(@vocabulary)]/@code Sector 46 325 171 74
.//sector/@vocabulary Vocabulary 49 10 5 3
.//transaction/transaction-type/@code TransactionType 65 10 5 7
.//@xml:lang Language 73 181 9 3
.//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
.//transaction/value/@currency Currency 42 176 10 2
.//default-aid-type/@code AidType 39 24 10 1
.//default-flow-type/@code FlowType 42 10 5 1
.//document-link/language/@code Language 7 181 1 0
.//budget/value/@currency Currency 42 176 6 105
.//conditions/condition/@type ConditionType 3 3 2 0
.//default-finance-type/@code FinanceType 28 68 8 1
.//default-tied-status/@code TiedStatus 28 3 3 0
.//location/location-type/@code LocationType 9 682 5 0
.//planned-disbursement/value/@currency Currency 4 176 1 0
.//policy-marker/@significance PolicySignificance 7 5 4 0
.//policy-marker/@vocabulary Vocabulary 4 10 2 1
.//recipient-region[@vocabulary = '1' or not(@vocabulary)]/@code Region 21 26 16 2
.//result/@type ResultType 3 4 2 0
.//result/description/@type DescriptionType 1 4 1 0
.//result/indicator/@measure IndicatorMeasure 3 5 4 0
.//result/indicator/description/@type DescriptionType 1 4 2 0
.//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
.//collaboration-type/@code CollaborationType 22 7 5 1
.//policy-marker[@vocabulary = '1' or not(@vocabulary)]/@code PolicyMarker 5 12 9 0
.//location/administrative/@country Country 5 251 18 0
.//location/coordinates/@precision GeographicalPrecision 3 9 2 0
.//activity-scope/@code ActivityScope 4 8 6 0
.//contact-info/@type ContactType 7 4 2 30
.//sector[@vocabulary = 'DAC-3']/@code SectorCategory 1 44 1 0
.//recipient-region/@vocabulary RegionVocabulary 5 3 1 0
.//location/gazetteer-entry/@gazetteer-ref GazetteerAgency 2 3 2 0
.//related-activity/@type RelatedActivityType 1 5 1 0
.//location/location-reach/@code GeographicLocationReach 1 2 1 0