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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17010000000471 | L17/amo10 | 17 | 17010000000458 | 17010000000468 | 3 | Mme | Angélique | Gapilian | ||
| 17010000000472 | L17/amo10 | 17 | 17010000000458 | 17010000000468 | 4 | M. | Louis | Denquin | ||
| 17010000000536 | L17/amo10 | 17 | 17010000000473 | 17010000000535 | 1 | M. | Johnny | Villion | ||
| 17010000000537 | L17/amo10 | 17 | 17010000000473 | 17010000000535 | 2 | Mme | Clémence | Fort | ||
| 17010000000591 | L17/amo10 | 17 | 17010000000538 | 17010000000590 | 1 | M. | Frank | Mezzasoma | ||
| 17010000000592 | L17/amo10 | 17 | 17010000000538 | 17010000000590 | 2 | M. | Rémi | Blardone | ||
| 17010000000593 | L17/amo10 | 17 | 17010000000538 | 17010000000590 | 3 | M. | David | Avaliani | ||
| 17010000000594 | L17/amo10 | 17 | 17010000000538 | 17010000000590 | 4 | M. | Romain | Aidaoui | ||
| 17010000000595 | L17/amo10 | 17 | 17010000000538 | 17010000000590 | 5 | M. | Kamel | Rezagui | ||
| 17010000000623 | L17/amo10 | 17 | 17010000000596 | 17010000000622 | 1 | Mme | Manon | Silvant | ||
| 17010000000624 | L17/amo10 | 17 | 17010000000596 | 17010000000622 | 2 | M. | Nathan | Sourisseau | ||
| 17010000000625 | L17/amo10 | 17 | 17010000000596 | 17010000000622 | 3 | M. | Kylan | Semenzin | ||
| 17010000000626 | L17/amo10 | 17 | 17010000000596 | 17010000000622 | 4 | M. | Erwan | Ferry | ||
| 17010000000627 | L17/amo10 | 17 | 17010000000596 | 17010000000622 | 5 | M. | Anthony | Poulin | ||
| 17010000000628 | L17/amo10 | 17 | 17010000000596 | 17010000000622 | 6 | Mme | Claire | Mallard | ||
| 17010000000662 | L17/amo10 | 17 | 17010000000629 | 17010000000661 | 1 | Mme | Anne | Dumay | ||
| 17010000000663 | L17/amo10 | 17 | 17010000000629 | 17010000000661 | 2 | Mme | Monique | Dujeancourt | ||
| 17010000000664 | L17/amo10 | 17 | 17010000000629 | 17010000000661 | 3 | Mme | Caroline | Quiène | ||
| 17010000000665 | L17/amo10 | 17 | 17010000000629 | 17010000000661 | 4 | Mme | Delphine | Champagne | ||
| 17010000000666 | L17/amo10 | 17 | 17010000000629 | 17010000000661 | 5 | M. | Abel | Beltrame | ||
| 17010000000710 | L17/amo10 | 17 | 17010000000667 | 17010000000709 | 1 | Mme | Virginie | Le Garec | ||
| 17010000000711 | L17/amo10 | 17 | 17010000000667 | 17010000000709 | 2 | M. | Matéo | Vayssié | ||
| 17010000000712 | L17/amo10 | 17 | 17010000000667 | 17010000000709 | 3 | M. | Charles | Guemas | ||
| 17010000000713 | L17/amo10 | 17 | 17010000000667 | 17010000000709 | 4 | M. | Nolan | Genty | ||
| 17010000000770 | L17/amo10 | 17 | 17010000000714 | 17010000000769 | 1 | M. | Jean-Luc | Orset | ||
| 17010000000771 | L17/amo10 | 17 | 17010000000714 | 17010000000769 | 2 | Mme | Christelle | Demoustier | ||
| 17010000000772 | L17/amo10 | 17 | 17010000000714 | 17010000000769 | 3 | M. | Alexis | Morand | ||
| 17010000000773 | L17/amo10 | 17 | 17010000000714 | 17010000000769 | 4 | Mme | Laurence | Champier | ||
| 17010000000807 | L17/amo10 | 17 | 17010000000774 | 17010000000806 | 1 | M. | Frédéric | Langenfeld | ||
| 17010000000808 | L17/amo10 | 17 | 17010000000774 | 17010000000806 | 2 | M. | Gaëtan | Inard | ||
| 17010000000809 | L17/amo10 | 17 | 17010000000774 | 17010000000806 | 3 | M. | Théo | Dutrieu | ||
| 17010000000848 | L17/amo10 | 17 | 17010000000810 | 17010000000847 | 1 | Mme | Savine | Bénard-Bienvenu | ||
| 17010000000849 | L17/amo10 | 17 | 17010000000810 | 17010000000847 | 2 | M. | Pascal | Piganiol | ||
| 17010000000850 | L17/amo10 | 17 | 17010000000810 | 17010000000847 | 3 | Mme | Sylvie | Lachaize | ||
| 17010000000867 | L17/amo10 | 17 | 17010000000851 | 17010000000866 | 1 | M. | Clément | Haquet | ||
| 17010000000868 | L17/amo10 | 17 | 17010000000851 | 17010000000866 | 2 | Mme | Julie | Guillaud | ||
| 17010000000869 | L17/amo10 | 17 | 17010000000851 | 17010000000866 | 3 | Mme | Morgane | Jeanjacquot | ||
| 17010000000870 | L17/amo10 | 17 | 17010000000851 | 17010000000866 | 4 | M. | Bruno | Mazereau | ||
| 17010000000901 | L17/amo10 | 17 | 17010000000871 | 17010000000900 | 1 | Mme | Marie | Vanderchmitt | ||
| 17010000000902 | L17/amo10 | 17 | 17010000000871 | 17010000000900 | 2 | Mme | Chloé | Augey | ||
| 17010000000919 | L17/amo10 | 17 | 17010000000903 | 17010000000918 | 1 | Mme | Florence | Dubois | ||
| 17010000000920 | L17/amo10 | 17 | 17010000000903 | 17010000000918 | 2 | M. | Franck | Charon | ||
| 17010000000940 | L17/amo10 | 17 | 17010000000921 | 17010000000939 | 1 | M. | Sébastien | Bonjour | ||
| 17010000000941 | L17/amo10 | 17 | 17010000000921 | 17010000000939 | 2 | M. | Raynald | Hottegindre | ||
| 17010000000942 | L17/amo10 | 17 | 17010000000921 | 17010000000939 | 3 | Mme | Clémentine | Verron | ||
| 17010000000976 | L17/amo10 | 17 | 17010000000943 | 17010000000975 | 1 | Mme | Rachel | Mehaignerie | ||
| 17010000000977 | L17/amo10 | 17 | 17010000000943 | 17010000000975 | 2 | Mme | Pascale | Cupif | ||
| 17010000000978 | L17/amo10 | 17 | 17010000000943 | 17010000000975 | 3 | M. | Augustin | Moreau | ||
| 17010000001071 | L17/amo10 | 17 | 17010000000979 | 17010000001070 | 1 | Mme | Marion | Guesdon | ||
| 17010000001072 | L17/amo10 | 17 | 17010000000979 | 17010000001070 | 2 | Mme | Dorothée | Rouillard |