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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17020000040137 | L17/amo20 | 17 | 17020000040029 | 17020000040136 | 1 | Mme | Amandine | Pasquier | ||
| 17020000040138 | L17/amo20 | 17 | 17020000040029 | 17020000040136 | 2 | M. | Pierre | Le Brigand | ||
| 17020000040139 | L17/amo20 | 17 | 17020000040029 | 17020000040136 | 3 | M. | Théophane | Vincent | ||
| 17020000040140 | L17/amo20 | 17 | 17020000040029 | 17020000040136 | 4 | Mme | Juliette | Goujet | ||
| 17020000040302 | L17/amo20 | 17 | 17020000040288 | 17020000040301 | 1 | M. | Zineddine | Abderrehim | ||
| 17020000040303 | L17/amo20 | 17 | 17020000040288 | 17020000040301 | 2 | Mme | Tiphaine | Jacquin-Dantin | ||
| 17020000040304 | L17/amo20 | 17 | 17020000040288 | 17020000040301 | 3 | M. | Alexis | Fayolle | ||
| 17020000040305 | L17/amo20 | 17 | 17020000040288 | 17020000040301 | 4 | Mme | Coline | Chaudet | ||
| 17020000040369 | L17/amo20 | 17 | 17020000040321 | 17020000040368 | 1 | Mme | Mariella | Ceriani | ||
| 17020000040370 | L17/amo20 | 17 | 17020000040321 | 17020000040368 | 2 | Mme | Sophie | Clément | ||
| 17020000040371 | L17/amo20 | 17 | 17020000040321 | 17020000040368 | 3 | Mme | Jessica | Langner | ||
| 17020000040470 | L17/amo20 | 17 | 17020000040453 | 17020000040469 | 1 | M. | François-Éric | Carbonnel | ||
| 17020000040471 | L17/amo20 | 17 | 17020000040453 | 17020000040469 | 2 | M. | Baptiste | Dufrier | ||
| 17020000040502 | L17/amo20 | 17 | 17020000040472 | 17020000040501 | 1 | Mme | Tiphaine | Giton | ||
| 17020000040503 | L17/amo20 | 17 | 17020000040472 | 17020000040501 | 2 | M. | Stéphan | Fautrat | ||
| 17020000040504 | L17/amo20 | 17 | 17020000040472 | 17020000040501 | 3 | Mme | Elisa | Raynaud | ||
| 17020000040575 | L17/amo20 | 17 | 17020000040533 | 17020000040574 | 1 | Mme | Fatma | Gouasmia | ||
| 17020000040576 | L17/amo20 | 17 | 17020000040533 | 17020000040574 | 2 | M. | Sébastien | Mirgodin | ||
| 17020000040577 | L17/amo20 | 17 | 17020000040533 | 17020000040574 | 3 | M. | Julien | Gonthier | ||
| 17020000040578 | L17/amo20 | 17 | 17020000040533 | 17020000040574 | 4 | Mme | Aude | Barrard | ||
| 15020000000075 | L15/amo20 | 15 | 15020000000032 | 15020000000074 | 1 | Mme | Sylvie | Couderc | ||
| 15020000000076 | L15/amo20 | 15 | 15020000000032 | 15020000000074 | 2 | M. | Samuel | Ducasse-Reiss | ||
| 15020000000137 | L15/amo20 | 15 | 15020000000077 | 15020000000136 | 1 | Mme | Sabine | Vasquez | ||
| 15020000000138 | L15/amo20 | 15 | 15020000000077 | 15020000000136 | 2 | Mme | Edwige | Lafayolle de la Bruyère | ||
| 15020000000139 | L15/amo20 | 15 | 15020000000077 | 15020000000136 | 3 | Mme | Aurélie | Richard | ||
| 15020000000196 | L15/amo20 | 15 | 15020000000147 | 15020000000195 | 1 | Mme | Stéphanie | Mayadoux | ||
| 15020000000197 | L15/amo20 | 15 | 15020000000147 | 15020000000195 | 2 | Mme | Stéphanie | Cardella | ||
| 15020000000198 | L15/amo20 | 15 | 15020000000147 | 15020000000195 | 3 | Mme | Judith | Dossemont | ||
| 15020000000199 | L15/amo20 | 15 | 15020000000147 | 15020000000195 | 4 | M. | Jean-Laurent | Méfret | ||
| 15020000000397 | L15/amo20 | 15 | 15020000000302 | 15020000000396 | 1 | Mme | Valérie | Scognamiglio | ||
| 15020000000398 | L15/amo20 | 15 | 15020000000302 | 15020000000396 | 2 | M. | Pascal | Leroy | ||
| 15020000000399 | L15/amo20 | 15 | 15020000000302 | 15020000000396 | 3 | Mme | Emmanuelle | Jardin-Payet | ||
| 15020000000433 | L15/amo20 | 15 | 15020000000408 | 15020000000432 | 1 | Mme | Catherine | Pasco | ||
| 15020000000434 | L15/amo20 | 15 | 15020000000408 | 15020000000432 | 2 | M. | Franck | Beeldens | ||
| 15020000000435 | L15/amo20 | 15 | 15020000000408 | 15020000000432 | 3 | M. | Maxence | Mahen | ||
| 15020000000436 | L15/amo20 | 15 | 15020000000408 | 15020000000432 | 4 | M. | Eloi | Passot | ||
| 15020000000494 | L15/amo20 | 15 | 15020000000460 | 15020000000493 | 1 | M. | Zakaria | Mehidi | ||
| 15020000000495 | L15/amo20 | 15 | 15020000000460 | 15020000000493 | 2 | M. | Adrien | Nfissi | ||
| 15020000000496 | L15/amo20 | 15 | 15020000000460 | 15020000000493 | 3 | M. | Pierre | Langeron-Saez | ||
| 15020000000581 | L15/amo20 | 15 | 15020000000507 | 15020000000580 | 1 | M. | Hubert | Chabenat | ||
| 15020000000582 | L15/amo20 | 15 | 15020000000507 | 15020000000580 | 2 | Mme | Juliette | Lafont | ||
| 15020000000583 | L15/amo20 | 15 | 15020000000507 | 15020000000580 | 3 | Mme | Mahaut | de Casaban | ||
| 15020000000584 | L15/amo20 | 15 | 15020000000507 | 15020000000580 | 4 | M. | Alexandre | Leonardi | ||
| 15020000000585 | L15/amo20 | 15 | 15020000000507 | 15020000000580 | 5 | Mme | Blanche | Feignon | ||
| 15020000000865 | L15/amo20 | 15 | 15020000000767 | 15020000000864 | 1 | Mme | Amandine | Painset | ||
| 15020000000866 | L15/amo20 | 15 | 15020000000767 | 15020000000864 | 2 | M. | David | Duizidou | ||
| 15020000000867 | L15/amo20 | 15 | 15020000000767 | 15020000000864 | 3 | M. | Lindsey | Deary | ||
| 15020000000868 | L15/amo20 | 15 | 15020000000767 | 15020000000864 | 4 | Mme | Sixtine | Aumont | ||
| 15020000001071 | L15/amo20 | 15 | 15020000000882 | 15020000001070 | 1 | M. | Romain | Maria | ||
| 15020000001072 | L15/amo20 | 15 | 15020000000882 | 15020000001070 | 2 | Mme | Delphine | Raimond |