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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17020000008279 | L17/amo20 | 17 | 17020000008210 | 17020000008275 | 4 | Mme | Sophia | Audias | ||
| 17020000008336 | L17/amo20 | 17 | 17020000008280 | 17020000008335 | 1 | Mme | Maryll | Vignal | ||
| 17020000008337 | L17/amo20 | 17 | 17020000008280 | 17020000008335 | 2 | M. | Arsène | Gornik | ||
| 17020000008338 | L17/amo20 | 17 | 17020000008280 | 17020000008335 | 3 | M. | Brice | Baessa Cariot | ||
| 17020000008339 | L17/amo20 | 17 | 17020000008280 | 17020000008335 | 4 | M. | Abel | Hermel | ||
| 17020000008439 | L17/amo20 | 17 | 17020000008340 | 17020000008438 | 1 | M. | Patrick | Barrau | ||
| 17020000008440 | L17/amo20 | 17 | 17020000008340 | 17020000008438 | 2 | M. | Yoann | Peres | ||
| 17020000008441 | L17/amo20 | 17 | 17020000008340 | 17020000008438 | 3 | M. | Nicolas | Le Cheviller | ||
| 17020000008566 | L17/amo20 | 17 | 17020000008442 | 17020000008565 | 1 | M. | François-Xavier | Le Rhun | ||
| 17020000008567 | L17/amo20 | 17 | 17020000008442 | 17020000008565 | 2 | Mme | Guénaëlle | Lauden | ||
| 17020000008568 | L17/amo20 | 17 | 17020000008442 | 17020000008565 | 3 | Mme | Martine | Olivier | ||
| 17020000008569 | L17/amo20 | 17 | 17020000008442 | 17020000008565 | 4 | Mme | Charlotte | Nicollet | ||
| 17020000008622 | L17/amo20 | 17 | 17020000008570 | 17020000008621 | 1 | Mme | Laure-Anne | Kerisit | ||
| 17020000008623 | L17/amo20 | 17 | 17020000008570 | 17020000008621 | 2 | Mme | Alexia | Nguyen Quoc | ||
| 17020000008624 | L17/amo20 | 17 | 17020000008570 | 17020000008621 | 3 | M. | Louis | Gendreau | ||
| 17020000008669 | L17/amo20 | 17 | 17020000008625 | 17020000008668 | 1 | Mme | Elise | Gaubert | ||
| 17020000008670 | L17/amo20 | 17 | 17020000008625 | 17020000008668 | 2 | Mme | Lucie | Hémond | ||
| 17020000008671 | L17/amo20 | 17 | 17020000008625 | 17020000008668 | 3 | M. | Rémi | Joussiaume | ||
| 17020000008709 | L17/amo20 | 17 | 17020000008672 | 17020000008708 | 1 | Mme | Nadia | Dupuyau | ||
| 17020000008710 | L17/amo20 | 17 | 17020000008672 | 17020000008708 | 2 | Mme | Rachel | Molère-Attal | ||
| 17020000008711 | L17/amo20 | 17 | 17020000008672 | 17020000008708 | 3 | Mme | Clara | Feufeu-Rozière | ||
| 17020000008834 | L17/amo20 | 17 | 17020000008712 | 17020000008833 | 1 | M. | Thibault | Girou | ||
| 17020000008835 | L17/amo20 | 17 | 17020000008712 | 17020000008833 | 2 | Mme | Cécile | Reix | ||
| 17020000008836 | L17/amo20 | 17 | 17020000008712 | 17020000008833 | 3 | Mme | Myriam | Boukhalfa | ||
| 17020000008926 | L17/amo20 | 17 | 17020000008878 | 17020000008925 | 1 | M. | Frédéric | Sicot | ||
| 17020000008927 | L17/amo20 | 17 | 17020000008878 | 17020000008925 | 2 | M. | Kévin | Dereppe | ||
| 17020000008928 | L17/amo20 | 17 | 17020000008878 | 17020000008925 | 3 | Mme | Heïdi | Loisel | ||
| 17020000008974 | L17/amo20 | 17 | 17020000008929 | 17020000008973 | 1 | Mme | Marie-Claire | Pinardon | ||
| 17020000008975 | L17/amo20 | 17 | 17020000008929 | 17020000008973 | 2 | M. | David | Miodownick | ||
| 17020000009035 | L17/amo20 | 17 | 17020000008976 | 17020000009034 | 1 | Mme | Victoria | Petrolesi | ||
| 17020000009036 | L17/amo20 | 17 | 17020000008976 | 17020000009034 | 2 | M. | Léo | Castoldi-Robert | ||
| 17020000009093 | L17/amo20 | 17 | 17020000009037 | 17020000009092 | 1 | M. | Sacha | Lamsika | ||
| 17020000009094 | L17/amo20 | 17 | 17020000009037 | 17020000009092 | 2 | Mme | Elodie | Poinha | ||
| 17020000009095 | L17/amo20 | 17 | 17020000009037 | 17020000009092 | 3 | Mme | Ouloufa | Dorani | ||
| 17020000009096 | L17/amo20 | 17 | 17020000009037 | 17020000009092 | 4 | Mme | Sabrina | Milan | ||
| 17020000009175 | L17/amo20 | 17 | 17020000009097 | 17020000009174 | 1 | M. | Michaël | Miel-Margeretta | ||
| 17020000009176 | L17/amo20 | 17 | 17020000009097 | 17020000009174 | 2 | Mme | Nathalie | Coron | ||
| 17020000009177 | L17/amo20 | 17 | 17020000009097 | 17020000009174 | 3 | M. | Vincent | Thommelin | ||
| 17020000009202 | L17/amo20 | 17 | 17020000009178 | 17020000009201 | 1 | Mme | Marie-Pierre | Gazo | ||
| 17020000009203 | L17/amo20 | 17 | 17020000009178 | 17020000009201 | 2 | M. | Fabien | Lainé | ||
| 17020000009204 | L17/amo20 | 17 | 17020000009178 | 17020000009201 | 3 | M. | Tom | Gillet Duffrechou | ||
| 17020000009205 | L17/amo20 | 17 | 17020000009178 | 17020000009201 | 4 | M. | Sacha | Lamsika | ||
| 17020000009206 | L17/amo20 | 17 | 17020000009178 | 17020000009201 | 5 | M. | Anthony | Cales | ||
| 17020000009255 | L17/amo20 | 17 | 17020000009222 | 17020000009254 | 1 | M. | Pierre | Pécastaings | ||
| 17020000009256 | L17/amo20 | 17 | 17020000009222 | 17020000009254 | 2 | M. | Mehdi | Rahoui | ||
| 17020000009257 | L17/amo20 | 17 | 17020000009222 | 17020000009254 | 3 | M. | Jean-François | Broqueres | ||
| 17020000009258 | L17/amo20 | 17 | 17020000009222 | 17020000009254 | 4 | M. | Paul-Antoine | Caillaud | ||
| 17020000009259 | L17/amo20 | 17 | 17020000009222 | 17020000009254 | 5 | M. | Romain | Lafitte | ||
| 17020000009283 | L17/amo20 | 17 | 17020000009260 | 17020000009282 | 1 | M. | Philippe | Quéré | ||
| 17020000009284 | L17/amo20 | 17 | 17020000009260 | 17020000009282 | 2 | Mme | Magali | Valiorgue |