London Elections Results 2004, Borough
Greater London Authority
@ukgov.london_elections_results_2004_borough
Greater London Authority
@ukgov.london_elections_results_2004_borough
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
);
Anyone who has the link will be able to view this.