Name: Portugal Municipal Elections 2025
Creator: jsoares
License: https://creativecommons.org/licenses/by/4.0/

Resultados para Assembleia Municipal agregados por concelho

@jsoares.portugal_municipal_elections_2025.am_concelhos

26.93 kB
1,516 rows
16 columns

CREATE TABLE am_concelhos (
  "election_code" VARCHAR,
  "election_date" DATE,
  "territory_code" VARCHAR,
  "territory_name" VARCHAR,
  "territory_type" VARCHAR,
  "organ" VARCHAR,
  "state" VARCHAR,
  "party" VARCHAR,
  "party_full" VARCHAR,
  "party_type" VARCHAR,
  "votes" BIGINT,
  "votes_pct" DOUBLE,
  "mandates" BIGINT,
  "presidents" VARCHAR,
  "absolute_majorities" VARCHAR,
  "electoral_circles_compete" VARCHAR
);

Participação para Assembleia Municipal agregada por concelho

@jsoares.portugal_municipal_elections_2025.am_concelhos_participacao

18.62 kB
308 rows
18 columns

CREATE TABLE am_concelhos_participacao (
  "election_code" VARCHAR,
  "election_date" DATE,
  "territory_code" VARCHAR,
  "territory_name" VARCHAR,
  "territory_type" VARCHAR,
  "organ" VARCHAR,
  "subscribers" BIGINT,
  "votes" BIGINT,
  "voters_pct" DOUBLE,
  "abstention_pct" DOUBLE,
  "blank_votes" BIGINT,
  "blank_pct" DOUBLE,
  "null_votes" BIGINT,
  "null_pct" DOUBLE,
  "mandates_assigned" BIGINT,
  "mandates_unassigned" BIGINT,
  "mandates_total" BIGINT,
  "state" VARCHAR
);

Resultados para Assembleia Municipal desagregados por freguesia

@jsoares.portugal_municipal_elections_2025.am_freguesias

215.17 kB
17,260 rows
16 columns

CREATE TABLE am_freguesias (
  "election_code" VARCHAR,
  "election_date" DATE,
  "territory_code" VARCHAR,
  "territory_name" VARCHAR,
  "territory_type" VARCHAR,
  "organ" VARCHAR,
  "state" VARCHAR,
  "party" VARCHAR,
  "party_full" VARCHAR,
  "party_type" VARCHAR,
  "votes" BIGINT,
  "votes_pct" DOUBLE,
  "mandates" VARCHAR,
  "presidents" VARCHAR,
  "absolute_majorities" VARCHAR,
  "electoral_circles_compete" VARCHAR
);

Participação para Assembleia Municipal desagregada por freguesia

@jsoares.portugal_municipal_elections_2025.am_freguesias_participacao

127.82 kB
3,259 rows
18 columns

CREATE TABLE am_freguesias_participacao (
  "election_code" VARCHAR,
  "election_date" DATE,
  "territory_code" VARCHAR,
  "territory_name" VARCHAR,
  "territory_type" VARCHAR,
  "organ" VARCHAR,
  "subscribers" BIGINT,
  "votes" BIGINT,
  "voters_pct" DOUBLE,
  "abstention_pct" DOUBLE,
  "blank_votes" BIGINT,
  "blank_pct" DOUBLE,
  "null_votes" BIGINT,
  "null_pct" DOUBLE,
  "mandates_assigned" VARCHAR,
  "mandates_unassigned" VARCHAR,
  "mandates_total" VARCHAR,
  "state" VARCHAR
);

Resultados para Câmara Municipal agregados por concelho

@jsoares.portugal_municipal_elections_2025.cm_concelhos

29.11 kB
1,583 rows
16 columns

