Country STAT Platform Overview of the Coding System

Country. STAT Platform Overview of the Coding System in the new Country. STAT platform TRAINING OF FOCAL POINTS on the Country. STAT SYSTEM based on FENIX

Overview Work flow Coding System: Central Product Classification Coding System: Harmonized Commodity Description and Coding System: Global Administrative Unit Layers Coding System: Country. STAT indicators Coding System: Fishery products Coding System: Scientific Fishery products Coding System: Forestry trees Coding System: DAC Coding System: Attributes Coding System: Unit of measurement Coding System: Flags How to use the codification files

Work flow • Have the data ready • • • CVS format No columns with labels Your table is published • Upload the values 17/10/2021 3 • • Title Subject Data type Domain • Create the DSD structure Create your table following the rules • • • • CPC 2. 1 HS GAUL Country. STAT indicators Unit of Measurement DAC Attributes Flag Forestry production Fishery production Scientific Fishery production Codifications: Forestry trees • Fill all metadata Use the right Coding System • Have the metadata ready • Go to the metadata editor

Coding Systems CPC 2. 1 For goods and services GAUL For geo data HS For trade data Country. STAT indicators For all indicators UM Unit of measurement Attributes Characteristics of the indicators Flags To indicate missing and estimated values Forestry products DAC For sectors Scientific Fishery products Forestry trees

Coding System: CPC • The Central Product Classification (CPC) constitutes a complete product classification covering all goods and services based on a set of internationally agreed concepts, definitions, principles and classification rules • It provides a comprehensive framework within which data on products can be collected and presented in a format that allows for economic analysis supporting decision-taking and policy-making 17/10/2021 5

Coding System: CPC The current version, CPC version 2. 1, is the result of a scheduled review of the CPC structure and detail, in order to ensure the classification’s relevance for describing current products in the economy. For Country. STAT should be utilized an expanded version (provided in the Excel file in the “Country. STAT documentation” section) All detailed structure and explanatory notes can be found at the following link (CPC 2. 1 not expanded version): http: //unstats. un. org/unsd/cr/registry/regcst. asp? Cl=31 Here all the available correspondences: http: //unstats. un. org/unsd/cr/registry/regot. asp? Lg=1

CPC 2. 1 : Broad structure

CPC is available only in English at the moment

Coding Systems: HS The Harmonized Commodity Description and Coding System generally referred to as "Harmonized System" or simply "HS" is a multipurpose international product nomenclature developed by the World Customs Organization (WCO). The Harmonized Commodity Description and Coding System (HS) is an exhaustive nomenclature of internationally traded commodities (goods) classified according to the following criteria: – – 17/10/2021 raw or basic material degree of processing use or function economic activities 12 In Country. STAT we use the 6 digits (or less) of the HS codification. Versions: 1992 up to 2012

Coding Systems: GAUL The Global Administrative Unit Layers (GAUL) is an initiative implemented by FAO within the Bill & Melinda Gates Foundation, Agricultural Market Information System (AMIS) and Africa. Fertilizer. org projects. The GAUL compiles and disseminates the best available information on administrative units for all the countries in the world, providing a contribution to the standardization of the spatial dataset representing administrative units. The GAUL always maintains global layers with a unified coding system at country, first (e. g. departments) and second administrative levels (e. g. districts). Where data is available, it provides layers on a country by country basis down to third, fourth and lowers levels

Coding Systems: GAUL The overall methodology consists in a) collecting the best available data from most reliable sources b) establishing validation periods of the geographic features (when possible) c) adding selected data to the global layer based on the last country boundaries map provided by the UN Cartographic Unit (UNCS) d) generating codes using GAUL Coding System e) distribute data to the users

Coding Systems: GAUL Because GAUL works at global level, unsettled territories are reported. The approach of GAUL is to deal with these areas in such a way to preserve national integrity for all disputing countries. GAUL is released once a year and the target beneficiary of GAUL data is the UN community and other authorized international and national partners. Data might not be officially validated by authoritative national sources and cannot be distributed to the general public. A disclaimer should always accompany use of GAUL data. GAUL keeps track of administrative units that has been changed, added or dismissed in the past for political causes. Changes implemented in different years are recorded in GAUL on different layers. For this reason the GAUL product is not a single layer but a group of layers, named "GAUL Set".

