About this Dataset

London Elections Results 2004, Borough

Mayoral and London Assembly votes, spoils and turnout from 2004. Election results from London elections on 10 June 2004. Data from the elections in 2000 is not available at a borough level since it was never collected, though the report does provide comparisons with all available data from the 2000 elections ie Constituency level data. There is a seperate page for 2000 data. Elections covered in the data are London Mayor (first and second choice), London member (list), GLA Constituency member, and European Parliament. Read a the full report in PDF. Download the ward data for all elections
Publisher name: Greater London Authority
Last updated: 2024-09-14T07:53:01Z

Tables

Gla-elections-votes-party-borough-2004

@ukgov.london_elections_results_2004_borough.gla_elections_votes_party_borough_2004

92.43 kB
34 rows
78 columns

CREATE TABLE gla_elections_votes_party_borough_2004 (
  "code" VARCHAR,
  "borough" VARCHAR,
  "constituency" VARCHAR,
  "london_mayor_1st_choice_lindsey_ann_german_respect_the_3dcfaaab" BIGINT  -- London Mayor-1st Choice-Lindsey Ann GERMAN - Respect The Unity Coalition George Galloway,
  "london_mayor_1st_choice_balram_gidoomal_known_as_ram_c_7299756e" BIGINT  -- London Mayor-1st Choice-Balram GIDOOMAL Known As Ram - Christian Peoples Alliance,
  "london_mayor_1st_choice_simon_henry_ward_hughes_libera_bd880060" BIGINT  -- London Mayor-1st Choice-Simon Henry Ward HUGHES - Liberal Democrats,
  "london_mayor_1st_choice_darren_johnson_green_party_candidate" BIGINT  -- London Mayor-1st Choice-Darren JOHNSON - Green Party Candidate,
  "london_mayor_1st_choice_julian_peter_leppert_british_n_a9aebb23" BIGINT  -- London Mayor-1st Choice-Julian Peter LEPPERT - British National Party,
  "london_mayor_1st_choice_kenneth_robert_livingstone_the_dfe3b7e1" BIGINT  -- London Mayor-1st Choice-Kenneth Robert LIVINGSTONE - The Labour Party,
  "london_mayor_1st_choice_francis_maloney_known_as_frank_7c20382e" BIGINT  -- London Mayor-1st Choice-Francis MALONEY Known As Frank - UK Independence Party,
  "london_mayor_1st_choice_puvanarani_tammy_dr_nagalingam_ind" BIGINT  -- London Mayor-1st Choice-Puvanarani Tammy Dr.NAGALINGAM - Ind,
  "london_mayor_1st_choice_steven_john_norris_conservativ_65e61cf6" BIGINT  -- London Mayor-1st Choice-Steven John NORRIS - Conservative And Unionist Party,
  "london_mayor_1st_choice_lorna_reid_independent_working_b715aee6" BIGINT  -- London Mayor-1st Choice-Lorna REID - Independent Working Class Association,
  "london_mayor_1st_choice_total_good_votes" BIGINT,
  "london_mayor_1st_choice_spoils_uncertain_or_blank" BIGINT,
  "london_mayor_1st_choice_spoils_voting_for_too_many_candidates" BIGINT,
  "london_mayor_1st_choice_spoils_writing_a_mark_by_which_eb738bbb" BIGINT  -- London Mayor-1st Choice Spoils-Writing A Mark By Which The Voter Could Be Identified,
  "london_mayor_1st_choice_spoils_lack_of_official_mark" BIGINT,
  "london_mayor_1st_choice_spoils_total_spoils" BIGINT,
  "london_mayor_2nd_choice_lindsey_ann_german_respect_the_23b18946" BIGINT  -- London Mayor-2nd Choice-Lindsey Ann GERMAN - Respect The Unity Coalition George Galloway,
  "london_mayor_2nd_choice_balram_gidoomal_known_as_ram_c_ea09c83e" BIGINT  -- London Mayor-2nd Choice-Balram GIDOOMAL Known As Ram - Christian Peoples Alliance,
  "london_mayor_2nd_choice_simon_henry_ward_hughes_libera_baa8cc30" BIGINT  -- London Mayor-2nd Choice-Simon Henry Ward HUGHES - Liberal Democrats,
  "london_mayor_2nd_choice_darren_johnson_green_party_candidate" BIGINT  -- London Mayor-2nd Choice-Darren JOHNSON - Green Party Candidate,
  "london_mayor_2nd_choice_julian_peter_leppert_british_n_2c12b346" BIGINT  -- London Mayor-2nd Choice-Julian Peter LEPPERT - British National Party,
  "london_mayor_2nd_choice_kenneth_robert_livingstone_the_35470560" BIGINT  -- London Mayor-2nd Choice-Kenneth Robert LIVINGSTONE - The Labour Party,
  "london_mayor_2nd_choice_francis_maloney_known_as_frank_47a78d88" BIGINT  -- London Mayor-2nd Choice-Francis MALONEY Known As Frank - UK Independence Party,
  "london_mayor_2nd_choice_puvanarani_tammy_dr_nagalingam_ind" BIGINT  -- London Mayor-2nd Choice-Puvanarani Tammy Dr.NAGALINGAM - Ind,
  "london_mayor_2nd_choice_steven_john_norris_conservativ_4472ea7b" BIGINT  -- London Mayor-2nd Choice-Steven John NORRIS - Conservative And Unionist Party,
  "london_mayor_2nd_choice_lorna_reid_independent_working_376dd3bf" BIGINT  -- London Mayor-2nd Choice-Lorna REID - Independent Working Class Association,
  "london_mayor_2nd_choice_total_good_votes" BIGINT,
  "london_mayor_2st_choice_spoils_no_valid_first_choice" BIGINT,
  "london_mayor_2st_choice_spoils_uncertain_or_blank" BIGINT,
  "london_mayor_2st_choice_spoils_voting_for_too_many_candidates" BIGINT,
  "london_mayor_2st_choice_spoils_total_spoils" BIGINT,
  "london_mayor_assembly_electorate" BIGINT,
  "london_mayor_poll_turnout" DOUBLE  -- London Mayor-% Poll Turnout,
  "london_member_alliance_for_diversity_in_community_uppal" BIGINT,
  "london_member_british_national_party" BIGINT,
  "london_member_christian_peoples_alliance" BIGINT,
  "london_member_conservative_and_unionist_party" BIGINT,
  "london_member_the_green_party" BIGINT,
  "london_member_the_labour_party" BIGINT,
  "london_member_liberal_democrats" BIGINT,
  "london_member_respect_the_unity_coalition_george_galloway" BIGINT,
  "london_member_united_kingdom_independence_party" BIGINT,
  "london_member_total_good_votes" BIGINT,
  "london_member_spoils_uncertain_or_blank" BIGINT,
  "london_member_spoils_voting_for_too_many_candidates" BIGINT,
  "london_member_spoils_writing_a_mark_by_which_the_voter_83fe334b" BIGINT  -- London Member-Spoils-Writing A Mark By Which The Voter Could Be Identified,
  "london_member_spoils_lack_of_official_mark" BIGINT,
  "london_member_spoils_total_spoils" BIGINT,
  "london_member_poll_turnout" DOUBLE  -- London Member-% Poll Turnout,
  "constituency_member_candidate_1" BIGINT,
  "constituency_member_candidate_2" BIGINT,
  "constituency_member_candidate_3" BIGINT,
  "constituency_member_candidate_4" BIGINT,
  "constituency_member_candidate_5" BIGINT,
  "constituency_member_candidate_6" BIGINT,
  "constituency_member_candidate_7" BIGINT,
  "constituency_member_candidate_8" VARCHAR,
  "constituency_member_candidate_9" VARCHAR,
  "constituency_member_candidate_10" VARCHAR,
  "constituency_member_total_good_votes" BIGINT,
  "constituency_member_spoils_uncertain_or_blank" BIGINT,
  "constituency_member_spoils_voting_for_too_many_candidates" BIGINT,
  "constituency_member_spoils_writing_a_mark_by_which_the_8a9441b1" BIGINT  -- Constituency Member-Spoils-Writing A Mark By Which The Voter Could Be Identified,
  "constituency_member_spoils_lack_of_official_mark" BIGINT,
  "constituency_member_spoils_total_spoils" BIGINT,
  "constituency_member_candidate_1_1" VARCHAR,
  "constituency_member_candidate_2_1" VARCHAR,
  "constituency_member_candidate_3_1" VARCHAR,
  "constituency_member_candidate_4_1" VARCHAR,
  "constituency_member_candidate_5_1" VARCHAR,
  "constituency_member_candidate_6_1" VARCHAR,
  "constituency_member_candidate_7_1" VARCHAR,
  "constituency_member_candidate_8_1" VARCHAR,
  "constituency_member_candidate_9_1" VARCHAR,
  "constituency_member_candidate_10_1" VARCHAR
);