Schott's International Economics Resource Page
Trade Data and Concordances
Updated 2016.9.29

Dataset / Documentation

Citation

Downloads
(Right click to download)

U.S. apparel and textile quotas under the MFA and ATC

 

Description

Please reference Brambilla, Khandelwal and Schott (2010)

Dataset
US HS-MFA Concordance

(data zipped using free 7-Zip utility)

HS-level U.S. import and export data
(HS x country x year; Stata format)
(v2013.7.2)


HS import data layout
HS export data layout

These data were purchased from the U.S. Census Bureau and converted into Stata format; funding from Yale Social Sciences Library is acknowledged gratefully

Please reference Schott (2008);

Note that in addition to the records contained in the layout, these files also contain NAICS codes


Imports
1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015

Exports
1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015

(data zipped using free 7-Zip utility)

SIC87- and NAICS-level U.S. import and export data, 1972-2005
(SIC or NAICS x country x year; Stata format)

(v2011.11.30)

 

Data description

The underlying data were purchased from the U.S. Census Bureau and converted into Stata format; funding from Yale Social Sciences Library is acknowledged gratefully

These data are an update of Schott (2008) and use the concordances from Pierce and Schott (2009) and Bartelsman et al (2000).
 

SIC87
1972-2005

NAICS
1989-2005

Notes:

(1) These data also contain countries’ GDP per capita and so can be used to compute low-wage country import penetration as in Bernard, Jensen and Schott (2006a). 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).

(2) I am no longer updating these data, but if you want to have U.S. trade totals by NAICS and country just use the files above and collapse by NAICS.

U.S. export and import HS codes used by year

Please reference Pierce and Schott (2012)

Zip file

Concordance for 1989-2007 US HS codes over time

 

Please reference Pierce and Schott (2012)

Zip file; see paper for
description of contents

Concordance of 1989-2006 US HS codes to US SIC, SITC and NAICS codes over time

 

Pierce and Schott (2009)

Zip file; see paper for
description of contents

Import penetration, low-wage country competition indexes and trade cost data from Bernard, Jensen and Schott (2006)

Low-wage competition slides with movie

Trade cost slides with movie
Plotting a Leamer (1987) Triangle?

Please reference Survival of the Best Fit: Low Wage Competition and the (Uneven) Growth of US Manufacturing Plants Journal of International Economics 68 (2006):219-237.

Updated (v2011.3.3)
low-wage country share (sic basis)
low-wage country share (naics basis)
data layout and graphs

Original (JIE 2006)
import penetration
low-wage competition
trade costs
data layout

Country-industry capital intensity; described in the paper listed in the cell to the right.

One Size Fits All? Heckscher-Ohlin Specialization in Global Production. 2003. American Economic Review 93(2):686-708

Data

“Parts” indicator for identifying international trade in intermediate goods. This file identifies TSUSA and HS import product codes that contain the word “parts”.

Please reference Across-Product versus Within-Product Specialization in International Trade QJE 119(2):647-678 (May 2004)

Intermediate Product Indicator (Excel)

U.S. Intermediate Imports (Stata)
Dataset Layout

Concordance of Chinese CIC industries to ISIC (revision 3) industries

Judith M. Dean and Mary E. Lovely. "Trade Growth, Production Fragmentation, and China’s Environment." China's Growing Role in World Trade. Ed. R. Feenstra and S. Wei. Chicago: NBER and University of Chicago Press, 2010

CIC to ISIC

Concordance of ISIC (revision 3) to SIC (revision 1987)

http://unstats.un.org/unsd/cr/registry/regdnld.asp?Lg=1

ISIC to SIC

Data for replicating results in Pierce and Schott (2016)

The Surprisingly Swift Decline of U.S. Manufacturing Employment  American Economic Review 106(7):1632-62

Data directory