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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17020000029821 | L17/amo20 | 17 | 17020000029712 | 17020000029818 | 3 | M. | Fabio | Rodrigues Martins | ||
| 17020000029861 | L17/amo20 | 17 | 17020000029822 | 17020000029860 | 1 | M. | Luca | Bachi | ||
| 17020000029862 | L17/amo20 | 17 | 17020000029822 | 17020000029860 | 2 | Mme | Vanessa | Jimenez | ||
| 17020000029863 | L17/amo20 | 17 | 17020000029822 | 17020000029860 | 3 | M. | Néil | Duggan | ||
| 17020000029884 | L17/amo20 | 17 | 17020000029864 | 17020000029883 | 1 | M. | Stanislas | Paute | ||
| 17020000029885 | L17/amo20 | 17 | 17020000029864 | 17020000029883 | 2 | Mme | Blandine | de Vitton de Peyruis | ||
| 17020000029969 | L17/amo20 | 17 | 17020000029886 | 17020000029968 | 1 | Mme | Audrey | Haranger | ||
| 17020000029970 | L17/amo20 | 17 | 17020000029886 | 17020000029968 | 2 | M. | Baptiste | Walter | ||
| 17020000029971 | L17/amo20 | 17 | 17020000029886 | 17020000029968 | 3 | Mme | Jade | Beaurain | ||
| 17020000030100 | L17/amo20 | 17 | 17020000030056 | 17020000030099 | 1 | Mme | Christine | Lacoste | ||
| 17020000030101 | L17/amo20 | 17 | 17020000030056 | 17020000030099 | 2 | M. | Lucas | Estagnasié | ||
| 17020000030102 | L17/amo20 | 17 | 17020000030056 | 17020000030099 | 3 | Mme | Héloïse | Nocera | ||
| 17020000030186 | L17/amo20 | 17 | 17020000030121 | 17020000030185 | 1 | M. | Pacifique | Robineau | ||
| 17020000030187 | L17/amo20 | 17 | 17020000030121 | 17020000030185 | 2 | Mme | Claire | Lejeune | ||
| 17020000030188 | L17/amo20 | 17 | 17020000030121 | 17020000030185 | 3 | Mme | Eve | Jobard | ||
| 17020000030258 | L17/amo20 | 17 | 17020000030189 | 17020000030257 | 1 | M. | Gauthier | Willem | ||
| 17020000030259 | L17/amo20 | 17 | 17020000030189 | 17020000030257 | 2 | Mme | Nathalie | Werquin | ||
| 17020000030260 | L17/amo20 | 17 | 17020000030189 | 17020000030257 | 3 | M. | Christophe | Versini | ||
| 17020000030294 | L17/amo20 | 17 | 17020000030261 | 17020000030293 | 1 | Mme | Marie | Marteau | ||
| 17020000030295 | L17/amo20 | 17 | 17020000030261 | 17020000030293 | 2 | M. | Victor | Chomard | ||
| 17020000030350 | L17/amo20 | 17 | 17020000030296 | 17020000030349 | 1 | Mme | Annabelle | Huet | ||
| 17020000030351 | L17/amo20 | 17 | 17020000030296 | 17020000030349 | 2 | M. | Arthur | Courant | ||
| 17020000030352 | L17/amo20 | 17 | 17020000030296 | 17020000030349 | 3 | M. | Elie | Colsenet | ||
| 17020000030353 | L17/amo20 | 17 | 17020000030296 | 17020000030349 | 4 | M. | Alban | Mathon | ||
| 17020000030354 | L17/amo20 | 17 | 17020000030296 | 17020000030349 | 5 | M. | Alexandre | Charbonnel-Cardoso | ||
| 17020000030494 | L17/amo20 | 17 | 17020000030393 | 17020000030493 | 1 | Mme | Aurélie | Hoareau | ||
| 17020000030495 | L17/amo20 | 17 | 17020000030393 | 17020000030493 | 2 | M. | Fabrice | Grondin | ||
| 17020000030496 | L17/amo20 | 17 | 17020000030393 | 17020000030493 | 3 | M. | Olivier | Richauvet | ||
| 17020000030497 | L17/amo20 | 17 | 17020000030393 | 17020000030493 | 4 | M. | Lucas | Pothin | ||
| 17020000030498 | L17/amo20 | 17 | 17020000030393 | 17020000030493 | 5 | Mme | Aude | Payet | ||
| 17020000030550 | L17/amo20 | 17 | 17020000030499 | 17020000030549 | 1 | M. | Frédéric | Rousseau | ||
| 17020000030551 | L17/amo20 | 17 | 17020000030499 | 17020000030549 | 2 | Mme | Marie Dominique | Thionville | ||
| 17020000030552 | L17/amo20 | 17 | 17020000030499 | 17020000030549 | 3 | Mme | Isabelle | Cerveaux | ||
| 17020000030553 | L17/amo20 | 17 | 17020000030499 | 17020000030549 | 4 | Mme | Juliana | Hibon | ||
| 17020000030625 | L17/amo20 | 17 | 17020000030554 | 17020000030624 | 1 | Mme | Elyse | Lethuillier | ||
| 17020000030626 | L17/amo20 | 17 | 17020000030554 | 17020000030624 | 2 | Mme | Elena | Hourdin--Solovieff | ||
| 17020000030627 | L17/amo20 | 17 | 17020000030554 | 17020000030624 | 3 | Mme | Mathilde | Bockoltz | ||
| 17020000030648 | L17/amo20 | 17 | 17020000030628 | 17020000030647 | 1 | M. | Jules | Sornay | ||
| 17020000030649 | L17/amo20 | 17 | 17020000030628 | 17020000030647 | 2 | M. | Pierre | Boué | ||
| 17020000030681 | L17/amo20 | 17 | 17020000030650 | 17020000030680 | 1 | Mme | Melody | De Witte | ||
| 17020000030682 | L17/amo20 | 17 | 17020000030650 | 17020000030680 | 2 | M. | Thomas | Molina | ||
| 17020000030715 | L17/amo20 | 17 | 17020000030683 | 17020000030714 | 1 | M. | Gilles | Baldacchino | ||
| 17020000030716 | L17/amo20 | 17 | 17020000030683 | 17020000030714 | 2 | M. | Paul | Laurent | ||
| 17020000030717 | L17/amo20 | 17 | 17020000030683 | 17020000030714 | 3 | M. | Thierry | Casanova | ||
| 17020000030758 | L17/amo20 | 17 | 17020000030718 | 17020000030757 | 1 | M. | Antoine | Barthélemy | ||
| 17020000030759 | L17/amo20 | 17 | 17020000030718 | 17020000030757 | 2 | M. | Fabien | Semat | ||
| 17020000030760 | L17/amo20 | 17 | 17020000030718 | 17020000030757 | 3 | Mme | Alexandra | Mereu | ||
| 17020000030761 | L17/amo20 | 17 | 17020000030718 | 17020000030757 | 4 | M. | François | Cantepe | ||
| 17020000030762 | L17/amo20 | 17 | 17020000030718 | 17020000030757 | 5 | M. | Louis | Bérerd | ||
| 17020000030852 | L17/amo20 | 17 | 17020000030763 | 17020000030851 | 1 | Mme | Sophie | Perchellet |