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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17020000034527 | L17/amo20 | 17 | 17020000034487 | 17020000034525 | 2 | Mme | Céline | Carcy | ||
| 17020000034528 | L17/amo20 | 17 | 17020000034487 | 17020000034525 | 3 | Mme | Mélissa | Martinez | ||
| 17020000034529 | L17/amo20 | 17 | 17020000034487 | 17020000034525 | 4 | Mme | Nina | Vicente | ||
| 17020000034568 | L17/amo20 | 17 | 17020000034530 | 17020000034567 | 1 | M. | Alex | Frederiksen | ||
| 17020000034569 | L17/amo20 | 17 | 17020000034530 | 17020000034567 | 2 | M. | David | Quentin | ||
| 17020000034570 | L17/amo20 | 17 | 17020000034530 | 17020000034567 | 3 | M. | Léo | Reuter | ||
| 17020000034595 | L17/amo20 | 17 | 17020000034571 | 17020000034594 | 1 | Mme | Crystel | Ruiz | ||
| 17020000034596 | L17/amo20 | 17 | 17020000034571 | 17020000034594 | 2 | M. | Olivier | Stroobants | ||
| 17020000034597 | L17/amo20 | 17 | 17020000034571 | 17020000034594 | 3 | M. | Victor | Lemoine | ||
| 17020000034598 | L17/amo20 | 17 | 17020000034571 | 17020000034594 | 4 | Mme | Margot | Cance | ||
| 17020000034663 | L17/amo20 | 17 | 17020000034599 | 17020000034662 | 1 | Mme | Emilie | Laverdant | ||
| 17020000034664 | L17/amo20 | 17 | 17020000034599 | 17020000034662 | 2 | Mme | Florine | Tremblais | ||
| 17020000034665 | L17/amo20 | 17 | 17020000034599 | 17020000034662 | 3 | M. | Simon | Vaslin-Thillet | ||
| 17020000034666 | L17/amo20 | 17 | 17020000034599 | 17020000034662 | 4 | M. | Tony | Imbert | ||
| 17020000034741 | L17/amo20 | 17 | 17020000034678 | 17020000034740 | 1 | M. | Mathieu | Mickael | ||
| 17020000034742 | L17/amo20 | 17 | 17020000034678 | 17020000034740 | 2 | M. | Raphaël | Hérimian | ||
| 17020000034743 | L17/amo20 | 17 | 17020000034678 | 17020000034740 | 3 | M. | Samuel | Sakpa | ||
| 17020000034744 | L17/amo20 | 17 | 17020000034678 | 17020000034740 | 4 | M. | Enzo | Billon | ||
| 17020000034821 | L17/amo20 | 17 | 17020000034745 | 17020000034820 | 1 | Mme | Alexandra | Beckley | ||
| 17020000034822 | L17/amo20 | 17 | 17020000034745 | 17020000034820 | 2 | Mme | Alexine | Chorda | ||
| 17020000034823 | L17/amo20 | 17 | 17020000034745 | 17020000034820 | 3 | M. | Jules | Terrier | ||
| 17020000034824 | L17/amo20 | 17 | 17020000034745 | 17020000034820 | 4 | Mme | Tiphaine | Chomaz | ||
| 17020000034825 | L17/amo20 | 17 | 17020000034745 | 17020000034820 | 5 | Mme | Rachel | Keke | ||
| 17020000034826 | L17/amo20 | 17 | 17020000034745 | 17020000034820 | 6 | Mme | Chérine | Zaiout | ||
| 17020000034853 | L17/amo20 | 17 | 17020000034827 | 17020000034852 | 1 | M. | Valentin | Gabriac | ||
| 17020000034854 | L17/amo20 | 17 | 17020000034827 | 17020000034852 | 2 | M. | Quentin | Féres | ||
| 17020000034855 | L17/amo20 | 17 | 17020000034827 | 17020000034852 | 3 | M. | Benoît | Auguste | ||
| 17020000034856 | L17/amo20 | 17 | 17020000034827 | 17020000034852 | 4 | M. | Pierre | Costantino | ||
| 17020000034895 | L17/amo20 | 17 | 17020000034857 | 17020000034894 | 1 | M. | Christophe | Coraux | ||
| 17020000034896 | L17/amo20 | 17 | 17020000034857 | 17020000034894 | 2 | M. | Raphaël | Tabusse | ||
| 17020000034897 | L17/amo20 | 17 | 17020000034857 | 17020000034894 | 3 | Mme | Sheherazade | Khandani | ||
| 17020000034945 | L17/amo20 | 17 | 17020000034898 | 17020000034944 | 1 | Mme | Cassandre | Bliot | ||
| 17020000034946 | L17/amo20 | 17 | 17020000034898 | 17020000034944 | 2 | Mme | Typhaine | Grignard | ||
| 17020000034947 | L17/amo20 | 17 | 17020000034898 | 17020000034944 | 3 | Mme | Juliette | Malbois | ||
| 17020000034948 | L17/amo20 | 17 | 17020000034898 | 17020000034944 | 4 | M. | Antonin | Godard | ||
| 17020000034993 | L17/amo20 | 17 | 17020000034949 | 17020000034992 | 1 | M. | Matthieu | Groseil | ||
| 17020000034994 | L17/amo20 | 17 | 17020000034949 | 17020000034992 | 2 | Mme | Mathilde | Hériaud | ||
| 17020000034995 | L17/amo20 | 17 | 17020000034949 | 17020000034992 | 3 | M. | David | Thomas | ||
| 17020000034996 | L17/amo20 | 17 | 17020000034949 | 17020000034992 | 4 | M. | Nathan | Guillemot | ||
| 17020000035041 | L17/amo20 | 17 | 17020000034997 | 17020000035040 | 1 | Mme | Sylvie | Bridier | ||
| 17020000035042 | L17/amo20 | 17 | 17020000034997 | 17020000035040 | 2 | Mme | Juliette | Sachot | ||
| 17020000035043 | L17/amo20 | 17 | 17020000034997 | 17020000035040 | 3 | M. | Alexis | Diard | ||
| 17020000035101 | L17/amo20 | 17 | 17020000035044 | 17020000035100 | 1 | Mme | Roxane | Le Breton | ||
| 17020000035102 | L17/amo20 | 17 | 17020000035044 | 17020000035100 | 2 | M. | Léo | Lespinasse | ||
| 17020000035103 | L17/amo20 | 17 | 17020000035044 | 17020000035100 | 3 | Mme | Léa | Dallet | ||
| 17020000035104 | L17/amo20 | 17 | 17020000035044 | 17020000035100 | 4 | M. | Julien | Lefebvre | ||
| 17020000035164 | L17/amo20 | 17 | 17020000035105 | 17020000035163 | 1 | Mme | Laëtitia | Riffard | ||
| 17020000035165 | L17/amo20 | 17 | 17020000035105 | 17020000035163 | 2 | M. | Benjamin | Gibert | ||
| 17020000035166 | L17/amo20 | 17 | 17020000035105 | 17020000035163 | 3 | Mme | Marie | Valette | ||
| 17020000035167 | L17/amo20 | 17 | 17020000035105 | 17020000035163 | 4 | Mme | Lisa | Moulin--Villard |