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

201.87 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,
  "london_mayor_winner" VARCHAR,
  "london_mayor_1st_choice_siobhan_benita" BIGINT,
  "london_mayor_2nd_choice_carlos_cortiglia_british_national_party" BIGINT,
  "london_mayor_3rd_choice_boris_johnson_the_conservative_069791c6" BIGINT,
  "london_mayor_4th_choice_jenny_jones_green_party" BIGINT,
  "london_mayor_5th_choice_ken_livingstone_the_labour_par_7244111d" BIGINT,
  "london_mayor_6th_choice_brian_paddick_london_liberal_democrats" BIGINT,
  "london_mayor_7th_choice_lawrence_james_webb_fresh_choi_033fd263" BIGINT,
  "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_4th_choice_boris_johnson_the_conservative_0f0a82b5" BIGINT,
  "london_mayor_5th_choice_jenny_jones_green_party" BIGINT,
  "london_mayor_6th_choice_ken_livingstone_the_labour_par_72c468de" BIGINT,
  "london_mayor_7th_choice_brian_paddick_london_liberal_democrats" BIGINT,
  "london_mayor_8th_choice_lawrence_james_webb_fresh_choi_8ed72c3f" BIGINT,
  "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_conservative_party" BIGINT,
  "london_member_english_democrats_putting_england_first" BIGINT,
  "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_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_greenwich_lewisham_people_before_profit" DOUBLE,
  "constituency_member_communities_united_party" DOUBLE,
  "constituency_member_national_front" DOUBLE,
  "constituency_member_independent1_ne" DOUBLE,
  "constituency_member_the_socialist_party_gb" DOUBLE,
  "constituency_member_english_democrats" DOUBLE,
  "constituency_member_independent2_m_w" DOUBLE,
  "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_greenwich_lewisham_5df0fa99" VARCHAR,
  "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_the_socialist_party_gb" VARCHAR,
  "constituency_member_candidate_names_english_democrats" VARCHAR,
  "constituency_member_candidate_names_independent2_m_w" VARCHAR,
  "constituency_member_candidate_names_communist_league" VARCHAR
);