People Power Index: Full Data (4 December 2019)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUV
1
2
People Power Index
3
4
5
6
7
This spreadsheet contains all of the data used to drive and calculate the People Power Index.

Each MP is assigned a score out of 10, based on the number of points they get in each different category. Each category is composed of 2-6 data points.

Points are awarded for each data point based on their importance, set in the ""Importance ranking"" tab. There are 50 points in total, 30 provided for the Availability to Constituents, and 10 each for Participation in Parliament and Listening to the Public. The total points for all data points are added up and converted into a score from 1 to 10, which is the final People Power Score.

Currently, the index is composed of 10 different data points, each of which have been assigned a category for ease of analysis. The categories are as follows:
Availability to Constituents (constituency office, active on Twitter, second job, WriteToThem responsiveness, case workers, and constituent surgeries)
• Participation in Parliament (attendance, mentions of constituents in the chamber)
Listening to the Public (number of signatures on Change.org petitions in their constituency, number of times petitions raised and debated in Parliament)

Read the full methodology here:
change.org/peoplepowermethodology


Important tabs:
• Summary scoring - This tab combines all of the scores from the ""Detailed scoring"" tab into the assigned categories and works out MPs' total scores, as well as their scores in each different category.
• Importance ranking - This tab outlines the different levels of importance that each piece of data has. By editing the yellow column in this tab, you can change the importance of each and see how that affects the scoring in the ""Summary scoring"" tab.
• Detailed scoring - This tab combines the ""Importance ranking"" tab and the ""DATA - Raw composite"" tab to work out how many points MPs get for each data set.

Other tabs for background:
• DATA - Raw composite - this tab combines all of the data sets into one place for ease of navigation
• DATA - Exclusion control sheet - this tab controls which MPs are excluded from, using the DATA - Absences tab
• DATA - Absences - this tab contains all of the information provided by MPs or researched by Change.org on whether or not MPs have had leaves of absence or held positions that meant they couldn't advocate for their constituents directly in the chamber
• DATA - Categorical scoring - this tab contains the scores for each of the non-textual metrics, e.g.: constituency offices may be ""Yes"", ""Hidden"", or ""No"", this tab contains what those values correspond to in points
• DATA - Constituency offices - this tab contains the information about whether MPs have a constituency office or not
• DATA - Active on Twitter - this tab has the stats about MPs last 500 tweets, what kind of tweets they were and so on
• DATA - WriteToThem responsiveness - this tab contains the data provided by WriteToThem about MPs' responsiveness
• DATA - Constituent mentions in Parliament - this tab holds the numbers for amount of times MPs have mentioned the terms 'my constituent', 'a person in my constituency', 'somebody in my constituency', 'someone in my constituency'.
• DATA - Second job - this tab contains information about how much money different MPs have earnt, both one-off and monthly and a classification of whether or not they have a second job
• DATA - Sigs by constituency (Change.org) - this tab holds data by constituency on how many petitions were started there and how many signatures came from that constituency
• DATA - attend+rebel records in Parliament - this tab contains the attendance and rebellion for each MP in this parliament, and controls the scoring baseline for each based on the averages
• DATA - petitions mentioned in HoC/WMH - this tab holds data about how often MPs have mentioned the terms 'presenting a petition', 'organisers of the petition', 'present a petition', 'present petitions on behalf', 'that this house has considered e-petition', 'present this petition', 'present my first petition', 'constituents signed the petition'
• DATA - Case worker/surgery - this tab holds data about whether or not MPs reported holding regular constituent surgeries and having a case worker employed in their offices as collected by Change.org
"









































8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...