Coding Systems: GAUL ADM 0_NAME Afghanistan Afghanistan Afghanistan Afghanistan Afghanistan ADM 1_CODE 279 273 292 282 296 279 286 289 296 290 278 277 279 274 278 ADM 1_NAME Ghazni Badghis Nangarhar Hirat Paktya Ghazni Kapisa Kunduz Paktya Laghman Faryab Farah Ghazni Baghlan Faryab STR 1_YEAR 1000 1000 1000 1000 1000 EXP 1_YEAR 3000 3000 3000 3000 3000 These are just the first few lines to give an idea of the codification. Entire codification is provided through the Excel file “GAUL” in “Country. STAT documentation”

Coding Systems: Country. STAT Indicators Domain code 0101 0102 0103 Production 0104 0105 0106 0201 Food 0202 availability 0203 0301 0302 0303 0304 Trade 0305 0306 0307 0308 0309 indicator Production quantity Production value Yield Area Harvested Area sown Seeds quantity Protein quantity Lipid quantity Food supply quantity Export value Import quantity Import value Consumption quantity Re-export value Re-import quantity Re-import value Machinery 0401 Machines in service 0501 Population Economically active 0502 population Population 0503 Population total density 0504 Population growth Rate 0505 Life expectancy 0601 Consumer price 0602 Producer price 0603 Commercial rate Prices 0604 Official rate 0605 Wholesale price 0606 Annual average price 0701 Constant prices Value added 0702 Current prices These are just the first lines to give you an idea of the codification. The complete coding is in the Excel file online on "Country. STAT Documentations"

Coding Systems: Country. STAT Indicators 0801 0802 0803 0804 0805 0806 0807 Land use 0808 0809 0810 0811 0812 0813 0814 0815 0901 Employment 0902 1001 Water 1002 1003 Administrative Area Agricultural area Arable land and permanent crops area Area equipped for irrigation Fallow Land Forest area Inland water Land Area Other land Other wooded land Permanent crops area Permanent meadows and pastures Temporary crops area Temporary meadows and pastures Unemployment Rate Labour force Participation Rate Average rainfall Max temperature Min temperature Livestock 1101 Slaughtered animals 1102 Live animals 110201 Female Live Animals 110202 Lactating Animals 110203 Male Live Animals 110204 Born Animals 110205 Bought Animals 110206 Animals got as gift 110207 Animals got for caretaking 110208 Sold Animals 110209 Stolen Animals 110210 Animals given for caretaking 110211 Animals given as gift 1103 Laying hens 1104 Dead Animals 1105 Total Input 1106 Total Output

Coding Systems: Country. STAT Indicators 1201 National Account 1202 1203 130101 13010201 13010202 130103 Fishery 130201 13020201 13020202 130203 GPD GDP growth GDP per capita Aquaculture production Inland Aquaculture production Marine Aquaculture production Industrial Marine Aquaculture production Artisanal Marine Aquaculture production Marine/Brackish Aquaculture production Capture production Inland Capture production Marine Capture production Industrial Marine Capture production Artisanal Marine Capture production Marine/Brackish Capture production These are just the first lines to give you an idea of the codification. The complete coding is in the Excel file online on "Country. STAT Documentations"

Coding Systems: Country. STAT Indicators Forestry Education Food Balance Sheet 1401 1402 140301 140302 140303 140304 140305 1404 1405 1501 1502 1601 1602 1603 1604 Reforested area Seedlings planted Burned area Burned meadows Burned natural forests Burned reafforestation Authorized clearing Non-authorized clearing Deforested area Deforestation rate Literacy rate Primary literacy rate Stock variation Waste Other use Procurement These are just the first lines to give you an idea of the codification. The complete coding is in the Excel file online on "Country. STAT Documentations"

