European Election Results 2004
Greater London Authority
@ukgov.european_election_results_2004
Greater London Authority
@ukgov.european_election_results_2004
CREATE TABLE european_elections_votes_party_borough_2004 (
"code" VARCHAR,
"borough" VARCHAR,
"number_votes_conservatives" BIGINT,
"number_votes_labour" BIGINT,
"number_votes_liberal_democrats" BIGINT,
"number_votes_green" BIGINT,
"number_votes_ukip" BIGINT,
"number_votes_bnp" BIGINT,
"number_votes_christian_peoples_alliance" BIGINT,
"number_votes_english_democrats" BIGINT,
"number_votes_respect_the_unity_coalition" BIGINT,
"number_votes_peoples_party_for_better_government" BIGINT,
"number_votes_total_good_votes" BIGINT,
"number_spoils_uncertain_or_blank" BIGINT,
"number_spoils_voting_for_too_many_candidates" BIGINT,
"number_spoils_writing_a_mark_by_which_the_voter_could__c30ce738" BIGINT,
"number_spoils_lack_of_official_mark" BIGINT,
"number_spoils_total_spoils" BIGINT,
"electorate" BIGINT,
"ballot_papers" BIGINT,
"percent_poll" DOUBLE,
"percent_good_votes_conservatives" DOUBLE,
"percent_good_votes_labour" DOUBLE,
"percent_good_votes_liberal_democrats" DOUBLE,
"percent_good_votes_green" DOUBLE,
"percent_good_votes_ukip" DOUBLE,
"percent_good_votes_bnp" DOUBLE,
"percent_good_votes_christian_peoples_alliance" DOUBLE,
"percent_good_votes_english_democrats" DOUBLE,
"percent_good_votes_respect_the_unity_coalition" DOUBLE,
"percent_good_votes_peoples_party_for_better_government" DOUBLE,
"percent_good_votes_total_good_votes" BIGINT,
"total_spoils_as_percent_good_votes" DOUBLE
);
Anyone who has the link will be able to view this.