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-Respect - The Unity Coalition,
  "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-Writing A Mark By Which The Voter Could Be Identified,
  "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-Respect - The Unity Coalition,
  "percent_good_votes_peoples_party_for_better_government" DOUBLE,
  "percent_good_votes_total_good_votes" BIGINT,
  "total_spoils_as_percent_good_votes" DOUBLE
);