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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 15020000001111 | L15/amo20 | 15 | 15020000001080 | 15020000001110 | 1 | M. | Olivier | Lavenka | ||
| 15020000001112 | L15/amo20 | 15 | 15020000001080 | 15020000001110 | 2 | Mme | Corinne | Michel | ||
| 15020000001113 | L15/amo20 | 15 | 15020000001080 | 15020000001110 | 3 | M. | Jean-François | Bénard | ||
| 15020000001114 | L15/amo20 | 15 | 15020000001080 | 15020000001110 | 4 | M. | Patrick | Hajzler | ||
| 15020000001115 | L15/amo20 | 15 | 15020000001080 | 15020000001110 | 5 | M. | Hervé | Patron | ||
| 15020000001340 | L15/amo20 | 15 | 15020000001143 | 15020000001339 | 1 | Mme | Virginie | Bourdier | ||
| 15020000001341 | L15/amo20 | 15 | 15020000001143 | 15020000001339 | 2 | Mme | Géraldine | Jerome | ||
| 15020000001342 | L15/amo20 | 15 | 15020000001143 | 15020000001339 | 3 | Mme | Nesrine | Scolaro | ||
| 15020000001591 | L15/amo20 | 15 | 15020000001353 | 15020000001590 | 1 | Mme | Catherine | Marques | ||
| 15020000001592 | L15/amo20 | 15 | 15020000001353 | 15020000001590 | 2 | Mme | Lysiane | Palacin | ||
| 15020000001593 | L15/amo20 | 15 | 15020000001353 | 15020000001590 | 3 | Mme | Malgorzata | Mathis Mazurczak | ||
| 15020000001594 | L15/amo20 | 15 | 15020000001353 | 15020000001590 | 4 | M. | Barthelemy | Aguerre | ||
| 15020000001595 | L15/amo20 | 15 | 15020000001353 | 15020000001590 | 5 | M. | Jacques | Desmaisons | ||
| 15020000001944 | L15/amo20 | 15 | 15020000001609 | 15020000001943 | 1 | M. | Stéphane | De Sallier Dupin | ||
| 15020000001945 | L15/amo20 | 15 | 15020000001609 | 15020000001943 | 2 | Mme | Béatrice | Boulanger | ||
| 15020000001946 | L15/amo20 | 15 | 15020000001609 | 15020000001943 | 3 | M. | Nicolas | Le Caroff | ||
| 15020000002276 | L15/amo20 | 15 | 15020000002227 | 15020000002275 | 1 | M. | Antoine | Salles-Papou | ||
| 15020000002277 | L15/amo20 | 15 | 15020000002227 | 15020000002275 | 2 | Mme | Manon | Dervin | ||
| 15020000002317 | L15/amo20 | 15 | 15020000002283 | 15020000002316 | 1 | M. | Julien | Rouet | ||
| 15020000002318 | L15/amo20 | 15 | 15020000002283 | 15020000002316 | 2 | Mme | Annie | Rousseau | ||
| 15020000002319 | L15/amo20 | 15 | 15020000002283 | 15020000002316 | 3 | M. | Gaël | Grosmaire | ||
| 15020000002320 | L15/amo20 | 15 | 15020000002283 | 15020000002316 | 4 | Mme | Chantal | Da costa | ||
| 15020000002321 | L15/amo20 | 15 | 15020000002283 | 15020000002316 | 5 | Mme | Inès | Sidir | ||
| 15020000002452 | L15/amo20 | 15 | 15020000002396 | 15020000002451 | 1 | Mme | Isabelle | Droguet | ||
| 15020000002453 | L15/amo20 | 15 | 15020000002396 | 15020000002451 | 2 | Mme | Béatrice | Frot | ||
| 15020000002454 | L15/amo20 | 15 | 15020000002396 | 15020000002451 | 3 | Mme | Magali | Reilhes | ||
| 15020000002936 | L15/amo20 | 15 | 15020000002741 | 15020000002935 | 1 | Mme | Brigitte | Trambouze | ||
| 15020000002937 | L15/amo20 | 15 | 15020000002741 | 15020000002935 | 2 | M. | François | Pagnon | ||
| 15020000002938 | L15/amo20 | 15 | 15020000002741 | 15020000002935 | 3 | Mme | Roxane | Beguet | ||
| 15020000003035 | L15/amo20 | 15 | 15020000002968 | 15020000003034 | 1 | M. | Jean-Claude | Briffault | ||
| 15020000003036 | L15/amo20 | 15 | 15020000002968 | 15020000003034 | 2 | Mme | Martine | Ricordeau | ||
| 15020000003037 | L15/amo20 | 15 | 15020000002968 | 15020000003034 | 3 | Mme | Stéphanie | Boulanger | ||
| 15020000003217 | L15/amo20 | 15 | 15020000003045 | 15020000003216 | 1 | M. | Didier | Dudrouilhe | ||
| 15020000003218 | L15/amo20 | 15 | 15020000003045 | 15020000003216 | 2 | Mme | Stephanie | Pineau | ||
| 15020000003219 | L15/amo20 | 15 | 15020000003045 | 15020000003216 | 3 | Mme | Marinette | Puysilloux | ||
| 15020000003429 | L15/amo20 | 15 | 15020000003247 | 15020000003428 | 1 | Mme | Christiane | Muller | ||
| 15020000003430 | L15/amo20 | 15 | 15020000003247 | 15020000003428 | 2 | Mme | Alexandra | Gutzwiller | ||
| 15020000003431 | L15/amo20 | 15 | 15020000003247 | 15020000003428 | 3 | M. | Maxime | Beltzung | ||
| 15020000003432 | L15/amo20 | 15 | 15020000003247 | 15020000003428 | 4 | Mme | Ghislaine | Pierrat | ||
| 15020000003714 | L15/amo20 | 15 | 15020000003575 | 15020000003713 | 1 | M. | Christian | Klipfel | ||
| 15020000003715 | L15/amo20 | 15 | 15020000003575 | 15020000003713 | 2 | Mme | Sophie | Paillard | ||
| 15020000003716 | L15/amo20 | 15 | 15020000003575 | 15020000003713 | 3 | Mme | Julie | Hoffmann | ||
| 15020000003717 | L15/amo20 | 15 | 15020000003575 | 15020000003713 | 4 | Mme | Caroline | Seither | ||
| 15020000003909 | L15/amo20 | 15 | 15020000003718 | 15020000003908 | 1 | M. | Jean-François | Vidal | ||
| 15020000003910 | L15/amo20 | 15 | 15020000003718 | 15020000003908 | 2 | Mme | Sophie | Rousset | ||
| 15020000003911 | L15/amo20 | 15 | 15020000003718 | 15020000003908 | 3 | Mme | Marion | Mayrand | ||
| 15020000003912 | L15/amo20 | 15 | 15020000003718 | 15020000003908 | 4 | M. | Victor | Gaonach | ||
| 15020000003958 | L15/amo20 | 15 | 15020000003913 | 15020000003957 | 1 | Mme | Valérie | Cabecas | ||
| 15020000003959 | L15/amo20 | 15 | 15020000003913 | 15020000003957 | 2 | Mme | Michèle | Parion | ||
| 15020000004156 | L15/amo20 | 15 | 15020000003979 | 15020000004155 | 1 | Mme | Céline | Lemoussu |