A vision of Britain through time

A vision of Britain from 1801 to now.

Including maps, statistical trends and historical descriptions.

- Table ID:
- G_ELECTIONS (58112)
- Contents:
- Summary statistics and interpretative text about each General Election 1833-2005
- Approx. number of rows:
- 44
- Table type:
- Raw Data
- Documentation Author:
- Humphrey Southall
- Chronology:
- The data cover the period 1881 to 1911.

- This table combines basic summary statistics about each General Election, abstracted from a variety of reference books including Craig, with explanatory text written by Humphrey Southall.

- This table exists to support the presentation of election results in the Vision of Britain site, and in particular within the statistical atlas. That presentation differs from other political themes in two ways. Firstly, we hold data for each by-election but it makes not sense to map it, so we need a separate list which defines which dates were General Elections. Secondly, elections were contests between named parties with local and national victors.
- Note that the statistics held here are NOT a summary of the results for individual constituencies we hold elsewhere, as the overall results of UK elections for much of the period depended in part on what happened in Irish constituencies which were not covered by the reference books we computerised for constituency-level data.

Index | Type | Column(s) indexed |
---|---|---|

g_elections_pkey | Primary key | election_date |

The table has the following associated constraints:

Constraint | Type | Details |
---|---|---|

g_elections_pkey | Primary Key | See details above for primary key index |

Column | Type | Contents |
---|---|---|

rec_num | Integer number. | Sequence number placing the elections in chronological order. |

page_seq | Integer number. | This is an alternative numbering designed to arrange the elections chronologically but in two columns, so it runs up initially from 1 incrementing by 2 until half way through the list, then restarts again at 2. |

election_date | Database date value. | Precise calendar date of the General Election. NB this is used by the system to identify which constituency results are from General Elections and which from by-elections. |

change | Text string (max.len.=6). | Y or N depending on whether the election led to a change in the party in power. |

election_name | Text string (max.len.=64). | For almost all elections this is simply the year of the election, but in 1910 and 1974, each of which had two General Elections, it includes an abbreviation for the month, so '1974 Feb' and '1974 Oct'. |

outcome | Text string (max.len.=64). | Text providing a headline summary of the outcome. |

pm_before | Text string (max.len.=34). | Name of the Prime Minister in power before the election. |

party_before | Text string (max.len.=14). | Name of the party in power before the election. |

pm_after | Text string (max.len.=34). | Name of the Prime Minister in power after the election. |

party_after | Text string (max.len.=14). | Name of the party in power after the election. |

con_seats | Integer number. | Number of seats won by the Conservatives. |

lib_seats | Integer number. | Number of seats won by the Liberals. |

lab_seats | Integer number. | Number of seats won by Labour. |

nat_seats | Integer number. | Number of seats won by the Nationalists. |

uu_seats | Integer number. | Number of seats won by the Ulster Unionists. |

wsn_seats | Integer number. | Number of seats won by the Welsh Nationalists. |

coal_seats | Integer number. | Number of seats won by coalition parties. |

other_seats | Integer number. | Number of seats won by other parties. |

con_votes | Integer number. | Number of votes won by the Conservatives. |

lib_votes | Integer number. | Number of votes won by the Liberals. |

lab_votes | Integer number. | Number of votes won by Labour. |

nat_votes | Integer number. | Number of votes won by the Nationalists. |

uu_votes | Integer number. | Number of votes won by the Ulster Unionists. |

wsn_votes | Integer number. | Number of votes won by the Welsh Nationalists. |

coal_votes | Integer number. | Number of votes won by coalition parties. |

other_votes | Integer number. | Number of votes won by other parties. |

total_votes | Integer number. | Total number of votes cast. |

etext | Long text. | Text summarising the election and its result. |

map_text | Long text. | Explanatory text to accompany map of the results. NB always null as this has never been written. |