Real Time Election Results: Portugal 2019 Data Set
Real Time Election Results: Portugal 2019 Data Set
@kaggle.ishandutta_real_time_election_results_portugal_2019_data_set
Real Time Election Results: Portugal 2019 Data Set
@kaggle.ishandutta_real_time_election_results_portugal_2019_data_set
CREATE TABLE electiondata (
"timeelapsed" BIGINT,
"time" TIMESTAMP,
"territoryname" VARCHAR,
"totalmandates" BIGINT,
"availablemandates" BIGINT,
"numparishes" BIGINT,
"numparishesapproved" BIGINT,
"blankvotes" BIGINT,
"blankvotespercentage" DOUBLE,
"nullvotes" BIGINT,
"nullvotespercentage" DOUBLE,
"voterspercentage" DOUBLE,
"subscribedvoters" BIGINT,
"totalvoters" BIGINT,
"pre_blankvotes" BIGINT,
"pre_blankvotespercentage" DOUBLE,
"pre_nullvotes" BIGINT,
"pre_nullvotespercentage" DOUBLE,
"pre_voterspercentage" DOUBLE,
"pre_subscribedvoters" BIGINT,
"pre_totalvoters" BIGINT,
"party" VARCHAR,
"mandates" BIGINT,
"percentage" DOUBLE,
"validvotespercentage" DOUBLE,
"votes" BIGINT,
"hondt" BIGINT,
"finalmandates" BIGINT
);
CREATE TABLE freguesias_metadata (
"nivel" BIGINT,
"distrito" VARCHAR,
"concelho" VARCHAR,
"freguesia" VARCHAR,
"dicofre" VARCHAR,
"brasao" VARCHAR
);
CREATE TABLE overall_results (
"time" TIMESTAMP,
"territoryfullname" VARCHAR,
"territoryname" VARCHAR,
"territorykey" VARCHAR,
"totalmandates" DOUBLE,
"availablemandates" BIGINT,
"numparishes" DOUBLE,
"numparishesapproved" DOUBLE,
"blankvotes" DOUBLE,
"blankvotespercentage" DOUBLE,
"nullvotes" DOUBLE,
"nullvotespercentage" DOUBLE,
"voterspercentage" DOUBLE,
"subscribedvoters" DOUBLE,
"totalvoters" DOUBLE,
"pre_totalmandates" DOUBLE,
"pre_availablemandates" BIGINT,
"pre_blankvotes" DOUBLE,
"pre_blankvotespercentage" DOUBLE,
"pre_nullvotes" DOUBLE,
"pre_nullvotespercentage" DOUBLE,
"pre_voterspercentage" DOUBLE,
"pre_subscribedvoters" DOUBLE,
"pre_totalvoters" DOUBLE
);
CREATE TABLE parishes (
"time" TIMESTAMP,
"territoryfullname" VARCHAR,
"territoryname" VARCHAR,
"territorykey" VARCHAR,
"totalmandates" VARCHAR,
"availablemandates" BIGINT,
"numparishes" BIGINT,
"numparishesapproved" BIGINT,
"blankvotes" BIGINT,
"blankvotespercentage" DOUBLE,
"nullvotes" BIGINT,
"nullvotespercentage" DOUBLE,
"voterspercentage" DOUBLE,
"subscribedvoters" BIGINT,
"totalvoters" BIGINT,
"pre_totalmandates" VARCHAR,
"pre_availablemandates" BIGINT,
"pre_blankvotes" BIGINT,
"pre_blankvotespercentage" DOUBLE,
"pre_nullvotes" BIGINT,
"pre_nullvotespercentage" DOUBLE,
"pre_voterspercentage" DOUBLE,
"pre_subscribedvoters" BIGINT,
"pre_totalvoters" BIGINT,
"council" VARCHAR,
"district" VARCHAR
);
CREATE TABLE votes (
"time" TIMESTAMP,
"district" VARCHAR,
"party" VARCHAR,
"mandates" BIGINT,
"percentage" DOUBLE,
"validvotespercentage" DOUBLE,
"votes" BIGINT
);
CREATE TABLE votes_parishes (
"district" VARCHAR,
"party" VARCHAR,
"percentage" DOUBLE,
"validvotespercentage" DOUBLE,
"votes" BIGINT,
"council" VARCHAR,
"district_1" VARCHAR
);
Anyone who has the link will be able to view this.