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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 15020000009302 | L15/amo20 | 15 | 15020000009240 | 15020000009298 | 4 | Mme | Laury | Saladin | ||
| 15020000009363 | L15/amo20 | 15 | 15020000009303 | 15020000009362 | 1 | Mme | Savine | Bénard-Bienvenu | ||
| 15020000009364 | L15/amo20 | 15 | 15020000009303 | 15020000009362 | 2 | M. | Pascal | Piganiol | ||
| 15020000009365 | L15/amo20 | 15 | 15020000009303 | 15020000009362 | 3 | Mme | Sylvie | Lachaize | ||
| 15020000009605 | L15/amo20 | 15 | 15020000009514 | 15020000009604 | 1 | M. | Serge | Cornette | ||
| 15020000009606 | L15/amo20 | 15 | 15020000009514 | 15020000009604 | 2 | Mme | Maryse | David | ||
| 15020000009607 | L15/amo20 | 15 | 15020000009514 | 15020000009604 | 3 | M. | Clément | Haquet | ||
| 15020000009608 | L15/amo20 | 15 | 15020000009514 | 15020000009604 | 4 | Mme | Christiane | Bonsergent | ||
| 15020000009609 | L15/amo20 | 15 | 15020000009514 | 15020000009604 | 5 | Mme | Mélanie | Lefebvre | ||
| 15020000009665 | L15/amo20 | 15 | 15020000009610 | 15020000009664 | 1 | Mme | Mathilde | Tolsan | ||
| 15020000009666 | L15/amo20 | 15 | 15020000009610 | 15020000009664 | 2 | Mme | Marie | Vanderchmitt | ||
| 15020000009667 | L15/amo20 | 15 | 15020000009610 | 15020000009664 | 3 | Mme | Catherine | Van de Keere | ||
| 15020000009747 | L15/amo20 | 15 | 15020000009668 | 15020000009746 | 1 | Mme | Florence | Dubois | ||
| 15020000009748 | L15/amo20 | 15 | 15020000009668 | 15020000009746 | 2 | M. | Ulysse | Gouret | ||
| 15020000009749 | L15/amo20 | 15 | 15020000009668 | 15020000009746 | 3 | Mme | Joséphine | Perrel | ||
| 15020000009857 | L15/amo20 | 15 | 15020000009750 | 15020000009856 | 1 | M. | Sébastien | Bonjour | ||
| 15020000009858 | L15/amo20 | 15 | 15020000009750 | 15020000009856 | 2 | M. | Raynald | Hottegindre | ||
| 15020000009859 | L15/amo20 | 15 | 15020000009750 | 15020000009856 | 3 | Mme | Clémentine | Verron | ||
| 15020000009946 | L15/amo20 | 15 | 15020000009860 | 15020000009945 | 1 | M. | Julien | Joassard | ||
| 15020000009947 | L15/amo20 | 15 | 15020000009860 | 15020000009945 | 2 | Mme | Isabelle | Dumestre | ||
| 15020000009948 | L15/amo20 | 15 | 15020000009860 | 15020000009945 | 3 | Mme | Blandine | Mounier | ||
| 15020000009949 | L15/amo20 | 15 | 15020000009860 | 15020000009945 | 4 | M. | Rayane | Guerboub | ||
| 15020000010027 | L15/amo20 | 15 | 15020000009950 | 15020000010026 | 1 | M. | Eric | Fallourd | ||
| 15020000010028 | L15/amo20 | 15 | 15020000009950 | 15020000010026 | 2 | M. | Paul | Hervy | ||
| 15020000010126 | L15/amo20 | 15 | 15020000010029 | 15020000010125 | 1 | Mme | Rachel | Mehaignerie | ||
| 15020000010127 | L15/amo20 | 15 | 15020000010029 | 15020000010125 | 2 | Mme | Pascale | Cupif | ||
| 15020000010128 | L15/amo20 | 15 | 15020000010029 | 15020000010125 | 3 | M. | Augustin | Moreau | ||
| 15020000010216 | L15/amo20 | 15 | 15020000010129 | 15020000010215 | 1 | Mme | Agathe | Colin | ||
| 15020000010217 | L15/amo20 | 15 | 15020000010129 | 15020000010215 | 2 | Mme | Alice | Bénard | ||
| 15020000010218 | L15/amo20 | 15 | 15020000010129 | 15020000010215 | 3 | Mme | Audrey | Jacamant | ||
| 15020000010219 | L15/amo20 | 15 | 15020000010129 | 15020000010215 | 4 | M. | Guillaume | Fillon | ||
| 15020000010297 | L15/amo20 | 15 | 15020000010220 | 15020000010296 | 1 | Mme | Martine | Douillé | ||
| 15020000010298 | L15/amo20 | 15 | 15020000010220 | 15020000010296 | 2 | M. | Claude | Nicolet | ||
| 15020000010359 | L15/amo20 | 15 | 15020000010299 | 15020000010358 | 1 | M. | Daniel | Lemai-Ducrocq | ||
| 15020000010360 | L15/amo20 | 15 | 15020000010299 | 15020000010358 | 2 | M. | Frédéric | Olivier | ||
| 15020000010361 | L15/amo20 | 15 | 15020000010299 | 15020000010358 | 3 | Mme | Justine | Pitre | ||
| 15020000010642 | L15/amo20 | 15 | 15020000010566 | 15020000010641 | 1 | Mme | Sarah | Peillon | ||
| 15020000010643 | L15/amo20 | 15 | 15020000010566 | 15020000010641 | 2 | Mme | Nathalie | Robert | ||
| 15020000010644 | L15/amo20 | 15 | 15020000010566 | 15020000010641 | 3 | M. | Fabien | Gueguen | ||
| 15020000010944 | L15/amo20 | 15 | 15020000010799 | 15020000010943 | 1 | M. | Claude | Chatonnay | ||
| 15020000010945 | L15/amo20 | 15 | 15020000010799 | 15020000010943 | 2 | Mme | Léa | Garnier | ||
| 15020000010946 | L15/amo20 | 15 | 15020000010799 | 15020000010943 | 3 | Mme | Isabelle | Garsmeur | ||
| 15020000011103 | L15/amo20 | 15 | 15020000011004 | 15020000011102 | 1 | M. | Simon | Desmarest | ||
| 15020000011104 | L15/amo20 | 15 | 15020000011004 | 15020000011102 | 2 | M. | Sébastien | Giard | ||
| 15020000011105 | L15/amo20 | 15 | 15020000011004 | 15020000011102 | 3 | Mme | Angela | Héranval | ||
| 15020000011223 | L15/amo20 | 15 | 15020000011156 | 15020000011222 | 1 | M. | Mathieu | Havsali | ||
| 15020000011224 | L15/amo20 | 15 | 15020000011156 | 15020000011222 | 2 | M. | Etienne | Juin | ||
| 15020000011225 | L15/amo20 | 15 | 15020000011156 | 15020000011222 | 3 | Mme | Marylène | Simonnet | ||
| 15020000011226 | L15/amo20 | 15 | 15020000011156 | 15020000011222 | 4 | Mme | Nina | Géron | ||
| 15020000011278 | L15/amo20 | 15 | 15020000011228 | 15020000011277 | 1 | Mme | Lucie | Fournel |