French National Assembly Open Data

All the data to analyse the french national assembly between 2017 and 2021

@kaggle.maxlutz09_french_national_assembly_open_data

Table List

6 tables(866.9 KB)

Df Votes

@kaggle.maxlutz09_french_national_assembly_open_data.df_votes

573.92 KB
393349 rows
8 columns

scrutin Scrutin	deputy_code Deputy Code	pour Pour	non_votants Non Votants	cause Cause
VTANR5L15V1	PA332747		1	PSE
VTANR5L15V1	PA337633		1	MG
VTANR5L15V1	PA331481		1	MG
VTANR5L15V1	PA605131		1	MG
VTANR5L15V1	PA607395		1	MG
VTANR5L15V1	PA721560		1	MG
VTANR5L15V1	PA721872		1	MG
VTANR5L15V1	PA717167		1	MG
VTANR5L15V1	PA721262	1		nan
VTANR5L15V1	PA722398	1		nan


CREATE TABLE df_votes (
  "scrutin" VARCHAR,
  "deputy_code" VARCHAR,
  "pour" BIGINT,
  "contre" BIGINT,
  "non_votants" BIGINT,
  "abstentions" BIGINT,
  "cause" VARCHAR,
  "par_delegation" BIGINT
);