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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17020000030853 | L17/amo20 | 17 | 17020000030763 | 17020000030851 | 2 | Mme | Aziza | Nouioua | ||
| 17020000030854 | L17/amo20 | 17 | 17020000030763 | 17020000030851 | 3 | Mme | Khady | Thiam | ||
| 17020000030855 | L17/amo20 | 17 | 17020000030763 | 17020000030851 | 4 | Mme | Léa | Frydman | ||
| 17020000030981 | L17/amo20 | 17 | 17020000030856 | 17020000030980 | 1 | Mme | Sarah | Leclerc | ||
| 17020000030982 | L17/amo20 | 17 | 17020000030856 | 17020000030980 | 2 | Mme | Sandra | Gence | ||
| 17020000030983 | L17/amo20 | 17 | 17020000030856 | 17020000030980 | 3 | Mme | Fabienne | Payet | ||
| 17020000030984 | L17/amo20 | 17 | 17020000030856 | 17020000030980 | 4 | Mme | Julia | Atchiama-Gangama | ||
| 17020000030985 | L17/amo20 | 17 | 17020000030856 | 17020000030980 | 5 | M. | Cédric | Arnassalom | ||
| 17020000031073 | L17/amo20 | 17 | 17020000030986 | 17020000031072 | 1 | Mme | Haïria | Abdallah | ||
| 17020000031074 | L17/amo20 | 17 | 17020000030986 | 17020000031072 | 2 | M. | Simon | Lochard | ||
| 17020000031112 | L17/amo20 | 17 | 17020000031083 | 17020000031111 | 1 | M. | Cédric | Kerdrébez | ||
| 17020000031113 | L17/amo20 | 17 | 17020000031083 | 17020000031111 | 2 | M. | Mathys | Claveau | ||
| 17020000031114 | L17/amo20 | 17 | 17020000031083 | 17020000031111 | 3 | Mme | Lubja | Bowman | ||
| 17020000031165 | L17/amo20 | 17 | 17020000031115 | 17020000031164 | 1 | Mme | Florence | Goyer | ||
| 17020000031166 | L17/amo20 | 17 | 17020000031115 | 17020000031164 | 2 | M. | Jonathan | Thirel | ||
| 17020000031167 | L17/amo20 | 17 | 17020000031115 | 17020000031164 | 3 | M. | Jacky | Sousa | ||
| 17020000031184 | L17/amo20 | 17 | 17020000031168 | 17020000031183 | 1 | M. | André-Yves | Beck | ||
| 17020000031185 | L17/amo20 | 17 | 17020000031168 | 17020000031183 | 2 | Mme | Jade | Lucy | ||
| 17020000031186 | L17/amo20 | 17 | 17020000031168 | 17020000031183 | 3 | M. | Albéric | Ferrand | ||
| 17020000031264 | L17/amo20 | 17 | 17020000031187 | 17020000031263 | 1 | M. | Elias | Kari | ||
| 17020000031265 | L17/amo20 | 17 | 17020000031187 | 17020000031263 | 2 | M. | Nicolas | Brunet | ||
| 17020000031266 | L17/amo20 | 17 | 17020000031187 | 17020000031263 | 3 | Mme | Anne-France | Abadie | ||
| 17020000031267 | L17/amo20 | 17 | 17020000031187 | 17020000031263 | 4 | Mme | Lola | Binet | ||
| 17020000031351 | L17/amo20 | 17 | 17020000031268 | 17020000031350 | 1 | M. | Benjamin | Lacourt | ||
| 17020000031352 | L17/amo20 | 17 | 17020000031268 | 17020000031350 | 2 | M. | Henri | Heidsieck | ||
| 17020000031353 | L17/amo20 | 17 | 17020000031268 | 17020000031350 | 3 | Mme | Emma | Guillot | ||
| 17020000031354 | L17/amo20 | 17 | 17020000031268 | 17020000031350 | 4 | Mme | Johaïna | Benchikh | ||
| 17020000031355 | L17/amo20 | 17 | 17020000031268 | 17020000031350 | 5 | Mme | Semsha | Cottret | ||
| 17020000031412 | L17/amo20 | 17 | 17020000031356 | 17020000031411 | 1 | Mme | Aude | Marchand | ||
| 17020000031413 | L17/amo20 | 17 | 17020000031356 | 17020000031411 | 2 | M. | Matthieu | Dussaigne | ||
| 17020000031414 | L17/amo20 | 17 | 17020000031356 | 17020000031411 | 3 | M. | Anthony | Brondel | ||
| 17020000031415 | L17/amo20 | 17 | 17020000031356 | 17020000031411 | 4 | Mme | Eileen | Chaix | ||
| 17020000031416 | L17/amo20 | 17 | 17020000031356 | 17020000031411 | 5 | M. | Vincent | Biton | ||
| 17020000031481 | L17/amo20 | 17 | 17020000031417 | 17020000031480 | 1 | Mme | Sandra | El Ouarghi | ||
| 17020000031482 | L17/amo20 | 17 | 17020000031417 | 17020000031480 | 2 | Mme | Mylène | Facchetti | ||
| 17020000031523 | L17/amo20 | 17 | 17020000031483 | 17020000031522 | 1 | Mme | Maria | Escribano | ||
| 17020000031524 | L17/amo20 | 17 | 17020000031483 | 17020000031522 | 2 | M. | Yann | Gilas | ||
| 17020000032175 | L17/amo20 | 17 | 17020000032147 | 17020000032174 | 1 | M. | Paul | Simbsler | ||
| 17020000032176 | L17/amo20 | 17 | 17020000032147 | 17020000032174 | 2 | Mme | Carla-Marie | Sieber | ||
| 17020000032177 | L17/amo20 | 17 | 17020000032147 | 17020000032174 | 3 | M. | Rémi | Ducros | ||
| 17020000032217 | L17/amo20 | 17 | 17020000032178 | 17020000032216 | 1 | Mme | Marie | Prinet | ||
| 17020000032218 | L17/amo20 | 17 | 17020000032178 | 17020000032216 | 2 | M. | Antoine | Mellies | ||
| 17020000032219 | L17/amo20 | 17 | 17020000032178 | 17020000032216 | 3 | Mme | Nathalie | Thai | ||
| 17020000032220 | L17/amo20 | 17 | 17020000032178 | 17020000032216 | 4 | Mme | Stéphanie | Lejeune | ||
| 17020000032221 | L17/amo20 | 17 | 17020000032178 | 17020000032216 | 5 | Mme | Valentine | Auroux-Delage | ||
| 17020000032222 | L17/amo20 | 17 | 17020000032178 | 17020000032216 | 6 | M. | Joost | Lumia | ||
| 17020000032247 | L17/amo20 | 17 | 17020000032223 | 17020000032246 | 1 | Mme | Olivia | Cruz | ||
| 17020000032248 | L17/amo20 | 17 | 17020000032223 | 17020000032246 | 2 | Mme | Flavia | Mangano | ||
| 17020000032249 | L17/amo20 | 17 | 17020000032223 | 17020000032246 | 3 | Mme | Hermine | Falicon | ||
| 17020000032293 | L17/amo20 | 17 | 17020000032250 | 17020000032292 | 1 | Mme | Marion | Lecaille |