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

28.2 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

31.39 kB
16,670 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

33.02 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.55 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

202.86 kB
3,739 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

587.69 kB
393,349 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
);