Skip to content

brycewang-stanford/Auto-Empirical-Research-Skills / skills/18-jusi-aalto-stata-accounting-research

stata-accounting-research

Unverified

STATA code pattern library for empirical archival accounting research. Provides tested syntax from 126 peer-reviewed JAR (Journal of Accounting Research) replication files (2017-2025). Use when the user asks procedural questions like "How do I implement [method]?" or "Show me code for [technique]" — including: entropy balancing, propensity score matching (PSM), difference-in-differences (DiD), regression discontinuity (RDD), instrumental variables (IV), event studies (CAR/BHAR), survival analysis, Fama-MacBeth regressions, bootstrap, quantile regression, reghdfe/xtreg/areg, clustering standard errors, fixed effects, esttab/outreg2 table formatting, winsorization, leads/lags. Users can specify their variables (e.g., treatment, outcomes, controls) and receive adapted syntax. NOTE: This skill provides code patterns from published papers, not research design advice.

FileKindSize
README-original.mdmarkdown2.9 KB
SKILL.mdskill md4.8 KB
references/JAR_55_bbcl.doother59.1 KB
references/JAR_55_chaplinksy-hanley-moon.doother46.3 KB
references/JAR_55_clm.doother95.1 KB
references/JAR_55_elw.doother58.0 KB
references/JAR_55_hlsw.doother104.1 KB
references/JAR_55_kks.doother365.5 KB
references/JAR_55_lzz.doother25.5 KB
references/JAR_55_madsen.doother307.5 KB
references/JAR_55_mr.doother41.5 KB
references/JAR_56_al.doother75.3 KB
references/JAR_56_bch.doother13.5 KB
references/JAR_56_blv.doother24.6 KB
references/JAR_56_csmw.doother27.6 KB
references/JAR_56_en.doother21.2 KB
references/JAR_56_granja.doother107.9 KB
references/JAR_56_htw.doother18.6 KB
references/JAR_56_kmt.doother5.6 KB
references/JAR_56_ksvw.doother8.0 KB
references/JAR_56_llz.doother3.1 KB
references/JAR_56_ls.doother147.5 KB
references/JAR_56_lv2018.doother123.7 KB
references/JAR_57_bht.doother24.4 KB
references/JAR_57_bl.doother22.6 KB
references/JAR_57_bw.doother263.2 KB
references/JAR_57_cct.doother347.1 KB
references/JAR_57_cgw.doother195.8 KB
references/JAR_57_hcp.doother38.0 KB
references/JAR_57_honigsberg.doother99.5 KB
references/JAR_57_lehmann.doother112.8 KB
references/JAR_57_lm.doother85.5 KB
references/JAR_58_bsz.doother36.9 KB
references/JAR_58_ckm.doother52.3 KB
references/JAR_58_eyring.doother58.1 KB
references/JAR_58_gj.doother187.5 KB
references/JAR_58_gsz.doother121.6 KB
references/JAR_58_htyz.doother30.9 KB
references/JAR_58_jansen.doother99.5 KB
references/JAR_58_joshi.doother43.0 KB
references/JAR_58_kvy.doother19.5 KB
references/JAR_58_msz.doother35.0 KB
references/JAR_58_rauter.doother433.2 KB
references/JAR_58_wy.doother64.5 KB
references/JAR_58_zz.doother125.5 KB
references/JAR_59_breuer.doother826.9 KB
references/JAR_59_ctv.doother383.7 KB
references/JAR_59_dess.doother78.4 KB
references/JAR_59_hmo.doother351.6 KB
references/JAR_60_abkp.doother129.9 KB
references/JAR_60_alv.doother35.4 KB
references/JAR_60_at.doother38.5 KB
references/JAR_60_barrios.doother119.6 KB
references/JAR_60_bbin.doother72.9 KB
references/JAR_60_bdem.doother11.6 KB
references/JAR_60_bl.doother43.5 KB
references/JAR_60_bmsw.doother7.7 KB
references/JAR_60_cc.doother20.1 KB
references/JAR_60_cpss.doother15.4 KB
references/JAR_60_cstv.doother175.3 KB
references/JAR_60_dg.doother19.9 KB
references/JAR_60_duguay.doother8.0 KB
references/JAR_60_fhl.doother71.3 KB
references/JAR_60_gls.doother37.0 KB
references/JAR_60_hmryz.doother28.6 KB
references/JAR_60_hst.doother18.3 KB
references/JAR_60_kt.doother10.4 KB
references/JAR_60_mliu.doother28.3 KB
references/JAR_60_nrwx.doother14.6 KB
references/JAR_60_ptwy.doother26.6 KB
references/JAR_60_skim.doother14.7 KB
references/JAR_61_bcdr.doother524.9 KB
references/JAR_61_bkr.doother51.6 KB
references/JAR_61_bls.doother79.2 KB
references/JAR_61_bo.doother29.7 KB
references/JAR_61_ccm.doother48.7 KB
references/JAR_61_cdss.doother3.9 KB
references/JAR_61_cfhll.doother47.1 KB
references/JAR_61_cfmp.doother12.7 KB
references/JAR_61_ckor.doother77.5 KB
references/JAR_61_cllw.doother11.2 KB
references/JAR_61_clm.doother11.0 KB
references/JAR_61_deller.doother368.9 KB
references/JAR_61_dlrtw.doother30.6 KB
references/JAR_61_dlz.doother13.6 KB
references/JAR_61_drs.doother15.8 KB
references/JAR_61_ds.doother197.5 KB
references/JAR_61_glt.doother1.9 KB
references/JAR_61_gyz.doother7.5 KB
references/JAR_61_ll.doother89.3 KB
references/JAR_61_lszz.doother15.9 KB
references/JAR_61_os.doother128.9 KB
references/JAR_61_zureich.doother22.2 KB
references/JAR_62_1_bdsy_banerjee_etal.doother6.6 KB
references/JAR_62_1_bhs_bouwens_etal.doother59.7 KB
references/JAR_62_1_gsz_gu_sun_zhou.doother46.6 KB
references/JAR_62_2_dgzz_defranco_etal.doother1.8 KB
references/JAR_62_2_gmp_grewal_etal.doother37.2 KB
references/JAR_62_2_xyz_xin_etal.doother25.3 KB
references/JAR_62_3_bht_bloomfield_etal.doother16.0 KB
references/JAR_62_3_ccz_cheynel_etal.doother23.3 KB
references/JAR_62_3_kim.doother2.6 KB
references/JAR_62_3_rr_raghunandan_ruchti.doother15.5 KB
references/JAR_62_4_bd_breuer_dehaan.doother15.3 KB
references/JAR_62_4_cc_cadman_carrizosa.doother20.1 KB
references/JAR_62_4_kmsv_kohler_etal.doother91.5 KB
references/JAR_62_4_mps_marra_etal.doother68.0 KB
references/JAR_62_4_raghunandan.doother50.0 KB
references/JAR_62_4_stv_sran_etal.doother41.1 KB
references/JAR_62_4_xu.doother49.4 KB
references/JAR_62_5_aov_abraham_etal.doother418.9 KB
references/JAR_62_5_gibbons.doother80.1 KB
references/JAR_62_5_jiang.doother114.3 KB
references/JAR_62_5_kstz_krueger_etal.doother26.7 KB
references/JAR_62_5_llz_li_lou_zhang.doother6.2 KB
references/JAR_62_5_lrst_lins_etal.doother66.2 KB
references/JAR_62_5_lswy_lin_etal.doother85.2 KB
references/JAR_62_5_lw_li_wang.doother16.6 KB
references/JAR_63_1_blmv_bastiaansen_etal.doother18.5 KB
references/JAR_63_1_cvw_chen_etal.doother61.2 KB
references/JAR_63_1_fgr_frankel_etal.doother30.3 KB
references/JAR_63_1_hrsx_huang_etal.doother35.5 KB
references/JAR_63_1_jia.doother12.0 KB
references/JAR_63_2_bcrw_bakke_etal.doother271.3 KB
references/JAR_63_2_dlr_desimone_etal.doother83.5 KB
references/JAR_63_2_mqtz_mao_etal.doother94.2 KB
references/JAR_63_2_npstv_nessa_etal.doother7.0 KB
references/JAR_63_3_breuer.doother51.4 KB
references/REFERENCES.mdmarkdown30.7 KB

references/JAR_58_ckm.do

View on GitHub
use "D:\CKM.dta", clear

