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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17020000007356 | L17/amo20 | 17 | 17020000007291 | 17020000007352 | 4 | M. | Charles | Crespel | ||
| 17020000007357 | L17/amo20 | 17 | 17020000007291 | 17020000007352 | 5 | M. | Louis | Cadou | ||
| 17020000007414 | L17/amo20 | 17 | 17020000007358 | 17020000007413 | 1 | Mme | Marie | Lebedio | ||
| 17020000007415 | L17/amo20 | 17 | 17020000007358 | 17020000007413 | 2 | Mme | Elise | Mellinger | ||
| 17020000007416 | L17/amo20 | 17 | 17020000007358 | 17020000007413 | 3 | M. | Floris | Legrand | ||
| 17020000007465 | L17/amo20 | 17 | 17020000007417 | 17020000007464 | 1 | M. | Ludwig | Speter-Lejeune | ||
| 17020000007466 | L17/amo20 | 17 | 17020000007417 | 17020000007464 | 2 | Mme | Aurélie | Loeillet | ||
| 17020000007467 | L17/amo20 | 17 | 17020000007417 | 17020000007464 | 3 | M. | Magnuson | Lopes | ||
| 17020000007540 | L17/amo20 | 17 | 17020000007468 | 17020000007539 | 1 | M. | Kerrian | Realland | ||
| 17020000007541 | L17/amo20 | 17 | 17020000007468 | 17020000007539 | 2 | Mme | Laure | Merendon | ||
| 17020000007594 | L17/amo20 | 17 | 17020000007542 | 17020000007593 | 1 | Mme | Eliette | Courilleau | ||
| 17020000007595 | L17/amo20 | 17 | 17020000007542 | 17020000007593 | 2 | M. | Paul | Jobard | ||
| 17020000007596 | L17/amo20 | 17 | 17020000007542 | 17020000007593 | 3 | Mme | Anne-Marie | Cormier-Bouligeon | ||
| 17020000007597 | L17/amo20 | 17 | 17020000007542 | 17020000007593 | 4 | M. | Antoine | Engel | ||
| 17020000007598 | L17/amo20 | 17 | 17020000007542 | 17020000007593 | 5 | Mme | Noémie | Linquette | ||
| 17020000007641 | L17/amo20 | 17 | 17020000007599 | 17020000007640 | 1 | M. | Alain | Clemenceau | ||
| 17020000007642 | L17/amo20 | 17 | 17020000007599 | 17020000007640 | 2 | M. | Pierre-Louis | Rivailler | ||
| 17020000007643 | L17/amo20 | 17 | 17020000007599 | 17020000007640 | 3 | Mme | Léa | Manicacci | ||
| 17020000007715 | L17/amo20 | 17 | 17020000007689 | 17020000007714 | 1 | Mme | Delphine | Foucaud | ||
| 17020000007716 | L17/amo20 | 17 | 17020000007689 | 17020000007714 | 2 | M. | Eddie | Marcos | ||
| 17020000007717 | L17/amo20 | 17 | 17020000007689 | 17020000007714 | 3 | Mme | Anne-Laure | Baldon | ||
| 17020000007797 | L17/amo20 | 17 | 17020000007732 | 17020000007796 | 1 | M. | Guillaume | Luciani | ||
| 17020000007798 | L17/amo20 | 17 | 17020000007732 | 17020000007796 | 2 | M. | Jean-Toussaint | Mattei | ||
| 17020000007799 | L17/amo20 | 17 | 17020000007732 | 17020000007796 | 3 | Mme | Josepha | Geronimi | ||
| 17020000007800 | L17/amo20 | 17 | 17020000007732 | 17020000007796 | 4 | M. | Pierre-Paul | Gori | ||
| 17020000007883 | L17/amo20 | 17 | 17020000007801 | 17020000007882 | 1 | Mme | Caroline | Forest | ||
| 17020000007884 | L17/amo20 | 17 | 17020000007801 | 17020000007882 | 2 | Mme | Mathilde | Tastavy | ||
| 17020000007885 | L17/amo20 | 17 | 17020000007801 | 17020000007882 | 3 | M. | Grégory | Abherve-Gueguen | ||
| 17020000007992 | L17/amo20 | 17 | 17020000007886 | 17020000007991 | 1 | Mme | Sandrine | Ballester | ||
| 17020000007993 | L17/amo20 | 17 | 17020000007886 | 17020000007991 | 2 | M. | Thibaut | Colombier | ||
| 17020000007994 | L17/amo20 | 17 | 17020000007886 | 17020000007991 | 3 | Mme | Chloé | Boireau | ||
| 17020000008050 | L17/amo20 | 17 | 17020000007995 | 17020000008049 | 1 | M. | William | Calvez | ||
| 17020000008051 | L17/amo20 | 17 | 17020000007995 | 17020000008049 | 2 | Mme | Vanessa | Photiou | ||
| 17020000008052 | L17/amo20 | 17 | 17020000007995 | 17020000008049 | 3 | M. | François-Régis | Friant | ||
| 17020000008123 | L17/amo20 | 17 | 17020000008053 | 17020000008122 | 1 | M. | Jérôme | Hébert | ||
| 17020000008124 | L17/amo20 | 17 | 17020000008053 | 17020000008122 | 2 | Mme | Nolwenn | Rault-Barbier | ||
| 17020000008125 | L17/amo20 | 17 | 17020000008053 | 17020000008122 | 3 | Mme | Julie | Binois | ||
| 17020000008126 | L17/amo20 | 17 | 17020000008053 | 17020000008122 | 4 | Mme | Klervi | Le Lez | ||
| 17020000008127 | L17/amo20 | 17 | 17020000008053 | 17020000008122 | 5 | M. | Axel | Talabardon | ||
| 17020000008165 | L17/amo20 | 17 | 17020000008142 | 17020000008164 | 1 | Mme | Aude | Goarnisson | ||
| 17020000008166 | L17/amo20 | 17 | 17020000008142 | 17020000008164 | 2 | Mme | Agathe | Huard | ||
| 17020000008167 | L17/amo20 | 17 | 17020000008142 | 17020000008164 | 3 | M. | Damien | Ladan | ||
| 17020000008168 | L17/amo20 | 17 | 17020000008142 | 17020000008164 | 4 | Mme | Agathe | Rosa | ||
| 17020000008169 | L17/amo20 | 17 | 17020000008142 | 17020000008164 | 5 | M. | Damien | Kitmacher | ||
| 17020000008207 | L17/amo20 | 17 | 17020000008170 | 17020000008206 | 1 | Mme | Emmanuelle | Gavanon | ||
| 17020000008208 | L17/amo20 | 17 | 17020000008170 | 17020000008206 | 2 | M. | Thomas | Combaudon | ||
| 17020000008209 | L17/amo20 | 17 | 17020000008170 | 17020000008206 | 3 | M. | Théo | Privat | ||
| 17020000008276 | L17/amo20 | 17 | 17020000008210 | 17020000008275 | 1 | M. | Antoine | Farin | ||
| 17020000008277 | L17/amo20 | 17 | 17020000008210 | 17020000008275 | 2 | Mme | Esther | Lévine | ||
| 17020000008278 | L17/amo20 | 17 | 17020000008210 | 17020000008275 | 3 | M. | Hugo | Martin |