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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17030000154246 | L17/amo30 | 17 | 17030000154135 | 17030000154242 | 4 | M. | Matthieu | Maillard | ||
| 17030000154309 | L17/amo30 | 17 | 17030000154247 | 17030000154308 | 1 | M. | Dylan | Cauvin-Merrant | ||
| 17030000154310 | L17/amo30 | 17 | 17030000154247 | 17030000154308 | 2 | M. | Rémi | Scholtz | ||
| 17030000154311 | L17/amo30 | 17 | 17030000154247 | 17030000154308 | 3 | M. | Clément | Belliere | ||
| 17030000154402 | L17/amo30 | 17 | 17030000154324 | 17030000154401 | 1 | Mme | Clotilde | Guéry | ||
| 17030000154403 | L17/amo30 | 17 | 17030000154324 | 17030000154401 | 2 | M. | Charles | Rouvier | ||
| 17030000154404 | L17/amo30 | 17 | 17030000154324 | 17030000154401 | 3 | M. | Nicolas | Tavan | ||
| 17030000154405 | L17/amo30 | 17 | 17030000154324 | 17030000154401 | 4 | Mme | Olivia | Gazzano | ||
| 17030000154591 | L17/amo30 | 17 | 17030000154406 | 17030000154590 | 1 | Mme | Clothilde | Baudouin | ||
| 17030000154592 | L17/amo30 | 17 | 17030000154406 | 17030000154590 | 2 | Mme | Perrine | Tavernier | ||
| 17030000154593 | L17/amo30 | 17 | 17030000154406 | 17030000154590 | 3 | M. | Jérémy | Chossat | ||
| 17030000154658 | L17/amo30 | 17 | 17030000154595 | 17030000154657 | 1 | Mme | Manon | Bouchet | ||
| 17030000154659 | L17/amo30 | 17 | 17030000154595 | 17030000154657 | 2 | M. | David | Nascimento | ||
| 17030000154660 | L17/amo30 | 17 | 17030000154595 | 17030000154657 | 3 | Mme | Vanessa | Vottier | ||
| 17030000154796 | L17/amo30 | 17 | 17030000154740 | 17030000154795 | 1 | M. | Christian | Gérard | ||
| 17030000154797 | L17/amo30 | 17 | 17030000154740 | 17030000154795 | 2 | M. | Ange | Olibé | ||
| 17030000154893 | L17/amo30 | 17 | 17030000154798 | 17030000154892 | 1 | M. | Antonin | Bergier | ||
| 17030000154894 | L17/amo30 | 17 | 17030000154798 | 17030000154892 | 2 | M. | Loan | Cannard | ||
| 17030000154895 | L17/amo30 | 17 | 17030000154798 | 17030000154892 | 3 | Mme | Laura | Jovignot | ||
| 17030000154896 | L17/amo30 | 17 | 17030000154798 | 17030000154892 | 4 | Mme | Julie | Pasquet | ||
| 17030000154982 | L17/amo30 | 17 | 17030000154897 | 17030000154981 | 1 | M. | Yaye | Kaba | ||
| 17030000154983 | L17/amo30 | 17 | 17030000154897 | 17030000154981 | 2 | Mme | Dorine | Ramos | ||
| 17030000154984 | L17/amo30 | 17 | 17030000154897 | 17030000154981 | 3 | M. | Maxime | Munier | ||
| 17030000155156 | L17/amo30 | 17 | 17030000155019 | 17030000155155 | 1 | Mme | Alice | Lemarinel | ||
| 17030000155157 | L17/amo30 | 17 | 17030000155019 | 17030000155155 | 2 | M. | Guillaume | Bichet | ||
| 17030000155158 | L17/amo30 | 17 | 17030000155019 | 17030000155155 | 3 | M. | Olivier | Mencarelli | ||
| 17030000155159 | L17/amo30 | 17 | 17030000155019 | 17030000155155 | 4 | M. | Antoine | Toulza | ||
| 17030000155268 | L17/amo30 | 17 | 17030000155160 | 17030000155267 | 1 | M. | Julien | Cadieu | ||
| 17030000155269 | L17/amo30 | 17 | 17030000155160 | 17030000155267 | 2 | M. | Rémy | Salvador | ||
| 17030000155270 | L17/amo30 | 17 | 17030000155160 | 17030000155267 | 3 | Mme | Rania | Hattabi | ||
| 17030000155271 | L17/amo30 | 17 | 17030000155160 | 17030000155267 | 4 | Mme | Julie | Litre | ||
| 17030000155386 | L17/amo30 | 17 | 17030000155272 | 17030000155385 | 1 | Mme | Galia | Mercier | ||
| 17030000155387 | L17/amo30 | 17 | 17030000155272 | 17030000155385 | 2 | Mme | Inès | Djelida | ||
| 17030000155388 | L17/amo30 | 17 | 17030000155272 | 17030000155385 | 3 | M. | Johan | Marchand | ||
| 17030000155389 | L17/amo30 | 17 | 17030000155272 | 17030000155385 | 4 | Mme | Clara | Ould-Aklouche | ||
| 17030000155390 | L17/amo30 | 17 | 17030000155272 | 17030000155385 | 5 | M. | Rhany | Slimane Tich Tich | ||
| 17030000155465 | L17/amo30 | 17 | 17030000155391 | 17030000155464 | 1 | M. | Loïc | Muria | ||
| 17030000155466 | L17/amo30 | 17 | 17030000155391 | 17030000155464 | 2 | M. | Maxime | Neutzner | ||
| 17030000155467 | L17/amo30 | 17 | 17030000155391 | 17030000155464 | 3 | Mme | Alice | Corre | ||
| 17030000155468 | L17/amo30 | 17 | 17030000155391 | 17030000155464 | 4 | Mme | Ariane | Laude | ||
| 17030000155595 | L17/amo30 | 17 | 17030000155469 | 17030000155594 | 1 | M. | Dacruz | Baloa | ||
| 17030000155596 | L17/amo30 | 17 | 17030000155469 | 17030000155594 | 2 | Mme | Ethel | Gandia | ||
| 17030000155597 | L17/amo30 | 17 | 17030000155469 | 17030000155594 | 3 | Mme | Lux | Hervé | ||
| 17030000155785 | L17/amo30 | 17 | 17030000155668 | 17030000155784 | 1 | M. | Clément | Chicoyneau de Lavalette | ||
| 17030000155786 | L17/amo30 | 17 | 17030000155668 | 17030000155784 | 2 | Mme | Valérie | Lacabanne | ||
| 17030000155787 | L17/amo30 | 17 | 17030000155668 | 17030000155784 | 3 | M. | Franck | Barthet | ||
| 17030000155893 | L17/amo30 | 17 | 17030000155788 | 17030000155892 | 1 | M. | Sacha | Duprat | ||
| 17030000155894 | L17/amo30 | 17 | 17030000155788 | 17030000155892 | 2 | M. | Simon | Eppling | ||
| 17030000155895 | L17/amo30 | 17 | 17030000155788 | 17030000155892 | 3 | Mme | Sandrine | Le Traon | ||
| 17030000155896 | L17/amo30 | 17 | 17030000155788 | 17030000155892 | 4 | M. | Solal-Ewan | Allain |