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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 15020000033853 | L15/amo20 | 15 | 15020000033803 | 15020000033851 | 2 | Mme | Maha | Jaballi | ||
| 15020000033913 | L15/amo20 | 15 | 15020000033892 | 15020000033912 | 1 | M. | Éric | Van Roy | ||
| 15020000033914 | L15/amo20 | 15 | 15020000033892 | 15020000033912 | 2 | M. | Michel | Vanwarreghem | ||
| 15020000033915 | L15/amo20 | 15 | 15020000033892 | 15020000033912 | 3 | Mme | Habibath | Adjaho | ||
| 15020000033916 | L15/amo20 | 15 | 15020000033892 | 15020000033912 | 4 | M. | Geoffrey | Squedin | ||
| 15020000033946 | L15/amo20 | 15 | 15020000033917 | 15020000033945 | 1 | M. | Adrien | Lariepe | ||
| 15020000033947 | L15/amo20 | 15 | 15020000033917 | 15020000033945 | 2 | M. | Mehdi | Soyah | ||
| 15020000034017 | L15/amo20 | 15 | 15020000033948 | 15020000034016 | 1 | M. | Aurélien | Royal | ||
| 15020000034018 | L15/amo20 | 15 | 15020000033948 | 15020000034016 | 2 | M. | Dacruz | Baloa | ||
| 15020000034019 | L15/amo20 | 15 | 15020000033948 | 15020000034016 | 3 | Mme | Magali | Lassalvy | ||
| 15020000034020 | L15/amo20 | 15 | 15020000033948 | 15020000034016 | 4 | Mme | Khrystyna | Korin | ||
| 15020000034086 | L15/amo20 | 15 | 15020000034021 | 15020000034085 | 1 | M. | Benjamin | Vandekerckhove | ||
| 15020000034087 | L15/amo20 | 15 | 15020000034021 | 15020000034085 | 2 | Mme | Fatima | Belaïdi | ||
| 15020000034088 | L15/amo20 | 15 | 15020000034021 | 15020000034085 | 3 | Mme | Stéphanie | Messineo | ||
| 15020000034089 | L15/amo20 | 15 | 15020000034021 | 15020000034085 | 4 | M. | Rémy | Fleury | ||
| 15020000034090 | L15/amo20 | 15 | 15020000034021 | 15020000034085 | 5 | Mme | Laura | Czapara | ||
| 15020000034139 | L15/amo20 | 15 | 15020000034091 | 15020000034138 | 1 | Mme | Catherine | Hurstel | ||
| 15020000034140 | L15/amo20 | 15 | 15020000034091 | 15020000034138 | 2 | M. | Emmanuel | Bertin | ||
| 15020000034141 | L15/amo20 | 15 | 15020000034091 | 15020000034138 | 3 | Mme | Yolande | Houver | ||
| 15020000034142 | L15/amo20 | 15 | 15020000034091 | 15020000034138 | 4 | M. | Corentin | Przybylski | ||
| 15020000034208 | L15/amo20 | 15 | 15020000034143 | 15020000034207 | 1 | Mme | Poerava | Meunier | ||
| 15020000034209 | L15/amo20 | 15 | 15020000034143 | 15020000034207 | 2 | Mme | Anouck | Camain | ||
| 15020000034272 | L15/amo20 | 15 | 15020000034210 | 15020000034271 | 1 | Mme | Isabelle | Lescalle | ||
| 15020000034273 | L15/amo20 | 15 | 15020000034210 | 15020000034271 | 2 | M. | Charles | Herrbach | ||
| 15020000034274 | L15/amo20 | 15 | 15020000034210 | 15020000034271 | 3 | Mme | Marion | Lescalle | ||
| 15020000034345 | L15/amo20 | 15 | 15020000034275 | 15020000034344 | 1 | M. | Jérôme | Furet | ||
| 15020000034346 | L15/amo20 | 15 | 15020000034275 | 15020000034344 | 2 | M. | Cédric | Pruvost | ||
| 15020000034347 | L15/amo20 | 15 | 15020000034275 | 15020000034344 | 3 | Mme | Océane | Rouxel | ||
| 15020000034467 | L15/amo20 | 15 | 15020000034348 | 15020000034466 | 1 | Mme | Delphine | Morelle-Hanryon | ||
| 15020000034468 | L15/amo20 | 15 | 15020000034348 | 15020000034466 | 2 | Mme | Maryline | Lima | ||
| 15020000034469 | L15/amo20 | 15 | 15020000034348 | 15020000034466 | 3 | M. | Tariel | Vatchadzé | ||
| 15020000034470 | L15/amo20 | 15 | 15020000034348 | 15020000034466 | 4 | Mme | Camille | Florentin | ||
| 15020000034544 | L15/amo20 | 15 | 15020000034471 | 15020000034543 | 1 | Mme | Marie | Deffontaines | ||
| 15020000034545 | L15/amo20 | 15 | 15020000034471 | 15020000034543 | 2 | M. | Baptiste | Lasala | ||
| 15020000034612 | L15/amo20 | 15 | 15020000034546 | 15020000034611 | 1 | M. | Ludovic | Declercq | ||
| 15020000034613 | L15/amo20 | 15 | 15020000034546 | 15020000034611 | 2 | Mme | Dorothée | Morel | ||
| 15020000034614 | L15/amo20 | 15 | 15020000034546 | 15020000034611 | 3 | M. | Marc | Desramaut | ||
| 15020000034615 | L15/amo20 | 15 | 15020000034546 | 15020000034611 | 4 | M. | Kenny | Kremer | ||
| 15020000034679 | L15/amo20 | 15 | 15020000034653 | 15020000034678 | 1 | Mme | Christelle | Laly Duhaut | ||
| 15020000034680 | L15/amo20 | 15 | 15020000034653 | 15020000034678 | 2 | M. | Pierre | Deniau | ||
| 15020000034681 | L15/amo20 | 15 | 15020000034653 | 15020000034678 | 3 | M. | Hugo | Meurin | ||
| 15020000034912 | L15/amo20 | 15 | 15020000034699 | 15020000034911 | 1 | M. | Tony | Granzotto | ||
| 15020000034913 | L15/amo20 | 15 | 15020000034699 | 15020000034911 | 2 | Mme | Catherine | Bernard | ||
| 15020000034914 | L15/amo20 | 15 | 15020000034699 | 15020000034911 | 3 | M. | Matthias | Hammou-N'Aïcha-Matron | ||
| 15020000034915 | L15/amo20 | 15 | 15020000034699 | 15020000034911 | 4 | M. | Florian | Leclercq | ||
| 15020000034993 | L15/amo20 | 15 | 15020000034916 | 15020000034992 | 1 | Mme | Virginie | Larsonnier | ||
| 15020000034994 | L15/amo20 | 15 | 15020000034916 | 15020000034992 | 2 | M. | Benjamin | Locatelli | ||
| 15020000034995 | L15/amo20 | 15 | 15020000034916 | 15020000034992 | 3 | Mme | Catherine | Pierru | ||
| 15020000034996 | L15/amo20 | 15 | 15020000034916 | 15020000034992 | 4 | Mme | Noémie | Thomas | ||
| 15020000035056 | L15/amo20 | 15 | 15020000035007 | 15020000035055 | 1 | M. | Maxime | Guilmin |