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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17020000037666 | L17/amo20 | 17 | 17020000037614 | 17020000037663 | 3 | M. | Huseyin | Koyuncu | ||
| 17020000037696 | L17/amo20 | 17 | 17020000037667 | 17020000037695 | 1 | M. | Roger | Pécout | ||
| 17020000037697 | L17/amo20 | 17 | 17020000037667 | 17020000037695 | 2 | M. | Rémi | Berthoux | ||
| 17020000037698 | L17/amo20 | 17 | 17020000037667 | 17020000037695 | 3 | M. | Esteban | Maillot | ||
| 17020000037699 | L17/amo20 | 17 | 17020000037667 | 17020000037695 | 4 | Mme | Maëlle | Martin | ||
| 17020000037736 | L17/amo20 | 17 | 17020000037714 | 17020000037735 | 1 | M. | Tim | Bouzon | ||
| 17020000037737 | L17/amo20 | 17 | 17020000037714 | 17020000037735 | 2 | M. | Florian | Patard | ||
| 17020000037738 | L17/amo20 | 17 | 17020000037714 | 17020000037735 | 3 | M. | Hubert | de Jacquelin | ||
| 17020000037739 | L17/amo20 | 17 | 17020000037714 | 17020000037735 | 4 | M. | Mathis | Gangand | ||
| 17020000037764 | L17/amo20 | 17 | 17020000037740 | 17020000037763 | 1 | M. | Ludovic | Massard | ||
| 17020000037765 | L17/amo20 | 17 | 17020000037740 | 17020000037763 | 2 | Mme | Sandrine | Baroin | ||
| 17020000037766 | L17/amo20 | 17 | 17020000037740 | 17020000037763 | 3 | M. | Etienne | Clerc | ||
| 17020000037767 | L17/amo20 | 17 | 17020000037740 | 17020000037763 | 4 | Mme | Aurélie | Jouvelot | ||
| 17020000037873 | L17/amo20 | 17 | 17020000037768 | 17020000037872 | 1 | M. | Jacques | Desmaisons | ||
| 17020000037874 | L17/amo20 | 17 | 17020000037768 | 17020000037872 | 2 | Mme | Lydie | Bonito | ||
| 17020000037875 | L17/amo20 | 17 | 17020000037768 | 17020000037872 | 3 | Mme | Clémence | Delongvert | ||
| 17020000037951 | L17/amo20 | 17 | 17020000037904 | 17020000037950 | 1 | Mme | Christelle | Angelloz-Nicoud | ||
| 17020000037952 | L17/amo20 | 17 | 17020000037904 | 17020000037950 | 2 | M. | Magnuson | Lopes | ||
| 17020000037953 | L17/amo20 | 17 | 17020000037904 | 17020000037950 | 3 | M. | Colin | Mauchand | ||
| 17020000037995 | L17/amo20 | 17 | 17020000037954 | 17020000037994 | 1 | M. | Antoine | Potor | ||
| 17020000037996 | L17/amo20 | 17 | 17020000037954 | 17020000037994 | 2 | Mme | Agathe | Samson | ||
| 17020000037997 | L17/amo20 | 17 | 17020000037954 | 17020000037994 | 3 | M. | Lucas | Mélinand | ||
| 17020000037998 | L17/amo20 | 17 | 17020000037954 | 17020000037994 | 4 | M. | Alban | Gissinger | ||
| 17020000038020 | L17/amo20 | 17 | 17020000037999 | 17020000038019 | 1 | M. | Joffrey | Pointlane | ||
| 17020000038021 | L17/amo20 | 17 | 17020000037999 | 17020000038019 | 2 | Mme | Mathilde | Marjanovic | ||
| 17020000038022 | L17/amo20 | 17 | 17020000037999 | 17020000038019 | 3 | Mme | Céline | Pennelle | ||
| 17020000038023 | L17/amo20 | 17 | 17020000037999 | 17020000038019 | 4 | M. | Mathéo | de Souza | ||
| 17020000038072 | L17/amo20 | 17 | 17020000038035 | 17020000038071 | 1 | M. | Brieuc | Jalon | ||
| 17020000038073 | L17/amo20 | 17 | 17020000038035 | 17020000038071 | 2 | Mme | Charlotte | Chambounaud | ||
| 17020000038074 | L17/amo20 | 17 | 17020000038035 | 17020000038071 | 3 | M. | Paul | du Peyroux | ||
| 17020000038075 | L17/amo20 | 17 | 17020000038035 | 17020000038071 | 4 | M. | Arthur | Casal | ||
| 17020000038146 | L17/amo20 | 17 | 17020000038076 | 17020000038145 | 1 | M. | Tomek | Godefroy | ||
| 17020000038147 | L17/amo20 | 17 | 17020000038076 | 17020000038145 | 2 | Mme | Fatiya | Mothay | ||
| 17020000038148 | L17/amo20 | 17 | 17020000038076 | 17020000038145 | 3 | M. | Mathieu | Rateau | ||
| 17020000038149 | L17/amo20 | 17 | 17020000038076 | 17020000038145 | 4 | M. | Umit | Dogan | ||
| 17020000038208 | L17/amo20 | 17 | 17020000038150 | 17020000038207 | 1 | Mme | Emilie | Mostefaï | ||
| 17020000038209 | L17/amo20 | 17 | 17020000038150 | 17020000038207 | 2 | M. | Léopold | Comtet | ||
| 17020000038210 | L17/amo20 | 17 | 17020000038150 | 17020000038207 | 3 | M. | Augustin | Stalloni | ||
| 17020000038256 | L17/amo20 | 17 | 17020000038222 | 17020000038255 | 1 | M. | François | Ceglarski | ||
| 17020000038257 | L17/amo20 | 17 | 17020000038222 | 17020000038255 | 2 | M. | Maxence | Audo | ||
| 17020000038320 | L17/amo20 | 17 | 17020000038258 | 17020000038319 | 1 | M. | Adrien | Lienard | ||
| 17020000038321 | L17/amo20 | 17 | 17020000038258 | 17020000038319 | 2 | Mme | Elisabeth | Abanda Ayissi Beyene | ||
| 17020000038322 | L17/amo20 | 17 | 17020000038258 | 17020000038319 | 3 | M. | Benjamin | Peutevynck | ||
| 17020000038398 | L17/amo20 | 17 | 17020000038323 | 17020000038397 | 1 | M. | Cyril | Fernagu | ||
| 17020000038399 | L17/amo20 | 17 | 17020000038323 | 17020000038397 | 2 | Mme | Nell | Groussin | ||
| 17020000038400 | L17/amo20 | 17 | 17020000038323 | 17020000038397 | 3 | Mme | Angéline | Martinez | ||
| 17020000038451 | L17/amo20 | 17 | 17020000038401 | 17020000038450 | 1 | M. | Maxence | Pigrée | ||
| 17020000038452 | L17/amo20 | 17 | 17020000038401 | 17020000038450 | 2 | Mme | Yasmine | Beldjelti | ||
| 17020000038502 | L17/amo20 | 17 | 17020000038453 | 17020000038501 | 1 | M. | Armand | Barbieux | ||
| 17020000038503 | L17/amo20 | 17 | 17020000038453 | 17020000038501 | 2 | Mme | Nathalie | Fortin-Jouannet |