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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17020000021457 | L17/amo20 | 17 | 17020000021403 | 17020000021453 | 4 | M. | Benjamin | Galy | ||
| 17020000021537 | L17/amo20 | 17 | 17020000021485 | 17020000021536 | 1 | M. | Romain | Berthet | ||
| 17020000021538 | L17/amo20 | 17 | 17020000021485 | 17020000021536 | 2 | Mme | Fatima | Mbitel | ||
| 17020000021539 | L17/amo20 | 17 | 17020000021485 | 17020000021536 | 3 | Mme | Anne-Sophie | Nury | ||
| 17020000021540 | L17/amo20 | 17 | 17020000021485 | 17020000021536 | 4 | M. | Frédéric | Hopital | ||
| 17020000021608 | L17/amo20 | 17 | 17020000021541 | 17020000021607 | 1 | Mme | Karine | Sorin Lambert | ||
| 17020000021609 | L17/amo20 | 17 | 17020000021541 | 17020000021607 | 2 | Mme | Marianna | Didiergeorges | ||
| 17020000021610 | L17/amo20 | 17 | 17020000021541 | 17020000021607 | 3 | M. | Clément | Venet | ||
| 17020000021611 | L17/amo20 | 17 | 17020000021541 | 17020000021607 | 4 | Mme | Vanessa | Issermann | ||
| 17020000021740 | L17/amo20 | 17 | 17020000021612 | 17020000021739 | 1 | Mme | Astrid | Ribardière | ||
| 17020000021741 | L17/amo20 | 17 | 17020000021612 | 17020000021739 | 2 | Mme | Audrey | Nivole | ||
| 17020000021742 | L17/amo20 | 17 | 17020000021612 | 17020000021739 | 3 | Mme | Félicie | Jamen | ||
| 17020000021806 | L17/amo20 | 17 | 17020000021743 | 17020000021805 | 1 | M. | Louis-Sami | Ramdani | ||
| 17020000021807 | L17/amo20 | 17 | 17020000021743 | 17020000021805 | 2 | Mme | Coline | Caniard | ||
| 17020000021808 | L17/amo20 | 17 | 17020000021743 | 17020000021805 | 3 | M. | Léopold | Lavou-Soriano | ||
| 17020000021809 | L17/amo20 | 17 | 17020000021743 | 17020000021805 | 4 | Mme | Garance | Blettery | ||
| 17020000021907 | L17/amo20 | 17 | 17020000021810 | 17020000021906 | 1 | Mme | Edith | Sellier | ||
| 17020000021908 | L17/amo20 | 17 | 17020000021810 | 17020000021906 | 2 | Mme | Valérie | Chaumanet | ||
| 17020000021909 | L17/amo20 | 17 | 17020000021810 | 17020000021906 | 3 | Mme | Agnès | Pardon | ||
| 17020000021910 | L17/amo20 | 17 | 17020000021810 | 17020000021906 | 4 | M. | Roland | Comte | ||
| 17020000021911 | L17/amo20 | 17 | 17020000021810 | 17020000021906 | 5 | M. | Jean-Michel | Gimard | ||
| 17020000021955 | L17/amo20 | 17 | 17020000021912 | 17020000021954 | 1 | Mme | Rachelle | De Wever | ||
| 17020000021956 | L17/amo20 | 17 | 17020000021912 | 17020000021954 | 2 | M. | Gautier | Boband | ||
| 17020000021957 | L17/amo20 | 17 | 17020000021912 | 17020000021954 | 3 | Mme | Hélène | de Fombelle | ||
| 17020000021958 | L17/amo20 | 17 | 17020000021912 | 17020000021954 | 4 | M. | Yonathan | Bellaiche | ||
| 17020000021959 | L17/amo20 | 17 | 17020000021912 | 17020000021954 | 5 | M. | Valentin | Joly | ||
| 17020000021960 | L17/amo20 | 17 | 17020000021912 | 17020000021954 | 6 | M. | Léo | Pimentel | ||
| 17020000022038 | L17/amo20 | 17 | 17020000021961 | 17020000022037 | 1 | M. | Mustapha | Gharbi | ||
| 17020000022039 | L17/amo20 | 17 | 17020000021961 | 17020000022037 | 2 | M. | Merlin | Gautier | ||
| 17020000022040 | L17/amo20 | 17 | 17020000021961 | 17020000022037 | 3 | M. | Tim | Blanloeil | ||
| 17020000022041 | L17/amo20 | 17 | 17020000021961 | 17020000022037 | 4 | M. | Tom | Bernard | ||
| 17020000022042 | L17/amo20 | 17 | 17020000021961 | 17020000022037 | 5 | Mme | Anaïs | Besse-Renard | ||
| 17020000022107 | L17/amo20 | 17 | 17020000022043 | 17020000022106 | 1 | Mme | Christine | Legnani | ||
| 17020000022108 | L17/amo20 | 17 | 17020000022043 | 17020000022106 | 2 | M. | Marin | Fournier | ||
| 17020000022109 | L17/amo20 | 17 | 17020000022043 | 17020000022106 | 3 | M. | Maxime | Viancin | ||
| 17020000022183 | L17/amo20 | 17 | 17020000022110 | 17020000022182 | 1 | M. | Samuel | Langlade | ||
| 17020000022184 | L17/amo20 | 17 | 17020000022110 | 17020000022182 | 2 | Mme | Maëlis | Juvin | ||
| 17020000022185 | L17/amo20 | 17 | 17020000022110 | 17020000022182 | 3 | M. | Philippe | Le Boulanger | ||
| 17020000022248 | L17/amo20 | 17 | 17020000022186 | 17020000022247 | 1 | M. | Maxime | Hupel | ||
| 17020000022249 | L17/amo20 | 17 | 17020000022186 | 17020000022247 | 2 | Mme | Solenn | Maray | ||
| 17020000022250 | L17/amo20 | 17 | 17020000022186 | 17020000022247 | 3 | Mme | Zoé | Bédelet | ||
| 17020000022251 | L17/amo20 | 17 | 17020000022186 | 17020000022247 | 4 | Mme | Ariane | Rambaud | ||
| 17020000022324 | L17/amo20 | 17 | 17020000022252 | 17020000022323 | 1 | M. | David | Faustin | ||
| 17020000022325 | L17/amo20 | 17 | 17020000022252 | 17020000022323 | 2 | M. | Thomas | Lefeuvre | ||
| 17020000022326 | L17/amo20 | 17 | 17020000022252 | 17020000022323 | 3 | M. | Sébastien | Tixier | ||
| 17020000022327 | L17/amo20 | 17 | 17020000022252 | 17020000022323 | 4 | Mme | Pauline | Bunel | ||
| 17020000022328 | L17/amo20 | 17 | 17020000022252 | 17020000022323 | 5 | M. | Morgan | Ceulemans | ||
| 17020000022404 | L17/amo20 | 17 | 17020000022392 | 17020000022403 | 1 | M. | Hugo | Frery | ||
| 17020000022405 | L17/amo20 | 17 | 17020000022392 | 17020000022403 | 2 | M. | Hervé | Maître | ||
| 17020000022406 | L17/amo20 | 17 | 17020000022392 | 17020000022403 | 3 | Mme | Sophie | Paillard |