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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 15020000032089 | L15/amo20 | 15 | 15020000032010 | 15020000032088 | 1 | Mme | Laura | Bonnemains | ||
| 15020000032090 | L15/amo20 | 15 | 15020000032010 | 15020000032088 | 2 | Mme | Marie-Laure | Gouhier | ||
| 15020000032136 | L15/amo20 | 15 | 15020000032091 | 15020000032135 | 1 | Mme | Christine | Franzin | ||
| 15020000032137 | L15/amo20 | 15 | 15020000032091 | 15020000032135 | 2 | M. | Roger | Pécout | ||
| 15020000032138 | L15/amo20 | 15 | 15020000032091 | 15020000032135 | 3 | Mme | Jade | Delaitre | ||
| 15020000032139 | L15/amo20 | 15 | 15020000032091 | 15020000032135 | 4 | M. | Pierre | Ceugniet | ||
| 15020000032191 | L15/amo20 | 15 | 15020000032140 | 15020000032190 | 1 | M. | Youri | Philip | ||
| 15020000032246 | L15/amo20 | 15 | 15020000032192 | 15020000032245 | 1 | M. | Etienne | Bertin | ||
| 15020000032311 | L15/amo20 | 15 | 15020000032247 | 15020000032310 | 1 | Mme | Elodie | Trembley | ||
| 15020000032312 | L15/amo20 | 15 | 15020000032247 | 15020000032310 | 2 | Mme | Clotilde | Gerbaux | ||
| 15020000032313 | L15/amo20 | 15 | 15020000032247 | 15020000032310 | 3 | M. | Lucas | Le Roux | ||
| 15020000032408 | L15/amo20 | 15 | 15020000032382 | 15020000032407 | 1 | Mme | Claire | Colliat | ||
| 15020000032409 | L15/amo20 | 15 | 15020000032382 | 15020000032407 | 2 | M. | Esteban | Kollar | ||
| 15020000032451 | L15/amo20 | 15 | 15020000032410 | 15020000032450 | 1 | Mme | Stéphanie | Garot | ||
| 15020000032529 | L15/amo20 | 15 | 15020000032452 | 15020000032528 | 1 | Mme | Laurence | Marquis | ||
| 15020000032530 | L15/amo20 | 15 | 15020000032452 | 15020000032528 | 2 | Mme | Farah | Hamidani | ||
| 15020000032531 | L15/amo20 | 15 | 15020000032452 | 15020000032528 | 3 | M. | Stéphane | Mazeaufroid-Boulestin | ||
| 15020000032532 | L15/amo20 | 15 | 15020000032452 | 15020000032528 | 4 | Mme | Monira | Taleb | ||
| 15020000032533 | L15/amo20 | 15 | 15020000032452 | 15020000032528 | 5 | Mme | Salwa | Lakrafi | ||
| 15020000032581 | L15/amo20 | 15 | 15020000032534 | 15020000032580 | 1 | Mme | Emeline | Robert | ||
| 15020000032582 | L15/amo20 | 15 | 15020000032534 | 15020000032580 | 2 | M. | David | Georget | ||
| 15020000032583 | L15/amo20 | 15 | 15020000032534 | 15020000032580 | 3 | M. | David | Glotin | ||
| 15020000032584 | L15/amo20 | 15 | 15020000032534 | 15020000032580 | 4 | M. | Hugo | Viel | ||
| 15020000032635 | L15/amo20 | 15 | 15020000032585 | 15020000032634 | 1 | Mme | Sandrine | Hirschler | ||
| 15020000032636 | L15/amo20 | 15 | 15020000032585 | 15020000032634 | 2 | M. | Antoine | Parrot | ||
| 15020000032637 | L15/amo20 | 15 | 15020000032585 | 15020000032634 | 3 | M. | Patrick | Dorville | ||
| 15020000032692 | L15/amo20 | 15 | 15020000032638 | 15020000032691 | 1 | Mme | Roxane | Jacqueray | ||
| 15020000032693 | L15/amo20 | 15 | 15020000032638 | 15020000032691 | 2 | Mme | Nina | Plantin | ||
| 15020000032694 | L15/amo20 | 15 | 15020000032638 | 15020000032691 | 3 | M. | Moïse | Medallel | ||
| 15020000032725 | L15/amo20 | 15 | 15020000032695 | 15020000032724 | 1 | M. | Thomas | Patti | ||
| 15020000032726 | L15/amo20 | 15 | 15020000032695 | 15020000032724 | 2 | Mme | Martine | Kirchhoff | ||
| 15020000032727 | L15/amo20 | 15 | 15020000032695 | 15020000032724 | 3 | Mme | Patricia | Serek | ||
| 15020000032728 | L15/amo20 | 15 | 15020000032695 | 15020000032724 | 4 | M. | Léopold | Nusse | ||
| 15020000032729 | L15/amo20 | 15 | 15020000032695 | 15020000032724 | 5 | Mme | Nicole | Muller-Becker | ||
| 15020000032730 | L15/amo20 | 15 | 15020000032695 | 15020000032724 | 6 | Mme | Sebil | Sahin-Tortum | ||
| 15020000032784 | L15/amo20 | 15 | 15020000032731 | 15020000032783 | 1 | Mme | Nathalie | Adam | ||
| 15020000032785 | L15/amo20 | 15 | 15020000032731 | 15020000032783 | 2 | Mme | Tressia | Goetz | ||
| 15020000032786 | L15/amo20 | 15 | 15020000032731 | 15020000032783 | 3 | Mme | Charlie | Trisse | ||
| 15020000032884 | L15/amo20 | 15 | 15020000032787 | 15020000032883 | 1 | Mme | Isabelle | Desvignes | ||
| 15020000032885 | L15/amo20 | 15 | 15020000032787 | 15020000032883 | 2 | Mme | Rébecca | Neisse | ||
| 15020000032886 | L15/amo20 | 15 | 15020000032787 | 15020000032883 | 3 | M. | Pierre | Piton | ||
| 15020000032887 | L15/amo20 | 15 | 15020000032787 | 15020000032883 | 4 | Mme | Dorine | Ramos | ||
| 15020000032924 | L15/amo20 | 15 | 15020000032888 | 15020000032923 | 1 | Mme | Claudie | Le Bohec | ||
| 15020000032925 | L15/amo20 | 15 | 15020000032888 | 15020000032923 | 2 | M. | Thibaud | Soret | ||
| 15020000032926 | L15/amo20 | 15 | 15020000032888 | 15020000032923 | 3 | M. | Yves | Niort | ||
| 15020000032987 | L15/amo20 | 15 | 15020000032927 | 15020000032986 | 1 | M. | Cédric | Martin | ||
| 15020000032988 | L15/amo20 | 15 | 15020000032927 | 15020000032986 | 2 | M. | Thomas | Mogharaei | ||
| 15020000032989 | L15/amo20 | 15 | 15020000032927 | 15020000032986 | 3 | M. | Quentin | Jarno | ||
| 15020000032990 | L15/amo20 | 15 | 15020000032927 | 15020000032986 | 4 | Mme | Elsa | Le Pallec | ||
| 15020000033034 | L15/amo20 | 15 | 15020000032991 | 15020000033033 | 1 | Mme | Nadia | Souffoy |