amo30.acteur_mandat_collaborateurs_collaborateur
Chemin acteur.mandats.mandat.collaborateurs.collaborateur · présence : L17 18 %
2 070 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 18 % · 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 18 % |
| 9 | nom | VARCHAR | acteur.mandats.mandat.collaborateurs.collaborateur.nom · présence : L17 18 % |
| 10 | date_debut | VARCHAR | acteur.mandats.mandat.collaborateurs.collaborateur.dateDebut · présence : L17 18 % |
| 11 | date_fin | VARCHAR | acteur.mandats.mandat.collaborateurs.collaborateur.dateFin · présence : L17 18 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | qualite | prenom | nom | date_debut | date_fin |
|---|---|---|---|---|---|---|---|---|---|---|
| 17030000151064 | L17/amo30 | 17 | 17030000150978 | 17030000151061 | 3 | Mme | Marlène | Virantin | ||
| 17030000151236 | L17/amo30 | 17 | 17030000151116 | 17030000151235 | 1 | M. | Adrien | Pêpe | ||
| 17030000151237 | L17/amo30 | 17 | 17030000151116 | 17030000151235 | 2 | Mme | Sandrine | Panizzutti | ||
| 17030000151238 | L17/amo30 | 17 | 17030000151116 | 17030000151235 | 3 | M. | Alexandre | Jabard | ||
| 17030000151239 | L17/amo30 | 17 | 17030000151116 | 17030000151235 | 4 | M. | Damien | Obrador | ||
| 17030000151321 | L17/amo30 | 17 | 17030000151240 | 17030000151320 | 1 | Mme | Pauline | Vilchez | ||
| 17030000151322 | L17/amo30 | 17 | 17030000151240 | 17030000151320 | 2 | M. | Thierry | Strub | ||
| 17030000151323 | L17/amo30 | 17 | 17030000151240 | 17030000151320 | 3 | Mme | Julie | Gahinet | ||
| 17030000151421 | L17/amo30 | 17 | 17030000151324 | 17030000151420 | 1 | M. | Guilhem | Serieys | ||
| 17030000151422 | L17/amo30 | 17 | 17030000151324 | 17030000151420 | 2 | Mme | Iris | Lelièvre | ||
| 17030000151423 | L17/amo30 | 17 | 17030000151324 | 17030000151420 | 3 | Mme | Alice | Thimister | ||
| 17030000151524 | L17/amo30 | 17 | 17030000151424 | 17030000151523 | 1 | Mme | Cécile | Bourrel | ||
| 17030000151525 | L17/amo30 | 17 | 17030000151424 | 17030000151523 | 2 | Mme | Anne-Charlotte | Hüe | ||
| 17030000151673 | L17/amo30 | 17 | 17030000151604 | 17030000151672 | 1 | M. | Lukas | Kubicki | ||
| 17030000151674 | L17/amo30 | 17 | 17030000151604 | 17030000151672 | 2 | Mme | Amandine | Tolaïni | ||
| 17030000151675 | L17/amo30 | 17 | 17030000151604 | 17030000151672 | 3 | M. | Bryan | Vincent | ||
| 17030000151676 | L17/amo30 | 17 | 17030000151604 | 17030000151672 | 4 | M. | Théau | Fournet | ||
| 17030000151731 | L17/amo30 | 17 | 17030000151677 | 17030000151730 | 1 | M. | Andréa | Orabona | ||
| 17030000151732 | L17/amo30 | 17 | 17030000151677 | 17030000151730 | 2 | M. | Franck | Galbert | ||
| 17030000151733 | L17/amo30 | 17 | 17030000151677 | 17030000151730 | 3 | Mme | Magali | Lemêle | ||
| 17030000151734 | L17/amo30 | 17 | 17030000151677 | 17030000151730 | 4 | M. | Pierre | Deniau | ||
| 17030000151878 | L17/amo30 | 17 | 17030000151825 | 17030000151877 | 1 | M. | Quentin | Obert de Thieusies | ||
| 17030000151879 | L17/amo30 | 17 | 17030000151825 | 17030000151877 | 2 | M. | Pierre | Piquemal Soulata | ||
| 17030000151880 | L17/amo30 | 17 | 17030000151825 | 17030000151877 | 3 | M. | Matthieu | Thaon | ||
| 17030000151989 | L17/amo30 | 17 | 17030000151958 | 17030000151988 | 1 | M. | Lucas | Jujard | ||
| 17030000151990 | L17/amo30 | 17 | 17030000151958 | 17030000151988 | 2 | M. | Nathan | Cassar | ||
| 17030000151991 | L17/amo30 | 17 | 17030000151958 | 17030000151988 | 3 | M. | Alexandre | Schlesser | ||
| 17030000151992 | L17/amo30 | 17 | 17030000151958 | 17030000151988 | 4 | M. | Raphaël | Rofidal | ||
| 17030000152050 | L17/amo30 | 17 | 17030000151993 | 17030000152049 | 1 | Mme | Magali | Reilhes | ||
| 17030000152051 | L17/amo30 | 17 | 17030000151993 | 17030000152049 | 2 | Mme | Isabelle | Droguet | ||
| 17030000152052 | L17/amo30 | 17 | 17030000151993 | 17030000152049 | 3 | Mme | Marie-Line | Billon | ||
| 17030000152053 | L17/amo30 | 17 | 17030000151993 | 17030000152049 | 4 | Mme | Carla | Mata | ||
| 17030000152184 | L17/amo30 | 17 | 17030000152054 | 17030000152183 | 1 | Mme | Noëlle | Margaria | ||
| 17030000152185 | L17/amo30 | 17 | 17030000152054 | 17030000152183 | 2 | Mme | Charlotte | Carron de la Carrière | ||
| 17030000152230 | L17/amo30 | 17 | 17030000152186 | 17030000152229 | 1 | M. | Kévin | Rahou | ||
| 17030000152231 | L17/amo30 | 17 | 17030000152186 | 17030000152229 | 2 | M. | Stéphane | Simond | ||
| 17030000152232 | L17/amo30 | 17 | 17030000152186 | 17030000152229 | 3 | Mme | Martina | Gabelica | ||
| 17030000152233 | L17/amo30 | 17 | 17030000152186 | 17030000152229 | 4 | Mme | Marjorie | Peyre | ||
| 17030000152346 | L17/amo30 | 17 | 17030000152235 | 17030000152345 | 1 | Mme | Chantal | Gros | ||
| 17030000152347 | L17/amo30 | 17 | 17030000152235 | 17030000152345 | 2 | Mme | Isabelle | Borgniet | ||
| 17030000152348 | L17/amo30 | 17 | 17030000152235 | 17030000152345 | 3 | M. | Anthony | Grand | ||
| 17030000152414 | L17/amo30 | 17 | 17030000152350 | 17030000152413 | 1 | M. | Thibault | Lemaire | ||
| 17030000152415 | L17/amo30 | 17 | 17030000152350 | 17030000152413 | 2 | M. | Léo | Porcari | ||
| 17030000152416 | L17/amo30 | 17 | 17030000152350 | 17030000152413 | 3 | M. | Mathieu | Vaché | ||
| 17030000152613 | L17/amo30 | 17 | 17030000152418 | 17030000152612 | 1 | M. | Romain | Palazzini | ||
| 17030000152614 | L17/amo30 | 17 | 17030000152418 | 17030000152612 | 2 | M. | Léopold | Benattar | ||
| 17030000152615 | L17/amo30 | 17 | 17030000152418 | 17030000152612 | 3 | Mme | Lucie | Poullias | ||
| 17030000152616 | L17/amo30 | 17 | 17030000152418 | 17030000152612 | 4 | Mme | Ambre | Rivoallan-Dorlencourt | ||
| 17030000152736 | L17/amo30 | 17 | 17030000152617 | 17030000152735 | 1 | M. | Pierre | Betelaud | ||
| 17030000152948 | L17/amo30 | 17 | 17030000152861 | 17030000152947 | 1 | M. | Louis | Grégoire |