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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17030000066909 | L17/amo30 | 17 | 17030000066481 | 17030000066906 | 3 | M. | Denis | Vincent | ||
| 17030000066910 | L17/amo30 | 17 | 17030000066481 | 17030000066906 | 4 | Mme | Inès | Jacques | ||
| 17030000066911 | L17/amo30 | 17 | 17030000066481 | 17030000066906 | 5 | Mme | Faustine | Ruchaud | ||
| 17030000067611 | L17/amo30 | 17 | 17030000067426 | 17030000067610 | 1 | M. | Sébastien | Giard | ||
| 17030000067612 | L17/amo30 | 17 | 17030000067426 | 17030000067610 | 2 | Mme | Angela | Héranval | ||
| 17030000067613 | L17/amo30 | 17 | 17030000067426 | 17030000067610 | 3 | Mme | Marine | Beaurain | ||
| 17030000067891 | L17/amo30 | 17 | 17030000067741 | 17030000067890 | 1 | M. | Mathieu | Havsali | ||
| 17030000067892 | L17/amo30 | 17 | 17030000067741 | 17030000067890 | 2 | Mme | Edith | Lecherbonnier | ||
| 17030000067893 | L17/amo30 | 17 | 17030000067741 | 17030000067890 | 3 | M. | Yoann | Balestrat | ||
| 17030000069829 | L17/amo30 | 17 | 17030000069707 | 17030000069828 | 1 | M. | Théo | Durand-Tortorella | ||
| 17030000069830 | L17/amo30 | 17 | 17030000069707 | 17030000069828 | 2 | Mme | Mylène | Coste | ||
| 17030000069831 | L17/amo30 | 17 | 17030000069707 | 17030000069828 | 3 | M. | Riwan | Yahmi | ||
| 17030000070508 | L17/amo30 | 17 | 17030000070416 | 17030000070507 | 1 | M. | Ludovic | Germain | ||
| 17030000070509 | L17/amo30 | 17 | 17030000070416 | 17030000070507 | 2 | Mme | Jeanne | Bardoux | ||
| 17030000070510 | L17/amo30 | 17 | 17030000070416 | 17030000070507 | 3 | M. | Gabriel | Troude--Beherégaray | ||
| 17030000070511 | L17/amo30 | 17 | 17030000070416 | 17030000070507 | 4 | Mme | Carla | Kopp | ||
| 17030000070610 | L17/amo30 | 17 | 17030000070519 | 17030000070609 | 1 | Mme | Delphine | Rolland | ||
| 17030000070611 | L17/amo30 | 17 | 17030000070519 | 17030000070609 | 2 | M. | Julien | Cahu | ||
| 17030000070612 | L17/amo30 | 17 | 17030000070519 | 17030000070609 | 3 | M. | Jérôme | Petit | ||
| 17030000070666 | L17/amo30 | 17 | 17030000070613 | 17030000070665 | 1 | Mme | Stéphanie | Botcazou | ||
| 17030000070667 | L17/amo30 | 17 | 17030000070613 | 17030000070665 | 2 | Mme | Tania | Carré | ||
| 17030000070668 | L17/amo30 | 17 | 17030000070613 | 17030000070665 | 3 | Mme | Sophie | Paillard | ||
| 17030000070759 | L17/amo30 | 17 | 17030000070692 | 17030000070758 | 1 | Mme | Sarah | Meyssonnier | ||
| 17030000070760 | L17/amo30 | 17 | 17030000070692 | 17030000070758 | 2 | Mme | Myriam | Lejmi | ||
| 17030000070761 | L17/amo30 | 17 | 17030000070692 | 17030000070758 | 3 | M. | Albin | Dubanchet | ||
| 17030000070762 | L17/amo30 | 17 | 17030000070692 | 17030000070758 | 4 | Mme | Solène | Del'Homme | ||
| 17030000071095 | L17/amo30 | 17 | 17030000070763 | 17030000071094 | 1 | M. | Adrian | Raffin | ||
| 17030000071096 | L17/amo30 | 17 | 17030000070763 | 17030000071094 | 2 | Mme | Nathalie | Gritti-Rival | ||
| 17030000071097 | L17/amo30 | 17 | 17030000070763 | 17030000071094 | 3 | M. | Alexandre | Leclercq | ||
| 17030000071098 | L17/amo30 | 17 | 17030000070763 | 17030000071094 | 4 | M. | Natan | Pillot | ||
| 17030000071099 | L17/amo30 | 17 | 17030000070763 | 17030000071094 | 5 | Mme | Anaïs | Poncet | ||
| 17030000072468 | L17/amo30 | 17 | 17030000072188 | 17030000072467 | 1 | Mme | Eve-Marie | Ganczarczyk | ||
| 17030000072469 | L17/amo30 | 17 | 17030000072188 | 17030000072467 | 2 | M. | Ludger | Adnot | ||
| 17030000073291 | L17/amo30 | 17 | 17030000073227 | 17030000073290 | 1 | M. | Pierre | Baillou | ||
| 17030000073292 | L17/amo30 | 17 | 17030000073227 | 17030000073290 | 2 | Mme | Sabine | Rozier-Deroche | ||
| 17030000073293 | L17/amo30 | 17 | 17030000073227 | 17030000073290 | 3 | Mme | Roxane | Beguet | ||
| 17030000073294 | L17/amo30 | 17 | 17030000073227 | 17030000073290 | 4 | M. | Dimitri | Ferrand | ||
| 17030000073295 | L17/amo30 | 17 | 17030000073227 | 17030000073290 | 5 | M. | Vincent | Delorme | ||
| 17030000073296 | L17/amo30 | 17 | 17030000073227 | 17030000073290 | 6 | M. | Eric | Cesari | ||
| 17030000074029 | L17/amo30 | 17 | 17030000074007 | 17030000074028 | 1 | M. | Guillaume | Lamidon | ||
| 17030000074030 | L17/amo30 | 17 | 17030000074007 | 17030000074028 | 2 | Mme | Lisa | Berdah | ||
| 17030000074031 | L17/amo30 | 17 | 17030000074007 | 17030000074028 | 3 | M. | Timothé | Gagnard | ||
| 17030000081319 | L17/amo30 | 17 | 17030000081236 | 17030000081318 | 1 | Mme | Julie | Capo Ortega | ||
| 17030000081320 | L17/amo30 | 17 | 17030000081236 | 17030000081318 | 2 | Mme | Catherine | Jacob | ||
| 17030000081321 | L17/amo30 | 17 | 17030000081236 | 17030000081318 | 3 | Mme | Geneviève | Parmentier | ||
| 17030000081322 | L17/amo30 | 17 | 17030000081236 | 17030000081318 | 4 | M. | Christian | Victor | ||
| 17030000081563 | L17/amo30 | 17 | 17030000081467 | 17030000081562 | 1 | M. | Julien | Auffret | ||
| 17030000081564 | L17/amo30 | 17 | 17030000081467 | 17030000081562 | 2 | M. | Rodrigue | Elichondoborde | ||
| 17030000081565 | L17/amo30 | 17 | 17030000081467 | 17030000081562 | 3 | Mme | Chloé | Linard | ||
| 17030000081566 | L17/amo30 | 17 | 17030000081467 | 17030000081562 | 4 | Mme | Emma | Bernard |