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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 15020000037562 | L15/amo20 | 15 | 15020000037516 | 15020000037559 | 3 | M. | Gilles | Waro | ||
| 15020000037605 | L15/amo20 | 15 | 15020000037563 | 15020000037604 | 1 | M. | Eric | Parlier | ||
| 15020000037606 | L15/amo20 | 15 | 15020000037563 | 15020000037604 | 2 | Mme | Vanessa | Balbine | ||
| 15020000037659 | L15/amo20 | 15 | 15020000037611 | 15020000037658 | 1 | M. | Luçay | Sautron | ||
| 15020000037660 | L15/amo20 | 15 | 15020000037611 | 15020000037658 | 2 | M. | Gérard | Cazanove | ||
| 15020000037661 | L15/amo20 | 15 | 15020000037611 | 15020000037658 | 3 | M. | Brice | Baillard | ||
| 15020000037662 | L15/amo20 | 15 | 15020000037611 | 15020000037658 | 4 | Mme | Aliette | Soupaya Valliama | ||
| 15020000037663 | L15/amo20 | 15 | 15020000037611 | 15020000037658 | 5 | M. | José | Apou | ||
| 15020000037727 | L15/amo20 | 15 | 15020000037664 | 15020000037726 | 1 | M. | Eric | Helard | ||
| 15020000037728 | L15/amo20 | 15 | 15020000037664 | 15020000037726 | 2 | Mme | Marie-Astrid | Jardé | ||
| 15020000037788 | L15/amo20 | 15 | 15020000037729 | 15020000037787 | 1 | Mme | Sylvie | Bouras | ||
| 15020000037789 | L15/amo20 | 15 | 15020000037729 | 15020000037787 | 2 | Mme | Leila | Auméran | ||
| 15020000037790 | L15/amo20 | 15 | 15020000037729 | 15020000037787 | 3 | Mme | Alexia | Torea | ||
| 15020000037791 | L15/amo20 | 15 | 15020000037729 | 15020000037787 | 4 | Mme | Honorine | Omitai | ||
| 15020000037877 | L15/amo20 | 15 | 15020000037792 | 15020000037876 | 1 | M. | Te Haurii | Taimana | ||
| 15020000037878 | L15/amo20 | 15 | 15020000037792 | 15020000037876 | 2 | Mme | Mateata | Materouru | ||
| 15020000037879 | L15/amo20 | 15 | 15020000037792 | 15020000037876 | 3 | Mme | Aunoo-Douce | François-Eloccie | ||
| 15020000037914 | L15/amo20 | 15 | 15020000037880 | 15020000037913 | 1 | Mme | Christiane | Carty | ||
| 15020000037915 | L15/amo20 | 15 | 15020000037880 | 15020000037913 | 2 | Mme | Jénovéfa | Eche | ||
| 15020000037992 | L15/amo20 | 15 | 15020000037925 | 15020000037991 | 1 | M. | Tony | Lopez | ||
| 15020000037993 | L15/amo20 | 15 | 15020000037925 | 15020000037991 | 2 | Mme | Maîna | Tréguier | ||
| 15020000037994 | L15/amo20 | 15 | 15020000037925 | 15020000037991 | 3 | Mme | Capucine | Barraud-Degouy | ||
| 15020000038044 | L15/amo20 | 15 | 15020000037995 | 15020000038043 | 1 | M. | Xavier | Berne | ||
| 15020000038045 | L15/amo20 | 15 | 15020000037995 | 15020000038043 | 2 | Mme | Emilie | Gapaillard | ||
| 15020000038046 | L15/amo20 | 15 | 15020000037995 | 15020000038043 | 3 | M. | Miguel | Pedro | ||
| 15020000038047 | L15/amo20 | 15 | 15020000037995 | 15020000038043 | 4 | Mme | Morgane | Merat | ||
| 15020000038116 | L15/amo20 | 15 | 15020000038048 | 15020000038115 | 1 | Mme | Melissa | Amroun | ||
| 15020000038117 | L15/amo20 | 15 | 15020000038048 | 15020000038115 | 2 | M. | Thibault | Gavalda | ||
| 15020000038173 | L15/amo20 | 15 | 15020000038118 | 15020000038172 | 1 | M. | Maxime | Lelièvre | ||
| 15020000038174 | L15/amo20 | 15 | 15020000038118 | 15020000038172 | 2 | Mme | Pegah | Malek-Ahmadi | ||
| 15020000038235 | L15/amo20 | 15 | 15020000038219 | 15020000038234 | 1 | M. | Yann | Saillard | ||
| 15020000038236 | L15/amo20 | 15 | 15020000038219 | 15020000038234 | 2 | Mme | Bérénice | Mottelay | ||
| 15020000038237 | L15/amo20 | 15 | 15020000038219 | 15020000038234 | 3 | Mme | Marie | Camacho | ||
| 15020000038238 | L15/amo20 | 15 | 15020000038219 | 15020000038234 | 4 | Mme | Emilie | Chartier | ||
| 15020000038239 | L15/amo20 | 15 | 15020000038219 | 15020000038234 | 5 | M. | Gautier | Lagarde | ||
| 15020000038453 | L15/amo20 | 15 | 15020000038240 | 15020000038452 | 1 | Mme | Emeline | Ozhan | ||
| 15020000038454 | L15/amo20 | 15 | 15020000038240 | 15020000038452 | 2 | Mme | Camille | Lemaitre | ||
| 15020000038455 | L15/amo20 | 15 | 15020000038240 | 15020000038452 | 3 | M. | Jean-Eudes | Le Moulec-Deschamps | ||
| 15020000038456 | L15/amo20 | 15 | 15020000038240 | 15020000038452 | 4 | Mme | Hermine | Falicon | ||
| 15020000038457 | L15/amo20 | 15 | 15020000038240 | 15020000038452 | 5 | Mme | Suzanne | Caye | ||
| 15020000038516 | L15/amo20 | 15 | 15020000038458 | 15020000038515 | 1 | Mme | Claire | Staudenmayer | ||
| 15020000038517 | L15/amo20 | 15 | 15020000038458 | 15020000038515 | 2 | M. | Hugo | Outin | ||
| 15020000038518 | L15/amo20 | 15 | 15020000038458 | 15020000038515 | 3 | M. | Arthur | Kenigsberg | ||
| 15020000038519 | L15/amo20 | 15 | 15020000038458 | 15020000038515 | 4 | Mme | Nadia | Salem | ||
| 15020000038594 | L15/amo20 | 15 | 15020000038520 | 15020000038593 | 1 | M. | Etienne | Lesoeur | ||
| 15020000038595 | L15/amo20 | 15 | 15020000038520 | 15020000038593 | 2 | Mme | Anne-Céline | Guihéneuf | ||
| 15020000038596 | L15/amo20 | 15 | 15020000038520 | 15020000038593 | 3 | Mme | Aline | Durand | ||
| 15020000038667 | L15/amo20 | 15 | 15020000038597 | 15020000038666 | 1 | Mme | Manon | Monmirel | ||
| 15020000038668 | L15/amo20 | 15 | 15020000038597 | 15020000038666 | 2 | Mme | Aude | Courbier | ||
| 15020000038669 | L15/amo20 | 15 | 15020000038597 | 15020000038666 | 3 | Mme | Layla | Yakoub |