DOI: 10.5281/zenodo.4012191
title: Replication package for «Business disruptions from social distancing»

description: <strong>Replication package for "Business disruptions from social distancing"</strong> Please cite as Koren, Miklós and Rita Pető. 2020. "Replication package for «Business disruptions from social distancing»" [dataset] Zenodo. http://doi.org/10.5281/zenodo.4012191 <strong>License and copyright</strong> All text (<code>*.md</code>, <code>*.txt</code>, <code>*.tex</code>, <code>*.pdf</code>) are CC-BY-4.0. All code (<code>*.do</code>, <code>Makefile</code>) are subject to the 3-clause BSD license. All derived data (<code>data/derived/*</code>) are subject to Open Database License. Please respect to copyright and license terms of original data vendors (<code>data/raw/*</code>). <strong>Data Availability Statements</strong> 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: <code>/monthly-patterns/patterns_backfill/2020/05/07/12/2020/02/patterns-part[1-4].csv.gz</code> (Monthly Places Patterns for February 2020, released May 7, 2020), <code>/monthly-patterns/patterns/2020/06/05/06/patterns-part[1-4].csv.gz</code> (Monthly Places Patterns for February 2020, released June 5, 2020) and <code>/core/2020/06/Core-USA-June2020-Release-CORE_POI-2020_05-2020-06-06.zip</code> (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 <code>data/raw/</code>. The <code>Makefile</code> in each folder shows the URLs used to download the data. <strong>SafeGraph</strong> Citation SafeGraph. "Patterns [dataset]"; 2020. Downloaded 2020-06-20. License Proprietary, see https://shop.safegraph.com/ or https://www.safegraph.com/covid-19-data-consortium (data manager: Ross Epstein, ross@safegraph.com) <strong>O*NET</strong> Citation U.S. Department of Labor/Employment and Training Administration, 2020. "O*NET Online." Downloaded 2020-03-12. License CC-BY-4.0 https://www.onetonline.org/help/license <strong>Current Employment Statistics</strong> Citation U.S. Bureau of Labor Statistics. 2020. "Current Employment Statistics." https://www.bls.gov/ces/ Downloaded 2020-03-15. License Public domain: https://www.bls.gov/bls/linksite.htm <strong>National Employment Matrix</strong> Citation U.S. Bureau of Labor Statistics. 2018. "National Employment Matrix." https://www.bls.gov/emp/data/occupational-data.htm Downloaded 2020-03-15. License Public domain: https://www.bls.gov/bls/linksite.htm <strong>Crosswalk</strong> Citation 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. License Public domain: https://www.bls.gov/bls/linksite.htm <strong>American Time Use Survey</strong> Citation U.S. Bureau of Labor Statistics. 2018. “American Time Use Survey.” https://www.bls.gov/tus/. We are using the following files: Respondent File Activity File Who File Replicate Weights Leave Module 2017-18 License Data is in public domain. <strong>County Business Patterns</strong> Citation U.S. Bureau of the Census. 2017. "County Business Patterns." Available at https://www.census.gov/programs-surveys/cbp.html License https://www.census.gov/data/developers/about/terms-of-service.html <strong>Dataset list</strong> <strong>Raw data</strong> | Data file | Source | Notes | Provided | |-----------|--------|----------|----------| | <code>data/raw/bls/industry-employment/ces.txt</code> | BLS Current Employment Statistics | Public domain | Yes | | <code>data/raw/bls/atus/*.dat</code> | BLS Time Use Survey | Public domain | Yes | | <code>data/raw/bls/employment-matrix/matrix.xlsx</code> | BLS National Employment Matrix | Public domain | Yes | | <code>data/raw/bls/crosswalk/matrix.xlsx</code> | ONET-SOC to Occupational Outlook Handbook Crosswalk | Public domain | Yes | | <code>data/raw/onet/*.csv</code> | ONET Online | Creative Commons 4.0 | Yes | | <code>data/raw/census/cbp/*.txt</code> | County Business Patterns | Public domain | Yes | | <code>not-included/safegraph/02/*.csv</code>| SafeGraph | Available with Data Agreement with SafeGraph | No | | <code>not-included/safegraph/05/*.csv</code>| SafeGraph | Available with Data Agreement with SafeGraph | No | <strong>Clean data</strong> | Data file | Source | Notes | Provided | |-----------|--------|----------|----------| | <code>data/clean/industry-employment/industry-employment.dta</code> | BLS Current Employment Statistics | Public domain | Yes | | <code>data/clean/time-use/atus.dta</code> | BLS Time Use Survey | Public domain | Yes | | <code>data/clean/employment-matrix/matrix.dta</code> | BLS National Employment Matrix | Public domain | Yes | | <code>data/clean/onet/risks.csv</code> | ONET Online | Creative Commons 4.0 | Yes | | <code>data/clean/cbp/zip_code_business_patterns.dta</code> | County Business Patterns | Public domain | Yes | <strong>Derived data</strong> | Data file | Source | Notes | Provided | |-----------|--------|----------|----------| | <code>data/derived/occupation/*</code> | Various sources | Public domain | Yes | | <code>data/derived/time-use/atus_working_at_home_occupationlevel.dta</code> | BLS Time Use Survey | Public domain | Yes | | <code>data/derived/crosswalk/*</code> | Various sources | Public domain | Yes | | <code>not-included/safegraph/naics-zip-??.csv</code>| SafeGraph | Available with Data Agreement with SafeGraph | Yes, with permission of SafeGraph | | <code>data/derived/visit/visit-change.dta</code>| SafeGraph | Aggregated to 3-digit NAICS industries | Yes, with permission of SafeGraph | <strong>Computational requirements</strong> <strong>Software Requirements</strong> Stata (code was last run with version 16.1) <code>estout</code> (from http://www.stata-journal.com/software/sj14-2/) running <code>make install</code> from the root of the folder will install <code>estout</code> locally, and should be run once. Portions of the code use bash scripting (<code>make</code>, <code>wget</code>, <code>head</code>, <code>tail</code>), which may require Linux or Mac OS X. The entry point for analysis is <code>analysis/Makefile</code>, which can be run by GNU Make on any Unix-like system by <pre><code>cd analysis make</code></pre> 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. <strong>Hardware</strong> The analysis takes a few minutes on a standard laptop. <strong>Description of programs</strong> Raw data are in <code>data/raw/&lt;vendor&gt;/&lt;dataset&gt;</code>. This data is saved as it has been received from the data publisher, downloaded by the respective Makefiles. Each folder has a <code>README.md</code> with data citation and license terms. Clean data are in <code>data/clean/&lt;dataset&gt;</code>. Each folder has a <code>Makefile</code> that specifies the steps of data cleaning. Analysis data are in <code>data/derived/&lt;topic&gt;</code>. Each folder has a <code>Makefile</code> that specifies the steps of sample specification, variable selection and modification. Analysis codes are in <code>analysis/</code>. A <code>Makefile</code> specifies how the .do files have to be run to reproduce the analysis. <strong>Instructions</strong> After uncompressing the replication package, change the working directory to <code>analysis/</code> and run the Makefile there. <pre><code>unzip PONE-D-20-08910.zip cd PONE-D-20-08910/analysis/ make</code></pre> <strong>List of tables and programs</strong> ------------------------- | Exhibit | File | Code | |---------|------|------| | headcount number in abstract | <code>analysis/headcount.log</code> line 60 | <code>analysis/headcount.do</code> | | Table 1 | NA | NA | | Table 2 | <code>exhibit/table2.csv</code> | <code>analysis/toplist.do</code> | | Table 3 | <code>exhibit/table3.tex</code> | <code>analysis/employment-growth.do</code> | | Table 4 | <code>exhibit/table4.csv</code> | <code>analysis/counterfactual.do</code> | | Figure 1 | <code>exhibit/fig1.eps</code> | NA | | Figure 2 | <code>exhibit/fig2.eps</code> | <code>analysis/scatter_customers_teamwork_byoccupation.do</code> | | Figure 3 | <code>exhibit/fig3.eps</code> | <code>analysis/scatterplot_validation_customer_atus.do</code> | | Figure 4 | <code>exhibit/fig4.eps</code> | <code>analysis/scatterplot_validation_teamwork_atus.do</code> | <strong>References</strong> National Center for O* NET Development. O* NET OnLine [dataset]; 2020. https://www.onetonline.org/ U S Bureau of the Census. County Business Patterns [dataset]; 2017. https://www.census.gov/data/datasets/2017/econ/cbp/2017-cbp.html SafeGraph. Patterns [dataset]; 2020. https://www.safegraph.com/covid-19-data-consortium U S Bureau of Labor Statistics. American Time Use Survey [dataset]; 2018. https://www.bls.gov/tus/#data U S Bureau of Labor Statistics. Current Employment Statistics [dataset]; 2020. https://www.bls.gov/ces/ U S Bureau of Labor Statistics. National Employment Matrix [dataset]; 2020. https://www.bls.gov/emp/tables/industry-occupation-matrix-industry.htm
description: {"references": ["National Center for O* NET Development. O* NET OnLine [dataset]; 2020. https://www.onetonline.org/", "U S Bureau of the Census. County Business Patterns [dataset]; 2017. https://www.census.gov/data/datasets/2017/econ/cbp/2017-cbp.html", "SafeGraph. Patterns [dataset]; 2020. https://www.safegraph.com/covid-19-data-consortium", "U S Bureau of Labor Statistics. American Time Use Survey [dataset]; 2018. https://www.bls.gov/tus/#data", "U S Bureau of Labor Statistics. Current Employment Statistics [dataset]; 2020. https://www.bls.gov/ces/", "U S Bureau of Labor Statistics. National Employment Matrix [dataset]; 2020. https://www.bls.gov/emp/tables/industry-occupation-matrix-industry.htm"]}