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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 15020000033035 | L15/amo20 | 15 | 15020000032991 | 15020000033033 | 2 | Mme | Céline | Philippe | ||
| 15020000033036 | L15/amo20 | 15 | 15020000032991 | 15020000033033 | 3 | Mme | Lisa | Wingerter | ||
| 15020000033037 | L15/amo20 | 15 | 15020000032991 | 15020000033033 | 4 | Mme | Amandine | Herbaux | ||
| 15020000033093 | L15/amo20 | 15 | 15020000033038 | 15020000033092 | 1 | Mme | Anabel | Mayer | ||
| 15020000033094 | L15/amo20 | 15 | 15020000033038 | 15020000033092 | 2 | M. | Emmanuel | Bertin | ||
| 15020000033095 | L15/amo20 | 15 | 15020000033038 | 15020000033092 | 3 | M. | Jean-Rémy | Dushimiyimana | ||
| 15020000033163 | L15/amo20 | 15 | 15020000033096 | 15020000033162 | 1 | M. | Thibaud | Muller | ||
| 15020000033164 | L15/amo20 | 15 | 15020000033096 | 15020000033162 | 2 | Mme | Natacha | Masseret | ||
| 15020000033165 | L15/amo20 | 15 | 15020000033096 | 15020000033162 | 3 | Mme | Nadia | Lazrag | ||
| 15020000033205 | L15/amo20 | 15 | 15020000033166 | 15020000033204 | 1 | M. | Jérémy | Sebbane | ||
| 15020000033206 | L15/amo20 | 15 | 15020000033166 | 15020000033204 | 2 | M. | Alban | Ah-Yu | ||
| 15020000033207 | L15/amo20 | 15 | 15020000033166 | 15020000033204 | 3 | Mme | Claire | Martin | ||
| 15020000033235 | L15/amo20 | 15 | 15020000033208 | 15020000033234 | 1 | Mme | Christelle | Pilleux | ||
| 15020000033236 | L15/amo20 | 15 | 15020000033208 | 15020000033234 | 2 | Mme | Audrey | Levavasseur | ||
| 15020000033237 | L15/amo20 | 15 | 15020000033208 | 15020000033234 | 3 | M. | Stéphane | Guehrar | ||
| 15020000033282 | L15/amo20 | 15 | 15020000033238 | 15020000033281 | 1 | M. | Jean-Luc | Toulza | ||
| 15020000033283 | L15/amo20 | 15 | 15020000033238 | 15020000033281 | 2 | M. | Benjamin | Recher | ||
| 15020000033319 | L15/amo20 | 15 | 15020000033284 | 15020000033318 | 1 | M. | François | Plaine | ||
| 15020000033320 | L15/amo20 | 15 | 15020000033284 | 15020000033318 | 2 | Mme | Gwenaëlle | Marques | ||
| 15020000033362 | L15/amo20 | 15 | 15020000033321 | 15020000033361 | 1 | M. | Valentin | Gomes | ||
| 15020000033363 | L15/amo20 | 15 | 15020000033321 | 15020000033361 | 2 | Mme | Valérie | Delong | ||
| 15020000033364 | L15/amo20 | 15 | 15020000033321 | 15020000033361 | 3 | M. | Maurice | Houzard | ||
| 15020000033406 | L15/amo20 | 15 | 15020000033365 | 15020000033405 | 1 | M. | Samy | Olivier | ||
| 15020000033407 | L15/amo20 | 15 | 15020000033365 | 15020000033405 | 2 | M. | Roland | D'Argy | ||
| 15020000033408 | L15/amo20 | 15 | 15020000033365 | 15020000033405 | 3 | Mme | Julie | Leturcq | ||
| 15020000033486 | L15/amo20 | 15 | 15020000033409 | 15020000033485 | 1 | Mme | Clémentine | Paluszezak | ||
| 15020000033487 | L15/amo20 | 15 | 15020000033409 | 15020000033485 | 2 | M. | Antoine | Béchet | ||
| 15020000033530 | L15/amo20 | 15 | 15020000033488 | 15020000033529 | 1 | M. | Rui | Antunes | ||
| 15020000033531 | L15/amo20 | 15 | 15020000033488 | 15020000033529 | 2 | Mme | Joëlle | Tornotti-Bouttefeux | ||
| 15020000033532 | L15/amo20 | 15 | 15020000033488 | 15020000033529 | 3 | Mme | Dey | Muteba | ||
| 15020000033533 | L15/amo20 | 15 | 15020000033488 | 15020000033529 | 4 | M. | David | Bouchard | ||
| 15020000033568 | L15/amo20 | 15 | 15020000033534 | 15020000033567 | 1 | M. | David | Bouchard | ||
| 15020000033569 | L15/amo20 | 15 | 15020000033534 | 15020000033567 | 2 | Mme | Mila | Legay | ||
| 15020000033632 | L15/amo20 | 15 | 15020000033570 | 15020000033631 | 1 | M. | Pierre | Pavy | ||
| 15020000033633 | L15/amo20 | 15 | 15020000033570 | 15020000033631 | 2 | Mme | Anissa | Yekken | ||
| 15020000033669 | L15/amo20 | 15 | 15020000033634 | 15020000033668 | 1 | Mme | Anaïs | Varlet | ||
| 15020000033670 | L15/amo20 | 15 | 15020000033634 | 15020000033668 | 2 | Mme | Régine | Andris | ||
| 15020000033671 | L15/amo20 | 15 | 15020000033634 | 15020000033668 | 3 | Mme | Caroline | Varlet | ||
| 15020000033672 | L15/amo20 | 15 | 15020000033634 | 15020000033668 | 4 | M. | Damien | Toumi | ||
| 15020000033722 | L15/amo20 | 15 | 15020000033673 | 15020000033721 | 1 | Mme | Aurélie | Legrand | ||
| 15020000033723 | L15/amo20 | 15 | 15020000033673 | 15020000033721 | 2 | M. | Julien | Di Maggio | ||
| 15020000033724 | L15/amo20 | 15 | 15020000033673 | 15020000033721 | 3 | M. | Guillaume | Cordier | ||
| 15020000033757 | L15/amo20 | 15 | 15020000033725 | 15020000033756 | 1 | Mme | Juliette | Lorthoy | ||
| 15020000033758 | L15/amo20 | 15 | 15020000033725 | 15020000033756 | 2 | Mme | Kelly | Verkindere | ||
| 15020000033759 | L15/amo20 | 15 | 15020000033725 | 15020000033756 | 3 | Mme | Clara | Cornille | ||
| 15020000033799 | L15/amo20 | 15 | 15020000033760 | 15020000033798 | 1 | M. | Stéphane | Thiery | ||
| 15020000033800 | L15/amo20 | 15 | 15020000033760 | 15020000033798 | 2 | M. | Djamel | Kerrouche | ||
| 15020000033801 | L15/amo20 | 15 | 15020000033760 | 15020000033798 | 3 | M. | Marc | Vasseur | ||
| 15020000033802 | L15/amo20 | 15 | 15020000033760 | 15020000033798 | 4 | Mme | Ijja | El Ghoul | ||
| 15020000033852 | L15/amo20 | 15 | 15020000033803 | 15020000033851 | 1 | M. | Philippe | Reich |