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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17020000004669 | L17/amo20 | 17 | 17020000004601 | 17020000004665 | 4 | Mme | Sylvie | Gir | ||
| 17020000004775 | L17/amo20 | 17 | 17020000004671 | 17020000004774 | 1 | Mme | Lauriane | Merotto | ||
| 17020000004776 | L17/amo20 | 17 | 17020000004671 | 17020000004774 | 2 | M. | Thomas | Nexon | ||
| 17020000004777 | L17/amo20 | 17 | 17020000004671 | 17020000004774 | 3 | M. | Jean | Combette | ||
| 17020000004806 | L17/amo20 | 17 | 17020000004778 | 17020000004805 | 1 | Mme | Stephanie | Le Meur | ||
| 17020000004807 | L17/amo20 | 17 | 17020000004778 | 17020000004805 | 2 | Mme | Amandine | Janiaud-Vergnaud | ||
| 17020000004856 | L17/amo20 | 17 | 17020000004808 | 17020000004855 | 1 | Mme | Marie | Niquet | ||
| 17020000004857 | L17/amo20 | 17 | 17020000004808 | 17020000004855 | 2 | M. | Setni | Baro | ||
| 17020000004858 | L17/amo20 | 17 | 17020000004808 | 17020000004855 | 3 | Mme | Gabrielle | Boudaud | ||
| 17020000004859 | L17/amo20 | 17 | 17020000004808 | 17020000004855 | 4 | M. | Malo | Huillery | ||
| 17020000004930 | L17/amo20 | 17 | 17020000004860 | 17020000004929 | 1 | Mme | Christine | Lérandy | ||
| 17020000004931 | L17/amo20 | 17 | 17020000004860 | 17020000004929 | 2 | Mme | Aurélie | Nella | ||
| 17020000004932 | L17/amo20 | 17 | 17020000004860 | 17020000004929 | 3 | M. | Ludony | Zongo | ||
| 17020000004933 | L17/amo20 | 17 | 17020000004860 | 17020000004929 | 4 | Mme | Anne | Berisson | ||
| 17020000004934 | L17/amo20 | 17 | 17020000004860 | 17020000004929 | 5 | Mme | Nadine | Nacitas | ||
| 17020000005034 | L17/amo20 | 17 | 17020000004953 | 17020000005033 | 1 | M. | Emmanuel | Jean-Etienne | ||
| 17020000005035 | L17/amo20 | 17 | 17020000004953 | 17020000005033 | 2 | Mme | Myriam | Briant-Benabdallah | ||
| 17020000005036 | L17/amo20 | 17 | 17020000004953 | 17020000005033 | 3 | Mme | Lola | Morey Yeghiazarian | ||
| 17020000005115 | L17/amo20 | 17 | 17020000005037 | 17020000005114 | 1 | Mme | Odile | Clavier | ||
| 17020000005116 | L17/amo20 | 17 | 17020000005037 | 17020000005114 | 2 | M. | Olivier | Dulucq | ||
| 17020000005167 | L17/amo20 | 17 | 17020000005117 | 17020000005166 | 1 | Mme | Clara | Courtet | ||
| 17020000005168 | L17/amo20 | 17 | 17020000005117 | 17020000005166 | 2 | Mme | Marie-Aimée | Jacquet | ||
| 17020000005169 | L17/amo20 | 17 | 17020000005117 | 17020000005166 | 3 | Mme | Clémence | Toy-Riont Grossiord | ||
| 17020000005240 | L17/amo20 | 17 | 17020000005189 | 17020000005239 | 1 | Mme | Nadia | Mekkid | ||
| 17020000005241 | L17/amo20 | 17 | 17020000005189 | 17020000005239 | 2 | M. | Jean-Luc | Picard | ||
| 17020000005242 | L17/amo20 | 17 | 17020000005189 | 17020000005239 | 3 | M. | Simon | Guerand | ||
| 17020000005323 | L17/amo20 | 17 | 17020000005243 | 17020000005322 | 1 | Mme | Isabelle | André | ||
| 17020000005324 | L17/amo20 | 17 | 17020000005243 | 17020000005322 | 2 | M. | Geoffrey | Meresse-Volleaux | ||
| 17020000005325 | L17/amo20 | 17 | 17020000005243 | 17020000005322 | 3 | Mme | Julie | Lassus | ||
| 17020000005326 | L17/amo20 | 17 | 17020000005243 | 17020000005322 | 4 | Mme | Brunissène | Petit-Jean | ||
| 17020000005327 | L17/amo20 | 17 | 17020000005243 | 17020000005322 | 5 | M. | Sasha | Richard | ||
| 17020000005328 | L17/amo20 | 17 | 17020000005243 | 17020000005322 | 6 | Mme | Juline | Brégeot | ||
| 17020000005434 | L17/amo20 | 17 | 17020000005395 | 17020000005433 | 1 | M. | Georges-Fabrice | Blum | ||
| 17020000005435 | L17/amo20 | 17 | 17020000005395 | 17020000005433 | 2 | Mme | Christelle | Engel | ||
| 17020000005436 | L17/amo20 | 17 | 17020000005395 | 17020000005433 | 3 | M. | Benjamin | Zaluski | ||
| 17020000005437 | L17/amo20 | 17 | 17020000005395 | 17020000005433 | 4 | M. | Alexandre | Birrien | ||
| 17020000005502 | L17/amo20 | 17 | 17020000005446 | 17020000005501 | 1 | Mme | Gaëlle | Croquin Guillem | ||
| 17020000005503 | L17/amo20 | 17 | 17020000005446 | 17020000005501 | 2 | M. | Mathis | Maurial | ||
| 17020000005504 | L17/amo20 | 17 | 17020000005446 | 17020000005501 | 3 | M. | Joris | Varjabedian | ||
| 17020000005565 | L17/amo20 | 17 | 17020000005521 | 17020000005564 | 1 | Mme | Clémence | Delebecque | ||
| 17020000005566 | L17/amo20 | 17 | 17020000005521 | 17020000005564 | 2 | Mme | Chloé | Sallé | ||
| 17020000005567 | L17/amo20 | 17 | 17020000005521 | 17020000005564 | 3 | M. | Thomas | Batigne | ||
| 17020000005584 | L17/amo20 | 17 | 17020000005568 | 17020000005583 | 1 | M. | Mounir | Chakkar | ||
| 17020000005585 | L17/amo20 | 17 | 17020000005568 | 17020000005583 | 2 | Mme | Isabelle | Calmels | ||
| 17020000005586 | L17/amo20 | 17 | 17020000005568 | 17020000005583 | 3 | Mme | Clémence | Guichard | ||
| 17020000005636 | L17/amo20 | 17 | 17020000005587 | 17020000005635 | 1 | M. | Philippe | Philidor | ||
| 17020000005637 | L17/amo20 | 17 | 17020000005587 | 17020000005635 | 2 | M. | Jacob | Ambrosio | ||
| 17020000005638 | L17/amo20 | 17 | 17020000005587 | 17020000005635 | 3 | Mme | Marie-Elie | Grandbois | ||
| 17020000005639 | L17/amo20 | 17 | 17020000005587 | 17020000005635 | 4 | M. | Léo | Mogin | ||
| 17020000005689 | L17/amo20 | 17 | 17020000005640 | 17020000005688 | 1 | Mme | Evelyne | Gigan |