amo50.mandat_collaborateurs_collaborateur
Chemin mandat.collaborateurs.collaborateur · présence : L17 0 %, L16 2 %
2 210 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 | mandat.collaborateurs.collaborateur.qualite · présence : L17 0 %, L16 2 % · 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 | mandat.collaborateurs.collaborateur.prenom · présence : L17 0 %, L16 2 % |
| 9 | nom | VARCHAR | mandat.collaborateurs.collaborateur.nom · présence : L17 0 %, L16 2 % |
| 10 | date_debut | VARCHAR | mandat.collaborateurs.collaborateur.dateDebut · présence : L17 0 %, L16 2 % |
| 11 | date_fin | VARCHAR | mandat.collaborateurs.collaborateur.dateFin · présence : L17 0 %, L16 2 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | qualite | prenom | nom | date_debut | date_fin |
|---|---|---|---|---|---|---|---|---|---|---|
| 16050000022992 | L16/amo50 | 16 | 16050000022988 | 16050000022989 | 3 | M. | Chérif | Lahouali | ||
| 16050000022993 | L16/amo50 | 16 | 16050000022988 | 16050000022989 | 4 | Mme | Delphine | Coyon | ||
| 16050000022997 | L16/amo50 | 16 | 16050000022995 | 16050000022996 | 1 | Mme | Fatma | Gouasmia | ||
| 16050000022998 | L16/amo50 | 16 | 16050000022995 | 16050000022996 | 2 | M. | Sébastien | Mirgodin | ||
| 16050000022999 | L16/amo50 | 16 | 16050000022995 | 16050000022996 | 3 | Mme | Solène | Rannou | ||
| 16050000023000 | L16/amo50 | 16 | 16050000022995 | 16050000022996 | 4 | M. | Julien | Gonthier | ||
| 16050000023004 | L16/amo50 | 16 | 16050000023002 | 16050000023003 | 1 | Mme | Carine | Dronet | ||
| 16050000023005 | L16/amo50 | 16 | 16050000023002 | 16050000023003 | 2 | Mme | Karine | Le Gal | ||
| 16050000023006 | L16/amo50 | 16 | 16050000023002 | 16050000023003 | 3 | M. | Jean Bosco | Nicolle | ||
| 16050000023007 | L16/amo50 | 16 | 16050000023002 | 16050000023003 | 4 | Mme | Claire | Gerault | ||
| 16050000023011 | L16/amo50 | 16 | 16050000023009 | 16050000023010 | 1 | M. | Stéphan | Fautrat | ||
| 16050000023012 | L16/amo50 | 16 | 16050000023009 | 16050000023010 | 2 | Mme | Maïté | Sève | ||
| 16050000023013 | L16/amo50 | 16 | 16050000023009 | 16050000023010 | 3 | M. | Jordan | Challier | ||
| 16050000023014 | L16/amo50 | 16 | 16050000023009 | 16050000023010 | 4 | M. | Alexandre | El Ghoul | ||
| 16050000023015 | L16/amo50 | 16 | 16050000023009 | 16050000023010 | 5 | Mme | Tatiana | Vivier-Paulange | ||
| 16050000023019 | L16/amo50 | 16 | 16050000023017 | 16050000023018 | 1 | Mme | Nadège | Condat | ||
| 16050000023020 | L16/amo50 | 16 | 16050000023017 | 16050000023018 | 2 | M. | Guillaume | Jollet | ||
| 16050000023021 | L16/amo50 | 16 | 16050000023017 | 16050000023018 | 3 | Mme | Noëlle | Brizemeure | ||
| 16050000023025 | L16/amo50 | 16 | 16050000023023 | 16050000023024 | 1 | M. | Théophane | De Cézac | ||
| 16050000023026 | L16/amo50 | 16 | 16050000023023 | 16050000023024 | 2 | Mme | Ambre | Louisin | ||
| 16050000023027 | L16/amo50 | 16 | 16050000023023 | 16050000023024 | 3 | Mme | Tiffany | Spitaleri | ||
| 16050000023031 | L16/amo50 | 16 | 16050000023029 | 16050000023030 | 1 | M. | Loïc | Burgun | ||
| 16050000023032 | L16/amo50 | 16 | 16050000023029 | 16050000023030 | 2 | Mme | Emma | Minot | ||
| 16050000023033 | L16/amo50 | 16 | 16050000023029 | 16050000023030 | 3 | Mme | nadège | Desprès | ||
| 16050000023037 | L16/amo50 | 16 | 16050000023035 | 16050000023036 | 1 | M. | Cédric | Chambard | ||
| 16050000023038 | L16/amo50 | 16 | 16050000023035 | 16050000023036 | 2 | M. | Eric | Tournon | ||
| 16050000023039 | L16/amo50 | 16 | 16050000023035 | 16050000023036 | 3 | Mme | Marie-Françoise | Fautrat | ||
| 16050000023040 | L16/amo50 | 16 | 16050000023035 | 16050000023036 | 4 | Mme | Véronique | Breton | ||
| 16050000023041 | L16/amo50 | 16 | 16050000023035 | 16050000023036 | 5 | Mme | Sandra | Diniz | ||
| 16050000023045 | L16/amo50 | 16 | 16050000023043 | 16050000023044 | 1 | Mme | Amandine | Rollin | ||
| 16050000023046 | L16/amo50 | 16 | 16050000023043 | 16050000023044 | 2 | Mme | Marion | Nowak | ||
| 16050000023047 | L16/amo50 | 16 | 16050000023043 | 16050000023044 | 3 | M. | Stéphane | Feutry | ||
| 16050000023051 | L16/amo50 | 16 | 16050000023049 | 16050000023050 | 1 | Mme | Mariel | Missud | ||
| 16050000023052 | L16/amo50 | 16 | 16050000023049 | 16050000023050 | 2 | Mme | Alice | Dekker | ||
| 16050000023053 | L16/amo50 | 16 | 16050000023049 | 16050000023050 | 3 | Mme | Agnès | Oberdorff | ||
| 16050000023054 | L16/amo50 | 16 | 16050000023049 | 16050000023050 | 4 | Mme | Laura | Verkaeren | ||
| 16050000023055 | L16/amo50 | 16 | 16050000023049 | 16050000023050 | 5 | M. | Valentin | Rouffiac | ||
| 16050000023056 | L16/amo50 | 16 | 16050000023049 | 16050000023050 | 6 | Mme | CHarles-William | Van Cappel | ||
| 16050000023060 | L16/amo50 | 16 | 16050000023058 | 16050000023059 | 1 | M. | Jean-Baptiste | Jallet | ||
| 16050000023061 | L16/amo50 | 16 | 16050000023058 | 16050000023059 | 2 | M. | François | Lacombe | ||
| 16050000023062 | L16/amo50 | 16 | 16050000023058 | 16050000023059 | 3 | M. | Hugo | Barbazanges | ||
| 16050000023066 | L16/amo50 | 16 | 16050000023064 | 16050000023065 | 1 | Mme | Claire | Rives | ||
| 16050000023067 | L16/amo50 | 16 | 16050000023064 | 16050000023065 | 2 | M. | Dorian | Terral | ||
| 16050000023068 | L16/amo50 | 16 | 16050000023064 | 16050000023065 | 3 | M. | Alexy | Rodriguez | ||
| 16050000023072 | L16/amo50 | 16 | 16050000023070 | 16050000023071 | 1 | Mme | Diane | Delbosq | ||
| 16050000023073 | L16/amo50 | 16 | 16050000023070 | 16050000023071 | 2 | M. | Dorian | Munoz-Munoz | ||
| 16050000023074 | L16/amo50 | 16 | 16050000023070 | 16050000023071 | 3 | M. | Martin | Jarrige | ||
| 16050000023078 | L16/amo50 | 16 | 16050000023076 | 16050000023077 | 1 | Mme | Isabelle | André | ||
| 16050000023079 | L16/amo50 | 16 | 16050000023076 | 16050000023077 | 2 | M. | Geoffrey | Meresse-Volleaux | ||
| 16050000023080 | L16/amo50 | 16 | 16050000023076 | 16050000023077 | 3 | M. | Louis | Savoldi |