Please cite as
Koren, Miklós and Rita Pető. 2020. "Replication package for «Business disruptions from social distancing»" (Version 1.3) [Data set]. Zenodo. http://doi.org/10.5281/zenodo.4016325
All text and graphs (*.md, *.txt, *.tex, *.eps) are CC-BY-4.0. All code (*.do, Makefile, *.py) are subject to the 3-clause BSD license. All derived data (data/derived/*) are subject to Open Database License. Please respect the copyright and license terms of original data vendors (data/raw/*).
The mobility data used in this paper (SafeGraph 2020) is proprietary, but may be obtained free of charge for COVID-19-related research from the COVID-19 Consortium. The authors are not affiliated with this consortium. Researchers interested in access to the data can apply at https://www.safegraph.com/covid-19-data-consortium (data manager: Ross Epstein, ross@safegraph.com). After signing a Data Agreement, access is granted within a few days. The Consortium does not require coauthorship and does not review or approve research results before publication. Datafiles used: /monthly-patterns/patterns_backfill/2020/05/07/12/2020/02/patterns-part[1-4].csv.gz (Monthly Places Patterns for February 2020, released May 7, 2020), /monthly-patterns/patterns/2020/06/05/06/patterns-part[1-4].csv.gz (Monthly Places Patterns for February 2020, released June 5, 2020) and /core/2020/06/Core-USA-June2020-Release-CORE_POI-2020_05-2020-06-06.zip (Core Places for June 2020, released June 6, 2020). The COVID-19 Consortium will keep these datafiles accessible for researchers. The authors will assist with any reasonable replication attempts for two years following publication.
All other data used in the analysis, including raw data, are available for reuse with permissive licenses. Raw data are saved in the folder data/raw/. The Makefile in each folder shows the URLs used to download the data.
SafeGraph. "Patterns [dataset]"; 2020. Downloaded 2020-06-20.
Proprietary, see https://shop.safegraph.com/ or https://www.safegraph.com/covid-19-data-consortium (data manager: Ross Epstein, ross@safegraph.com)
U.S. Department of Labor/Employment and Training Administration, 2020. "O*NET Online." Downloaded 2020-03-12.
CC-BY-4.0 https://www.onetonline.org/help/license
U.S. Bureau of Labor Statistics. 2020. "Current Employment Statistics." https://www.bls.gov/ces/ Downloaded 2020-03-15.
Public domain: https://www.bls.gov/bls/linksite.htm
U.S. Bureau of Labor Statistics. 2018. "National Employment Matrix." https://www.bls.gov/emp/data/occupational-data.htm Downloaded 2020-03-15.
Public domain: https://www.bls.gov/bls/linksite.htm
U.S. Bureau of Labor Statistics. 2019. "O* NET-SOC to Occupational Outlook Handbook Crosswalk." https://www.bls.gov/emp/classifications-crosswalks/nem-onet-to-soc-crosswalk.xlsx Downloaded 2020-03-15.
Public domain: https://www.bls.gov/bls/linksite.htm
U.S. Bureau of Labor Statistics. 2018. “American Time Use Survey.” https://www.bls.gov/tus/.
We are using the following files:
Data is in public domain.
U.S. Bureau of the Census. 2017. "County Business Patterns." Available at https://www.census.gov/programs-surveys/cbp.html
https://www.census.gov/data/developers/about/terms-of-service.html
| Data file | Source | Notes | Provided |
|---|---|---|---|
data/raw/bls/industry-employment/ces.txt |
BLS Current Employment Statistics | Public domain | Yes |
data/raw/bls/atus/*.dat |
BLS Time Use Survey | Public domain | Yes |
data/raw/bls/employment-matrix/matrix.xlsx |
BLS National Employment Matrix | Public domain | Yes |
data/raw/bls/crosswalk/*.xlsx |
O*NET-SOC to Occupational Outlook Handbook Crosswalk | Public domain | Yes |
data/raw/onet/*.csv |
O*NET Online | Creative Commons 4.0 | Yes |
data/raw/census/cbp/*.txt |
County Business Patterns | Public domain | Yes |
not-included/safegraph/02/*.csv |
SafeGraph | Available with Data Agreement with SafeGraph | No |
not-included/safegraph/05/*.csv |
SafeGraph | Available with Data Agreement with SafeGraph | No |
| Data file | Source | Notes | Provided |
|---|---|---|---|
data/clean/industry-employment/industry-employment.dta |
BLS Current Employment Statistics | Public domain | Yes |
data/clean/time-use/atus.dta |
BLS Time Use Survey | Public domain | Yes |
data/clean/employment-matrix/matrix.dta |
BLS National Employment Matrix | Public domain | Yes |
data/clean/onet/risks.csv |
O*NET Online | Creative Commons 4.0 | Yes |
data/clean/cbp/zip_code_business_patterns.dta |
County Business Patterns | Public domain | Yes |
| Data file | Source | Notes | Provided |
|---|---|---|---|
data/derived/occupation/* |
Various sources | Public domain | Yes |
data/derived/time-use/atus_working_at_home_occupationlevel.dta |
BLS Time Use Survey | Public domain | Yes |
data/derived/crosswalk/* |
Various sources | Public domain | Yes |
not-included/safegraph/naics-zip-*.csv |
SafeGraph | Available with Data Agreement with SafeGraph | Yes, with permission of SafeGraph |
data/derived/visit/visit-change.dta |
SafeGraph | Aggregated to 3-digit NAICS industries | Yes, with permission of SafeGraph |
estout (from http://www.stata-journal.com/software/sj14-2/)make install from the root of the folder will install estout locally, and should be run once.Portions of the code use bash scripting (make, wget, head, tail), which may require Linux or Mac OS X.
The entry point for analysis is analysis/Makefile, which can be run by GNU Make on any Unix-like system by
cd analysis
make
The dependence of outputs on code and input data is captured in the respective Makefiles.
We have used Mac OS X, but all the code should run on Linux and Windows platforms, too.
The analysis takes a few minutes on a standard laptop.
data/raw/<vendor>/<dataset>. This data is saved as it has been received from the data publisher, downloaded by the respective Makefiles. Each folder has a README.md with data citation and license terms.data/clean/<dataset>. Each folder has a Makefile that specifies the steps of data cleaning.data/derived/<topic>. Each folder has a Makefile that specifies the steps of sample specification, variable selection and modification.analysis/. A Makefile specifies how the .do files have to be run to reproduce the analysis.After uncompressing the replication package, change the working directory to analysis/ and run the Makefile there.
mkdir koren-peto
cd koren-peto
unzip ../koren-peto.zip
cd analysis/
make
The Makefile assumes that Stata is accessible from your shell via the command stata. If you use any other command to call Stata, introduce an alias.
| Exhibit | File | Code |
|---|---|---|
| headcount number in abstract | analysis/headcount.log line 66 |
analysis/headcount.do |
| Table 1 | NA | NA |
| Table 2 | exhibit/table2.csv |
analysis/toplist.do |
| Table 3 | exhibit/table3.tex |
analysis/employment-growth.do |
| Table 4 | exhibit/table4.csv |
analysis/counterfactual.do |
| Figure 1 | exhibit/fig1.eps |
NA |
| Figure 2 | exhibit/fig2.eps |
analysis/scatter_customers_teamwork_byoccupation.do |
| Figure 3 | exhibit/fig3.eps |
analysis/scatterplot_validation_customer_atus.do |
| Figure 4 | exhibit/fig4.eps |
analysis/scatterplot_validation_teamwork_atus.do |
| Supplementary Information 1 | exhibit/SI1.csv |
analysis/create_SI1.do |