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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17020000002428 | L17/amo20 | 17 | 17020000002290 | 17020000002425 | 3 | M. | Denis | Vincent | ||
| 17020000002429 | L17/amo20 | 17 | 17020000002290 | 17020000002425 | 4 | Mme | Inès | Jacques | ||
| 17020000002430 | L17/amo20 | 17 | 17020000002290 | 17020000002425 | 5 | Mme | Faustine | Ruchaud | ||
| 17020000002487 | L17/amo20 | 17 | 17020000002431 | 17020000002486 | 1 | M. | Sébastien | Giard | ||
| 17020000002488 | L17/amo20 | 17 | 17020000002431 | 17020000002486 | 2 | Mme | Angela | Héranval | ||
| 17020000002489 | L17/amo20 | 17 | 17020000002431 | 17020000002486 | 3 | Mme | Marine | Beaurain | ||
| 17020000002550 | L17/amo20 | 17 | 17020000002517 | 17020000002549 | 1 | M. | Mathieu | Havsali | ||
| 17020000002551 | L17/amo20 | 17 | 17020000002517 | 17020000002549 | 2 | Mme | Edith | Lecherbonnier | ||
| 17020000002552 | L17/amo20 | 17 | 17020000002517 | 17020000002549 | 3 | M. | Yoann | Balestrat | ||
| 17020000002611 | L17/amo20 | 17 | 17020000002574 | 17020000002610 | 1 | M. | Théo | Durand-Tortorella | ||
| 17020000002612 | L17/amo20 | 17 | 17020000002574 | 17020000002610 | 2 | Mme | Mylène | Coste | ||
| 17020000002613 | L17/amo20 | 17 | 17020000002574 | 17020000002610 | 3 | M. | Riwan | Yahmi | ||
| 17020000002688 | L17/amo20 | 17 | 17020000002627 | 17020000002687 | 1 | M. | Ludovic | Germain | ||
| 17020000002689 | L17/amo20 | 17 | 17020000002627 | 17020000002687 | 2 | Mme | Jeanne | Bardoux | ||
| 17020000002690 | L17/amo20 | 17 | 17020000002627 | 17020000002687 | 3 | M. | Gabriel | Troude--Beherégaray | ||
| 17020000002691 | L17/amo20 | 17 | 17020000002627 | 17020000002687 | 4 | Mme | Carla | Kopp | ||
| 17020000002737 | L17/amo20 | 17 | 17020000002692 | 17020000002736 | 1 | Mme | Delphine | Rolland | ||
| 17020000002738 | L17/amo20 | 17 | 17020000002692 | 17020000002736 | 2 | M. | Julien | Cahu | ||
| 17020000002739 | L17/amo20 | 17 | 17020000002692 | 17020000002736 | 3 | M. | Jérôme | Petit | ||
| 17020000002773 | L17/amo20 | 17 | 17020000002740 | 17020000002772 | 1 | Mme | Stéphanie | Botcazou | ||
| 17020000002774 | L17/amo20 | 17 | 17020000002740 | 17020000002772 | 2 | Mme | Tania | Carré | ||
| 17020000002775 | L17/amo20 | 17 | 17020000002740 | 17020000002772 | 3 | Mme | Sophie | Paillard | ||
| 17020000002826 | L17/amo20 | 17 | 17020000002776 | 17020000002825 | 1 | Mme | Sarah | Meyssonnier | ||
| 17020000002827 | L17/amo20 | 17 | 17020000002776 | 17020000002825 | 2 | Mme | Myriam | Lejmi | ||
| 17020000002828 | L17/amo20 | 17 | 17020000002776 | 17020000002825 | 3 | M. | Albin | Dubanchet | ||
| 17020000002829 | L17/amo20 | 17 | 17020000002776 | 17020000002825 | 4 | Mme | Solène | Del'Homme | ||
| 17020000002921 | L17/amo20 | 17 | 17020000002830 | 17020000002920 | 1 | M. | Adrian | Raffin | ||
| 17020000002922 | L17/amo20 | 17 | 17020000002830 | 17020000002920 | 2 | Mme | Nathalie | Gritti-Rival | ||
| 17020000002923 | L17/amo20 | 17 | 17020000002830 | 17020000002920 | 3 | M. | Alexandre | Leclercq | ||
| 17020000002924 | L17/amo20 | 17 | 17020000002830 | 17020000002920 | 4 | M. | Natan | Pillot | ||
| 17020000002925 | L17/amo20 | 17 | 17020000002830 | 17020000002920 | 5 | Mme | Anaïs | Poncet | ||
| 17020000003064 | L17/amo20 | 17 | 17020000002949 | 17020000003063 | 1 | Mme | Eve-Marie | Ganczarczyk | ||
| 17020000003065 | L17/amo20 | 17 | 17020000002949 | 17020000003063 | 2 | M. | Ludger | Adnot | ||
| 17020000003126 | L17/amo20 | 17 | 17020000003092 | 17020000003125 | 1 | M. | Pierre | Baillou | ||
| 17020000003127 | L17/amo20 | 17 | 17020000003092 | 17020000003125 | 2 | Mme | Sabine | Rozier-Deroche | ||
| 17020000003128 | L17/amo20 | 17 | 17020000003092 | 17020000003125 | 3 | Mme | Roxane | Beguet | ||
| 17020000003129 | L17/amo20 | 17 | 17020000003092 | 17020000003125 | 4 | M. | Dimitri | Ferrand | ||
| 17020000003130 | L17/amo20 | 17 | 17020000003092 | 17020000003125 | 5 | M. | Vincent | Delorme | ||
| 17020000003131 | L17/amo20 | 17 | 17020000003092 | 17020000003125 | 6 | M. | Eric | Cesari | ||
| 17020000003152 | L17/amo20 | 17 | 17020000003132 | 17020000003151 | 1 | M. | Guillaume | Lamidon | ||
| 17020000003153 | L17/amo20 | 17 | 17020000003132 | 17020000003151 | 2 | Mme | Lisa | Berdah | ||
| 17020000003154 | L17/amo20 | 17 | 17020000003132 | 17020000003151 | 3 | M. | Timothé | Gagnard | ||
| 17020000003596 | L17/amo20 | 17 | 17020000003559 | 17020000003595 | 1 | Mme | Julie | Capo Ortega | ||
| 17020000003597 | L17/amo20 | 17 | 17020000003559 | 17020000003595 | 2 | Mme | Catherine | Jacob | ||
| 17020000003598 | L17/amo20 | 17 | 17020000003559 | 17020000003595 | 3 | Mme | Geneviève | Parmentier | ||
| 17020000003599 | L17/amo20 | 17 | 17020000003559 | 17020000003595 | 4 | M. | Christian | Victor | ||
| 17020000003634 | L17/amo20 | 17 | 17020000003600 | 17020000003633 | 1 | M. | Julien | Auffret | ||
| 17020000003635 | L17/amo20 | 17 | 17020000003600 | 17020000003633 | 2 | M. | Rodrigue | Elichondoborde | ||
| 17020000003636 | L17/amo20 | 17 | 17020000003600 | 17020000003633 | 3 | Mme | Chloé | Linard | ||
| 17020000003637 | L17/amo20 | 17 | 17020000003600 | 17020000003633 | 4 | Mme | Emma | Bernard |