clear capture clear matrix set mem 600m capture log close log using "C:\Project_DigitalMobility_Infrastructure_COVID\Log-File1.log", replace version 14.0 set more off use "C:\Project_DigitalMobility_Infrastructure_COVID\Datensatz.dta" ************Definition of Variables**************************** **kennziffer : Number of NUTS III region (Kreis or kreisfreie Stadt) **raumeinheit : Name of the NUTS III region **cases : Infected COVID-19 cases as of 5.5.2020, per NUTS III region, total **casesperpop : Infected COVID-19 cases per 1000 population as of 5.5.2020, per NUTS III region **accessibility : Average travel time from all communities of the NUTS III region by car to next agglomeration centre, in minutes **pop : Number of population, per NUTS III region, total **area : Area in square km, per NUTS III region **GDP : GDP in euros per inhabitant, per NUTS III region **medicaldoc : General practitioners per 10000 population (Allgemeinarzt), per NUTS III region **jobcommuters : Job commuters (outward) as a share to social security related employees at place of living, in percent, in NUTS III region **laboratory : Postitive Corona test results per Bundesland, in percent **age_g_65years : Share of inhabitants that are 65 and older in relation to all inhabitants, in percent **employ_t : Share of employees in tertiary sector, in percent **hotelbeds : Beds in hotel businesses (Fremdenverkehr) per 1000 inhabitants, in NUTS III region **strictpolicy : Dummy variable that is 1 if the state is Baden-Wuertemberg, Bavaria, Rhineland-Palatine, Saarland, and 0 otherwise **mobility : Percentage change of trips undertaken on Easter Sunday (12.4.2020) compared to average Sunday in April in 2019, at NUTS III level **deaths : Total number of COVID-19 deaths as of 5.5.2020, per NUTS III region **death_rate : Share of deaths in relation to infected COVID-19 cases as of 5.5.2020, per NUTS III region, in percent gen l_casesperpop=log(casesperpop) gen l_pop=log(pop) gen l_area=log(area) gen l_GDP=log(GDP) gen l_deaths=log(deaths) **************************************************************** ******************Table 1*************************************** **************************************************************** *********The Impact of Accessibility by Road Infrastructure on COVID-19 Cases in Germany *********OLS regressions regress l_casesperpop accessibility , vce(robust) regress l_casesperpop accessibility l_pop l_area l_GDP , vce(robust) regress l_casesperpop accessibility l_pop l_area l_GDP medicaldoc, vce(robust) regress l_casesperpop accessibility l_pop l_area l_GDP medicaldoc jobcommuters, vce(robust) regress l_casesperpop accessibility l_pop l_area l_GDP medicaldoc jobcommuters laboratory, vce(robust) regress l_casesperpop accessibility l_pop l_area l_GDP medicaldoc jobcommuters laboratory region_north region_northwest region_northeast region_west region_southeast , vce(robust) ***************************************************************** *******************Table 2*************************************** ***************************************************************** *********The Impact of Mobility on COVID-19 Cases in Germany *********OLS regressions regress l_casesperpop mobility, vce(robust) regress l_casesperpop mobility l_pop l_area l_GDP , vce(robust) regress l_casesperpop mobility l_pop l_area l_GDP medicaldoc, vce(robust) regress l_casesperpop mobility l_pop l_area l_GDP medicaldoc jobcommuters, vce(robust) regress l_casesperpop mobility l_pop l_area l_GDP medicaldoc jobcommuters laboratory, vce(robust) regress l_casesperpop mobility l_pop l_area l_GDP medicaldoc jobcommuters laboratory region_north region_northwest region_northeast region_west region_southeast , vce(robust) *********The Impact of Mobility on COVID-19 Cases in Germany *********IV regression and First Stage regression ivregress 2sls l_casesperpop (mobility=accessibility) l_pop l_area l_GDP medicaldoc jobcommuters laboratory region_north region_northwest region_northeast region_west region_southeast , first vce(robust) ***************************************************************** *******************Table 3*************************************** ***************************************************************** *********Robustness Checks *********The Impact of Mobility on COVID-19 Cases in Germany *********The Impact of Mobility on Deaths and Death rates due to COVID-19 in Germany *********IV regressions ivregress 2sls l_casesperpop (mobility=accessibility) l_pop l_area l_GDP medicaldoc jobcommuters laboratory age_g_65years region_north region_northwest region_northeast region_west region_southeast, first vce(robust) ivregress 2sls l_casesperpop (mobility=accessibility) l_pop l_area l_GDP medicaldoc jobcommuters laboratory age_g_65years employ_t region_north region_northwest region_northeast region_west region_southeast, first vce(robust) ivregress 2sls l_casesperpop (mobility=accessibility) l_pop l_area l_GDP medicaldoc jobcommuters laboratory age_g_65years employ_t hotelbeds region_north region_northwest region_northeast region_west region_southeast, first vce(robust) ivregress 2sls l_casesperpop (mobility=accessibility) l_pop l_area l_GDP medicaldoc jobcommuters laboratory age_g_65years employ_t hotelbeds strictpolicy region_north region_northwest region_northeast region_west region_southeast, first vce(robust) ivregress 2sls death_rate (mobility=accessibility) l_pop l_area l_GDP medicaldoc jobcommuters laboratory age_g_65years employ_t hotelbeds strictpolicy region_north region_northwest region_northeast region_west region_southeast, first vce(robust) ivregress 2sls l_deaths (mobility=accessibility) l_pop l_area l_GDP medicaldoc jobcommuters laboratory age_g_65years employ_t hotelbeds strictpolicy region_north region_northwest region_northeast region_west region_southeast, first vce(robust) ******************************************************************* *************************Table A.2********************************* ******************************************************************* ************Descriptive Statistics sum cases casesperpop mobility accessibility pop area GDP medicaldoc jobcommuters laboratory age_g_65years employ_t hotelbeds deaths death_rate ******************************************************************* *************************Table A.3********************************* ******************************************************************* ************Correlation matrix corr cases casesperpop mobility accessibility pop area GDP medicaldoc jobcommuters laboratory age_g_65years employ_t hotelbeds deaths death_rate clear log close exit