Correlation Plots of Salaries vs. Multiple City Characteristics

2000 - 2017 Percent Change

Correlations are computed by Spearman’s Method.

Definitions of Variables:

  • pct_change_hh_income: Percent Change in Median Household Income (ACS)

  • pct_change_pop: Percent Change in Total Population (ACS)

  • pct_change_hpi: Percent Change in House Price Index for County (FHFA)

  • pct_change_outlays: Percent Change in Total Municipal Outlays (Census of Govts)

  • pp_change_single_fam: Percentage Point Change in % Housing Units that are Single Family (ACS)

  • pp_change_non_white: Percentage Point Change in % of Population that is NOT non-hispanic white (ACS)

  • pp_change_college_educ: Percentage Point Change in % of 25+ Population with Associate’s Degree completed or greater (ACS)

  • pct_change_violent_crime: Percent Change in Violent Crime (FBI)

  • pp_change_police_budget: Percentage Point Change in Police Share of Municipal Budget (Census of Govts)

Not Separated by Bargaining Measure

Separated by Bargaining Measure

Right to Work

Right to Strike

State-Level State Employee Collective Bargaining

State-Level Local Police Collective Bargaining

2017 Level

Right to Work

Right to Strike

State-Level State Employee Collective Bargaining

State-Level Local Police Collective Bargaining

Correlation Plots Pct Change in Salaries vs. Pct Change HPI

By Above / Below Median Pct Change HPI

By Above / Below Median Pct Change Total outlays

By Union Measure: Right to Work

By Union Measure: Right to Strike

By Union Measure: State Employee Collective Bargaining

By Union Measure: State Local Police Collective Bargaining

Re-Run Regression with Interaction with Income Instead of HPI

2000-2017 Log Level Time Series (with City and Year Fixed Effects)

Note: Intercepts are not shown

regression term est se p_val
Police Salaries
Right to Work
log_police_salaries vs rtw rtwYes -0.149 0.073 0.042
log_police_salaries vs rtw log_hh_income 0.374 0.012 0.000
log_police_salaries vs rtw rtwYes:log_hh_income 0.018 0.016 0.262
Right to Strike
log_police_salaries vs right_to_strike right_to_strike 0.959 0.107 0.000
log_police_salaries vs right_to_strike log_hh_income 0.441 0.011 0.000
log_police_salaries vs right_to_strike right_to_strike:log_hh_income -0.200 0.024 0.000
State Employee Collect. Barg.
log_police_salaries vs union_state union_state 0.396 0.081 0.000
log_police_salaries vs union_state log_hh_income 0.397 0.014 0.000
log_police_salaries vs union_state union_state:log_hh_income -0.065 0.018 0.000
Local Police Collect. Barg.
log_police_salaries vs union_localpol union_localpol -0.232 0.088 0.008
log_police_salaries vs union_localpol log_hh_income 0.307 0.016 0.000
log_police_salaries vs union_localpol union_localpol:log_hh_income 0.073 0.019 0.000
Local Fire Collect. Barg.
log_police_salaries vs union_localfire union_localfire -0.198 0.096 0.039
log_police_salaries vs union_localfire log_hh_income 0.331 0.019 0.000
log_police_salaries vs union_localfire union_localfire:log_hh_income 0.060 0.021 0.005
Police Employment
Right to Work
log_police_pc vs rtw rtwYes 1.771 0.234 0.000
log_police_pc vs rtw log_hh_income -0.634 0.038 0.000
log_police_pc vs rtw rtwYes:log_hh_income -0.376 0.052 0.000
Right to Strike
log_police_pc vs right_to_strike right_to_strike -1.363 0.332 0.000
log_police_pc vs right_to_strike log_hh_income -0.877 0.033 0.000
log_police_pc vs right_to_strike right_to_strike:log_hh_income 0.264 0.073 0.000
State Employee Collect. Barg.
log_police_pc vs union_state union_state -2.081 0.259 0.000
log_police_pc vs union_state log_hh_income -0.991 0.044 0.000
log_police_pc vs union_state union_state:log_hh_income 0.419 0.057 0.000
Local Police Collect. Barg.
log_police_pc vs union_localpol union_localpol -2.190 0.278 0.000
log_police_pc vs union_localpol log_hh_income -1.022 0.051 0.000
log_police_pc vs union_localpol union_localpol:log_hh_income 0.439 0.062 0.000
Local Fire Collect. Barg.
log_police_pc vs union_localfire union_localfire -2.573 0.298 0.000
log_police_pc vs union_localfire log_hh_income -1.176 0.059 0.000
log_police_pc vs union_localfire union_localfire:log_hh_income 0.529 0.066 0.000
Fire Salaries
Right to Work
log_ff_salaries vs rtw rtwYes -0.316 0.085 0.000
log_ff_salaries vs rtw log_hh_income 0.406 0.014 0.000
log_ff_salaries vs rtw rtwYes:log_hh_income 0.056 0.019 0.003
Right to Strike
log_ff_salaries vs right_to_strike right_to_strike 1.140 0.125 0.000
log_ff_salaries vs right_to_strike log_hh_income 0.494 0.012 0.000
log_ff_salaries vs right_to_strike right_to_strike:log_hh_income -0.239 0.028 0.000
State Employee Collect. Barg.
log_ff_salaries vs union_state union_state 0.443 0.094 0.000
log_ff_salaries vs union_state log_hh_income 0.456 0.016 0.000
log_ff_salaries vs union_state union_state:log_hh_income -0.075 0.021 0.000
Local Police Collect. Barg.
log_ff_salaries vs union_localpol union_localpol -0.115 0.103 0.267
log_ff_salaries vs union_localpol log_hh_income 0.361 0.019 0.000
log_ff_salaries vs union_localpol union_localpol:log_hh_income 0.051 0.023 0.027
Local Fire Collect. Barg.
log_ff_salaries vs union_localfire union_localfire -0.061 0.112 0.587
log_ff_salaries vs union_localfire log_hh_income 0.390 0.022 0.000
log_ff_salaries vs union_localfire union_localfire:log_hh_income 0.034 0.025 0.176
Fire Employment
Right to Work
log_fire_pc vs rtw rtwYes 1.570 0.387 0.000
log_fire_pc vs rtw log_hh_income -1.220 0.065 0.000
log_fire_pc vs rtw rtwYes:log_hh_income -0.334 0.085 0.000
Right to Strike
log_fire_pc vs right_to_strike right_to_strike -0.444 0.561 0.428
log_fire_pc vs right_to_strike log_hh_income -1.410 0.054 0.000
log_fire_pc vs right_to_strike right_to_strike:log_hh_income 0.038 0.124 0.761
State Employee Collect. Barg.
log_fire_pc vs union_state union_state -1.905 0.439 0.000
log_fire_pc vs union_state log_hh_income -1.550 0.074 0.000
log_fire_pc vs union_state union_state:log_hh_income 0.381 0.097 0.000
Local Police Collect. Barg.
log_fire_pc vs union_localpol union_localpol 0.031 0.483 0.948
log_fire_pc vs union_localpol log_hh_income -1.289 0.087 0.000
log_fire_pc vs union_localpol union_localpol:log_hh_income -0.043 0.107 0.686
Local Fire Collect. Barg.
log_fire_pc vs union_localfire union_localfire -0.699 0.515 0.175
log_fire_pc vs union_localfire log_hh_income -1.441 0.102 0.000
log_fire_pc vs union_localfire union_localfire:log_hh_income 0.124 0.114 0.279