Coding Systems: Fishery products code 1 11 12 13 2 21 22 23 24 25 3 31 32 33 34 35 36 37 38 product Freshwater fishes Carps, barbels and other cyprinids Tilapias and other cichlids Miscellaneous freshwater fishes Diadromous fishes Sturgeons, paddlefishes River eels Salmons, trouts, smelts Shads Miscellaneous diadromous fishes Marine fishes Flounders, halibuts, soles Cods, hakes, haddocks Miscellaneous coastal fishes Miscellaneous demersal fishes Herrings, sardines, anchovies Tunas, bonitos, billfishes Miscellaneous pelagic fishes Sharks, rays, chimaeras 39 4 41 42 43 44 45 46 47 5 51 52 53 54 55 56 57 58 6 61 Marine fishes not identified Crustaceans Freshwater crustaceans Crabs, sea-spiders Lobsters, spiny-rock lobsters King crabs, squat-lobsters Shrimps, prawns Krill, planktonic crustaceans Miscellaneous marine crustaceans Molluscs Freshwater molluscs Abalones, winkles, conchs Oysters Mussels Scallops, pectens Clams, cockles, arkshells Squids, cuttlefishes, octopuses Miscellaneous marine molluscs Whales, seals and other aquatic mammals Blue-whales, fin-whales 62 Sperm-whales, pilot-whales 63 64 7 71 72 73 74 Eared seals, hair seals, walruses Miscellaneous aquatic mammals Miscellaneous aquatic animals Frogs and other amphibians Turtles Crocodiles and alligators Sea-squirts and other tunicates Horseshoe crabs and other arachnoids 75 76 77 8 81 82 83 9 91 92 93 94 Sea-urchins and other echinoderms Miscellaneous aquatic invertebrates Miscellaneous aquatic animal products Pearls, mother-of-pearl, shells Corals Sponges Aquatic plants Brown seaweeds Red seaweeds Green seaweeds Miscellaneous aquatic plants

Coding Systems: Scientific Fishery products code 1400100101 1400100201 1400100402 1400100403 1400100404 1400100405 1400100601 1400100602 1400100603 1400100901 1400101101 1400102001 1400102901 1400110601 1400112001 1400112801 1400112901 1400113701 dimensions Cycleptus elongatus Deltistes luxatus Catostomus catostomus Catostomus commersoni Catostomus latipinnis Catostomus macrocheilus Catostomus tahoensis Moxostoma congestum Moxostoma erythrurum Moxostoma macrolepidotum Lagochila lacera Ictiobus cyprinellus Myxocyprinus asiaticus Carpiodes carpio Xyrauchen texanus Chasmistes cujus Minytrema melanops Erimyzon sucetta Hypentelium nigricans 1400200102 1400200201 1400200202 1400200401 1400200501 1400200601 1400200701 1400200801 1400201202 1400201301 1400201302 1400201303 1400201304 1400201305 1400201307 1400201308 1400201309 1400201310 1400201311 Abramis brama Cyprinus carpio Cyprinus pellegrini Aaptosyax grypus Abbottina rivularis Acanthalburnus microlepis Tinca tinca Acapoeta tanganicae Alburnus alburnus Alburnus albidus Barbus barbus Barbus meridionalis Barbus canis Barbus aeneus Barbus capensis Barbus haasi Barbus holotaenia Barbus johnstonii Barbus macrotaenia Barbus neumayeri These are just the first lines to give you an idea of the codification. The complete coding is in the Excel file online on "Country. STAT Documentations"

Coding Systems: Forestry products code 0101 0102 0103 0104 0105 0106 0107 0108 0109 0110 0111 0112 0113 0114 0115 0116 0117 0118 0119 0120 0121 0122 0123 0124 0125 product Recovered Fibre Pulp Uncoated Mechanical Uncoated Woodfree Coated Papers Case Materials Folding Boxboard Wrapping Papers Other Papers Packaging Wood Charcoal Mechanical Wood Pulp Semi-Chemical Wood Pulp Unbleached Sulphite Pulp Bleached Sulphite Pulp Unbleached Sulphate Pulp Bleached Sulphate Pulp Dissolving Wood Pulp Other Fibre Pulp Recovered Paper Newsprint Printing+Writing Paper Other Paper+Paperboard Household+Sanitary Paper Wrapg+Packg Paper+Board Paper+Paperboard NES 0126 0127 0128 0129 0130 0131 0132 0133 0134 0135 0136 0137 0138 0139 0140 0141 0142 0143 0144 0145 0146 0147 0148 0149 0150 0151 0152 Sawlogs+Veneer Logs (C) Pulpwood, Round&Split(NC) Sawlogs+Veneer Logs (NC) Pulpwood+Particles(NC) Pulpwood, Round&Split Trd Chips and Particles Wood Residues Other Indust Roundwd(C) Other Indust Roundwd Trd Other Indust Roundwd(NC) Wood Fuel(NC) Wood Fuel Trd Sawnwood (C) Sawnwood (NC) Veneer Sheets Plywood Particle Board Hardboard MDF Fibreboard, Compressed Insulating Board Ind Rwd Wir (C) Ind Rwd Wir (NC) Tropica Ind Rwd Wir (NC) Other

