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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 15020000045023 | L15/amo20 | 15 | 15020000044987 | 15020000045022 | 1 | Mme | Clémence | Lisambert | ||
| 15020000045024 | L15/amo20 | 15 | 15020000044987 | 15020000045022 | 2 | Mme | Sophie | Barbier | ||
| 15020000045097 | L15/amo20 | 15 | 15020000045025 | 15020000045096 | 1 | Mme | Isabelle | Sotto | ||
| 15020000045098 | L15/amo20 | 15 | 15020000045025 | 15020000045096 | 2 | M. | François | Lacombe | ||
| 15020000045099 | L15/amo20 | 15 | 15020000045025 | 15020000045096 | 3 | M. | Benoît | Cassorla | ||
| 15020000045100 | L15/amo20 | 15 | 15020000045025 | 15020000045096 | 4 | Mme | Ariane | Lecerf | ||
| 15020000045190 | L15/amo20 | 15 | 15020000045147 | 15020000045189 | 1 | Mme | Agnès | Copin | ||
| 15020000045191 | L15/amo20 | 15 | 15020000045147 | 15020000045189 | 2 | M. | Romain | Plusse | ||
| 15020000045192 | L15/amo20 | 15 | 15020000045147 | 15020000045189 | 3 | Mme | Alexandra | Rivalain | ||
| 15020000045268 | L15/amo20 | 15 | 15020000045199 | 15020000045267 | 1 | M. | Damien | Becquart | ||
| 15020000045269 | L15/amo20 | 15 | 15020000045199 | 15020000045267 | 2 | Mme | Fatima | Belaïdi | ||
| 15020000045270 | L15/amo20 | 15 | 15020000045199 | 15020000045267 | 3 | Mme | Julie | Avenel | ||
| 15020000045271 | L15/amo20 | 15 | 15020000045199 | 15020000045267 | 4 | Mme | Sarah | Khedimallah | ||
| 15020000045272 | L15/amo20 | 15 | 15020000045199 | 15020000045267 | 5 | M. | Valentin | Rieu | ||
| 15020000045285 | L15/amo20 | 15 | 15020000045273 | 15020000045284 | 1 | Mme | Sabine | Tirmarche | ||
| 15020000045286 | L15/amo20 | 15 | 15020000045273 | 15020000045284 | 2 | Mme | Emmanuelle | Steuperaert | ||
| 15020000045362 | L15/amo20 | 15 | 15020000045287 | 15020000045361 | 1 | M. | Nicolas | Blin | ||
| 15020000045363 | L15/amo20 | 15 | 15020000045287 | 15020000045361 | 2 | M. | Amar | Rezki | ||
| 15020000045364 | L15/amo20 | 15 | 15020000045287 | 15020000045361 | 3 | Mme | Catherine | Lebegue | ||
| 15020000045430 | L15/amo20 | 15 | 15020000045410 | 15020000045429 | 1 | Mme | Stéphanie | Boisserie | ||
| 15020000045431 | L15/amo20 | 15 | 15020000045410 | 15020000045429 | 2 | M. | Victor | Guilbert | ||
| 15020000045432 | L15/amo20 | 15 | 15020000045410 | 15020000045429 | 3 | M. | Azedine | Ghobrini | ||
| 15020000045433 | L15/amo20 | 15 | 15020000045410 | 15020000045429 | 4 | Mme | Lucy | Jalouneix | ||
| 15020000045434 | L15/amo20 | 15 | 15020000045410 | 15020000045429 | 5 | M. | Florian | Privat | ||
| 15020000045468 | L15/amo20 | 15 | 15020000045435 | 15020000045467 | 1 | M. | Mickaël | Bouet | ||
| 15020000045469 | L15/amo20 | 15 | 15020000045435 | 15020000045467 | 2 | M. | Stéphane | Dupic | ||
| 15020000045470 | L15/amo20 | 15 | 15020000045435 | 15020000045467 | 3 | M. | Pierre-François | Allart | ||
| 15020000045519 | L15/amo20 | 15 | 15020000045471 | 15020000045518 | 1 | Mme | Ingrid | Lanoë | ||
| 15020000045520 | L15/amo20 | 15 | 15020000045471 | 15020000045518 | 2 | Mme | Christelle | Pouliquen | ||
| 15020000045521 | L15/amo20 | 15 | 15020000045471 | 15020000045518 | 3 | Mme | Anne | Martiréné | ||
| 15020000045522 | L15/amo20 | 15 | 15020000045471 | 15020000045518 | 4 | Mme | Anne Sophie | Roquette | ||
| 15020000045523 | L15/amo20 | 15 | 15020000045471 | 15020000045518 | 5 | Mme | Zineb | Mekouar | ||
| 15020000045560 | L15/amo20 | 15 | 15020000045524 | 15020000045559 | 1 | M. | David | Saussol | ||
| 15020000045561 | L15/amo20 | 15 | 15020000045524 | 15020000045559 | 2 | Mme | Anne-Lise | Meurier | ||
| 15020000045562 | L15/amo20 | 15 | 15020000045524 | 15020000045559 | 3 | M. | Samuel | Langlade | ||
| 15020000045626 | L15/amo20 | 15 | 15020000045563 | 15020000045625 | 1 | Mme | Marie | Reis | ||
| 15020000045627 | L15/amo20 | 15 | 15020000045563 | 15020000045625 | 2 | M. | Abel | Duclos | ||
| 15020000045628 | L15/amo20 | 15 | 15020000045563 | 15020000045625 | 3 | Mme | Alice | De la Bourdonnaye | ||
| 15020000045647 | L15/amo20 | 15 | 15020000045629 | 15020000045646 | 1 | M. | Jean | Biehler | ||
| 15020000045648 | L15/amo20 | 15 | 15020000045629 | 15020000045646 | 2 | Mme | Nadège | Heiligenstein | ||
| 15020000045649 | L15/amo20 | 15 | 15020000045629 | 15020000045646 | 3 | M. | Nicolas | Dryll | ||
| 15020000045724 | L15/amo20 | 15 | 15020000045650 | 15020000045723 | 1 | Mme | Marieke | Liebaert | ||
| 15020000045725 | L15/amo20 | 15 | 15020000045650 | 15020000045723 | 2 | Mme | Isabelle | Laferrerie | ||
| 15020000045726 | L15/amo20 | 15 | 15020000045650 | 15020000045723 | 3 | Mme | Barbara | Bourges | ||
| 15020000045727 | L15/amo20 | 15 | 15020000045650 | 15020000045723 | 4 | M. | Paul | Donn | ||
| 15020000045790 | L15/amo20 | 15 | 15020000045728 | 15020000045789 | 1 | M. | Thomas | Montmessin | ||
| 15020000045791 | L15/amo20 | 15 | 15020000045728 | 15020000045789 | 2 | Mme | Sandra | Mondon | ||
| 15020000045867 | L15/amo20 | 15 | 15020000045841 | 15020000045866 | 1 | M. | Paul | Esnault | ||
| 15020000045868 | L15/amo20 | 15 | 15020000045841 | 15020000045866 | 2 | Mme | Nathalie | Meunier | ||
| 15020000045869 | L15/amo20 | 15 | 15020000045841 | 15020000045866 | 3 | M. | Sylvain | Dumord |