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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17020000032294 | L17/amo20 | 17 | 17020000032250 | 17020000032292 | 2 | M. | Louis-Marie | Gautier | ||
| 17020000032295 | L17/amo20 | 17 | 17020000032250 | 17020000032292 | 3 | Mme | Emmanuelle | Duroyon | ||
| 17020000032350 | L17/amo20 | 17 | 17020000032296 | 17020000032349 | 1 | M. | Théo | Wallon | ||
| 17020000032351 | L17/amo20 | 17 | 17020000032296 | 17020000032349 | 2 | M. | Mathieu | Grimpret | ||
| 17020000032352 | L17/amo20 | 17 | 17020000032296 | 17020000032349 | 3 | Mme | Sophie | Lenormand | ||
| 17020000032353 | L17/amo20 | 17 | 17020000032296 | 17020000032349 | 4 | M. | Arnaud | Cervelle | ||
| 17020000032354 | L17/amo20 | 17 | 17020000032296 | 17020000032349 | 5 | M. | Eloi | Florin | ||
| 17020000032406 | L17/amo20 | 17 | 17020000032355 | 17020000032405 | 1 | Mme | Laetitia | Roland | ||
| 17020000032407 | L17/amo20 | 17 | 17020000032355 | 17020000032405 | 2 | M. | Louis | Maussant | ||
| 17020000032408 | L17/amo20 | 17 | 17020000032355 | 17020000032405 | 3 | M. | Stéfano | Canale | ||
| 17020000032409 | L17/amo20 | 17 | 17020000032355 | 17020000032405 | 4 | M. | Maximilien | Jendrzezak | ||
| 17020000032448 | L17/amo20 | 17 | 17020000032410 | 17020000032447 | 1 | M. | Gilles | Montreuil | ||
| 17020000032449 | L17/amo20 | 17 | 17020000032410 | 17020000032447 | 2 | M. | Julien | Hamy | ||
| 17020000032450 | L17/amo20 | 17 | 17020000032410 | 17020000032447 | 3 | Mme | Leslie | Dervaux | ||
| 17020000032451 | L17/amo20 | 17 | 17020000032410 | 17020000032447 | 4 | M. | Alexis | Goeury | ||
| 17020000032452 | L17/amo20 | 17 | 17020000032410 | 17020000032447 | 5 | M. | Noé | Carette | ||
| 17020000032453 | L17/amo20 | 17 | 17020000032410 | 17020000032447 | 6 | M. | Alexis | Audant | ||
| 17020000032542 | L17/amo20 | 17 | 17020000032527 | 17020000032541 | 1 | Mme | Anna | Loescher | ||
| 17020000032543 | L17/amo20 | 17 | 17020000032527 | 17020000032541 | 2 | M. | Karel | Sirjacq | ||
| 17020000032544 | L17/amo20 | 17 | 17020000032527 | 17020000032541 | 3 | Mme | Pauline | Jaffré | ||
| 17020000032616 | L17/amo20 | 17 | 17020000032545 | 17020000032615 | 1 | M. | Quentin | Dellong | ||
| 17020000032617 | L17/amo20 | 17 | 17020000032545 | 17020000032615 | 2 | M. | Thierry | Nhun Fat | ||
| 17020000032618 | L17/amo20 | 17 | 17020000032545 | 17020000032615 | 3 | Mme | Emma | Mathieu | ||
| 17020000032619 | L17/amo20 | 17 | 17020000032545 | 17020000032615 | 4 | M. | Teiki | Dubois | ||
| 17020000032660 | L17/amo20 | 17 | 17020000032620 | 17020000032659 | 1 | Mme | Clarisse | Garcier | ||
| 17020000032661 | L17/amo20 | 17 | 17020000032620 | 17020000032659 | 2 | Mme | Agathe | Decaroli | ||
| 17020000032662 | L17/amo20 | 17 | 17020000032620 | 17020000032659 | 3 | M. | Roland | Morard | ||
| 17020000032719 | L17/amo20 | 17 | 17020000032663 | 17020000032718 | 1 | M. | Quentin | Coignus | ||
| 17020000032720 | L17/amo20 | 17 | 17020000032663 | 17020000032718 | 2 | Mme | Sophie | Croizat | ||
| 17020000032721 | L17/amo20 | 17 | 17020000032663 | 17020000032718 | 3 | M. | Elie | Cordier | ||
| 17020000032722 | L17/amo20 | 17 | 17020000032663 | 17020000032718 | 4 | M. | Lucas | Mikaélian | ||
| 17020000032814 | L17/amo20 | 17 | 17020000032723 | 17020000032813 | 1 | M. | Vincent | Bonnardel | ||
| 17020000032815 | L17/amo20 | 17 | 17020000032723 | 17020000032813 | 2 | Mme | Aurore | Ziga | ||
| 17020000032816 | L17/amo20 | 17 | 17020000032723 | 17020000032813 | 3 | Mme | Myrna | Doniz Le Loarer | ||
| 17020000032817 | L17/amo20 | 17 | 17020000032723 | 17020000032813 | 4 | M. | Baptiste | Balezeau | ||
| 17020000032871 | L17/amo20 | 17 | 17020000032818 | 17020000032870 | 1 | Mme | Laure | Carrel-Billiard | ||
| 17020000032872 | L17/amo20 | 17 | 17020000032818 | 17020000032870 | 2 | M. | Cris | Pajon | ||
| 17020000032873 | L17/amo20 | 17 | 17020000032818 | 17020000032870 | 3 | M. | Killian | Delarbre | ||
| 17020000032892 | L17/amo20 | 17 | 17020000032874 | 17020000032891 | 1 | M. | Adonis | Zlayji | ||
| 17020000032893 | L17/amo20 | 17 | 17020000032874 | 17020000032891 | 2 | Mme | Sabine | Giordan | ||
| 17020000032894 | L17/amo20 | 17 | 17020000032874 | 17020000032891 | 3 | Mme | Karen | Allais | ||
| 17020000032956 | L17/amo20 | 17 | 17020000032914 | 17020000032955 | 1 | Mme | Marion | Richard du Montellier | ||
| 17020000032957 | L17/amo20 | 17 | 17020000032914 | 17020000032955 | 2 | M. | Anthony | Bouvier | ||
| 17020000032958 | L17/amo20 | 17 | 17020000032914 | 17020000032955 | 3 | Mme | Astrée | Petit | ||
| 17020000032987 | L17/amo20 | 17 | 17020000032970 | 17020000032986 | 1 | M. | Florent | Ghisi | ||
| 17020000032988 | L17/amo20 | 17 | 17020000032970 | 17020000032986 | 2 | M. | Mathis | Maurial | ||
| 17020000033020 | L17/amo20 | 17 | 17020000032989 | 17020000033019 | 1 | M. | Arnaud | Keller | ||
| 17020000033021 | L17/amo20 | 17 | 17020000032989 | 17020000033019 | 2 | M. | Médéric | Kovalevsky | ||
| 17020000033022 | L17/amo20 | 17 | 17020000032989 | 17020000033019 | 3 | M. | Bryan | Vincent | ||
| 17020000033090 | L17/amo20 | 17 | 17020000033023 | 17020000033089 | 1 | Mme | Estelle | Angles |