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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17020000010997 | L17/amo20 | 17 | 17020000010954 | 17020000010996 | 1 | Mme | Violaine | Cabidoche | ||
| 17020000010998 | L17/amo20 | 17 | 17020000010954 | 17020000010996 | 2 | Mme | Julie | Malozon | ||
| 17020000010999 | L17/amo20 | 17 | 17020000010954 | 17020000010996 | 3 | M. | Xavier | Sy | ||
| 17020000011029 | L17/amo20 | 17 | 17020000011000 | 17020000011028 | 1 | M. | Laurent | Dassonville | ||
| 17020000011030 | L17/amo20 | 17 | 17020000011000 | 17020000011028 | 2 | M. | Laurent | Brice | ||
| 17020000011031 | L17/amo20 | 17 | 17020000011000 | 17020000011028 | 3 | M. | Louis | Mompeu | ||
| 17020000011032 | L17/amo20 | 17 | 17020000011000 | 17020000011028 | 4 | M. | Jérôme | Cochet | ||
| 17020000011094 | L17/amo20 | 17 | 17020000011033 | 17020000011093 | 1 | Mme | Lorédane | Cléret | ||
| 17020000011095 | L17/amo20 | 17 | 17020000011033 | 17020000011093 | 2 | Mme | Evre | Isikli | ||
| 17020000011096 | L17/amo20 | 17 | 17020000011033 | 17020000011093 | 3 | M. | Jacky | Sousa | ||
| 17020000011097 | L17/amo20 | 17 | 17020000011033 | 17020000011093 | 4 | Mme | Diadji | Sacko | ||
| 17020000011200 | L17/amo20 | 17 | 17020000011098 | 17020000011199 | 1 | Mme | Lucie | Kirchner | ||
| 17020000011201 | L17/amo20 | 17 | 17020000011098 | 17020000011199 | 2 | M. | David | Gallo | ||
| 17020000011202 | L17/amo20 | 17 | 17020000011098 | 17020000011199 | 3 | M. | Maximilien | Mesnard | ||
| 17020000011203 | L17/amo20 | 17 | 17020000011098 | 17020000011199 | 4 | M. | Alban | Mathon | ||
| 17020000011204 | L17/amo20 | 17 | 17020000011098 | 17020000011199 | 5 | M. | Tiziano | Zumkeller | ||
| 17020000011260 | L17/amo20 | 17 | 17020000011215 | 17020000011259 | 1 | M. | Helmi | M'Rabet | ||
| 17020000011261 | L17/amo20 | 17 | 17020000011215 | 17020000011259 | 2 | Mme | Elise | Trouvé-Buisson | ||
| 17020000011262 | L17/amo20 | 17 | 17020000011215 | 17020000011259 | 3 | M. | Clément | Morel | ||
| 17020000011263 | L17/amo20 | 17 | 17020000011215 | 17020000011259 | 4 | M. | Maxime | Dacalor | ||
| 17020000011264 | L17/amo20 | 17 | 17020000011215 | 17020000011259 | 5 | Mme | Lara | Bigorre | ||
| 17020000011265 | L17/amo20 | 17 | 17020000011215 | 17020000011259 | 6 | Mme | Lisa | Grailhe | ||
| 17020000011411 | L17/amo20 | 17 | 17020000011310 | 17020000011410 | 1 | M. | Gabriel | Deleglise | ||
| 17020000011412 | L17/amo20 | 17 | 17020000011310 | 17020000011410 | 2 | M. | Salwann | Kamouk | ||
| 17020000011413 | L17/amo20 | 17 | 17020000011310 | 17020000011410 | 3 | Mme | Aurore | Andrieu | ||
| 17020000011414 | L17/amo20 | 17 | 17020000011310 | 17020000011410 | 4 | M. | Niels | Pascal | ||
| 17020000011415 | L17/amo20 | 17 | 17020000011310 | 17020000011410 | 5 | M. | Abel | Hermel | ||
| 17020000011469 | L17/amo20 | 17 | 17020000011416 | 17020000011468 | 1 | M. | Pierre | Soulez | ||
| 17020000011470 | L17/amo20 | 17 | 17020000011416 | 17020000011468 | 2 | Mme | Sandrine | Serva | ||
| 17020000011471 | L17/amo20 | 17 | 17020000011416 | 17020000011468 | 3 | Mme | Lovely | Bergena | ||
| 17020000011472 | L17/amo20 | 17 | 17020000011416 | 17020000011468 | 4 | M. | Edwin | Phaeton | ||
| 17020000011513 | L17/amo20 | 17 | 17020000011473 | 17020000011512 | 1 | Mme | Laurence | de Saint Sernin | ||
| 17020000011514 | L17/amo20 | 17 | 17020000011473 | 17020000011512 | 2 | M. | Danick | Lator | ||
| 17020000011515 | L17/amo20 | 17 | 17020000011473 | 17020000011512 | 3 | M. | Fred | Sapotille | ||
| 17020000011516 | L17/amo20 | 17 | 17020000011473 | 17020000011512 | 4 | M. | Ruddy | Naime | ||
| 17020000011579 | L17/amo20 | 17 | 17020000011517 | 17020000011578 | 1 | Mme | Elyssa | Laurent | ||
| 17020000011580 | L17/amo20 | 17 | 17020000011517 | 17020000011578 | 2 | Mme | Célia | Louis-Marie | ||
| 17020000011581 | L17/amo20 | 17 | 17020000011517 | 17020000011578 | 3 | Mme | Annie-Laure | Hilarus | ||
| 17020000011582 | L17/amo20 | 17 | 17020000011517 | 17020000011578 | 4 | M. | Olivier | Lette | ||
| 17020000011583 | L17/amo20 | 17 | 17020000011517 | 17020000011578 | 5 | M. | Harry | Hersilie-Héloïse | ||
| 17020000011709 | L17/amo20 | 17 | 17020000011584 | 17020000011708 | 1 | M. | Roman | Kwiatkowski | ||
| 17020000011710 | L17/amo20 | 17 | 17020000011584 | 17020000011708 | 2 | M. | Joseph | Mecarsel | ||
| 17020000011711 | L17/amo20 | 17 | 17020000011584 | 17020000011708 | 3 | Mme | Sylvie | Autissier | ||
| 17020000011712 | L17/amo20 | 17 | 17020000011584 | 17020000011708 | 4 | Mme | Sofia | Khelloqi | ||
| 17020000011713 | L17/amo20 | 17 | 17020000011584 | 17020000011708 | 5 | Mme | Vera | Webert Makhlouf | ||
| 17020000011802 | L17/amo20 | 17 | 17020000011714 | 17020000011801 | 1 | M. | Vincent | Berthiot | ||
| 17020000011803 | L17/amo20 | 17 | 17020000011714 | 17020000011801 | 2 | Mme | Maylis | Lepinette | ||
| 17020000011804 | L17/amo20 | 17 | 17020000011714 | 17020000011801 | 3 | M. | Melvyn | Menard | ||
| 17020000011866 | L17/amo20 | 17 | 17020000011806 | 17020000011865 | 1 | M. | Eric | Parlier | ||
| 17020000011867 | L17/amo20 | 17 | 17020000011806 | 17020000011865 | 2 | Mme | Vanessa | Balbine |