European Election Results 2009
Greater London Authority
@ukgov.european_election_results_2009
Greater London Authority
@ukgov.european_election_results_2009
CREATE TABLE european_elections_votes_party_borough_2009 (
"code" VARCHAR,
"authority" VARCHAR,
"eligible_electors" BIGINT,
"verified_ballots" BIGINT,
"turnout" DOUBLE,
"conservative_party_votes" BIGINT,
"the_labour_party_votes" BIGINT,
"liberal_democrats_votes" BIGINT,
"the_green_party_votes" BIGINT,
"united_kingdom_independence_party_votes" BIGINT,
"british_national_party_votes" BIGINT,
"christian_party_proclaiming_christ_s_lordship_votes" BIGINT,
"jan_jananayagam_votes" BIGINT,
"english_democrats_party_votes" BIGINT,
"no2eu_yes_to_democracy_votes" BIGINT,
"socialist_labour_party_votes" BIGINT,
"pro_democracy_libertas_eu_votes" BIGINT,
"jury_team_votes" BIGINT,
"steven_cheung_votes" BIGINT,
"the_socialist_party_of_great_britain_votes" BIGINT,
"yes_2_europe_votes" BIGINT,
"sohale_rahman_votes" BIGINT,
"gene_alcantara_votes" BIGINT,
"haroon_saad_votes" BIGINT,
"total_party_votes" BIGINT,
"total_rejected_votes" BIGINT,
"conservative_party_percent_good_votes" DOUBLE,
"the_labour_party_percent_good_votes" DOUBLE,
"liberal_democrats_percent_good_votes" DOUBLE,
"the_green_party_percent_good_votes" DOUBLE,
"united_kingdom_independence_party_percent_good_votes" DOUBLE,
"british_national_party_percent_good_votes" DOUBLE,
"christian_party_proclaiming_christ_s_lordship_percent__ad4538f8" DOUBLE,
"jan_jananayagam_percent_good_votes" DOUBLE,
"english_democrats_party_percent_good_votes" DOUBLE,
"no2eu_yes_to_democracy_percent_good_votes" DOUBLE,
"socialist_labour_party_percent_good_votes" DOUBLE,
"pro_democracy_libertas_eu_percent_good_votes" DOUBLE,
"jury_team_percent_good_votes" DOUBLE,
"steven_cheung_percent_good_votes" DOUBLE,
"the_socialist_party_of_great_britain_percent_good_votes" DOUBLE,
"yes_2_europe_percent_good_votes" DOUBLE,
"sohale_rahman_percent_good_votes" DOUBLE,
"gene_alcantara_percent_good_votes" DOUBLE,
"haroon_saad_percent_good_votes" DOUBLE
);
Anyone who has the link will be able to view this.