amo10.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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17010000014335 | L17/amo10 | 17 | 17010000014239 | 17010000014332 | 3 | M. | Fabio | Rodrigues Martins | ||
| 17010000014360 | L17/amo10 | 17 | 17010000014336 | 17010000014359 | 1 | M. | Luca | Bachi | ||
| 17010000014361 | L17/amo10 | 17 | 17010000014336 | 17010000014359 | 2 | Mme | Vanessa | Jimenez | ||
| 17010000014362 | L17/amo10 | 17 | 17010000014336 | 17010000014359 | 3 | M. | Néil | Duggan | ||
| 17010000014375 | L17/amo10 | 17 | 17010000014363 | 17010000014374 | 1 | M. | Stanislas | Paute | ||
| 17010000014376 | L17/amo10 | 17 | 17010000014363 | 17010000014374 | 2 | Mme | Blandine | de Vitton de Peyruis | ||
| 17010000014403 | L17/amo10 | 17 | 17010000014377 | 17010000014402 | 1 | Mme | Audrey | Haranger | ||
| 17010000014404 | L17/amo10 | 17 | 17010000014377 | 17010000014402 | 2 | M. | Baptiste | Walter | ||
| 17010000014405 | L17/amo10 | 17 | 17010000014377 | 17010000014402 | 3 | Mme | Jade | Beaurain | ||
| 17010000014431 | L17/amo10 | 17 | 17010000014406 | 17010000014430 | 1 | Mme | Christine | Lacoste | ||
| 17010000014432 | L17/amo10 | 17 | 17010000014406 | 17010000014430 | 2 | M. | Lucas | Estagnasié | ||
| 17010000014433 | L17/amo10 | 17 | 17010000014406 | 17010000014430 | 3 | Mme | Héloïse | Nocera | ||
| 17010000014459 | L17/amo10 | 17 | 17010000014434 | 17010000014458 | 1 | M. | Pacifique | Robineau | ||
| 17010000014460 | L17/amo10 | 17 | 17010000014434 | 17010000014458 | 2 | Mme | Claire | Lejeune | ||
| 17010000014461 | L17/amo10 | 17 | 17010000014434 | 17010000014458 | 3 | Mme | Eve | Jobard | ||
| 17010000014522 | L17/amo10 | 17 | 17010000014462 | 17010000014521 | 1 | M. | Gauthier | Willem | ||
| 17010000014523 | L17/amo10 | 17 | 17010000014462 | 17010000014521 | 2 | Mme | Nathalie | Werquin | ||
| 17010000014524 | L17/amo10 | 17 | 17010000014462 | 17010000014521 | 3 | M. | Christophe | Versini | ||
| 17010000014550 | L17/amo10 | 17 | 17010000014525 | 17010000014549 | 1 | Mme | Marie | Marteau | ||
| 17010000014551 | L17/amo10 | 17 | 17010000014525 | 17010000014549 | 2 | M. | Victor | Chomard | ||
| 17010000014575 | L17/amo10 | 17 | 17010000014552 | 17010000014574 | 1 | Mme | Annabelle | Huet | ||
| 17010000014576 | L17/amo10 | 17 | 17010000014552 | 17010000014574 | 2 | M. | Arthur | Courant | ||
| 17010000014577 | L17/amo10 | 17 | 17010000014552 | 17010000014574 | 3 | M. | Elie | Colsenet | ||
| 17010000014578 | L17/amo10 | 17 | 17010000014552 | 17010000014574 | 4 | M. | Alban | Mathon | ||
| 17010000014579 | L17/amo10 | 17 | 17010000014552 | 17010000014574 | 5 | M. | Alexandre | Charbonnel-Cardoso | ||
| 17010000014636 | L17/amo10 | 17 | 17010000014580 | 17010000014635 | 1 | Mme | Aurélie | Hoareau | ||
| 17010000014637 | L17/amo10 | 17 | 17010000014580 | 17010000014635 | 2 | M. | Fabrice | Grondin | ||
| 17010000014638 | L17/amo10 | 17 | 17010000014580 | 17010000014635 | 3 | M. | Olivier | Richauvet | ||
| 17010000014639 | L17/amo10 | 17 | 17010000014580 | 17010000014635 | 4 | M. | Lucas | Pothin | ||
| 17010000014640 | L17/amo10 | 17 | 17010000014580 | 17010000014635 | 5 | Mme | Aude | Payet | ||
| 17010000014661 | L17/amo10 | 17 | 17010000014641 | 17010000014660 | 1 | M. | Frédéric | Rousseau | ||
| 17010000014662 | L17/amo10 | 17 | 17010000014641 | 17010000014660 | 2 | Mme | Marie Dominique | Thionville | ||
| 17010000014663 | L17/amo10 | 17 | 17010000014641 | 17010000014660 | 3 | Mme | Isabelle | Cerveaux | ||
| 17010000014664 | L17/amo10 | 17 | 17010000014641 | 17010000014660 | 4 | Mme | Juliana | Hibon | ||
| 17010000014688 | L17/amo10 | 17 | 17010000014665 | 17010000014687 | 1 | Mme | Elyse | Lethuillier | ||
| 17010000014689 | L17/amo10 | 17 | 17010000014665 | 17010000014687 | 2 | Mme | Elena | Hourdin--Solovieff | ||
| 17010000014690 | L17/amo10 | 17 | 17010000014665 | 17010000014687 | 3 | Mme | Mathilde | Bockoltz | ||
| 17010000014708 | L17/amo10 | 17 | 17010000014691 | 17010000014707 | 1 | M. | Jules | Sornay | ||
| 17010000014709 | L17/amo10 | 17 | 17010000014691 | 17010000014707 | 2 | M. | Pierre | Boué | ||
| 17010000014735 | L17/amo10 | 17 | 17010000014710 | 17010000014734 | 1 | Mme | Melody | De Witte | ||
| 17010000014736 | L17/amo10 | 17 | 17010000014710 | 17010000014734 | 2 | M. | Thomas | Molina | ||
| 17010000014764 | L17/amo10 | 17 | 17010000014737 | 17010000014763 | 1 | M. | Gilles | Baldacchino | ||
| 17010000014765 | L17/amo10 | 17 | 17010000014737 | 17010000014763 | 2 | M. | Paul | Laurent | ||
| 17010000014766 | L17/amo10 | 17 | 17010000014737 | 17010000014763 | 3 | M. | Thierry | Casanova | ||
| 17010000014796 | L17/amo10 | 17 | 17010000014767 | 17010000014795 | 1 | M. | Antoine | Barthélemy | ||
| 17010000014797 | L17/amo10 | 17 | 17010000014767 | 17010000014795 | 2 | M. | Fabien | Semat | ||
| 17010000014798 | L17/amo10 | 17 | 17010000014767 | 17010000014795 | 3 | Mme | Alexandra | Mereu | ||
| 17010000014799 | L17/amo10 | 17 | 17010000014767 | 17010000014795 | 4 | M. | François | Cantepe | ||
| 17010000014800 | L17/amo10 | 17 | 17010000014767 | 17010000014795 | 5 | M. | Louis | Bérerd | ||
| 17010000014831 | L17/amo10 | 17 | 17010000014801 | 17010000014830 | 1 | Mme | Sophie | Perchellet |