About this Dataset

London Elections Results 2012, Wards, Boroughs, Constituency

DATA ---- The results for the Mayoral and Assembly elections down to constituency level are available (including turnout and spoils etc). The full 2012 election results for Mayor and Assembly for: \- Wards, Boroughs and Constituencies (includes postal votes data, turnout figures, and first by second Mayoral vote matrices) \- Constituencies only (includes percentages) MAPPING ------- The 2000-2012 election data for wards, boroughs, and constituencies in summary format is presented using interactive maps and charts in an InstantAtlas report. \- if you have a browser that supports HTML5 check out our Instant Atlas report of the report (Firefox, Chrome, Safari or IE9 support this). This data for all three levels of geography is presented in these reports. This includes interactive map, table, bar chart, and trend chart. SUMMARY ------- The election results in summary format for 2000 to 2012 for: * Constituencies only * Wards, Boroughs and Constituencies Note: In a few instances the electorate figure has been revised since the initial declared result. This has led to a small change in some turnout figures. The spreadsheets above all contain the correct revised figures. The spreadsheet contains a summary of all the London elections results since 2000. This includes Mayoral, Assembly list and Constituency member election results. In the 2000 election, only data for constituencies was collected, so no borough or ward breakdowns are available for that year. Data shown includes: \- the winner in each area (the candidate or party with most votes). This does not include second preference votes in the Mayoral election, \- the winning majority (the highest number of votes minus the second highest number of votes), \- the percentage turnout figure. (note for wards this is indicative only since all postal votes are registered to borough level only), and \- the percentage of votes for each of the major parties. Note that only parties with at least 5 per cent of the vote across London in at least one year of elections are shown. All other parties are aggregated into 'Other'. INFOGRAPHIC ----------- The GLA Intelligence Unit has produced this infographic below (London Election Results By Numbers), presenting the key facts from these elections. Access further detail and reports for all elections from the Elections page. Or visit the London Elects website
Publisher name: Greater London Authority
Last updated: 2024-09-14T08:01:37Z

Tables

Gla-elections-votes-ward-2012-+Wards+&+Postals

@ukgov.london_elections_results_2012_wards_boroughs_constituency.gla_elections_votes_ward_2012_wards_postals

206.71 kB
659 rows
94 columns

