Baselight

London Elections Results 2004, Borough

Greater London Authority

@ukgov.london_elections_results_2004_borough

Loading...
Loading...

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
  • 90.26 KB
  • 34 rows
  • 78 columns
Loading...

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_balram_gidoomal_known_as_ram_c_7299756e" BIGINT,
  "london_mayor_1st_choice_simon_henry_ward_hughes_libera_bd880060" BIGINT,
  "london_mayor_1st_choice_darren_johnson_green_party_candidate" BIGINT,
  "london_mayor_1st_choice_julian_peter_leppert_british_n_a9aebb23" BIGINT,
  "london_mayor_1st_choice_kenneth_robert_livingstone_the_dfe3b7e1" BIGINT,
  "london_mayor_1st_choice_francis_maloney_known_as_frank_7c20382e" BIGINT,
  "london_mayor_1st_choice_puvanarani_tammy_dr_nagalingam_ind" BIGINT,
  "london_mayor_1st_choice_steven_john_norris_conservativ_65e61cf6" BIGINT,
  "london_mayor_1st_choice_lorna_reid_independent_working_b715aee6" BIGINT,
  "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_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_balram_gidoomal_known_as_ram_c_ea09c83e" BIGINT,
  "london_mayor_2nd_choice_simon_henry_ward_hughes_libera_baa8cc30" BIGINT,
  "london_mayor_2nd_choice_darren_johnson_green_party_candidate" BIGINT,
  "london_mayor_2nd_choice_julian_peter_leppert_british_n_2c12b346" BIGINT,
  "london_mayor_2nd_choice_kenneth_robert_livingstone_the_35470560" BIGINT,
  "london_mayor_2nd_choice_francis_maloney_known_as_frank_47a78d88" BIGINT,
  "london_mayor_2nd_choice_puvanarani_tammy_dr_nagalingam_ind" BIGINT,
  "london_mayor_2nd_choice_steven_john_norris_conservativ_4472ea7b" BIGINT,
  "london_mayor_2nd_choice_lorna_reid_independent_working_376dd3bf" BIGINT,
  "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_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_lack_of_official_mark" BIGINT,
  "london_member_spoils_total_spoils" BIGINT,
  "london_member_poll_turnout" DOUBLE,
  "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_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
);

Share link

Anyone who has the link will be able to view this.