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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17020000023215 | L17/amo20 | 17 | 17020000023176 | 17020000023214 | 1 | M. | Gabriel | Baude | ||
| 17020000023261 | L17/amo20 | 17 | 17020000023218 | 17020000023260 | 1 | M. | Mickaël | Lebas | ||
| 17020000023262 | L17/amo20 | 17 | 17020000023218 | 17020000023260 | 2 | Mme | Caroline | Bettinger-Aucagos | ||
| 17020000023263 | L17/amo20 | 17 | 17020000023218 | 17020000023260 | 3 | Mme | Sabrina | Thomas | ||
| 17020000023292 | L17/amo20 | 17 | 17020000023268 | 17020000023291 | 1 | M. | Samy | Hafiz | ||
| 17020000023293 | L17/amo20 | 17 | 17020000023268 | 17020000023291 | 2 | Mme | Anne | Boulanger | ||
| 17020000023294 | L17/amo20 | 17 | 17020000023268 | 17020000023291 | 3 | M. | Benoît | Everaere | ||
| 17020000023393 | L17/amo20 | 17 | 17020000023296 | 17020000023392 | 1 | Mme | Nathalie | Facon | ||
| 17020000023394 | L17/amo20 | 17 | 17020000023296 | 17020000023392 | 2 | M. | Maxence | Lemoine | ||
| 17020000023395 | L17/amo20 | 17 | 17020000023296 | 17020000023392 | 3 | Mme | Emmanuelle | Paillard | ||
| 17020000023396 | L17/amo20 | 17 | 17020000023296 | 17020000023392 | 4 | M. | Grégoire | Guillemin | ||
| 17020000023470 | L17/amo20 | 17 | 17020000023427 | 17020000023469 | 1 | M. | Wilson | Roux | ||
| 17020000023471 | L17/amo20 | 17 | 17020000023427 | 17020000023469 | 2 | Mme | Isabelle | Lescalle | ||
| 17020000023472 | L17/amo20 | 17 | 17020000023427 | 17020000023469 | 3 | M. | Thomas | Perret | ||
| 17020000023658 | L17/amo20 | 17 | 17020000023473 | 17020000023657 | 1 | M. | Arthur | Desoignies | ||
| 17020000023659 | L17/amo20 | 17 | 17020000023473 | 17020000023657 | 2 | Mme | Shauna | MC Hugh | ||
| 17020000023660 | L17/amo20 | 17 | 17020000023473 | 17020000023657 | 3 | M. | Hugo | Mendes | ||
| 17020000023661 | L17/amo20 | 17 | 17020000023473 | 17020000023657 | 4 | M. | Jonathan | Verbeken | ||
| 17020000023685 | L17/amo20 | 17 | 17020000023662 | 17020000023684 | 1 | Mme | Isabelle | Guillot | ||
| 17020000023686 | L17/amo20 | 17 | 17020000023662 | 17020000023684 | 2 | Mme | Manoëlle | Martin | ||
| 17020000023687 | L17/amo20 | 17 | 17020000023662 | 17020000023684 | 3 | M. | Pierre | Arbousset | ||
| 17020000023718 | L17/amo20 | 17 | 17020000023688 | 17020000023717 | 1 | Mme | Josiane | Marison | ||
| 17020000023719 | L17/amo20 | 17 | 17020000023688 | 17020000023717 | 2 | M. | Krysten | Richard | ||
| 17020000023720 | L17/amo20 | 17 | 17020000023688 | 17020000023717 | 3 | M. | Grégoire | Guillemin | ||
| 17020000023721 | L17/amo20 | 17 | 17020000023688 | 17020000023717 | 4 | M. | Guillaume | Gobernatz | ||
| 17020000023774 | L17/amo20 | 17 | 17020000023722 | 17020000023773 | 1 | M. | Angelo | Heilig | ||
| 17020000023775 | L17/amo20 | 17 | 17020000023722 | 17020000023773 | 2 | M. | Rémy | Berthonneau | ||
| 17020000023808 | L17/amo20 | 17 | 17020000023776 | 17020000023807 | 1 | M. | Guillaume | Baratte | ||
| 17020000023809 | L17/amo20 | 17 | 17020000023776 | 17020000023807 | 2 | M. | Julien | Nicolas | ||
| 17020000023810 | L17/amo20 | 17 | 17020000023776 | 17020000023807 | 3 | M. | Andrew | Delforge | ||
| 17020000023811 | L17/amo20 | 17 | 17020000023776 | 17020000023807 | 4 | M. | Mathéo | Basin | ||
| 17020000023874 | L17/amo20 | 17 | 17020000023812 | 17020000023873 | 1 | M. | Domingo | Soudais | ||
| 17020000023875 | L17/amo20 | 17 | 17020000023812 | 17020000023873 | 2 | M. | Martin | Gosselin | ||
| 17020000023876 | L17/amo20 | 17 | 17020000023812 | 17020000023873 | 3 | M. | Romain | Martin | ||
| 17020000023877 | L17/amo20 | 17 | 17020000023812 | 17020000023873 | 4 | M. | Florian | Bourgois | ||
| 17020000023905 | L17/amo20 | 17 | 17020000023878 | 17020000023904 | 1 | M. | Corentin | Fagot | ||
| 17020000023906 | L17/amo20 | 17 | 17020000023878 | 17020000023904 | 2 | M. | Grégory | Vivard | ||
| 17020000023942 | L17/amo20 | 17 | 17020000023907 | 17020000023941 | 1 | M. | Valentin | Duthoit | ||
| 17020000023943 | L17/amo20 | 17 | 17020000023907 | 17020000023941 | 2 | M. | Jérôme | Antochewicz | ||
| 17020000023944 | L17/amo20 | 17 | 17020000023907 | 17020000023941 | 3 | M. | Yann | Vizcaino | ||
| 17020000023945 | L17/amo20 | 17 | 17020000023907 | 17020000023941 | 4 | Mme | Linda | Gossart | ||
| 17020000024005 | L17/amo20 | 17 | 17020000023946 | 17020000024004 | 1 | Mme | Océane | Pichon | ||
| 17020000024006 | L17/amo20 | 17 | 17020000023946 | 17020000024004 | 2 | M. | Matthieu | Barberis | ||
| 17020000024007 | L17/amo20 | 17 | 17020000023946 | 17020000024004 | 3 | Mme | Esther | Allard | ||
| 17020000024008 | L17/amo20 | 17 | 17020000023946 | 17020000024004 | 4 | Mme | Earine | Chapelon | ||
| 17020000024093 | L17/amo20 | 17 | 17020000024009 | 17020000024092 | 1 | Mme | Sandrine | Armand | ||
| 17020000024094 | L17/amo20 | 17 | 17020000024009 | 17020000024092 | 2 | Mme | Romane | Gallay | ||
| 17020000024095 | L17/amo20 | 17 | 17020000024009 | 17020000024092 | 3 | M. | Hugo | Torres | ||
| 17020000024150 | L17/amo20 | 17 | 17020000024096 | 17020000024149 | 1 | Mme | Corinne | Ould'Ameur | ||
| 17020000024151 | L17/amo20 | 17 | 17020000024096 | 17020000024149 | 2 | M. | Laurent | Courtial |