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 Deputies

@kaggle.maxlutz09_french_national_assembly_open_data.df_deputies

27.54 KB
573 rows
10 columns

code Code	sex Sex	family_name Family Name	first_name First Name	date_of_birth Date Of Birth	activity Activity	pol_party Pol Party	dep Dep	num_dep Num Dep	circo Circo
PA1008	male	David	Alain	Thu Jun 02 1949 00:00:00 GMT+0000 (Coordinated Universal Time)	Cadres	PS	Gironde	33	4
PA1012	male	de la Verpillière	Charles	Mon May 31 1954 00:00:00 GMT+0000 (Coordinated Universal Time)	Cadres	REP	Ain	01	2
PA1029	male	Deflesselles	Bernard	Fri Oct 16 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	Cadres	REP	Bouches-du-Rhône	13	9
PA1198	female	Dumont	Laurence	Mon Jun 02 1958 00:00:00 GMT+0000 (Coordinated Universal Time)	Cadres	PS	Calvados	14	2
PA1206	male	Dupont-Aignan	Nicolas	Tue Mar 07 1961 00:00:00 GMT+0000 (Coordinated Universal Time)	Cadres	ND	Essonne	91	8
PA1276	male	Fanget	Michel	Wed May 03 1950 00:00:00 GMT+0000 (Coordinated Universal Time)	Cadres	MODEM	Puy-de-Dôme	63	4
PA1327	male	Forissier	Nicolas	Fri Feb 17 1961 00:00:00 GMT+0000 (Coordinated Universal Time)	Entrepreneurs	REP	Indre	36	2
PA1592	male	Habib	David	Thu Mar 16 1961 00:00:00 GMT+0000 (Coordinated Universal Time)	Cadres	PS	Pyrénées-Atlantiques	64	3
PA1630	male	Herbillon	Michel	Tue Mar 06 1951 00:00:00 GMT+0000 (Coordinated Universal Time)	Cadres	REP	Val-de-Marne	94	8
PA1695	male	Jacob	Christian	Fri Dec 04 1959 00:00:00 GMT+0000 (Coordinated Universal Time)	Agriculteurs	REP	Seine-et-Marne	77	4


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
);