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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 15020000035752 | L15/amo20 | 15 | 15020000035711 | 15020000035750 | 2 | Mme | Camille | Klein-Parra | ||
| 15020000035822 | L15/amo20 | 15 | 15020000035753 | 15020000035821 | 1 | M. | Laurent | Blanquer | ||
| 15020000035823 | L15/amo20 | 15 | 15020000035753 | 15020000035821 | 2 | Mme | Alix | Arnaud | ||
| 15020000035876 | L15/amo20 | 15 | 15020000035824 | 15020000035875 | 1 | Mme | Jacinthe | Dhelft | ||
| 15020000035877 | L15/amo20 | 15 | 15020000035824 | 15020000035875 | 2 | M. | François | Roux | ||
| 15020000035878 | L15/amo20 | 15 | 15020000035824 | 15020000035875 | 3 | Mme | Fantine | Garnier-Collot | ||
| 15020000035879 | L15/amo20 | 15 | 15020000035824 | 15020000035875 | 4 | M. | Damien | Gardey | ||
| 15020000035910 | L15/amo20 | 15 | 15020000035880 | 15020000035909 | 1 | M. | Laurent | Rosello | ||
| 15020000035911 | L15/amo20 | 15 | 15020000035880 | 15020000035909 | 2 | Mme | Isabelle | De Noell-Marchesan | ||
| 15020000035912 | L15/amo20 | 15 | 15020000035880 | 15020000035909 | 3 | Mme | Monique | Juanola | ||
| 15020000035913 | L15/amo20 | 15 | 15020000035880 | 15020000035909 | 4 | M. | Stéphane | Vaills | ||
| 15020000035954 | L15/amo20 | 15 | 15020000035934 | 15020000035953 | 1 | M. | Jean-François | Lopez | ||
| 15020000035955 | L15/amo20 | 15 | 15020000035934 | 15020000035953 | 2 | Mme | Rania | Elias-Milad | ||
| 15020000035956 | L15/amo20 | 15 | 15020000035934 | 15020000035953 | 3 | M. | Louis | Mompeu | ||
| 15020000035957 | L15/amo20 | 15 | 15020000035934 | 15020000035953 | 4 | Mme | Séverine | Potel | ||
| 15020000036018 | L15/amo20 | 15 | 15020000035958 | 15020000036017 | 1 | Mme | Aurore | Bouniol de Gineste | ||
| 15020000036019 | L15/amo20 | 15 | 15020000035958 | 15020000036017 | 2 | Mme | Camille | Aspar | ||
| 15020000036020 | L15/amo20 | 15 | 15020000035958 | 15020000036017 | 3 | Mme | Charlotte | Lextrat | ||
| 15020000036058 | L15/amo20 | 15 | 15020000036021 | 15020000036057 | 1 | Mme | Magali | Nolibois | ||
| 15020000036079 | L15/amo20 | 15 | 15020000036059 | 15020000036078 | 1 | M. | Laurent | Dassonville | ||
| 15020000036080 | L15/amo20 | 15 | 15020000036059 | 15020000036078 | 2 | M. | Julien | Odoul | ||
| 15020000036081 | L15/amo20 | 15 | 15020000036059 | 15020000036078 | 3 | M. | Laurent | Brice | ||
| 15020000036082 | L15/amo20 | 15 | 15020000036059 | 15020000036078 | 4 | M. | Louis | Mompeu | ||
| 15020000036134 | L15/amo20 | 15 | 15020000036083 | 15020000036133 | 1 | M. | Sylvain | Gony | ||
| 15020000036135 | L15/amo20 | 15 | 15020000036083 | 15020000036133 | 2 | Mme | Céline | Molinier | ||
| 15020000036136 | L15/amo20 | 15 | 15020000036083 | 15020000036133 | 3 | M. | Joismy | Barroso Mukombo | ||
| 15020000036206 | L15/amo20 | 15 | 15020000036137 | 15020000036205 | 1 | Mme | Lucie | Kirchner | ||
| 15020000036207 | L15/amo20 | 15 | 15020000036137 | 15020000036205 | 2 | M. | Aurélien | Saintoul | ||
| 15020000036208 | L15/amo20 | 15 | 15020000036137 | 15020000036205 | 3 | M. | Arnaud | Le Gall | ||
| 15020000036243 | L15/amo20 | 15 | 15020000036209 | 15020000036242 | 1 | M. | Jérôme | Meunier | ||
| 15020000036244 | L15/amo20 | 15 | 15020000036209 | 15020000036242 | 2 | Mme | Prisca | Thévenot | ||
| 15020000036245 | L15/amo20 | 15 | 15020000036209 | 15020000036242 | 3 | Mme | Aminata | Coulibaly | ||
| 15020000036276 | L15/amo20 | 15 | 15020000036246 | 15020000036275 | 1 | M. | Pierre | Delavaquerie | ||
| 15020000036342 | L15/amo20 | 15 | 15020000036277 | 15020000036341 | 1 | Mme | Jacqueline | Eude-Dürler | ||
| 15020000036343 | L15/amo20 | 15 | 15020000036277 | 15020000036341 | 2 | M. | Thomas | Burkarth | ||
| 15020000036344 | L15/amo20 | 15 | 15020000036277 | 15020000036341 | 3 | M. | Manuel | Thenard | ||
| 15020000036345 | L15/amo20 | 15 | 15020000036277 | 15020000036341 | 4 | Mme | Salma | Briouel | ||
| 15020000036439 | L15/amo20 | 15 | 15020000036346 | 15020000036438 | 1 | Mme | Florence | Rognard | ||
| 15020000036440 | L15/amo20 | 15 | 15020000036346 | 15020000036438 | 2 | M. | Yanis | Sicre | ||
| 15020000036441 | L15/amo20 | 15 | 15020000036346 | 15020000036438 | 3 | M. | Alexy | Rodriguez | ||
| 15020000036508 | L15/amo20 | 15 | 15020000036445 | 15020000036507 | 1 | M. | Helmi | M'Rabet | ||
| 15020000036509 | L15/amo20 | 15 | 15020000036445 | 15020000036507 | 2 | Mme | Lynda-May | Azibi | ||
| 15020000036510 | L15/amo20 | 15 | 15020000036445 | 15020000036507 | 3 | Mme | Josépha | Le Goff | ||
| 15020000036511 | L15/amo20 | 15 | 15020000036445 | 15020000036507 | 4 | Mme | Elise | Trouvé-Buisson | ||
| 15020000036566 | L15/amo20 | 15 | 15020000036512 | 15020000036565 | 1 | M. | Karim | Boulkhoubz | ||
| 15020000036567 | L15/amo20 | 15 | 15020000036512 | 15020000036565 | 2 | M. | Jean | Exilus | ||
| 15020000036568 | L15/amo20 | 15 | 15020000036512 | 15020000036565 | 3 | Mme | Victoria | Jolly | ||
| 15020000036646 | L15/amo20 | 15 | 15020000036569 | 15020000036645 | 1 | M. | Juan | Diaz del Cano | ||
| 15020000036647 | L15/amo20 | 15 | 15020000036569 | 15020000036645 | 2 | Mme | Valérie | Attrait | ||
| 15020000036648 | L15/amo20 | 15 | 15020000036569 | 15020000036645 | 3 | M. | Jean-Christophe | Barré |