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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17030000164288 | L17/amo30 | 17 | 17030000164161 | 17030000164286 | 2 | Mme | Huguette | Dies | ||
| 17030000164289 | L17/amo30 | 17 | 17030000164161 | 17030000164286 | 3 | Mme | Yaël | Nahon | ||
| 17030000164290 | L17/amo30 | 17 | 17030000164161 | 17030000164286 | 4 | M. | Valentin | Farines | ||
| 17030000164400 | L17/amo30 | 17 | 17030000164291 | 17030000164399 | 1 | Mme | Rania | Elias | ||
| 17030000164401 | L17/amo30 | 17 | 17030000164291 | 17030000164399 | 2 | M. | Louis | Mompeu | ||
| 17030000164402 | L17/amo30 | 17 | 17030000164291 | 17030000164399 | 3 | M. | Gaël | Jaouën | ||
| 17030000164403 | L17/amo30 | 17 | 17030000164291 | 17030000164399 | 4 | Mme | Christine | François-Guichard | ||
| 17030000164404 | L17/amo30 | 17 | 17030000164291 | 17030000164399 | 5 | M. | Alexandre | Durand-Gomez | ||
| 17030000164549 | L17/amo30 | 17 | 17030000164405 | 17030000164548 | 1 | M. | Alexis | David | ||
| 17030000164550 | L17/amo30 | 17 | 17030000164405 | 17030000164548 | 2 | Mme | Eva | Suarez | ||
| 17030000164551 | L17/amo30 | 17 | 17030000164405 | 17030000164548 | 3 | M. | Samir | Asselot | ||
| 17030000164552 | L17/amo30 | 17 | 17030000164405 | 17030000164548 | 4 | Mme | Lorella | Fili | ||
| 17030000164553 | L17/amo30 | 17 | 17030000164405 | 17030000164548 | 5 | M. | Julien | Prissette | ||
| 17030000164717 | L17/amo30 | 17 | 17030000164657 | 17030000164716 | 1 | Mme | Gaëlle | Fabriguet | ||
| 17030000164718 | L17/amo30 | 17 | 17030000164657 | 17030000164716 | 2 | M. | Allan | Brunon | ||
| 17030000164775 | L17/amo30 | 17 | 17030000164719 | 17030000164774 | 1 | M. | Antoni | Magnin | ||
| 17030000164776 | L17/amo30 | 17 | 17030000164719 | 17030000164774 | 2 | M. | Dimitru | Cazacu | ||
| 17030000164777 | L17/amo30 | 17 | 17030000164719 | 17030000164774 | 3 | M. | Brice | Malagoli | ||
| 17030000164778 | L17/amo30 | 17 | 17030000164719 | 17030000164774 | 4 | M. | Cédric | Occhipinti | ||
| 17030000164879 | L17/amo30 | 17 | 17030000164780 | 17030000164878 | 1 | M. | Steven | Fasquelle | ||
| 17030000164880 | L17/amo30 | 17 | 17030000164780 | 17030000164878 | 2 | M. | Fabio | Vasconcelos | ||
| 17030000164881 | L17/amo30 | 17 | 17030000164780 | 17030000164878 | 3 | Mme | Nathalie | Fritsch | ||
| 17030000164882 | L17/amo30 | 17 | 17030000164780 | 17030000164878 | 4 | Mme | Céline | Pennelle | ||
| 17030000165031 | L17/amo30 | 17 | 17030000164919 | 17030000165030 | 1 | Mme | Manon | Kayat | ||
| 17030000165032 | L17/amo30 | 17 | 17030000164919 | 17030000165030 | 2 | Mme | Ingrid | Fusil | ||
| 17030000165033 | L17/amo30 | 17 | 17030000164919 | 17030000165030 | 3 | M. | Luca | Fournier | ||
| 17030000165107 | L17/amo30 | 17 | 17030000165034 | 17030000165106 | 1 | Mme | Nathalie | Hadj-Saïd | ||
| 17030000165108 | L17/amo30 | 17 | 17030000165034 | 17030000165106 | 2 | M. | Kerrien | Piquant | ||
| 17030000165109 | L17/amo30 | 17 | 17030000165034 | 17030000165106 | 3 | M. | Rémi | Berne | ||
| 17030000165110 | L17/amo30 | 17 | 17030000165034 | 17030000165106 | 4 | M. | Emmanuel | Fourdrigniez | ||
| 17030000165111 | L17/amo30 | 17 | 17030000165034 | 17030000165106 | 5 | M. | Adrien | Cornut-Gentille | ||
| 17030000165112 | L17/amo30 | 17 | 17030000165034 | 17030000165106 | 6 | M. | Loan | Deschamps | ||
| 17030000165113 | L17/amo30 | 17 | 17030000165034 | 17030000165106 | 7 | M. | Raphaël | Toupin | ||
| 17030000165213 | L17/amo30 | 17 | 17030000165115 | 17030000165212 | 1 | Mme | Anne-Lise | Meurier | ||
| 17030000165214 | L17/amo30 | 17 | 17030000165115 | 17030000165212 | 2 | M. | Arthur | Raynal | ||
| 17030000165327 | L17/amo30 | 17 | 17030000165215 | 17030000165326 | 1 | Mme | Elsa | Favre-Rochex Jacquier | ||
| 17030000165328 | L17/amo30 | 17 | 17030000165215 | 17030000165326 | 2 | Mme | Maud | Perrot | ||
| 17030000165473 | L17/amo30 | 17 | 17030000165330 | 17030000165472 | 1 | Mme | Aline | Lévêque | ||
| 17030000165474 | L17/amo30 | 17 | 17030000165330 | 17030000165472 | 2 | Mme | Julie | Piton Saint-Martin | ||
| 17030000165475 | L17/amo30 | 17 | 17030000165330 | 17030000165472 | 3 | M. | Sébastien | Léopold | ||
| 17030000165735 | L17/amo30 | 17 | 17030000165623 | 17030000165734 | 1 | M. | Théo | Garcia | ||
| 17030000165736 | L17/amo30 | 17 | 17030000165623 | 17030000165734 | 2 | M. | Martin | Hilsum | ||
| 17030000165737 | L17/amo30 | 17 | 17030000165623 | 17030000165734 | 3 | M. | William | Doré | ||
| 17030000165809 | L17/amo30 | 17 | 17030000165738 | 17030000165808 | 1 | Mme | Nathalie | Laville | ||
| 17030000165810 | L17/amo30 | 17 | 17030000165738 | 17030000165808 | 2 | M. | Benjamin | Sbriglio | ||
| 17030000165811 | L17/amo30 | 17 | 17030000165738 | 17030000165808 | 3 | M. | Léon | Laprun | ||
| 17030000165959 | L17/amo30 | 17 | 17030000165812 | 17030000165958 | 1 | Mme | Mathilde | Gaillat | ||
| 17030000165960 | L17/amo30 | 17 | 17030000165812 | 17030000165958 | 2 | Mme | Clara | Avenant | ||
| 17030000165961 | L17/amo30 | 17 | 17030000165812 | 17030000165958 | 3 | M. | Pascal | Dupuis | ||
| 17030000165962 | L17/amo30 | 17 | 17030000165812 | 17030000165958 | 4 | Mme | Carla | Paillès |