amo40.acteur_mandat_collaborateurs_collaborateur
Chemin acteur.mandats.mandat.collaborateurs.collaborateur · présence : L17 100 %
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 100 % · 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 100 % |
| 9 | nom | VARCHAR | acteur.mandats.mandat.collaborateurs.collaborateur.nom · présence : L17 100 % |
| 10 | date_debut | VARCHAR | acteur.mandats.mandat.collaborateurs.collaborateur.dateDebut · présence : L17 100 % |
| 11 | date_fin | VARCHAR | acteur.mandats.mandat.collaborateurs.collaborateur.dateFin · présence : L17 100 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | qualite | prenom | nom | date_debut | date_fin |
|---|---|---|---|---|---|---|---|---|---|---|
| 17040000014807 | L17/amo40 | 17 | 17040000014750 | 17040000014803 | 4 | M. | Matthieu | Maillard | ||
| 17040000014841 | L17/amo40 | 17 | 17040000014813 | 17040000014840 | 1 | M. | Dylan | Cauvin-Merrant | ||
| 17040000014842 | L17/amo40 | 17 | 17040000014813 | 17040000014840 | 2 | M. | Rémi | Scholtz | ||
| 17040000014843 | L17/amo40 | 17 | 17040000014813 | 17040000014840 | 3 | M. | Clément | Belliere | ||
| 17040000014887 | L17/amo40 | 17 | 17040000014855 | 17040000014886 | 1 | Mme | Clotilde | Guéry | ||
| 17040000014888 | L17/amo40 | 17 | 17040000014855 | 17040000014886 | 2 | M. | Charles | Rouvier | ||
| 17040000014889 | L17/amo40 | 17 | 17040000014855 | 17040000014886 | 3 | M. | Nicolas | Tavan | ||
| 17040000014890 | L17/amo40 | 17 | 17040000014855 | 17040000014886 | 4 | Mme | Olivia | Gazzano | ||
| 17040000014941 | L17/amo40 | 17 | 17040000014913 | 17040000014940 | 1 | Mme | Clothilde | Baudouin | ||
| 17040000014942 | L17/amo40 | 17 | 17040000014913 | 17040000014940 | 2 | Mme | Perrine | Tavernier | ||
| 17040000014943 | L17/amo40 | 17 | 17040000014913 | 17040000014940 | 3 | M. | Jérémy | Chossat | ||
| 17040000015037 | L17/amo40 | 17 | 17040000015028 | 17040000015036 | 1 | Mme | Manon | Bouchet | ||
| 17040000015038 | L17/amo40 | 17 | 17040000015028 | 17040000015036 | 2 | M. | David | Nascimento | ||
| 17040000015039 | L17/amo40 | 17 | 17040000015028 | 17040000015036 | 3 | Mme | Vanessa | Vottier | ||
| 17040000015093 | L17/amo40 | 17 | 17040000015061 | 17040000015092 | 1 | M. | Christian | Gérard | ||
| 17040000015094 | L17/amo40 | 17 | 17040000015061 | 17040000015092 | 2 | M. | Ange | Olibé | ||
| 17040000015137 | L17/amo40 | 17 | 17040000015097 | 17040000015136 | 1 | M. | Antonin | Bergier | ||
| 17040000015138 | L17/amo40 | 17 | 17040000015097 | 17040000015136 | 2 | M. | Loan | Cannard | ||
| 17040000015139 | L17/amo40 | 17 | 17040000015097 | 17040000015136 | 3 | Mme | Laura | Jovignot | ||
| 17040000015140 | L17/amo40 | 17 | 17040000015097 | 17040000015136 | 4 | Mme | Julie | Pasquet | ||
| 17040000015180 | L17/amo40 | 17 | 17040000015154 | 17040000015179 | 1 | M. | Yaye | Kaba | ||
| 17040000015181 | L17/amo40 | 17 | 17040000015154 | 17040000015179 | 2 | Mme | Dorine | Ramos | ||
| 17040000015182 | L17/amo40 | 17 | 17040000015154 | 17040000015179 | 3 | M. | Maxime | Munier | ||
| 17040000015266 | L17/amo40 | 17 | 17040000015212 | 17040000015265 | 1 | Mme | Alice | Lemarinel | ||
| 17040000015267 | L17/amo40 | 17 | 17040000015212 | 17040000015265 | 2 | M. | Guillaume | Bichet | ||
| 17040000015268 | L17/amo40 | 17 | 17040000015212 | 17040000015265 | 3 | M. | Olivier | Mencarelli | ||
| 17040000015269 | L17/amo40 | 17 | 17040000015212 | 17040000015265 | 4 | M. | Antoine | Toulza | ||
| 17040000015324 | L17/amo40 | 17 | 17040000015300 | 17040000015323 | 1 | M. | Julien | Cadieu | ||
| 17040000015325 | L17/amo40 | 17 | 17040000015300 | 17040000015323 | 2 | M. | Rémy | Salvador | ||
| 17040000015326 | L17/amo40 | 17 | 17040000015300 | 17040000015323 | 3 | Mme | Rania | Hattabi | ||
| 17040000015327 | L17/amo40 | 17 | 17040000015300 | 17040000015323 | 4 | Mme | Julie | Litre | ||
| 17040000015433 | L17/amo40 | 17 | 17040000015369 | 17040000015432 | 1 | Mme | Galia | Mercier | ||
| 17040000015434 | L17/amo40 | 17 | 17040000015369 | 17040000015432 | 2 | Mme | Inès | Djelida | ||
| 17040000015435 | L17/amo40 | 17 | 17040000015369 | 17040000015432 | 3 | M. | Johan | Marchand | ||
| 17040000015436 | L17/amo40 | 17 | 17040000015369 | 17040000015432 | 4 | Mme | Clara | Ould-Aklouche | ||
| 17040000015437 | L17/amo40 | 17 | 17040000015369 | 17040000015432 | 5 | M. | Rhany | Slimane Tich Tich | ||
| 17040000015495 | L17/amo40 | 17 | 17040000015444 | 17040000015494 | 1 | M. | Loïc | Muria | ||
| 17040000015496 | L17/amo40 | 17 | 17040000015444 | 17040000015494 | 2 | M. | Maxime | Neutzner | ||
| 17040000015497 | L17/amo40 | 17 | 17040000015444 | 17040000015494 | 3 | Mme | Alice | Corre | ||
| 17040000015498 | L17/amo40 | 17 | 17040000015444 | 17040000015494 | 4 | Mme | Ariane | Laude | ||
| 17040000015571 | L17/amo40 | 17 | 17040000015503 | 17040000015570 | 1 | M. | Dacruz | Baloa | ||
| 17040000015572 | L17/amo40 | 17 | 17040000015503 | 17040000015570 | 2 | Mme | Ethel | Gandia | ||
| 17040000015573 | L17/amo40 | 17 | 17040000015503 | 17040000015570 | 3 | Mme | Lux | Hervé | ||
| 17040000015627 | L17/amo40 | 17 | 17040000015578 | 17040000015626 | 1 | M. | Clément | Chicoyneau de Lavalette | ||
| 17040000015628 | L17/amo40 | 17 | 17040000015578 | 17040000015626 | 2 | Mme | Valérie | Lacabanne | ||
| 17040000015629 | L17/amo40 | 17 | 17040000015578 | 17040000015626 | 3 | M. | Franck | Barthet | ||
| 17040000015677 | L17/amo40 | 17 | 17040000015661 | 17040000015676 | 1 | M. | Sacha | Duprat | ||
| 17040000015678 | L17/amo40 | 17 | 17040000015661 | 17040000015676 | 2 | M. | Simon | Eppling | ||
| 17040000015679 | L17/amo40 | 17 | 17040000015661 | 17040000015676 | 3 | Mme | Sandrine | Le Traon | ||
| 17040000015680 | L17/amo40 | 17 | 17040000015661 | 17040000015676 | 4 | M. | Solal-Ewan | Allain |