amo40.acteur_mandat_collaborateurs_collaborateur
Chemin acteur.mandats.mandat.collaborateurs.collaborateur · présence : L17 100 %
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 100 % · 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 100 % |
| 9 | nom | VARCHAR | acteur.mandats.mandat.collaborateurs.collaborateur.nom · présence : L17 100 % |
| 10 | date_debut | VARCHAR | acteur.mandats.mandat.collaborateurs.collaborateur.dateDebut · présence : L17 100 % |
| 11 | date_fin | VARCHAR | acteur.mandats.mandat.collaborateurs.collaborateur.dateFin · présence : L17 100 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | qualite | prenom | nom | date_debut | date_fin |
|---|---|---|---|---|---|---|---|---|---|---|
| 17040000008211 | L17/amo40 | 17 | 17040000008176 | 17040000008210 | 1 | Mme | Violaine | Cabidoche | ||
| 17040000008212 | L17/amo40 | 17 | 17040000008176 | 17040000008210 | 2 | Mme | Julie | Malozon | ||
| 17040000008213 | L17/amo40 | 17 | 17040000008176 | 17040000008210 | 3 | M. | Xavier | Sy | ||
| 17040000008250 | L17/amo40 | 17 | 17040000008222 | 17040000008249 | 1 | M. | Laurent | Dassonville | ||
| 17040000008251 | L17/amo40 | 17 | 17040000008222 | 17040000008249 | 2 | M. | Laurent | Brice | ||
| 17040000008252 | L17/amo40 | 17 | 17040000008222 | 17040000008249 | 3 | M. | Louis | Mompeu | ||
| 17040000008253 | L17/amo40 | 17 | 17040000008222 | 17040000008249 | 4 | M. | Jérôme | Cochet | ||
| 17040000008293 | L17/amo40 | 17 | 17040000008255 | 17040000008292 | 1 | Mme | Lorédane | Cléret | ||
| 17040000008294 | L17/amo40 | 17 | 17040000008255 | 17040000008292 | 2 | Mme | Evre | Isikli | ||
| 17040000008295 | L17/amo40 | 17 | 17040000008255 | 17040000008292 | 3 | M. | Jacky | Sousa | ||
| 17040000008296 | L17/amo40 | 17 | 17040000008255 | 17040000008292 | 4 | Mme | Diadji | Sacko | ||
| 17040000008383 | L17/amo40 | 17 | 17040000008320 | 17040000008382 | 1 | Mme | Lucie | Kirchner | ||
| 17040000008384 | L17/amo40 | 17 | 17040000008320 | 17040000008382 | 2 | M. | David | Gallo | ||
| 17040000008385 | L17/amo40 | 17 | 17040000008320 | 17040000008382 | 3 | M. | Maximilien | Mesnard | ||
| 17040000008386 | L17/amo40 | 17 | 17040000008320 | 17040000008382 | 4 | M. | Alban | Mathon | ||
| 17040000008387 | L17/amo40 | 17 | 17040000008320 | 17040000008382 | 5 | M. | Tiziano | Zumkeller | ||
| 17040000008463 | L17/amo40 | 17 | 17040000008427 | 17040000008462 | 1 | M. | Helmi | M'Rabet | ||
| 17040000008464 | L17/amo40 | 17 | 17040000008427 | 17040000008462 | 2 | Mme | Elise | Trouvé-Buisson | ||
| 17040000008465 | L17/amo40 | 17 | 17040000008427 | 17040000008462 | 3 | M. | Clément | Morel | ||
| 17040000008466 | L17/amo40 | 17 | 17040000008427 | 17040000008462 | 4 | M. | Maxime | Dacalor | ||
| 17040000008467 | L17/amo40 | 17 | 17040000008427 | 17040000008462 | 5 | Mme | Lara | Bigorre | ||
| 17040000008468 | L17/amo40 | 17 | 17040000008427 | 17040000008462 | 6 | Mme | Lisa | Grailhe | ||
| 17040000008504 | L17/amo40 | 17 | 17040000008478 | 17040000008503 | 1 | M. | Gabriel | Deleglise | ||
| 17040000008505 | L17/amo40 | 17 | 17040000008478 | 17040000008503 | 2 | M. | Salwann | Kamouk | ||
| 17040000008506 | L17/amo40 | 17 | 17040000008478 | 17040000008503 | 3 | Mme | Aurore | Andrieu | ||
| 17040000008507 | L17/amo40 | 17 | 17040000008478 | 17040000008503 | 4 | M. | Niels | Pascal | ||
| 17040000008508 | L17/amo40 | 17 | 17040000008478 | 17040000008503 | 5 | M. | Abel | Hermel | ||
| 17040000008629 | L17/amo40 | 17 | 17040000008584 | 17040000008628 | 1 | M. | Pierre | Soulez | ||
| 17040000008630 | L17/amo40 | 17 | 17040000008584 | 17040000008628 | 2 | Mme | Sandrine | Serva | ||
| 17040000008631 | L17/amo40 | 17 | 17040000008584 | 17040000008628 | 3 | Mme | Lovely | Bergena | ||
| 17040000008632 | L17/amo40 | 17 | 17040000008584 | 17040000008628 | 4 | M. | Edwin | Phaeton | ||
| 17040000008675 | L17/amo40 | 17 | 17040000008641 | 17040000008674 | 1 | Mme | Laurence | de Saint Sernin | ||
| 17040000008676 | L17/amo40 | 17 | 17040000008641 | 17040000008674 | 2 | M. | Danick | Lator | ||
| 17040000008677 | L17/amo40 | 17 | 17040000008641 | 17040000008674 | 3 | M. | Fred | Sapotille | ||
| 17040000008678 | L17/amo40 | 17 | 17040000008641 | 17040000008674 | 4 | M. | Ruddy | Naime | ||
| 17040000008693 | L17/amo40 | 17 | 17040000008685 | 17040000008692 | 1 | Mme | Elyssa | Laurent | ||
| 17040000008694 | L17/amo40 | 17 | 17040000008685 | 17040000008692 | 2 | Mme | Célia | Louis-Marie | ||
| 17040000008695 | L17/amo40 | 17 | 17040000008685 | 17040000008692 | 3 | Mme | Annie-Laure | Hilarus | ||
| 17040000008696 | L17/amo40 | 17 | 17040000008685 | 17040000008692 | 4 | M. | Olivier | Lette | ||
| 17040000008697 | L17/amo40 | 17 | 17040000008685 | 17040000008692 | 5 | M. | Harry | Hersilie-Héloïse | ||
| 17040000008789 | L17/amo40 | 17 | 17040000008752 | 17040000008788 | 1 | M. | Roman | Kwiatkowski | ||
| 17040000008790 | L17/amo40 | 17 | 17040000008752 | 17040000008788 | 2 | M. | Joseph | Mecarsel | ||
| 17040000008791 | L17/amo40 | 17 | 17040000008752 | 17040000008788 | 3 | Mme | Sylvie | Autissier | ||
| 17040000008792 | L17/amo40 | 17 | 17040000008752 | 17040000008788 | 4 | Mme | Sofia | Khelloqi | ||
| 17040000008793 | L17/amo40 | 17 | 17040000008752 | 17040000008788 | 5 | Mme | Vera | Webert Makhlouf | ||
| 17040000008918 | L17/amo40 | 17 | 17040000008882 | 17040000008917 | 1 | M. | Vincent | Berthiot | ||
| 17040000008919 | L17/amo40 | 17 | 17040000008882 | 17040000008917 | 2 | Mme | Maylis | Lepinette | ||
| 17040000008920 | L17/amo40 | 17 | 17040000008882 | 17040000008917 | 3 | M. | Melvyn | Menard | ||
| 17040000009010 | L17/amo40 | 17 | 17040000008974 | 17040000009009 | 1 | M. | Eric | Parlier | ||
| 17040000009011 | L17/amo40 | 17 | 17040000008974 | 17040000009009 | 2 | Mme | Vanessa | Balbine |