amo30.acteur_mandat_collaborateurs_collaborateur
Chemin acteur.mandats.mandat.collaborateurs.collaborateur · présence : L17 18 %
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 18 % · 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 18 % |
| 9 | nom | VARCHAR | acteur.mandats.mandat.collaborateurs.collaborateur.nom · présence : L17 18 % |
| 10 | date_debut | VARCHAR | acteur.mandats.mandat.collaborateurs.collaborateur.dateDebut · présence : L17 18 % |
| 11 | date_fin | VARCHAR | acteur.mandats.mandat.collaborateurs.collaborateur.dateFin · présence : L17 18 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | qualite | prenom | nom | date_debut | date_fin |
|---|---|---|---|---|---|---|---|---|---|---|
| 17030000112304 | L17/amo30 | 17 | 17030000112146 | 17030000112300 | 4 | Mme | Sophia | Audias | ||
| 17030000112801 | L17/amo30 | 17 | 17030000112677 | 17030000112800 | 1 | Mme | Maryll | Vignal | ||
| 17030000112802 | L17/amo30 | 17 | 17030000112677 | 17030000112800 | 2 | M. | Arsène | Gornik | ||
| 17030000112803 | L17/amo30 | 17 | 17030000112677 | 17030000112800 | 3 | M. | Brice | Baessa Cariot | ||
| 17030000112804 | L17/amo30 | 17 | 17030000112677 | 17030000112800 | 4 | M. | Abel | Hermel | ||
| 17030000113049 | L17/amo30 | 17 | 17030000112887 | 17030000113048 | 1 | M. | Patrick | Barrau | ||
| 17030000113050 | L17/amo30 | 17 | 17030000112887 | 17030000113048 | 2 | M. | Yoann | Peres | ||
| 17030000113051 | L17/amo30 | 17 | 17030000112887 | 17030000113048 | 3 | M. | Nicolas | Le Cheviller | ||
| 17030000113364 | L17/amo30 | 17 | 17030000113116 | 17030000113363 | 1 | M. | François-Xavier | Le Rhun | ||
| 17030000113365 | L17/amo30 | 17 | 17030000113116 | 17030000113363 | 2 | Mme | Guénaëlle | Lauden | ||
| 17030000113366 | L17/amo30 | 17 | 17030000113116 | 17030000113363 | 3 | Mme | Martine | Olivier | ||
| 17030000113367 | L17/amo30 | 17 | 17030000113116 | 17030000113363 | 4 | Mme | Charlotte | Nicollet | ||
| 17030000113509 | L17/amo30 | 17 | 17030000113368 | 17030000113508 | 1 | Mme | Laure-Anne | Kerisit | ||
| 17030000113510 | L17/amo30 | 17 | 17030000113368 | 17030000113508 | 2 | Mme | Alexia | Nguyen Quoc | ||
| 17030000113511 | L17/amo30 | 17 | 17030000113368 | 17030000113508 | 3 | M. | Louis | Gendreau | ||
| 17030000113677 | L17/amo30 | 17 | 17030000113550 | 17030000113676 | 1 | Mme | Elise | Gaubert | ||
| 17030000113678 | L17/amo30 | 17 | 17030000113550 | 17030000113676 | 2 | Mme | Lucie | Hémond | ||
| 17030000113679 | L17/amo30 | 17 | 17030000113550 | 17030000113676 | 3 | M. | Rémi | Joussiaume | ||
| 17030000114241 | L17/amo30 | 17 | 17030000114146 | 17030000114240 | 1 | Mme | Nadia | Dupuyau | ||
| 17030000114242 | L17/amo30 | 17 | 17030000114146 | 17030000114240 | 2 | Mme | Rachel | Molère-Attal | ||
| 17030000114243 | L17/amo30 | 17 | 17030000114146 | 17030000114240 | 3 | Mme | Clara | Feufeu-Rozière | ||
| 17030000114502 | L17/amo30 | 17 | 17030000114244 | 17030000114501 | 1 | M. | Thibault | Girou | ||
| 17030000114503 | L17/amo30 | 17 | 17030000114244 | 17030000114501 | 2 | Mme | Cécile | Reix | ||
| 17030000114504 | L17/amo30 | 17 | 17030000114244 | 17030000114501 | 3 | Mme | Myriam | Boukhalfa | ||
| 17030000115402 | L17/amo30 | 17 | 17030000115274 | 17030000115401 | 1 | M. | Frédéric | Sicot | ||
| 17030000115403 | L17/amo30 | 17 | 17030000115274 | 17030000115401 | 2 | M. | Kévin | Dereppe | ||
| 17030000115404 | L17/amo30 | 17 | 17030000115274 | 17030000115401 | 3 | Mme | Heïdi | Loisel | ||
| 17030000115537 | L17/amo30 | 17 | 17030000115429 | 17030000115536 | 1 | Mme | Marie-Claire | Pinardon | ||
| 17030000115538 | L17/amo30 | 17 | 17030000115429 | 17030000115536 | 2 | M. | David | Miodownick | ||
| 17030000115715 | L17/amo30 | 17 | 17030000115584 | 17030000115714 | 1 | Mme | Victoria | Petrolesi | ||
| 17030000115716 | L17/amo30 | 17 | 17030000115584 | 17030000115714 | 2 | M. | Léo | Castoldi-Robert | ||
| 17030000116014 | L17/amo30 | 17 | 17030000115908 | 17030000116013 | 1 | M. | Sacha | Lamsika | ||
| 17030000116015 | L17/amo30 | 17 | 17030000115908 | 17030000116013 | 2 | Mme | Elodie | Poinha | ||
| 17030000116016 | L17/amo30 | 17 | 17030000115908 | 17030000116013 | 3 | Mme | Ouloufa | Dorani | ||
| 17030000116017 | L17/amo30 | 17 | 17030000115908 | 17030000116013 | 4 | Mme | Sabrina | Milan | ||
| 17030000116708 | L17/amo30 | 17 | 17030000116534 | 17030000116707 | 1 | M. | Michaël | Miel-Margeretta | ||
| 17030000116709 | L17/amo30 | 17 | 17030000116534 | 17030000116707 | 2 | Mme | Nathalie | Coron | ||
| 17030000116710 | L17/amo30 | 17 | 17030000116534 | 17030000116707 | 3 | M. | Vincent | Thommelin | ||
| 17030000116851 | L17/amo30 | 17 | 17030000116799 | 17030000116850 | 1 | Mme | Marie-Pierre | Gazo | ||
| 17030000116852 | L17/amo30 | 17 | 17030000116799 | 17030000116850 | 2 | M. | Fabien | Lainé | ||
| 17030000116853 | L17/amo30 | 17 | 17030000116799 | 17030000116850 | 3 | M. | Tom | Gillet Duffrechou | ||
| 17030000116854 | L17/amo30 | 17 | 17030000116799 | 17030000116850 | 4 | M. | Sacha | Lamsika | ||
| 17030000116855 | L17/amo30 | 17 | 17030000116799 | 17030000116850 | 5 | M. | Anthony | Cales | ||
| 17030000117075 | L17/amo30 | 17 | 17030000116951 | 17030000117074 | 1 | M. | Pierre | Pécastaings | ||
| 17030000117076 | L17/amo30 | 17 | 17030000116951 | 17030000117074 | 2 | M. | Mehdi | Rahoui | ||
| 17030000117077 | L17/amo30 | 17 | 17030000116951 | 17030000117074 | 3 | M. | Jean-François | Broqueres | ||
| 17030000117078 | L17/amo30 | 17 | 17030000116951 | 17030000117074 | 4 | M. | Paul-Antoine | Caillaud | ||
| 17030000117079 | L17/amo30 | 17 | 17030000116951 | 17030000117074 | 5 | M. | Romain | Lafitte | ||
| 17030000117181 | L17/amo30 | 17 | 17030000117080 | 17030000117180 | 1 | M. | Philippe | Quéré | ||
| 17030000117182 | L17/amo30 | 17 | 17030000117080 | 17030000117180 | 2 | Mme | Magali | Valiorgue |