/* Merge with EMMA */
encode dbkey, gen(id)
merge 1:1 dbkey audityear using "d:/new_issues_emma.dta"
gen new_issue=0
replace new_issue=1 if _merge==3
drop if _merge==2
drop _merge

/* Create lag variables */
sort dbkey1 audityear
tsset dbkey1 audityear
foreach i in 610 59 48 37 12 1121{ 
gen sum_tenure`i'_nolag = sum_tenure`i'
gen lag_sum_tenure`i'=l.sum_tenure`i'
drop sum_tenure`i'
rename lag_sum_tenure`i' sum_tenure`i'
}
foreach i in 610 59 48 37 { 
gen lag_d_death`i'=l.d_death`i'
drop d_death`i'
rename lag_d_death`i' d_death`i'
gen lag_app`i'=l.app`i'
drop app`i'
rename lag_app`i' app`i'
}
drop if missing(sum_tenure610)

/* Create First Principal Component Measures of Reporting Quality and Compliance */
gen no_mw=0 if !missing(mw)
replace no_mw=1 if (!missing(mw) & mw==0)
gen no_mao=0 if !missing(mao)
replace no_mao=1 if (!missing(mao) & mao==0)
gen no_rp=0 if !missing(rp)
replace no_rp=1 if (!missing(rp) & rp==0)
gen no_mnc=0 if !missing(mnc)
replace no_mnc=1 if (!missing(mnc) & mnc==0)
gen lag=(timing1*-1)/365
gen no_mw_rp=3
replace no_mw_rp=2 if (rp==1 & mw==0)
replace no_mw_rp=1 if (mw==1 & rp==0)
replace no_mw_rp=0 if (mw==1 & rp==1)

gen no_mw_mp=0 if !missing(mw_mp)
replace no_mw_mp=1 if (!missing(mw_mp) & mw_mp==0)
gen no_mao_mp=0 if !missing(mao_mp)
replace no_mao_mp=1 if (!missing(mao_mp) & mao_mp==0)
gen no_rp_mp=0 if !missing(rp_mp)
replace no_rp_mp=1 if (!missing(rp_mp) & rp_mp==0)
gen no_mw_rp_mp=0
replace no_mw_rp_mp=-1 if no_rp_mp==0
replace no_mw_rp_mp=-2 if no_mw_mp==0
replace no_mw_rp_mp=-3 if (no_mw_mp==0 & no_rp_mp==0)

/* Scale Main Independent Variables by 100 */
foreach i in sum_tenure610 sum_tenure59 sum_tenure48 sum_tenure37 sum_tenure12 sum_tenure1121 sum_tenure610_nolag sum_tenure59_nolag sum_tenure48_nolag sum_tenure37_nolag{ 
replace `i'=`i'/100
}

/* PCA */
pca no_mw no_mao no_rp no_mnc lag, components(1)
predict pc1_finrep, score

pca no_mw_mp no_mao_mp no_rp_mp, components(1)
predict pc1_mp, score

sort dbkey1 audityear
tsset dbkey1 audityear

foreach i in pc1_finrep{
by dbkey1: gen lag_pc1_finrep  = pc1_finrep[_n-1] if audityear == audityear[_n-1] +1
by dbkey1: gen lag2_pc1_finrep = pc1_finrep[_n-2] if audityear == audityear[_n-2] +2
by dbkey1: gen lag3_pc1_finrep = pc1_finrep[_n-3] if audityear == audityear[_n-3] +3
by dbkey1: gen lag4_pc1_finrep = pc1_finrep[_n-4] if audityear == audityear[_n-4] +4
}
gen sum_pc1_finrep = lag_pc1_finrep + lag2_pc1_finrep + lag3_pc1_finrep + lag4_pc1_finrep
xtile pc1_finrep_rank = sum_pc1_finrep, nq(4)
gen low_finrep=1 if pc1_finrep_rank ==1
replace low_finrep=0 if missing(low_finrep)
foreach i in 610 59 48 37{ 
gen sum_tenure`i'_low_finrep=sum_tenure`i'_nolag*low_finrep
}
gen lead_fin=f.pc1_finrep
gen simplesum = no_mao + no_mw + no_rp + no_mnc + lag

/* Make lrisk Increase in Opacity */
gen hrisk=0
replace hrisk=1 if lrisk==0
foreach i in 610 59 48 37{ 
gen sum_tenure`i'_lrisk=sum_tenure`i'*lrisk
}

/* Size */
xtile size=population, nq(4)
gen small=0 
replace small=1 if size==1
replace small=1 if missing(size)
foreach i in 610 59 48 37{ 
gen sum_tenure`i'_small=sum_tenure`i'*small
}

/* Bing */
replace valid_articles = 0 if missing(valid_articles)
gen n_bing = -valid_articles

sort dbkey
by dbkey: egen avg_bing2 = mean(n_bing)
sort audityear
by audityear: egen avg_bing3 = mean(n_bing)
gen n_bing1 = (n_bing - avg_bing2 - avg_bing3)

/* Bond-Market Participants as Monitor */
foreach i in 610 59 48 37{ 
gen sum_tenure`i'_new_issue=sum_tenure`i'*new_issue
}

/* Independent Auditor as Monitors */
gen indep_audit=0
replace indep_audit=1 if state_audit==0
foreach i in 610 59 48 37{ 
gen sum_tenure`i'_indep_audit=sum_tenure`i'*indep_audit
}

/* Media as Monitors */
gen news = (newspaper / population_st) * 1000
xtile xtile_news=news, nq(4)
gen high_news = 0
replace high_news = 1 if xtile_news >=4
foreach i in 610 59 48 37{ 
gen sum_tenure`i'_news=sum_tenure`i'*high_news
}

/* Stewardship for Reputation Building */
xtile lag_fin_rank= lag_pc1_finrep, nq(4) 
xtile lead_fin_rank= lead_fin, nq(4) 
gen reputation = 0
replace reputation = 1 if lag_fin_rank <=2 & lead_fin_rank >=3
foreach i in 610 59 48 37 {
gen d_death`i'_reputation = d_death`i' * reputation
}

/* Favor - Partisan */
gen favor = 0
replace favor = 1 if n_democrat1 >=2 & d_democrat ==1
replace favor = 1 if n_democrat1 ==0 & d_republican ==1
foreach i in 610 59 48 37{
gen sum_tenure`i'_favor = sum_tenure`i'*favor
}

/* Favor - Hometown */
gen dist = min(dist1, dist2)
gen d_dist = 0
replace d_dist = 1 if dist <= 25
foreach i in 610 59 48 37{
gen sum_tenure`i'_dist = sum_tenure`i'*d_dist
}

/* Appropriation */
foreach i in 610 59 48 37{
egen app`i'_rank = xtile(app`i'), by(audityear) nq(4)
gen d_app`i' = 1 if app`i'_rank >= 4
replace d_app`i' = 0 if missing(d_app`i')
gen sum_tenure`i'_app = sum_tenure`i'*d_app`i'
}

/* Court */
gen court= (sum_totcase/1000)  /* time-invariant */
gen courti= (totcase/1000)  /* time-varying */

xtile xtile_court=court, nq(4)
gen low_court=0 if !missing(xtile_court)
replace low_court=1 if xtile_court==1 & !missing(xtile_court)

xtile xtile_courti=courti, nq(4)
gen low_courti=0 if !missing(xtile_courti)
replace low_courti=1 if xtile_courti==1 & !missing(xtile_courti)

foreach i in 610 59 48 37{ 
gen sum_tenure`i'_court=sum_tenure`i'*low_court
gen sum_tenure`i'_courti=sum_tenure`i'*low_courti
}

/* DOJ */
gen doj= sum_doj1  /* time-invariant */
gen doji= doj1  /* time-variant */

xtile xtile_doj=doj, nq(4)
gen low_doj=0 if !missing(xtile_doj)
replace low_doj=1 if xtile_doj==1 & !missing(xtile_doj)

xtile xtile_doji=doji, nq(4)
gen low_doji=0 if !missing(xtile_doji)
replace low_doji=1 if xtile_doji==1 & !missing(xtile_doji)

foreach i in 610 59 48 37{ 
gen sum_tenure`i'_doj=sum_tenure`i'*low_doj
gen sum_tenure`i'_doji=sum_tenure`i'*low_doji
}

/* Margin */
foreach i in 610 59 48 37{
gen sum_tenure`i'_margin1 = sum_tenure`i' * margin1
}