CREATE TABLE gla_elections_votes_ward_2012_wards_postals (
  "ward" VARCHAR,
  "geog_level" VARCHAR,
  "constituency" VARCHAR,
  "borough" VARCHAR,
  "ward_name" VARCHAR,
  "turnout_turnout" BIGINT,
  "turnout_electorate" BIGINT,
  "turnout_turnout_e1ecb3" VARCHAR  -- Turnout;Turnout %,
  "london_mayor_winner" VARCHAR,
  "london_mayor_1st_choice_siobhan_benita" BIGINT,
  "london_mayor_2nd_choice_carlos_cortiglia_british_national_party" BIGINT  -- London Mayor;2nd Choice;Carlos Cortiglia - British National Party,
  "london_mayor_3rd_choice_boris_johnson_the_conservative_069791c6" BIGINT  -- London Mayor;3rd Choice;Boris Johnson - The Conservative Party Candidate,
  "london_mayor_4th_choice_jenny_jones_green_party" BIGINT  -- London Mayor;4th Choice;Jenny Jones - Green Party,
  "london_mayor_5th_choice_ken_livingstone_the_labour_par_7244111d" BIGINT  -- London Mayor;5th Choice;Ken Livingstone - The Labour Party Candidate,
  "london_mayor_6th_choice_brian_paddick_london_liberal_democrats" BIGINT  -- London Mayor;6th Choice;Brian Paddick - London Liberal Democrats,
  "london_mayor_7th_choice_lawrence_james_webb_fresh_choi_033fd263" BIGINT  -- London Mayor;7th Choice;Lawrence James Webb - Fresh Choice For London,
  "london_mayor_8th_choice_total_good" BIGINT,
  "london_mayor_1st_choice_spoils_want_of_official_mark" BIGINT,
  "london_mayor_2nd_choice_spoils_writing_identifying_voter" BIGINT,
  "london_mayor_3rd_choice_spoils_unmarked" BIGINT,
  "london_mayor_4th_choice_spoils_uncertain" BIGINT,
  "london_mayor_5th_choice_spoils_voting_for_too_many" BIGINT,
  "london_mayor_6th_choice_spoils_total_spoils" BIGINT,
  "london_mayor_2nd_choice_siobhan_benita" BIGINT,
  "london_mayor_3rd_choice_carlos_cortiglia_british_national_party" BIGINT  -- London Mayor;3rd Choice;Carlos Cortiglia - British National Party,
  "london_mayor_4th_choice_boris_johnson_the_conservative_0f0a82b5" BIGINT  -- London Mayor;4th Choice;Boris Johnson - The Conservative Party Candidate,
  "london_mayor_5th_choice_jenny_jones_green_party" BIGINT  -- London Mayor;5th Choice;Jenny Jones - Green Party,
  "london_mayor_6th_choice_ken_livingstone_the_labour_par_72c468de" BIGINT  -- London Mayor;6th Choice;Ken Livingstone - The Labour Party Candidate,
  "london_mayor_7th_choice_brian_paddick_london_liberal_democrats" BIGINT  -- London Mayor;7th Choice;Brian Paddick - London Liberal Democrats,
  "london_mayor_8th_choice_lawrence_james_webb_fresh_choi_8ed72c3f" BIGINT  -- London Mayor;8th Choice;Lawrence James Webb - Fresh Choice For London,
  "london_mayor_9th_choice_total_good" BIGINT,
  "london_mayor_2nd_choice_spoils_unmarked" BIGINT,
  "london_mayor_3rd_choice_spoils_uncertain" BIGINT,
  "london_mayor_4th_choice_spoils_voting_for_too_many" BIGINT,
  "london_mayor_5th_choice_spoils_total_spoils" BIGINT,
  "london_member_winner" VARCHAR,
  "london_member_british_national_party" BIGINT,
  "london_member_christian_peoples_alliance_supporting_tr_02212656" BIGINT  -- London Member;Christian Peoples Alliance - Supporting Traditional Marriage,
  "london_member_conservative_party" BIGINT,
  "london_member_english_democrats_putting_england_first" BIGINT  -- London Member;English Democrats - "Putting England First!",
  "london_member_green_party" BIGINT,
  "london_member_labour_party" BIGINT,
  "london_member_london_liberal_democrats" BIGINT,
  "london_member_national_front_putting_londoners_first" BIGINT,
  "london_member_the_house_party_homes_for_londoners" BIGINT  -- London Member;The House Party - Homes For Londoners,
  "london_member_trade_unionist_and_socialist_coalition" BIGINT,
  "london_member_uk_independence_party" BIGINT,
  "london_member_rathy_alagaratnam" BIGINT,
  "london_member_ijaz_hayat" BIGINT,
  "london_member_total_good" BIGINT,
  "london_member_spoils_want_of_official_mark" BIGINT,
  "london_member_spoils_writing_identifying_voter" BIGINT,
  "london_member_spoils_unmarked" BIGINT,
  "london_member_spoils_uncertain" BIGINT,
  "london_member_spoils_voting_for_too_many" BIGINT,
  "london_member_spoils_total_spoils" BIGINT,
  "constituency_member_winner" VARCHAR,
  "constituency_member_labour" BIGINT,
  "constituency_member_conservative" BIGINT,
  "constituency_member_liberal_democrat" BIGINT,
  "constituency_member_green" BIGINT,
  "constituency_member_uk_independence_party" BIGINT,
  "constituency_member_british_national_party" DOUBLE,
  "constituency_member_residents_association_of_london" DOUBLE  -- Constituency Member;Residents' Association Of London,
  "constituency_member_greenwich_lewisham_people_before_profit" DOUBLE  -- Constituency Member;Greenwich & Lewisham People Before Profit,
  "constituency_member_communities_united_party" DOUBLE,
  "constituency_member_national_front" DOUBLE,
  "constituency_member_independent1_ne" DOUBLE  -- Constituency Member;Independent1 (NE),
  "constituency_member_the_socialist_party_gb" DOUBLE  -- Constituency Member;The Socialist Party (GB),
  "constituency_member_english_democrats" DOUBLE,
  "constituency_member_independent2_m_w" DOUBLE  -- Constituency Member;Independent2 (M&W),
  "constituency_member_communist_league" DOUBLE,
  "constituency_member_total_good" BIGINT,
  "constituency_member_spoils_want_of_official_mark" BIGINT,
  "constituency_member_spoils_writing_identifying_voter" BIGINT,
  "constituency_member_spoils_unmarked" BIGINT,
  "constituency_member_spoils_uncertain" BIGINT,
  "constituency_member_spoils_voting_for_too_many" BIGINT,
  "constituency_member_spoils_total_spoils" BIGINT,
  "constituency_member_candidate_names_labour" VARCHAR,
  "constituency_member_candidate_names_conservative" VARCHAR,
  "constituency_member_candidate_names_liberal_democrat" VARCHAR,
  "constituency_member_candidate_names_green" VARCHAR,
  "constituency_member_candidate_names_uk_independence_party" VARCHAR,
  "constituency_member_candidate_names_british_national_party" VARCHAR,
  "constituency_member_candidate_names_residents_associat_48ddbded" VARCHAR  -- Constituency Member;Candidate Names;Residents' Association Of London,
  "constituency_member_candidate_names_greenwich_lewisham_5df0fa99" VARCHAR  -- Constituency Member;Candidate Names;Greenwich & Lewisham People Before Profit,
  "constituency_member_candidate_names_communities_united_party" VARCHAR,
  "constituency_member_candidate_names_national_front" VARCHAR,
  "constituency_member_candidate_names_independent1_ne" VARCHAR  -- Constituency Member;Candidate Names;Independent1 (NE),
  "constituency_member_candidate_names_the_socialist_party_gb" VARCHAR  -- Constituency Member;Candidate Names;The Socialist Party (GB),
  "constituency_member_candidate_names_english_democrats" VARCHAR,
  "constituency_member_candidate_names_independent2_m_w" VARCHAR  -- Constituency Member;Candidate Names;Independent2 (M&W),
  "constituency_member_candidate_names_communist_league" VARCHAR
);