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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 15020000023156 | L15/amo20 | 15 | 15020000023107 | 15020000023154 | 2 | M. | Paul | Brounais | ||
| 15020000023157 | L15/amo20 | 15 | 15020000023107 | 15020000023154 | 3 | M. | Mathieu | Trouillard | ||
| 15020000023158 | L15/amo20 | 15 | 15020000023107 | 15020000023154 | 4 | Mme | Jessica | Tlemsani | ||
| 15020000023213 | L15/amo20 | 15 | 15020000023159 | 15020000023212 | 1 | M. | Romain | Prax | ||
| 15020000023214 | L15/amo20 | 15 | 15020000023159 | 15020000023212 | 2 | Mme | Tatiana | Vivier-Paulange | ||
| 15020000023215 | L15/amo20 | 15 | 15020000023159 | 15020000023212 | 3 | Mme | Anne | Boyer | ||
| 15020000023275 | L15/amo20 | 15 | 15020000023216 | 15020000023274 | 1 | Mme | Elisabeth | Riom | ||
| 15020000023276 | L15/amo20 | 15 | 15020000023216 | 15020000023274 | 2 | Mme | Emilie | Vieuille | ||
| 15020000023277 | L15/amo20 | 15 | 15020000023216 | 15020000023274 | 3 | M. | Daniel | Perron | ||
| 15020000023355 | L15/amo20 | 15 | 15020000023278 | 15020000023354 | 1 | Mme | Agata | Wozniak | ||
| 15020000023356 | L15/amo20 | 15 | 15020000023278 | 15020000023354 | 2 | Mme | Maryline | Tindille | ||
| 15020000023357 | L15/amo20 | 15 | 15020000023278 | 15020000023354 | 3 | M. | Corentin | Marron | ||
| 15020000023419 | L15/amo20 | 15 | 15020000023358 | 15020000023418 | 1 | Mme | Marie | Milan | ||
| 15020000023420 | L15/amo20 | 15 | 15020000023358 | 15020000023418 | 2 | Mme | Juliette | Parizot | ||
| 15020000023421 | L15/amo20 | 15 | 15020000023358 | 15020000023418 | 3 | Mme | Brigitte | Hyon | ||
| 15020000023474 | L15/amo20 | 15 | 15020000023422 | 15020000023473 | 1 | M. | Tarik | Belkadi | ||
| 15020000023475 | L15/amo20 | 15 | 15020000023422 | 15020000023473 | 2 | Mme | Aurélie | Lecointre | ||
| 15020000023476 | L15/amo20 | 15 | 15020000023422 | 15020000023473 | 3 | M. | Simon | Mauger | ||
| 15020000023477 | L15/amo20 | 15 | 15020000023422 | 15020000023473 | 4 | M. | Frédéric | Richard | ||
| 15020000023540 | L15/amo20 | 15 | 15020000023478 | 15020000023539 | 1 | M. | Maxime | Da Silva | ||
| 15020000023541 | L15/amo20 | 15 | 15020000023478 | 15020000023539 | 2 | M. | Fabien | Collin | ||
| 15020000023542 | L15/amo20 | 15 | 15020000023478 | 15020000023539 | 3 | Mme | Anaïs | Souquet | ||
| 15020000023610 | L15/amo20 | 15 | 15020000023543 | 15020000023609 | 1 | Mme | Delphine | Bonn | ||
| 15020000023611 | L15/amo20 | 15 | 15020000023543 | 15020000023609 | 2 | M. | Nicolas | Bideaux | ||
| 15020000023612 | L15/amo20 | 15 | 15020000023543 | 15020000023609 | 3 | Mme | Alexandra | Bélateche | ||
| 15020000023658 | L15/amo20 | 15 | 15020000023613 | 15020000023657 | 1 | Mme | Anne | Leboulanger | ||
| 15020000023659 | L15/amo20 | 15 | 15020000023613 | 15020000023657 | 2 | M. | Stéphane | Grillat | ||
| 15020000023706 | L15/amo20 | 15 | 15020000023660 | 15020000023705 | 1 | M. | Manuel | Eynard | ||
| 15020000023707 | L15/amo20 | 15 | 15020000023660 | 15020000023705 | 2 | M. | Antoine | Malet | ||
| 15020000023760 | L15/amo20 | 15 | 15020000023708 | 15020000023759 | 1 | Mme | Caroline | Puisségur-Ripet | ||
| 15020000023761 | L15/amo20 | 15 | 15020000023708 | 15020000023759 | 2 | Mme | Julie | Phan-Pérain | ||
| 15020000023762 | L15/amo20 | 15 | 15020000023708 | 15020000023759 | 3 | M. | Luc | Derai | ||
| 15020000023817 | L15/amo20 | 15 | 15020000023763 | 15020000023816 | 1 | Mme | Pascale | Assante | ||
| 15020000023818 | L15/amo20 | 15 | 15020000023763 | 15020000023816 | 2 | Mme | Mélissa | Lotz | ||
| 15020000023819 | L15/amo20 | 15 | 15020000023763 | 15020000023816 | 3 | Mme | Agatha | Granddidier | ||
| 15020000023882 | L15/amo20 | 15 | 15020000023820 | 15020000023881 | 1 | M. | Wiktor | Zamojski | ||
| 15020000023883 | L15/amo20 | 15 | 15020000023820 | 15020000023881 | 2 | M. | Gérard | Blanc | ||
| 15020000023884 | L15/amo20 | 15 | 15020000023820 | 15020000023881 | 3 | M. | Axel | Nys | ||
| 15020000023885 | L15/amo20 | 15 | 15020000023820 | 15020000023881 | 4 | Mme | Melody | Foubert | ||
| 15020000023986 | L15/amo20 | 15 | 15020000023886 | 15020000023985 | 1 | Mme | Nathalie | Lefebvre | ||
| 15020000023987 | L15/amo20 | 15 | 15020000023886 | 15020000023985 | 2 | M. | Jean-Jacques | Boujot | ||
| 15020000023988 | L15/amo20 | 15 | 15020000023886 | 15020000023985 | 3 | Mme | Marie-France | Nunez | ||
| 15020000023989 | L15/amo20 | 15 | 15020000023886 | 15020000023985 | 4 | Mme | Anne | Jouve | ||
| 15020000024041 | L15/amo20 | 15 | 15020000023990 | 15020000024040 | 1 | M. | Sylvain | Wellhoff | ||
| 15020000024042 | L15/amo20 | 15 | 15020000023990 | 15020000024040 | 2 | Mme | Caroline | Onnis | ||
| 15020000024043 | L15/amo20 | 15 | 15020000023990 | 15020000024040 | 3 | M. | Georges | Gosselin | ||
| 15020000024081 | L15/amo20 | 15 | 15020000024044 | 15020000024080 | 1 | M. | Nicolas | Caure le Graet | ||
| 15020000024082 | L15/amo20 | 15 | 15020000024044 | 15020000024080 | 2 | Mme | Fanny | Diadema | ||
| 15020000024083 | L15/amo20 | 15 | 15020000024044 | 15020000024080 | 3 | Mme | Elsa | Pariente | ||
| 15020000024120 | L15/amo20 | 15 | 15020000024084 | 15020000024119 | 1 | Mme | Rachida | Tir |