amo40.acteur_mandat_collaborateurs_collaborateur
Chemin acteur.mandats.mandat.collaborateurs.collaborateur · présence : L17 100 %
2 070 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 100 % · 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 100 % |
| 9 | nom | VARCHAR | acteur.mandats.mandat.collaborateurs.collaborateur.nom · présence : L17 100 % |
| 10 | date_debut | VARCHAR | acteur.mandats.mandat.collaborateurs.collaborateur.dateDebut · présence : L17 100 % |
| 11 | date_fin | VARCHAR | acteur.mandats.mandat.collaborateurs.collaborateur.dateFin · présence : L17 100 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | qualite | prenom | nom | date_debut | date_fin |
|---|---|---|---|---|---|---|---|---|---|---|
| 17040000010765 | L17/amo40 | 17 | 17040000010748 | 17040000010763 | 2 | M. | Sylvain | Jager | ||
| 17040000010766 | L17/amo40 | 17 | 17040000010748 | 17040000010763 | 3 | Mme | Olga | Prokopieva | ||
| 17040000010835 | L17/amo40 | 17 | 17040000010797 | 17040000010834 | 1 | Mme | Léopoldine | Chambon | ||
| 17040000010836 | L17/amo40 | 17 | 17040000010797 | 17040000010834 | 2 | M. | Jean-Baptiste | Rolland | ||
| 17040000010837 | L17/amo40 | 17 | 17040000010797 | 17040000010834 | 3 | M. | Lilian | Corne | ||
| 17040000010908 | L17/amo40 | 17 | 17040000010867 | 17040000010907 | 1 | M. | Yacine | Khedim | ||
| 17040000010909 | L17/amo40 | 17 | 17040000010867 | 17040000010907 | 2 | Mme | Barbara | Zauli | ||
| 17040000010910 | L17/amo40 | 17 | 17040000010867 | 17040000010907 | 3 | Mme | Sarah | Mouheb | ||
| 17040000010911 | L17/amo40 | 17 | 17040000010867 | 17040000010907 | 4 | Mme | Agathe | Jamaux | ||
| 17040000010912 | L17/amo40 | 17 | 17040000010867 | 17040000010907 | 5 | Mme | Sasha | Bernert | ||
| 17040000010997 | L17/amo40 | 17 | 17040000010922 | 17040000010996 | 1 | Mme | Catherine | Alix | ||
| 17040000010998 | L17/amo40 | 17 | 17040000010922 | 17040000010996 | 2 | M. | Clément | Nauleau | ||
| 17040000010999 | L17/amo40 | 17 | 17040000010922 | 17040000010996 | 3 | Mme | Sophie | Alix-Liorit | ||
| 17040000011090 | L17/amo40 | 17 | 17040000011025 | 17040000011089 | 1 | M. | Yann | Legargeant | ||
| 17040000011091 | L17/amo40 | 17 | 17040000011025 | 17040000011089 | 2 | Mme | Anne | Mion | ||
| 17040000011092 | L17/amo40 | 17 | 17040000011025 | 17040000011089 | 3 | Mme | Mathilde | Mandin | ||
| 17040000011145 | L17/amo40 | 17 | 17040000011106 | 17040000011144 | 1 | Mme | Béatrice | Moinard | ||
| 17040000011146 | L17/amo40 | 17 | 17040000011106 | 17040000011144 | 2 | M. | Charly | Porcher | ||
| 17040000011174 | L17/amo40 | 17 | 17040000011150 | 17040000011173 | 1 | M. | Alban | Bourguignon | ||
| 17040000011175 | L17/amo40 | 17 | 17040000011150 | 17040000011173 | 2 | Mme | Morgane | Duchesne | ||
| 17040000011176 | L17/amo40 | 17 | 17040000011150 | 17040000011173 | 3 | M. | Axel | Ferry | ||
| 17040000011177 | L17/amo40 | 17 | 17040000011150 | 17040000011173 | 4 | M. | Hugo | Page | ||
| 17040000011215 | L17/amo40 | 17 | 17040000011203 | 17040000011214 | 1 | Mme | Estelle | Bennouara | ||
| 17040000011216 | L17/amo40 | 17 | 17040000011203 | 17040000011214 | 2 | Mme | Carla | Camilleri | ||
| 17040000011217 | L17/amo40 | 17 | 17040000011203 | 17040000011214 | 3 | Mme | Clara | Rataud | ||
| 17040000011272 | L17/amo40 | 17 | 17040000011252 | 17040000011271 | 1 | M. | Dimitri | Bourrié | ||
| 17040000011273 | L17/amo40 | 17 | 17040000011252 | 17040000011271 | 2 | Mme | Louise | Le Provost | ||
| 17040000011274 | L17/amo40 | 17 | 17040000011252 | 17040000011271 | 3 | M. | Quentin | Dagbert | ||
| 17040000011275 | L17/amo40 | 17 | 17040000011252 | 17040000011271 | 4 | M. | Bastien | Vigier | ||
| 17040000011276 | L17/amo40 | 17 | 17040000011252 | 17040000011271 | 5 | M. | Tristan | Paruch | ||
| 17040000011337 | L17/amo40 | 17 | 17040000011313 | 17040000011336 | 1 | Mme | Mathilde | Lacazette | ||
| 17040000011338 | L17/amo40 | 17 | 17040000011313 | 17040000011336 | 2 | M. | Hadrien | Thérasse | ||
| 17040000011339 | L17/amo40 | 17 | 17040000011313 | 17040000011336 | 3 | Mme | Camille | Diais | ||
| 17040000011340 | L17/amo40 | 17 | 17040000011313 | 17040000011336 | 4 | Mme | Léa | Grino-Lacassagne | ||
| 17040000011417 | L17/amo40 | 17 | 17040000011376 | 17040000011416 | 1 | M. | Xavier | Brouard | ||
| 17040000011418 | L17/amo40 | 17 | 17040000011376 | 17040000011416 | 2 | M. | François | Plaze | ||
| 17040000011419 | L17/amo40 | 17 | 17040000011376 | 17040000011416 | 3 | Mme | Valérie | Dauge | ||
| 17040000011472 | L17/amo40 | 17 | 17040000011440 | 17040000011471 | 1 | Mme | Virginie | Vincent | ||
| 17040000011473 | L17/amo40 | 17 | 17040000011440 | 17040000011471 | 2 | M. | Ambroise | Mejean | ||
| 17040000011474 | L17/amo40 | 17 | 17040000011440 | 17040000011471 | 3 | M. | Alexis | Izard | ||
| 17040000011532 | L17/amo40 | 17 | 17040000011520 | 17040000011531 | 1 | Mme | Anne | Martiréné | ||
| 17040000011533 | L17/amo40 | 17 | 17040000011520 | 17040000011531 | 2 | M. | Gabriel | Salesse | ||
| 17040000011602 | L17/amo40 | 17 | 17040000011587 | 17040000011601 | 1 | M. | Pierre-Emmanuel | Kentouri-Bonod | ||
| 17040000011603 | L17/amo40 | 17 | 17040000011587 | 17040000011601 | 2 | Mme | Sabrina | Abib | ||
| 17040000011604 | L17/amo40 | 17 | 17040000011587 | 17040000011601 | 3 | M. | Antoine | Jumel | ||
| 17040000011605 | L17/amo40 | 17 | 17040000011587 | 17040000011601 | 4 | M. | José | Brice | ||
| 17040000011606 | L17/amo40 | 17 | 17040000011587 | 17040000011601 | 5 | M. | Alexandre | Flory | ||
| 17040000011607 | L17/amo40 | 17 | 17040000011587 | 17040000011601 | 6 | Mme | Aline | Durand | ||
| 17040000011608 | L17/amo40 | 17 | 17040000011587 | 17040000011601 | 7 | Mme | Chloé | Noblet | ||
| 17040000011633 | L17/amo40 | 17 | 17040000011620 | 17040000011632 | 1 | Mme | Aurélia | Drif |