amo10.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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17010000010307 | L17/amo10 | 17 | 17010000010292 | 17010000010303 | 4 | Mme | Mireille | Giunta | ||
| 17010000010327 | L17/amo10 | 17 | 17010000010308 | 17010000010326 | 1 | Mme | Cécile | Gonzalez | ||
| 17010000010328 | L17/amo10 | 17 | 17010000010308 | 17010000010326 | 2 | M. | Etienne | Gaume | ||
| 17010000010329 | L17/amo10 | 17 | 17010000010308 | 17010000010326 | 3 | M. | Romain | Donadini | ||
| 17010000010359 | L17/amo10 | 17 | 17010000010330 | 17010000010358 | 1 | Mme | Anaïs | Fournier | ||
| 17010000010360 | L17/amo10 | 17 | 17010000010330 | 17010000010358 | 2 | M. | Fabien | Brunet | ||
| 17010000010388 | L17/amo10 | 17 | 17010000010361 | 17010000010387 | 1 | M. | Baptiste | Vaugoyeau | ||
| 17010000010389 | L17/amo10 | 17 | 17010000010361 | 17010000010387 | 2 | M. | Alexandre | Smadja | ||
| 17010000010390 | L17/amo10 | 17 | 17010000010361 | 17010000010387 | 3 | Mme | Clarisse | Chabernaud | ||
| 17010000010408 | L17/amo10 | 17 | 17010000010391 | 17010000010407 | 1 | M. | Martin | Rochepeau | ||
| 17010000010409 | L17/amo10 | 17 | 17010000010391 | 17010000010407 | 2 | M. | Benjamin | Kirschner | ||
| 17010000010410 | L17/amo10 | 17 | 17010000010391 | 17010000010407 | 3 | Mme | Stéphanie | de Fortis | ||
| 17010000010448 | L17/amo10 | 17 | 17010000010411 | 17010000010447 | 1 | M. | Anthony | Chrétien | ||
| 17010000010449 | L17/amo10 | 17 | 17010000010411 | 17010000010447 | 2 | Mme | Estelle | Loret | ||
| 17010000010450 | L17/amo10 | 17 | 17010000010411 | 17010000010447 | 3 | M. | Eliott | Boulais-Rivière | ||
| 17010000010451 | L17/amo10 | 17 | 17010000010411 | 17010000010447 | 4 | Mme | Capucine | Marie | ||
| 17010000010473 | L17/amo10 | 17 | 17010000010452 | 17010000010472 | 1 | Mme | Julie | Boillot | ||
| 17010000010474 | L17/amo10 | 17 | 17010000010452 | 17010000010472 | 2 | Mme | Maud | Krebs | ||
| 17010000010475 | L17/amo10 | 17 | 17010000010452 | 17010000010472 | 3 | M. | Valentin | Michel | ||
| 17010000010512 | L17/amo10 | 17 | 17010000010476 | 17010000010511 | 1 | M. | Loïc | Burgun | ||
| 17010000010513 | L17/amo10 | 17 | 17010000010476 | 17010000010511 | 2 | Mme | Nadège | Cardot | ||
| 17010000010514 | L17/amo10 | 17 | 17010000010476 | 17010000010511 | 3 | M. | Anthony | Zeller | ||
| 17010000010545 | L17/amo10 | 17 | 17010000010515 | 17010000010544 | 1 | M. | Cédric | Chambard | ||
| 17010000010546 | L17/amo10 | 17 | 17010000010515 | 17010000010544 | 2 | M. | Eric | Tournon | ||
| 17010000010547 | L17/amo10 | 17 | 17010000010515 | 17010000010544 | 3 | Mme | Marie-Françoise | Fautrat | ||
| 17010000010548 | L17/amo10 | 17 | 17010000010515 | 17010000010544 | 4 | Mme | Véronique | Breton | ||
| 17010000010589 | L17/amo10 | 17 | 17010000010549 | 17010000010588 | 1 | M. | Martin | Jarrige | ||
| 17010000010590 | L17/amo10 | 17 | 17010000010549 | 17010000010588 | 2 | M. | Steven | Quinet | ||
| 17010000010591 | L17/amo10 | 17 | 17010000010549 | 17010000010588 | 3 | M. | Grégoire | Guillemin | ||
| 17010000010592 | L17/amo10 | 17 | 17010000010549 | 17010000010588 | 4 | Mme | Marie-Liesse | Renucci | ||
| 17010000010618 | L17/amo10 | 17 | 17010000010593 | 17010000010617 | 1 | M. | Jean-Baptiste | Orban | ||
| 17010000010619 | L17/amo10 | 17 | 17010000010593 | 17010000010617 | 2 | Mme | Carine | George | ||
| 17010000010620 | L17/amo10 | 17 | 17010000010593 | 17010000010617 | 3 | Mme | Anne | Chouzenoux | ||
| 17010000010635 | L17/amo10 | 17 | 17010000010621 | 17010000010634 | 1 | Mme | Constance | Journet | ||
| 17010000010636 | L17/amo10 | 17 | 17010000010621 | 17010000010634 | 2 | Mme | Louise | Krafft | ||
| 17010000010670 | L17/amo10 | 17 | 17010000010637 | 17010000010669 | 1 | M. | Roch | Girard | ||
| 17010000010671 | L17/amo10 | 17 | 17010000010637 | 17010000010669 | 2 | M. | Charles | Marconnet | ||
| 17010000010672 | L17/amo10 | 17 | 17010000010637 | 17010000010669 | 3 | M. | Géraud | Mautin | ||
| 17010000010673 | L17/amo10 | 17 | 17010000010637 | 17010000010669 | 4 | M. | Fabien | Muradian | ||
| 17010000010685 | L17/amo10 | 17 | 17010000010674 | 17010000010684 | 1 | M. | Pascal | Erre | ||
| 17010000010686 | L17/amo10 | 17 | 17010000010674 | 17010000010684 | 2 | Mme | Stéphanie | Brouard | ||
| 17010000010687 | L17/amo10 | 17 | 17010000010674 | 17010000010684 | 3 | M. | Damien | Obrador | ||
| 17010000010688 | L17/amo10 | 17 | 17010000010674 | 17010000010684 | 4 | Mme | Coraline | Durand | ||
| 17010000010689 | L17/amo10 | 17 | 17010000010674 | 17010000010684 | 5 | M. | Charles | Rouvier | ||
| 17010000010717 | L17/amo10 | 17 | 17010000010690 | 17010000010716 | 1 | M. | Alexis | Her | ||
| 17010000010718 | L17/amo10 | 17 | 17010000010690 | 17010000010716 | 2 | M. | Louis-Alexandre | Osinski | ||
| 17010000010719 | L17/amo10 | 17 | 17010000010690 | 17010000010716 | 3 | M. | Cyrille | Macron | ||
| 17010000010739 | L17/amo10 | 17 | 17010000010720 | 17010000010738 | 1 | Mme | Tiphaine | Lemoine | ||
| 17010000010740 | L17/amo10 | 17 | 17010000010720 | 17010000010738 | 2 | M. | Eric | Aelterman | ||
| 17010000010741 | L17/amo10 | 17 | 17010000010720 | 17010000010738 | 3 | Mme | Mathilde | Remi |