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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17020000005690 | L17/amo20 | 17 | 17020000005640 | 17020000005688 | 2 | Mme | Laïla | Ahmed Kassim | ||
| 17020000005691 | L17/amo20 | 17 | 17020000005640 | 17020000005688 | 3 | M. | Gustave | Richard | ||
| 17020000005740 | L17/amo20 | 17 | 17020000005692 | 17020000005739 | 1 | Mme | Aline | Garnier Taveau | ||
| 17020000005741 | L17/amo20 | 17 | 17020000005692 | 17020000005739 | 2 | Mme | Capucine | Ottino | ||
| 17020000005742 | L17/amo20 | 17 | 17020000005692 | 17020000005739 | 3 | M. | Mathéo | Paris | ||
| 17020000005743 | L17/amo20 | 17 | 17020000005692 | 17020000005739 | 4 | Mme | Juliette | Gribovalle | ||
| 17020000005800 | L17/amo20 | 17 | 17020000005744 | 17020000005799 | 1 | M. | Sixte | Rudolf Restrepo | ||
| 17020000005801 | L17/amo20 | 17 | 17020000005744 | 17020000005799 | 2 | Mme | Lucille | Geiss | ||
| 17020000005802 | L17/amo20 | 17 | 17020000005744 | 17020000005799 | 3 | M. | Matthieu | Brun | ||
| 17020000005803 | L17/amo20 | 17 | 17020000005744 | 17020000005799 | 4 | M. | Laurent | Boulay | ||
| 17020000005804 | L17/amo20 | 17 | 17020000005744 | 17020000005799 | 5 | Mme | Paula | Reihlen | ||
| 17020000005878 | L17/amo20 | 17 | 17020000005805 | 17020000005877 | 1 | Mme | Catherine | Gallerand | ||
| 17020000005879 | L17/amo20 | 17 | 17020000005805 | 17020000005877 | 2 | Mme | Marie | Spring | ||
| 17020000005880 | L17/amo20 | 17 | 17020000005805 | 17020000005877 | 3 | Mme | Alice | Zarba | ||
| 17020000005881 | L17/amo20 | 17 | 17020000005805 | 17020000005877 | 4 | Mme | Prune | Marie | ||
| 17020000006035 | L17/amo20 | 17 | 17020000005989 | 17020000006034 | 1 | M. | Baptiste | Vedrines | ||
| 17020000006036 | L17/amo20 | 17 | 17020000005989 | 17020000006034 | 2 | Mme | Nathalie | Lenoël | ||
| 17020000006037 | L17/amo20 | 17 | 17020000005989 | 17020000006034 | 3 | Mme | Mathilde | Lorey | ||
| 17020000006038 | L17/amo20 | 17 | 17020000005989 | 17020000006034 | 4 | Mme | Madeline | Clodong--Verron | ||
| 17020000006729 | L17/amo20 | 17 | 17020000006688 | 17020000006728 | 1 | Mme | Olga | Fernandes | ||
| 17020000006730 | L17/amo20 | 17 | 17020000006688 | 17020000006728 | 2 | Mme | Fabienne | Chanteloup | ||
| 17020000006731 | L17/amo20 | 17 | 17020000006688 | 17020000006728 | 3 | M. | Landry | Mepui Abah | ||
| 17020000006786 | L17/amo20 | 17 | 17020000006732 | 17020000006785 | 1 | Mme | Constance | Foiret | ||
| 17020000006787 | L17/amo20 | 17 | 17020000006732 | 17020000006785 | 2 | Mme | Christelle | Gomes | ||
| 17020000006788 | L17/amo20 | 17 | 17020000006732 | 17020000006785 | 3 | Mme | Françoise | Marlière | ||
| 17020000006789 | L17/amo20 | 17 | 17020000006732 | 17020000006785 | 4 | M. | Jonathan | Dysserinck | ||
| 17020000006839 | L17/amo20 | 17 | 17020000006817 | 17020000006838 | 1 | M. | Marlon | Camps | ||
| 17020000006840 | L17/amo20 | 17 | 17020000006817 | 17020000006838 | 2 | M. | Benjamin | Campos | ||
| 17020000006934 | L17/amo20 | 17 | 17020000006841 | 17020000006933 | 1 | Mme | Aude | Vrillet | ||
| 17020000006997 | L17/amo20 | 17 | 17020000006936 | 17020000006996 | 1 | Mme | Shauna | Grew | ||
| 17020000006998 | L17/amo20 | 17 | 17020000006936 | 17020000006996 | 2 | M. | Teddy | Demangeot | ||
| 17020000007064 | L17/amo20 | 17 | 17020000006999 | 17020000007063 | 1 | M. | Pierre | Alaux | ||
| 17020000007065 | L17/amo20 | 17 | 17020000006999 | 17020000007063 | 2 | M. | Stéphane | Léonetti | ||
| 17020000007066 | L17/amo20 | 17 | 17020000006999 | 17020000007063 | 3 | Mme | Johanna | Simoes da Silva | ||
| 17020000007067 | L17/amo20 | 17 | 17020000006999 | 17020000007063 | 4 | M. | Clément | Fauriel | ||
| 17020000007104 | L17/amo20 | 17 | 17020000007068 | 17020000007103 | 1 | M. | Cédric | Chambard | ||
| 17020000007105 | L17/amo20 | 17 | 17020000007068 | 17020000007103 | 2 | Mme | Noémie | Deguara Acquier | ||
| 17020000007183 | L17/amo20 | 17 | 17020000007106 | 17020000007182 | 1 | Mme | Maryline | Tindille | ||
| 17020000007184 | L17/amo20 | 17 | 17020000007106 | 17020000007182 | 2 | M. | Augustin | André | ||
| 17020000007185 | L17/amo20 | 17 | 17020000007106 | 17020000007182 | 3 | M. | Dorian | Thoulouze | ||
| 17020000007239 | L17/amo20 | 17 | 17020000007186 | 17020000007238 | 1 | Mme | Marie | Milan-Homolle | ||
| 17020000007240 | L17/amo20 | 17 | 17020000007186 | 17020000007238 | 2 | Mme | Juliette | Parizot | ||
| 17020000007241 | L17/amo20 | 17 | 17020000007186 | 17020000007238 | 3 | Mme | Alexia | Léonard | ||
| 17020000007287 | L17/amo20 | 17 | 17020000007242 | 17020000007286 | 1 | M. | Stéphane | Grillat | ||
| 17020000007288 | L17/amo20 | 17 | 17020000007242 | 17020000007286 | 2 | Mme | Sophie | Aubry-Caffet | ||
| 17020000007289 | L17/amo20 | 17 | 17020000007242 | 17020000007286 | 3 | M. | Richard | Kiss | ||
| 17020000007290 | L17/amo20 | 17 | 17020000007242 | 17020000007286 | 4 | Mme | Clémentine | Verron | ||
| 17020000007353 | L17/amo20 | 17 | 17020000007291 | 17020000007352 | 1 | M. | Nourdine | Barqi | ||
| 17020000007354 | L17/amo20 | 17 | 17020000007291 | 17020000007352 | 2 | M. | Edouard | Cornu | ||
| 17020000007355 | L17/amo20 | 17 | 17020000007291 | 17020000007352 | 3 | M. | Christophe | Guyomard |