/* Alternative Congressional Representation */
foreach i in 6 5 4 3 {
gen senate_dtenure`i' = sum_dtenure`i'*democrat_r
replace senate_dtenure`i' = 0 if missing(senate_dtenure`i')
gen senate_rtenure`i' = sum_rtenure`i'*republican_r
replace senate_rtenure`i' = 0 if missing(senate_rtenure`i')
gen senate_tenure`i' = senate_dtenure`i' + senate_rtenure`i'
}
foreach i in 10 9 8 7 {
gen house_dtenure`i' = sum_dtenure`i'*democrat_district
replace house_dtenure`i' = 0 if missing(house_dtenure`i')
gen house_rtenure`i' = sum_rtenure`i'*republican_district
replace house_rtenure`i' = 0 if missing(house_rtenure`i')
gen house_tenure`i' = house_dtenure`i' + house_rtenure`i'
}
gen alt_tenure610 = (senate_tenure6 + house_tenure10)/100
gen alt_tenure59 = (senate_tenure5 + house_tenure9)/100
gen alt_tenure48 = (senate_tenure4 + house_tenure8)/100
gen alt_tenure37 = (senate_tenure3 + house_tenure7)/100

*************Main Paper*************

*Table 1 - Descriptive Statistics
tabstat pc1_finrep no_mao no_mw no_rp no_mnc lag sum_tenure610 sum_tenure59 sum_tenure48 sum_tenure37 d_death610 d_death59 d_death48 d_death37 new_issue lexp lm_subsidy, statistics(n mean sd p25 p50 p75) columns(statistics)
tabstat court doj small margin1, statistics(n mean sd p25 p50 p75) columns(statistics)

estpost correlate pc1_finrep no_mao no_mw no_rp no_mnc lag sum_tenure37 sum_tenure48 sum_tenure59 sum_tenure610, matrix

*Table 2 - Local Stewardship, by State
sort statename
by statename: tabstat pc1_finrep, statistics(n mean) columns(statistics)

