#LyX 2.1 created this file. For more info see http://www.lyx.org/
\lyxformat 474
\begin_document
\begin_header
\textclass article
\begin_preamble
\AtBeginDocument{
\addtolength{\abovedisplayskip}{-1.0ex}
\addtolength{\abovedisplayshortskip}{-1.0ex}
\addtolength{\belowdisplayskip}{-1.0ex}
\addtolength{\belowdisplayshortskip}{-1.0ex}
}
\end_preamble
\use_default_options false
\maintain_unincluded_children false
\language english
\language_package default
\inputencoding auto
\fontencoding global
\font_roman default
\font_sans default
\font_typewriter default
\font_math auto
\font_default_family default
\use_non_tex_fonts false
\font_sc false
\font_osf false
\font_sf_scale 100
\font_tt_scale 100
\graphics default
\default_output_format default
\output_sync 0
\bibtex_command default
\index_command default
\paperfontsize 11
\spacing onehalf
\use_hyperref false
\papersize default
\use_geometry true
\use_package amsmath 2
\use_package amssymb 2
\use_package cancel 0
\use_package esint 0
\use_package mathdots 1
\use_package mathtools 0
\use_package mhchem 1
\use_package stackrel 0
\use_package stmaryrd 0
\use_package undertilde 0
\cite_engine basic
\cite_engine_type default
\biblio_style plain
\use_bibtopic false
\use_indices false
\paperorientation portrait
\suppress_date false
\justification true
\use_refstyle 0
\index Index
\shortcut idx
\color #008000
\end_index
\leftmargin 2.5cm
\topmargin 2.5cm
\rightmargin 2.5cm
\bottommargin 2.5cm
\secnumdepth 3
\tocdepth 3
\paragraph_separation indent
\paragraph_indentation default
\quotes_language english
\papercolumns 1
\papersides 1
\paperpagestyle default
\tracking_changes false
\output_changes false
\html_math_output 0
\html_css_as_file 0
\html_be_strict false
\end_header

\begin_body

\begin_layout Title

\series bold
Data for 
\begin_inset Quotes eld
\end_inset

Untangling Trade and Technology: Evidence from Local Labor Markets
\begin_inset Quotes erd
\end_inset


\end_layout

\begin_layout Author
David H.
 Autor 
\begin_inset Newline newline
\end_inset

 
\begin_inset ERT
status collapsed

\begin_layout Plain Layout

%EndAName
\end_layout

\begin_layout Plain Layout

\end_layout

\end_inset

MIT and NBER 
\begin_inset ERT
status collapsed

\begin_layout Plain Layout


\backslash
and
\end_layout

\end_inset

 David Dorn 
\begin_inset Newline newline
\end_inset

 
\begin_inset ERT
status collapsed

\begin_layout Plain Layout

%EndAName
\end_layout

\begin_layout Plain Layout

\end_layout

\end_inset

University of Zurich and CEPR 
\begin_inset ERT
status collapsed

\begin_layout Plain Layout


\backslash
and
\end_layout

\end_inset

 Gordon H.
 Hanson 
\begin_inset Newline newline
\end_inset

 
\begin_inset ERT
status collapsed

\begin_layout Plain Layout

%EndAName
\end_layout

\begin_layout Plain Layout

\end_layout

\end_inset

UCSD and NBER
\end_layout

\begin_layout Standard
\begin_inset Newpage pagebreak
\end_inset


\end_layout

\begin_layout Subsection*
Data files (folder 
\emph on
/dta
\emph default
)
\end_layout

\begin_layout Standard
The online data archive contains the following data sets in Stata format:
\end_layout

\begin_layout Itemize

\emph on
workfile_china.dta
\emph default
 provides data for 722 Commuting Zones times 2 time periods (1990-2000,
 2000-2007), and is taken from Autor, Dorn and Hanson (AER 2013).
 All variables with the prefix 
\begin_inset Quotes eld
\end_inset


\emph on
l_
\emph default

\begin_inset Quotes erd
\end_inset

 refer to start-of-period values while variables with the prefix 
\begin_inset Quotes eld
\end_inset


\emph on
d_
\emph default

\begin_inset Quotes erd
\end_inset

 correspond to 10-year equivalent changes.
 Variables from this file are used in all Tables.
\end_layout

\begin_layout Itemize

\emph on
workfile2012.dta
\emph default
 provides data for 722 Commuting Zones times 2 time periods (1980-1990,
 1990-2000, 2000-2005), and is taken from Autor and Dorn (AER 2013).
 All variables with the prefix 
\begin_inset Quotes eld
\end_inset


\emph on
l_
\emph default

\begin_inset Quotes erd
\end_inset

 refer to start-of-period values while variables with the prefix 
\begin_inset Quotes eld
\end_inset


\emph on
d_
\emph default

\begin_inset Quotes erd
\end_inset

 correspond to 10-year equivalent changes.
 Variables from this file are only used for the results of Table 5.
\end_layout

\begin_layout Itemize

\emph on
czoneYYYYpor_current_v2.dta
\emph default
 and
\emph on
 czoneYYYYpor_mfg_v2.dta
\emph default
 provide additional Commuting Zone variables that measure unemployment,
 nonemployment and employment by sector and occupation for different subgroups
 of the population, and the share of routine employment by Commuting Zone
 and sector.
 The files YYYY={1980, 1990, 2000} are based on 5% IPUMS samples of the
 Decennial Census of Population while the file YYYY=060708 is based on the
 pooled 2006-2008 file of the American Community Survey.
 Variables from this file are used in all Tables.
\end_layout

\begin_layout Itemize

\emph on
czone1950por_indstr_v2.dta
\emph default
 provides for each Commuting Zone the share of routine employment, overall
 and by sector, as predicted by the Commuting Zone's industrial employment
 structure in 1950.
 The data is based on the 1% IPUMS sample of the Decennial Census of Population
 of 1950.
 Variables from this file are used in all Tables except Appendix Table 1
 as instruments for the start-of-period share of routine employment.
\end_layout

\begin_layout Itemize

\emph on
cbp_mfgsh.dta
\emph default
 provides for each Commuting Zone the share of manufacturing in total employment
 according to the County Business Pattern data, and measured separately
 for the years 1980, 1990 and 2000.
 This information is used as a control variable in all Tables.
\end_layout

\begin_layout Standard
Further documentation of the Autor, Dorn and Hanson (AER 2013) and Autor
 and Dorn (AER 2013) data, including downloadable file archives for each
 project and additional information on Commuting Zones, is available from
 David Dorn's data page, www.ddorn.net/data.htm.
 
\end_layout

\begin_layout Subsection*
Computation of results (folder 
\emph on
/do
\emph default
)
\end_layout

\begin_layout Standard
The following Stata do-file combines the data files and computes the results
 of the paper:
\end_layout

\begin_layout Itemize

\emph on
czone_analysis_untangling_final.do
\emph default
 computes results for Tables 1 to 5 and Appendix Table 1.
\end_layout

\begin_layout Subsection*
Raw results (folder 
\emph on
/log
\emph default
)
\end_layout

\begin_layout Standard
The folder 
\emph on
/log
\emph default
 contains the regression log file that is produced by the file in the folder
 
\emph on
/do
\emph default
.
\end_layout

\begin_layout Subsection*
Tables (folder 
\emph on
/tab-fig
\emph default
)
\end_layout

\begin_layout Standard
The Excel file 
\emph on
China-Untangling-Final.xls
\emph default
 provides the full set of Tables that is presented in the paper.
\end_layout

\end_body
\end_document
