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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 15020000043976 | L15/amo20 | 15 | 15020000043935 | 15020000043975 | 1 | M. | Pierre | Cormier | ||
| 15020000043977 | L15/amo20 | 15 | 15020000043935 | 15020000043975 | 2 | Mme | Marjorie | You | ||
| 15020000044013 | L15/amo20 | 15 | 15020000043978 | 15020000044012 | 1 | Mme | Audrey | Terlynck | ||
| 15020000044085 | L15/amo20 | 15 | 15020000044014 | 15020000044084 | 1 | M. | Simon | Goldblat | ||
| 15020000044086 | L15/amo20 | 15 | 15020000044014 | 15020000044084 | 2 | M. | Samir | Belaïd | ||
| 15020000044087 | L15/amo20 | 15 | 15020000044014 | 15020000044084 | 3 | Mme | Pascale | Marcaggi | ||
| 15020000044131 | L15/amo20 | 15 | 15020000044088 | 15020000044130 | 1 | Mme | Aline | Boucault | ||
| 15020000044132 | L15/amo20 | 15 | 15020000044088 | 15020000044130 | 2 | M. | Esteban | Lopez | ||
| 15020000044202 | L15/amo20 | 15 | 15020000044133 | 15020000044201 | 1 | Mme | Anne-Sophie | Ronceret | ||
| 15020000044203 | L15/amo20 | 15 | 15020000044133 | 15020000044201 | 2 | Mme | Maureen | Ruiz | ||
| 15020000044204 | L15/amo20 | 15 | 15020000044133 | 15020000044201 | 3 | Mme | Géraldine | Morisse | ||
| 15020000044205 | L15/amo20 | 15 | 15020000044133 | 15020000044201 | 4 | Mme | Alice | Epstein | ||
| 15020000044282 | L15/amo20 | 15 | 15020000044250 | 15020000044281 | 1 | Mme | Sandrine | Blasque | ||
| 15020000044283 | L15/amo20 | 15 | 15020000044250 | 15020000044281 | 2 | Mme | Julie Johanna | Neonakis | ||
| 15020000044284 | L15/amo20 | 15 | 15020000044250 | 15020000044281 | 3 | Mme | Anaïs | Jatière | ||
| 15020000044323 | L15/amo20 | 15 | 15020000044285 | 15020000044322 | 1 | Mme | Béatrice | Moinard | ||
| 15020000044324 | L15/amo20 | 15 | 15020000044285 | 15020000044322 | 2 | Mme | Anne-Sophie | Bellamy-Biard | ||
| 15020000044365 | L15/amo20 | 15 | 15020000044345 | 15020000044364 | 1 | Mme | Mélanie | Beau-Fournier | ||
| 15020000044366 | L15/amo20 | 15 | 15020000044345 | 15020000044364 | 2 | M. | Samuel | Auzanneau | ||
| 15020000044367 | L15/amo20 | 15 | 15020000044345 | 15020000044364 | 3 | M. | Enrique | Prazian | ||
| 15020000044444 | L15/amo20 | 15 | 15020000044404 | 15020000044443 | 1 | Mme | Françoise | Baumard | ||
| 15020000044445 | L15/amo20 | 15 | 15020000044404 | 15020000044443 | 2 | Mme | Cécile | Mouly | ||
| 15020000044487 | L15/amo20 | 15 | 15020000044446 | 15020000044486 | 1 | M. | David | Courtois | ||
| 15020000044488 | L15/amo20 | 15 | 15020000044446 | 15020000044486 | 2 | Mme | Cécile | Bézat | ||
| 15020000044489 | L15/amo20 | 15 | 15020000044446 | 15020000044486 | 3 | Mme | Gabrielle | Clairon | ||
| 15020000044532 | L15/amo20 | 15 | 15020000044490 | 15020000044531 | 1 | M. | Alban | Bourguignon | ||
| 15020000044533 | L15/amo20 | 15 | 15020000044490 | 15020000044531 | 2 | M. | Matthias | Vazquez | ||
| 15020000044534 | L15/amo20 | 15 | 15020000044490 | 15020000044531 | 3 | Mme | Morgane | Duchesne | ||
| 15020000044624 | L15/amo20 | 15 | 15020000044535 | 15020000044623 | 1 | M. | Jonathan | Thirel | ||
| 15020000044625 | L15/amo20 | 15 | 15020000044535 | 15020000044623 | 2 | Mme | Fatima | Belaïdi | ||
| 15020000044626 | L15/amo20 | 15 | 15020000044535 | 15020000044623 | 3 | Mme | Florence | Goyer | ||
| 15020000044676 | L15/amo20 | 15 | 15020000044627 | 15020000044675 | 1 | Mme | Lucette | Fréry | ||
| 15020000044677 | L15/amo20 | 15 | 15020000044627 | 15020000044675 | 2 | M. | Charles | MORGAT | ||
| 15020000044678 | L15/amo20 | 15 | 15020000044627 | 15020000044675 | 3 | Mme | Joëlle | Hist | ||
| 15020000044729 | L15/amo20 | 15 | 15020000044679 | 15020000044728 | 1 | Mme | Sophie | Trilles | ||
| 15020000044730 | L15/amo20 | 15 | 15020000044679 | 15020000044728 | 2 | Mme | Audrey | Voisin | ||
| 15020000044731 | L15/amo20 | 15 | 15020000044679 | 15020000044728 | 3 | Mme | Manon | Esther Hervieu | ||
| 15020000044777 | L15/amo20 | 15 | 15020000044732 | 15020000044776 | 1 | M. | Andy | Douet | ||
| 15020000044778 | L15/amo20 | 15 | 15020000044732 | 15020000044776 | 2 | Mme | Estelle | Bennouara | ||
| 15020000044779 | L15/amo20 | 15 | 15020000044732 | 15020000044776 | 3 | M. | Jamel | Cheniour | ||
| 15020000044855 | L15/amo20 | 15 | 15020000044780 | 15020000044854 | 1 | M. | Sylvain | Laporte | ||
| 15020000044856 | L15/amo20 | 15 | 15020000044780 | 15020000044854 | 2 | M. | Paul | Bernardet | ||
| 15020000044924 | L15/amo20 | 15 | 15020000044857 | 15020000044923 | 1 | Mme | Stéphanie | Charreau Grandcoing | ||
| 15020000044925 | L15/amo20 | 15 | 15020000044857 | 15020000044923 | 2 | Mme | Aurélie | Richard | ||
| 15020000044926 | L15/amo20 | 15 | 15020000044857 | 15020000044923 | 3 | Mme | Amira | Aidel | ||
| 15020000044927 | L15/amo20 | 15 | 15020000044857 | 15020000044923 | 4 | M. | Corentin | Hlupic | ||
| 15020000044983 | L15/amo20 | 15 | 15020000044928 | 15020000044982 | 1 | M. | Xavier | Brouard | ||
| 15020000044984 | L15/amo20 | 15 | 15020000044928 | 15020000044982 | 2 | M. | François | Plaze | ||
| 15020000044985 | L15/amo20 | 15 | 15020000044928 | 15020000044982 | 3 | Mme | Manon | Baillargeaux | ||
| 15020000044986 | L15/amo20 | 15 | 15020000044928 | 15020000044982 | 4 | Mme | Anaïs | Auger |