Download data

Name: Download Spanish Congress data in Excel and CSV: deputies, assets and votes
Creator: Congreso Abierto
License: https://creativecommons.org/licenses/by/4.0/

Choose a table, filter what you need and download it to open in Excel, Google Sheets or your data tool.

Step 1 of 4Table

DeputiesOne row per deputy: profile, assets, income, debts and a summary of their votes350 rowsPropertiesOne row per declared property1,003 rowsVotesOne row per plenary vote, with its result2,175 rowsEach group’s voteOne row per vote and group, with the group’s majority vote19,561 rowsEach deputy’s voteOne row per deputy and vote (over 700,000)726,564 rows

Step 2 of 4Filters

Loading data…

Step 3 of 4Columns

Step 4 of 4Download

FormatExcelSemicolons and decimal comma: opens with a double click in Excel set to Spanish or European formats.Standard CSVCommas and decimal point: for R, Python, Google Sheets or English Excel.

See the first rows

More ways to use the data

Full tables

The full tables in standard CSV, with fixed column names, for use in code or to link to.

What each column means

Deputies

Profile

Code: Official parliamentary code of the deputy; id
First name: Given name, as in the official profile; nombre
Surnames: Surnames, as in the official profile; apellidos
Sex: F or M, as in the official profile; genero
Group: Parliamentary group (short name); grupo
Group (official name): Official name of the parliamentary group; grupo_nombre
Electoral list: List on which they were elected; partido
Constituency: Province or city they were elected for; circunscripcion
Start date: Date they took their seat; fecha_alta
Year of birth: As in the official profile; anio_nacimiento
Terms: Number of terms as a deputy; legislaturas
Positions: Current positions in Congress; cargos
Education: Literal text from the official profile; formacion
University type: publica, privada, ambas, sin-centro or sin-datos (per RUCT); tipo_formacion

Pay, assets and debts

Monthly pay (€): Official monthly amounts from Congress; retribucion_mensual
Properties: Real estate declared in their name; propiedades
Homes: Residential properties declared; viviendas
Vehicles: Vehicles declared; vehiculos
Declared income (€): Income in the year before the declaration, excluding Congress pay; rentas_declaradas
Income: at least: Some amount could not be read: the total is a minimum; rentas_al_menos
Accounts and deposits (€): Declared balance in accounts and deposits; depositos
Deposits: at least: Some amount could not be read: the total is a minimum; depositos_al_menos
Outstanding debt (€): Outstanding balance of declared loans; deuda_pendiente
Debt: at least: Some amount could not be read: the total is a minimum; deuda_al_menos

Votes

Votes while seated: Plenary votes held while they had a seat; votaciones_en_escano
Yes votes: Times they voted yes; votos_si
No votes: Times they voted no; votos_no
Abstentions: Times they abstained; votos_abstencion
Did not vote: Votes in which they did not vote; no_vota
Votes against group: Times they voted differently from their group majority; votos_distintos_del_grupo

Warnings and links

Unconfirmed reading: Some value could not be fully confirmed: check the official PDF; lectura_no_confirmada
Official profile: Profile on congreso.es; url_ficha_oficial
Asset declaration: Official PDF of the asset declaration; url_declaracion_bienes
Congreso Abierto profile: Their profile on this site; url_congreso_abierto

Properties

Deputy code: Official parliamentary code; diputado_id
Deputy: Full name; diputado
Group: Parliamentary group (short name); grupo
Constituency: Province or city they were elected for; circunscripcion
Holder: propio (in their name) or sociedad (via a company); titular
Description: Literal text of the declaration; descripcion
Type: urbana, rustica or sociedad; naturaleza
Is a home: Residential use (flat, house…); es_vivienda
Province: Province of the property, if stated; provincia
Year acquired: If stated; anio_adquisicion
Right: Literal text: full ownership, bare ownership…; derecho
Share (%): Ownership share, if stated; porcentaje
Title: Official text of the matter voted on; titulo
Unconfirmed reading: Some value could not be fully confirmed: check the official PDF; lectura_no_confirmada
Declaration: Official PDF; url_declaracion

Votes

Code: Vote identifier (sitting and number); id
Date: YYYY-MM-DD; fecha
Session: Plenary session number; sesion
Number: Vote number within the session; numero
Type: Type of initiative (official text); tipo
Title: Official text of the matter voted on; titulo
Topics: Congreso Abierto topics, assigned by title keywords; temas
Result: Official result; resultado
Yes: Votes in favour; si
No: Votes against; no
Abstention: Abstention votes; abstencion
Did not vote: MPs who did not vote; no_vota
Vote (official): Official JSON of the vote; url_votacion
File: Official page of the file; url_expediente

Each group’s vote

Vote: Vote identifier (session and number); votacion_id
Date: YYYY-MM-DD; fecha
Title: Official text of the matter voted on; titulo
Topics: Congreso Abierto topics, assigned by title keywords; temas
Group: Parliamentary group (short name); grupo
Yes: MPs in the group who voted yes; si
No: MPs in the group who voted no; no
Abstention: MPs in the group who abstained; abstencion
Did not vote: MPs in the group who did not vote; no_vota
Majority vote: What most of the group voted (Sí, No, Abstención or Empate); voto_mayoritario

Each deputy’s vote

Vote: Vote identifier (session and number); votacion_id
Date: YYYY-MM-DD; fecha
Topics: Congreso Abierto topics, assigned by title keywords; temas
Deputy code: Official parliamentary code; diputado_id
Deputy: Full name; diputado
Group: Parliamentary group (short name); grupo
Constituency: Province or city they were elected for; circunscripcion
Vote: Sí, No, Abstención or No vota (official value); voto

Licence and how to cite

Congreso Abierto data is published under the CC BY 4.0 licence: you may reuse it, including commercially, crediting the source like this:

Congreso Abierto (congresoabierto.org), a partir de datos oficiales del Congreso de los Diputados

Everything comes from official Congress documents and each row links to its source when it has one. Official texts are in Spanish, as Congress publishes them.