amo20.acteur_mandat_collaborateurs_collaborateur
Chemin acteur.mandats.mandat.collaborateurs.collaborateur · présence : L17 54 %, L15 45 %
3 846 lignes (estimation)
Colonnes
| # | Colonne | Type | Commentaire |
|---|---|---|---|
| 1 | _id | BIGINT | identifiant : code de la source × 10¹⁰ + rang |
| 2 | _source | VARCHAR | source du catalogue (catalogue.py) |
| 3 | _legislature | BIGINT | colonne constante de la source |
| 4 | _racine_id | BIGINT | _id de la ligne racine |
| 5 | _parent_id | BIGINT | _id de la ligne parente |
| 6 | _ordre | BIGINT | rang dans le tableau d'origine (1…) |
| 7 | qualite | VARCHAR | acteur.mandats.mandat.collaborateurs.collaborateur.qualite · présence : L17 54 %, L15 45 % · XSD 2016 : Rapporteur, rapporteur pour avis, général, spécial, intervenant. Ne pas mettre auteur et cosignataire. Utilisé également pour la spécialité du rapporteur sur le PLF |
| 8 | prenom | VARCHAR | acteur.mandats.mandat.collaborateurs.collaborateur.prenom · présence : L17 54 %, L15 45 % |
| 9 | nom | VARCHAR | acteur.mandats.mandat.collaborateurs.collaborateur.nom · présence : L17 54 %, L15 45 % |
| 10 | date_debut | VARCHAR | acteur.mandats.mandat.collaborateurs.collaborateur.dateDebut · présence : L17 54 %, L15 45 % |
| 11 | date_fin | VARCHAR | acteur.mandats.mandat.collaborateurs.collaborateur.dateFin · présence : L17 54 %, L15 45 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | qualite | prenom | nom | date_debut | date_fin |
|---|---|---|---|---|---|---|---|---|---|---|
| 17020000033091 | L17/amo20 | 17 | 17020000033023 | 17020000033089 | 2 | Mme | Sarah | Nequey | ||
| 17020000033092 | L17/amo20 | 17 | 17020000033023 | 17020000033089 | 3 | Mme | Virginie | Roche | ||
| 17020000033093 | L17/amo20 | 17 | 17020000033023 | 17020000033089 | 4 | Mme | Marion | Mercier | ||
| 17020000033135 | L17/amo20 | 17 | 17020000033094 | 17020000033134 | 1 | M. | Olivier | Rioult | ||
| 17020000033136 | L17/amo20 | 17 | 17020000033094 | 17020000033134 | 2 | Mme | Anne-Marie | Gregori | ||
| 17020000033137 | L17/amo20 | 17 | 17020000033094 | 17020000033134 | 3 | M. | Raphaël | Hérimian | ||
| 17020000033138 | L17/amo20 | 17 | 17020000033094 | 17020000033134 | 4 | Mme | Margie | Liccioni | ||
| 17020000033139 | L17/amo20 | 17 | 17020000033094 | 17020000033134 | 5 | M. | Pierre | Couve | ||
| 17020000033162 | L17/amo20 | 17 | 17020000033140 | 17020000033161 | 1 | M. | Olivier | Debicki | ||
| 17020000033163 | L17/amo20 | 17 | 17020000033140 | 17020000033161 | 2 | Mme | Emma | Hardy | ||
| 17020000033164 | L17/amo20 | 17 | 17020000033140 | 17020000033161 | 3 | M. | Paul | Laurent | ||
| 17020000033165 | L17/amo20 | 17 | 17020000033140 | 17020000033161 | 4 | Mme | Eléna | Dias--Seghi | ||
| 17020000033207 | L17/amo20 | 17 | 17020000033166 | 17020000033206 | 1 | M. | Virgile | Donati | ||
| 17020000033208 | L17/amo20 | 17 | 17020000033166 | 17020000033206 | 2 | M. | Alexandre | Boumendil | ||
| 17020000033209 | L17/amo20 | 17 | 17020000033166 | 17020000033206 | 3 | M. | César | Vermorel Forest | ||
| 17020000033238 | L17/amo20 | 17 | 17020000033210 | 17020000033237 | 1 | M. | Léopold | Aubin | ||
| 17020000033239 | L17/amo20 | 17 | 17020000033210 | 17020000033237 | 2 | M. | Kévin | Nader | ||
| 17020000033240 | L17/amo20 | 17 | 17020000033210 | 17020000033237 | 3 | M. | Thibaut | de Bougrenet de la Tocnaye | ||
| 17020000033277 | L17/amo20 | 17 | 17020000033241 | 17020000033276 | 1 | Mme | Alix | Bougnoux | ||
| 17020000033278 | L17/amo20 | 17 | 17020000033241 | 17020000033276 | 2 | M. | Jacques | Smith | ||
| 17020000033279 | L17/amo20 | 17 | 17020000033241 | 17020000033276 | 3 | M. | François-Régis | Lavier | ||
| 17020000033280 | L17/amo20 | 17 | 17020000033241 | 17020000033276 | 4 | Mme | Dina | Labane | ||
| 17020000033335 | L17/amo20 | 17 | 17020000033281 | 17020000033334 | 1 | Mme | Jennifer | Tonel | ||
| 17020000033336 | L17/amo20 | 17 | 17020000033281 | 17020000033334 | 2 | M. | Victor | Lecasble | ||
| 17020000033337 | L17/amo20 | 17 | 17020000033281 | 17020000033334 | 3 | M. | Louis | Ronssin | ||
| 17020000033373 | L17/amo20 | 17 | 17020000033338 | 17020000033372 | 1 | Mme | Lydia | Labrue | ||
| 17020000033374 | L17/amo20 | 17 | 17020000033338 | 17020000033372 | 2 | M. | Antoine | Dallet | ||
| 17020000033375 | L17/amo20 | 17 | 17020000033338 | 17020000033372 | 3 | Mme | Léa | Chataigné | ||
| 17020000033376 | L17/amo20 | 17 | 17020000033338 | 17020000033372 | 4 | M. | Malo | Gentric-Lepage | ||
| 17020000033410 | L17/amo20 | 17 | 17020000033377 | 17020000033409 | 1 | M. | Yohan | De Koninck | ||
| 17020000033411 | L17/amo20 | 17 | 17020000033377 | 17020000033409 | 2 | M. | Richard | Guerit | ||
| 17020000033412 | L17/amo20 | 17 | 17020000033377 | 17020000033409 | 3 | M. | Patrick | Dugenne | ||
| 17020000033413 | L17/amo20 | 17 | 17020000033377 | 17020000033409 | 4 | Mme | Emma | Vallain | ||
| 17020000033414 | L17/amo20 | 17 | 17020000033377 | 17020000033409 | 5 | M. | Pascal | Lévrier | ||
| 17020000033438 | L17/amo20 | 17 | 17020000033415 | 17020000033437 | 1 | M. | Flavien | Jouve | ||
| 17020000033439 | L17/amo20 | 17 | 17020000033415 | 17020000033437 | 2 | M. | Théo | Thomas | ||
| 17020000033440 | L17/amo20 | 17 | 17020000033415 | 17020000033437 | 3 | M. | Antoine | Teyssier | ||
| 17020000033464 | L17/amo20 | 17 | 17020000033441 | 17020000033463 | 1 | M. | Alexandre | Ledoux | ||
| 17020000033465 | L17/amo20 | 17 | 17020000033441 | 17020000033463 | 2 | M. | Eric | Barateau-Corbiat | ||
| 17020000033466 | L17/amo20 | 17 | 17020000033441 | 17020000033463 | 3 | M. | Morgan | Le Calvez | ||
| 17020000033496 | L17/amo20 | 17 | 17020000033467 | 17020000033495 | 1 | M. | Clovis | Roussel | ||
| 17020000033497 | L17/amo20 | 17 | 17020000033467 | 17020000033495 | 2 | M. | David | Desgouilles | ||
| 17020000033498 | L17/amo20 | 17 | 17020000033467 | 17020000033495 | 3 | Mme | Manon | Feind | ||
| 17020000033554 | L17/amo20 | 17 | 17020000033499 | 17020000033553 | 1 | M. | Ulysse | Lévy-Bruhl | ||
| 17020000033555 | L17/amo20 | 17 | 17020000033499 | 17020000033553 | 2 | M. | Quentin | Coignus | ||
| 17020000033556 | L17/amo20 | 17 | 17020000033499 | 17020000033553 | 3 | Mme | Marie | Vernochet | ||
| 17020000033588 | L17/amo20 | 17 | 17020000033557 | 17020000033587 | 1 | M. | Antoine | Mellies | ||
| 17020000033589 | L17/amo20 | 17 | 17020000033557 | 17020000033587 | 2 | M. | Romain | Besnard | ||
| 17020000033590 | L17/amo20 | 17 | 17020000033557 | 17020000033587 | 3 | Mme | Nathalie | Thai | ||
| 17020000033591 | L17/amo20 | 17 | 17020000033557 | 17020000033587 | 4 | Mme | Valentine | Auroux-Delage |