This directory contains the files needed to reproduce the tables and figures in Allegretto and Nadler, "Tipped Wage Effects on Earnings and Employment in Full-Service Restaurants" This README describes how the Stata DO files can be used to recreate the tables and figures in the paper. The DO file "master.do" will run the other DO files for you and create any subdirectories that are needed. Before running any of the DO files, first manually set the "working data" to be the directory in which these files are stored. Otherwise, the DO files will not work. Please contact Sylvia Allegretto (allegretto@berkeley.edu) with any questions. **************************************************************************************** ****************************** DATASETS ************************************************ **************************************************************************************** These datasets were saved using Stata version 13. qcewnational.dta - Nationwide-year QCEW data on private sector and restaurant sector earnings and employment qcew_restaurants_AC_quarterly_unbalanced.dta - The "All County" QCEW County-quarter sample qcew_restaurants_BC_quarterly_unbalanced.dta - The "Border county" QCEW County-quarter sample Descriptions of the variables in these datasets are below. **************************************************************************************** ****************************** DO FILES ************************************************ **************************************************************************************** - master.do runs all the following DO files, producing all the figures and log files used to create the tables and figures in the paper, except Figures 2 and 3. ********************** FIGURES - figure1.do - produces data used in Figure 1 "Employment and earnings growth: private sector, full-service (FSR) and limited-service (LSR) restaurants, 1990-2012" Saves a comma-delimited file called "figure1data.csv" that has the following columns: year - Year realavgearnq10 - Average weekly earnings in the private sector ($2013) realavgearnq7221 - Inflation adjusted average quarterly earnings in Full-service restaurants ($2013) (averaged across 4 quarters) realavgearnq7222 - Inflation adjusted average quarterly earnings in Limited-service restaurants ($2013) (averaged across 4 quarters) empq10 - Total employment in the private sector (averaged across 4 quarters) empq7221 - Total employment in Full-service restaurants (averaged across 4 quarters) empq7222 - Total employment in Limited-service restaurants (averaged across 4 quarters) - figures4_5.do - produces Figures 4 and 5 Figure 5, State minimum and tipped wages by Census division, 1990-2013 Saves figure4.eps and figure5.eps in the present directory - figure6.do - produces Figure 6 "Number of county-pairs with minimum or tipped wage differential and average absolute relative differential" Saves figure6.eps in the present directory. ********************* TABLES - table1AC.do - produces All County numbers in Table 1 "Descriptive statistics for the 'All County' and 'Border County' samples by full-service (FSR) and limited-service (LSR)" - table1BC.do - - produces Border County numbers in Table 1 "Descriptive statistics for the 'All County' and 'Border County' samples by full-service (FSR) and limited-service (LSR)" The descriptive statistics shown in Table 1 are based on the values in the comma-delimited tables and other statistics printed at the bottom of the log files produced by table1AC.do and table1BC.do. The comma-delimited tables have the following columns: variable name, mean, standard deviation, p25, p50, p75, # obs The variables in the rows are in the same order as in the paper. - table2wTW.do - produces results from models with the tipped wage in Table 2 "All County sample estimates of the tipped and minimum wage on earnings and employment, by restaurant sector" - table2noTW.do - produces results from models without the tipped wage in Table 2 "All County sample estimates of the tipped and minimum wage on earnings and employment, by restaurant sector" The results shown in Table 2 are based on the comma-delimited tables printed at the bottom of the log files produced by table2wTW.do and table2noTW.do. The models in the comma-delimited table are in the same order as in the table in the paper. - table3wTW.do - produces results from models with the tipped wage in Table 3 "Border County-Pair sample estimates of the tipped and minimum wage on earnings and employment, by restaurant sector" - table3noTW.do - produces results from models without the tipped wage in Table 3 "Border County-Pair sample estimates of the tipped and minimum wage on earnings and employment, by restaurant sector" The results shown in Table 3 are based on the comma-delimited tables printed at the bottom of the log files produced by table3wTW.do and table3noTW.do. The models in the comma-delimited table are the following: (1) Model with county and quarter effects fit on the AC sample (Model 1 in Table 2) (2) Model with county and quarter effects fit on the BC sample (Model 5 in Table 3) (3) Model with county-pairXquarter effects (no county effects) (Not shown on Table 3) (4) Model with county-pairXquarter effects + state effects (Not shown on Table 3) (5) Model with county-pairXquarter effects + county effects (Model 6 on Table 3) Coefficients and standard errors are listed in the tables for the right-hand side variables in the following order: log(tipped wage) log(minimum wage) log(county population) log(private sector employment) log(private sector earnings) ***************************************************************************** ******************** VARIABLE LABELS **************************************** ***************************************************************************** See text for description of how data was constructed and sources. ** VARIABLES IN qcewnational.dta (NATIONAL-LEVEL QCEW DATA, USED FOR FIGURE 1) unit of observation is a sector-quarter own_code - ownership (=5, for private sector) industry_code - NAICS (recoded for consistency) 10 total private sector 7221 full-service (includes 722511) 7222 limited-service (includes 722211 and 722513) agglvl_code - 2-digit aggregation level size_code - 1 digit size code year - year qtr - qtr of year (=1,2,3 or 4) qtrly_estabs_count - count of establishments month1_emplvl - employment level in 1st month of given quarter month2_emplvl - employment level in 2nd month of given quarter month3_emplvl - employment level in 3rd month of given quarter total_qtrly_wages - total wages for a given quarter avg_wkly_wage - average weekly wage for a given quarter statefips - (="US" indicating all observations at the national level) ** VARIABLES IN qcew_restaurants_AC_quarterly_unbalanced.dta (ALL COUNTY DATA) unit of observation - county-quarter countyfipsnum - county FIPS number earnq10 - average weekly earnings, total private sector empq10 - total employment, total private sector earnq7221 - average weekly earnings, full-service restaurants empq7221 - total employment, full-service restaurants earnq7222 - average weekly earnings, limited-service restaurants empq7222 - total employment, limited-service restaurants year - year state_name - state name census_div - census division 1 northeast 2 midatlantic 3 east north central 4 west north central 5 south atlantic 6 east south central 7 west south central 8 mountain 9 pacific pop - county population statefipsnum - state FIPs number empcount7221 - (county-level) number of quarters during the sample period that county has disclosed full-service restaurants employment and earnings information empcount7222 - (county-level) number of quarters during the sample period that county has disclosed limited-service restaurants employment and earnings information empcount10 - (county-level) number of quarters during the sample period that county has disclosed total private sector employment and earnings information quarterdate - quarter (in quarter-year format) logempq7221 - = log(empq7221) logempq7222 - = log(empq7222) logempq10 - = log(empq10) logearnq7221 - = log(earnq7221) logearnq7222 - = log(earnq7222) logearnq10 - = log(earnq10) logpop - = log(pop) tw - tipped wage mw - minimum wage logmw - = log(tw) logtw - = log(mw) ** VARIABLES IN qcew_restaurants_BC_quarterly_unbalanced.dta (BORDER COUNTY DATA) unit of observation - county-quarter This dataset has the same variables as qcew_restaurants_AC_quarterly_unbalanced.dta, plus: countypairnum - unique ID for each border-county pair statebordernum - unique ID for each group of counties that share the same state border (used for constructing standard errors) countypairdate - = group(countypairnum quarterdate)