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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17030000162731 | L17/amo30 | 17 | 17030000162675 | 17030000162728 | 3 | Mme | Agnès | Cluzy | ||
| 17030000162732 | L17/amo30 | 17 | 17030000162675 | 17030000162728 | 4 | M. | Benoît | Pidou | ||
| 17030000162796 | L17/amo30 | 17 | 17030000162733 | 17030000162795 | 1 | Mme | Magalie | Cozette | ||
| 17030000162797 | L17/amo30 | 17 | 17030000162733 | 17030000162795 | 2 | M. | Henryk | Strozyk | ||
| 17030000162798 | L17/amo30 | 17 | 17030000162733 | 17030000162795 | 3 | M. | Thomas | Dambron | ||
| 17030000162799 | L17/amo30 | 17 | 17030000162733 | 17030000162795 | 4 | Mme | Dorothée | Maillioux | ||
| 17030000162800 | L17/amo30 | 17 | 17030000162733 | 17030000162795 | 5 | M. | Thomas | Blondel | ||
| 17030000162923 | L17/amo30 | 17 | 17030000162801 | 17030000162922 | 1 | Mme | Annick | Sézille | ||
| 17030000162924 | L17/amo30 | 17 | 17030000162801 | 17030000162922 | 2 | M. | Yannick | Lozac'h de Cordoue-Hecquard | ||
| 17030000162944 | L17/amo30 | 17 | 17030000162925 | 17030000162943 | 1 | Mme | Clémentine | Verron | ||
| 17030000162945 | L17/amo30 | 17 | 17030000162925 | 17030000162943 | 2 | Mme | Annie | Cote | ||
| 17030000162946 | L17/amo30 | 17 | 17030000162925 | 17030000162943 | 3 | Mme | Amandine | Ferrand | ||
| 17030000162947 | L17/amo30 | 17 | 17030000162925 | 17030000162943 | 4 | M. | Edward | Vandevyvere | ||
| 17030000162997 | L17/amo30 | 17 | 17030000162949 | 17030000162996 | 1 | Mme | Elisabeth | Miffre | ||
| 17030000162998 | L17/amo30 | 17 | 17030000162949 | 17030000162996 | 2 | Mme | Bénédicte | Le Blond de Mancier | ||
| 17030000162999 | L17/amo30 | 17 | 17030000162949 | 17030000162996 | 3 | M. | Paul | Miffre | ||
| 17030000163046 | L17/amo30 | 17 | 17030000163000 | 17030000163045 | 1 | Mme | Laura | Chretien | ||
| 17030000163047 | L17/amo30 | 17 | 17030000163000 | 17030000163045 | 2 | M. | Maxime | Martinaggi | ||
| 17030000163048 | L17/amo30 | 17 | 17030000163000 | 17030000163045 | 3 | M. | Jérôme | Lagoutte | ||
| 17030000163187 | L17/amo30 | 17 | 17030000163049 | 17030000163186 | 1 | M. | Lucas | Leloup | ||
| 17030000163188 | L17/amo30 | 17 | 17030000163049 | 17030000163186 | 2 | M. | Clovis | Daguerre | ||
| 17030000163189 | L17/amo30 | 17 | 17030000163049 | 17030000163186 | 3 | M. | Thomas | Heap | ||
| 17030000163296 | L17/amo30 | 17 | 17030000163190 | 17030000163295 | 1 | M. | Stefano | Wolff | ||
| 17030000163297 | L17/amo30 | 17 | 17030000163190 | 17030000163295 | 2 | M. | Léo | Delahaye | ||
| 17030000163298 | L17/amo30 | 17 | 17030000163190 | 17030000163295 | 3 | Mme | Lisa | Farault | ||
| 17030000163299 | L17/amo30 | 17 | 17030000163190 | 17030000163295 | 4 | Mme | Mariette | Leprince | ||
| 17030000163371 | L17/amo30 | 17 | 17030000163300 | 17030000163370 | 1 | M. | Nicolas | Quenouille | ||
| 17030000163372 | L17/amo30 | 17 | 17030000163300 | 17030000163370 | 2 | Mme | Khadija | Chatouani | ||
| 17030000163373 | L17/amo30 | 17 | 17030000163300 | 17030000163370 | 3 | Mme | Alice | Christiaens | ||
| 17030000163486 | L17/amo30 | 17 | 17030000163374 | 17030000163485 | 1 | Mme | Nadège | Heiligenstein | ||
| 17030000163487 | L17/amo30 | 17 | 17030000163374 | 17030000163485 | 2 | M. | Louis | Reboul | ||
| 17030000163488 | L17/amo30 | 17 | 17030000163374 | 17030000163485 | 3 | Mme | Eva | Stein | ||
| 17030000163582 | L17/amo30 | 17 | 17030000163489 | 17030000163581 | 1 | Mme | Djamila | Salifou Panga | ||
| 17030000163583 | L17/amo30 | 17 | 17030000163489 | 17030000163581 | 2 | Mme | Pauline | Pagès | ||
| 17030000163584 | L17/amo30 | 17 | 17030000163489 | 17030000163581 | 3 | M. | Simon | Tharreau-Le Tourneux de la Perraudière | ||
| 17030000163585 | L17/amo30 | 17 | 17030000163489 | 17030000163581 | 4 | Mme | Emma | Dagorne | ||
| 17030000163739 | L17/amo30 | 17 | 17030000163612 | 17030000163738 | 1 | Mme | Mathilde | Thuet | ||
| 17030000163740 | L17/amo30 | 17 | 17030000163612 | 17030000163738 | 2 | Mme | Albertine | Ferreira | ||
| 17030000163741 | L17/amo30 | 17 | 17030000163612 | 17030000163738 | 3 | M. | Hugo | Caspard | ||
| 17030000163742 | L17/amo30 | 17 | 17030000163612 | 17030000163738 | 4 | Mme | Justine | Zimmermann | ||
| 17030000163855 | L17/amo30 | 17 | 17030000163743 | 17030000163854 | 1 | Mme | Camille | Blenner | ||
| 17030000163856 | L17/amo30 | 17 | 17030000163743 | 17030000163854 | 2 | M. | Luc | Lehner | ||
| 17030000163857 | L17/amo30 | 17 | 17030000163743 | 17030000163854 | 3 | Mme | Berthe | Muller | ||
| 17030000164026 | L17/amo30 | 17 | 17030000163911 | 17030000164025 | 1 | Mme | Emma | Briand-Paléologos | ||
| 17030000164027 | L17/amo30 | 17 | 17030000163911 | 17030000164025 | 2 | Mme | Emmanuelle | Caravera | ||
| 17030000164028 | L17/amo30 | 17 | 17030000163911 | 17030000164025 | 3 | M. | Louis | Labaigt | ||
| 17030000164112 | L17/amo30 | 17 | 17030000164029 | 17030000164111 | 1 | Mme | Wissal | El Jarrari | ||
| 17030000164113 | L17/amo30 | 17 | 17030000164029 | 17030000164111 | 2 | Mme | Aurélie | Lecointre | ||
| 17030000164114 | L17/amo30 | 17 | 17030000164029 | 17030000164111 | 3 | Mme | Marion | Perez | ||
| 17030000164287 | L17/amo30 | 17 | 17030000164161 | 17030000164286 | 1 | M. | Xavier | Baudry |