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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17030000159229 | L17/amo30 | 17 | 17030000159214 | 17030000159225 | 4 | Mme | Mireille | Giunta | ||
| 17030000159364 | L17/amo30 | 17 | 17030000159299 | 17030000159363 | 1 | Mme | Cécile | Gonzalez | ||
| 17030000159365 | L17/amo30 | 17 | 17030000159299 | 17030000159363 | 2 | M. | Etienne | Gaume | ||
| 17030000159366 | L17/amo30 | 17 | 17030000159299 | 17030000159363 | 3 | M. | Romain | Donadini | ||
| 17030000159468 | L17/amo30 | 17 | 17030000159367 | 17030000159467 | 1 | Mme | Anaïs | Fournier | ||
| 17030000159469 | L17/amo30 | 17 | 17030000159367 | 17030000159467 | 2 | M. | Fabien | Brunet | ||
| 17030000159617 | L17/amo30 | 17 | 17030000159535 | 17030000159616 | 1 | M. | Baptiste | Vaugoyeau | ||
| 17030000159618 | L17/amo30 | 17 | 17030000159535 | 17030000159616 | 2 | M. | Alexandre | Smadja | ||
| 17030000159619 | L17/amo30 | 17 | 17030000159535 | 17030000159616 | 3 | Mme | Clarisse | Chabernaud | ||
| 17030000159638 | L17/amo30 | 17 | 17030000159620 | 17030000159637 | 1 | M. | Martin | Rochepeau | ||
| 17030000159639 | L17/amo30 | 17 | 17030000159620 | 17030000159637 | 2 | M. | Benjamin | Kirschner | ||
| 17030000159640 | L17/amo30 | 17 | 17030000159620 | 17030000159637 | 3 | Mme | Stéphanie | de Fortis | ||
| 17030000159758 | L17/amo30 | 17 | 17030000159641 | 17030000159757 | 1 | M. | Anthony | Chrétien | ||
| 17030000159759 | L17/amo30 | 17 | 17030000159641 | 17030000159757 | 2 | Mme | Estelle | Loret | ||
| 17030000159760 | L17/amo30 | 17 | 17030000159641 | 17030000159757 | 3 | M. | Eliott | Boulais-Rivière | ||
| 17030000159761 | L17/amo30 | 17 | 17030000159641 | 17030000159757 | 4 | Mme | Capucine | Marie | ||
| 17030000159839 | L17/amo30 | 17 | 17030000159762 | 17030000159838 | 1 | Mme | Julie | Boillot | ||
| 17030000159840 | L17/amo30 | 17 | 17030000159762 | 17030000159838 | 2 | Mme | Maud | Krebs | ||
| 17030000159841 | L17/amo30 | 17 | 17030000159762 | 17030000159838 | 3 | M. | Valentin | Michel | ||
| 17030000159981 | L17/amo30 | 17 | 17030000159889 | 17030000159980 | 1 | M. | Loïc | Burgun | ||
| 17030000159982 | L17/amo30 | 17 | 17030000159889 | 17030000159980 | 2 | Mme | Nadège | Cardot | ||
| 17030000159983 | L17/amo30 | 17 | 17030000159889 | 17030000159980 | 3 | M. | Anthony | Zeller | ||
| 17030000160096 | L17/amo30 | 17 | 17030000159984 | 17030000160095 | 1 | M. | Cédric | Chambard | ||
| 17030000160097 | L17/amo30 | 17 | 17030000159984 | 17030000160095 | 2 | M. | Eric | Tournon | ||
| 17030000160098 | L17/amo30 | 17 | 17030000159984 | 17030000160095 | 3 | Mme | Marie-Françoise | Fautrat | ||
| 17030000160099 | L17/amo30 | 17 | 17030000159984 | 17030000160095 | 4 | Mme | Véronique | Breton | ||
| 17030000160183 | L17/amo30 | 17 | 17030000160100 | 17030000160182 | 1 | M. | Martin | Jarrige | ||
| 17030000160184 | L17/amo30 | 17 | 17030000160100 | 17030000160182 | 2 | M. | Steven | Quinet | ||
| 17030000160185 | L17/amo30 | 17 | 17030000160100 | 17030000160182 | 3 | M. | Grégoire | Guillemin | ||
| 17030000160186 | L17/amo30 | 17 | 17030000160100 | 17030000160182 | 4 | Mme | Marie-Liesse | Renucci | ||
| 17030000160515 | L17/amo30 | 17 | 17030000160449 | 17030000160514 | 1 | M. | Jean-Baptiste | Orban | ||
| 17030000160516 | L17/amo30 | 17 | 17030000160449 | 17030000160514 | 2 | Mme | Carine | George | ||
| 17030000160517 | L17/amo30 | 17 | 17030000160449 | 17030000160514 | 3 | Mme | Anne | Chouzenoux | ||
| 17030000160602 | L17/amo30 | 17 | 17030000160584 | 17030000160601 | 1 | Mme | Constance | Journet | ||
| 17030000160603 | L17/amo30 | 17 | 17030000160584 | 17030000160601 | 2 | Mme | Louise | Krafft | ||
| 17030000160679 | L17/amo30 | 17 | 17030000160604 | 17030000160678 | 1 | M. | Roch | Girard | ||
| 17030000160680 | L17/amo30 | 17 | 17030000160604 | 17030000160678 | 2 | M. | Charles | Marconnet | ||
| 17030000160681 | L17/amo30 | 17 | 17030000160604 | 17030000160678 | 3 | M. | Géraud | Mautin | ||
| 17030000160682 | L17/amo30 | 17 | 17030000160604 | 17030000160678 | 4 | M. | Fabien | Muradian | ||
| 17030000160709 | L17/amo30 | 17 | 17030000160683 | 17030000160708 | 1 | M. | Pascal | Erre | ||
| 17030000160710 | L17/amo30 | 17 | 17030000160683 | 17030000160708 | 2 | Mme | Stéphanie | Brouard | ||
| 17030000160711 | L17/amo30 | 17 | 17030000160683 | 17030000160708 | 3 | M. | Damien | Obrador | ||
| 17030000160712 | L17/amo30 | 17 | 17030000160683 | 17030000160708 | 4 | Mme | Coraline | Durand | ||
| 17030000160713 | L17/amo30 | 17 | 17030000160683 | 17030000160708 | 5 | M. | Charles | Rouvier | ||
| 17030000160897 | L17/amo30 | 17 | 17030000160831 | 17030000160896 | 1 | M. | Alexis | Her | ||
| 17030000160898 | L17/amo30 | 17 | 17030000160831 | 17030000160896 | 2 | M. | Louis-Alexandre | Osinski | ||
| 17030000160899 | L17/amo30 | 17 | 17030000160831 | 17030000160896 | 3 | M. | Cyrille | Macron | ||
| 17030000161017 | L17/amo30 | 17 | 17030000160950 | 17030000161016 | 1 | Mme | Tiphaine | Lemoine | ||
| 17030000161018 | L17/amo30 | 17 | 17030000160950 | 17030000161016 | 2 | M. | Eric | Aelterman | ||
| 17030000161019 | L17/amo30 | 17 | 17030000160950 | 17030000161016 | 3 | Mme | Mathilde | Remi |