amo40.acteur_mandat_collaborateurs_collaborateur
Chemin acteur.mandats.mandat.collaborateurs.collaborateur · présence : L17 100 %
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 100 % · 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 100 % |
| 9 | nom | VARCHAR | acteur.mandats.mandat.collaborateurs.collaborateur.nom · présence : L17 100 % |
| 10 | date_debut | VARCHAR | acteur.mandats.mandat.collaborateurs.collaborateur.dateDebut · présence : L17 100 % |
| 11 | date_fin | VARCHAR | acteur.mandats.mandat.collaborateurs.collaborateur.dateFin · présence : L17 100 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | qualite | prenom | nom | date_debut | date_fin |
|---|---|---|---|---|---|---|---|---|---|---|
| 17040000030043 | L17/amo40 | 17 | 17040000030002 | 17040000030039 | 4 | Mme | Clotilde | Ferrand | ||
| 17040000030091 | L17/amo40 | 17 | 17040000030055 | 17040000030090 | 1 | Mme | Emilie | Thomas | ||
| 17040000030092 | L17/amo40 | 17 | 17040000030055 | 17040000030090 | 2 | M. | Adrien | Naves-Lauby | ||
| 17040000030093 | L17/amo40 | 17 | 17040000030055 | 17040000030090 | 3 | Mme | Aurélie | Pirillo | ||
| 17040000030094 | L17/amo40 | 17 | 17040000030055 | 17040000030090 | 4 | M. | Jérôme | Nury | ||
| 17040000030108 | L17/amo40 | 17 | 17040000030102 | 17040000030107 | 1 | M. | Thomas | Pamart | ||
| 17040000030109 | L17/amo40 | 17 | 17040000030102 | 17040000030107 | 2 | M. | Géraud | Mautin | ||
| 17040000030110 | L17/amo40 | 17 | 17040000030102 | 17040000030107 | 3 | Mme | Julie | Ledoux | ||
| 17040000030111 | L17/amo40 | 17 | 17040000030102 | 17040000030107 | 4 | M. | Yohan | Marcourt | ||
| 17040000030112 | L17/amo40 | 17 | 17040000030102 | 17040000030107 | 5 | M. | Yvenn | Le Coz | ||
| 17040000030285 | L17/amo40 | 17 | 17040000030140 | 17040000030284 | 1 | Mme | Sandrine | Demaret | ||
| 17040000030286 | L17/amo40 | 17 | 17040000030140 | 17040000030284 | 2 | M. | Quentin | Louis | ||
| 17040000030287 | L17/amo40 | 17 | 17040000030140 | 17040000030284 | 3 | Mme | Marion | Moreau | ||
| 17040000030288 | L17/amo40 | 17 | 17040000030140 | 17040000030284 | 4 | Mme | Rachel | Pohier | ||
| 17040000030440 | L17/amo40 | 17 | 17040000030428 | 17040000030439 | 1 | M. | Geoffrey | Rousseau | ||
| 17040000030441 | L17/amo40 | 17 | 17040000030428 | 17040000030439 | 2 | Mme | Camille | Lemaitre | ||
| 17040000030442 | L17/amo40 | 17 | 17040000030428 | 17040000030439 | 3 | Mme | Marine | Dutrieux | ||
| 17040000030498 | L17/amo40 | 17 | 17040000030466 | 17040000030497 | 1 | Mme | Gabrielle | Arestegui | ||
| 17040000030499 | L17/amo40 | 17 | 17040000030466 | 17040000030497 | 2 | M. | Alexis | Bernigaud | ||
| 17040000030500 | L17/amo40 | 17 | 17040000030466 | 17040000030497 | 3 | Mme | Anne | Lacouture | ||
| 17040000030501 | L17/amo40 | 17 | 17040000030466 | 17040000030497 | 4 | M. | Ibon | Arenas Aizpuru | ||
| 17040000030532 | L17/amo40 | 17 | 17040000030510 | 17040000030531 | 1 | M. | Jean-François | Delanoue | ||
| 17040000030533 | L17/amo40 | 17 | 17040000030510 | 17040000030531 | 2 | M. | Nicolas | Villain | ||
| 17040000030534 | L17/amo40 | 17 | 17040000030510 | 17040000030531 | 3 | M. | Robin | Hils | ||
| 17040000030611 | L17/amo40 | 17 | 17040000030550 | 17040000030610 | 1 | M. | Constant | Jeanson | ||
| 17040000030612 | L17/amo40 | 17 | 17040000030550 | 17040000030610 | 2 | M. | Fabrice | Torro | ||
| 17040000030613 | L17/amo40 | 17 | 17040000030550 | 17040000030610 | 3 | Mme | Lisa | Cros | ||
| 17040000030648 | L17/amo40 | 17 | 17040000030625 | 17040000030647 | 1 | Mme | Tiffany | Perez | ||
| 17040000030649 | L17/amo40 | 17 | 17040000030625 | 17040000030647 | 2 | M. | Jean-Bernard | Colomès | ||
| 17040000030650 | L17/amo40 | 17 | 17040000030625 | 17040000030647 | 3 | M. | Antoine | Bulard | ||
| 17040000030728 | L17/amo40 | 17 | 17040000030677 | 17040000030727 | 1 | M. | Robert | Vanherzeeke | ||
| 17040000030729 | L17/amo40 | 17 | 17040000030677 | 17040000030727 | 2 | Mme | Faustine | Voltzenlogel | ||
| 17040000030730 | L17/amo40 | 17 | 17040000030677 | 17040000030727 | 3 | Mme | Sarah | Bonnière | ||
| 17040000030731 | L17/amo40 | 17 | 17040000030677 | 17040000030727 | 4 | M. | Cyril | Mihai | ||
| 17040000030826 | L17/amo40 | 17 | 17040000030762 | 17040000030825 | 1 | Mme | Annabelle | Chelil | ||
| 17040000030827 | L17/amo40 | 17 | 17040000030762 | 17040000030825 | 2 | Mme | Imane | Bounouh | ||
| 17040000030828 | L17/amo40 | 17 | 17040000030762 | 17040000030825 | 3 | Mme | Marilyne | Yeou | ||
| 17040000030829 | L17/amo40 | 17 | 17040000030762 | 17040000030825 | 4 | M. | Sébastien | Goua | ||
| 17040000030867 | L17/amo40 | 17 | 17040000030831 | 17040000030866 | 1 | Mme | Agnès | Copin | ||
| 17040000030868 | L17/amo40 | 17 | 17040000030831 | 17040000030866 | 2 | M. | Maxime | Loth | ||
| 17040000030869 | L17/amo40 | 17 | 17040000030831 | 17040000030866 | 3 | Mme | Alexandra | Rivalain | ||
| 17040000030914 | L17/amo40 | 17 | 17040000030905 | 17040000030913 | 1 | M. | Roméo | Chomphoo | ||
| 17040000030915 | L17/amo40 | 17 | 17040000030905 | 17040000030913 | 2 | Mme | Charlotte | Brasse | ||
| 17040000030916 | L17/amo40 | 17 | 17040000030905 | 17040000030913 | 3 | M. | Clément | Coulet | ||
| 17040000031003 | L17/amo40 | 17 | 17040000030955 | 17040000031002 | 1 | Mme | Diane | Caffyn | ||
| 17040000031004 | L17/amo40 | 17 | 17040000030955 | 17040000031002 | 2 | Mme | Déliana | Renou | ||
| 17040000031005 | L17/amo40 | 17 | 17040000030955 | 17040000031002 | 3 | M. | Ilyes | Chebbi Krol | ||
| 17040000031006 | L17/amo40 | 17 | 17040000030955 | 17040000031002 | 4 | M. | Quentin | Bougheraba | ||
| 17040000031047 | L17/amo40 | 17 | 17040000031030 | 17040000031046 | 1 | M. | Cédric | Morzelle | ||
| 17040000031048 | L17/amo40 | 17 | 17040000031030 | 17040000031046 | 2 | M. | Léo | Bares |