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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17020000013847 | L17/amo20 | 17 | 17020000013800 | 17020000013845 | 2 | M. | Sylvain | Jager | ||
| 17020000013848 | L17/amo20 | 17 | 17020000013800 | 17020000013845 | 3 | Mme | Olga | Prokopieva | ||
| 17020000013916 | L17/amo20 | 17 | 17020000013849 | 17020000013915 | 1 | Mme | Léopoldine | Chambon | ||
| 17020000013917 | L17/amo20 | 17 | 17020000013849 | 17020000013915 | 2 | M. | Jean-Baptiste | Rolland | ||
| 17020000013918 | L17/amo20 | 17 | 17020000013849 | 17020000013915 | 3 | M. | Lilian | Corne | ||
| 17020000013969 | L17/amo20 | 17 | 17020000013919 | 17020000013968 | 1 | M. | Yacine | Khedim | ||
| 17020000013970 | L17/amo20 | 17 | 17020000013919 | 17020000013968 | 2 | Mme | Barbara | Zauli | ||
| 17020000013971 | L17/amo20 | 17 | 17020000013919 | 17020000013968 | 3 | Mme | Sarah | Mouheb | ||
| 17020000013972 | L17/amo20 | 17 | 17020000013919 | 17020000013968 | 4 | Mme | Agathe | Jamaux | ||
| 17020000013973 | L17/amo20 | 17 | 17020000013919 | 17020000013968 | 5 | Mme | Sasha | Bernert | ||
| 17020000014074 | L17/amo20 | 17 | 17020000013974 | 17020000014073 | 1 | Mme | Catherine | Alix | ||
| 17020000014075 | L17/amo20 | 17 | 17020000013974 | 17020000014073 | 2 | M. | Clément | Nauleau | ||
| 17020000014076 | L17/amo20 | 17 | 17020000013974 | 17020000014073 | 3 | Mme | Sophie | Alix-Liorit | ||
| 17020000014155 | L17/amo20 | 17 | 17020000014077 | 17020000014154 | 1 | M. | Yann | Legargeant | ||
| 17020000014156 | L17/amo20 | 17 | 17020000014077 | 17020000014154 | 2 | Mme | Anne | Mion | ||
| 17020000014157 | L17/amo20 | 17 | 17020000014077 | 17020000014154 | 3 | Mme | Mathilde | Mandin | ||
| 17020000014231 | L17/amo20 | 17 | 17020000014189 | 17020000014230 | 1 | Mme | Béatrice | Moinard | ||
| 17020000014232 | L17/amo20 | 17 | 17020000014189 | 17020000014230 | 2 | M. | Charly | Porcher | ||
| 17020000014282 | L17/amo20 | 17 | 17020000014233 | 17020000014281 | 1 | M. | Alban | Bourguignon | ||
| 17020000014283 | L17/amo20 | 17 | 17020000014233 | 17020000014281 | 2 | Mme | Morgane | Duchesne | ||
| 17020000014284 | L17/amo20 | 17 | 17020000014233 | 17020000014281 | 3 | M. | Axel | Ferry | ||
| 17020000014285 | L17/amo20 | 17 | 17020000014233 | 17020000014281 | 4 | M. | Hugo | Page | ||
| 17020000014332 | L17/amo20 | 17 | 17020000014286 | 17020000014331 | 1 | Mme | Estelle | Bennouara | ||
| 17020000014333 | L17/amo20 | 17 | 17020000014286 | 17020000014331 | 2 | Mme | Carla | Camilleri | ||
| 17020000014334 | L17/amo20 | 17 | 17020000014286 | 17020000014331 | 3 | Mme | Clara | Rataud | ||
| 17020000014391 | L17/amo20 | 17 | 17020000014335 | 17020000014390 | 1 | M. | Dimitri | Bourrié | ||
| 17020000014392 | L17/amo20 | 17 | 17020000014335 | 17020000014390 | 2 | Mme | Louise | Le Provost | ||
| 17020000014393 | L17/amo20 | 17 | 17020000014335 | 17020000014390 | 3 | M. | Quentin | Dagbert | ||
| 17020000014394 | L17/amo20 | 17 | 17020000014335 | 17020000014390 | 4 | M. | Bastien | Vigier | ||
| 17020000014395 | L17/amo20 | 17 | 17020000014335 | 17020000014390 | 5 | M. | Tristan | Paruch | ||
| 17020000014455 | L17/amo20 | 17 | 17020000014396 | 17020000014454 | 1 | Mme | Mathilde | Lacazette | ||
| 17020000014456 | L17/amo20 | 17 | 17020000014396 | 17020000014454 | 2 | M. | Hadrien | Thérasse | ||
| 17020000014457 | L17/amo20 | 17 | 17020000014396 | 17020000014454 | 3 | Mme | Camille | Diais | ||
| 17020000014458 | L17/amo20 | 17 | 17020000014396 | 17020000014454 | 4 | Mme | Léa | Grino-Lacassagne | ||
| 17020000014520 | L17/amo20 | 17 | 17020000014459 | 17020000014519 | 1 | M. | Xavier | Brouard | ||
| 17020000014521 | L17/amo20 | 17 | 17020000014459 | 17020000014519 | 2 | M. | François | Plaze | ||
| 17020000014522 | L17/amo20 | 17 | 17020000014459 | 17020000014519 | 3 | Mme | Valérie | Dauge | ||
| 17020000014600 | L17/amo20 | 17 | 17020000014523 | 17020000014599 | 1 | Mme | Virginie | Vincent | ||
| 17020000014601 | L17/amo20 | 17 | 17020000014523 | 17020000014599 | 2 | M. | Ambroise | Mejean | ||
| 17020000014602 | L17/amo20 | 17 | 17020000014523 | 17020000014599 | 3 | M. | Alexis | Izard | ||
| 17020000014668 | L17/amo20 | 17 | 17020000014603 | 17020000014667 | 1 | Mme | Anne | Martiréné | ||
| 17020000014669 | L17/amo20 | 17 | 17020000014603 | 17020000014667 | 2 | M. | Gabriel | Salesse | ||
| 17020000014696 | L17/amo20 | 17 | 17020000014670 | 17020000014695 | 1 | M. | Pierre-Emmanuel | Kentouri-Bonod | ||
| 17020000014697 | L17/amo20 | 17 | 17020000014670 | 17020000014695 | 2 | Mme | Sabrina | Abib | ||
| 17020000014698 | L17/amo20 | 17 | 17020000014670 | 17020000014695 | 3 | M. | Antoine | Jumel | ||
| 17020000014699 | L17/amo20 | 17 | 17020000014670 | 17020000014695 | 4 | M. | José | Brice | ||
| 17020000014700 | L17/amo20 | 17 | 17020000014670 | 17020000014695 | 5 | M. | Alexandre | Flory | ||
| 17020000014701 | L17/amo20 | 17 | 17020000014670 | 17020000014695 | 6 | Mme | Aline | Durand | ||
| 17020000014702 | L17/amo20 | 17 | 17020000014670 | 17020000014695 | 7 | Mme | Chloé | Noblet | ||
| 17020000014798 | L17/amo20 | 17 | 17020000014715 | 17020000014797 | 1 | Mme | Aurélia | Drif |