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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17020000014799 | L17/amo20 | 17 | 17020000014715 | 17020000014797 | 2 | Mme | Diane | Virecoulon | ||
| 17020000014800 | L17/amo20 | 17 | 17020000014715 | 17020000014797 | 3 | M. | Quentin | Desiré | ||
| 17020000014801 | L17/amo20 | 17 | 17020000014715 | 17020000014797 | 4 | Mme | Ludine | Wagner | ||
| 17020000014846 | L17/amo20 | 17 | 17020000014802 | 17020000014845 | 1 | Mme | Fabienne | Tirtiaux | ||
| 17020000014847 | L17/amo20 | 17 | 17020000014802 | 17020000014845 | 2 | M. | Mathieu | Girandola | ||
| 17020000014848 | L17/amo20 | 17 | 17020000014802 | 17020000014845 | 3 | Mme | Lou | Esposito | ||
| 17020000014849 | L17/amo20 | 17 | 17020000014802 | 17020000014845 | 4 | M. | Maxime | Jambou | ||
| 17020000014896 | L17/amo20 | 17 | 17020000014850 | 17020000014895 | 1 | M. | Cyril | Berthier | ||
| 17020000014897 | L17/amo20 | 17 | 17020000014850 | 17020000014895 | 2 | M. | David | Ouzilou | ||
| 17020000014898 | L17/amo20 | 17 | 17020000014850 | 17020000014895 | 3 | Mme | Maelle | Savidan Midroit | ||
| 17020000014964 | L17/amo20 | 17 | 17020000014899 | 17020000014963 | 1 | Mme | Jacqueline | Lebrun | ||
| 17020000014965 | L17/amo20 | 17 | 17020000014899 | 17020000014963 | 2 | Mme | Karin | Kamalanavin | ||
| 17020000014966 | L17/amo20 | 17 | 17020000014899 | 17020000014963 | 3 | M. | Bastien | Da Silva Matias | ||
| 17020000015005 | L17/amo20 | 17 | 17020000014967 | 17020000015004 | 1 | Mme | Cécile | Muschotti | ||
| 17020000015006 | L17/amo20 | 17 | 17020000014967 | 17020000015004 | 2 | Mme | Christine | Christiansen | ||
| 17020000015007 | L17/amo20 | 17 | 17020000014967 | 17020000015004 | 3 | M. | Pierre-Antoine | Joly | ||
| 17020000015008 | L17/amo20 | 17 | 17020000014967 | 17020000015004 | 4 | M. | Jean | Payebien | ||
| 17020000015009 | L17/amo20 | 17 | 17020000014967 | 17020000015004 | 5 | M. | Céleste | Macquet | ||
| 17020000015071 | L17/amo20 | 17 | 17020000015010 | 17020000015070 | 1 | M. | Emmanuel | Rey | ||
| 17020000015072 | L17/amo20 | 17 | 17020000015010 | 17020000015070 | 2 | Mme | Isabelle | Lenglain | ||
| 17020000015073 | L17/amo20 | 17 | 17020000015010 | 17020000015070 | 3 | M. | Lucas | Leruste | ||
| 17020000015074 | L17/amo20 | 17 | 17020000015010 | 17020000015070 | 4 | Mme | Clara | Martinovic | ||
| 17020000015442 | L17/amo20 | 17 | 17020000015356 | 17020000015441 | 1 | Mme | Laétitia | Boutrais | ||
| 17020000015443 | L17/amo20 | 17 | 17020000015356 | 17020000015441 | 2 | Mme | Manon | Amirshahi | ||
| 17020000015444 | L17/amo20 | 17 | 17020000015356 | 17020000015441 | 3 | Mme | Sarah | Robin | ||
| 17020000015445 | L17/amo20 | 17 | 17020000015356 | 17020000015441 | 4 | Mme | Maritza | Munoz | ||
| 17020000015879 | L17/amo20 | 17 | 17020000015851 | 17020000015878 | 1 | M. | Olivier | Castel | ||
| 17020000015880 | L17/amo20 | 17 | 17020000015851 | 17020000015878 | 2 | M. | Jean-Claude | Benard | ||
| 17020000015881 | L17/amo20 | 17 | 17020000015851 | 17020000015878 | 3 | Mme | Sabine | Kulifekai-Sako | ||
| 17020000015882 | L17/amo20 | 17 | 17020000015851 | 17020000015878 | 4 | Mme | Logokiuva | Taalo | ||
| 17020000015963 | L17/amo20 | 17 | 17020000015905 | 17020000015962 | 1 | M. | Vianney | Calibre | ||
| 17020000015964 | L17/amo20 | 17 | 17020000015905 | 17020000015962 | 2 | Mme | Marine | Defalt | ||
| 17020000015965 | L17/amo20 | 17 | 17020000015905 | 17020000015962 | 3 | Mme | Stéphanie | Sloboda | ||
| 17020000016136 | L17/amo20 | 17 | 17020000016042 | 17020000016135 | 1 | M. | Michel | Chassereau | ||
| 17020000016137 | L17/amo20 | 17 | 17020000016042 | 17020000016135 | 2 | Mme | Océane | Cherré | ||
| 17020000016138 | L17/amo20 | 17 | 17020000016042 | 17020000016135 | 3 | M. | Gauthier | Boiza | ||
| 17020000016190 | L17/amo20 | 17 | 17020000016139 | 17020000016189 | 1 | M. | Cyril | Blondel | ||
| 17020000016191 | L17/amo20 | 17 | 17020000016139 | 17020000016189 | 2 | Mme | Delphine | Martin | ||
| 17020000016192 | L17/amo20 | 17 | 17020000016139 | 17020000016189 | 3 | M. | Guillaume | Seris | ||
| 17020000016269 | L17/amo20 | 17 | 17020000016193 | 17020000016268 | 1 | M. | Stéphane | Exposito | ||
| 17020000016270 | L17/amo20 | 17 | 17020000016193 | 17020000016268 | 2 | M. | Aurélien | Carré | ||
| 17020000016349 | L17/amo20 | 17 | 17020000016271 | 17020000016348 | 1 | Mme | Julie | Lebihan | ||
| 17020000016350 | L17/amo20 | 17 | 17020000016271 | 17020000016348 | 2 | M. | Stevie | Coudray | ||
| 17020000016351 | L17/amo20 | 17 | 17020000016271 | 17020000016348 | 3 | Mme | Anne-Laure | Payet | ||
| 17020000016352 | L17/amo20 | 17 | 17020000016271 | 17020000016348 | 4 | Mme | Coralie | Payet | ||
| 17020000017099 | L17/amo20 | 17 | 17020000017048 | 17020000017098 | 1 | M. | Anthony | Gony | ||
| 17020000017100 | L17/amo20 | 17 | 17020000017048 | 17020000017098 | 2 | M. | Alexandre | Gore | ||
| 17020000017101 | L17/amo20 | 17 | 17020000017048 | 17020000017098 | 3 | M. | Guillaume | Poignet | ||
| 17020000017102 | L17/amo20 | 17 | 17020000017048 | 17020000017098 | 4 | M. | Julien | Roussel | ||
| 17020000017176 | L17/amo20 | 17 | 17020000017103 | 17020000017175 | 1 | M. | Hendrik | Porte |