Column | Type | Contents |
con_seq |
Integer number. |
Identifying Number of the Constituency.
|
seats |
Integer number. |
Number of Seats within the Constituency.
|
constituency_raw |
Text string (max.len.=104). |
Name of Constituency in original data.
|
constituency |
Text string (max.len.=104). |
Cleaned name of Constituency.
|
cand_seq |
Integer number. |
Candidate sequence number.
|
party_code |
Text string (max.len.=104). |
Code for party name.
|
votes |
Floating point number. |
Number of votes as figures (unopposed candidates given as -1).
|
party_label |
Text string (max.len.=154). |
Name of party. Number in brackets separates the candidates from the same party.
Also identifies total electorate, turnout, number of votes and quota
|
election_year |
Integer number. |
Year of Election.
|
election_month |
Text string (max.len.=34). |
Month of Election.
|
election_day |
Integer number. |
Day of Election.
|
election_date |
Database date value. |
Date of Election, held as database date value.
|
end_election_year |
Integer number. |
Year Election ended when over multiple days.
|
end_election_month |
Text string (max.len.=34). |
Month Election ended when over multiple days.
|
end_election_day |
Integer number. |
Day Election ended when over multiple days.
|
end_election_date |
Database date value. |
Date Election ended when over multiple days, held as database date value.
|
adj |
Text string (max.len.=8). |
Indicates 1979 results with adjusted constituency boundaries
|
election_type |
Text string (max.len.=6). |
Letter code identifying whether General election (G) or By-election (B).
|
election_prop |
Integer number. |
Number 1, 2 or 3 denotes order in which successful candidates elected in university constituencies practising Proportional Representation.
|
g_authority |
Text string (max.len.=1004). |
Source for the information.
NB anything included here must be an authority ID defined in the main g_authority table.
|
nation |
Text string (max.len.=34). |
Name of Nation constituency contained within (not all rows).
|
notes |
Text string (max.len.=1004). |
Comments including reason for instigation of a by-election.
|
unopp_flag |
Text string (max.len.=12). |
Flag indicating where election was unopposed (unopposed candidates given as -1 in votes column).
|
g_unit |
Integer number. |
Unique ID number for constituency unit.
|
rec_num |
Integer number. |
Sequence number of order of list in book or original spreadsheet.
|