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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 15020000040776 | L15/amo20 | 15 | 15020000040736 | 15020000040775 | 1 | M. | Jonathan | Van Parys | ||
| 15020000040777 | L15/amo20 | 15 | 15020000040736 | 15020000040775 | 2 | Mme | Magali | Gaudart Guyot | ||
| 15020000040778 | L15/amo20 | 15 | 15020000040736 | 15020000040775 | 3 | Mme | Sylvia | De Oliveira | ||
| 15020000040804 | L15/amo20 | 15 | 15020000040779 | 15020000040803 | 1 | Mme | Tatiana | Vivier-Paulange | ||
| 15020000040870 | L15/amo20 | 15 | 15020000040805 | 15020000040869 | 1 | Mme | Chantal | Louis-Williatte | ||
| 15020000040871 | L15/amo20 | 15 | 15020000040805 | 15020000040869 | 2 | M. | Jean-Marc | Fouillade | ||
| 15020000040872 | L15/amo20 | 15 | 15020000040805 | 15020000040869 | 3 | M. | Joseph | Quennesson | ||
| 15020000040990 | L15/amo20 | 15 | 15020000040935 | 15020000040989 | 1 | M. | Alexandre | Le Bars | ||
| 15020000040991 | L15/amo20 | 15 | 15020000040935 | 15020000040989 | 2 | M. | Nathan | Brouet | ||
| 15020000041017 | L15/amo20 | 15 | 15020000040992 | 15020000041016 | 1 | Mme | Charlotte | Vaillot | ||
| 15020000041018 | L15/amo20 | 15 | 15020000040992 | 15020000041016 | 2 | M. | Pascal | Aujard | ||
| 15020000041019 | L15/amo20 | 15 | 15020000040992 | 15020000041016 | 3 | M. | Pierre | Ceugniet | ||
| 15020000041068 | L15/amo20 | 15 | 15020000041020 | 15020000041067 | 1 | Mme | Valérie | de Gerando | ||
| 15020000041069 | L15/amo20 | 15 | 15020000041020 | 15020000041067 | 2 | M. | Julien | de Gerando | ||
| 15020000041070 | L15/amo20 | 15 | 15020000041020 | 15020000041067 | 3 | Mme | Marie | Lacan | ||
| 15020000041071 | L15/amo20 | 15 | 15020000041020 | 15020000041067 | 4 | Mme | Edith | Alauzet | ||
| 15020000041072 | L15/amo20 | 15 | 15020000041020 | 15020000041067 | 5 | M. | Bernard | Andreu | ||
| 15020000041131 | L15/amo20 | 15 | 15020000041073 | 15020000041130 | 1 | M. | Abel | Hermel | ||
| 15020000041132 | L15/amo20 | 15 | 15020000041073 | 15020000041130 | 2 | Mme | Bochra | Ben Achour | ||
| 15020000041133 | L15/amo20 | 15 | 15020000041073 | 15020000041130 | 3 | M. | Robin | Gastaldi | ||
| 15020000041134 | L15/amo20 | 15 | 15020000041073 | 15020000041130 | 4 | Mme | Marina | Benigni | ||
| 15020000041165 | L15/amo20 | 15 | 15020000041135 | 15020000041164 | 1 | Mme | Clothilde | Avenet-Tenneson | ||
| 15020000041166 | L15/amo20 | 15 | 15020000041135 | 15020000041164 | 2 | Mme | Ariane | Cornut-Gentille | ||
| 15020000041167 | L15/amo20 | 15 | 15020000041135 | 15020000041164 | 3 | M. | Bertrand | Marcincal | ||
| 15020000041214 | L15/amo20 | 15 | 15020000041168 | 15020000041213 | 1 | M. | Alexandre | Bianco | ||
| 15020000041215 | L15/amo20 | 15 | 15020000041168 | 15020000041213 | 2 | M. | Alexandre | Molina | ||
| 15020000041266 | L15/amo20 | 15 | 15020000041216 | 15020000041265 | 1 | Mme | Nathalie | Thomas | ||
| 15020000041267 | L15/amo20 | 15 | 15020000041216 | 15020000041265 | 2 | Mme | Morgana | Bendaoud | ||
| 15020000041312 | L15/amo20 | 15 | 15020000041268 | 15020000041311 | 1 | M. | Victor | Ignasiak | ||
| 15020000041313 | L15/amo20 | 15 | 15020000041268 | 15020000041311 | 2 | M. | Matthieu | Brun | ||
| 15020000041314 | L15/amo20 | 15 | 15020000041268 | 15020000041311 | 3 | Mme | Caroline | Fel | ||
| 15020000041465 | L15/amo20 | 15 | 15020000041344 | 15020000041464 | 1 | Mme | Ludivine | Jacquemain | ||
| 15020000041466 | L15/amo20 | 15 | 15020000041344 | 15020000041464 | 2 | M. | Patrick | Jalladaud | ||
| 15020000041467 | L15/amo20 | 15 | 15020000041344 | 15020000041464 | 3 | M. | Mohamed-El-Amine | Boubekeur | ||
| 15020000041468 | L15/amo20 | 15 | 15020000041344 | 15020000041464 | 4 | Mme | Camélia | Croyal | ||
| 15020000041506 | L15/amo20 | 15 | 15020000041469 | 15020000041505 | 1 | M. | Raphael | Gomez | ||
| 15020000041507 | L15/amo20 | 15 | 15020000041469 | 15020000041505 | 2 | Mme | Karima | Kandi | ||
| 15020000041508 | L15/amo20 | 15 | 15020000041469 | 15020000041505 | 3 | M. | Abel | Hermel | ||
| 15020000041509 | L15/amo20 | 15 | 15020000041469 | 15020000041505 | 4 | Mme | Audrey | Arnaudo | ||
| 15020000041521 | L15/amo20 | 15 | 15020000041510 | 15020000041520 | 1 | M. | David | Girard | ||
| 15020000041522 | L15/amo20 | 15 | 15020000041510 | 15020000041520 | 2 | Mme | Annie | Giobbio | ||
| 15020000041523 | L15/amo20 | 15 | 15020000041510 | 15020000041520 | 3 | M. | Gauthier | Willem | ||
| 15020000041524 | L15/amo20 | 15 | 15020000041510 | 15020000041520 | 4 | Mme | Mélissa | Fradier | ||
| 15020000041590 | L15/amo20 | 15 | 15020000041559 | 15020000041589 | 1 | Mme | Laurence | Marty | ||
| 15020000041591 | L15/amo20 | 15 | 15020000041559 | 15020000041589 | 2 | M. | Cédric | Chambard | ||
| 15020000041592 | L15/amo20 | 15 | 15020000041559 | 15020000041589 | 3 | M. | Antoine | Rozec | ||
| 15020000041643 | L15/amo20 | 15 | 15020000041593 | 15020000041642 | 1 | M. | Maxime | Charlet | ||
| 15020000041644 | L15/amo20 | 15 | 15020000041593 | 15020000041642 | 2 | Mme | Aurélie | Troubat | ||
| 15020000041722 | L15/amo20 | 15 | 15020000041645 | 15020000041721 | 1 | M. | François | Bussery | ||
| 15020000041754 | L15/amo20 | 15 | 15020000041723 | 15020000041753 | 1 | M. | Alexandre | Coutant |