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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17020000036532 | L17/amo20 | 17 | 17020000036480 | 17020000036528 | 4 | Mme | Clotilde | Ferrand | ||
| 17020000036576 | L17/amo20 | 17 | 17020000036533 | 17020000036575 | 1 | Mme | Emilie | Thomas | ||
| 17020000036577 | L17/amo20 | 17 | 17020000036533 | 17020000036575 | 2 | M. | Adrien | Naves-Lauby | ||
| 17020000036578 | L17/amo20 | 17 | 17020000036533 | 17020000036575 | 3 | Mme | Aurélie | Pirillo | ||
| 17020000036579 | L17/amo20 | 17 | 17020000036533 | 17020000036575 | 4 | M. | Jérôme | Nury | ||
| 17020000036655 | L17/amo20 | 17 | 17020000036622 | 17020000036654 | 1 | M. | Thomas | Pamart | ||
| 17020000036656 | L17/amo20 | 17 | 17020000036622 | 17020000036654 | 2 | M. | Géraud | Mautin | ||
| 17020000036657 | L17/amo20 | 17 | 17020000036622 | 17020000036654 | 3 | Mme | Julie | Ledoux | ||
| 17020000036658 | L17/amo20 | 17 | 17020000036622 | 17020000036654 | 4 | M. | Yohan | Marcourt | ||
| 17020000036659 | L17/amo20 | 17 | 17020000036622 | 17020000036654 | 5 | M. | Yvenn | Le Coz | ||
| 17020000036944 | L17/amo20 | 17 | 17020000036660 | 17020000036943 | 1 | Mme | Sandrine | Demaret | ||
| 17020000036945 | L17/amo20 | 17 | 17020000036660 | 17020000036943 | 2 | M. | Quentin | Louis | ||
| 17020000036946 | L17/amo20 | 17 | 17020000036660 | 17020000036943 | 3 | Mme | Marion | Moreau | ||
| 17020000036947 | L17/amo20 | 17 | 17020000036660 | 17020000036943 | 4 | Mme | Rachel | Pohier | ||
| 17020000036983 | L17/amo20 | 17 | 17020000036948 | 17020000036982 | 1 | M. | Geoffrey | Rousseau | ||
| 17020000036984 | L17/amo20 | 17 | 17020000036948 | 17020000036982 | 2 | Mme | Camille | Lemaitre | ||
| 17020000036985 | L17/amo20 | 17 | 17020000036948 | 17020000036982 | 3 | Mme | Marine | Dutrieux | ||
| 17020000037026 | L17/amo20 | 17 | 17020000036986 | 17020000037025 | 1 | Mme | Gabrielle | Arestegui | ||
| 17020000037027 | L17/amo20 | 17 | 17020000036986 | 17020000037025 | 2 | M. | Alexis | Bernigaud | ||
| 17020000037028 | L17/amo20 | 17 | 17020000036986 | 17020000037025 | 3 | Mme | Anne | Lacouture | ||
| 17020000037029 | L17/amo20 | 17 | 17020000036986 | 17020000037025 | 4 | M. | Ibon | Arenas Aizpuru | ||
| 17020000037067 | L17/amo20 | 17 | 17020000037030 | 17020000037066 | 1 | M. | Jean-François | Delanoue | ||
| 17020000037068 | L17/amo20 | 17 | 17020000037030 | 17020000037066 | 2 | M. | Nicolas | Villain | ||
| 17020000037069 | L17/amo20 | 17 | 17020000037030 | 17020000037066 | 3 | M. | Robin | Hils | ||
| 17020000037142 | L17/amo20 | 17 | 17020000037070 | 17020000037141 | 1 | M. | Constant | Jeanson | ||
| 17020000037143 | L17/amo20 | 17 | 17020000037070 | 17020000037141 | 2 | M. | Fabrice | Torro | ||
| 17020000037144 | L17/amo20 | 17 | 17020000037070 | 17020000037141 | 3 | Mme | Lisa | Cros | ||
| 17020000037194 | L17/amo20 | 17 | 17020000037145 | 17020000037193 | 1 | Mme | Tiffany | Perez | ||
| 17020000037195 | L17/amo20 | 17 | 17020000037145 | 17020000037193 | 2 | M. | Jean-Bernard | Colomès | ||
| 17020000037196 | L17/amo20 | 17 | 17020000037145 | 17020000037193 | 3 | M. | Antoine | Bulard | ||
| 17020000037278 | L17/amo20 | 17 | 17020000037197 | 17020000037277 | 1 | M. | Robert | Vanherzeeke | ||
| 17020000037279 | L17/amo20 | 17 | 17020000037197 | 17020000037277 | 2 | Mme | Faustine | Voltzenlogel | ||
| 17020000037280 | L17/amo20 | 17 | 17020000037197 | 17020000037277 | 3 | Mme | Sarah | Bonnière | ||
| 17020000037281 | L17/amo20 | 17 | 17020000037197 | 17020000037277 | 4 | M. | Cyril | Mihai | ||
| 17020000037411 | L17/amo20 | 17 | 17020000037346 | 17020000037410 | 1 | Mme | Annabelle | Chelil | ||
| 17020000037412 | L17/amo20 | 17 | 17020000037346 | 17020000037410 | 2 | Mme | Imane | Bounouh | ||
| 17020000037413 | L17/amo20 | 17 | 17020000037346 | 17020000037410 | 3 | Mme | Marilyne | Yeou | ||
| 17020000037414 | L17/amo20 | 17 | 17020000037346 | 17020000037410 | 4 | M. | Sébastien | Goua | ||
| 17020000037486 | L17/amo20 | 17 | 17020000037415 | 17020000037485 | 1 | Mme | Agnès | Copin | ||
| 17020000037487 | L17/amo20 | 17 | 17020000037415 | 17020000037485 | 2 | M. | Maxime | Loth | ||
| 17020000037488 | L17/amo20 | 17 | 17020000037415 | 17020000037485 | 3 | Mme | Alexandra | Rivalain | ||
| 17020000037536 | L17/amo20 | 17 | 17020000037489 | 17020000037535 | 1 | M. | Roméo | Chomphoo | ||
| 17020000037537 | L17/amo20 | 17 | 17020000037489 | 17020000037535 | 2 | Mme | Charlotte | Brasse | ||
| 17020000037538 | L17/amo20 | 17 | 17020000037489 | 17020000037535 | 3 | M. | Clément | Coulet | ||
| 17020000037610 | L17/amo20 | 17 | 17020000037539 | 17020000037609 | 1 | Mme | Diane | Caffyn | ||
| 17020000037611 | L17/amo20 | 17 | 17020000037539 | 17020000037609 | 2 | Mme | Déliana | Renou | ||
| 17020000037612 | L17/amo20 | 17 | 17020000037539 | 17020000037609 | 3 | M. | Ilyes | Chebbi Krol | ||
| 17020000037613 | L17/amo20 | 17 | 17020000037539 | 17020000037609 | 4 | M. | Quentin | Bougheraba | ||
| 17020000037664 | L17/amo20 | 17 | 17020000037614 | 17020000037663 | 1 | M. | Cédric | Morzelle | ||
| 17020000037665 | L17/amo20 | 17 | 17020000037614 | 17020000037663 | 2 | M. | Léo | Bares |