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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17030000107650 | L17/amo30 | 17 | 17030000107480 | 17030000107646 | 4 | M. | Charles | Crespel | ||
| 17030000107651 | L17/amo30 | 17 | 17030000107480 | 17030000107646 | 5 | M. | Louis | Cadou | ||
| 17030000107799 | L17/amo30 | 17 | 17030000107652 | 17030000107798 | 1 | Mme | Marie | Lebedio | ||
| 17030000107800 | L17/amo30 | 17 | 17030000107652 | 17030000107798 | 2 | Mme | Elise | Mellinger | ||
| 17030000107801 | L17/amo30 | 17 | 17030000107652 | 17030000107798 | 3 | M. | Floris | Legrand | ||
| 17030000107993 | L17/amo30 | 17 | 17030000107871 | 17030000107992 | 1 | M. | Ludwig | Speter-Lejeune | ||
| 17030000107994 | L17/amo30 | 17 | 17030000107871 | 17030000107992 | 2 | Mme | Aurélie | Loeillet | ||
| 17030000107995 | L17/amo30 | 17 | 17030000107871 | 17030000107992 | 3 | M. | Magnuson | Lopes | ||
| 17030000108287 | L17/amo30 | 17 | 17030000108130 | 17030000108286 | 1 | M. | Kerrian | Realland | ||
| 17030000108288 | L17/amo30 | 17 | 17030000108130 | 17030000108286 | 2 | Mme | Laure | Merendon | ||
| 17030000108695 | L17/amo30 | 17 | 17030000108550 | 17030000108694 | 1 | Mme | Eliette | Courilleau | ||
| 17030000108696 | L17/amo30 | 17 | 17030000108550 | 17030000108694 | 2 | M. | Paul | Jobard | ||
| 17030000108697 | L17/amo30 | 17 | 17030000108550 | 17030000108694 | 3 | Mme | Anne-Marie | Cormier-Bouligeon | ||
| 17030000108698 | L17/amo30 | 17 | 17030000108550 | 17030000108694 | 4 | M. | Antoine | Engel | ||
| 17030000108699 | L17/amo30 | 17 | 17030000108550 | 17030000108694 | 5 | Mme | Noémie | Linquette | ||
| 17030000108884 | L17/amo30 | 17 | 17030000108780 | 17030000108883 | 1 | M. | Alain | Clemenceau | ||
| 17030000108885 | L17/amo30 | 17 | 17030000108780 | 17030000108883 | 2 | M. | Pierre-Louis | Rivailler | ||
| 17030000108886 | L17/amo30 | 17 | 17030000108780 | 17030000108883 | 3 | Mme | Léa | Manicacci | ||
| 17030000110054 | L17/amo30 | 17 | 17030000109979 | 17030000110053 | 1 | Mme | Delphine | Foucaud | ||
| 17030000110055 | L17/amo30 | 17 | 17030000109979 | 17030000110053 | 2 | M. | Eddie | Marcos | ||
| 17030000110056 | L17/amo30 | 17 | 17030000109979 | 17030000110053 | 3 | Mme | Anne-Laure | Baldon | ||
| 17030000110215 | L17/amo30 | 17 | 17030000110071 | 17030000110214 | 1 | M. | Guillaume | Luciani | ||
| 17030000110216 | L17/amo30 | 17 | 17030000110071 | 17030000110214 | 2 | M. | Jean-Toussaint | Mattei | ||
| 17030000110217 | L17/amo30 | 17 | 17030000110071 | 17030000110214 | 3 | Mme | Josepha | Geronimi | ||
| 17030000110218 | L17/amo30 | 17 | 17030000110071 | 17030000110214 | 4 | M. | Pierre-Paul | Gori | ||
| 17030000110833 | L17/amo30 | 17 | 17030000110672 | 17030000110832 | 1 | Mme | Caroline | Forest | ||
| 17030000110834 | L17/amo30 | 17 | 17030000110672 | 17030000110832 | 2 | Mme | Mathilde | Tastavy | ||
| 17030000110835 | L17/amo30 | 17 | 17030000110672 | 17030000110832 | 3 | M. | Grégory | Abherve-Gueguen | ||
| 17030000111139 | L17/amo30 | 17 | 17030000110916 | 17030000111138 | 1 | Mme | Sandrine | Ballester | ||
| 17030000111140 | L17/amo30 | 17 | 17030000110916 | 17030000111138 | 2 | M. | Thibaut | Colombier | ||
| 17030000111141 | L17/amo30 | 17 | 17030000110916 | 17030000111138 | 3 | Mme | Chloé | Boireau | ||
| 17030000111342 | L17/amo30 | 17 | 17030000111215 | 17030000111341 | 1 | M. | William | Calvez | ||
| 17030000111343 | L17/amo30 | 17 | 17030000111215 | 17030000111341 | 2 | Mme | Vanessa | Photiou | ||
| 17030000111344 | L17/amo30 | 17 | 17030000111215 | 17030000111341 | 3 | M. | François-Régis | Friant | ||
| 17030000111568 | L17/amo30 | 17 | 17030000111435 | 17030000111567 | 1 | M. | Jérôme | Hébert | ||
| 17030000111569 | L17/amo30 | 17 | 17030000111435 | 17030000111567 | 2 | Mme | Nolwenn | Rault-Barbier | ||
| 17030000111570 | L17/amo30 | 17 | 17030000111435 | 17030000111567 | 3 | Mme | Julie | Binois | ||
| 17030000111571 | L17/amo30 | 17 | 17030000111435 | 17030000111567 | 4 | Mme | Klervi | Le Lez | ||
| 17030000111572 | L17/amo30 | 17 | 17030000111435 | 17030000111567 | 5 | M. | Axel | Talabardon | ||
| 17030000111710 | L17/amo30 | 17 | 17030000111602 | 17030000111709 | 1 | Mme | Aude | Goarnisson | ||
| 17030000111711 | L17/amo30 | 17 | 17030000111602 | 17030000111709 | 2 | Mme | Agathe | Huard | ||
| 17030000111712 | L17/amo30 | 17 | 17030000111602 | 17030000111709 | 3 | M. | Damien | Ladan | ||
| 17030000111713 | L17/amo30 | 17 | 17030000111602 | 17030000111709 | 4 | Mme | Agathe | Rosa | ||
| 17030000111714 | L17/amo30 | 17 | 17030000111602 | 17030000111709 | 5 | M. | Damien | Kitmacher | ||
| 17030000111862 | L17/amo30 | 17 | 17030000111753 | 17030000111861 | 1 | Mme | Emmanuelle | Gavanon | ||
| 17030000111863 | L17/amo30 | 17 | 17030000111753 | 17030000111861 | 2 | M. | Thomas | Combaudon | ||
| 17030000111864 | L17/amo30 | 17 | 17030000111753 | 17030000111861 | 3 | M. | Théo | Privat | ||
| 17030000112301 | L17/amo30 | 17 | 17030000112146 | 17030000112300 | 1 | M. | Antoine | Farin | ||
| 17030000112302 | L17/amo30 | 17 | 17030000112146 | 17030000112300 | 2 | Mme | Esther | Lévine | ||
| 17030000112303 | L17/amo30 | 17 | 17030000112146 | 17030000112300 | 3 | M. | Hugo | Martin |