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.178** (0.4024) 3.757*** (0.1947)
## log_pop 0.9362*** (0.0230) 0.7101*** (0.0301) 0.0724*** (0.0119)
## log_med_income -0.0530 (0.0354) -0.0120 (0.0348) 0.3744*** (0.0184)
## log_crime 0.1006*** (0.0164) 0.0796*** (0.0164) 0.0154. (0.0085)
## log_outlays 0.2245*** (0.0194)
## _______________ __________________ __________________ __________________
## S.E. type IID IID IID
## Observations 1,642 1,567 1,642
## R2 0.82098 0.84126 0.31840
## Adj. R2 0.82065 0.84085 0.31716
##
## p_model_outlays q_model q_model_outlays
## Dependent Var.: log_p_pol log_q_pol log_q_pol
##
## Constant 3.487*** (0.2181) -0.5628 (0.3457) -2.309*** (0.3704)
## log_pop 0.0617*** (0.0163) 0.8638*** (0.0211) 0.6485*** (0.0277)
## log_med_income 0.3945*** (0.0189) -0.4274*** (0.0326) -0.4065*** (0.0320)
## log_crime 0.0122 (0.0089) 0.0852*** (0.0151) 0.0674*** (0.0151)
## log_outlays 0.0103 (0.0105) 0.2143*** (0.0179)
## _______________ __________________ ___________________ ___________________
## S.E. type IID IID IID
## Observations 1,567 1,642 1,567
## R2 0.33158 0.81680 0.83818
## Adj. R2 0.32986 0.81646 0.83776
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Theories
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.284*** (0.6237) 2.384*** (0.3421)
## log_pop 0.8937*** (0.0276) 0.6350*** (0.0413) 0.1057*** (0.0159)
## log_med_income 0.3000*** (0.0578) 0.3113*** (0.0556) 0.4810*** (0.0333)
## log_fires_2017 0.1084*** (0.0249) 0.0796** (0.0241) -0.0044 (0.0143)
## log_outlays 0.2627*** (0.0321)
## _______________ __________________ __________________ __________________
## S.E. type IID IID IID
## Observations 678 667 678
## R2 0.83515 0.85120 0.39348
## Adj. R2 0.83442 0.85030 0.39078
##
## pF_out qF qF_out
## Dependent Var.: log_p_fire log_q_fire log_q_fire
##
## Constant 2.288*** (0.3730) -2.567*** (0.6004) -4.571*** (0.6337)
## log_pop 0.1052*** (0.0247) 0.7881*** (0.0279) 0.5299*** (0.0419)
## log_med_income 0.4921*** (0.0333) -0.1810** (0.0584) -0.1808** (0.0565)
## log_fires_2017 -0.0052 (0.0144) 0.1129*** (0.0251) 0.0848*** (0.0245)
## log_outlays -0.0009 (0.0192) 0.2636*** (0.0327)
## _______________ __________________ __________________ __________________
## S.E. type IID IID IID
## Observations 667 678 667
## R2 0.40370 0.78712 0.80635
## Adj. R2 0.40010 0.78618 0.80518
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Theories
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.382*** (0.9308) 3.650*** (0.2275)
## log_pop 0.9138*** (0.0539) 0.4879*** (0.0692) 0.0473*** (0.0142)
## log_med_income -0.7793*** (0.0830) -0.7628*** (0.0829) 0.3889*** (0.0218)
## log_crime 0.1386*** (0.0390) 0.0978* (0.0387) 0.0042 (0.0103)
## log_outlays 0.4286*** (0.0442)
## _______________ ___________________ ___________________ __________________
## S.E. type IID IID IID
## Observations 1,350 1,297 1,350
## R2 0.55453 0.58875 0.26271
## Adj. R2 0.55353 0.58748 0.26107
##
## pT_out qT qT_out
## Dependent Var.: log_p_transit log_q_transit log_q_transit
##
## Constant 3.072*** (0.2521) 5.968*** (0.8664) 3.310*** (0.9371)
## log_pop 0.0032 (0.0187) 0.8666*** (0.0540) 0.4847*** (0.0697)
## log_med_income 0.4151*** (0.0225) -1.168*** (0.0832) -1.178*** (0.0835)
## log_crime -0.0018 (0.0105) 0.1344*** (0.0391) 0.0996* (0.0390)
## log_outlays 0.0436*** (0.0120) 0.3850*** (0.0445)
## _______________ __________________ __________________ __________________
## S.E. type IID IID IID
## Observations 1,297 1,350 1,297
## R2 0.28333 0.53991 0.57179
## Adj. R2 0.28111 0.53889 0.57046
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## Theories
RTW
Politics
