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

94.86 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_batten_gerard_joseph_uk_indpen_4d7ab8d3" BIGINT,
  "london_mayor_1st_choice_berry_sian_green_party" BIGINT,
  "london_mayor_1st_choice_craig_alan_christian_peoples_a_ee3ac8ba" BIGINT,
  "london_mayor_1st_choice_german_lindsey_ann_left_list" BIGINT,
  "london_mayor_1st_choice_johnson_boris_conservative_party" BIGINT,
  "london_mayor_1st_choice_livingstone_ken_the_labour_par_e611a08a" BIGINT,
  "london_mayor_1st_choice_mckenzie_winston_truman_independent" BIGINT,
  "london_mayor_1st_choice_o_connor_matt_english_democrats" BIGINT,
  "london_mayor_1st_choice_paddick_brian_lenoard_liberal_democrats" BIGINT,
  "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_batten_gerard_joseph_uk_indpen_71431b60" BIGINT,
  "london_mayor_2nd_choice_berry_sian_green_party" BIGINT,
  "london_mayor_2nd_choice_craig_alan_christian_peoples_a_062ed1f8" BIGINT,
  "london_mayor_2nd_choice_german_lindsey_ann_left_list" BIGINT,
  "london_mayor_2nd_choice_johnson_boris_conservative_party" BIGINT,
  "london_mayor_2nd_choice_livingstone_ken_the_labour_par_1e319a84" BIGINT,
  "london_mayor_2nd_choice_mckenzie_winston_truman_independent" BIGINT,
  "london_mayor_2nd_choice_o_connor_matt_english_democrats" BIGINT,
  "london_mayor_2nd_choice_paddick_brian_lenoard_liberal_democrats" BIGINT,
  "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_1" DOUBLE,
  "london_member" BIGINT,
  "london_member_1" BIGINT,
  "london_member_2" BIGINT,
  "london_member_3" BIGINT,
  "london_member_4" BIGINT,
  "london_member_5" BIGINT,
  "london_member_6" BIGINT,
  "london_member_7" BIGINT,
  "london_member_8" BIGINT,
  "london_member_9" BIGINT,
  "london_member_10" BIGINT,
  "london_member_11" BIGINT,
  "london_member_12" BIGINT,
  "london_member_13" BIGINT,
  "london_member_14" BIGINT,
  "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,
  "constituency_member" BIGINT,
  "constituency_member_1" BIGINT,
  "constituency_member_2" BIGINT,
  "constituency_member_3" BIGINT,
  "constituency_member_4" BIGINT,
  "constituency_member_5" BIGINT,
  "constituency_member_6" BIGINT,
  "constituency_member_7" BIGINT,
  "constituency_member_8" BIGINT,
  "constituency_member_9" BIGINT,
  "constituency_member_10" BIGINT,
  "constituency_member_11" BIGINT,
  "constituency_member_12" BIGINT,
  "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_14" VARCHAR,
  "constituency_member_15" VARCHAR,
  "constituency_member_16" VARCHAR,
  "constituency_member_17" VARCHAR,
  "constituency_member_18" VARCHAR,
  "constituency_member_19" VARCHAR,
  "constituency_member_20" VARCHAR,
  "constituency_member_21" VARCHAR,
  "constituency_member_22" VARCHAR,
  "constituency_member_23" VARCHAR,
  "constituency_member_24" VARCHAR
);