*Table 3 - Main Result
global control "new_issue lexp lm_subsidy d_subsidy"
foreach j in pc1_finrep{
foreach i in 610 59 48 37 { 
	qui areg `j' sum_tenure`i' $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 4 - Death
foreach j in pc1_finrep{
foreach i in d_death610 d_death59 d_death48 d_death37 { 
	qui areg `j' `i' $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 5 - Misappropriation or Ineptitude
foreach j in pc1_finrep {
foreach i in 59 37 {
	qui areg `j' sum_tenure`i' sum_tenure`i'_court $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_court ==0
	qui areg `j' sum_tenure`i' sum_tenure`i'_doj $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_doj ==0
}
}
foreach j in pc1_finrep {
foreach i in 610 59 48 37  { 
	qui areg `j' sum_tenure`i' sum_tenure`i'_small small $control i.audityear, absorb(id) vce(cluster stcd)  
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_small =0
}
}
*Table 6 - Political Competition
foreach j in pc1_finrep{
foreach i in 610 59 48 37{
	qui areg `j' sum_tenure`i' sum_tenure`i'_margin1 margin1 $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_margin1 = 0
}
}

*************Online Appendix*************

*Table 1 - Components
foreach j in no_mao no_mw no_rp no_mnc lag {
foreach i in 59 37 { 
	qui areg `j' sum_tenure`i' $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 2 - Simple Sum
estpost correlate simplesum pc1_finrep no_mao no_mw no_rp no_mnc lag sum_tenure37 sum_tenure48 sum_tenure59 sum_tenure610, matrix
foreach j in simplesum{
foreach i in 610 59 48 37 { 
	qui areg `j' sum_tenure`i' $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 3 - Compliance 
foreach j in pc1_mp {
foreach i in 610 59 48 37 { 
	qui areg `j' sum_tenure`i' $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 4 - News Search-based
estpost correlate n_bing1 pc1_finrep no_mao no_mw no_rp no_mnc lag sum_tenure37 sum_tenure48 sum_tenure59 sum_tenure610, matrix
foreach j in n_bing {
foreach i in 610 59 48 37 { 
	qui areg `j' sum_tenure`i' $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 5 - Alternative congressional representation
foreach j in pc1_finrep {
foreach i in 610 59 48 37 { 
	qui areg `j' p75_tenure`i' $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 6 - Falsification non-top 10 committees
gen sum_exten = sum_tenure1121 - sum_tenure37
foreach j in pc1_finrep {
foreach i in sum_exten { 
	qui areg `j' `i' $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 10 - Instrumented
foreach i in 610 59 48 37 {
	qui reghdfe pc1_finrep  $control i.audityear (sum_tenure`i'=d_death`i'), keepsin absorb(id) cluster(stcd)
	est tab, drop(d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
*Table 11 - Corruption (time-varying)
foreach j in pc1_finrep {
foreach i in 59 37 {
	qui areg `j' sum_tenure`i' sum_tenure`i'_courti low_courti $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_courti ==0
	qui areg `j' sum_tenure`i' sum_tenure`i'_doji low_doji $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_doji ==0
}
}
*Table 12 - DOJ enforcements
foreach j in doji {
foreach i in 610 59 48 37 {
	qui areg `j' sum_tenure`i' sum_tenure`i'_low_finrep low_finrep $control i.audityear, absorb(id) vce(cluster stcd)    
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 13 - Measuring congressional representation based on party affiliation
foreach j in pc1_finrep {
foreach i in 610 59 48 37 { 
	qui areg `j' alt_tenure`i' $control i.audityear if missing(ranney)==0, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}

*Table 14 - Favoritism
foreach j in lexp {
foreach i in 610 59 48 37 { 
	qui areg `j' sum_tenure`i' sum_tenure`i'_favor favor new_issue i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_favor =0
}
}
foreach j in lexp {
foreach i in 610 59 48 37 {
	qui areg `j' sum_tenure`i' sum_tenure`i'_dist d_dist new_issue i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_dist==0
}
}
*Table 15 - Stewardship for reputation building
foreach j in lexp {
foreach i in d_death610 d_death59 d_death48 d_death37 { 
	qui areg `j' `i' `i'_reputation reputation new_issue i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test `i'+`i'_reputation = 0
}
}
*Table 16 - Bondholder as a monitor
foreach j in pc1_finrep {
foreach i in sum_tenure610 sum_tenure59 sum_tenure48 sum_tenure37 { 
	qui areg `j' `i' `i'_new_issue $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test `i'+`i'_new_issue=0
}
}
*Table 17 - Independent auditor as a monitor
foreach j in pc1_finrep {
foreach i in sum_tenure610 sum_tenure59 sum_tenure48 sum_tenure37 { 
	qui areg `j' `i' `i'_indep_audit indep_audit $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test `i'+`i'_indep_audit=0
}
}
*Table 18 -  Media as a monitor
foreach j in pc1_finrep {
foreach i in 610 59 48 37 {
	qui areg `j' sum_tenure`i' sum_tenure`i'_news $control i.audityear, absorb(id) vce(cluster stcd)    
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_news = 0
}
}
*Table 19 - Auditor effort
foreach j in pc1_finrep {
foreach i in sum_tenure610 sum_tenure59 sum_tenure48 sum_tenure37 { 
	qui areg `j' `i' `i'_lrisk lrisk $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test `i'+`i'_lrisk=0
}
}
*Table 20 - Appropriation
foreach j in pc1_finrep {
foreach i in 610 59 48 37 { 
	qui areg `j' sum_tenure`i' sum_tenure`i'_app d_app`i' $control i.audityear, absorb(id) vce(cluster stcd)  
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 21 - Exclude 12 largest states
gen large12 = 0
replace large12 = 1 if inlist(statename,"CA","FA","GA","IL","MI","NC")
replace large12 = 1 if inlist(statename,"NJ","NY","OH","PA","TX","VA")
foreach j in pc1_finrep {
foreach i in 610 59 48 37 {
	qui areg `j' sum_tenure`i' $control i.audityear if large12 ==0, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 22 - State-by-year fixed effects
foreach j in pc1_finrep {
foreach i in 610 59 48 37 { 
	reg2hdfe `j' sum_tenure`i' $control , id1(id) id2(styr) cluster (stcd)
}
}
*Table 23 - Including interactions
foreach j in pc1_finrep{
foreach i in 610 59 48 37{
	qui areg `j' sum_tenure`i' sum_tenure`i'_margin1 sum_tenure`i'_court sum_tenure`i'_doj sum_tenure`i'_small margin1 $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_margin1 = 0
}
}
use "D:\CKM_local.dta", clear

*Scale independent variables by 100
foreach i in sum_tenure610 sum_tenure59 sum_tenure48 sum_tenure37 { 
replace `i'=`i'/100
}
*Table 7 - Local Elections and Stewardship
tabstat lead_rvotes pc1_finrep_lag sum_tenure610 sum_tenure59 sum_tenure48 sum_tenure37 lexp lm_subsidy margin1 lincome_cty ue_cty edu, statistics(n mean sd p25 p50 p75) columns(statistics)
global control "lexp lm_subsidy margin1 lincome_cty ue_cty edu d_subsidy "
foreach j in  lead_rvotes {
foreach i in 610 { 
	qui reg `j' pc1_finrep_lag $control i.year1, vce(robust)
	est tab, drop(_cons d_subsidy i.year1)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
foreach j in  lead_rvotes {
foreach i in 610 59 48 37 { 
	qui reg `j' pc1_finrep_lag sum_tenure`i' $control i.year1, vce(robust)
	est tab, drop(_cons d_subsidy i.year1)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}

use "D:\CKM_congress.dta", clear

/* Scale independent variables by 100 */
foreach i in sum_tenure10 sum_tenure5 sum_tenure3 sum_tenure1 { 
replace `i'=`i'/100
}

*Table 8 - Congressional Elections and Stewardship
tabstat lead_rvotes pc1_finrep_lag sum_tenure1 sum_tenure3 sum_tenure5 sum_tenure10 lexp lm_subsidy margin1 lincome_cty ue_cty edu, statistics(n mean sd p25 p50 p75) columns(statistics)
global control "lexp lm_subsidy margin1 lincome_cty ue_cty edu d_subsidy "
foreach j in lead_rvotes {
foreach i in 1 { 
	qui reg `j' pc1_finrep_lag $control i.year1, vce(robust)
	est tab, drop(_cons d_subsidy i.year1)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
foreach j in lead_rvotes {
foreach i in 1 3 5 10{ 
	qui reg `j' pc1_finrep_lag sum_tenure`i' $control i.year1, vce(robust)
	est tab, drop(_cons d_subsidy i.year1)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}

use "D:\CKM.dta", clear

/* Merge with EMMA */
encode dbkey, gen(id)
merge 1:1 dbkey audityear using "d:/new_issues_emma.dta"
gen new_issue=0
replace new_issue=1 if _merge==3
drop if _merge==2
drop _merge

/* Create lag variables */
sort dbkey1 audityear
tsset dbkey1 audityear
foreach i in 610 59 48 37 12 1121{ 
gen sum_tenure`i'_nolag = sum_tenure`i'
gen lag_sum_tenure`i'=l.sum_tenure`i'
drop sum_tenure`i'
rename lag_sum_tenure`i' sum_tenure`i'
}
foreach i in 610 59 48 37 { 
gen lag_d_death`i'=l.d_death`i'
drop d_death`i'
rename lag_d_death`i' d_death`i'
gen lag_app`i'=l.app`i'
drop app`i'
rename lag_app`i' app`i'
}
drop if missing(sum_tenure610)

/* Create First Principal Component Measures of Reporting Quality and Compliance */
gen no_mw=0 if !missing(mw)
replace no_mw=1 if (!missing(mw) & mw==0)
gen no_mao=0 if !missing(mao)
replace no_mao=1 if (!missing(mao) & mao==0)
gen no_rp=0 if !missing(rp)
replace no_rp=1 if (!missing(rp) & rp==0)
gen no_mnc=0 if !missing(mnc)
replace no_mnc=1 if (!missing(mnc) & mnc==0)
gen lag=(timing1*-1)/365
gen no_mw_rp=3
replace no_mw_rp=2 if (rp==1 & mw==0)
replace no_mw_rp=1 if (mw==1 & rp==0)
replace no_mw_rp=0 if (mw==1 & rp==1)

gen no_mw_mp=0 if !missing(mw_mp)
replace no_mw_mp=1 if (!missing(mw_mp) & mw_mp==0)
gen no_mao_mp=0 if !missing(mao_mp)
replace no_mao_mp=1 if (!missing(mao_mp) & mao_mp==0)
gen no_rp_mp=0 if !missing(rp_mp)
replace no_rp_mp=1 if (!missing(rp_mp) & rp_mp==0)
gen no_mw_rp_mp=0
replace no_mw_rp_mp=-1 if no_rp_mp==0
replace no_mw_rp_mp=-2 if no_mw_mp==0
replace no_mw_rp_mp=-3 if (no_mw_mp==0 & no_rp_mp==0)

/* Scale Main Independent Variables by 100 */
foreach i in sum_tenure610 sum_tenure59 sum_tenure48 sum_tenure37 sum_tenure12 sum_tenure1121 sum_tenure610_nolag sum_tenure59_nolag sum_tenure48_nolag sum_tenure37_nolag{ 
replace `i'=`i'/100
}

/* PCA */
pca no_mw no_mao no_rp no_mnc lag, components(1)
predict pc1_finrep, score

pca no_mw_mp no_mao_mp no_rp_mp, components(1)
predict pc1_mp, score

sort dbkey1 audityear
tsset dbkey1 audityear

foreach i in pc1_finrep{
by dbkey1: gen lag_pc1_finrep  = pc1_finrep[_n-1] if audityear == audityear[_n-1] +1
by dbkey1: gen lag2_pc1_finrep = pc1_finrep[_n-2] if audityear == audityear[_n-2] +2
by dbkey1: gen lag3_pc1_finrep = pc1_finrep[_n-3] if audityear == audityear[_n-3] +3
by dbkey1: gen lag4_pc1_finrep = pc1_finrep[_n-4] if audityear == audityear[_n-4] +4
}
gen sum_pc1_finrep = lag_pc1_finrep + lag2_pc1_finrep + lag3_pc1_finrep + lag4_pc1_finrep
xtile pc1_finrep_rank = sum_pc1_finrep, nq(4)
gen low_finrep=1 if pc1_finrep_rank ==1
replace low_finrep=0 if missing(low_finrep)
foreach i in 610 59 48 37{ 
gen sum_tenure`i'_low_finrep=sum_tenure`i'_nolag*low_finrep
}
gen lead_fin=f.pc1_finrep
gen simplesum = no_mao + no_mw + no_rp + no_mnc + lag

/* Make lrisk Increase in Opacity */
gen hrisk=0
replace hrisk=1 if lrisk==0
foreach i in 610 59 48 37{ 
gen sum_tenure`i'_lrisk=sum_tenure`i'*lrisk
}

/* Size */
xtile size=population, nq(4)
gen small=0 
replace small=1 if size==1
replace small=1 if missing(size)
foreach i in 610 59 48 37{ 
gen sum_tenure`i'_small=sum_tenure`i'*small
}

/* Bing */
replace valid_articles = 0 if missing(valid_articles)
gen n_bing = -valid_articles

sort dbkey
by dbkey: egen avg_bing2 = mean(n_bing)
sort audityear
by audityear: egen avg_bing3 = mean(n_bing)
gen n_bing1 = (n_bing - avg_bing2 - avg_bing3)

/* Bond-Market Participants as Monitor */
foreach i in 610 59 48 37{ 
gen sum_tenure`i'_new_issue=sum_tenure`i'*new_issue
}

/* Independent Auditor as Monitors */
gen indep_audit=0
replace indep_audit=1 if state_audit==0
foreach i in 610 59 48 37{ 
gen sum_tenure`i'_indep_audit=sum_tenure`i'*indep_audit
}

/* Media as Monitors */
gen news = (newspaper / population_st) * 1000
xtile xtile_news=news, nq(4)
gen high_news = 0
replace high_news = 1 if xtile_news >=4
foreach i in 610 59 48 37{ 
gen sum_tenure`i'_news=sum_tenure`i'*high_news
}

/* Stewardship for Reputation Building */
xtile lag_fin_rank= lag_pc1_finrep, nq(4) 
xtile lead_fin_rank= lead_fin, nq(4) 
gen reputation = 0
replace reputation = 1 if lag_fin_rank <=2 & lead_fin_rank >=3
foreach i in 610 59 48 37 {
gen d_death`i'_reputation = d_death`i' * reputation
}

/* Favor - Partisan */
gen favor = 0
replace favor = 1 if n_democrat1 >=2 & d_democrat ==1
replace favor = 1 if n_democrat1 ==0 & d_republican ==1
foreach i in 610 59 48 37{
gen sum_tenure`i'_favor = sum_tenure`i'*favor
}

/* Favor - Hometown */
gen dist = min(dist1, dist2)
gen d_dist = 0
replace d_dist = 1 if dist <= 25
foreach i in 610 59 48 37{
gen sum_tenure`i'_dist = sum_tenure`i'*d_dist
}

/* Appropriation */
foreach i in 610 59 48 37{
egen app`i'_rank = xtile(app`i'), by(audityear) nq(4)
gen d_app`i' = 1 if app`i'_rank >= 4
replace d_app`i' = 0 if missing(d_app`i')
gen sum_tenure`i'_app = sum_tenure`i'*d_app`i'
}

/* Court */
gen court= (sum_totcase/1000)  /* time-invariant */
gen courti= (totcase/1000)  /* time-varying */

xtile xtile_court=court, nq(4)
gen low_court=0 if !missing(xtile_court)
replace low_court=1 if xtile_court==1 & !missing(xtile_court)

xtile xtile_courti=courti, nq(4)
gen low_courti=0 if !missing(xtile_courti)
replace low_courti=1 if xtile_courti==1 & !missing(xtile_courti)

foreach i in 610 59 48 37{ 
gen sum_tenure`i'_court=sum_tenure`i'*low_court
gen sum_tenure`i'_courti=sum_tenure`i'*low_courti
}

/* DOJ */
gen doj= sum_doj1  /* time-invariant */
gen doji= doj1  /* time-variant */

xtile xtile_doj=doj, nq(4)
gen low_doj=0 if !missing(xtile_doj)
replace low_doj=1 if xtile_doj==1 & !missing(xtile_doj)

xtile xtile_doji=doji, nq(4)
gen low_doji=0 if !missing(xtile_doji)
replace low_doji=1 if xtile_doji==1 & !missing(xtile_doji)

foreach i in 610 59 48 37{ 
gen sum_tenure`i'_doj=sum_tenure`i'*low_doj
gen sum_tenure`i'_doji=sum_tenure`i'*low_doji
}

/* Margin */
foreach i in 610 59 48 37{
gen sum_tenure`i'_margin1 = sum_tenure`i' * margin1
}

/* Alternative Congressional Representation */
foreach i in 6 5 4 3 {
gen senate_dtenure`i' = sum_dtenure`i'*democrat_r
replace senate_dtenure`i' = 0 if missing(senate_dtenure`i')
gen senate_rtenure`i' = sum_rtenure`i'*republican_r
replace senate_rtenure`i' = 0 if missing(senate_rtenure`i')
gen senate_tenure`i' = senate_dtenure`i' + senate_rtenure`i'
}
foreach i in 10 9 8 7 {
gen house_dtenure`i' = sum_dtenure`i'*democrat_district
replace house_dtenure`i' = 0 if missing(house_dtenure`i')
gen house_rtenure`i' = sum_rtenure`i'*republican_district
replace house_rtenure`i' = 0 if missing(house_rtenure`i')
gen house_tenure`i' = house_dtenure`i' + house_rtenure`i'
}
gen alt_tenure610 = (senate_tenure6 + house_tenure10)/100
gen alt_tenure59 = (senate_tenure5 + house_tenure9)/100
gen alt_tenure48 = (senate_tenure4 + house_tenure8)/100
gen alt_tenure37 = (senate_tenure3 + house_tenure7)/100

*************Main Paper*************

*Table 1 - Descriptive Statistics
tabstat pc1_finrep no_mao no_mw no_rp no_mnc lag sum_tenure610 sum_tenure59 sum_tenure48 sum_tenure37 d_death610 d_death59 d_death48 d_death37 new_issue lexp lm_subsidy, statistics(n mean sd p25 p50 p75) columns(statistics)
tabstat court doj small margin1, statistics(n mean sd p25 p50 p75) columns(statistics)

estpost correlate pc1_finrep no_mao no_mw no_rp no_mnc lag sum_tenure37 sum_tenure48 sum_tenure59 sum_tenure610, matrix

*Table 2 - Local Stewardship, by State
sort statename
by statename: tabstat pc1_finrep, statistics(n mean) columns(statistics)

*Table 3 - Main Result
global control "new_issue lexp lm_subsidy d_subsidy"
foreach j in pc1_finrep{
foreach i in 610 59 48 37 { 
	qui areg `j' sum_tenure`i' $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 4 - Death
foreach j in pc1_finrep{
foreach i in d_death610 d_death59 d_death48 d_death37 { 
	qui areg `j' `i' $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 5 - Misappropriation or Ineptitude
foreach j in pc1_finrep {
foreach i in 59 37 {
	qui areg `j' sum_tenure`i' sum_tenure`i'_court $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_court ==0
	qui areg `j' sum_tenure`i' sum_tenure`i'_doj $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_doj ==0
}
}
foreach j in pc1_finrep {
foreach i in 610 59 48 37  { 
	qui areg `j' sum_tenure`i' sum_tenure`i'_small small $control i.audityear, absorb(id) vce(cluster stcd)  
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_small =0
}
}
*Table 6 - Political Competition
foreach j in pc1_finrep{
foreach i in 610 59 48 37{
	qui areg `j' sum_tenure`i' sum_tenure`i'_margin1 margin1 $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_margin1 = 0
}
}

*************Online Appendix*************

*Table 1 - Components
foreach j in no_mao no_mw no_rp no_mnc lag {
foreach i in 59 37 { 
	qui areg `j' sum_tenure`i' $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 2 - Simple Sum
estpost correlate simplesum pc1_finrep no_mao no_mw no_rp no_mnc lag sum_tenure37 sum_tenure48 sum_tenure59 sum_tenure610, matrix
foreach j in simplesum{
foreach i in 610 59 48 37 { 
	qui areg `j' sum_tenure`i' $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 3 - Compliance 
foreach j in pc1_mp {
foreach i in 610 59 48 37 { 
	qui areg `j' sum_tenure`i' $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 4 - News Search-based
estpost correlate n_bing1 pc1_finrep no_mao no_mw no_rp no_mnc lag sum_tenure37 sum_tenure48 sum_tenure59 sum_tenure610, matrix
foreach j in n_bing {
foreach i in 610 59 48 37 { 
	qui areg `j' sum_tenure`i' $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 5 - Alternative congressional representation
foreach j in pc1_finrep {
foreach i in 610 59 48 37 { 
	qui areg `j' p75_tenure`i' $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 6 - Falsification non-top 10 committees
gen sum_exten = sum_tenure1121 - sum_tenure37
foreach j in pc1_finrep {
foreach i in sum_exten { 
	qui areg `j' `i' $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 10 - Instrumented
foreach i in 610 59 48 37 {
	qui reghdfe pc1_finrep  $control i.audityear (sum_tenure`i'=d_death`i'), keepsin absorb(id) cluster(stcd)
	est tab, drop(d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
*Table 11 - Corruption (time-varying)
foreach j in pc1_finrep {
foreach i in 59 37 {
	qui areg `j' sum_tenure`i' sum_tenure`i'_courti low_courti $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_courti ==0
	qui areg `j' sum_tenure`i' sum_tenure`i'_doji low_doji $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_doji ==0
}
}
*Table 12 - DOJ enforcements
foreach j in doji {
foreach i in 610 59 48 37 {
	qui areg `j' sum_tenure`i' sum_tenure`i'_low_finrep low_finrep $control i.audityear, absorb(id) vce(cluster stcd)    
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 13 - Measuring congressional representation based on party affiliation
foreach j in pc1_finrep {
foreach i in 610 59 48 37 { 
	qui areg `j' alt_tenure`i' $control i.audityear if missing(ranney)==0, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}

*Table 14 - Favoritism
foreach j in lexp {
foreach i in 610 59 48 37 { 
	qui areg `j' sum_tenure`i' sum_tenure`i'_favor favor new_issue i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_favor =0
}
}
foreach j in lexp {
foreach i in 610 59 48 37 {
	qui areg `j' sum_tenure`i' sum_tenure`i'_dist d_dist new_issue i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_dist==0
}
}
*Table 15 - Stewardship for reputation building
foreach j in lexp {
foreach i in d_death610 d_death59 d_death48 d_death37 { 
	qui areg `j' `i' `i'_reputation reputation new_issue i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test `i'+`i'_reputation = 0
}
}
*Table 16 - Bondholder as a monitor
foreach j in pc1_finrep {
foreach i in sum_tenure610 sum_tenure59 sum_tenure48 sum_tenure37 { 
	qui areg `j' `i' `i'_new_issue $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test `i'+`i'_new_issue=0
}
}
*Table 17 - Independent auditor as a monitor
foreach j in pc1_finrep {
foreach i in sum_tenure610 sum_tenure59 sum_tenure48 sum_tenure37 { 
	qui areg `j' `i' `i'_indep_audit indep_audit $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test `i'+`i'_indep_audit=0
}
}
*Table 18 -  Media as a monitor
foreach j in pc1_finrep {
foreach i in 610 59 48 37 {
	qui areg `j' sum_tenure`i' sum_tenure`i'_news $control i.audityear, absorb(id) vce(cluster stcd)    
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_news = 0
}
}
*Table 19 - Auditor effort
foreach j in pc1_finrep {
foreach i in sum_tenure610 sum_tenure59 sum_tenure48 sum_tenure37 { 
	qui areg `j' `i' `i'_lrisk lrisk $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test `i'+`i'_lrisk=0
}
}
*Table 20 - Appropriation
foreach j in pc1_finrep {
foreach i in 610 59 48 37 { 
	qui areg `j' sum_tenure`i' sum_tenure`i'_app d_app`i' $control i.audityear, absorb(id) vce(cluster stcd)  
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 21 - Exclude 12 largest states
gen large12 = 0
replace large12 = 1 if inlist(statename,"CA","FA","GA","IL","MI","NC")
replace large12 = 1 if inlist(statename,"NJ","NY","OH","PA","TX","VA")
foreach j in pc1_finrep {
foreach i in 610 59 48 37 {
	qui areg `j' sum_tenure`i' $control i.audityear if large12 ==0, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 22 - State-by-year fixed effects
foreach j in pc1_finrep {
foreach i in 610 59 48 37 { 
	reg2hdfe `j' sum_tenure`i' $control , id1(id) id2(styr) cluster (stcd)
}
}
*Table 23 - Including interactions
foreach j in pc1_finrep{
foreach i in 610 59 48 37{
	qui areg `j' sum_tenure`i' sum_tenure`i'_margin1 sum_tenure`i'_court sum_tenure`i'_doj sum_tenure`i'_small margin1 $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_margin1 = 0
}
}
use "D:\CKM_local.dta", clear

*Scale independent variables by 100
foreach i in sum_tenure610 sum_tenure59 sum_tenure48 sum_tenure37 { 
replace `i'=`i'/100
}
*Table 7 - Local Elections and Stewardship
tabstat lead_rvotes pc1_finrep_lag sum_tenure610 sum_tenure59 sum_tenure48 sum_tenure37 lexp lm_subsidy margin1 lincome_cty ue_cty edu, statistics(n mean sd p25 p50 p75) columns(statistics)
global control "lexp lm_subsidy margin1 lincome_cty ue_cty edu d_subsidy "
foreach j in  lead_rvotes {
foreach i in 610 { 
	qui reg `j' pc1_finrep_lag $control i.year1, vce(robust)
	est tab, drop(_cons d_subsidy i.year1)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
foreach j in  lead_rvotes {
foreach i in 610 59 48 37 { 
	qui reg `j' pc1_finrep_lag sum_tenure`i' $control i.year1, vce(robust)
	est tab, drop(_cons d_subsidy i.year1)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}

use "D:\CKM_congress.dta", clear

/* Scale independent variables by 100 */
foreach i in sum_tenure10 sum_tenure5 sum_tenure3 sum_tenure1 { 
replace `i'=`i'/100
}

*Table 8 - Congressional Elections and Stewardship
tabstat lead_rvotes pc1_finrep_lag sum_tenure1 sum_tenure3 sum_tenure5 sum_tenure10 lexp lm_subsidy margin1 lincome_cty ue_cty edu, statistics(n mean sd p25 p50 p75) columns(statistics)
global control "lexp lm_subsidy margin1 lincome_cty ue_cty edu d_subsidy "
foreach j in lead_rvotes {
foreach i in 1 { 
	qui reg `j' pc1_finrep_lag $control i.year1, vce(robust)
	est tab, drop(_cons d_subsidy i.year1)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
foreach j in lead_rvotes {
foreach i in 1 3 5 10{ 
	qui reg `j' pc1_finrep_lag sum_tenure`i' $control i.year1, vce(robust)
	est tab, drop(_cons d_subsidy i.year1)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}

use "D:\CKM.dta", clear

/* Merge with EMMA */
encode dbkey, gen(id)
merge 1:1 dbkey audityear using "d:/new_issues_emma.dta"
gen new_issue=0
replace new_issue=1 if _merge==3
drop if _merge==2
drop _merge

/* Create lag variables */
sort dbkey1 audityear
tsset dbkey1 audityear
foreach i in 610 59 48 37 12 1121{ 
gen sum_tenure`i'_nolag = sum_tenure`i'
gen lag_sum_tenure`i'=l.sum_tenure`i'
drop sum_tenure`i'
rename lag_sum_tenure`i' sum_tenure`i'
}
foreach i in 610 59 48 37 { 
gen lag_d_death`i'=l.d_death`i'
drop d_death`i'
rename lag_d_death`i' d_death`i'
gen lag_app`i'=l.app`i'
drop app`i'
rename lag_app`i' app`i'
}
drop if missing(sum_tenure610)

/* Create First Principal Component Measures of Reporting Quality and Compliance */
gen no_mw=0 if !missing(mw)
replace no_mw=1 if (!missing(mw) & mw==0)
gen no_mao=0 if !missing(mao)
replace no_mao=1 if (!missing(mao) & mao==0)
gen no_rp=0 if !missing(rp)
replace no_rp=1 if (!missing(rp) & rp==0)
gen no_mnc=0 if !missing(mnc)
replace no_mnc=1 if (!missing(mnc) & mnc==0)
gen lag=(timing1*-1)/365
gen no_mw_rp=3
replace no_mw_rp=2 if (rp==1 & mw==0)
replace no_mw_rp=1 if (mw==1 & rp==0)
replace no_mw_rp=0 if (mw==1 & rp==1)

gen no_mw_mp=0 if !missing(mw_mp)
replace no_mw_mp=1 if (!missing(mw_mp) & mw_mp==0)
gen no_mao_mp=0 if !missing(mao_mp)
replace no_mao_mp=1 if (!missing(mao_mp) & mao_mp==0)
gen no_rp_mp=0 if !missing(rp_mp)
replace no_rp_mp=1 if (!missing(rp_mp) & rp_mp==0)
gen no_mw_rp_mp=0
replace no_mw_rp_mp=-1 if no_rp_mp==0
replace no_mw_rp_mp=-2 if no_mw_mp==0
replace no_mw_rp_mp=-3 if (no_mw_mp==0 & no_rp_mp==0)

/* Scale Main Independent Variables by 100 */
foreach i in sum_tenure610 sum_tenure59 sum_tenure48 sum_tenure37 sum_tenure12 sum_tenure1121 sum_tenure610_nolag sum_tenure59_nolag sum_tenure48_nolag sum_tenure37_nolag{ 
replace `i'=`i'/100
}

/* PCA */
pca no_mw no_mao no_rp no_mnc lag, components(1)
predict pc1_finrep, score

pca no_mw_mp no_mao_mp no_rp_mp, components(1)
predict pc1_mp, score

sort dbkey1 audityear
tsset dbkey1 audityear

foreach i in pc1_finrep{
by dbkey1: gen lag_pc1_finrep  = pc1_finrep[_n-1] if audityear == audityear[_n-1] +1
by dbkey1: gen lag2_pc1_finrep = pc1_finrep[_n-2] if audityear == audityear[_n-2] +2
by dbkey1: gen lag3_pc1_finrep = pc1_finrep[_n-3] if audityear == audityear[_n-3] +3
by dbkey1: gen lag4_pc1_finrep = pc1_finrep[_n-4] if audityear == audityear[_n-4] +4
}
gen sum_pc1_finrep = lag_pc1_finrep + lag2_pc1_finrep + lag3_pc1_finrep + lag4_pc1_finrep
xtile pc1_finrep_rank = sum_pc1_finrep, nq(4)
gen low_finrep=1 if pc1_finrep_rank ==1
replace low_finrep=0 if missing(low_finrep)
foreach i in 610 59 48 37{ 
gen sum_tenure`i'_low_finrep=sum_tenure`i'_nolag*low_finrep
}
gen lead_fin=f.pc1_finrep
gen simplesum = no_mao + no_mw + no_rp + no_mnc + lag

/* Make lrisk Increase in Opacity */
gen hrisk=0
replace hrisk=1 if lrisk==0
foreach i in 610 59 48 37{ 
gen sum_tenure`i'_lrisk=sum_tenure`i'*lrisk
}

/* Size */
xtile size=population, nq(4)
gen small=0 
replace small=1 if size==1
replace small=1 if missing(size)
foreach i in 610 59 48 37{ 
gen sum_tenure`i'_small=sum_tenure`i'*small
}

/* Bing */
replace valid_articles = 0 if missing(valid_articles)
gen n_bing = -valid_articles

sort dbkey
by dbkey: egen avg_bing2 = mean(n_bing)
sort audityear
by audityear: egen avg_bing3 = mean(n_bing)
gen n_bing1 = (n_bing - avg_bing2 - avg_bing3)

/* Bond-Market Participants as Monitor */
foreach i in 610 59 48 37{ 
gen sum_tenure`i'_new_issue=sum_tenure`i'*new_issue
}

/* Independent Auditor as Monitors */
gen indep_audit=0
replace indep_audit=1 if state_audit==0
foreach i in 610 59 48 37{ 
gen sum_tenure`i'_indep_audit=sum_tenure`i'*indep_audit
}

/* Media as Monitors */
gen news = (newspaper / population_st) * 1000
xtile xtile_news=news, nq(4)
gen high_news = 0
replace high_news = 1 if xtile_news >=4
foreach i in 610 59 48 37{ 
gen sum_tenure`i'_news=sum_tenure`i'*high_news
}

/* Stewardship for Reputation Building */
xtile lag_fin_rank= lag_pc1_finrep, nq(4) 
xtile lead_fin_rank= lead_fin, nq(4) 
gen reputation = 0
replace reputation = 1 if lag_fin_rank <=2 & lead_fin_rank >=3
foreach i in 610 59 48 37 {
gen d_death`i'_reputation = d_death`i' * reputation
}

/* Favor - Partisan */
gen favor = 0
replace favor = 1 if n_democrat1 >=2 & d_democrat ==1
replace favor = 1 if n_democrat1 ==0 & d_republican ==1
foreach i in 610 59 48 37{
gen sum_tenure`i'_favor = sum_tenure`i'*favor
}

/* Favor - Hometown */
gen dist = min(dist1, dist2)
gen d_dist = 0
replace d_dist = 1 if dist <= 25
foreach i in 610 59 48 37{
gen sum_tenure`i'_dist = sum_tenure`i'*d_dist
}

/* Appropriation */
foreach i in 610 59 48 37{
egen app`i'_rank = xtile(app`i'), by(audityear) nq(4)
gen d_app`i' = 1 if app`i'_rank >= 4
replace d_app`i' = 0 if missing(d_app`i')
gen sum_tenure`i'_app = sum_tenure`i'*d_app`i'
}

/* Court */
gen court= (sum_totcase/1000)  /* time-invariant */
gen courti= (totcase/1000)  /* time-varying */

xtile xtile_court=court, nq(4)
gen low_court=0 if !missing(xtile_court)
replace low_court=1 if xtile_court==1 & !missing(xtile_court)

xtile xtile_courti=courti, nq(4)
gen low_courti=0 if !missing(xtile_courti)
replace low_courti=1 if xtile_courti==1 & !missing(xtile_courti)

foreach i in 610 59 48 37{ 
gen sum_tenure`i'_court=sum_tenure`i'*low_court
gen sum_tenure`i'_courti=sum_tenure`i'*low_courti
}

/* DOJ */
gen doj= sum_doj1  /* time-invariant */
gen doji= doj1  /* time-variant */

xtile xtile_doj=doj, nq(4)
gen low_doj=0 if !missing(xtile_doj)
replace low_doj=1 if xtile_doj==1 & !missing(xtile_doj)

xtile xtile_doji=doji, nq(4)
gen low_doji=0 if !missing(xtile_doji)
replace low_doji=1 if xtile_doji==1 & !missing(xtile_doji)

foreach i in 610 59 48 37{ 
gen sum_tenure`i'_doj=sum_tenure`i'*low_doj
gen sum_tenure`i'_doji=sum_tenure`i'*low_doji
}

/* Margin */
foreach i in 610 59 48 37{
gen sum_tenure`i'_margin1 = sum_tenure`i' * margin1
}

/* Alternative Congressional Representation */
foreach i in 6 5 4 3 {
gen senate_dtenure`i' = sum_dtenure`i'*democrat_r
replace senate_dtenure`i' = 0 if missing(senate_dtenure`i')
gen senate_rtenure`i' = sum_rtenure`i'*republican_r
replace senate_rtenure`i' = 0 if missing(senate_rtenure`i')
gen senate_tenure`i' = senate_dtenure`i' + senate_rtenure`i'
}
foreach i in 10 9 8 7 {
gen house_dtenure`i' = sum_dtenure`i'*democrat_district
replace house_dtenure`i' = 0 if missing(house_dtenure`i')
gen house_rtenure`i' = sum_rtenure`i'*republican_district
replace house_rtenure`i' = 0 if missing(house_rtenure`i')
gen house_tenure`i' = house_dtenure`i' + house_rtenure`i'
}
gen alt_tenure610 = (senate_tenure6 + house_tenure10)/100
gen alt_tenure59 = (senate_tenure5 + house_tenure9)/100
gen alt_tenure48 = (senate_tenure4 + house_tenure8)/100
gen alt_tenure37 = (senate_tenure3 + house_tenure7)/100

*************Main Paper*************

*Table 1 - Descriptive Statistics
tabstat pc1_finrep no_mao no_mw no_rp no_mnc lag sum_tenure610 sum_tenure59 sum_tenure48 sum_tenure37 d_death610 d_death59 d_death48 d_death37 new_issue lexp lm_subsidy, statistics(n mean sd p25 p50 p75) columns(statistics)
tabstat court doj small margin1, statistics(n mean sd p25 p50 p75) columns(statistics)

estpost correlate pc1_finrep no_mao no_mw no_rp no_mnc lag sum_tenure37 sum_tenure48 sum_tenure59 sum_tenure610, matrix

*Table 2 - Local Stewardship, by State
sort statename
by statename: tabstat pc1_finrep, statistics(n mean) columns(statistics)

*Table 3 - Main Result
global control "new_issue lexp lm_subsidy d_subsidy"
foreach j in pc1_finrep{
foreach i in 610 59 48 37 { 
	qui areg `j' sum_tenure`i' $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 4 - Death
foreach j in pc1_finrep{
foreach i in d_death610 d_death59 d_death48 d_death37 { 
	qui areg `j' `i' $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 5 - Misappropriation or Ineptitude
foreach j in pc1_finrep {
foreach i in 59 37 {
	qui areg `j' sum_tenure`i' sum_tenure`i'_court $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_court ==0
	qui areg `j' sum_tenure`i' sum_tenure`i'_doj $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_doj ==0
}
}
foreach j in pc1_finrep {
foreach i in 610 59 48 37  { 
	qui areg `j' sum_tenure`i' sum_tenure`i'_small small $control i.audityear, absorb(id) vce(cluster stcd)  
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_small =0
}
}
*Table 6 - Political Competition
foreach j in pc1_finrep{
foreach i in 610 59 48 37{
	qui areg `j' sum_tenure`i' sum_tenure`i'_margin1 margin1 $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_margin1 = 0
}
}

*************Online Appendix*************

*Table 1 - Components
foreach j in no_mao no_mw no_rp no_mnc lag {
foreach i in 59 37 { 
	qui areg `j' sum_tenure`i' $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 2 - Simple Sum
estpost correlate simplesum pc1_finrep no_mao no_mw no_rp no_mnc lag sum_tenure37 sum_tenure48 sum_tenure59 sum_tenure610, matrix
foreach j in simplesum{
foreach i in 610 59 48 37 { 
	qui areg `j' sum_tenure`i' $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 3 - Compliance 
foreach j in pc1_mp {
foreach i in 610 59 48 37 { 
	qui areg `j' sum_tenure`i' $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 4 - News Search-based
estpost correlate n_bing1 pc1_finrep no_mao no_mw no_rp no_mnc lag sum_tenure37 sum_tenure48 sum_tenure59 sum_tenure610, matrix
foreach j in n_bing {
foreach i in 610 59 48 37 { 
	qui areg `j' sum_tenure`i' $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 5 - Alternative congressional representation
foreach j in pc1_finrep {
foreach i in 610 59 48 37 { 
	qui areg `j' p75_tenure`i' $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 6 - Falsification non-top 10 committees
gen sum_exten = sum_tenure1121 - sum_tenure37
foreach j in pc1_finrep {
foreach i in sum_exten { 
	qui areg `j' `i' $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 10 - Instrumented
foreach i in 610 59 48 37 {
	qui reghdfe pc1_finrep  $control i.audityear (sum_tenure`i'=d_death`i'), keepsin absorb(id) cluster(stcd)
	est tab, drop(d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
*Table 11 - Corruption (time-varying)
foreach j in pc1_finrep {
foreach i in 59 37 {
	qui areg `j' sum_tenure`i' sum_tenure`i'_courti low_courti $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_courti ==0
	qui areg `j' sum_tenure`i' sum_tenure`i'_doji low_doji $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_doji ==0
}
}
*Table 12 - DOJ enforcements
foreach j in doji {
foreach i in 610 59 48 37 {
	qui areg `j' sum_tenure`i' sum_tenure`i'_low_finrep low_finrep $control i.audityear, absorb(id) vce(cluster stcd)    
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 13 - Measuring congressional representation based on party affiliation
foreach j in pc1_finrep {
foreach i in 610 59 48 37 { 
	qui areg `j' alt_tenure`i' $control i.audityear if missing(ranney)==0, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}

*Table 14 - Favoritism
foreach j in lexp {
foreach i in 610 59 48 37 { 
	qui areg `j' sum_tenure`i' sum_tenure`i'_favor favor new_issue i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_favor =0
}
}
foreach j in lexp {
foreach i in 610 59 48 37 {
	qui areg `j' sum_tenure`i' sum_tenure`i'_dist d_dist new_issue i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_dist==0
}
}
*Table 15 - Stewardship for reputation building
foreach j in lexp {
foreach i in d_death610 d_death59 d_death48 d_death37 { 
	qui areg `j' `i' `i'_reputation reputation new_issue i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test `i'+`i'_reputation = 0
}
}
*Table 16 - Bondholder as a monitor
foreach j in pc1_finrep {
foreach i in sum_tenure610 sum_tenure59 sum_tenure48 sum_tenure37 { 
	qui areg `j' `i' `i'_new_issue $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test `i'+`i'_new_issue=0
}
}
*Table 17 - Independent auditor as a monitor
foreach j in pc1_finrep {
foreach i in sum_tenure610 sum_tenure59 sum_tenure48 sum_tenure37 { 
	qui areg `j' `i' `i'_indep_audit indep_audit $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test `i'+`i'_indep_audit=0
}
}
*Table 18 -  Media as a monitor
foreach j in pc1_finrep {
foreach i in 610 59 48 37 {
	qui areg `j' sum_tenure`i' sum_tenure`i'_news $control i.audityear, absorb(id) vce(cluster stcd)    
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_news = 0
}
}
*Table 19 - Auditor effort
foreach j in pc1_finrep {
foreach i in sum_tenure610 sum_tenure59 sum_tenure48 sum_tenure37 { 
	qui areg `j' `i' `i'_lrisk lrisk $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test `i'+`i'_lrisk=0
}
}
*Table 20 - Appropriation
foreach j in pc1_finrep {
foreach i in 610 59 48 37 { 
	qui areg `j' sum_tenure`i' sum_tenure`i'_app d_app`i' $control i.audityear, absorb(id) vce(cluster stcd)  
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 21 - Exclude 12 largest states
gen large12 = 0
replace large12 = 1 if inlist(statename,"CA","FA","GA","IL","MI","NC")
replace large12 = 1 if inlist(statename,"NJ","NY","OH","PA","TX","VA")
foreach j in pc1_finrep {
foreach i in 610 59 48 37 {
	qui areg `j' sum_tenure`i' $control i.audityear if large12 ==0, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
*Table 22 - State-by-year fixed effects
foreach j in pc1_finrep {
foreach i in 610 59 48 37 { 
	reg2hdfe `j' sum_tenure`i' $control , id1(id) id2(styr) cluster (stcd)
}
}
*Table 23 - Including interactions
foreach j in pc1_finrep{
foreach i in 610 59 48 37{
	qui areg `j' sum_tenure`i' sum_tenure`i'_margin1 sum_tenure`i'_court sum_tenure`i'_doj sum_tenure`i'_small margin1 $control i.audityear, absorb(id) vce(cluster stcd)
	est tab, drop(_cons d_subsidy i.audityear)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
		test sum_tenure`i' + sum_tenure`i'_margin1 = 0
}
}
use "D:\CKM_local.dta", clear

*Scale independent variables by 100
foreach i in sum_tenure610 sum_tenure59 sum_tenure48 sum_tenure37 { 
replace `i'=`i'/100
}
*Table 7 - Local Elections and Stewardship
tabstat lead_rvotes pc1_finrep_lag sum_tenure610 sum_tenure59 sum_tenure48 sum_tenure37 lexp lm_subsidy margin1 lincome_cty ue_cty edu, statistics(n mean sd p25 p50 p75) columns(statistics)
global control "lexp lm_subsidy margin1 lincome_cty ue_cty edu d_subsidy "
foreach j in  lead_rvotes {
foreach i in 610 { 
	qui reg `j' pc1_finrep_lag $control i.year1, vce(robust)
	est tab, drop(_cons d_subsidy i.year1)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
foreach j in  lead_rvotes {
foreach i in 610 59 48 37 { 
	qui reg `j' pc1_finrep_lag sum_tenure`i' $control i.year1, vce(robust)
	est tab, drop(_cons d_subsidy i.year1)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}

use "D:\CKM_congress.dta", clear

/* Scale independent variables by 100 */
foreach i in sum_tenure10 sum_tenure5 sum_tenure3 sum_tenure1 { 
replace `i'=`i'/100
}

*Table 8 - Congressional Elections and Stewardship
tabstat lead_rvotes pc1_finrep_lag sum_tenure1 sum_tenure3 sum_tenure5 sum_tenure10 lexp lm_subsidy margin1 lincome_cty ue_cty edu, statistics(n mean sd p25 p50 p75) columns(statistics)
global control "lexp lm_subsidy margin1 lincome_cty ue_cty edu d_subsidy "
foreach j in lead_rvotes {
foreach i in 1 { 
	qui reg `j' pc1_finrep_lag $control i.year1, vce(robust)
	est tab, drop(_cons d_subsidy i.year1)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}
foreach j in lead_rvotes {
foreach i in 1 3 5 10{ 
	qui reg `j' pc1_finrep_lag sum_tenure`i' $control i.year1, vce(robust)
	est tab, drop(_cons d_subsidy i.year1)  b(%8.3f) se(%8.3f) stats(N r2) varwidth(20)
}
}


brainstormingobra/superpowersYou MUST use this before any creative work - creating features, building components, adding functionality, modifying behavior, or planning anything new, in software or out of it (a talk, a business, a renovation).Stars: 323kUpdated Claude CodeCodexVerifiedInstall
brand-guidelinesanthropics/skillsApplies Anthropic's official brand colors and typography to any sort of artifact that may benefit from having Anthropic's look-and-feel. Use it when brand colors or style guidelines, visual formatting, or company design standards apply.Stars: 198kUpdated Claude CodeCodexVerifiedInstall
frontend-designanthropics/skillsGuidance for distinctive, intentional visual design when building new UI or reshaping an existing one. Helps with aesthetic direction, typography, and making choices that don't read as templated defaults.Stars: 198kUpdated Claude CodeCodexVerifiedInstall
mcp-builderanthropics/skillsGuide for creating high-quality MCP (Model Context Protocol) servers that enable LLMs to interact with external services through well-designed tools. Use when building MCP servers to integrate external APIs or services, whether in Python (FastMCP) or Node/TypeScript (MCP SDK).Stars: 198kUpdated Claude CodeCodexVerifiedInstall