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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17030000000167 | L17/amo30 | 17 | 17030000000092 | 17030000000166 | 1 | Mme | Sylvie | Couderc | ||
| 17030000000168 | L17/amo30 | 17 | 17030000000092 | 17030000000166 | 2 | M. | Samuel | Ducasse-Reiss | ||
| 17030000008770 | L17/amo30 | 17 | 17030000008652 | 17030000008769 | 1 | M. | Sylvain | Matus | ||
| 17030000008771 | L17/amo30 | 17 | 17030000008652 | 17030000008769 | 2 | M. | Samuel | Chomat | ||
| 17030000008772 | L17/amo30 | 17 | 17030000008652 | 17030000008769 | 3 | Mme | Apolline | Barrau | ||
| 17030000008773 | L17/amo30 | 17 | 17030000008652 | 17030000008769 | 4 | M. | Antonin | Clavreul | ||
| 17030000008774 | L17/amo30 | 17 | 17030000008652 | 17030000008769 | 5 | M. | Simao | Ntoni | ||
| 17030000009560 | L17/amo30 | 17 | 17030000009366 | 17030000009559 | 1 | Mme | Amandine | Painset | ||
| 17030000009561 | L17/amo30 | 17 | 17030000009366 | 17030000009559 | 2 | M. | David | Duizidou | ||
| 17030000009562 | L17/amo30 | 17 | 17030000009366 | 17030000009559 | 3 | M. | Lindsey | Deary | ||
| 17030000010310 | L17/amo30 | 17 | 17030000009864 | 17030000010309 | 1 | M. | Romain | Maria | ||
| 17030000010311 | L17/amo30 | 17 | 17030000009864 | 17030000010309 | 2 | Mme | Delphine | Raimond | ||
| 17030000010312 | L17/amo30 | 17 | 17030000009864 | 17030000010309 | 3 | M. | Edgar | Mathet-Raffaelli | ||
| 17030000010313 | L17/amo30 | 17 | 17030000009864 | 17030000010309 | 4 | M. | Paul | Morelli | ||
| 17030000010431 | L17/amo30 | 17 | 17030000010404 | 17030000010430 | 1 | M. | Thomas | Jacquelin | ||
| 17030000010432 | L17/amo30 | 17 | 17030000010404 | 17030000010430 | 2 | M. | Bernard | Combes | ||
| 17030000010433 | L17/amo30 | 17 | 17030000010404 | 17030000010430 | 3 | Mme | Carole | Nangéroni | ||
| 17030000010434 | L17/amo30 | 17 | 17030000010404 | 17030000010430 | 4 | M. | Baptiste | Labbat | ||
| 17030000010435 | L17/amo30 | 17 | 17030000010404 | 17030000010430 | 5 | Mme | Aurélie | Monteil | ||
| 17030000024332 | L17/amo30 | 17 | 17030000024261 | 17030000024331 | 1 | Mme | Sara | Jouanneau | ||
| 17030000024333 | L17/amo30 | 17 | 17030000024261 | 17030000024331 | 2 | M. | Marc | Stievenard | ||
| 17030000024334 | L17/amo30 | 17 | 17030000024261 | 17030000024331 | 3 | M. | Maxime | Parent | ||
| 17030000024335 | L17/amo30 | 17 | 17030000024261 | 17030000024331 | 4 | M. | Jérôme | Meunier | ||
| 17030000032183 | L17/amo30 | 17 | 17030000032086 | 17030000032182 | 1 | Mme | Valérie | Cabecas | ||
| 17030000032184 | L17/amo30 | 17 | 17030000032086 | 17030000032182 | 2 | Mme | Juliette | Devedeux | ||
| 17030000032673 | L17/amo30 | 17 | 17030000032224 | 17030000032672 | 1 | Mme | Céline | Lemoussu | ||
| 17030000032674 | L17/amo30 | 17 | 17030000032224 | 17030000032672 | 2 | M. | Guillaume | Denis-David | ||
| 17030000032675 | L17/amo30 | 17 | 17030000032224 | 17030000032672 | 3 | M. | Xavier | Jaglin | ||
| 17030000032869 | L17/amo30 | 17 | 17030000032676 | 17030000032868 | 1 | Mme | Sandrine | Poignet | ||
| 17030000032870 | L17/amo30 | 17 | 17030000032676 | 17030000032868 | 2 | Mme | Cécile | Petralia | ||
| 17030000032871 | L17/amo30 | 17 | 17030000032676 | 17030000032868 | 3 | Mme | Séverine | Vibert | ||
| 17030000032872 | L17/amo30 | 17 | 17030000032676 | 17030000032868 | 4 | M. | Adrien | Naves-Lauby | ||
| 17030000032873 | L17/amo30 | 17 | 17030000032676 | 17030000032868 | 5 | M. | Adrien | Parent | ||
| 17030000033631 | L17/amo30 | 17 | 17030000033443 | 17030000033630 | 1 | Mme | Emmanuelle | Boutang | ||
| 17030000033632 | L17/amo30 | 17 | 17030000033443 | 17030000033630 | 2 | Mme | Marjory | Lempereur | ||
| 17030000035812 | L17/amo30 | 17 | 17030000035574 | 17030000035811 | 1 | Mme | Véronique | Van Tichelen | ||
| 17030000035813 | L17/amo30 | 17 | 17030000035574 | 17030000035811 | 2 | M. | Clément | Delplanque | ||
| 17030000035814 | L17/amo30 | 17 | 17030000035574 | 17030000035811 | 3 | M. | Jimi | Erotico | ||
| 17030000035815 | L17/amo30 | 17 | 17030000035574 | 17030000035811 | 4 | Mme | Lola | Verger | ||
| 17030000037634 | L17/amo30 | 17 | 17030000037582 | 17030000037633 | 1 | Mme | Charlotte | Vaillot | ||
| 17030000037635 | L17/amo30 | 17 | 17030000037582 | 17030000037633 | 2 | Mme | Patricia | Goudard | ||
| 17030000037636 | L17/amo30 | 17 | 17030000037582 | 17030000037633 | 3 | Mme | Myriam | Vocanson | ||
| 17030000037637 | L17/amo30 | 17 | 17030000037582 | 17030000037633 | 4 | Mme | Mathilde | Bourgin | ||
| 17030000037638 | L17/amo30 | 17 | 17030000037582 | 17030000037633 | 5 | Mme | Maud | Berthomieu | ||
| 17030000038646 | L17/amo30 | 17 | 17030000038555 | 17030000038645 | 1 | M. | Antoine | Reydellet | ||
| 17030000038647 | L17/amo30 | 17 | 17030000038555 | 17030000038645 | 2 | M. | Corentin | Jouathel | ||
| 17030000038648 | L17/amo30 | 17 | 17030000038555 | 17030000038645 | 3 | Mme | Anne | De Danne | ||
| 17030000038649 | L17/amo30 | 17 | 17030000038555 | 17030000038645 | 4 | M. | Willy | Pauvert | ||
| 17030000046646 | L17/amo30 | 17 | 17030000046622 | 17030000046645 | 1 | M. | Jérôme | Darques | ||
| 17030000046647 | L17/amo30 | 17 | 17030000046622 | 17030000046645 | 2 | Mme | Panna | Patik |