Coding Systems: Forestry trees Code 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 Latin name Achras sapota Actinidia arguta Actinidia deliciosa Aframomum angustifolium Aleurites moluccana Alpinia caerulea Ananas comosus Annona atemoya Annona cherimoya Annona muricata Annona purpurea Annona scleroderma Annona squamosa Araucaria bidwillii Artocarpus integrifolia Asparagus officinalis English name Sapodilla Hardy Kiwifruit False Cardamom Candle nut Native Ginger Ananas Custard Apple Cherimoya Soursop Soncoya Poshte Sugar Apple/Sweetsop Bunya Nut Jakfruit Asparagus These are just the first lines to give you an idea of the codification. The complete coding is in the Excel file online on "Country. STAT Documentations"

Coding Systems: Attributes – DAC: Sector DAC 5 CODE 110 111 112 113 114 120 121 122 130 140 151 152 160 210 230 240 250 311 DESCRIPTION EDUCATION Education, level unspecified Basic education Secondary education Post-secondary education HEALTH Health, general Basic health POPULATION POLICIES/PROGRAMMES AND REPRODUCTIVE HEALTH WATER SUPPLY AND SANITATION GOVERNMENT AND CIVIL SOCIETY Government and civil society, general These are just the first lines Conflict prevention and resolution, peace and security to give you an idea of the OTHER SOCIAL INFRASTRUCTURE AND SERVICES TRANSPORT AND STORAGE codification. The complete ENERGY GENERATION AND SUPPLY coding is in the Excel file BANKING AND FINANCIAL SERVICES online on "Country. STAT BUSINESS AND OTHER SERVICES Documentations" AGRICULTURE+FORESTRY+FISHERY AGRICULTURE

Coding Systems: Attributes Gender code 5001 5002 5003 5004 Agriculture and livestock dimensions Female Male Unspecified Total code 6001 6002 6003 6004 Population and status code 7001 7002 7003 7004 dimensions Rural Urban Unspecified Total dimensions Agricultural Non agricultural Unspecified Total Food code 9001 9002 9003 9004 dimensions Food Non Food Unspecified Total These are just the first lines to give you an idea of the codification. The complete coding is in the Excel file online on "Country. STAT Documentations"

Coding Systems: Attributes Size Field code 8001 8002 8003 8004 8005 8006 8007 8008 8009 8010 code dimensions 1201 small 1202 medium 1203 big dimensions Rainfed Irrigated Cultivated and irrigated Natural Growth Organic Certified organic In conversion to organic Unspecified Total These are just the first lines to give you an idea of the codification. The complete coding is in the Excel file online on "Country. STAT Documentations"

Coding Systems: Unit of Measurement code 0101 0102 0103 0104 0105 0106 0107 0108 0109 0110 0111 0112 0113 0114 0115 unit head Ha ton US$ local currency index thousands units cubic meter kg/capita/yr Kcal/capita/day g/capita/day 1000 US$ Liter Cubic meter/second 0116 0117 0118 0119 0120 0121 0122 0123 0124 0125 0126 0127 0128 0129 0130 0131 Centimeter Local currency by ton Degree Celsius Percentage MT or Cubic meter Local currency/hectar Local currency/1 cubic meter Kg/Ha Local currency/Kg 1000 Ha mm Square meter Household Ton/Ha Km 2 Years These are just the first lines to give you an idea of the codification. The complete coding is in the Excel file online on "Country. STAT Documentations"

Coding Systems: FLAGS • e = Estimated value • c = Calculated value (through a formula) • m / Empty cell = Missing data Data exist but were not collected • na = Data not existing / not available Data do not even hypothetically exist

How to use the codification files • Go to the section « Country. STAT documentation » Here you can find all useful documents for the website’s management (PPT Presentations, Code Lists, Manuals, etc. )

How to use the codification files Write as keyword: «code» and press «search»

How to use the codification files Download the three files: Country. STAT Code List, GAUL and HS Remember to regularly check the dates of upload to see if exists a more updated version compared to the one that you have on your PC

How to use the codification files Country. STAT Code List: All codes are organized in several sheets More than that

How to use the codification files The GAUL file appears as a single file for the various countries of the world. Filter column B and select only your country Plus que ça

How to use the codification files The HS file contains all HS versions from 1992 to 2012