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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17030000161095 | L17/amo30 | 17 | 17030000161020 | 17030000161094 | 1 | M. | Gabriel | Baude | ||
| 17030000161165 | L17/amo30 | 17 | 17030000161099 | 17030000161164 | 1 | M. | Mickaël | Lebas | ||
| 17030000161166 | L17/amo30 | 17 | 17030000161099 | 17030000161164 | 2 | Mme | Caroline | Bettinger-Aucagos | ||
| 17030000161167 | L17/amo30 | 17 | 17030000161099 | 17030000161164 | 3 | Mme | Sabrina | Thomas | ||
| 17030000161259 | L17/amo30 | 17 | 17030000161235 | 17030000161258 | 1 | M. | Samy | Hafiz | ||
| 17030000161260 | L17/amo30 | 17 | 17030000161235 | 17030000161258 | 2 | Mme | Anne | Boulanger | ||
| 17030000161261 | L17/amo30 | 17 | 17030000161235 | 17030000161258 | 3 | M. | Benoît | Everaere | ||
| 17030000161475 | L17/amo30 | 17 | 17030000161354 | 17030000161474 | 1 | Mme | Nathalie | Facon | ||
| 17030000161476 | L17/amo30 | 17 | 17030000161354 | 17030000161474 | 2 | M. | Maxence | Lemoine | ||
| 17030000161477 | L17/amo30 | 17 | 17030000161354 | 17030000161474 | 3 | Mme | Emmanuelle | Paillard | ||
| 17030000161478 | L17/amo30 | 17 | 17030000161354 | 17030000161474 | 4 | M. | Grégoire | Guillemin | ||
| 17030000161631 | L17/amo30 | 17 | 17030000161551 | 17030000161630 | 1 | M. | Wilson | Roux | ||
| 17030000161632 | L17/amo30 | 17 | 17030000161551 | 17030000161630 | 2 | Mme | Isabelle | Lescalle | ||
| 17030000161633 | L17/amo30 | 17 | 17030000161551 | 17030000161630 | 3 | M. | Thomas | Perret | ||
| 17030000161851 | L17/amo30 | 17 | 17030000161634 | 17030000161850 | 1 | M. | Arthur | Desoignies | ||
| 17030000161852 | L17/amo30 | 17 | 17030000161634 | 17030000161850 | 2 | Mme | Shauna | MC Hugh | ||
| 17030000161853 | L17/amo30 | 17 | 17030000161634 | 17030000161850 | 3 | M. | Hugo | Mendes | ||
| 17030000161854 | L17/amo30 | 17 | 17030000161634 | 17030000161850 | 4 | M. | Jonathan | Verbeken | ||
| 17030000161878 | L17/amo30 | 17 | 17030000161855 | 17030000161877 | 1 | Mme | Isabelle | Guillot | ||
| 17030000161879 | L17/amo30 | 17 | 17030000161855 | 17030000161877 | 2 | Mme | Manoëlle | Martin | ||
| 17030000161880 | L17/amo30 | 17 | 17030000161855 | 17030000161877 | 3 | M. | Pierre | Arbousset | ||
| 17030000161928 | L17/amo30 | 17 | 17030000161881 | 17030000161927 | 1 | Mme | Josiane | Marison | ||
| 17030000161929 | L17/amo30 | 17 | 17030000161881 | 17030000161927 | 2 | M. | Krysten | Richard | ||
| 17030000161930 | L17/amo30 | 17 | 17030000161881 | 17030000161927 | 3 | M. | Grégoire | Guillemin | ||
| 17030000161931 | L17/amo30 | 17 | 17030000161881 | 17030000161927 | 4 | M. | Guillaume | Gobernatz | ||
| 17030000162009 | L17/amo30 | 17 | 17030000161932 | 17030000162008 | 1 | M. | Angelo | Heilig | ||
| 17030000162010 | L17/amo30 | 17 | 17030000161932 | 17030000162008 | 2 | M. | Rémy | Berthonneau | ||
| 17030000162061 | L17/amo30 | 17 | 17030000162011 | 17030000162060 | 1 | M. | Guillaume | Baratte | ||
| 17030000162062 | L17/amo30 | 17 | 17030000162011 | 17030000162060 | 2 | M. | Julien | Nicolas | ||
| 17030000162063 | L17/amo30 | 17 | 17030000162011 | 17030000162060 | 3 | M. | Andrew | Delforge | ||
| 17030000162064 | L17/amo30 | 17 | 17030000162011 | 17030000162060 | 4 | M. | Mathéo | Basin | ||
| 17030000162343 | L17/amo30 | 17 | 17030000162225 | 17030000162342 | 1 | M. | Domingo | Soudais | ||
| 17030000162344 | L17/amo30 | 17 | 17030000162225 | 17030000162342 | 2 | M. | Martin | Gosselin | ||
| 17030000162345 | L17/amo30 | 17 | 17030000162225 | 17030000162342 | 3 | M. | Romain | Martin | ||
| 17030000162346 | L17/amo30 | 17 | 17030000162225 | 17030000162342 | 4 | M. | Florian | Bourgois | ||
| 17030000162390 | L17/amo30 | 17 | 17030000162347 | 17030000162389 | 1 | M. | Corentin | Fagot | ||
| 17030000162391 | L17/amo30 | 17 | 17030000162347 | 17030000162389 | 2 | M. | Grégory | Vivard | ||
| 17030000162461 | L17/amo30 | 17 | 17030000162392 | 17030000162460 | 1 | M. | Valentin | Duthoit | ||
| 17030000162462 | L17/amo30 | 17 | 17030000162392 | 17030000162460 | 2 | M. | Jérôme | Antochewicz | ||
| 17030000162463 | L17/amo30 | 17 | 17030000162392 | 17030000162460 | 3 | M. | Yann | Vizcaino | ||
| 17030000162464 | L17/amo30 | 17 | 17030000162392 | 17030000162460 | 4 | Mme | Linda | Gossart | ||
| 17030000162554 | L17/amo30 | 17 | 17030000162465 | 17030000162553 | 1 | Mme | Océane | Pichon | ||
| 17030000162555 | L17/amo30 | 17 | 17030000162465 | 17030000162553 | 2 | M. | Matthieu | Barberis | ||
| 17030000162556 | L17/amo30 | 17 | 17030000162465 | 17030000162553 | 3 | Mme | Esther | Allard | ||
| 17030000162557 | L17/amo30 | 17 | 17030000162465 | 17030000162553 | 4 | Mme | Earine | Chapelon | ||
| 17030000162672 | L17/amo30 | 17 | 17030000162558 | 17030000162671 | 1 | Mme | Sandrine | Armand | ||
| 17030000162673 | L17/amo30 | 17 | 17030000162558 | 17030000162671 | 2 | Mme | Romane | Gallay | ||
| 17030000162674 | L17/amo30 | 17 | 17030000162558 | 17030000162671 | 3 | M. | Hugo | Torres | ||
| 17030000162729 | L17/amo30 | 17 | 17030000162675 | 17030000162728 | 1 | Mme | Corinne | Ould'Ameur | ||
| 17030000162730 | L17/amo30 | 17 | 17030000162675 | 17030000162728 | 2 | M. | Laurent | Courtial |