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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17030000046648 | L17/amo30 | 17 | 17030000046622 | 17030000046645 | 3 | Mme | Angélique | Gapilian | ||
| 17030000046649 | L17/amo30 | 17 | 17030000046622 | 17030000046645 | 4 | M. | Louis | Denquin | ||
| 17030000047382 | L17/amo30 | 17 | 17030000047140 | 17030000047381 | 1 | M. | Johnny | Villion | ||
| 17030000047383 | L17/amo30 | 17 | 17030000047140 | 17030000047381 | 2 | Mme | Clémence | Fort | ||
| 17030000047905 | L17/amo30 | 17 | 17030000047598 | 17030000047904 | 1 | M. | Frank | Mezzasoma | ||
| 17030000047906 | L17/amo30 | 17 | 17030000047598 | 17030000047904 | 2 | M. | Rémi | Blardone | ||
| 17030000047907 | L17/amo30 | 17 | 17030000047598 | 17030000047904 | 3 | M. | David | Avaliani | ||
| 17030000047908 | L17/amo30 | 17 | 17030000047598 | 17030000047904 | 4 | M. | Romain | Aidaoui | ||
| 17030000047909 | L17/amo30 | 17 | 17030000047598 | 17030000047904 | 5 | M. | Kamel | Rezagui | ||
| 17030000055612 | L17/amo30 | 17 | 17030000055540 | 17030000055611 | 1 | Mme | Manon | Silvant | ||
| 17030000055613 | L17/amo30 | 17 | 17030000055540 | 17030000055611 | 2 | M. | Nathan | Sourisseau | ||
| 17030000055614 | L17/amo30 | 17 | 17030000055540 | 17030000055611 | 3 | M. | Kylan | Semenzin | ||
| 17030000055615 | L17/amo30 | 17 | 17030000055540 | 17030000055611 | 4 | M. | Erwan | Ferry | ||
| 17030000055616 | L17/amo30 | 17 | 17030000055540 | 17030000055611 | 5 | M. | Anthony | Poulin | ||
| 17030000055617 | L17/amo30 | 17 | 17030000055540 | 17030000055611 | 6 | Mme | Claire | Mallard | ||
| 17030000056145 | L17/amo30 | 17 | 17030000055795 | 17030000056144 | 1 | Mme | Anne | Dumay | ||
| 17030000056146 | L17/amo30 | 17 | 17030000055795 | 17030000056144 | 2 | Mme | Monique | Dujeancourt | ||
| 17030000056147 | L17/amo30 | 17 | 17030000055795 | 17030000056144 | 3 | Mme | Caroline | Quiène | ||
| 17030000056148 | L17/amo30 | 17 | 17030000055795 | 17030000056144 | 4 | Mme | Delphine | Champagne | ||
| 17030000056149 | L17/amo30 | 17 | 17030000055795 | 17030000056144 | 5 | M. | Abel | Beltrame | ||
| 17030000058356 | L17/amo30 | 17 | 17030000058207 | 17030000058355 | 1 | Mme | Virginie | Le Garec | ||
| 17030000058357 | L17/amo30 | 17 | 17030000058207 | 17030000058355 | 2 | M. | Matéo | Vayssié | ||
| 17030000058358 | L17/amo30 | 17 | 17030000058207 | 17030000058355 | 3 | M. | Charles | Guemas | ||
| 17030000058359 | L17/amo30 | 17 | 17030000058207 | 17030000058355 | 4 | M. | Nolan | Genty | ||
| 17030000059234 | L17/amo30 | 17 | 17030000058756 | 17030000059233 | 1 | M. | Jean-Luc | Orset | ||
| 17030000059235 | L17/amo30 | 17 | 17030000058756 | 17030000059233 | 2 | Mme | Christelle | Demoustier | ||
| 17030000059236 | L17/amo30 | 17 | 17030000058756 | 17030000059233 | 3 | M. | Alexis | Morand | ||
| 17030000059237 | L17/amo30 | 17 | 17030000058756 | 17030000059233 | 4 | Mme | Laurence | Champier | ||
| 17030000059612 | L17/amo30 | 17 | 17030000059469 | 17030000059611 | 1 | M. | Frédéric | Langenfeld | ||
| 17030000059613 | L17/amo30 | 17 | 17030000059469 | 17030000059611 | 2 | M. | Gaëtan | Inard | ||
| 17030000059614 | L17/amo30 | 17 | 17030000059469 | 17030000059611 | 3 | M. | Théo | Dutrieu | ||
| 17030000060292 | L17/amo30 | 17 | 17030000060135 | 17030000060291 | 1 | Mme | Savine | Bénard-Bienvenu | ||
| 17030000060293 | L17/amo30 | 17 | 17030000060135 | 17030000060291 | 2 | M. | Pascal | Piganiol | ||
| 17030000060294 | L17/amo30 | 17 | 17030000060135 | 17030000060291 | 3 | Mme | Sylvie | Lachaize | ||
| 17030000061232 | L17/amo30 | 17 | 17030000061032 | 17030000061231 | 1 | M. | Clément | Haquet | ||
| 17030000061233 | L17/amo30 | 17 | 17030000061032 | 17030000061231 | 2 | Mme | Julie | Guillaud | ||
| 17030000061234 | L17/amo30 | 17 | 17030000061032 | 17030000061231 | 3 | Mme | Morgane | Jeanjacquot | ||
| 17030000061235 | L17/amo30 | 17 | 17030000061032 | 17030000061231 | 4 | M. | Bruno | Mazereau | ||
| 17030000061941 | L17/amo30 | 17 | 17030000061820 | 17030000061940 | 1 | Mme | Marie | Vanderchmitt | ||
| 17030000061942 | L17/amo30 | 17 | 17030000061820 | 17030000061940 | 2 | Mme | Chloé | Augey | ||
| 17030000062354 | L17/amo30 | 17 | 17030000062187 | 17030000062353 | 1 | Mme | Florence | Dubois | ||
| 17030000062355 | L17/amo30 | 17 | 17030000062187 | 17030000062353 | 2 | M. | Franck | Charon | ||
| 17030000062903 | L17/amo30 | 17 | 17030000062595 | 17030000062902 | 1 | M. | Sébastien | Bonjour | ||
| 17030000062904 | L17/amo30 | 17 | 17030000062595 | 17030000062902 | 2 | M. | Raynald | Hottegindre | ||
| 17030000062905 | L17/amo30 | 17 | 17030000062595 | 17030000062902 | 3 | Mme | Clémentine | Verron | ||
| 17030000064202 | L17/amo30 | 17 | 17030000063933 | 17030000064201 | 1 | Mme | Rachel | Mehaignerie | ||
| 17030000064203 | L17/amo30 | 17 | 17030000063933 | 17030000064201 | 2 | Mme | Pascale | Cupif | ||
| 17030000064204 | L17/amo30 | 17 | 17030000063933 | 17030000064201 | 3 | M. | Augustin | Moreau | ||
| 17030000066907 | L17/amo30 | 17 | 17030000066481 | 17030000066906 | 1 | Mme | Marion | Guesdon | ||
| 17030000066908 | L17/amo30 | 17 | 17030000066481 | 17030000066906 | 2 | Mme | Dorothée | Rouillard |