Data

1. County Business Patterns (1977-2016)

• Files: Click here for raw files and imputed data; and here for a data-visualization website. Reference: Eckert, Fort. Schott and Yang (2019)

2. US HS-level imports and exports (1989-2023)

• Annual Files 1989-2023 (v2025.2.24): imports and exports
• Monthly Files 1989-2024 (v2025.2.24): imports and exports
• Legacy Annual Files 1989-2023: imports and exports
• Layout: imports; exports; definitions.
• Reference: If you use these data please cite: Schott (2008)
• Notes: (1) These data were purchased from the US Census Bureau and converted into Stata format; funding from Yale Social Sciences Library is acknowledged gratefully. (2) The files for month 12 of each year can be found in the annual link, not the monthly link. (3) There is a known missing file for exports for 2011.4. (4) There are both "annual" files and "legacy annual" files: I rewrote the code I used to process the annual files when I added the monthly files on 2025.2.23. I am keeping the original legacy files up in case anyone depends on them, and as a reference in case any issues arise with the new annual files. (5) The NAICS codes in the trade data are vintage-dependent. That is, the NAICS code mapped to a partricular year is with respect to the NAICS vintage associated with that year, e.g., 2012 vs 2017. Concordances for linking NAICS codes over time are available on my CBP data page ( here).

3. US HS over time concordances

• Files: updated import concordance archive (v2019.7.12); older import and export concordance archive (v2010.10.22)
• Reference: Pierce and Schott (JOS 2012)

4. US HS-SIC/NAICS concordances

• Files: zip archive (v2024.8.1)
• Reference: Pierce and Schott (JESM 2012)

5. US MFA apparel and textile quotas

• Files: zip archive
• Description: Appendix of Pierce and Schott (2012)
• Reference: Brambilla, Khandelwal and Schott (2010)

6. Chinese HS code to Canada, EU and US MFA category concordance

• Files: Chinese Source Documents; Canada file; EU file; US file;
• Reference: Khandelwal, Schott and Wei (2013)

7. US tariff schedule 1989-2001

• Files: zip archive
• Reference: Feenstra, Romalis and Schott (2002)

8. US SIC87-level imports and exports (1972-2005)

• Files: imports and exports
• Reference: Schott (2008); Pierce and Schott (JESM 2012); Bartelsman et al. (2000)
• Note: These data were purchased from the US Census Bureau and converted into Stata format; funding from Yale Social Sciences Library is acknowledged gratefully. These data contain countries’ GDP per capita, and so can be used to compute low-wage country import penetration as in Bernard, Jensen and Schott (JIE 2006), as well as cif charges and duties collected. and so can be used to estimate trade costs as in that paper and in Bernard, Jensen and Schott (JMS 2006). I am no longer updating these data.

9. Import penetration, low-wage country competition and trade costs from Bernard, Jensen and Schott (JIE 2006) and Bernard, Jensen and Schott (JME 2006)

• Layout: original; updated
• Original files: import penetration; low-wage competition; trade costs
• Updated files (2011.3.3): low-wage share (SIC); low-wage share (NAICS)
• Supplements: LWC slides; TC slides; Plotting a Leamer triangle; updated slides
• Reference: Bernard, Jensen and Schott (JIE 2006) and Bernard, Jensen and Schott (JME 2006)