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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17020000033592 | L17/amo20 | 17 | 17020000033557 | 17020000033587 | 5 | M. | Joost | Lumia | ||
| 17020000033593 | L17/amo20 | 17 | 17020000033557 | 17020000033587 | 6 | M. | Charly | Sek | ||
| 17020000033624 | L17/amo20 | 17 | 17020000033594 | 17020000033623 | 1 | M. | Arnaud | Bordes-Penelope | ||
| 17020000033625 | L17/amo20 | 17 | 17020000033594 | 17020000033623 | 2 | M. | Fabrice | Rey | ||
| 17020000033626 | L17/amo20 | 17 | 17020000033594 | 17020000033623 | 3 | Mme | Emilie | Dumont | ||
| 17020000033627 | L17/amo20 | 17 | 17020000033594 | 17020000033623 | 4 | M. | Bertrand | Soulas | ||
| 17020000033693 | L17/amo20 | 17 | 17020000033628 | 17020000033692 | 1 | M. | Vincent | Picard | ||
| 17020000033694 | L17/amo20 | 17 | 17020000033628 | 17020000033692 | 2 | Mme | Louise | Pelletier | ||
| 17020000033695 | L17/amo20 | 17 | 17020000033628 | 17020000033692 | 3 | M. | Gabriel | Lapostolle | ||
| 17020000033696 | L17/amo20 | 17 | 17020000033628 | 17020000033692 | 4 | Mme | Juliette | Chaix | ||
| 17020000033697 | L17/amo20 | 17 | 17020000033628 | 17020000033692 | 5 | Mme | Claire | Mallard | ||
| 17020000033746 | L17/amo20 | 17 | 17020000033698 | 17020000033745 | 1 | M. | Victor | Le Monier | ||
| 17020000033747 | L17/amo20 | 17 | 17020000033698 | 17020000033745 | 2 | Mme | Aurélie | Mallet | ||
| 17020000033748 | L17/amo20 | 17 | 17020000033698 | 17020000033745 | 3 | Mme | Mathilde | Escoffier | ||
| 17020000033791 | L17/amo20 | 17 | 17020000033749 | 17020000033790 | 1 | M. | Vincent | Georget | ||
| 17020000033792 | L17/amo20 | 17 | 17020000033749 | 17020000033790 | 2 | M. | Guillaume | Pot | ||
| 17020000033793 | L17/amo20 | 17 | 17020000033749 | 17020000033790 | 3 | Mme | Honorine | Dubief | ||
| 17020000034024 | L17/amo20 | 17 | 17020000033794 | 17020000034023 | 1 | Mme | Béatrice | Boulanger | ||
| 17020000034025 | L17/amo20 | 17 | 17020000033794 | 17020000034023 | 2 | M. | Nicolas | Le Caroff | ||
| 17020000034026 | L17/amo20 | 17 | 17020000033794 | 17020000034023 | 3 | M. | Loïc | Vandier | ||
| 17020000034063 | L17/amo20 | 17 | 17020000034027 | 17020000034062 | 1 | Mme | Denise | Loué | ||
| 17020000034064 | L17/amo20 | 17 | 17020000034027 | 17020000034062 | 2 | M. | Joachim | Schauving | ||
| 17020000034065 | L17/amo20 | 17 | 17020000034027 | 17020000034062 | 3 | M. | Damien | Demarigny | ||
| 17020000034066 | L17/amo20 | 17 | 17020000034027 | 17020000034062 | 4 | Mme | Glwadys | Robert | ||
| 17020000034140 | L17/amo20 | 17 | 17020000034067 | 17020000034139 | 1 | M. | Franck | Rinchet-Girollet | ||
| 17020000034141 | L17/amo20 | 17 | 17020000034067 | 17020000034139 | 2 | Mme | Clémence | Anno | ||
| 17020000034142 | L17/amo20 | 17 | 17020000034067 | 17020000034139 | 3 | Mme | Myrtille | Bondu de Gryse | ||
| 17020000034259 | L17/amo20 | 17 | 17020000034188 | 17020000034258 | 1 | Mme | Cécile | Beaudouin | ||
| 17020000034260 | L17/amo20 | 17 | 17020000034188 | 17020000034258 | 2 | M. | Guillaume | Cléry | ||
| 17020000034261 | L17/amo20 | 17 | 17020000034188 | 17020000034258 | 3 | M. | Pierre | Tranvouez | ||
| 17020000034262 | L17/amo20 | 17 | 17020000034188 | 17020000034258 | 4 | Mme | Marie | Beurrier | ||
| 17020000034312 | L17/amo20 | 17 | 17020000034263 | 17020000034311 | 1 | M. | Pierre | Alessandrini | ||
| 17020000034313 | L17/amo20 | 17 | 17020000034263 | 17020000034311 | 2 | M. | Jean-Luc | Hallé | ||
| 17020000034314 | L17/amo20 | 17 | 17020000034263 | 17020000034311 | 3 | Mme | Laetitia | Pasqualini | ||
| 17020000034315 | L17/amo20 | 17 | 17020000034263 | 17020000034311 | 4 | Mme | Laetitia | Casoni | ||
| 17020000034332 | L17/amo20 | 17 | 17020000034316 | 17020000034331 | 1 | M. | Philippe | Galetto | ||
| 17020000034333 | L17/amo20 | 17 | 17020000034316 | 17020000034331 | 2 | M. | Xavier | Magnin-Wegmüller | ||
| 17020000034334 | L17/amo20 | 17 | 17020000034316 | 17020000034331 | 3 | Mme | Solène | Toulemonde | ||
| 17020000034335 | L17/amo20 | 17 | 17020000034316 | 17020000034331 | 4 | Mme | Marie-Charlotte | du Bourblanc | ||
| 17020000034393 | L17/amo20 | 17 | 17020000034336 | 17020000034392 | 1 | M. | Nathan | Casano | ||
| 17020000034394 | L17/amo20 | 17 | 17020000034336 | 17020000034392 | 2 | M. | Geoffrey | Morey | ||
| 17020000034395 | L17/amo20 | 17 | 17020000034336 | 17020000034392 | 3 | M. | Matthieu | Gallicher | ||
| 17020000034396 | L17/amo20 | 17 | 17020000034336 | 17020000034392 | 4 | Mme | Amandine | Roux | ||
| 17020000034430 | L17/amo20 | 17 | 17020000034397 | 17020000034429 | 1 | M. | Dorian | Lajunie | ||
| 17020000034431 | L17/amo20 | 17 | 17020000034397 | 17020000034429 | 2 | M. | Pierre | Rey | ||
| 17020000034432 | L17/amo20 | 17 | 17020000034397 | 17020000034429 | 3 | Mme | Manon | Deruem | ||
| 17020000034484 | L17/amo20 | 17 | 17020000034433 | 17020000034483 | 1 | M. | Mohamed | Bellarbi | ||
| 17020000034485 | L17/amo20 | 17 | 17020000034433 | 17020000034483 | 2 | M. | Martin | Olivo | ||
| 17020000034486 | L17/amo20 | 17 | 17020000034433 | 17020000034483 | 3 | M. | Christel | Gaudibert | ||
| 17020000034526 | L17/amo20 | 17 | 17020000034487 | 17020000034525 | 1 | M. | Emmanuel | Auger |