CREATE TABLE cm_concelhos (
  "election_code" VARCHAR,
  "election_date" DATE,
  "territory_code" VARCHAR,
  "territory_name" VARCHAR,
  "territory_type" VARCHAR,
  "organ" VARCHAR,
  "state" VARCHAR,
  "party" VARCHAR,
  "party_full" VARCHAR,
  "party_type" VARCHAR,
  "votes" BIGINT,
  "votes_pct" DOUBLE,
  "mandates" BIGINT,
  "presidents" BIGINT,
  "absolute_majorities" BIGINT,
  "electoral_circles_compete" VARCHAR
);

Participação para Câmara Municipal agregada por concelho

@jsoares.portugal_municipal_elections_2025.cm_concelhos_participacao

18.33 kB
308 rows
18 columns

CREATE TABLE cm_concelhos_participacao (
  "election_code" VARCHAR,
  "election_date" DATE,
  "territory_code" VARCHAR,
  "territory_name" VARCHAR,
  "territory_type" VARCHAR,
  "organ" VARCHAR,
  "subscribers" BIGINT,
  "votes" BIGINT,
  "voters_pct" DOUBLE,
  "abstention_pct" DOUBLE,
  "blank_votes" BIGINT,
  "blank_pct" DOUBLE,
  "null_votes" BIGINT,
  "null_pct" DOUBLE,
  "mandates_assigned" BIGINT,
  "mandates_unassigned" BIGINT,
  "mandates_total" BIGINT,
  "state" VARCHAR
);

Resultados para Câmara Municipal desagregados por freguesia

@jsoares.portugal_municipal_elections_2025.cm_freguesias

207.16 kB
17,980 rows
16 columns

CREATE TABLE cm_freguesias (
  "election_code" VARCHAR,
  "election_date" DATE,
  "territory_code" VARCHAR,
  "territory_name" VARCHAR,
  "territory_type" VARCHAR,
  "organ" VARCHAR,
  "state" VARCHAR,
  "party" VARCHAR,
  "party_full" VARCHAR,
  "party_type" VARCHAR,
  "votes" BIGINT,
  "votes_pct" DOUBLE,
  "mandates" VARCHAR,
  "presidents" VARCHAR,
  "absolute_majorities" VARCHAR,
  "electoral_circles_compete" VARCHAR
);

Participação para Câmara Municipal desagregada por freguesia

@jsoares.portugal_municipal_elections_2025.cm_freguesias_participacao

126.48 kB
3,259 rows
18 columns

CREATE TABLE cm_freguesias_participacao (
  "election_code" VARCHAR,
  "election_date" DATE,
  "territory_code" VARCHAR,
  "territory_name" VARCHAR,
  "territory_type" VARCHAR,
  "organ" VARCHAR,
  "subscribers" BIGINT,
  "votes" BIGINT,
  "voters_pct" DOUBLE,
  "abstention_pct" DOUBLE,
  "blank_votes" BIGINT,
  "blank_pct" DOUBLE,
  "null_votes" BIGINT,
  "null_pct" DOUBLE,
  "mandates_assigned" VARCHAR,
  "mandates_unassigned" VARCHAR,
  "mandates_total" VARCHAR,
  "state" VARCHAR
);

Resultados para Junta de Freguesia por freguesia

@jsoares.portugal_municipal_elections_2025.jf_freguesias

172.75 kB
9,757 rows
16 columns

CREATE TABLE jf_freguesias (
  "election_code" VARCHAR,
  "election_date" DATE,
  "territory_code" VARCHAR,
  "territory_name" VARCHAR,
  "territory_type" VARCHAR,
  "organ" VARCHAR,
  "state" VARCHAR,
  "party" VARCHAR,
  "party_full" VARCHAR,
  "party_type" VARCHAR,
  "votes" VARCHAR,
  "votes_pct" VARCHAR,
  "mandates" VARCHAR,
  "presidents" VARCHAR,
  "absolute_majorities" VARCHAR,
  "electoral_circles_compete" VARCHAR
);

Portugal Municipal Elections 2025

About this Dataset