CampaignLab / data-pipeline

Scripts and schemas that aim to make data from the inventory easier to analyse
8 stars 8 forks source link

Ward level information on School cuts - 4 #16

Open jamesmoulding opened 5 years ago

jamesmoulding commented 5 years ago

Key Question

Do school cuts affect vote share in wards?

Theory

School cuts negatively affect Conservative vote and likely boost Labour and opposition parties.

Key Data

School cuts information on wide range of topics from class size to number of schools cut.

https://www.dropbox.com/sh/iv61p6oj7i15kn7/AACgHztmZTTsFH27SPqJj5IAa?dl=0&preview=Wards.xlsx

Task

Extract data and determine an approach to measuring school cuts impact, such as (number of pupils * income per pupil) minus income reduction, or teachers cut as a proportion of total teachers in relation to pupil count. Correlate impact with vote share.