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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17020000019584 | L17/amo20 | 17 | 17020000019522 | 17020000019580 | 4 | M. | Matthieu | Maillard | ||
| 17020000019624 | L17/amo20 | 17 | 17020000019585 | 17020000019623 | 1 | M. | Dylan | Cauvin-Merrant | ||
| 17020000019625 | L17/amo20 | 17 | 17020000019585 | 17020000019623 | 2 | M. | Rémi | Scholtz | ||
| 17020000019626 | L17/amo20 | 17 | 17020000019585 | 17020000019623 | 3 | M. | Clément | Belliere | ||
| 17020000019681 | L17/amo20 | 17 | 17020000019627 | 17020000019680 | 1 | Mme | Clotilde | Guéry | ||
| 17020000019682 | L17/amo20 | 17 | 17020000019627 | 17020000019680 | 2 | M. | Charles | Rouvier | ||
| 17020000019683 | L17/amo20 | 17 | 17020000019627 | 17020000019680 | 3 | M. | Nicolas | Tavan | ||
| 17020000019684 | L17/amo20 | 17 | 17020000019627 | 17020000019680 | 4 | Mme | Olivia | Gazzano | ||
| 17020000019797 | L17/amo20 | 17 | 17020000019685 | 17020000019796 | 1 | Mme | Clothilde | Baudouin | ||
| 17020000019798 | L17/amo20 | 17 | 17020000019685 | 17020000019796 | 2 | Mme | Perrine | Tavernier | ||
| 17020000019799 | L17/amo20 | 17 | 17020000019685 | 17020000019796 | 3 | M. | Jérémy | Chossat | ||
| 17020000019830 | L17/amo20 | 17 | 17020000019800 | 17020000019829 | 1 | Mme | Manon | Bouchet | ||
| 17020000019831 | L17/amo20 | 17 | 17020000019800 | 17020000019829 | 2 | M. | David | Nascimento | ||
| 17020000019832 | L17/amo20 | 17 | 17020000019800 | 17020000019829 | 3 | Mme | Vanessa | Vottier | ||
| 17020000019867 | L17/amo20 | 17 | 17020000019833 | 17020000019866 | 1 | M. | Christian | Gérard | ||
| 17020000019868 | L17/amo20 | 17 | 17020000019833 | 17020000019866 | 2 | M. | Ange | Olibé | ||
| 17020000019922 | L17/amo20 | 17 | 17020000019869 | 17020000019921 | 1 | M. | Antonin | Bergier | ||
| 17020000019923 | L17/amo20 | 17 | 17020000019869 | 17020000019921 | 2 | M. | Loan | Cannard | ||
| 17020000019924 | L17/amo20 | 17 | 17020000019869 | 17020000019921 | 3 | Mme | Laura | Jovignot | ||
| 17020000019925 | L17/amo20 | 17 | 17020000019869 | 17020000019921 | 4 | Mme | Julie | Pasquet | ||
| 17020000019981 | L17/amo20 | 17 | 17020000019926 | 17020000019980 | 1 | M. | Yaye | Kaba | ||
| 17020000019982 | L17/amo20 | 17 | 17020000019926 | 17020000019980 | 2 | Mme | Dorine | Ramos | ||
| 17020000019983 | L17/amo20 | 17 | 17020000019926 | 17020000019980 | 3 | M. | Maxime | Munier | ||
| 17020000020068 | L17/amo20 | 17 | 17020000019984 | 17020000020067 | 1 | Mme | Alice | Lemarinel | ||
| 17020000020069 | L17/amo20 | 17 | 17020000019984 | 17020000020067 | 2 | M. | Guillaume | Bichet | ||
| 17020000020070 | L17/amo20 | 17 | 17020000019984 | 17020000020067 | 3 | M. | Olivier | Mencarelli | ||
| 17020000020071 | L17/amo20 | 17 | 17020000019984 | 17020000020067 | 4 | M. | Antoine | Toulza | ||
| 17020000020137 | L17/amo20 | 17 | 17020000020072 | 17020000020136 | 1 | M. | Julien | Cadieu | ||
| 17020000020138 | L17/amo20 | 17 | 17020000020072 | 17020000020136 | 2 | M. | Rémy | Salvador | ||
| 17020000020139 | L17/amo20 | 17 | 17020000020072 | 17020000020136 | 3 | Mme | Rania | Hattabi | ||
| 17020000020140 | L17/amo20 | 17 | 17020000020072 | 17020000020136 | 4 | Mme | Julie | Litre | ||
| 17020000020211 | L17/amo20 | 17 | 17020000020141 | 17020000020210 | 1 | Mme | Galia | Mercier | ||
| 17020000020212 | L17/amo20 | 17 | 17020000020141 | 17020000020210 | 2 | Mme | Inès | Djelida | ||
| 17020000020213 | L17/amo20 | 17 | 17020000020141 | 17020000020210 | 3 | M. | Johan | Marchand | ||
| 17020000020214 | L17/amo20 | 17 | 17020000020141 | 17020000020210 | 4 | Mme | Clara | Ould-Aklouche | ||
| 17020000020215 | L17/amo20 | 17 | 17020000020141 | 17020000020210 | 5 | M. | Rhany | Slimane Tich Tich | ||
| 17020000020271 | L17/amo20 | 17 | 17020000020216 | 17020000020270 | 1 | M. | Loïc | Muria | ||
| 17020000020272 | L17/amo20 | 17 | 17020000020216 | 17020000020270 | 2 | M. | Maxime | Neutzner | ||
| 17020000020273 | L17/amo20 | 17 | 17020000020216 | 17020000020270 | 3 | Mme | Alice | Corre | ||
| 17020000020274 | L17/amo20 | 17 | 17020000020216 | 17020000020270 | 4 | Mme | Ariane | Laude | ||
| 17020000020347 | L17/amo20 | 17 | 17020000020275 | 17020000020346 | 1 | M. | Dacruz | Baloa | ||
| 17020000020348 | L17/amo20 | 17 | 17020000020275 | 17020000020346 | 2 | Mme | Ethel | Gandia | ||
| 17020000020349 | L17/amo20 | 17 | 17020000020275 | 17020000020346 | 3 | Mme | Lux | Hervé | ||
| 17020000020438 | L17/amo20 | 17 | 17020000020358 | 17020000020437 | 1 | M. | Clément | Chicoyneau de Lavalette | ||
| 17020000020439 | L17/amo20 | 17 | 17020000020358 | 17020000020437 | 2 | Mme | Valérie | Lacabanne | ||
| 17020000020440 | L17/amo20 | 17 | 17020000020358 | 17020000020437 | 3 | M. | Franck | Barthet | ||
| 17020000020500 | L17/amo20 | 17 | 17020000020441 | 17020000020499 | 1 | M. | Sacha | Duprat | ||
| 17020000020501 | L17/amo20 | 17 | 17020000020441 | 17020000020499 | 2 | M. | Simon | Eppling | ||
| 17020000020502 | L17/amo20 | 17 | 17020000020441 | 17020000020499 | 3 | Mme | Sandrine | Le Traon | ||
| 17020000020503 | L17/amo20 | 17 | 17020000020441 | 17020000020499 | 4 | M. | Solal-Ewan | Allain |