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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17020000024152 | L17/amo20 | 17 | 17020000024096 | 17020000024149 | 3 | Mme | Agnès | Cluzy | ||
| 17020000024153 | L17/amo20 | 17 | 17020000024096 | 17020000024149 | 4 | M. | Benoît | Pidou | ||
| 17020000024186 | L17/amo20 | 17 | 17020000024154 | 17020000024185 | 1 | Mme | Magalie | Cozette | ||
| 17020000024187 | L17/amo20 | 17 | 17020000024154 | 17020000024185 | 2 | M. | Henryk | Strozyk | ||
| 17020000024188 | L17/amo20 | 17 | 17020000024154 | 17020000024185 | 3 | M. | Thomas | Dambron | ||
| 17020000024189 | L17/amo20 | 17 | 17020000024154 | 17020000024185 | 4 | Mme | Dorothée | Maillioux | ||
| 17020000024190 | L17/amo20 | 17 | 17020000024154 | 17020000024185 | 5 | M. | Thomas | Blondel | ||
| 17020000024258 | L17/amo20 | 17 | 17020000024191 | 17020000024257 | 1 | Mme | Annick | Sézille | ||
| 17020000024259 | L17/amo20 | 17 | 17020000024191 | 17020000024257 | 2 | M. | Yannick | Lozac'h de Cordoue-Hecquard | ||
| 17020000024279 | L17/amo20 | 17 | 17020000024260 | 17020000024278 | 1 | Mme | Clémentine | Verron | ||
| 17020000024280 | L17/amo20 | 17 | 17020000024260 | 17020000024278 | 2 | Mme | Annie | Cote | ||
| 17020000024281 | L17/amo20 | 17 | 17020000024260 | 17020000024278 | 3 | Mme | Amandine | Ferrand | ||
| 17020000024282 | L17/amo20 | 17 | 17020000024260 | 17020000024278 | 4 | M. | Edward | Vandevyvere | ||
| 17020000024314 | L17/amo20 | 17 | 17020000024284 | 17020000024313 | 1 | Mme | Elisabeth | Miffre | ||
| 17020000024315 | L17/amo20 | 17 | 17020000024284 | 17020000024313 | 2 | Mme | Bénédicte | Le Blond de Mancier | ||
| 17020000024316 | L17/amo20 | 17 | 17020000024284 | 17020000024313 | 3 | M. | Paul | Miffre | ||
| 17020000024347 | L17/amo20 | 17 | 17020000024317 | 17020000024346 | 1 | Mme | Laura | Chretien | ||
| 17020000024348 | L17/amo20 | 17 | 17020000024317 | 17020000024346 | 2 | M. | Maxime | Martinaggi | ||
| 17020000024349 | L17/amo20 | 17 | 17020000024317 | 17020000024346 | 3 | M. | Jérôme | Lagoutte | ||
| 17020000024432 | L17/amo20 | 17 | 17020000024350 | 17020000024431 | 1 | M. | Lucas | Leloup | ||
| 17020000024433 | L17/amo20 | 17 | 17020000024350 | 17020000024431 | 2 | M. | Clovis | Daguerre | ||
| 17020000024434 | L17/amo20 | 17 | 17020000024350 | 17020000024431 | 3 | M. | Thomas | Heap | ||
| 17020000024514 | L17/amo20 | 17 | 17020000024435 | 17020000024513 | 1 | M. | Stefano | Wolff | ||
| 17020000024515 | L17/amo20 | 17 | 17020000024435 | 17020000024513 | 2 | M. | Léo | Delahaye | ||
| 17020000024516 | L17/amo20 | 17 | 17020000024435 | 17020000024513 | 3 | Mme | Lisa | Farault | ||
| 17020000024517 | L17/amo20 | 17 | 17020000024435 | 17020000024513 | 4 | Mme | Mariette | Leprince | ||
| 17020000024560 | L17/amo20 | 17 | 17020000024518 | 17020000024559 | 1 | M. | Nicolas | Quenouille | ||
| 17020000024561 | L17/amo20 | 17 | 17020000024518 | 17020000024559 | 2 | Mme | Khadija | Chatouani | ||
| 17020000024562 | L17/amo20 | 17 | 17020000024518 | 17020000024559 | 3 | Mme | Alice | Christiaens | ||
| 17020000024621 | L17/amo20 | 17 | 17020000024563 | 17020000024620 | 1 | Mme | Nadège | Heiligenstein | ||
| 17020000024622 | L17/amo20 | 17 | 17020000024563 | 17020000024620 | 2 | M. | Louis | Reboul | ||
| 17020000024623 | L17/amo20 | 17 | 17020000024563 | 17020000024620 | 3 | Mme | Eva | Stein | ||
| 17020000024685 | L17/amo20 | 17 | 17020000024624 | 17020000024684 | 1 | Mme | Djamila | Salifou Panga | ||
| 17020000024686 | L17/amo20 | 17 | 17020000024624 | 17020000024684 | 2 | Mme | Pauline | Pagès | ||
| 17020000024687 | L17/amo20 | 17 | 17020000024624 | 17020000024684 | 3 | M. | Simon | Tharreau-Le Tourneux de la Perraudière | ||
| 17020000024688 | L17/amo20 | 17 | 17020000024624 | 17020000024684 | 4 | Mme | Emma | Dagorne | ||
| 17020000024756 | L17/amo20 | 17 | 17020000024689 | 17020000024755 | 1 | Mme | Mathilde | Thuet | ||
| 17020000024757 | L17/amo20 | 17 | 17020000024689 | 17020000024755 | 2 | Mme | Albertine | Ferreira | ||
| 17020000024758 | L17/amo20 | 17 | 17020000024689 | 17020000024755 | 3 | M. | Hugo | Caspard | ||
| 17020000024759 | L17/amo20 | 17 | 17020000024689 | 17020000024755 | 4 | Mme | Justine | Zimmermann | ||
| 17020000024828 | L17/amo20 | 17 | 17020000024760 | 17020000024827 | 1 | Mme | Camille | Blenner | ||
| 17020000024829 | L17/amo20 | 17 | 17020000024760 | 17020000024827 | 2 | M. | Luc | Lehner | ||
| 17020000024830 | L17/amo20 | 17 | 17020000024760 | 17020000024827 | 3 | Mme | Berthe | Muller | ||
| 17020000024888 | L17/amo20 | 17 | 17020000024831 | 17020000024887 | 1 | Mme | Emma | Briand-Paléologos | ||
| 17020000024889 | L17/amo20 | 17 | 17020000024831 | 17020000024887 | 2 | Mme | Emmanuelle | Caravera | ||
| 17020000024890 | L17/amo20 | 17 | 17020000024831 | 17020000024887 | 3 | M. | Louis | Labaigt | ||
| 17020000024950 | L17/amo20 | 17 | 17020000024891 | 17020000024949 | 1 | Mme | Wissal | El Jarrari | ||
| 17020000024951 | L17/amo20 | 17 | 17020000024891 | 17020000024949 | 2 | Mme | Aurélie | Lecointre | ||
| 17020000024952 | L17/amo20 | 17 | 17020000024891 | 17020000024949 | 3 | Mme | Marion | Perez | ||
| 17020000025051 | L17/amo20 | 17 | 17020000024953 | 17020000025050 | 1 | M. | Xavier | Baudry |