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
codeCode | sexSex | family_nameFamily Name | first_nameFirst Name | date_of_birthDate Of Birth | activityActivity | pol_partyPol Party | depDep | num_depNum Dep | circoCirco |
|---|---|---|---|---|---|---|---|---|---|
| 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
);