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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17020000018948 | L17/amo20 | 17 | 17020000018897 | 17020000018946 | 2 | M. | Antoine | Barthélémy | ||
| 17020000018949 | L17/amo20 | 17 | 17020000018897 | 17020000018946 | 3 | M. | Olivier | Rioult | ||
| 17020000018983 | L17/amo20 | 17 | 17020000018950 | 17020000018982 | 1 | Mme | Eve | Brochart | ||
| 17020000018984 | L17/amo20 | 17 | 17020000018950 | 17020000018982 | 2 | Mme | Cassandra | Serier | ||
| 17020000018985 | L17/amo20 | 17 | 17020000018950 | 17020000018982 | 3 | M. | Antoine | Bourdier | ||
| 17020000018986 | L17/amo20 | 17 | 17020000018950 | 17020000018982 | 4 | M. | Aurélien | Bourneuf | ||
| 17020000018987 | L17/amo20 | 17 | 17020000018950 | 17020000018982 | 5 | Mme | Annwenn | Corouge | ||
| 17020000019044 | L17/amo20 | 17 | 17020000018988 | 17020000019043 | 1 | Mme | Pauline | Tournier | ||
| 17020000019045 | L17/amo20 | 17 | 17020000018988 | 17020000019043 | 2 | Mme | Flora | Hermet | ||
| 17020000019046 | L17/amo20 | 17 | 17020000018988 | 17020000019043 | 3 | M. | Jules | Decreus | ||
| 17020000019091 | L17/amo20 | 17 | 17020000019047 | 17020000019090 | 1 | M. | Amine | Baba-Ahmed | ||
| 17020000019092 | L17/amo20 | 17 | 17020000019047 | 17020000019090 | 2 | Mme | Sarah | Mekidiche | ||
| 17020000019093 | L17/amo20 | 17 | 17020000019047 | 17020000019090 | 3 | M. | Sofian | Ben Amor | ||
| 17020000019094 | L17/amo20 | 17 | 17020000019047 | 17020000019090 | 4 | M. | Lucas | Fabre | ||
| 17020000019109 | L17/amo20 | 17 | 17020000019095 | 17020000019108 | 1 | Mme | Anne | Leboulanger | ||
| 17020000019110 | L17/amo20 | 17 | 17020000019095 | 17020000019108 | 2 | M. | Jean-Baptiste | Coupat | ||
| 17020000019189 | L17/amo20 | 17 | 17020000019111 | 17020000019188 | 1 | M. | Jean-Marc | Toqué | ||
| 17020000019190 | L17/amo20 | 17 | 17020000019111 | 17020000019188 | 2 | Mme | Stéphanie | Laboup-Charlet | ||
| 17020000019191 | L17/amo20 | 17 | 17020000019111 | 17020000019188 | 3 | M. | Bruno | Lorand | ||
| 17020000019192 | L17/amo20 | 17 | 17020000019111 | 17020000019188 | 4 | Mme | Géraldine | Morisse | ||
| 17020000019193 | L17/amo20 | 17 | 17020000019111 | 17020000019188 | 5 | Mme | Jeanne-Noëlle | Lamour | ||
| 17020000019194 | L17/amo20 | 17 | 17020000019111 | 17020000019188 | 6 | M. | Jean-Michel | Gimard | ||
| 17020000019203 | L17/amo20 | 17 | 17020000019195 | 17020000019202 | 1 | Mme | Mathilde | Tanguy | ||
| 17020000019204 | L17/amo20 | 17 | 17020000019195 | 17020000019202 | 2 | M. | Swann | Le Guen | ||
| 17020000019278 | L17/amo20 | 17 | 17020000019205 | 17020000019277 | 1 | M. | Alexandre | Cailleteau | ||
| 17020000019279 | L17/amo20 | 17 | 17020000019205 | 17020000019277 | 2 | Mme | Morgane | Le Bars | ||
| 17020000019280 | L17/amo20 | 17 | 17020000019205 | 17020000019277 | 3 | M. | Jean | Brichet | ||
| 17020000019312 | L17/amo20 | 17 | 17020000019281 | 17020000019311 | 1 | M. | Charles | Herrbach | ||
| 17020000019313 | L17/amo20 | 17 | 17020000019281 | 17020000019311 | 2 | M. | Aymeric | Mongelous | ||
| 17020000019314 | L17/amo20 | 17 | 17020000019281 | 17020000019311 | 3 | M. | Adrien | Hoffmann | ||
| 17020000019315 | L17/amo20 | 17 | 17020000019281 | 17020000019311 | 4 | M. | Vivian | Deslandes | ||
| 17020000019330 | L17/amo20 | 17 | 17020000019316 | 17020000019329 | 1 | M. | Sylvain | Ortis | ||
| 17020000019331 | L17/amo20 | 17 | 17020000019316 | 17020000019329 | 2 | M. | Sébastien | Arzalier | ||
| 17020000019332 | L17/amo20 | 17 | 17020000019316 | 17020000019329 | 3 | Mme | Joddie | Leclerre | ||
| 17020000019402 | L17/amo20 | 17 | 17020000019333 | 17020000019401 | 1 | M. | Maxime | Torrente | ||
| 17020000019403 | L17/amo20 | 17 | 17020000019333 | 17020000019401 | 2 | Mme | Vanessa | Parent | ||
| 17020000019404 | L17/amo20 | 17 | 17020000019333 | 17020000019401 | 3 | Mme | Camille | Révolat | ||
| 17020000019405 | L17/amo20 | 17 | 17020000019333 | 17020000019401 | 4 | Mme | Aurélie | Mitteault | ||
| 17020000019442 | L17/amo20 | 17 | 17020000019406 | 17020000019441 | 1 | M. | Jacques | Ricciardetti | ||
| 17020000019443 | L17/amo20 | 17 | 17020000019406 | 17020000019441 | 2 | M. | Maxime | Callois | ||
| 17020000019444 | L17/amo20 | 17 | 17020000019406 | 17020000019441 | 3 | M. | Quentin | Déchaux | ||
| 17020000019481 | L17/amo20 | 17 | 17020000019445 | 17020000019480 | 1 | Mme | Pryscillia | Brach | ||
| 17020000019482 | L17/amo20 | 17 | 17020000019445 | 17020000019480 | 2 | Mme | Sandra | Durosau | ||
| 17020000019483 | L17/amo20 | 17 | 17020000019445 | 17020000019480 | 3 | M. | Valentin | Gaudet | ||
| 17020000019519 | L17/amo20 | 17 | 17020000019484 | 17020000019518 | 1 | Mme | Annabelle | Arson | ||
| 17020000019520 | L17/amo20 | 17 | 17020000019484 | 17020000019518 | 2 | M. | Kélian | Dupuis | ||
| 17020000019521 | L17/amo20 | 17 | 17020000019484 | 17020000019518 | 3 | M. | Jeoffrey | Goncalves | ||
| 17020000019581 | L17/amo20 | 17 | 17020000019522 | 17020000019580 | 1 | M. | Smail | Chibane | ||
| 17020000019582 | L17/amo20 | 17 | 17020000019522 | 17020000019580 | 2 | M. | Jean-Baptiste | Genard-Coudray | ||
| 17020000019583 | L17/amo20 | 17 | 17020000019522 | 17020000019580 | 3 | M. | Stanislas | Ferrari |