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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17020000001267 | L17/amo20 | 17 | 17020000001241 | 17020000001264 | 3 | Mme | Angélique | Gapilian | ||
| 17020000001268 | L17/amo20 | 17 | 17020000001241 | 17020000001264 | 4 | M. | Louis | Denquin | ||
| 17020000001395 | L17/amo20 | 17 | 17020000001269 | 17020000001394 | 1 | M. | Johnny | Villion | ||
| 17020000001396 | L17/amo20 | 17 | 17020000001269 | 17020000001394 | 2 | Mme | Clémence | Fort | ||
| 17020000001464 | L17/amo20 | 17 | 17020000001397 | 17020000001463 | 1 | M. | Frank | Mezzasoma | ||
| 17020000001465 | L17/amo20 | 17 | 17020000001397 | 17020000001463 | 2 | M. | Rémi | Blardone | ||
| 17020000001466 | L17/amo20 | 17 | 17020000001397 | 17020000001463 | 3 | M. | David | Avaliani | ||
| 17020000001467 | L17/amo20 | 17 | 17020000001397 | 17020000001463 | 4 | M. | Romain | Aidaoui | ||
| 17020000001468 | L17/amo20 | 17 | 17020000001397 | 17020000001463 | 5 | M. | Kamel | Rezagui | ||
| 17020000001569 | L17/amo20 | 17 | 17020000001505 | 17020000001568 | 1 | Mme | Manon | Silvant | ||
| 17020000001570 | L17/amo20 | 17 | 17020000001505 | 17020000001568 | 2 | M. | Nathan | Sourisseau | ||
| 17020000001571 | L17/amo20 | 17 | 17020000001505 | 17020000001568 | 3 | M. | Kylan | Semenzin | ||
| 17020000001572 | L17/amo20 | 17 | 17020000001505 | 17020000001568 | 4 | M. | Erwan | Ferry | ||
| 17020000001573 | L17/amo20 | 17 | 17020000001505 | 17020000001568 | 5 | M. | Anthony | Poulin | ||
| 17020000001574 | L17/amo20 | 17 | 17020000001505 | 17020000001568 | 6 | Mme | Claire | Mallard | ||
| 17020000001635 | L17/amo20 | 17 | 17020000001575 | 17020000001634 | 1 | Mme | Anne | Dumay | ||
| 17020000001636 | L17/amo20 | 17 | 17020000001575 | 17020000001634 | 2 | Mme | Monique | Dujeancourt | ||
| 17020000001637 | L17/amo20 | 17 | 17020000001575 | 17020000001634 | 3 | Mme | Caroline | Quiène | ||
| 17020000001638 | L17/amo20 | 17 | 17020000001575 | 17020000001634 | 4 | Mme | Delphine | Champagne | ||
| 17020000001639 | L17/amo20 | 17 | 17020000001575 | 17020000001634 | 5 | M. | Abel | Beltrame | ||
| 17020000001783 | L17/amo20 | 17 | 17020000001736 | 17020000001782 | 1 | Mme | Virginie | Le Garec | ||
| 17020000001784 | L17/amo20 | 17 | 17020000001736 | 17020000001782 | 2 | M. | Matéo | Vayssié | ||
| 17020000001785 | L17/amo20 | 17 | 17020000001736 | 17020000001782 | 3 | M. | Charles | Guemas | ||
| 17020000001786 | L17/amo20 | 17 | 17020000001736 | 17020000001782 | 4 | M. | Nolan | Genty | ||
| 17020000001883 | L17/amo20 | 17 | 17020000001803 | 17020000001882 | 1 | M. | Jean-Luc | Orset | ||
| 17020000001884 | L17/amo20 | 17 | 17020000001803 | 17020000001882 | 2 | Mme | Christelle | Demoustier | ||
| 17020000001885 | L17/amo20 | 17 | 17020000001803 | 17020000001882 | 3 | M. | Alexis | Morand | ||
| 17020000001886 | L17/amo20 | 17 | 17020000001803 | 17020000001882 | 4 | Mme | Laurence | Champier | ||
| 17020000001936 | L17/amo20 | 17 | 17020000001887 | 17020000001935 | 1 | M. | Frédéric | Langenfeld | ||
| 17020000001937 | L17/amo20 | 17 | 17020000001887 | 17020000001935 | 2 | M. | Gaëtan | Inard | ||
| 17020000001938 | L17/amo20 | 17 | 17020000001887 | 17020000001935 | 3 | M. | Théo | Dutrieu | ||
| 17020000002005 | L17/amo20 | 17 | 17020000001951 | 17020000002004 | 1 | Mme | Savine | Bénard-Bienvenu | ||
| 17020000002006 | L17/amo20 | 17 | 17020000001951 | 17020000002004 | 2 | M. | Pascal | Piganiol | ||
| 17020000002007 | L17/amo20 | 17 | 17020000001951 | 17020000002004 | 3 | Mme | Sylvie | Lachaize | ||
| 17020000002072 | L17/amo20 | 17 | 17020000002026 | 17020000002071 | 1 | M. | Clément | Haquet | ||
| 17020000002073 | L17/amo20 | 17 | 17020000002026 | 17020000002071 | 2 | Mme | Julie | Guillaud | ||
| 17020000002074 | L17/amo20 | 17 | 17020000002026 | 17020000002071 | 3 | Mme | Morgane | Jeanjacquot | ||
| 17020000002075 | L17/amo20 | 17 | 17020000002026 | 17020000002071 | 4 | M. | Bruno | Mazereau | ||
| 17020000002117 | L17/amo20 | 17 | 17020000002076 | 17020000002116 | 1 | Mme | Marie | Vanderchmitt | ||
| 17020000002118 | L17/amo20 | 17 | 17020000002076 | 17020000002116 | 2 | Mme | Chloé | Augey | ||
| 17020000002149 | L17/amo20 | 17 | 17020000002119 | 17020000002148 | 1 | Mme | Florence | Dubois | ||
| 17020000002150 | L17/amo20 | 17 | 17020000002119 | 17020000002148 | 2 | M. | Franck | Charon | ||
| 17020000002223 | L17/amo20 | 17 | 17020000002151 | 17020000002222 | 1 | M. | Sébastien | Bonjour | ||
| 17020000002224 | L17/amo20 | 17 | 17020000002151 | 17020000002222 | 2 | M. | Raynald | Hottegindre | ||
| 17020000002225 | L17/amo20 | 17 | 17020000002151 | 17020000002222 | 3 | Mme | Clémentine | Verron | ||
| 17020000002287 | L17/amo20 | 17 | 17020000002226 | 17020000002286 | 1 | Mme | Rachel | Mehaignerie | ||
| 17020000002288 | L17/amo20 | 17 | 17020000002226 | 17020000002286 | 2 | Mme | Pascale | Cupif | ||
| 17020000002289 | L17/amo20 | 17 | 17020000002226 | 17020000002286 | 3 | M. | Augustin | Moreau | ||
| 17020000002426 | L17/amo20 | 17 | 17020000002290 | 17020000002425 | 1 | Mme | Marion | Guesdon | ||
| 17020000002427 | L17/amo20 | 17 | 17020000002290 | 17020000002425 | 2 | Mme | Dorothée | Rouillard |