(LTS TRAINS) User's Manual
Contents
1. All countries may be selected by simply clicking Countries that are not required may be removed from the list in the right box by selecting the countries in the right box and clicking 44 Remove Al Ae or simply click Once all countries have been selected click Save to start the selection process from the beginning Edit Group 25 D2 Building and Managing Product Groups From the Tool menu select Manage Product Groups and click 45 The following panel opens to build a product group La Product Group Editor P New Group 4 Edit Group RAMA Product Group Information Group Code Description pee Selection Tier 1 Products 0 Food and live animals 1 Beverages and tobacco amp Crude materials medible except fuels J Mineral fuels lubricants and related materials 4 Animal and vegetable oils and fats B Chemical E Manufact goods classified chiefly by material T Machinery and transport equipment d Miscellaneous manufactured articles 9 Commod transacts not class accord to kind Provide a short name and brief description of the group in Group Code and Group Name respectively e g BPC Beef pork and chicken Product Groups can be built using the SITC codes at the same level of aggregation Select the Tier 1 2 3 4 and 5 corresponding to 1 2 3 4 and 5 digit level respectively Select all codes to be included in the Group e g 4 digit with 012. 2003 2004 2005 2006 2007 2008 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2001 2006 2007 1988 1989 1995 1996 1997 1998 1999 2000 2001 2002 2004 2005 2006 2007 2008 2007 2008 1970 1974 1984 1986 1988 1989 1990 1991 1995 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 1996 2000 2001 2006 2007 2008 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2007 2008 1985 1996 1999 1985 1986 1987 1988 1992 1993 1997 2000 2001 2002 2003 2005 2006 2007 2008 2009 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1994 1997 2001 2002 2003 2005 2006 2007 2008 2009 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2001 2002 2004 2005 2006 2007 2008 2009 2010 1984 1985 1986 1987 1993 1998 1999 2000 2002 2003 2004 2005 2006 2007 2008 2009 1973 1974 1975 1976 1978 1980 1981 1982 1983 1984 1985 1986 1993 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 1971 1992 1993 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 1985 1986 1987 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2007 2009 1970 2001 2002 2003 2004 2005 2006 2007 2008 2009 1988 1989 1990 1
3. D Tools in LST TRAINS With LST TRAINS uses can construct their own country and product groups Detinition Explorer a Manage Country Groups ee Q ary F Manage Product Groups D1 Building and Managing Country Groups From the Tool menu select Manage Country Groups The following panel opens to build a country group za Country Group Editor B New Group Edit Group Group Information Group Membership Afghanistan de Aland Islands Cm Albania mm Algeria Add All gt gt American Samoa aa Andorra Add gt Angola Anguila Antarctica Remove Antigua and Barbuda Argentina lt lt Remove AN Armenia Aruba Australia Save Cancel Provide a short name and brief description of the group in Group Code and Group Name respectively e g ASEANS ASEAN original 5 members Select the individual counties from the left box and move them to the right box by clicking Add gt 24 a Country Group Editor lt New Group gt bp New Group Fi Edit Group E Exit SO Information Group Code ASEANS Group Name ASEAN onginal 5 members Group Membership I Suriname Svalbard and Jan Mayen Is Swaziland Sweden Switzerland Syprian Arab Republic Tawan China Tajikistan Tanzania Toga Tokelau Tonga Trinidad and Tobago Tunisia Fi Add All gt gt Add Remove Fe Remove All Ed Malaysia Philippines Singapore Thailand Cancel
4. SOC a U w w UUU UC w V 3 Sle v JVV v l LA Sle w ur Query Reports Tools Help Definition Explorer m o General Products Reporters Partners 4 General Products and Product Grou gt H Mame Testi Years 1980 to 2010 gt Years 1964 to 1973 Product Nomenclature Standard International Trade Classification Revision 1 Expand and Select Required Products 4 GB Individual Products Total Total Trade 0 Food andlive animals 1 Beverages and tobacco 2 Crude materials inedible except fuels 3 Mineral fuels lubricants and related materials 4 Ci 4 Animal and vegetable oils and fats 4 Dl S 41 Animal oils and fats 4 Ci 411 Animal oils and fats Fi 4111 Oils of fish and marine mammals B 4113 Animal oils fats and greases excluding lard 41131 Pig and poultry fat unrendered 41122 Fats unrendered of boving cattle sheeps tallow Select any number of products and any level of aggregation by checking the corresponding B1 4 4 Reviewing product selection When all product selection has been completed Click Fm and all selected products will be shown in the Current Selection Box In the example below All 1 digit products are selected from the Global Selection Food products from the Product Groups and a 4 digit code 4113 have been selected 13 Query Reports Tools Help Definition Explorer A General Delta d Query Definition ne OO pa Name Test Years 1980 to 201
5. 3 Name and Description of the Query and Years In the General tab 1 Enter a Query Name short name in one world and a Query Description in the corresponding text areas 2 Click on Select Years button and then click on the Select Year From tab the following list of all available years appear as follows Chery Med Tanis Hele r ERHAN i t ji ee E L 1 Lie Panja of Tes Frem ANU YA ipp Descending Year Chiar Lang Hima Gores Tamira Ha Prodat Namencintura SVG Nein Do Tear Wasi Fier Tes To ij TECE s jijiji AAA A 8 1558 EV 1987 UNCTAD IT Customer Se Mail FHELP itt cedmunc Phone FHELP 74367 Usar Nama aki Host Name IMC 1a Logon Server VM TRI IP Address 10 15 1 192 168 Host Time BR 3 Select all desired years individually and or select the first year for a range of years 10 4 For a range of years click on Select Year To tab which is activated when one year is selected from the previous list and choose the last year of the range In the exampole below two ranges one from 1964 to 1973 and another from 1980 to 2010 have been selected FormYearSelector Use Range of Years From 1967 To Apply Descending Year Order Tear romo o Year From Year Ta 1964 1973 1980 2010 B1 4 Products For the Product and Product Group selector click on the Products tab Query Reports Tools Help Definition Explore te Name Testi Years 1980 to 2
6. different column Click will be rearranged as follows dna gt H ORS F sake tems fi treat ote ma irasi mwari Pre nie Paihia sd Desi acon Cea ser ronkpugi pom TA AA Additionally if only one indicator is needed open pe fae ai mtd Moji dli aka ko ki E F select e B aah bata ESEEEEEEESG Debi ane Gi ramia aie Pa TE Oe Cad adie a pore cater irab veli na a Fan fl TE HI H i sed pre dra Beene catered ri dd Dag a zn Fed IC Ode aa bri ra Pore are sci ta ti kaaa Wa cola mul ra a ma al no rani zal ian a Paaie Pond ed rar ma Bora rirc Areal ca nil a brati gi Pire a Fed fi TE se i Patras izred taki Ter be VP aiii kairit wiit Li anh are Tei arrid Tem elk poi k i fre oe aa pmo Poe IC deti 1 Fimi graj kva zu tiki rada an hegre m Pegi Sala me jangan Wadah aa kegari Ya in bi para pe P pa tel gets pm aa oe E aa pir jed majo FE ie birati ie kirama i pra barge i grm Bete Ege Fikr lira lim E Mu Line lm Pay Lire dimi Pity Lira ite i Pare ie E Pile Lorem lini ZU HE Foy Lena VO ia MO OD S Select Indicator i rrr Mai AAA RA eT MIN AN ieee eS Pivot zee fee amp E ad and the table zu Yd ee tt Tha menu and select the required indicator e g Weighted Average Tariff the table will be reduced to k AEA aa Ci EKA Eta A
7. growth one very important guestion that a researcher must answer is how to measure openness Researchers have used a variety of measures and these are included in this database The database contains the following four measures 1 Simple Average Tariff This measure is computed by taking the simple arithmetic average of the tariff rates for each country for a given time period This measure gives egual weight to each tariff rate 2 Import Weighted Average Tariff This measure is the weighted sum of each country s tariff rates where the weights are the shares of each good in a country s total imports Compared to 1 this measure assigns higher weights to tariffs on goods for which imports are large However if tariffs are effective in restricting imports then imports would be low giving these goods low weights instead of high weights This is a weakness of using this indicator 3 Tariff Revenue Divided by Imports This measure is computed by dividing total revenue from duties on imports by the value of imports This measure includes the impact of tariff preferences granted by a particular country as it uses the actual value of revenue collected rather than statutory tariff rates 4 Partial Equilibrium Trade Restrictiveness Index This measure is a partial equilibrium version of the trade restrictiveness developed by Anderson and Neary 2005 Since it is often time consuming to construct general equilibrium models Feenstra 1995
8. or its equivalent AVE gt 15 11 rangeCount number of tariff lines whose ad valorem rate or its equivalent AVE falls a ease YS sa between 0 5 5 10 10 20 20 50 50 100 and above 100 12 tradeValue Value of imports from the world 13 netWeight Volume of imports from the world in Metric Tons 14 quantity Volume of imports from the world in secondary unit 15 gtyUnit Unit of the secondary volume B Query in LST TRAINS B1 Query Definition This section describes how to construct a query in LST TRAINS and submit it for execution B1 1 Introduction With the Query module users construct sophisticated queries by including multiple reporters and partner countries products and years in a single query Countries and products can be selected individually or aS groups Groups can be selected from users own customized country and product groups or pre defined aggregates Queries can be saved and reused The results of a Query include average tariff rates standard deviations international and domestic tariff peaks minimum and maximum rates etc B1 2 Opening a new Query To Open a new Query 1 Click on Query to open the menu 2 Click on New Tools Help Expand and Select Ba Current Selections Delete Code The following screen will be displayed ai Data Request Designer Query Reports Tools Help Definition Explorer q Partners Year From Year To Select Years B1
9. 0 1964 to 1973 Reporters Partners Products and Proc Product Nomenclature Standard International Trade Classification Revision 1 Expand and Select Required Products Current Selections Delete Code Name ME ALL Section 1 cigit x Food Food SITC 04 1 22 4 x 4113 Animal ails fats and greases excluding lard Any selection can be deleted by clicking the corresponding at B1 5 Reporters Clicking the Reporters tab opens the following panel Query Reports Tools Help Definition Explorer a YA General Product he Name Testi ta Years 1980 to 2010 Years 1964 to 1972 Do 4 Products lt Show All Country Group Definitions ALLI Section 1 digit Food Food SITC 4142244 Expand and Select Required Countries and Country Groups 4113 Animal oils fats and grease Reporters are countries which report the import tariff schedules and import statistics Select Countries from the Country Groups and or Individual Countries B1 5 1 Country Groups Country Groups are either pre defined in LST TRAINS by UNCTAD definition of economic development Economic Groupings by region Geographical Groupings or by regional trade blocks Trade Groups or defined by users using the Manage Country Groups tool see Section D for details The System will calculate all indicators for the group as a whole by aggregating import values and other additive numbers and averaging tariff rates Pre defined groups c
10. 0 1981 1982 1983 1984 1985 1996 1998 1999 2000 2001 2002 2003 2006 2007 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 1975 1989 1991 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 1982 1986 1987 1988 1989 1995 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 1987 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 1998 2001 2002 2005 2007 2002 2006 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 1995 2001 2002 2006 2008 1986 1987 1988 1973 1974 1975 1976 1978 1980 1981 1982 1983 1984 1985 1986 1993 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2003 2004 2007 2008 1970 1974 1975 1976 1978 1980 1981 1982 1983 1984 1985 1986 1988 1990 1991 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 1973 1974 1975 1976 1978 1980 1981 1982 1983 1984 1985 1986 1993 1996 1997 1998 1999 2000 2001 2002 2003 32 French Polynesia Gabon Gambia The Georgia Germany Ghana Greece Grenada Guatemala Guinea Guinea Bissau Guyana Haiti Honduras Hong Kong China Hungary Iceland India Indonesia Iran Islamic Rep Irag Ireland 2004 2005 2006 2007
11. 010 io 1964 to 1973 Product Nomenclature Standard International Trade Classification Revision 1 Expand and Select Required Products As show above products can be selected using one or more of the three methods Global Selections Product Groups and Individual Products 11 B1 4 1 Global Selections This method is used if all products need to be selected at a given level of aggregation of the product nomenclature i e SITC Rev1 Expanding the Global Selections by clicking shows each level of aggregation from 1 to 5 digit as follows 4 Global Selections Available Global Choices All Products Section 1 digit Division 2 digiti Group 3 digit Sub Group 4 digit Subsidiary Heading 5 digit Leaf level products Select the level of product aggregation required by checking the corresponding and the system will automatically select all products at that level of aggregation All levels can be selected at once by choosing All Products In STIC nomenclature the most detailed level may be at 4 or 5 digit depending on the type of products To select all products at their respective most detailed levels choose Leaf level products B1 4 2 Product Groups Product Groups are groups of heterogeneous product categories that are either pre defined in LST TRAINS or defined by users using the Manage Product Groups tool see Section D for details The System will calculate all indicators for the group as a who
12. 11 0113 and 0114 by highlighting them while pressing Ctrl key on the keyboard 26 gi Product Group Editor P New Group Fi Edit Group Product Group Information S Group Code BPC Description Beet Pork and Chiken _ Product Selection k lt 5 lt 5 lt 5SF Tier 4 Products 0011 Bovine cattleincluding buffaloes 0012 Sheep lambs and goats 0013 Swine 0014 Poultry live 0015 Horses asses mules and hinries 0019 Live animals chiefly for food n e s ZL Meat ot hovine rials MSE child At TOR 0112 Meat of sheep goats fresh chilled or frozen 0115 Meat of horses asses mules _hinnies fr ch fro 0116 Edible offals of animals fresh chilled frozen 0118 Other frezh chilled frozen meat edible offals N1 21 Racan ham atker dned salted smak ed nin meat Cancel Group saved Once all codes have been highlighted click 2 Zi E Annexes E1 Trade Restrictive Indices TRI There has been a great deal of interest in Knowing whether an economy has become more open over time Part of the reason for this is the hypothesis that economies that are more open to international trade grow faster than countries that are less open although the empirical evidence in support of this proposition is rather mixed at best see for example Edwards 1993 and Rodrik and Rodriguez 2001 In exploring the relationship between openness and
13. 1993 1995 1996 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 1987 2000 2003 2004 2007 2008 1962 1963 1964 1965 1966 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1973 1974 1975 1976 1978 1980 1981 1982 1983 1984 1985 1986 1993 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 33 1975 1982 1993 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 1973 1974 1975 1976 1978 1980 1981 1982 1983 1984 1985 1986 1993 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 1979 1980 1981 1982 1983 1984 1985 Jamaica 1996 1999 2000 2001 2002 2003 2004 2006 2007 1974 1978 1980 1981 1982 1983 1984 1985 1986 1988 1989 1990 1991 1992 Japan 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 20082009 1983 1984 1985 1986 1987 2000 2001 Israel Italy Jordan 2002 2003 2004 2005 2006 2007 2008 2009 Kazakhstan 1996 2004 2008 1989 1990 1994 1999 2000 2001 2002 2004 2005 2006 2007 2008 Korea Dem Rep 1985 1986 1987 1970 1973 1982 1986 1987 1988 1989 1990 1992 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 1976 1977 1978 1979 1980 1981 1982 Kuwait 1983 1984 1985 1
14. 1998 2000 2002 2003 2004 2005 2006 2008 1986 1987 1988 1993 1995 1996 1997 Trinidad and Tobago Turkey 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 Turkmenistan 1998 2002 1982 1983 1984 1985 1994 2000 2001 Uganda 2002 2003 2004 2005 2006 2007 2008 1995 1997 2002 2006 2007 2008 2009 2010 United Arab Emirates 1983 1984 1985 2003 2005 2006 2007 Ukraine 2008 1973 1974 1975 1976 1978 1980 1981 1982 1983 1984 1985 1986 1993 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 1989 1990 1991 1992 1993 1995 1996 United States 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 1972 1987 1988 1992 1995 1996 1997 United Kingdom Uruguay 1998 1999 2000 2001 2002 2004 2005 2006 2007 2008 2009 Uzbekistan 2001 2006 2007 2008 Vanuatu 2002 2003 2004 2005 2006 2007 2008 1977 1980 1981 1989 1992 1995 1997 Venezuela 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 1994 1999 2001 2002 2003 2004 2005 visinam 2006 2007 2008 1974 1975 1976 1977 1978 1979 1980 Yemen 1981 1982 1983 1984 1985 1986 2000 2006 Yugoslavia 2001 2002 2005 Yugoslavia FR Serbia Montene 1988 1989 1987 1993 1997 2001 2002 2003 2005 zampa 2007 2008 Zi Babi 1983 1988 1996 1997 1998 1999 2000 2001 2002 2003 2007
15. 2000 2001 2002 2003 2006 2007 2008 2009 1979 1980 1981 1982 1983 1984 1985 St Lucia 1996 1999 2000 2001 2002 2003 2005 2006 2007 1979 1980 1981 1982 1983 1984 1985 St Vincent and the 1996 1999 2000 2001 2002 2003 2006 Grenadines 2007 Sudan 1985 1986 1996 2002 2006 2008 Suriname 1996 1999 2000 2007 Swaziland 1990 2001 2002 2004 2005 2006 2007 2008 2009 2010 1978 1980 1982 1983 1984 1985 1986 Sweden 1988 1989 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 1978 1980 1981 1982 1983 1984 1985 1986 1990 1993 1995 1996 1997 1998 Switzerland 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 2002 1989 1992 1996 1998 1999 2000 2001 Syrian Arab Republic Taiwan China 2002 2003 2004 2005 2006 2007 2008 2009 Tajikistan 2002 2006 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1993 Tanzania 1997 1998 2000 2003 2005 2006 2007 2008 1971 1987 1988 1989 1991 1993 1995 Thailand 1999 2000 2001 2003 2004 2005 2006 2007 2008 2009 1996 1997 1999 2000 2001 2002 2003 Togo 2004 2005 2006 2007 2008 Tonga 2009 1985 1986 1987 1991 1992 1996 1999 2001 2002 2003 2004 2006 2007 2008 1973 1980 1981 1984 1985 1987 1988 Tunisia 1990 1991 1992 1995
16. 2003 2004 2005 2006 2007 2008 2009 2010 Azerbaijan 2002 2005 2007 2008 1975 1976 1977 1978 1979 1980 1981 Bahamas The 1982 1983 1984 1985 1986 1987 1999 2002 2006 1962 1963 1964 1965 1966 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1999 2000 20012002 2003 2004 2005 2006 2007 2008 1984 1985 1986 1989 1994 1998 1999 Bangladesh 2000 2002 2003 2004 2005 2006 2007 2008 1985 1996 1999 2000 2001 2002 2003 2004 2006 2007 Belarus 1996 1997 2000 2001 2002 2008 1973 1974 1975 1976 1978 1980 1981 1982 1983 1984 1985 1986 1993 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 1973 1974 1975 1976 1978 1980 1981 1982 1983 1984 1985 1986 1993 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 1979 1980 1981 1982 1983 1984 1985 1996 1999 2001 2002 2003 2006 2007 Bahrain Barbados Belgium Belgium Luxembourg Belize 30 Benin Bermuda Bhutan Bolivia Bosnia and Herzegovina Botswana Brazil Brunei Bulgaria Burkina Faso Burundi Cambodia Cameroon Canada Cape Verde Central African Republic Chad Chile China Colombia Comoros Congo Dem Rep Congo Rep Costa Rica Cote d Ivoire 2008 2009 1978 1979 1980 1981 1
17. 2008 2009 2010 2008 1984 1995 1998 2000 2001 2002 2005 2007 2008 2009 2003 2007 2008 1999 2001 2002 2003 2004 2005 2006 2007 2008 2009 1973 1974 1975 1976 1978 1980 1981 1982 1983 1984 1985 1986 1993 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 1973 1987 1993 2000 2001 2002 2003 2004 2007 2008 1974 1981 1982 1983 1984 1985 1986 1993 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 1979 1980 1981 1982 1983 1984 1985 1996 1999 2000 2001 2002 2003 2006 2007 2008 1987 1995 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 1985 1986 1998 2004 2005 2008 2009 2001 2002 2003 2004 2005 2006 2007 2008 1979 1980 1981 1982 1983 1984 1985 1996 1999 2000 2001 2002 2003 2006 2007 2008 1987 2007 2008 2009 1995 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 1988 1989 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 1971 1977 1980 1981 1982 1983 1984 1985 1986 1991 1992 1993 1996 1997 1998 1999 2000 2001 2002 2004 2005 2006 2007 2008 2009 2010 1993 1996 1998 1999 2000 2001 2003 2004 2005 2006 2007 2008 1979 1985 1986 1987 1990 1992 1996 1997 1999 2000 2001 2002 2004 2005 2006 2007 2008 1976 1989 1990
18. 4 146 2101 Food WLD 2009 MFN Developed econ Food SITC Q World 8 594709 5 426514 5 450423610647 313 0961378099 17 69452281950 0 230 147 USA 0 WLD 1989 MFN United States Food and live a World 699025536 513869143 3 560245235781 BO 82531329185 7 799058487526 0 35 148 USA 0011 WLD 1989 MFN United States Bovine cattle in World 0 0 0 0 O 0 0 149 USA 41 WLD 1989 MFN United States Animal oils and world 2 7166667 3 6583333 2 094432555821 4 401388862133 2 097948727241 0 5 150 USA 4113 WLD 1989 MFN United States Animal oils fats World 4 6 4 6 3 957342992743 0 320000006357 0 565685430568 3 5 151 USA Food WLD 1989 MFN United States Food SITC O4 World 6 73702049 4 82401 466 3 420785934934 59 39536332783 7 706838737630 0 35 152 USA 0 WLD 1990 MFN United States Food and live a World 7 03281 5 17309952 3 683036025137 60 65387728859 7 788059918143 0 35 153 USA 0011 WLD 1990 MFN United States Bovine cattle in World 0 O 0 0 O 0 0 154 USA 41 WLD 1990 MFN United States Animal oils and World 2 7 166667 3 6583333 2 107285085509 4 401388862133 2 097948727241 0 5 155 USA 4113 WLD 1990 MFN United States Animal oils fats World 4 6 4 6 3 9404090181558 0 320000006357 0 565685430568 3 5 156 USA Food WLD 1990 MFN United States Food SITC O World 6 78040648 485159349 3 527310734116 59 28043692601 7 699378996127 0 35 157 USA 0 WLD 1991 MFN United States Food and liv
19. 4 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2008 1986 1987 2003 2006 2007 2008 1984 1985 1994 1997 2001 2002 2005 2006 2007 1985 1986 1987 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 1978 1986 1987 1993 1996 2001 2002 31 Croatia Cuba Cyprus Czech Republic Czechoslovakia Denmark Djibouti Dominica Dominican Republic Ecuador Egypt Arab Rep El Salvador Eguatorial Guinea Eritrea Estonia Ethiopia excludes Eritrea Ethiopia includes Eritrea European Union Fiji Finland France 2003 2004 2005 2006 2007 2008 2001 2002 2003 2004 2005 2006 2007 2008 2009 1962 1963 1964 1965 1966 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1993 1996 1997 1998 1999 20002001 2002 2003 2004 2005 2006 2007 2008 2009 1978 1979 1980 1981 1982 1983 1984 1985 1986 1996 1997 1998 1999 2000 2001 2002 2004 2005 2006 2007 2008 2009 2010 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 1980 1989 1992 1973 1974 1975 1976 1978 1980 1981 1982 1983 1984 1985 1986 1993 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 1986 1987 1988 1998 1999 2002 2005 2006 2009 1979 198
20. 7 MFN Developed econ Animal oils fats World 1 296 1 2275 0 601726493024 5 245983965698 2 290411309284 0 6 5 136 2101 Food WLD 2007 MFN Developed econ Food SITC 0 4 World 8 647201 5 57858 5 574703698122 305 6234543757 17 48208953116 0 230 137 2101 0 WLD 2008 MFN Developed econ Food and live a World 9 499641 6 711104 6 208406541502 3448226780418 18 56940166084 0 230 138 2101 0011 WLD 2008 MFN Developed econ Bovine cattle in World 0 0 0 0 0 0 0 139 2101 41 WLD 2008 MFN Developed econ Animal oils and World 1 80552149 1 35217392 1 453372705434 8 801871336034 2 966794791695 0 12 140 2101 4113 WLD 2008 MFN Developed econ Animal oils fats World 1 2031579 1 16315794 0 650030132187 4 658411052211 2 158335250189 0 6 4 141 2101 Food WLD 2008 MFN Developed econ Food SITC 0 World 8 528367 5 699092 5 407990062830 303 7486837824 17 42838729723 0 230 142 2101 0 WLD 2009 MFN Developed econ Food and live a World 9 569398 6 370469 6 223917362083 355 4046075960 18 85217779451 0 230 143 2101 0011 WLD 2009 MFN Developed econ Bovine cattle in World 0 0 0 O O 0 0 144 2101 41 WLD 2009 MFN Developed econ Animal oils and world 1 80552149 1 35217392 1 578135421683 8 801871336034 2 966794791695 0 12 145 2101 4113 WLD 2009 MFN Developed econ Animal oils fats World 1 2031579 1 16315794 0 988291139102 4 658411052211 2 158335250189 0 6
21. 93 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 1985 1986 2002 2003 2004 2005 2006 2007 2008 2009 1974 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1991 1999 2001 2004 2005 2007 2008 2009 2010 1993 1994 1996 1997 2001 2002 2005 2007 2008 1987 1988 1993 2000 2001 2002 2003 2005 2006 2008 2009 1989 1994 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 1978 1985 1986 1987 2001 2002 2003 2004 2005 2006 2007 2008 2009 2005 2007 2008 2000 2001 2005 2006 2007 1977 1978 1979 1980 1981 1982 1983 1984 1985 2004 1975 1976 1989 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 1999 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 1995 1998 2006 2007 2008 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1973 1985 1988 1990 1991 1993 1996 1997 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 36 1986 1993 1996 1997 1998 1999 2000 Spain 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 1983 1985 1987 1990 1993 1994 1997 Sri Lanka 1998 2000 2001 2003 2004 2005 2006 2007 2008 2009 1979 1980 1981 1982 1983 1984 1985 St Kitts and Nevis 1996 1999
22. 982 1983 1984 1985 2001 2002 2003 2004 2005 2006 2007 2008 2001 2005 2007 2008 1996 2002 2004 2005 2007 1974 1987 1988 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2001 2006 2007 2008 1990 2001 2002 2004 2005 2006 2007 2008 2009 2010 1973 1979 1986 1987 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 1992 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 1982 1987 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 1978 1979 1980 1981 1982 1983 1984 1985 1993 2001 2002 2003 2004 2005 2006 2007 2008 1987 1988 2002 2003 2005 2006 2007 2008 2001 2002 2003 2005 2006 2007 2008 1984 1985 1986 1994 1995 2001 2002 2005 2007 2009 1989 1993 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2005 2006 2007 2008 2009 1984 1985 1995 1997 2001 2002 2005 2006 2007 1984 1995 1997 2001 2002 2005 2007 2009 1974 1983 1984 1985 1986 1987 1988 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 1986 1987 1988 1989 1990 1992 1993 1994 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 1975 1982 1988 1991 1992 199
23. 986 1987 1988 2002 2003 2004 2005 2006 2007 2008 2009 1995 2000 2001 2002 2003 2006 2007 Kenya Korea Rep Kyrgyz Republic 2008 Lao PDR 2000 2001 2004 2005 2006 2007 2008 nama 1996 1997 1998 1999 2000 2001 2002 2004 2005 2006 2007 2008 2009 2010 1999 2000 2001 2002 2004 2005 2006 Lebanon 2007 1990 2001 2004 2005 2006 2007 2008 Lesotho 2009 2010 Libya 1984 1985 1986 1987 1996 2002 2006 aa 2001 2002 2004 2005 2006 2007 2008 2009 2010 1973 1974 1975 1976 1978 1980 1981 ka 1982 1983 1984 1985 1986 1993 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 1996 1997 1998 1999 2000 2001 2002 Macao 2003 2004 2005 2006 2007 2008 2009 2010 Macedonia FYR 2001 2004 2005 2006 2007 2008 2009 a 1988 1995 1996 1997 1998 2000 2001 2002 2003 2004 2005 2006 2007 2008 eeu 1987 1988 1994 1996 1997 1998 2000 2001 2003 2006 2008 2009 1976 1980 1987 1988 1991 1993 1996 Malaysia 1997 1999 2000 2001 2002 2003 2005 2006 2007 2008 2009 2000 2001 2002 2003 2004 2005 2006 Maldives 5008 Mali Malta Mauritania Mauritius Mayotte Mexico Moldova Mongolia Montenegro Montserrat Morocco Mozambique Myanmar Namibia Nepal Netherlands New Zealand Nicaragua Niger Nigeria Norway Oman Pakistan 1995 1996 1997 1998 1999 2001 2002
24. 992 1995 1996 1997 1998 1999 2000 2001 2002 2003 2005 2006 2008 2009 1969 1972 1978 1980 1981 1982 1983 1984 1986 1988 1993 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 1985 1992 1997 2001 2002 2003 2004 2005 2006 2007 2008 2009 1973 1980 1984 1988 1995 1998 1999 2000 2001 2002 2003 2004 2005 2006 35 Palau Panama Papua New Guinea Paraguay Peru Philippines Poland Portugal Qatar Romania Russian Federation Rwanda Saudi Arabia Senegal Serbia Seychelles Sierra Leone Singapore Slovak Republic Slovenia Solomon Islands Somalia South Africa 2007 2008 2009 2005 2006 1988 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 1979 1980 1981 1982 1983 1984 1985 1986 1987 1997 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 1974 1982 1983 1984 1985 1986 1987 1991 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 1974 1986 1987 1993 1995 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 1974 1982 1983 1984 1985 1986 1987 1988 1989 1990 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 1980 1989 1991 1992 1995 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 1986 19
25. VE Leen d Peda TAMAN Ne en Gap godi an LET ae Laai TI HREN B2 3 Saving the Table for further manipulation The table can be saved in a Comma Separate Value CSV format To save click 4 at the top left corner of the table and specify the name and location for the CSV file 21 C Other Reports in LST TRAINS C1 Trade Restrictiveness Indices TRI Trade Restrictiveness Indices TRI by country year have been pre calculated for each Reporter country and available year For the calculation method see Annex E1 To obtain TRI click Report menu and select TRI Indicators The following panel appears to select Reporter 2 Select Countries Afghanistan Albania Algeria Angola Antigua and Barbuda Argentina Armenia Australia Austria Azerbaijan Bahamas The Bahrain Bangladesh Barbados Belarus Belgium Belize Benin Bhutan Bolivia Bosnia and Herzegovina Botswana Brazil Brunei Bulgaria Add All gt gt 2 Select Countries Afghanistan Bhutan Bolivia Bosnia and Herzegovina Botswana Brazil Brunei Bulgaria Burkina Faso Burundi Cambodia Cameroon Canada Cape Verde Central African Republic Chad Albania Algeria Angola Antiqua and Barbuda Argentina Armenia Australia Austria Azerbaijan Bahamas The Bahrain Bangladesh Barbados Belarus Belize Chile lt lt Remove All Benin Chie lt lt Remove Al Colombia Congo Dem Rep Congo Rep Costa Ri
26. an be 14 shown by expanding the selecting from clicking b at the Country Groups Country Group Category Show All Country Group Definitions z Expand and Select Required Counties and Country Groups Developed economies Asia and Oceania 2101 Developing economies Asia and Oceania 2102 Northern Africa excluding Sudan 2111 Sub Saharan Africa 2112 Central Africa 2113 East Africa 2114 South of Africa 2115 Sub Saharan Africa excluding South Africa 2116 Africa excluding South Africa 2117 South America excluding Brazil 2121 Small Caribbean Islands 7127 Greater Caribbean Islands excluding Puerto Rico 7123 Central America and Greater Caribbean Islands excluding Puerto Rico 2174 Select as many Country Groups as required by checking corresponding B1 5 2 Individual Countries Individual countries can be selected by expanding Individual Countries and selecting the required countries by checking corresponding Country Group Category Show All Country Group Definitions ir Expand and Select Required Counties and Country Groups gt Country Groups d indvidual Countnes Afghanistan AFG 004 Albania ALB 008 Algerna DZA 012 Angola AGO 024 Antigua and Barbuda ATG 028 Argentina ARG 032 Armenia ARM 051 Australia AUS 036 Austria AUT 040 Azerbaijan AZE 031 Bahamas The BHS 044 Bahrain BHR 048 and all selected countries and 15 country groups will be shown
27. arious nomenclatures and the SITC nomenclature Sources of Tariff Information UNCTAD TRAINS database HS for all years since 1988 UNCTAD database on Trade Control Measures based on CCCN GATT tariff study series based on CCCN International Customs Tariff Bureau BITD files purchased by IMF ae a a For the catalogue of available country years available as of 1 September 2011 see Annex E2 An updated list will be made available inside the System Tariff Indicators in the Database For the tariff lines corresponding to each SITC leaf level code sum Of Rates sum of ad valorem tariff rates sum Of Sguared Rates sum of squared ad valorem tariff rates min_Rate minimum ad valorem tariff rate or its equivalent AVE max_Rate maximum ad valorem tariff rate or its equivalent AVE count AVE Lines number of tariff lines for which ad valorem equivalents AVE have been calculated for non ad valorem rates count NA Lines number of tariff lines which are excluded from calculation of indicators for example because the AVE has not been calculated or the rate is not available at all count_Free_Lines number of MFN duty free tariff among the tariff count Dutiable Lines number of tariff lines with ad valorem rate gt 0 count DomesticPeaks number of tariff lines with ad valore rate or its equivalent AVE gt 3 x the country s overall simple average tariff rate 10 count_InternationalPeaks number of tariff lines with ad valore rate
28. ca Cote d Ivoire Croatia Cyprus Burkina Faso Czech Republic sej Select the desired Reporter countries by selecting from the left box and moving to the right one by clicking CT All countries may be selected by simply clicking Add Reporter countries not reguired may be removed from the list in the right box by selecting the countries in the right box and clicking oe Remove or simply click Fee to start the selection process from the beginning Once all countries have been selected click Z following table The TRI Indicators are presented in a kaap Vaaraa Domaca Fats da ee te biel ak dik 1E TC dar oan ag Li aa dami pa S EST is Pee T ili ee a hate E F na TS ifs podi dil da NAST BPS Mia dina a a Pena EPM Las 10 j zr ATENE 2114 NEMI FETT VRE VE EE i io j E SIH IIHT TE z SE RH IAE tirni ET EHC Kra i di Hi 7 z HELENA ME iris La et La de UA Jiini Mi r dna NEKI LAMIH ja pij OMETE EVE OI dana SETI LETI i MIHI See Annex E1 for the description of each column The table view can be customized and or saved in a similar way as the Query Results table explained in B2 2 and B2 3 above LS Krem VNETE gala MINILA IME CIMET NEKA ANE H ag Ji dal di i wi aa ETA PZA EDA Gri ZA CA E 22 C2 Import Demand Elasticity Import Demand Elasticity has been estimated by UNCTAD for each country year at the SITC Rev1 4 digit product level using the methodology intro
29. demonstrated how to compute a trade restrictiveness index under certain assumptions To do this only three pieces of data are required i import shares of each commodity ii tariff rates by commodity and iii price elasticities of demand for imports by commodity The mathematical formula for this index is 2 1 2 nasel MY SAJ gt Sje j Trade restrictiveness index for country k where S is the share of imports of good j in total imports is the price elasticity of demand for imports of good j and f is the tariff rate applied to good j Price elasticities have been econometrically estimated by Nicita 2010 for about 4000 products per country and 88 countries using a method similar to the one presented in Kee Nicita and Olarreaga 2006 28 References Anderson James and J Peter Neary 2005 Measuring the Restrictiveness of International Trade Policy Cambridge MIT Press Edwards Sebastian 1993 Openness Trade Liberalization and Growth in Developing Countries Journal of Economic Literature vol 31 Issue 3 September pp 1358 1393 Feenstra Robert 1995 Estimating the Effects of Trade Policy in Handbook of International Economics Volume 3 edited by Gene Grossman and Kenneth Rogoff Amsterdam Elsevier pp 1553 95 Kee Hiau Looi Alessandro Nicita and Marcelo Olarreaga 2009 Estimating Trade Restrictiveness Indices Economic Journal 119 534 pp 172 199 Nicita Alessa
30. duced and adopted by Kee Nicita and Olarreaga 2009 see reference in Annex E1 In LST TRAINS the Elasticity series can be downloaded by country year Click Report menu and select Elasticities The following panel appears to select a Reporter country first then select the year available for that country from the list SPA Select Reporter and Year Fe Select Reporter and Year Reporter Germany sz Sar OF Cancel Click 98 land the Elasticity for the selected country year is provided for each SITC 4 digit level with corresponding product description as follows MW Product elasticties Mm 4 4 6 of 485 b OPI Pivot ge Select Filter KY Refresh Data Reporter Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Product 0011 0013 O01 4 0015 0111 0112 0113 0114 0118 0121 0125 0133 U1 34 0 957 0016 1 00554 2 31 7937 1 4435215 199504 F2 0 954561 1 002927 119282342 2 3354U6 0 004206 LEFT Description Bovine cattle incl Swine Poultry live Horses asses mul Meat of bovine a Meat of sheep Meat of swine Ire Poultrincl otfals Other fresh chille Bacon ham amp oth Meat amp edible off Meat extracts amp Sausages wheth The table can be saved by clicking 4 at the top left corner and specifying the name and location of the file to be saved
31. e a World 7 016352 5 168298 3 769466344178 6057670676014 7 783103928391 0 35 158 USA 0011 WLD 1991 MFN United States Bovine cattle in World 0 0 0 0 O 0 0 159 USA 4 WLD 1991 MFN United States Animal oils and world 2 7166667 3 6583333 2 158094339085 4 401388862133 2 097948727241 0 5 160 USA 4113 WLD 1991 MFN United States Animal oils fats World 4 6 4 6 3 913676462990 0 320000006357 0 565685430568 3 5 161 USA Food WLD 1991 MFN United States Food SITC 04 World 6 76482534 4 847745 3 595569967763 59 19933769539 7 694110585077 0 35 162 USA 0 WLD 1992 MFN United States Food and live a World 7 053135 5 219618 3 818198930089 60 50847101732 7 778719111609 0 35 163 USA 0011 WLD 1992 MFN United States Bovine cattle in World 0 0 0 0 O 0 0 164 USA 41 WLD 1992 MFN United States Animal oils and World 2 71 66667 3 6583333 2 095006771933 4 401388862133 2 097948727241 0 5 165 USA 4113 WLD 1992 MFN United States Animal oils fats Word 4 6 4 6 3 938372181012 0 320000006357 0 565685430568 3 5 166 USA Food WLD 1992 MFN United States Food SITC 0 World 6 79956532 488633537 3 610153845939 59 15757338178 7 691396061950 0 35 167 USA 0 WLD 1993 MFN United States Food and live a World 7 053135 5 219618 3 892726639676 60 50847101732 7 778719111609 0 35 168 USA 0011 WLD 1993 MFN United States Bovine cattle in World 0 0 0 0 0 0 0 169 USA 41 WLD 1993 MFN United States Ani
32. e than Number of tariff line level lines with tariff rates above 100 100 Import Values in Bilateral imports of Reporter from Partner for the selected product 1000 USD B2 2 Customizing the Table View B2 2 1 Sorting the Table The result table can be sorted by any of the columns in descending or ascending order Click once the title of the column and the table will be sorted in ascending order and click it again will sort the table in descending order B2 2 2 Filtering the Table The table can be filtered for any single indicator to be shown For example if only the Weighted Tariff Average is needed then from the Select Filter indicator the above table will be reduced the one below ee Peti fie ee umiri Beti G li i pise POM ori poleni Mimo Cd bedra Dala menu select the corresponding i i dat ga Feed and ee ra i 4 iT LEE Fetal ae fee dri Fatt edd feet i Vel aed ee upa Faced ond kve mi r Pied aed rom ru EGEEE Fora gral lee ara Pama zid fre aa Fuj zdj kre a alu Vod ud a ia ses OO O O U OO Z O 4 ni Va ari ve gu 2 Food pedi rom gra Figelj oral rem mu Pagi rad re e u Piem en ri Fo and et YA Vol aed ee imi Face arr ben ra Tedi oral ieee ara kav vg Final ral live dra ue Pie ed eri ara Daj zaj brd zi SERIE ELE LE LED wu iD wie il we LO LE iL teri aii O O G gt O O O OO OO G 20 B2 2 3 Pivoting the Table The table can be pivoted to show each Year in
33. enu Query and click Save ss o Query Reports Tools Help Tools Help be Name Test esti Years 1980 to 2010 380 to 2010 Years 1964 to 1973 in 964 to 1973 ALLI Section 1 digit ection 1 digit gt Food Food SITC 0 1 22 4 ood SITC 0414224 4113 Animal oils fats and grease S Developed economies Asia and O Developed economies Asia and O ta United States USA 840 Partners t World WLD 000 world WLO 000 B1 8 Executing a Query To execute a saved query click Execute from the Query menu above The progress of the query execution can be monitored by selecting Status from the same menu German indicators Test version of executed query Ready results for reporting MFH indicators for Australia G3 and 2114 New test for nafta New test for nafta Test indrvidual EU member Some products from sechon 71 gel Query Status First test British tants over long time penod Delete Quer View Report OF Cancel When the Status becomes Completed the results can be retrieved see the next chapter amp 17 B2 Query Results Query results are contained in the Report section of LST TRAINS Tools Help ku View Query Results 4 0 TRI Indicators dd Elasticities Years 1980 to 2010 i Years 1964 to 1973 B2 1 Viewing the result in default format table By selecting View Qu
34. ery Results in the Report menu above the list of queries that have been completed appears ad View Results Report 1 Description mur MFN indicators for Australia G3 and 2114 See what is there Single year test G erman indicators Test version of executed query Ready results for reporting MEN indicators for Australia G3 and 2114 New test for nafta New test for nafta Test individual EU member View Report OF Cancel dli Select the desired query by checking the corresponding e g Test1 and click View Renon The results of the query are presented in a spreadsheet form 18 MFN Tariff Indicators juje Testi Xj 1 of 246 gt DI pivot J Select Filter Refresh Data m ee ee ln le 130 2101 4113 WLD 2006 MFN Developed econ Animal oils fats World 1 2875 1 21315789 0 733954661973 5 181510381003 2276293122821 0 6 5 131 2101 Food WLD 2006 MFN Developed econ Food SITC 0 World 8 745243 5 692443 5 763809627799 320 3802087251 17 89916782214 0 230 132 2101 0 WLD 2007 MFN Developed econ Food and live a World 9 633085 6 53432941 6 340430330983 346 59838372665 18 61715294363 0 230 133 2101 0011 WLD 2007 MFN Developed econ Bovine cattle in World 0 0 0 0 0 0 0 134 2101 41 WLD 2007 MFN Developed econ Animal oils and World 1 91428566 1 42291665 1 484787283485 9 529319704665 3 086959621482 0 12 135 2101 4113 WLD 200
35. essions alters current thinking on the relationship between trade and growth The new database is a homogenous analytical one of tariff and import statistics from 1970 to the present The package of the database and the application is available as UNCTAD Long Time series TRAINS database The use of SITC Rev 1 product classification enables easy multi country multi year comparisons A1 The Four Menus 1 Query The Query is the basic tool of the System Under this menu users select required dimensions years products reporter countries and partner countries and submit the query to calculate the basic tariff and trade indicators 2 Reports Under the Reports users obtain the results of the query constructed and submitted above or retrieve pre calculated Trade Restrictiveness Index TRI indicators by selecting desired countries and or Import Demand Elasticity series used as input into TRI calculation both by selecting a country year 3 Tools The available Tools include construction of user defined product group and country group 4 Help This menu is under development A2 Databases Principles Data and Coverage The database of LST TRAINS is constructed by matching the SITC Rev1 Import statistics from UN COMTRADE http comtrade un org with indicators of applied MFN tariff rates at each leaf level SITC Rev 1 product 4 or 5 digit The indicators are obtained concordance between the national tariff schedules reported in v
36. gu aa ee ia UB 14 Bie SZ Individual NA one ang eumgun thn mainan nsn an una 15 Bi s 2 Reviewing country selection en RIANA NIS 15 BLO ae aa 16 Bi 7 Reviewine Ouery DeMNIONS en mn aa mba Jam 17 Bee reuni Oa nun 17 BZ Ou en Aa 18 B2 1 Viewing the result in default format table 18 B22 4 ustomizine De Table VIEW anna ANE NA 20 Bee Sortinerhe dolan Sae ame NN O 20 B222 KINANA Tabe a mung 20 B22 Pivodine the Papi esses say sais ab nb ne asn eli In 21 B2 3 Saving the Table for further manipulation ocoaaak 21 C Other Reports nS TRAINS nei A eee ie ie ee icra 22 CL Trade Restrictiveness Indices TRD sees streets cote a eta tetas 22 C2 Import Demand BIaStiCItY angan asalan as 23 Doo ES T TRAIN BBS 24 DI Building and Managing Country Groups 24 D2 Building and Managing Product Groups oooo naa 26 EAN CS oa Wa ema NN a A A NE 28 FI Trade Resinctive Indices TR Di sensei Ra 28 Fo Catalosue Of Data A Yailabi y samaan aa Kan una NN AI 30 Introduction This document provides a brief introduction to the Long Time Series version of UNCTAD Trade Analysis and Information System LST TRAINS and shows you how to build queries and retrieve data through a series of demonstrations and examples How to Use This Manual The following typographical conventions are used in this manual Blue texts or grey if black and white copy indicate LST TRAINS commands feat
37. in the Current Selection Box In the example below Developed Economies of Asia and Oceania is selected from the Country Groups and USA is selected from the Individual Countries Country Group Category IM 2S how All Country Group Definitions a ba Expand and Select Required Counties and Country Groups Current Selections Delete Lode Name x 2101 Developed economies Asia and Ucearia x USA 840 United States Any selection can be deleted by clicking the corresponding at B1 6 Partners Partners are countries which export to the selected reporters and possibly face tariff protection when entering the market Partners can be selected in the same way as Reporters with one distinct difference In the Individual Countries selection option World is included a General Product H eporters Partners Partner and Partner Group Selector Country Group Category Show All Country Group Definitions m Expand and Select Required Counties and Country Groups gt Country Groups 4 individual Countnes World WO 000 Afghanistan AFG 004 Aland Islands ALI 248 This is because import statistics are reported by the reporting countries for each individual exporter partner as well as the total from the world B1 7 Reviewing Query Definitions All dimensions of the query can be reviewed on the left side pane by clicking the corresponding dimension Before executing the query it must be saved To save open the m
38. le by aggregating import values and other additive numbers and averaging tariff rates Pre defined groups can be shown by clicking at the Product Groups as follows gu 7 Query Reports Tools Help Definition Explorer q pi EEr Products Reporters ad Query Definition SSS 5 xin Fo As General Products and Product Groups a Name Testi be Years 1980 to 2010 Le Years 1964 to 1973 Product Nomenclature ti Products standard International Trade Classification Revision 1 Expand and Select Required Products gt Global Selections 4 Product Groups Code Description Agriculture Agricultural Materials SITC 04142 27 28 4 AgrRaw Chemical Chemicals SITC 45 Food SITE 04142244 Fuels SITC 3 Machinery amp Transport Equipment SITC 7 manutactures Miscellaneous Goods SITC S Ores Mtls Ores amp Metals SITC 274784658 OthrManf Other manufactures SITC 6 8 68 PetrlPrd Petroleum Products SITC 327 Textiles Textiles as 26465424 of SITC Rev rir Select any number of aggregates by checking the corresponding 12 B1 4 3 Individual Products If only a few individual products are required then select them from the individual product tree Expanding Individual Product shows the listing of SITC 1 digit level Each one digit category can be expanded to 2 digit list by clicking ie corresponding and each 2 digit into 3 digit list and AN A AL AL afa ava aya AL AL ALOLLA lan a AMAL
39. li k va s iv S F D Department for International UNCTAD Development Trade Analysis and Information System Long Time Series Version LTS TRAINS User s Manual Version 1 0 October 2011 LTS TRAINS has been developed by United Nations Conference on Trade and Development UNCTAD in collaboration with International Monetary Funds IMF and with financial assistance from UK Department for International Development DFID For feedback please send emails to UNCTAD TRAINS Team in Geneva trains unctad org For updates and an electronic version of this document please go to ftp ftp unctad org aki LTS TRAINS Manuals LTS TRAINS Manual pdf Table of Contents Introd WA coisa tides en en E AAEE A eta EE 3 EO oU TuS Pa IE sl E ein oes gt A Introduction to LST TRAINS wi WW ai 6 NU The Four MENU sx nanah in SI NN 1 A2 Databases Principles Data and Coverage oooaa 1 B Overyan LST TRAINS Lisan ss Massa iyaa Maa 9 Bi Oe iy Del AA On nakal nama nnti Ba 9 Bil WAGAWA AA Ne WAA 9 BL Open TSW OUS ah rcs AAA WAA A S 9 B1 3 Name and Description of the Query and YearS oooWomo 10 BLA POUC VA ea seta esate A cae O O AA S O NA 11 Biki Global SE LEC OS sani ma anis arn ter treet myn 12 Bi PO GROUP ee ln BN DB 12 Bla Indiyadual Products ab bea Demam sun An 13 B144 Reviewing product selection nan coset vias ian kkn nan anis 13 BLS RENONCE ben OI O WAN ea cutee 14 B 19 1 Country GIOU pa
40. mal oils and World 2 7 166667 3 6583333 2 062349762475 4 401388862133 2 097948727241 0 5 w D 1992 _AACKL il Ac ac 9 OAENO7OOJ1 474 NN MANCIRT A ECECOEAJNECO k E The results are organized in rows and contain the following fields column headings Column Heading Reporter Product Partner Year Duty Type Reporter Name Product Name Partner Name Simple Average Simple Tariff Line Average Weighted Average Variance Standard Deviation Minimum Rate Description Reporter country ISO3 or group 4digit code Product in SITC code or group abbreviation Partner ISO3 or group 4digit code Year of tariff data MFN Reporter country name or group description Product or group description Partner country name or group description In percentage simple average tariff of included SITC leaf level tariff rates The SITC leaf level tariff is itself an average of included tariff line level rates Simple average tariff rates across all tariff lines included in the selected product or product group Simple Average and Simple Tariff Line Average may differ as number of tariff lines corresponding to each leaf level STIC code are different and each may carry different tariff rate in percentage average of tariffs SITC leaf level tariff rates weighted by their corresponding bilateral trade value The SITC leaf level tariff is itself an average of included tariff line level rates Statistical measure of how widel
41. ndro 2010 Rodrik Dani and Francisco Rodriquez 2001 Trade Policy and Economic Growth A Skeptic s Guide to Cross National Evidence Macroeconomics Annual 2000 edited by Ben Bernanke and Kenneth Rogoff MIT Press for NBER Cambridge 29 E2 Catalogue of Data Availability The following table provides the available countries with corresponding years in LST TRAINS at the time of its initial launch in September 2011 As more data are included in the system the updated catalogue will be maintained in the System itself Country Availabe Years Afghanistan 2004 2006 2007 2008 1997 2000 2001 2002 2003 2004 2005 Albania 2006 2007 2008 2009 Algeria 1973 1979 1989 1992 1993 1997 1998 2001 2002 2003 2005 2006 2007 2008 1966 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 Angola 1980 1981 1982 1983 1984 1985 2002 2004 2005 2006 2008 2009 1979 1980 1981 1982 1983 1984 1985 Antigua and Barbuda 1986 1996 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 1984 1987 1988 1992 1993 1995 1996 Argentina 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 Armenia 2001 2003 2004 2005 2006 2007 2008 1973 1975 1981 1984 1986 1991 1993 Australia 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 1972 1975 1984 1990 1996 1997 1998 Austria 1999 2000 2001 2002
42. ures land elements Blue underlined texts indicate references to other documents or sections of the documenft it may also indicate links to the web Numbered lists describe step by step processes A Introduction to LST TRAINS UNCTAD in collaboration with IMF and with financial assistance from UK DFID initiated a new project in May 2010 to build this time series database based on the longest standing product nomenclature namely the Standard International Trade Classification Revision 1 SITC Rev 1 and develop an application to manipulate the database The database draws raw tariff data from various sources that include UNCTAD TRAINS Harmonized system database WTO IDB database GATT Tariff Study files and International Customs Tariff Bureau BITD files purchased by IMF converted by IMF in SITC Revision 1 classification standardized and transferred to a single historical database This new application allows researchers to inter alia construct trade restrictiveness indices TRIs that overcome the weaknesses inherent in the indices that have been used to date the simple average tariff rate and the others mentioned above With the new database a number of interesting research questions could be answered including i a comparison of the evolution of different indicators simple average tariff versus the Anderson Neary trade restrictiveness index TRI for example and ii how using Anderson Neary TRIs in standard growth regr
43. y tariffs are dispersed Square root of Variance In percentage points lowest tariff rate at the tariff line level within the 19 selected product or product group Maximum Rate in percentage points highest tariff rate at the tariff line level within the selected product or product group Nbr of AVE Lines Number of tariff line level lines with estimated Ad Valorem Equivalents of Non Ad Valorem tariff rates Nbr of NA Lines Number of tariff line level lines with no Ad Valorem tariff Non Ad Valorem tariffs or missing rates Nbr of Free Lines Number of tariff line level lines with 0 tariff Nor of Dutiable Lines Number of tariff line level lines with tariff above 0 excluding NA Nbr of Total Lines Number of tariffs at the tariff line level Nbr of DomesticPeaks Number of tariffs at the tariff line level with the rates higher than 3 times the overall simple average tariff of the Reporter country Nbr of International Number of tariffs at the tariff line level with rates higher than 15 Peaks Nbr Line 0 to 5 Number of tariff line level lines with tariff rates between 0 and 5 Nbr Line 5 to 10 Number of tariff line level lines with tariff rates between 5 and 10 Nbr Line 10 to 20 Number of tariff line level lines with tariff rates between 10 and 20 Nbr Line 20 to 50 Number of tariff line level lines with tariff rates between 20 and 50 Nbr Line 50 to 100 Number of tariff line level lines with tariff rates between 50 and 100 Nbr Line mor
Download Pdf Manuals
Related Search