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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 15020000036649 | L15/amo20 | 15 | 15020000036569 | 15020000036645 | 4 | Mme | Coline | Rougeaux | ||
| 15020000036731 | L15/amo20 | 15 | 15020000036650 | 15020000036730 | 1 | Mme | Karine | Rivière | ||
| 15020000036840 | L15/amo20 | 15 | 15020000036803 | 15020000036839 | 1 | Mme | Noëlie | Lopez-Morard | ||
| 15020000036841 | L15/amo20 | 15 | 15020000036803 | 15020000036839 | 2 | Mme | Emmanuelle | Desbois | ||
| 15020000036842 | L15/amo20 | 15 | 15020000036803 | 15020000036839 | 3 | M. | Victor | Sousa | ||
| 15020000036915 | L15/amo20 | 15 | 15020000036843 | 15020000036914 | 1 | M. | Nabil | Ait Akkache | ||
| 15020000036916 | L15/amo20 | 15 | 15020000036843 | 15020000036914 | 2 | M. | Michel | Amri | ||
| 15020000036917 | L15/amo20 | 15 | 15020000036843 | 15020000036914 | 3 | M. | Mohamed-El-Amine | Boubekeur | ||
| 15020000036961 | L15/amo20 | 15 | 15020000036918 | 15020000036960 | 1 | Mme | Maryeme | Bouslam | ||
| 15020000036962 | L15/amo20 | 15 | 15020000036918 | 15020000036960 | 2 | M. | Marius | Esposito | ||
| 15020000036963 | L15/amo20 | 15 | 15020000036918 | 15020000036960 | 3 | M. | Majdi | Chaarana | ||
| 15020000037014 | L15/amo20 | 15 | 15020000036964 | 15020000037013 | 1 | Mme | Keiza | Grand-Bonheur | ||
| 15020000037015 | L15/amo20 | 15 | 15020000036964 | 15020000037013 | 2 | M. | Pierre | Soulez | ||
| 15020000037016 | L15/amo20 | 15 | 15020000036964 | 15020000037013 | 3 | M. | Patrice | Resdedant | ||
| 15020000037017 | L15/amo20 | 15 | 15020000036964 | 15020000037013 | 4 | Mme | Sandrine | Serva | ||
| 15020000037018 | L15/amo20 | 15 | 15020000036964 | 15020000037013 | 5 | Mme | Georgia | Saint-Jean | ||
| 15020000037019 | L15/amo20 | 15 | 15020000036964 | 15020000037013 | 6 | Mme | Oxann | Sahai | ||
| 15020000037020 | L15/amo20 | 15 | 15020000036964 | 15020000037013 | 7 | Mme | Elyssa | Laurent | ||
| 15020000037021 | L15/amo20 | 15 | 15020000036964 | 15020000037013 | 8 | M. | Freddy | Lobeau | ||
| 15020000037063 | L15/amo20 | 15 | 15020000037022 | 15020000037062 | 1 | Mme | Younid | Coupan | ||
| 15020000037064 | L15/amo20 | 15 | 15020000037022 | 15020000037062 | 2 | M. | Pédro | Hippon | ||
| 15020000037098 | L15/amo20 | 15 | 15020000037065 | 15020000037097 | 1 | Mme | Laurence | de Saint Sernin | ||
| 15020000037099 | L15/amo20 | 15 | 15020000037065 | 15020000037097 | 2 | M. | Danick | Lator | ||
| 15020000037100 | L15/amo20 | 15 | 15020000037065 | 15020000037097 | 3 | Mme | Yaëlle | Pagesy | ||
| 15020000037101 | L15/amo20 | 15 | 15020000037065 | 15020000037097 | 4 | M. | Fred | Sapotille | ||
| 15020000037102 | L15/amo20 | 15 | 15020000037065 | 15020000037097 | 5 | M. | Jean | Valluet | ||
| 15020000037136 | L15/amo20 | 15 | 15020000037103 | 15020000037135 | 1 | M. | Brayen | Sooranna | ||
| 15020000037137 | L15/amo20 | 15 | 15020000037103 | 15020000037135 | 2 | M. | Lionel | Quille | ||
| 15020000037138 | L15/amo20 | 15 | 15020000037103 | 15020000037135 | 3 | Mme | Sandra | Seneron | ||
| 15020000037221 | L15/amo20 | 15 | 15020000037139 | 15020000037220 | 1 | M. | Anisse | Ben Younès | ||
| 15020000037222 | L15/amo20 | 15 | 15020000037139 | 15020000037220 | 2 | Mme | Mathilde | Tanguy | ||
| 15020000037223 | L15/amo20 | 15 | 15020000037139 | 15020000037220 | 3 | M. | Dylan | Piras | ||
| 15020000037296 | L15/amo20 | 15 | 15020000037224 | 15020000037295 | 1 | M. | Roman | Kwiatkowski | ||
| 15020000037297 | L15/amo20 | 15 | 15020000037224 | 15020000037295 | 2 | M. | Christophe | Calmann-Lévy | ||
| 15020000037298 | L15/amo20 | 15 | 15020000037224 | 15020000037295 | 3 | M. | Joseph | Mecarsel | ||
| 15020000037299 | L15/amo20 | 15 | 15020000037224 | 15020000037295 | 4 | Mme | Sylvie | Autissier | ||
| 15020000037333 | L15/amo20 | 15 | 15020000037300 | 15020000037332 | 1 | M. | Bruno | Daniel | ||
| 15020000037334 | L15/amo20 | 15 | 15020000037300 | 15020000037332 | 2 | M. | Pascal | Margueritte | ||
| 15020000037335 | L15/amo20 | 15 | 15020000037300 | 15020000037332 | 3 | M. | Jean-Simon | Salvage | ||
| 15020000037407 | L15/amo20 | 15 | 15020000037336 | 15020000037406 | 1 | Mme | Stéphanie | Reverchon | ||
| 15020000037408 | L15/amo20 | 15 | 15020000037336 | 15020000037406 | 2 | Mme | Bénédicte | Maerten | ||
| 15020000037409 | L15/amo20 | 15 | 15020000037336 | 15020000037406 | 3 | M. | Stéphane | Courtois | ||
| 15020000037410 | L15/amo20 | 15 | 15020000037336 | 15020000037406 | 4 | M. | Vincent | Berthiot | ||
| 15020000037465 | L15/amo20 | 15 | 15020000037414 | 15020000037464 | 1 | Mme | Lovely | Bergena | ||
| 15020000037466 | L15/amo20 | 15 | 15020000037414 | 15020000037464 | 2 | M. | Romaric | Baya | ||
| 15020000037513 | L15/amo20 | 15 | 15020000037468 | 15020000037512 | 1 | M. | Jean | Cadet | ||
| 15020000037514 | L15/amo20 | 15 | 15020000037468 | 15020000037512 | 2 | Mme | Nadège | Schneeberger | ||
| 15020000037515 | L15/amo20 | 15 | 15020000037468 | 15020000037512 | 3 | M. | Hugues | Bévillard | ||
| 15020000037560 | L15/amo20 | 15 | 15020000037516 | 15020000037559 | 1 | M. | Pierre-Henri | Fourgous | ||
| 15020000037561 | L15/amo20 | 15 | 15020000037516 | 15020000037559 | 2 | M. | Willy | Araboux |