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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17030000179401 | L17/amo30 | 17 | 17030000179361 | 17030000179399 | 2 | Mme | Céline | Carcy | ||
| 17030000179402 | L17/amo30 | 17 | 17030000179361 | 17030000179399 | 3 | Mme | Mélissa | Martinez | ||
| 17030000179403 | L17/amo30 | 17 | 17030000179361 | 17030000179399 | 4 | Mme | Nina | Vicente | ||
| 17030000179442 | L17/amo30 | 17 | 17030000179404 | 17030000179441 | 1 | M. | Alex | Frederiksen | ||
| 17030000179443 | L17/amo30 | 17 | 17030000179404 | 17030000179441 | 2 | M. | David | Quentin | ||
| 17030000179444 | L17/amo30 | 17 | 17030000179404 | 17030000179441 | 3 | M. | Léo | Reuter | ||
| 17030000179469 | L17/amo30 | 17 | 17030000179445 | 17030000179468 | 1 | Mme | Crystel | Ruiz | ||
| 17030000179470 | L17/amo30 | 17 | 17030000179445 | 17030000179468 | 2 | M. | Olivier | Stroobants | ||
| 17030000179471 | L17/amo30 | 17 | 17030000179445 | 17030000179468 | 3 | M. | Victor | Lemoine | ||
| 17030000179472 | L17/amo30 | 17 | 17030000179445 | 17030000179468 | 4 | Mme | Margot | Cance | ||
| 17030000179537 | L17/amo30 | 17 | 17030000179473 | 17030000179536 | 1 | Mme | Emilie | Laverdant | ||
| 17030000179538 | L17/amo30 | 17 | 17030000179473 | 17030000179536 | 2 | Mme | Florine | Tremblais | ||
| 17030000179539 | L17/amo30 | 17 | 17030000179473 | 17030000179536 | 3 | M. | Simon | Vaslin-Thillet | ||
| 17030000179540 | L17/amo30 | 17 | 17030000179473 | 17030000179536 | 4 | M. | Tony | Imbert | ||
| 17030000179615 | L17/amo30 | 17 | 17030000179552 | 17030000179614 | 1 | M. | Mathieu | Mickael | ||
| 17030000179616 | L17/amo30 | 17 | 17030000179552 | 17030000179614 | 2 | M. | Raphaël | Hérimian | ||
| 17030000179617 | L17/amo30 | 17 | 17030000179552 | 17030000179614 | 3 | M. | Samuel | Sakpa | ||
| 17030000179618 | L17/amo30 | 17 | 17030000179552 | 17030000179614 | 4 | M. | Enzo | Billon | ||
| 17030000179695 | L17/amo30 | 17 | 17030000179619 | 17030000179694 | 1 | Mme | Alexandra | Beckley | ||
| 17030000179696 | L17/amo30 | 17 | 17030000179619 | 17030000179694 | 2 | Mme | Alexine | Chorda | ||
| 17030000179697 | L17/amo30 | 17 | 17030000179619 | 17030000179694 | 3 | M. | Jules | Terrier | ||
| 17030000179698 | L17/amo30 | 17 | 17030000179619 | 17030000179694 | 4 | Mme | Tiphaine | Chomaz | ||
| 17030000179699 | L17/amo30 | 17 | 17030000179619 | 17030000179694 | 5 | Mme | Rachel | Keke | ||
| 17030000179700 | L17/amo30 | 17 | 17030000179619 | 17030000179694 | 6 | Mme | Chérine | Zaiout | ||
| 17030000179727 | L17/amo30 | 17 | 17030000179701 | 17030000179726 | 1 | M. | Valentin | Gabriac | ||
| 17030000179728 | L17/amo30 | 17 | 17030000179701 | 17030000179726 | 2 | M. | Quentin | Féres | ||
| 17030000179729 | L17/amo30 | 17 | 17030000179701 | 17030000179726 | 3 | M. | Benoît | Auguste | ||
| 17030000179730 | L17/amo30 | 17 | 17030000179701 | 17030000179726 | 4 | M. | Pierre | Costantino | ||
| 17030000179769 | L17/amo30 | 17 | 17030000179731 | 17030000179768 | 1 | M. | Christophe | Coraux | ||
| 17030000179770 | L17/amo30 | 17 | 17030000179731 | 17030000179768 | 2 | M. | Raphaël | Tabusse | ||
| 17030000179771 | L17/amo30 | 17 | 17030000179731 | 17030000179768 | 3 | Mme | Sheherazade | Khandani | ||
| 17030000179819 | L17/amo30 | 17 | 17030000179772 | 17030000179818 | 1 | Mme | Cassandre | Bliot | ||
| 17030000179820 | L17/amo30 | 17 | 17030000179772 | 17030000179818 | 2 | Mme | Typhaine | Grignard | ||
| 17030000179821 | L17/amo30 | 17 | 17030000179772 | 17030000179818 | 3 | Mme | Juliette | Malbois | ||
| 17030000179822 | L17/amo30 | 17 | 17030000179772 | 17030000179818 | 4 | M. | Antonin | Godard | ||
| 17030000179867 | L17/amo30 | 17 | 17030000179823 | 17030000179866 | 1 | M. | Matthieu | Groseil | ||
| 17030000179868 | L17/amo30 | 17 | 17030000179823 | 17030000179866 | 2 | Mme | Mathilde | Hériaud | ||
| 17030000179869 | L17/amo30 | 17 | 17030000179823 | 17030000179866 | 3 | M. | David | Thomas | ||
| 17030000179870 | L17/amo30 | 17 | 17030000179823 | 17030000179866 | 4 | M. | Nathan | Guillemot | ||
| 17030000179915 | L17/amo30 | 17 | 17030000179871 | 17030000179914 | 1 | Mme | Sylvie | Bridier | ||
| 17030000179916 | L17/amo30 | 17 | 17030000179871 | 17030000179914 | 2 | Mme | Juliette | Sachot | ||
| 17030000179917 | L17/amo30 | 17 | 17030000179871 | 17030000179914 | 3 | M. | Alexis | Diard | ||
| 17030000179975 | L17/amo30 | 17 | 17030000179918 | 17030000179974 | 1 | Mme | Roxane | Le Breton | ||
| 17030000179976 | L17/amo30 | 17 | 17030000179918 | 17030000179974 | 2 | M. | Léo | Lespinasse | ||
| 17030000179977 | L17/amo30 | 17 | 17030000179918 | 17030000179974 | 3 | Mme | Léa | Dallet | ||
| 17030000179978 | L17/amo30 | 17 | 17030000179918 | 17030000179974 | 4 | M. | Julien | Lefebvre | ||
| 17030000180038 | L17/amo30 | 17 | 17030000179979 | 17030000180037 | 1 | Mme | Laëtitia | Riffard | ||
| 17030000180039 | L17/amo30 | 17 | 17030000179979 | 17030000180037 | 2 | M. | Benjamin | Gibert | ||
| 17030000180040 | L17/amo30 | 17 | 17030000179979 | 17030000180037 | 3 | Mme | Marie | Valette | ||
| 17030000180041 | L17/amo30 | 17 | 17030000179979 | 17030000180037 | 4 | Mme | Lisa | Moulin--Villard |