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

Dataset / Documentation

Citation

Downloads
(Right click to download)

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

 

Description

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)
(v2010.5.4)


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

These data are an update of Schott (2008)


Imports
1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005

Exports
1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005

(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

Note: 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).

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

Pierce and Schott (2009)

Zip file

Concordance for 1989-2007 US HS codes over time

 

Pierce and Schott (2009)

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?

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

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

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