03_qp_regressions_110425
Olivia Martin
2025-11-04
Police
Regressions
## pq_model pq_model_outlays p_model
## Dependent Var.: log_pq_pol log_pq_pol log_p_pol
##
## Constant 3.194*** (0.3757) 1.265** (0.4023) 3.757*** (0.1947)
## log_pop 0.9362*** (0.0230) 0.7197*** (0.0300) 0.0724*** (0.0119)
## log_med_income -0.0530 (0.0354) -0.0132 (0.0349) 0.3744*** (0.0184)
## log_crime 0.1006*** (0.0164) 0.0806*** (0.0164) 0.0154. (0.0085)
## log_outlays 0.2146*** (0.0191)
## _______________ __________________ __________________ __________________
## S.E. type IID IID IID
## Observations 1,642 1,567 1,642
## R2 0.82098 0.84048 0.31840
## Adj. R2 0.82065 0.84007 0.31716
##
## p_model_outlays q_model q_model_outlays
## Dependent Var.: log_p_pol log_q_pol log_q_pol
##
## Constant 3.501*** (0.2175) -0.5628 (0.3457) -2.236*** (0.3701)
## log_pop 0.0633*** (0.0162) 0.8638*** (0.0211) 0.6564*** (0.0276)
## log_med_income 0.3943*** (0.0189) -0.4274*** (0.0326) -0.4074*** (0.0321)
## log_crime 0.0124 (0.0089) 0.0852*** (0.0151) 0.0683*** (0.0151)
## log_outlays 0.0086 (0.0103) 0.2060*** (0.0176)
## _______________ __________________ ___________________ ___________________
## S.E. type IID IID IID
## Observations 1,567 1,642 1,567
## R2 0.33147 0.81680 0.83749
## Adj. R2 0.32975 0.81646 0.83707
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Theories (Using Total Outlays Model)
RTW
Path Dependence: 1997 Crime
Politics
Violent to Propety Crime Ratio
Violent Crime Clearance Rate 2012-2022
Unsheltered Homeless Per Capita
Fire
Regressions
## pqF pqF_out pF
## Dependent Var.: log_pq_fire log_pq_fire log_p_fire
##
## Constant -0.1834 (0.5943) -2.255*** (0.6241) 2.384*** (0.3421)
## log_pop 0.8937*** (0.0276) 0.6386*** (0.0412) 0.1057*** (0.0159)
## log_med_income 0.3000*** (0.0578) 0.3116*** (0.0557) 0.4810*** (0.0333)
## log_fires_2017 0.1084*** (0.0249) 0.0801*** (0.0241) -0.0044 (0.0143)
## log_outlays 0.2588*** (0.0321)
## _______________ __________________ __________________ __________________
## S.E. type IID IID IID
## Observations 678 667 678
## R2 0.83515 0.85088 0.39348
## Adj. R2 0.83442 0.84998 0.39078
##
## pF_out qF qF_out
## Dependent Var.: log_p_fire log_q_fire log_q_fire
##
## Constant 2.292*** (0.3728) -2.567*** (0.6004) -4.547*** (0.6339)
## log_pop 0.1057*** (0.0246) 0.7881*** (0.0279) 0.5329*** (0.0419)
## log_med_income 0.4921*** (0.0333) -0.1810** (0.0584) -0.1805** (0.0566)
## log_fires_2017 -0.0051 (0.0144) 0.1129*** (0.0251) 0.0853*** (0.0245)
## log_outlays -0.0015 (0.0192) 0.2604*** (0.0326)
## _______________ __________________ __________________ __________________
## S.E. type IID IID IID
## Observations 667 678 667
## R2 0.40370 0.78712 0.80602
## Adj. R2 0.40010 0.78618 0.80485
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Theories (Using Total Outlays Model)
RTW
Politics
Unsheltered Homeless
Transit, Waste, Sewer
Regressions
## pqT pqT_out pT
## Dependent Var.: log_pq_transit log_pq_transit log_p_transit
##
## Constant 9.619*** (0.8639) 6.425*** (0.9308) 3.650*** (0.2275)
## log_pop 0.9138*** (0.0539) 0.4924*** (0.0692) 0.0473*** (0.0142)
## log_med_income -0.7793*** (0.0830) -0.7636*** (0.0830) 0.3889*** (0.0218)
## log_crime 0.1386*** (0.0390) 0.0983* (0.0387) 0.0042 (0.0103)
## log_outlays 0.4240*** (0.0441)
## _______________ ___________________ ___________________ __________________
## S.E. type IID IID IID
## Observations 1,350 1,297 1,350
## R2 0.55453 0.58825 0.26271
## Adj. R2 0.55353 0.58698 0.26107
##
## pT_out qT qT_out
## Dependent Var.: log_p_transit log_q_transit log_q_transit
##
## Constant 3.075*** (0.2519) 5.968*** (0.8664) 3.350*** (0.9371)
## log_pop 0.0034 (0.0187) 0.8666*** (0.0540) 0.4890*** (0.0697)
## log_med_income 0.4151*** (0.0225) -1.168*** (0.0832) -1.179*** (0.0835)
## log_crime -0.0018 (0.0105) 0.1344*** (0.0391) 0.1000* (0.0390)
## log_outlays 0.0434*** (0.0119) 0.3806*** (0.0444)
## _______________ __________________ __________________ __________________
## S.E. type IID IID IID
## Observations 1,297 1,350 1,297
## R2 0.28330 0.53991 0.57134
## Adj. R2 0.28108 0.53889 0.57001
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Theories (Using Total Outlays Model)
RTW
Politics
