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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 15020000030026 | L15/amo20 | 15 | 15020000029965 | 15020000030023 | 3 | Mme | Sonia-Sarah | Bakrim | ||
| 15020000030071 | L15/amo20 | 15 | 15020000030027 | 15020000030070 | 1 | Mme | Lindy | Pollet | ||
| 15020000030072 | L15/amo20 | 15 | 15020000030027 | 15020000030070 | 2 | Mme | Genia | Pislaru | ||
| 15020000030073 | L15/amo20 | 15 | 15020000030027 | 15020000030070 | 3 | M. | Julien | Petrequin | ||
| 15020000030120 | L15/amo20 | 15 | 15020000030074 | 15020000030119 | 1 | Mme | Aline | Verger | ||
| 15020000030121 | L15/amo20 | 15 | 15020000030074 | 15020000030119 | 2 | Mme | Elise | Frajerman | ||
| 15020000030122 | L15/amo20 | 15 | 15020000030074 | 15020000030119 | 3 | Mme | Maïmouna | Ndong-Etroit | ||
| 15020000030175 | L15/amo20 | 15 | 15020000030123 | 15020000030174 | 1 | Mme | Marianne | Chambard | ||
| 15020000030176 | L15/amo20 | 15 | 15020000030123 | 15020000030174 | 2 | M. | Michaël | Miel-Margeretta | ||
| 15020000030177 | L15/amo20 | 15 | 15020000030123 | 15020000030174 | 3 | Mme | Nathalie | Coron | ||
| 15020000030268 | L15/amo20 | 15 | 15020000030217 | 15020000030267 | 1 | M. | Christophe | Labruyere | ||
| 15020000030269 | L15/amo20 | 15 | 15020000030217 | 15020000030267 | 2 | M. | Antoine | Courant | ||
| 15020000030270 | L15/amo20 | 15 | 15020000030217 | 15020000030267 | 3 | Mme | Marie-Pierre | Gazo | ||
| 15020000030271 | L15/amo20 | 15 | 15020000030217 | 15020000030267 | 4 | M. | Charles | Dujour Bosquet | ||
| 15020000030321 | L15/amo20 | 15 | 15020000030272 | 15020000030320 | 1 | M. | Pierre | Pécastaings | ||
| 15020000030322 | L15/amo20 | 15 | 15020000030272 | 15020000030320 | 2 | M. | Mehdi | Rahoui | ||
| 15020000030323 | L15/amo20 | 15 | 15020000030272 | 15020000030320 | 3 | M. | Jean-François | Broqueres | ||
| 15020000030324 | L15/amo20 | 15 | 15020000030272 | 15020000030320 | 4 | M. | Julien | Biremont | ||
| 15020000030379 | L15/amo20 | 15 | 15020000030325 | 15020000030378 | 1 | M. | Philippe | Quéré | ||
| 15020000030380 | L15/amo20 | 15 | 15020000030325 | 15020000030378 | 2 | Mme | Magali | Valiorgue-Larrouy | ||
| 15020000030381 | L15/amo20 | 15 | 15020000030325 | 15020000030378 | 3 | M. | Nicolas | Bighetti de Flogny | ||
| 15020000030382 | L15/amo20 | 15 | 15020000030325 | 15020000030378 | 4 | Mme | Edith | Frechou | ||
| 15020000030571 | L15/amo20 | 15 | 15020000030478 | 15020000030570 | 1 | Mme | Alla | Cecoltan | ||
| 15020000030572 | L15/amo20 | 15 | 15020000030478 | 15020000030570 | 2 | Mme | Audrey | Lyonnet | ||
| 15020000030645 | L15/amo20 | 15 | 15020000030573 | 15020000030644 | 1 | Mme | Chrystèle | Aguilar | ||
| 15020000030646 | L15/amo20 | 15 | 15020000030573 | 15020000030644 | 2 | Mme | Bohdana | Fedun | ||
| 15020000030647 | L15/amo20 | 15 | 15020000030573 | 15020000030644 | 3 | M. | Dorian | Lechelle | ||
| 15020000030695 | L15/amo20 | 15 | 15020000030648 | 15020000030694 | 1 | Mme | Aurélie | Jaidane | ||
| 15020000030696 | L15/amo20 | 15 | 15020000030648 | 15020000030694 | 2 | Mme | Joëlle | Argot | ||
| 15020000030697 | L15/amo20 | 15 | 15020000030648 | 15020000030694 | 3 | Mme | Jacqueline | Boudignon | ||
| 15020000030698 | L15/amo20 | 15 | 15020000030648 | 15020000030694 | 4 | M. | Hugo | Page | ||
| 15020000030760 | L15/amo20 | 15 | 15020000030699 | 15020000030759 | 1 | Mme | Auriane | Gourbeyre | ||
| 15020000030761 | L15/amo20 | 15 | 15020000030699 | 15020000030759 | 2 | M. | Michaël | Forge | ||
| 15020000030762 | L15/amo20 | 15 | 15020000030699 | 15020000030759 | 3 | Mme | Melodie | Gardon | ||
| 15020000030826 | L15/amo20 | 15 | 15020000030763 | 15020000030825 | 1 | M. | Olivier | Klasser | ||
| 15020000030827 | L15/amo20 | 15 | 15020000030763 | 15020000030825 | 2 | Mme | Margaux | Retif | ||
| 15020000030889 | L15/amo20 | 15 | 15020000030878 | 15020000030888 | 1 | M. | Olivier | Tonnerre | ||
| 15020000030890 | L15/amo20 | 15 | 15020000030878 | 15020000030888 | 2 | Mme | Florence | Daubrée | ||
| 15020000030891 | L15/amo20 | 15 | 15020000030878 | 15020000030888 | 3 | Mme | Sophie | Alix-Liorit | ||
| 15020000030892 | L15/amo20 | 15 | 15020000030878 | 15020000030888 | 4 | M. | Maxime | Castric | ||
| 15020000030993 | L15/amo20 | 15 | 15020000030893 | 15020000030992 | 1 | M. | Jean-Baptiste | Jallet | ||
| 15020000030994 | L15/amo20 | 15 | 15020000030893 | 15020000030992 | 2 | Mme | Ivanne | Leclercq | ||
| 15020000030995 | L15/amo20 | 15 | 15020000030893 | 15020000030992 | 3 | Mme | Adélaïde | Jammes | ||
| 15020000030996 | L15/amo20 | 15 | 15020000030893 | 15020000030992 | 4 | Mme | Nathalie | Fiacre | ||
| 15020000031052 | L15/amo20 | 15 | 15020000030997 | 15020000031051 | 1 | Mme | Claire | Rives | ||
| 15020000031053 | L15/amo20 | 15 | 15020000030997 | 15020000031051 | 2 | M. | Dorian | Terral | ||
| 15020000031054 | L15/amo20 | 15 | 15020000030997 | 15020000031051 | 3 | Mme | Camille | Harant | ||
| 15020000031098 | L15/amo20 | 15 | 15020000031055 | 15020000031097 | 1 | Mme | Oumaïma | Bahhate | ||
| 15020000031099 | L15/amo20 | 15 | 15020000031055 | 15020000031097 | 2 | Mme | Sarah | El Kaid | ||
| 15020000031162 | L15/amo20 | 15 | 15020000031100 | 15020000031161 | 1 | Mme | Graziella | Guillanton |