amo30.acteur_mandat_collaborateurs_collaborateur
Chemin acteur.mandats.mandat.collaborateurs.collaborateur · présence : L17 18 %
2 070 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 18 % · 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 18 % |
| 9 | nom | VARCHAR | acteur.mandats.mandat.collaborateurs.collaborateur.nom · présence : L17 18 % |
| 10 | date_debut | VARCHAR | acteur.mandats.mandat.collaborateurs.collaborateur.dateDebut · présence : L17 18 % |
| 11 | date_fin | VARCHAR | acteur.mandats.mandat.collaborateurs.collaborateur.dateFin · présence : L17 18 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | qualite | prenom | nom | date_debut | date_fin |
|---|---|---|---|---|---|---|---|---|---|---|
| 17030000157750 | L17/amo30 | 17 | 17030000157643 | 17030000157746 | 4 | M. | Benjamin | Galy | ||
| 17030000157866 | L17/amo30 | 17 | 17030000157778 | 17030000157865 | 1 | M. | Romain | Berthet | ||
| 17030000157867 | L17/amo30 | 17 | 17030000157778 | 17030000157865 | 2 | Mme | Fatima | Mbitel | ||
| 17030000157868 | L17/amo30 | 17 | 17030000157778 | 17030000157865 | 3 | Mme | Anne-Sophie | Nury | ||
| 17030000157869 | L17/amo30 | 17 | 17030000157778 | 17030000157865 | 4 | M. | Frédéric | Hopital | ||
| 17030000158006 | L17/amo30 | 17 | 17030000157908 | 17030000158005 | 1 | Mme | Karine | Sorin Lambert | ||
| 17030000158007 | L17/amo30 | 17 | 17030000157908 | 17030000158005 | 2 | Mme | Marianna | Didiergeorges | ||
| 17030000158008 | L17/amo30 | 17 | 17030000157908 | 17030000158005 | 3 | M. | Clément | Venet | ||
| 17030000158009 | L17/amo30 | 17 | 17030000157908 | 17030000158005 | 4 | Mme | Vanessa | Issermann | ||
| 17030000158192 | L17/amo30 | 17 | 17030000158010 | 17030000158191 | 1 | Mme | Astrid | Ribardière | ||
| 17030000158193 | L17/amo30 | 17 | 17030000158010 | 17030000158191 | 2 | Mme | Audrey | Nivole | ||
| 17030000158194 | L17/amo30 | 17 | 17030000158010 | 17030000158191 | 3 | Mme | Félicie | Jamen | ||
| 17030000158297 | L17/amo30 | 17 | 17030000158195 | 17030000158296 | 1 | M. | Louis-Sami | Ramdani | ||
| 17030000158298 | L17/amo30 | 17 | 17030000158195 | 17030000158296 | 2 | Mme | Coline | Caniard | ||
| 17030000158299 | L17/amo30 | 17 | 17030000158195 | 17030000158296 | 3 | M. | Léopold | Lavou-Soriano | ||
| 17030000158300 | L17/amo30 | 17 | 17030000158195 | 17030000158296 | 4 | Mme | Garance | Blettery | ||
| 17030000158478 | L17/amo30 | 17 | 17030000158301 | 17030000158477 | 1 | Mme | Edith | Sellier | ||
| 17030000158479 | L17/amo30 | 17 | 17030000158301 | 17030000158477 | 2 | Mme | Valérie | Chaumanet | ||
| 17030000158480 | L17/amo30 | 17 | 17030000158301 | 17030000158477 | 3 | Mme | Agnès | Pardon | ||
| 17030000158481 | L17/amo30 | 17 | 17030000158301 | 17030000158477 | 4 | M. | Roland | Comte | ||
| 17030000158482 | L17/amo30 | 17 | 17030000158301 | 17030000158477 | 5 | M. | Jean-Michel | Gimard | ||
| 17030000158544 | L17/amo30 | 17 | 17030000158483 | 17030000158543 | 1 | Mme | Rachelle | De Wever | ||
| 17030000158545 | L17/amo30 | 17 | 17030000158483 | 17030000158543 | 2 | M. | Gautier | Boband | ||
| 17030000158546 | L17/amo30 | 17 | 17030000158483 | 17030000158543 | 3 | Mme | Hélène | de Fombelle | ||
| 17030000158547 | L17/amo30 | 17 | 17030000158483 | 17030000158543 | 4 | M. | Yonathan | Bellaiche | ||
| 17030000158548 | L17/amo30 | 17 | 17030000158483 | 17030000158543 | 5 | M. | Valentin | Joly | ||
| 17030000158549 | L17/amo30 | 17 | 17030000158483 | 17030000158543 | 6 | M. | Léo | Pimentel | ||
| 17030000158665 | L17/amo30 | 17 | 17030000158550 | 17030000158664 | 1 | M. | Mustapha | Gharbi | ||
| 17030000158666 | L17/amo30 | 17 | 17030000158550 | 17030000158664 | 2 | M. | Merlin | Gautier | ||
| 17030000158667 | L17/amo30 | 17 | 17030000158550 | 17030000158664 | 3 | M. | Tim | Blanloeil | ||
| 17030000158668 | L17/amo30 | 17 | 17030000158550 | 17030000158664 | 4 | M. | Tom | Bernard | ||
| 17030000158669 | L17/amo30 | 17 | 17030000158550 | 17030000158664 | 5 | Mme | Anaïs | Besse-Renard | ||
| 17030000158807 | L17/amo30 | 17 | 17030000158670 | 17030000158806 | 1 | Mme | Christine | Legnani | ||
| 17030000158808 | L17/amo30 | 17 | 17030000158670 | 17030000158806 | 2 | M. | Marin | Fournier | ||
| 17030000158809 | L17/amo30 | 17 | 17030000158670 | 17030000158806 | 3 | M. | Maxime | Viancin | ||
| 17030000158923 | L17/amo30 | 17 | 17030000158811 | 17030000158922 | 1 | M. | Samuel | Langlade | ||
| 17030000158924 | L17/amo30 | 17 | 17030000158811 | 17030000158922 | 2 | Mme | Maëlis | Juvin | ||
| 17030000158925 | L17/amo30 | 17 | 17030000158811 | 17030000158922 | 3 | M. | Philippe | Le Boulanger | ||
| 17030000159028 | L17/amo30 | 17 | 17030000158926 | 17030000159027 | 1 | M. | Maxime | Hupel | ||
| 17030000159029 | L17/amo30 | 17 | 17030000158926 | 17030000159027 | 2 | Mme | Solenn | Maray | ||
| 17030000159030 | L17/amo30 | 17 | 17030000158926 | 17030000159027 | 3 | Mme | Zoé | Bédelet | ||
| 17030000159031 | L17/amo30 | 17 | 17030000158926 | 17030000159027 | 4 | Mme | Ariane | Rambaud | ||
| 17030000159127 | L17/amo30 | 17 | 17030000159032 | 17030000159126 | 1 | M. | David | Faustin | ||
| 17030000159128 | L17/amo30 | 17 | 17030000159032 | 17030000159126 | 2 | M. | Thomas | Lefeuvre | ||
| 17030000159129 | L17/amo30 | 17 | 17030000159032 | 17030000159126 | 3 | M. | Sébastien | Tixier | ||
| 17030000159130 | L17/amo30 | 17 | 17030000159032 | 17030000159126 | 4 | Mme | Pauline | Bunel | ||
| 17030000159131 | L17/amo30 | 17 | 17030000159032 | 17030000159126 | 5 | M. | Morgan | Ceulemans | ||
| 17030000159226 | L17/amo30 | 17 | 17030000159214 | 17030000159225 | 1 | M. | Hugo | Frery | ||
| 17030000159227 | L17/amo30 | 17 | 17030000159214 | 17030000159225 | 2 | M. | Hervé | Maître | ||
| 17030000159228 | L17/amo30 | 17 | 17030000159214 | 17030000159225 | 3 | Mme | Sophie | Paillard |