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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17020000000040 | L17/amo20 | 17 | 17020000000016 | 17020000000039 | 1 | Mme | Sylvie | Couderc | ||
| 17020000000041 | L17/amo20 | 17 | 17020000000016 | 17020000000039 | 2 | M. | Samuel | Ducasse-Reiss | ||
| 17020000000255 | L17/amo20 | 17 | 17020000000200 | 17020000000254 | 1 | M. | Sylvain | Matus | ||
| 17020000000256 | L17/amo20 | 17 | 17020000000200 | 17020000000254 | 2 | M. | Samuel | Chomat | ||
| 17020000000257 | L17/amo20 | 17 | 17020000000200 | 17020000000254 | 3 | Mme | Apolline | Barrau | ||
| 17020000000258 | L17/amo20 | 17 | 17020000000200 | 17020000000254 | 4 | M. | Antonin | Clavreul | ||
| 17020000000259 | L17/amo20 | 17 | 17020000000200 | 17020000000254 | 5 | M. | Simao | Ntoni | ||
| 17020000000294 | L17/amo20 | 17 | 17020000000260 | 17020000000293 | 1 | Mme | Amandine | Painset | ||
| 17020000000295 | L17/amo20 | 17 | 17020000000260 | 17020000000293 | 2 | M. | David | Duizidou | ||
| 17020000000296 | L17/amo20 | 17 | 17020000000260 | 17020000000293 | 3 | M. | Lindsey | Deary | ||
| 17020000000375 | L17/amo20 | 17 | 17020000000297 | 17020000000374 | 1 | M. | Romain | Maria | ||
| 17020000000376 | L17/amo20 | 17 | 17020000000297 | 17020000000374 | 2 | Mme | Delphine | Raimond | ||
| 17020000000377 | L17/amo20 | 17 | 17020000000297 | 17020000000374 | 3 | M. | Edgar | Mathet-Raffaelli | ||
| 17020000000378 | L17/amo20 | 17 | 17020000000297 | 17020000000374 | 4 | M. | Paul | Morelli | ||
| 17020000000394 | L17/amo20 | 17 | 17020000000379 | 17020000000393 | 1 | M. | Thomas | Jacquelin | ||
| 17020000000395 | L17/amo20 | 17 | 17020000000379 | 17020000000393 | 2 | M. | Bernard | Combes | ||
| 17020000000396 | L17/amo20 | 17 | 17020000000379 | 17020000000393 | 3 | Mme | Carole | Nangéroni | ||
| 17020000000397 | L17/amo20 | 17 | 17020000000379 | 17020000000393 | 4 | M. | Baptiste | Labbat | ||
| 17020000000398 | L17/amo20 | 17 | 17020000000379 | 17020000000393 | 5 | Mme | Aurélie | Monteil | ||
| 17020000000510 | L17/amo20 | 17 | 17020000000473 | 17020000000509 | 1 | Mme | Sara | Jouanneau | ||
| 17020000000511 | L17/amo20 | 17 | 17020000000473 | 17020000000509 | 2 | M. | Marc | Stievenard | ||
| 17020000000512 | L17/amo20 | 17 | 17020000000473 | 17020000000509 | 3 | M. | Maxime | Parent | ||
| 17020000000513 | L17/amo20 | 17 | 17020000000473 | 17020000000509 | 4 | M. | Jérôme | Meunier | ||
| 17020000000587 | L17/amo20 | 17 | 17020000000559 | 17020000000586 | 1 | Mme | Valérie | Cabecas | ||
| 17020000000588 | L17/amo20 | 17 | 17020000000559 | 17020000000586 | 2 | Mme | Juliette | Devedeux | ||
| 17020000000706 | L17/amo20 | 17 | 17020000000602 | 17020000000705 | 1 | Mme | Céline | Lemoussu | ||
| 17020000000707 | L17/amo20 | 17 | 17020000000602 | 17020000000705 | 2 | M. | Guillaume | Denis-David | ||
| 17020000000708 | L17/amo20 | 17 | 17020000000602 | 17020000000705 | 3 | M. | Xavier | Jaglin | ||
| 17020000000788 | L17/amo20 | 17 | 17020000000709 | 17020000000787 | 1 | Mme | Sandrine | Poignet | ||
| 17020000000789 | L17/amo20 | 17 | 17020000000709 | 17020000000787 | 2 | Mme | Cécile | Petralia | ||
| 17020000000790 | L17/amo20 | 17 | 17020000000709 | 17020000000787 | 3 | Mme | Séverine | Vibert | ||
| 17020000000791 | L17/amo20 | 17 | 17020000000709 | 17020000000787 | 4 | M. | Adrien | Naves-Lauby | ||
| 17020000000792 | L17/amo20 | 17 | 17020000000709 | 17020000000787 | 5 | M. | Adrien | Parent | ||
| 17020000000824 | L17/amo20 | 17 | 17020000000793 | 17020000000823 | 1 | Mme | Emmanuelle | Boutang | ||
| 17020000000825 | L17/amo20 | 17 | 17020000000793 | 17020000000823 | 2 | Mme | Marjory | Lempereur | ||
| 17020000000948 | L17/amo20 | 17 | 17020000000878 | 17020000000947 | 1 | Mme | Véronique | Van Tichelen | ||
| 17020000000949 | L17/amo20 | 17 | 17020000000878 | 17020000000947 | 2 | M. | Clément | Delplanque | ||
| 17020000000950 | L17/amo20 | 17 | 17020000000878 | 17020000000947 | 3 | M. | Jimi | Erotico | ||
| 17020000000951 | L17/amo20 | 17 | 17020000000878 | 17020000000947 | 4 | Mme | Lola | Verger | ||
| 17020000000993 | L17/amo20 | 17 | 17020000000968 | 17020000000992 | 1 | Mme | Charlotte | Vaillot | ||
| 17020000000994 | L17/amo20 | 17 | 17020000000968 | 17020000000992 | 2 | Mme | Patricia | Goudard | ||
| 17020000000995 | L17/amo20 | 17 | 17020000000968 | 17020000000992 | 3 | Mme | Myriam | Vocanson | ||
| 17020000000996 | L17/amo20 | 17 | 17020000000968 | 17020000000992 | 4 | Mme | Mathilde | Bourgin | ||
| 17020000000997 | L17/amo20 | 17 | 17020000000968 | 17020000000992 | 5 | Mme | Maud | Berthomieu | ||
| 17020000001111 | L17/amo20 | 17 | 17020000001078 | 17020000001110 | 1 | M. | Antoine | Reydellet | ||
| 17020000001112 | L17/amo20 | 17 | 17020000001078 | 17020000001110 | 2 | M. | Corentin | Jouathel | ||
| 17020000001113 | L17/amo20 | 17 | 17020000001078 | 17020000001110 | 3 | Mme | Anne | De Danne | ||
| 17020000001114 | L17/amo20 | 17 | 17020000001078 | 17020000001110 | 4 | M. | Willy | Pauvert | ||
| 17020000001265 | L17/amo20 | 17 | 17020000001241 | 17020000001264 | 1 | M. | Jérôme | Darques | ||
| 17020000001266 | L17/amo20 | 17 | 17020000001241 | 17020000001264 | 2 | Mme | Panna | Patik |