About this Dataset

London Elections Results 2008, Borough

Mayoral and London Assembly votes, spoils and turnout. Borough level data is here. Election results from London elections on 1 May 2008. Data from the elections in 2000 is not available at a borough level since it was never collected. Elections covered in the data are London Mayor (first and second choice), London member (list), and GLA Constituency member. The 2008 PDF report can be found here Download the ward turnout data Note: Ward turnouts include polling station votes only, and are therefore indicative only. Postal votes weren't recorded in the ward where people were resident, only at borough level.
Publisher name: Greater London Authority
Last updated: 2024-10-13T04:00:04Z

Tables

Gla-elections-votes-party-borough-2008

@ukgov.london_elections_results_2008_borough.gla_elections_votes_party_borough_2008

97.14 kB
34 rows
91 columns

CREATE TABLE gla_elections_votes_party_borough_2008 (
  "code" VARCHAR,
  "borough" VARCHAR,
  "constituency" VARCHAR,
  "london_mayor_1st_choice_barnbrook_richard_british_nati_c6c7dc47" BIGINT  -- London Mayor-1st Choice-Barnbrook Richard - British National Party,
  "london_mayor_1st_choice_batten_gerard_joseph_uk_indpen_4d7ab8d3" BIGINT  -- London Mayor-1st Choice-Batten Gerard Joseph - UK Indpendence Party,
  "london_mayor_1st_choice_berry_sian_green_party" BIGINT  -- London Mayor-1st Choice-Berry Sian - Green Party,
  "london_mayor_1st_choice_craig_alan_christian_peoples_a_ee3ac8ba" BIGINT  -- London Mayor-1st Choice-Craig Alan - Christian Peoples Alliance And Christian Party,
  "london_mayor_1st_choice_german_lindsey_ann_left_list" BIGINT  -- London Mayor-1st Choice-German Lindsey Ann - Left List,
  "london_mayor_1st_choice_johnson_boris_conservative_party" BIGINT  -- London Mayor-1st Choice-Johnson Boris - Conservative Party,
  "london_mayor_1st_choice_livingstone_ken_the_labour_par_e611a08a" BIGINT  -- London Mayor-1st Choice-Livingstone Ken - The Labour Party Candidate,
  "london_mayor_1st_choice_mckenzie_winston_truman_independent" BIGINT  -- London Mayor-1st Choice-McKenzie Winston Truman - Independent,
  "london_mayor_1st_choice_o_connor_matt_english_democrats" BIGINT  -- London Mayor-1st Choice-O'Connor Matt - English Democrats,
  "london_mayor_1st_choice_paddick_brian_lenoard_liberal_democrats" BIGINT  -- London Mayor-1st Choice-Paddick Brian Lenoard - Liberal Democrats,
  "london_mayor_1st_choice_total_good" BIGINT,
  "london_mayor_1st_choice_spoils_want_of_official_mark" BIGINT,
  "london_mayor_1st_choice_spoils_voting_for_too_many" BIGINT,
  "london_mayor_1st_choice_spoils_writing_identifying_voter" BIGINT,
  "london_mayor_1st_choice_spoils_unmarked" BIGINT,
  "london_mayor_1st_choice_spoils_uncertain" BIGINT,
  "london_mayor_1st_choice_spoils_rejected_in_part" BIGINT,
  "london_mayor_1st_choice_spoils_total_spoils" BIGINT,
  "london_mayor_2nd_choice_barnbrook_richard_british_nati_6425b372" BIGINT  -- London Mayor-2nd Choice-Barnbrook Richard - British National Party,
  "london_mayor_2nd_choice_batten_gerard_joseph_uk_indpen_71431b60" BIGINT  -- London Mayor-2nd Choice-Batten Gerard Joseph - UK Indpendence Party,
  "london_mayor_2nd_choice_berry_sian_green_party" BIGINT  -- London Mayor-2nd Choice-Berry Sian - Green Party,
  "london_mayor_2nd_choice_craig_alan_christian_peoples_a_062ed1f8" BIGINT  -- London Mayor-2nd Choice-Craig Alan - Christian Peoples Alliance And Christian Party,
  "london_mayor_2nd_choice_german_lindsey_ann_left_list" BIGINT  -- London Mayor-2nd Choice-German Lindsey Ann - Left List,
  "london_mayor_2nd_choice_johnson_boris_conservative_party" BIGINT  -- London Mayor-2nd Choice-Johnson Boris - Conservative Party,
  "london_mayor_2nd_choice_livingstone_ken_the_labour_par_1e319a84" BIGINT  -- London Mayor-2nd Choice-Livingstone Ken - The Labour Party Candidate,
  "london_mayor_2nd_choice_mckenzie_winston_truman_independent" BIGINT  -- London Mayor-2nd Choice-McKenzie Winston Truman - Independent,
  "london_mayor_2nd_choice_o_connor_matt_english_democrats" BIGINT  -- London Mayor-2nd Choice-O'Connor Matt - English Democrats,
  "london_mayor_2nd_choice_paddick_brian_lenoard_liberal_democrats" BIGINT  -- London Mayor-2nd Choice-Paddick Brian Lenoard - Liberal Democrats,
  "london_mayor_2nd_choice_total_good" BIGINT,
  "london_mayor_2nd_choice_spoils_unmarked" BIGINT,
  "london_mayor_2nd_choice_spoils_voting_for_too_many" BIGINT,
  "london_mayor_2nd_choice_spoils_uncertain" BIGINT,
  "london_mayor_2nd_choice_spoils_total_spoils" BIGINT,
  "london_mayor" BIGINT  -- London Mayor-,
  "london_mayor_1" DOUBLE  -- London Mayor-.1,
  "london_member" BIGINT  -- London Member-,
  "london_member_1" BIGINT  -- London Member-.1,
  "london_member_2" BIGINT  -- London Member-.2,
  "london_member_3" BIGINT  -- London Member-.3,
  "london_member_4" BIGINT  -- London Member-.4,
  "london_member_5" BIGINT  -- London Member-.5,
  "london_member_6" BIGINT  -- London Member-.6,
  "london_member_7" BIGINT  -- London Member-.7,
  "london_member_8" BIGINT  -- London Member-.8,
  "london_member_9" BIGINT  -- London Member-.9,
  "london_member_10" BIGINT  -- London Member-.10,
  "london_member_11" BIGINT  -- London Member-.11,
  "london_member_12" BIGINT  -- London Member-.12,
  "london_member_13" BIGINT  -- London Member-.13,
  "london_member_14" BIGINT  -- London Member-.14,
  "london_member_spoils_want_of_official_mark" BIGINT,
  "london_member_spoils_voting_for_too_many" BIGINT,
  "london_member_spoils_writing_identifying_voter" BIGINT,
  "london_member_spoils_unmarked" BIGINT,
  "london_member_spoils_uncertain" BIGINT,
  "london_member_spoils_total_spoils" BIGINT,
  "london_member_15" DOUBLE  -- London Member-.15,
  "constituency_member" BIGINT  -- Constituency Member-,
  "constituency_member_1" BIGINT  -- Constituency Member-.1,
  "constituency_member_2" BIGINT  -- Constituency Member-.2,
  "constituency_member_3" BIGINT  -- Constituency Member-.3,
  "constituency_member_4" BIGINT  -- Constituency Member-.4,
  "constituency_member_5" BIGINT  -- Constituency Member-.5,
  "constituency_member_6" BIGINT  -- Constituency Member-.6,
  "constituency_member_7" BIGINT  -- Constituency Member-.7,
  "constituency_member_8" BIGINT  -- Constituency Member-.8,
  "constituency_member_9" BIGINT  -- Constituency Member-.9,
  "constituency_member_10" BIGINT  -- Constituency Member-.10,
  "constituency_member_11" BIGINT  -- Constituency Member-.11,
  "constituency_member_12" BIGINT  -- Constituency Member-.12,
  "constituency_member_spoils_want_of_official_mark" BIGINT,
  "constituency_member_spoils_voting_for_too_many" BIGINT,
  "constituency_member_spoils_writing_identifying_voter" BIGINT,
  "constituency_member_spoils_unmarked" BIGINT,
  "constituency_member_spoils_uncertain" BIGINT,
  "constituency_member_spoils_total_spoils" BIGINT,
  "constituency_member_13" VARCHAR  -- Constituency Member-.13,
  "constituency_member_14" VARCHAR  -- Constituency Member-.14,
  "constituency_member_15" VARCHAR  -- Constituency Member-.15,
  "constituency_member_16" VARCHAR  -- Constituency Member-.16,
  "constituency_member_17" VARCHAR  -- Constituency Member-.17,
  "constituency_member_18" VARCHAR  -- Constituency Member-.18,
  "constituency_member_19" VARCHAR  -- Constituency Member-.19,
  "constituency_member_20" VARCHAR  -- Constituency Member-.20,
  "constituency_member_21" VARCHAR  -- Constituency Member-.21,
  "constituency_member_22" VARCHAR  -- Constituency Member-.22,
  "constituency_member_23" VARCHAR  -- Constituency Member-.23,
  "constituency_member_24" VARCHAR  -- Constituency Member-.24
);