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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17020000012801 | L17/amo20 | 17 | 17020000012705 | 17020000012794 | 7 | Mme | Adèle | Blanchet | ||
| 17020000012802 | L17/amo20 | 17 | 17020000012705 | 17020000012794 | 8 | Mme | Morgana | Bendaoud | ||
| 17020000012883 | L17/amo20 | 17 | 17020000012825 | 17020000012882 | 1 | M. | Basile | Dunand | ||
| 17020000012884 | L17/amo20 | 17 | 17020000012825 | 17020000012882 | 2 | Mme | Marie | Esplandiu | ||
| 17020000012885 | L17/amo20 | 17 | 17020000012825 | 17020000012882 | 3 | M. | Baptiste | Normand | ||
| 17020000012942 | L17/amo20 | 17 | 17020000012886 | 17020000012941 | 1 | M. | Daniel | Valentin | ||
| 17020000012943 | L17/amo20 | 17 | 17020000012886 | 17020000012941 | 2 | Mme | Anastasia | Bouasse | ||
| 17020000012944 | L17/amo20 | 17 | 17020000012886 | 17020000012941 | 3 | Mme | Joséphine | Heumel | ||
| 17020000012945 | L17/amo20 | 17 | 17020000012886 | 17020000012941 | 4 | Mme | Marion | Pernin | ||
| 17020000013055 | L17/amo20 | 17 | 17020000012946 | 17020000013054 | 1 | Mme | Patricia | Ferry | ||
| 17020000013056 | L17/amo20 | 17 | 17020000012946 | 17020000013054 | 2 | Mme | Mathilde | Ferreira | ||
| 17020000013057 | L17/amo20 | 17 | 17020000012946 | 17020000013054 | 3 | M. | Louis | Ronssin | ||
| 17020000013058 | L17/amo20 | 17 | 17020000012946 | 17020000013054 | 4 | Mme | Pia | Pierrel | ||
| 17020000013059 | L17/amo20 | 17 | 17020000012946 | 17020000013054 | 5 | M. | Hugo | Laurent | ||
| 17020000013133 | L17/amo20 | 17 | 17020000013071 | 17020000013132 | 1 | M. | Julien | de Gerando | ||
| 17020000013134 | L17/amo20 | 17 | 17020000013071 | 17020000013132 | 2 | Mme | Marie | Lacan | ||
| 17020000013135 | L17/amo20 | 17 | 17020000013071 | 17020000013132 | 3 | M. | Bernard | Andreu | ||
| 17020000013136 | L17/amo20 | 17 | 17020000013071 | 17020000013132 | 4 | Mme | Nadia | Ould-Amer | ||
| 17020000013137 | L17/amo20 | 17 | 17020000013071 | 17020000013132 | 5 | Mme | Géraldine | Rouanet-Astruc | ||
| 17020000013138 | L17/amo20 | 17 | 17020000013071 | 17020000013132 | 6 | Mme | Catherine | Durand | ||
| 17020000013190 | L17/amo20 | 17 | 17020000013139 | 17020000013189 | 1 | M. | François | Magnin | ||
| 17020000013191 | L17/amo20 | 17 | 17020000013139 | 17020000013189 | 2 | Mme | Louise | Ramos | ||
| 17020000013192 | L17/amo20 | 17 | 17020000013139 | 17020000013189 | 3 | M. | Jean-Michel | Gimard | ||
| 17020000013193 | L17/amo20 | 17 | 17020000013139 | 17020000013189 | 4 | Mme | Rose | Salami | ||
| 17020000013212 | L17/amo20 | 17 | 17020000013194 | 17020000013211 | 1 | M. | Lucas | Flores | ||
| 17020000013213 | L17/amo20 | 17 | 17020000013194 | 17020000013211 | 2 | Mme | Emma | Lecomte | ||
| 17020000013214 | L17/amo20 | 17 | 17020000013194 | 17020000013211 | 3 | M. | Kévin | Chevrier | ||
| 17020000013331 | L17/amo20 | 17 | 17020000013248 | 17020000013330 | 1 | Mme | Manon | Fouyer | ||
| 17020000013332 | L17/amo20 | 17 | 17020000013248 | 17020000013330 | 2 | M. | Adrien | Sene | ||
| 17020000013333 | L17/amo20 | 17 | 17020000013248 | 17020000013330 | 3 | M. | Jérémy | Lepesqueur | ||
| 17020000013411 | L17/amo20 | 17 | 17020000013334 | 17020000013410 | 1 | M. | Gabriel | Deligny | ||
| 17020000013412 | L17/amo20 | 17 | 17020000013334 | 17020000013410 | 2 | M. | Alexandre | Vey | ||
| 17020000013413 | L17/amo20 | 17 | 17020000013334 | 17020000013410 | 3 | Mme | Kristell | Raseta | ||
| 17020000013497 | L17/amo20 | 17 | 17020000013414 | 17020000013496 | 1 | Mme | Aurélie | Rousseau | ||
| 17020000013498 | L17/amo20 | 17 | 17020000013414 | 17020000013496 | 2 | Mme | Colette | Vaud | ||
| 17020000013499 | L17/amo20 | 17 | 17020000013414 | 17020000013496 | 3 | M. | Nikola | Jelicic | ||
| 17020000013500 | L17/amo20 | 17 | 17020000013414 | 17020000013496 | 4 | M. | Hadi | Bougouffa | ||
| 17020000013501 | L17/amo20 | 17 | 17020000013414 | 17020000013496 | 5 | M. | Lorenzo | Mussio | ||
| 17020000013578 | L17/amo20 | 17 | 17020000013529 | 17020000013577 | 1 | Mme | Véronique | Siadous | ||
| 17020000013579 | L17/amo20 | 17 | 17020000013529 | 17020000013577 | 2 | M. | Simon | Zwertvaegher | ||
| 17020000013580 | L17/amo20 | 17 | 17020000013529 | 17020000013577 | 3 | M. | Romain | Chamand | ||
| 17020000013655 | L17/amo20 | 17 | 17020000013581 | 17020000013654 | 1 | M. | Jérémy | Herrouin | ||
| 17020000013656 | L17/amo20 | 17 | 17020000013581 | 17020000013654 | 2 | Mme | Marie-Charlotte | Dexmier | ||
| 17020000013657 | L17/amo20 | 17 | 17020000013581 | 17020000013654 | 3 | Mme | Clara | Debure | ||
| 17020000013734 | L17/amo20 | 17 | 17020000013666 | 17020000013733 | 1 | Mme | Angélique | Dupont | ||
| 17020000013735 | L17/amo20 | 17 | 17020000013666 | 17020000013733 | 2 | Mme | Assia | Hebbache | ||
| 17020000013736 | L17/amo20 | 17 | 17020000013666 | 17020000013733 | 3 | M. | Mehdi | Belmecheri-Rozental | ||
| 17020000013798 | L17/amo20 | 17 | 17020000013737 | 17020000013797 | 1 | M. | Thomas | Halberstadt | ||
| 17020000013799 | L17/amo20 | 17 | 17020000013737 | 17020000013797 | 2 | Mme | Sabine | Rober | ||
| 17020000013846 | L17/amo20 | 17 | 17020000013800 | 17020000013845 | 1 | M. | Stéphane | de Miroschedji |