Schott’s International Economics Resource Page
Trade Data and Concordances
Updated 2018.10.15
| Dataset / Documentation | Citation | Downloads (Right click to download) |
| HS-level U.S. import and export data (HS x country x year; Stata format) (v2018.10.15)HS import data layout HS export data layoutThese 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 2016 2017 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 2016 2017 |
| 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-2017 US HS codes to US SIC, SITC and NAICS codes over time
|
Pierce and Schott (2009)
2018 update: see this readme.txt for update notes |
2018 version
See paper for |
| 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 |
| U.S. apparel and textile quotas under the MFA and ATC
|
Please reference Brambilla, Khandelwal and Schott (2010) | Dataset US HS-MFA Concordance(data zipped using free 7-Zip utility) |
| Chinese HS code to MFA category concordances | Trade Liberalization and Embedded Institutional Reform: Evidence from Chinese Exporter. 2013. American Economic Review 103(6):2169-95. | Canada EU US |
| U.S. Tariff Schedule, 1989-2001 | Please reference Feenstra, Romalis and Schott (2002) | Dataset |
| U.S. export and import HS codes used by year | Please reference Pierce and Schott (2012) | Zip file |
| 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 descriptionThe 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-2005NAICS 1989-2005Notes:(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 the SIC version of these data, but will periodically update the NAICS version. |
| 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 |
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 graphsOriginal (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) |
| 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 |
| Concordance of US, UN and WB country codes | Please reference Schott (2004) | Dataset |
| US import and export data (v2018.10.15) Citation: Schott (2008) Format: HS import data layout; HS export data layout 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 2016 2017 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 2016 2017 Notes: These data were purchased from the U.S. Census Bureau and converted into Stata format; funding from Yale Social Sciences Library is acknowledged gratefully |
| Concordance for US HS codes over time (v XXX) Citation: Pierce and Schott (2012) Data: Zip file Notes: These data were purchased from the U.S. Census Bureau and converted into Stata format; funding from Yale Social Sciences Library is acknowledged gratefully |
| Concordance of US HS codes to SIC, SITC and NAICS (v 2018.10.15) Citation: Pierce and Schott (2009) Data: Zip File see paper for description of contents Notes: These data were purchased from the U.S. Census Bureau and converted into Stata format; funding from Yale Social Sciences Library is acknowledged gratefully |
Links to Useful US Census Data Information