Name: French National Assembly Open Data
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

French National Assembly Open Data

Context

As a beginner learning data science and data visualization, I wanted to work on a medium size project to showcase my skills and start building a portfolio. I was always interested in working with data from the government and see if the people we elect do the job they are supposed to do. That's why I started a project on the data on the french national assembly. They make it very easy to access the data and work with it. Everything is free and open which motivated me for the project.

Content

The data represents information on the deputies of the french national assembly between 2017 and 2021. All the information regarding the votes and the groups the deputies are part of are included in this dataset. There are close to 4000 different votes for this 4 year period, so there is the opportunity to do some statistical analysis and data visualization.

Tables

Df Deputies

@kaggle.maxlutz09_french_national_assembly_open_data.df_deputies

27.54 KB
573 rows
10 columns


CREATE TABLE df_deputies (
  "code" VARCHAR,
  "sex" VARCHAR,
  "family_name" VARCHAR,
  "first_name" VARCHAR,
  "date_of_birth" TIMESTAMP,
  "activity" VARCHAR,
  "pol_party" VARCHAR,
  "dep" VARCHAR,
  "num_dep" VARCHAR,
  "circo" BIGINT
);

Df Deputies Missions

@kaggle.maxlutz09_french_national_assembly_open_data.df_deputies_missions

30.65 KB
16670 rows
2 columns


CREATE TABLE df_deputies_missions (
  "code_organe" VARCHAR,
  "code_deputy" VARCHAR
);

Df Organs

@kaggle.maxlutz09_french_national_assembly_open_data.df_organs

32.24 KB
704 rows
4 columns


CREATE TABLE df_organs (
  "code" VARCHAR,
  "type" VARCHAR,
  "name" VARCHAR,
  "abreviated_name" VARCHAR
);

Df Political Parties

@kaggle.maxlutz09_french_national_assembly_open_data.df_political_parties

4.44 KB
10 rows
5 columns


CREATE TABLE df_political_parties (
  "code" VARCHAR,
  "name" VARCHAR,
  "abreviated_name" VARCHAR,
  "members" BIGINT,
  "color" VARCHAR
);

Df Vote Description

@kaggle.maxlutz09_french_national_assembly_open_data.df_vote_description

198.11 KB
3739 rows
24 columns


CREATE TABLE df_vote_description (
  "code" VARCHAR,
  "date" TIMESTAMP,
  "type" VARCHAR,
  "titre" VARCHAR,
  "demandeur" VARCHAR,
  "nb_votants" BIGINT,
  "requis" BIGINT,
  "non_votants" BIGINT,
  "pour" BIGINT,
  "contre" BIGINT,
  "abstentions" BIGINT,
  "demandeur_rep" BIGINT,
  "demandeur_larem" BIGINT,
  "demandeur_fi" BIGINT,
  "demandeur_ps" BIGINT,
  "demandeur_eelv" BIGINT,
  "demandeur_modem" BIGINT,
  "demandeur_nd" BIGINT,
  "demandeur_rps" BIGINT,
  "demandeur_udrl" BIGINT,
  "demandeur_pcf" BIGINT,
  "demandeur_cdp" BIGINT,
  "demandeur_gov" BIGINT,
  "demandeur_com_spe" BIGINT
);

Df Votes

@kaggle.maxlutz09_french_national_assembly_open_data.df_votes

573.92 KB
393349 rows
8 columns


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