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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 15020000039775 | L15/amo20 | 15 | 15020000039733 | 15020000039771 | 4 | M. | David | Ouzilou | ||
| 15020000039831 | L15/amo20 | 15 | 15020000039781 | 15020000039830 | 1 | Mme | Clara | Avenant | ||
| 15020000039832 | L15/amo20 | 15 | 15020000039781 | 15020000039830 | 2 | Mme | Véronique | Godard | ||
| 15020000039889 | L15/amo20 | 15 | 15020000039833 | 15020000039888 | 1 | M. | David | Petit | ||
| 15020000039890 | L15/amo20 | 15 | 15020000039833 | 15020000039888 | 2 | Mme | Marielle | Bergeron | ||
| 15020000039891 | L15/amo20 | 15 | 15020000039833 | 15020000039888 | 3 | M. | Sébastien | Pignier-Tracol | ||
| 15020000039892 | L15/amo20 | 15 | 15020000039833 | 15020000039888 | 4 | Mme | Delphine | Guillaume | ||
| 15020000039932 | L15/amo20 | 15 | 15020000039893 | 15020000039931 | 1 | Mme | Catherine | Gollnhofer | ||
| 15020000039933 | L15/amo20 | 15 | 15020000039893 | 15020000039931 | 2 | Mme | Isabelle | Lannes-Brun | ||
| 15020000039934 | L15/amo20 | 15 | 15020000039893 | 15020000039931 | 3 | Mme | Valentine | Favre-Bonté | ||
| 15020000039996 | L15/amo20 | 15 | 15020000039935 | 15020000039995 | 1 | Mme | Hélène | Jacquot | ||
| 15020000039997 | L15/amo20 | 15 | 15020000039935 | 15020000039995 | 2 | M. | Victor | Worms | ||
| 15020000039998 | L15/amo20 | 15 | 15020000039935 | 15020000039995 | 3 | Mme | Géraldine | Lehideux | ||
| 15020000039999 | L15/amo20 | 15 | 15020000039935 | 15020000039995 | 4 | M. | François-Xavier | Pénicaud | ||
| 15020000040064 | L15/amo20 | 15 | 15020000040000 | 15020000040063 | 1 | Mme | Sandrine | Arnoux-Herlemont | ||
| 15020000040065 | L15/amo20 | 15 | 15020000040000 | 15020000040063 | 2 | M. | Mickaël | Levy | ||
| 15020000040066 | L15/amo20 | 15 | 15020000040000 | 15020000040063 | 3 | Mme | Nathalie | Philibert | ||
| 15020000040112 | L15/amo20 | 15 | 15020000040106 | 15020000040111 | 1 | M. | Benoît | Rudinger | ||
| 15020000040124 | L15/amo20 | 15 | 15020000040113 | 15020000040123 | 1 | Mme | Mélanie | Mancera | ||
| 15020000040125 | L15/amo20 | 15 | 15020000040113 | 15020000040123 | 2 | Mme | Stéphanie | Delacquis | ||
| 15020000040126 | L15/amo20 | 15 | 15020000040113 | 15020000040123 | 3 | Mme | Laurie | Brand | ||
| 15020000040205 | L15/amo20 | 15 | 15020000040127 | 15020000040204 | 1 | Mme | Kheidi | Bentamra | ||
| 15020000040206 | L15/amo20 | 15 | 15020000040127 | 15020000040204 | 2 | Mme | Myriam | Clerc | ||
| 15020000040263 | L15/amo20 | 15 | 15020000040207 | 15020000040262 | 1 | Mme | Sabine | Miquet | ||
| 15020000040264 | L15/amo20 | 15 | 15020000040207 | 15020000040262 | 2 | M. | Basile | Dunand | ||
| 15020000040265 | L15/amo20 | 15 | 15020000040207 | 15020000040262 | 3 | Mme | Coraline | Lohat | ||
| 15020000040297 | L15/amo20 | 15 | 15020000040266 | 15020000040296 | 1 | M. | Simon | Albert | ||
| 15020000040298 | L15/amo20 | 15 | 15020000040266 | 15020000040296 | 2 | Mme | Marie | Malysse | ||
| 15020000040299 | L15/amo20 | 15 | 15020000040266 | 15020000040296 | 3 | M. | Célestin | Neyroud | ||
| 15020000040385 | L15/amo20 | 15 | 15020000040300 | 15020000040384 | 1 | Mme | Juliette | Devedeux | ||
| 15020000040386 | L15/amo20 | 15 | 15020000040300 | 15020000040384 | 2 | Mme | Camille | Robert | ||
| 15020000040387 | L15/amo20 | 15 | 15020000040300 | 15020000040384 | 3 | M. | Aurélien | Bétis | ||
| 15020000040388 | L15/amo20 | 15 | 15020000040300 | 15020000040384 | 4 | Mme | Sandra | Colombier | ||
| 15020000040504 | L15/amo20 | 15 | 15020000040389 | 15020000040503 | 1 | Mme | Patricia | Ferry | ||
| 15020000040505 | L15/amo20 | 15 | 15020000040389 | 15020000040503 | 2 | M. | Florent | Frantz | ||
| 15020000040506 | L15/amo20 | 15 | 15020000040389 | 15020000040503 | 3 | Mme | Chloé | Bouley | ||
| 15020000040507 | L15/amo20 | 15 | 15020000040389 | 15020000040503 | 4 | M. | Eric | Constantin | ||
| 15020000040537 | L15/amo20 | 15 | 15020000040508 | 15020000040536 | 1 | Mme | Manon | Martinez | ||
| 15020000040538 | L15/amo20 | 15 | 15020000040508 | 15020000040536 | 2 | Mme | Aline | Leveque | ||
| 15020000040605 | L15/amo20 | 15 | 15020000040539 | 15020000040604 | 1 | M. | Paul | Schmidtke | ||
| 15020000040606 | L15/amo20 | 15 | 15020000040539 | 15020000040604 | 2 | Mme | Aurélie | Belot | ||
| 15020000040671 | L15/amo20 | 15 | 15020000040607 | 15020000040670 | 1 | M. | Antoine | Vadrot | ||
| 15020000040672 | L15/amo20 | 15 | 15020000040607 | 15020000040670 | 2 | Mme | Emmanuelle | Olivier | ||
| 15020000040673 | L15/amo20 | 15 | 15020000040607 | 15020000040670 | 3 | M. | Franck | Boitelle | ||
| 15020000040674 | L15/amo20 | 15 | 15020000040607 | 15020000040670 | 4 | Mme | Marianne | Darmon | ||
| 15020000040731 | L15/amo20 | 15 | 15020000040675 | 15020000040730 | 1 | M. | Philippe | Cavé | ||
| 15020000040732 | L15/amo20 | 15 | 15020000040675 | 15020000040730 | 2 | Mme | Aurélie | Bennetot | ||
| 15020000040733 | L15/amo20 | 15 | 15020000040675 | 15020000040730 | 3 | Mme | Ève | Moreels | ||
| 15020000040734 | L15/amo20 | 15 | 15020000040675 | 15020000040730 | 4 | M. | Aurélien | Bénard | ||
| 15020000040735 | L15/amo20 | 15 | 15020000040675 | 15020000040730 | 5 | M. | Thibault | Montaron |