{"id":18,"date":"2018-12-30T23:11:46","date_gmt":"2018-12-30T23:11:46","guid":{"rendered":"https:\/\/faculty.som.yale.edu\/peterschott\/?page_id=18"},"modified":"2019-11-19T14:44:13","modified_gmt":"2019-11-19T14:44:13","slug":"international-trade-data","status":"publish","type":"page","link":"https:\/\/faculty.som.yale.edu\/peterschott\/international-trade-data\/","title":{"rendered":"International Trade Data"},"content":{"rendered":"

[vc_row][vc_column][vc_column_text]Schott’s International Economics Resource Page<\/strong>
\nTrade Data and Concordances
\n<\/strong>Updated 2018.10.15<\/strong><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Dataset \/ Documentation<\/strong><\/td>\nCitation<\/strong><\/td>\nDownloads<\/strong>
\n<\/strong>(Right click to download)<\/td>\n<\/tr>\n
HS-level U.S. import and export data
\n(HS x country x year; Stata format)
\n(v2018.10.15)HS import data layout<\/a>
\nHS export data layout<\/a>These data were purchased from the U.S. Census Bureau<\/a> and converted into Stata format; funding from Yale Social Sciences Library is acknowledged gratefully<\/td>\n		Please reference Schott (2008)<\/a>;<\/p>\n

Note that in addition to the records contained in the layout, these files also contain NAICS codes<\/td>\n

\n

Imports<\/em>: 1989<\/a> 1990<\/a> 1991<\/a> 1992<\/a> 1993<\/a> 1994<\/a> 1995<\/a> 1996<\/a> 1997<\/a> 1998<\/a> 1999<\/a> 2000<\/a> 2001<\/a> 2002<\/a> 2003<\/a> 2004<\/a> 2005<\/a> 2006<\/a> 2007<\/a> 2008<\/a> 2009<\/a> 2010<\/a> 2011<\/a> 2012<\/a> 2013<\/a> 2014<\/a> 2015<\/a> 2016<\/a> 2017<\/a><\/p>\n

Exports<\/em>: 1989<\/a> 1990<\/a> 1991<\/a> 1992<\/a> 1993<\/a> 1994<\/a> 1995<\/a> 1996<\/a> 1997<\/a> 1998<\/a> 1999<\/a> 2000<\/a> 2001<\/a> 2002<\/a> 2003<\/a> 2004<\/a> 2005<\/a> 2006<\/a> 2007<\/a> 2008<\/a> 2009<\/a> 2010<\/a> 2011<\/a> 2012<\/a> 2013<\/a> 2014<\/a> 2015<\/a> 2016<\/a> 2017<\/a><\/p>\n<\/td>\n<\/tr>\n

Concordance for 1989-2007 US HS codes over time<\/p>\n

 <\/td>\n

Please reference Pierce and Schott (2012)<\/a><\/td>\nZip file<\/a>; see paper for
\ndescription of contents<\/td>\n<\/tr>\n
Concordance of 1989-2017 US HS codes to US SIC, SITC and NAICS codes over time<\/p>\n

 <\/td>\n

Pierce and Schott (2009)<\/a><\/p>\n

2018 update<\/u>: see this readme.txt for update notes<\/td>\n

2018 version<\/a><\/p>\n

See paper for
\nmore detail<\/p>\n

(Previous version<\/a>)<\/td>\n<\/tr>\n

Data for replicating results in Pierce and Schott (2016)<\/a><\/td>\nThe Surprisingly Swift Decline of U.S. Manufacturing Employment<\/a> American Economic Review <\/em>106(7):1632-62<\/td>\nData directory<\/a><\/td>\n<\/tr>\n
U.S. apparel and textile quotas under the MFA and ATC<\/p>\n

 <\/p>\n

Description<\/a><\/td>\n

Please reference Brambilla, Khandelwal and Schott (2010)<\/a><\/td>\nDataset<\/a>
\nUS HS-MFA Concordance<\/a>(data zipped using free 7-Zip<\/a> utility)<\/td>\n<\/tr>\n
Chinese HS code to MFA category concordances<\/p>\n

Chinese Source Documents<\/a><\/td>\n

Trade Liberalization and Embedded Institutional Reform: Evidence from Chinese Exporter<\/a>. 2013. American Economic Review <\/em>103(6):2169-95.<\/em><\/td>\nCanada<\/a>
\nEU<\/a>
\nUS<\/a><\/td>\n<\/tr>\n
U.S. Tariff Schedule, 1989-2001<\/td>\nPlease reference Feenstra, Romalis and Schott (2002)<\/a><\/td>\nDataset<\/a><\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
U.S. export and import HS codes used by year<\/td>\nPlease reference Pierce and Schott (2012)<\/a><\/td>\nZip file<\/a><\/td>\n<\/tr>\n
SIC87- and NAICS-level U.S. import and export data, 1972-2005
\n(SIC or NAICS x country x year; Stata format)(v2011.11.30)Data description<\/a>The underlying data were purchased from the U.S. Census Bureau<\/a> and converted into Stata format; funding from Yale Social Sciences Library is acknowledged gratefully<\/td>\n		These data are an update of Schott (2008)<\/a> and use the concordances from Pierce and Schott (2009)<\/a> and Bartelsman et al (2000)<\/a>.<\/td>\nSIC87
\n<\/u>1972-2005<\/a>NAICS
\n<\/u>1989-2005<\/a>Notes:(1) These data also contain countries\u2019 GDP per capita and so can be used to compute low-wage country import penetration as in Bernard, Jensen and Schott (2006a)<\/a>. They also contain cif charges and duties collected and so can be used to estimate trade costs as in that paper and in Bernard, Jensen and Schott (2006b)<\/a>.(2) I am no longer updating the SIC version of these data, but will periodically update the NAICS version.<\/td>\n<\/tr>\n
Import penetration, low-wage country competition indexes and trade cost data from Bernard, Jensen and Schott (2006)<\/p>\n

Low-wage competition slides with movie<\/a><\/p>\n

Trade cost slides with movie<\/a>
\nPlotting a Leamer (1987) Triangle?<\/a><\/td>\n

Please reference Survival of the Best Fit: Low Wage Competition and the (Uneven) Growth of US Manufacturing Plants<\/a> Journal of International Economics 68 (2006):219-237.<\/td>\nUpdated (v2011.3.3)<\/u>
\nlow-wage country share (sic basis)<\/a>
\nlow-wage country share (naics basis)<\/a>
\ndata layout<\/a> and graphs<\/a>Original (JIE 2006)<\/u>
\nimport penetration<\/a>
\nlow-wage competition<\/a>
\ntrade costs<\/a>
\ndata layout<\/a><\/td>\n<\/tr>\n
Country-industry capital intensity; described in the paper listed in the cell to the right.<\/td>\nOne Size Fits All? Heckscher-Ohlin Specialization in Global Production<\/a>. 2003. American Economic Review <\/em>93(2):686-708<\/td>\nData<\/a><\/td>\n<\/tr>\n
\u201cParts\u201d indicator for identifying international trade in intermediate goods. This file identifies TSUSA and HS import product codes that contain the word \u201cparts\u201d.<\/td>\nPlease reference Across-Product versus Within-Product Specialization in International Trade<\/a> QJE 119(2):647-678 (May 2004)<\/td>\nIntermediate Product Indicator (Excel)<\/a><\/p>\n

U.S. Intermediate Imports (Stata)<\/a>
\nDataset Layout<\/a><\/td>\n<\/tr>\n

Concordance of Chinese CIC industries to ISIC (revision 3) industries<\/td>\nJudith M. Dean and Mary E. Lovely. “Trade Growth, Production Fragmentation, and China\u2019s Environment.” China’s Growing Role in World Trade. Ed. R. Feenstra and S. Wei. Chicago: NBER and University of Chicago Press, 2010<\/td>\nCIC to ISIC<\/a><\/td>\n<\/tr>\n
Concordance of ISIC (revision 3) to SIC (revision 1987)<\/td>\nhttp:\/\/unstats.un.org\/unsd\/cr\/registry\/regdnld.asp?Lg=1<\/a><\/td>\nISIC to SIC<\/a><\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Concordance of US, UN and WB country codes<\/td>\nPlease reference Schott (2004)<\/a><\/td>\nDataset<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

 <\/p>\n\n\n\n\n\n\n\n\n\n\n
US import and export data<\/strong>
\n(v2018.10.15)<\/p>\n

Citation<\/em>: Schott (2008)<\/a><\/p>\n

Format<\/em>: HS import data layout<\/a>; HS export data layout<\/a><\/p>\n

Imports<\/em>: 1989<\/a> 1990<\/a> 1991<\/a> 1992<\/a> 1993<\/a> 1994<\/a> 1995<\/a> 1996<\/a> 1997<\/a> 1998<\/a> 1999<\/a> 2000<\/a> 2001<\/a> 2002<\/a> 2003<\/a> 2004<\/a> 2005<\/a> 2006<\/a> 2007<\/a> 2008<\/a> 2009<\/a> 2010<\/a> 2011<\/a> 2012<\/a> 2013<\/a> 2014<\/a> 2015<\/a> 2016<\/a> 2017<\/a><\/p>\n

Exports<\/em>: 1989<\/a> 1990<\/a> 1991<\/a> 1992<\/a> 1993<\/a> 1994<\/a> 1995<\/a> 1996<\/a> 1997<\/a> 1998<\/a> 1999<\/a> 2000<\/a> 2001<\/a> 2002<\/a> 2003<\/a> 2004<\/a> 2005<\/a> 2006<\/a> 2007<\/a> 2008<\/a> 2009<\/a> 2010<\/a> 2011<\/a> 2012<\/a> 2013<\/a> 2014<\/a> 2015<\/a> 2016<\/a> 2017<\/a><\/p>\n

Notes<\/em>: These data were purchased from the U.S. Census Bureau<\/a> and converted into Stata format; funding from Yale Social Sciences Library is acknowledged gratefully<\/p>\n<\/td>\n<\/tr>\n

Concordance for US HS codes over time
\n<\/strong>(v XXX)<\/p>\n

Citation<\/em>: Pierce and Schott (2012)<\/a><\/p>\n

Data<\/em>: Zip file<\/a><\/p>\n

Notes<\/em>: These data were purchased from the U.S. Census Bureau<\/a> and converted into Stata format; funding from Yale Social Sciences Library is acknowledged gratefully<\/p>\n<\/td>\n<\/tr>\n

Concordance of US HS codes to SIC, SITC and NAICS
\n<\/strong>(v 2018.10.15)
\n<\/strong><\/p>\n

Citation<\/em>: Pierce and Schott (2009)<\/a><\/p>\n

Data<\/em>: Zip File<\/a><\/p>\n

see paper for description of contents<\/p>\n

Notes<\/em>: These data were purchased from the U.S. Census Bureau<\/a> and converted into Stata format; funding from Yale Social Sciences Library is acknowledged gratefully<\/p>\n<\/td>\n<\/tr>\n

<\/td>\n<\/tr>\n
<\/td>\n<\/tr>\n
<\/td>\n<\/tr>\n
<\/td>\n<\/tr>\n
<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

 <\/p>\n

Links to Useful US Census Data Information<\/strong><\/p>\n