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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17020000020593 | L17/amo20 | 17 | 17020000020504 | 17020000020592 | 1 | Mme | Liana | Ghazaryan | ||
| 17020000020594 | L17/amo20 | 17 | 17020000020504 | 17020000020592 | 2 | M. | Timothé | Chaudon | ||
| 17020000020595 | L17/amo20 | 17 | 17020000020504 | 17020000020592 | 3 | Mme | Alice-Anne | Pauleau | ||
| 17020000020663 | L17/amo20 | 17 | 17020000020635 | 17020000020662 | 1 | Mme | Philippine | Rambaud | ||
| 17020000020664 | L17/amo20 | 17 | 17020000020635 | 17020000020662 | 2 | M. | Amaury | Genin | ||
| 17020000020665 | L17/amo20 | 17 | 17020000020635 | 17020000020662 | 3 | M. | Thibault | Pellissier | ||
| 17020000020742 | L17/amo20 | 17 | 17020000020666 | 17020000020741 | 1 | M. | Jean-François | Collec | ||
| 17020000020743 | L17/amo20 | 17 | 17020000020666 | 17020000020741 | 2 | Mme | Sarah | Cauzit | ||
| 17020000020760 | L17/amo20 | 17 | 17020000020744 | 17020000020759 | 1 | M. | Bernard | Mula | ||
| 17020000020761 | L17/amo20 | 17 | 17020000020744 | 17020000020759 | 2 | M. | Bernard | Decocq | ||
| 17020000020762 | L17/amo20 | 17 | 17020000020744 | 17020000020759 | 3 | Mme | Claire | Pélissonnier | ||
| 17020000020763 | L17/amo20 | 17 | 17020000020744 | 17020000020759 | 4 | M. | Cyprien | Dossa | ||
| 17020000020865 | L17/amo20 | 17 | 17020000020807 | 17020000020864 | 1 | M. | Damien | Daurès | ||
| 17020000020866 | L17/amo20 | 17 | 17020000020807 | 17020000020864 | 2 | M. | Romain | Prélot | ||
| 17020000020867 | L17/amo20 | 17 | 17020000020807 | 17020000020864 | 3 | M. | Antoine | Cholet-Eyraud | ||
| 17020000020868 | L17/amo20 | 17 | 17020000020807 | 17020000020864 | 4 | M. | Maël | Reininger | ||
| 17020000020879 | L17/amo20 | 17 | 17020000020869 | 17020000020878 | 1 | Mme | Suzanne | Veyron | ||
| 17020000020880 | L17/amo20 | 17 | 17020000020869 | 17020000020878 | 2 | M. | Nawri | Boughita--Sauvanet | ||
| 17020000020881 | L17/amo20 | 17 | 17020000020869 | 17020000020878 | 3 | Mme | Lucie | Morel | ||
| 17020000020935 | L17/amo20 | 17 | 17020000020882 | 17020000020934 | 1 | Mme | Hager | Jacquemin | ||
| 17020000020936 | L17/amo20 | 17 | 17020000020882 | 17020000020934 | 2 | Mme | Christine | Dumas | ||
| 17020000020937 | L17/amo20 | 17 | 17020000020882 | 17020000020934 | 3 | M. | Esteban | Maillot | ||
| 17020000020938 | L17/amo20 | 17 | 17020000020882 | 17020000020934 | 4 | M. | Jordi | Vives Carceller | ||
| 17020000020939 | L17/amo20 | 17 | 17020000020882 | 17020000020934 | 5 | Mme | Clémence | Naveys-Dumas | ||
| 17020000021036 | L17/amo20 | 17 | 17020000021017 | 17020000021035 | 1 | M. | Matteo | Pavone | ||
| 17020000021068 | L17/amo20 | 17 | 17020000021037 | 17020000021067 | 1 | Mme | Auriane | Peinaud | ||
| 17020000021069 | L17/amo20 | 17 | 17020000021037 | 17020000021067 | 2 | Mme | Anne-Sophie | Lahaye | ||
| 17020000021070 | L17/amo20 | 17 | 17020000021037 | 17020000021067 | 3 | M. | Mathias | Gouëset | ||
| 17020000021181 | L17/amo20 | 17 | 17020000021071 | 17020000021180 | 1 | Mme | Jeanne | Loison | ||
| 17020000021182 | L17/amo20 | 17 | 17020000021071 | 17020000021180 | 2 | Mme | Pauline | Rapilly--Ferniot | ||
| 17020000021183 | L17/amo20 | 17 | 17020000021071 | 17020000021180 | 3 | Mme | Louise | Nahy-Schmidt | ||
| 17020000021240 | L17/amo20 | 17 | 17020000021184 | 17020000021239 | 1 | Mme | Emmanuelle | Dupas | ||
| 17020000021241 | L17/amo20 | 17 | 17020000021184 | 17020000021239 | 2 | Mme | Claire | Debré-Chaffaud | ||
| 17020000021242 | L17/amo20 | 17 | 17020000021184 | 17020000021239 | 3 | M. | Pierre | Chambolle | ||
| 17020000021296 | L17/amo20 | 17 | 17020000021243 | 17020000021295 | 1 | Mme | Catherine | Netoudykata | ||
| 17020000021297 | L17/amo20 | 17 | 17020000021243 | 17020000021295 | 2 | Mme | Marion | Hureau | ||
| 17020000021298 | L17/amo20 | 17 | 17020000021243 | 17020000021295 | 3 | Mme | Carolina | Faye | ||
| 17020000021299 | L17/amo20 | 17 | 17020000021243 | 17020000021295 | 4 | M. | Arnaud | Pinçon | ||
| 17020000021363 | L17/amo20 | 17 | 17020000021300 | 17020000021362 | 1 | Mme | Agathe | Arsenne | ||
| 17020000021364 | L17/amo20 | 17 | 17020000021300 | 17020000021362 | 2 | M. | Lou | Noirclere | ||
| 17020000021365 | L17/amo20 | 17 | 17020000021300 | 17020000021362 | 3 | Mme | Marion | Froger | ||
| 17020000021366 | L17/amo20 | 17 | 17020000021300 | 17020000021362 | 4 | Mme | Chloé | Coupat | ||
| 17020000021367 | L17/amo20 | 17 | 17020000021300 | 17020000021362 | 5 | M. | Jules | Viot | ||
| 17020000021399 | L17/amo20 | 17 | 17020000021368 | 17020000021398 | 1 | M. | Thomas | Gagnieu | ||
| 17020000021400 | L17/amo20 | 17 | 17020000021368 | 17020000021398 | 2 | Mme | Aurore | Meyrieux | ||
| 17020000021401 | L17/amo20 | 17 | 17020000021368 | 17020000021398 | 3 | M. | Alexandre | Moulin-Comte | ||
| 17020000021402 | L17/amo20 | 17 | 17020000021368 | 17020000021398 | 4 | M. | Jérôme | Cochet | ||
| 17020000021454 | L17/amo20 | 17 | 17020000021403 | 17020000021453 | 1 | M. | Bastien | Tissier | ||
| 17020000021455 | L17/amo20 | 17 | 17020000021403 | 17020000021453 | 2 | M. | Paul | Madinier | ||
| 17020000021456 | L17/amo20 | 17 | 17020000021403 | 17020000021453 | 3 | M. | Luc | Foschia |