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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17020000003726 | L17/amo20 | 17 | 17020000003679 | 17020000003725 | 1 | M. | Théo | Kececioglu | ||
| 17020000003727 | L17/amo20 | 17 | 17020000003679 | 17020000003725 | 2 | M. | Kévin | Jacquet | ||
| 17020000003728 | L17/amo20 | 17 | 17020000003679 | 17020000003725 | 3 | M. | Simon | Hocké-Douard | ||
| 17020000003729 | L17/amo20 | 17 | 17020000003679 | 17020000003725 | 4 | M. | Valentin | Grezet | ||
| 17020000003784 | L17/amo20 | 17 | 17020000003730 | 17020000003783 | 1 | M. | François-Joseph | Fazi | ||
| 17020000003785 | L17/amo20 | 17 | 17020000003730 | 17020000003783 | 2 | Mme | Vanina | Batistini Fenocchi | ||
| 17020000003786 | L17/amo20 | 17 | 17020000003730 | 17020000003783 | 3 | Mme | Juliette | Fricot | ||
| 17020000003950 | L17/amo20 | 17 | 17020000003914 | 17020000003949 | 1 | M. | Stéphane | Herb | ||
| 17020000003951 | L17/amo20 | 17 | 17020000003914 | 17020000003949 | 2 | M. | Gemel | Ben Saïd | ||
| 17020000003952 | L17/amo20 | 17 | 17020000003914 | 17020000003949 | 3 | Mme | Sarah | Richard | ||
| 17020000004014 | L17/amo20 | 17 | 17020000003953 | 17020000004013 | 1 | M. | Colas | Valat | ||
| 17020000004015 | L17/amo20 | 17 | 17020000003953 | 17020000004013 | 2 | M. | Kévin | Havet | ||
| 17020000004016 | L17/amo20 | 17 | 17020000003953 | 17020000004013 | 3 | M. | Thomas | Brault | ||
| 17020000004017 | L17/amo20 | 17 | 17020000003953 | 17020000004013 | 4 | M. | Roméo | Le Floch | ||
| 17020000004018 | L17/amo20 | 17 | 17020000003953 | 17020000004013 | 5 | Mme | Mariam | Soufane | ||
| 17020000004049 | L17/amo20 | 17 | 17020000004019 | 17020000004048 | 1 | Mme | Lucile | Vuillermoz | ||
| 17020000004050 | L17/amo20 | 17 | 17020000004019 | 17020000004048 | 2 | M. | Arthur | Job | ||
| 17020000004051 | L17/amo20 | 17 | 17020000004019 | 17020000004048 | 3 | M. | Medhi | Renard | ||
| 17020000004113 | L17/amo20 | 17 | 17020000004052 | 17020000004112 | 1 | Mme | Anaïs | Roussange-Chaillou | ||
| 17020000004114 | L17/amo20 | 17 | 17020000004052 | 17020000004112 | 2 | Mme | Nelly | Dioudonnat | ||
| 17020000004115 | L17/amo20 | 17 | 17020000004052 | 17020000004112 | 3 | M. | Florent | Bouchez | ||
| 17020000004116 | L17/amo20 | 17 | 17020000004052 | 17020000004112 | 4 | Mme | Catherine | Polge | ||
| 17020000004158 | L17/amo20 | 17 | 17020000004117 | 17020000004157 | 1 | Mme | Carine | Dronet | ||
| 17020000004159 | L17/amo20 | 17 | 17020000004117 | 17020000004157 | 2 | Mme | Karine | Le Gal | ||
| 17020000004160 | L17/amo20 | 17 | 17020000004117 | 17020000004157 | 3 | Mme | Claire | Gérault | ||
| 17020000004161 | L17/amo20 | 17 | 17020000004117 | 17020000004157 | 4 | Mme | Rita | Leonhardmair | ||
| 17020000004162 | L17/amo20 | 17 | 17020000004117 | 17020000004157 | 5 | Mme | Gamze | Atalay | ||
| 17020000004205 | L17/amo20 | 17 | 17020000004163 | 17020000004204 | 1 | Mme | Delphine | Jimenez-Grenier | ||
| 17020000004206 | L17/amo20 | 17 | 17020000004163 | 17020000004204 | 2 | M. | Denis | Bersauter | ||
| 17020000004207 | L17/amo20 | 17 | 17020000004163 | 17020000004204 | 3 | Mme | Mathilde | Blondel | ||
| 17020000004208 | L17/amo20 | 17 | 17020000004163 | 17020000004204 | 4 | Mme | Christel | Camus | ||
| 17020000004209 | L17/amo20 | 17 | 17020000004163 | 17020000004204 | 5 | Mme | Yaëlle | Reynaud | ||
| 17020000004275 | L17/amo20 | 17 | 17020000004221 | 17020000004274 | 1 | M. | Hugo | Gaspar | ||
| 17020000004276 | L17/amo20 | 17 | 17020000004221 | 17020000004274 | 2 | Mme | Esther | Albouy | ||
| 17020000004277 | L17/amo20 | 17 | 17020000004221 | 17020000004274 | 3 | Mme | Domitille | Lécroart | ||
| 17020000004278 | L17/amo20 | 17 | 17020000004221 | 17020000004274 | 4 | M. | Matteo | Vailly | ||
| 17020000004372 | L17/amo20 | 17 | 17020000004279 | 17020000004371 | 1 | Mme | Maëva | Dano | ||
| 17020000004373 | L17/amo20 | 17 | 17020000004279 | 17020000004371 | 2 | M. | Victor | Gallou | ||
| 17020000004374 | L17/amo20 | 17 | 17020000004279 | 17020000004371 | 3 | Mme | Laurine | Orêve | ||
| 17020000004529 | L17/amo20 | 17 | 17020000004464 | 17020000004528 | 1 | M. | Jérôme | Petit | ||
| 17020000004530 | L17/amo20 | 17 | 17020000004464 | 17020000004528 | 2 | Mme | Martine | Planteblat | ||
| 17020000004531 | L17/amo20 | 17 | 17020000004464 | 17020000004528 | 3 | Mme | Charlotte | Watine | ||
| 17020000004532 | L17/amo20 | 17 | 17020000004464 | 17020000004528 | 4 | Mme | Catherine | Bafoil | ||
| 17020000004597 | L17/amo20 | 17 | 17020000004533 | 17020000004596 | 1 | M. | Joé | Mendes Monteiro | ||
| 17020000004598 | L17/amo20 | 17 | 17020000004533 | 17020000004596 | 2 | Mme | Margaux | Belot | ||
| 17020000004599 | L17/amo20 | 17 | 17020000004533 | 17020000004596 | 3 | Mme | Muriel | Tancrez | ||
| 17020000004600 | L17/amo20 | 17 | 17020000004533 | 17020000004596 | 4 | M. | Enzo | Amand | ||
| 17020000004666 | L17/amo20 | 17 | 17020000004601 | 17020000004665 | 1 | Mme | Nathalie | Lozito | ||
| 17020000004667 | L17/amo20 | 17 | 17020000004601 | 17020000004665 | 2 | Mme | Catherine | Rieffel | ||
| 17020000004668 | L17/amo20 | 17 | 17020000004601 | 17020000004665 | 3 | Mme | Sylvie | Gruner |