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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17030000156034 | L17/amo30 | 17 | 17030000155897 | 17030000156033 | 1 | Mme | Liana | Ghazaryan | ||
| 17030000156035 | L17/amo30 | 17 | 17030000155897 | 17030000156033 | 2 | M. | Timothé | Chaudon | ||
| 17030000156036 | L17/amo30 | 17 | 17030000155897 | 17030000156033 | 3 | Mme | Alice-Anne | Pauleau | ||
| 17030000156174 | L17/amo30 | 17 | 17030000156109 | 17030000156173 | 1 | Mme | Philippine | Rambaud | ||
| 17030000156175 | L17/amo30 | 17 | 17030000156109 | 17030000156173 | 2 | M. | Amaury | Genin | ||
| 17030000156176 | L17/amo30 | 17 | 17030000156109 | 17030000156173 | 3 | M. | Thibault | Pellissier | ||
| 17030000156324 | L17/amo30 | 17 | 17030000156224 | 17030000156323 | 1 | M. | Jean-François | Collec | ||
| 17030000156325 | L17/amo30 | 17 | 17030000156224 | 17030000156323 | 2 | Mme | Sarah | Cauzit | ||
| 17030000156472 | L17/amo30 | 17 | 17030000156434 | 17030000156471 | 1 | M. | Bernard | Mula | ||
| 17030000156473 | L17/amo30 | 17 | 17030000156434 | 17030000156471 | 2 | M. | Bernard | Decocq | ||
| 17030000156474 | L17/amo30 | 17 | 17030000156434 | 17030000156471 | 3 | Mme | Claire | Pélissonnier | ||
| 17030000156475 | L17/amo30 | 17 | 17030000156434 | 17030000156471 | 4 | M. | Cyprien | Dossa | ||
| 17030000156639 | L17/amo30 | 17 | 17030000156552 | 17030000156638 | 1 | M. | Damien | Daurès | ||
| 17030000156640 | L17/amo30 | 17 | 17030000156552 | 17030000156638 | 2 | M. | Romain | Prélot | ||
| 17030000156641 | L17/amo30 | 17 | 17030000156552 | 17030000156638 | 3 | M. | Antoine | Cholet-Eyraud | ||
| 17030000156642 | L17/amo30 | 17 | 17030000156552 | 17030000156638 | 4 | M. | Maël | Reininger | ||
| 17030000156653 | L17/amo30 | 17 | 17030000156643 | 17030000156652 | 1 | Mme | Suzanne | Veyron | ||
| 17030000156654 | L17/amo30 | 17 | 17030000156643 | 17030000156652 | 2 | M. | Nawri | Boughita--Sauvanet | ||
| 17030000156655 | L17/amo30 | 17 | 17030000156643 | 17030000156652 | 3 | Mme | Lucie | Morel | ||
| 17030000156741 | L17/amo30 | 17 | 17030000156656 | 17030000156740 | 1 | Mme | Hager | Jacquemin | ||
| 17030000156742 | L17/amo30 | 17 | 17030000156656 | 17030000156740 | 2 | Mme | Christine | Dumas | ||
| 17030000156743 | L17/amo30 | 17 | 17030000156656 | 17030000156740 | 3 | M. | Esteban | Maillot | ||
| 17030000156744 | L17/amo30 | 17 | 17030000156656 | 17030000156740 | 4 | M. | Jordi | Vives Carceller | ||
| 17030000156745 | L17/amo30 | 17 | 17030000156656 | 17030000156740 | 5 | Mme | Clémence | Naveys-Dumas | ||
| 17030000156921 | L17/amo30 | 17 | 17030000156873 | 17030000156920 | 1 | M. | Matteo | Pavone | ||
| 17030000156982 | L17/amo30 | 17 | 17030000156923 | 17030000156981 | 1 | Mme | Auriane | Peinaud | ||
| 17030000156983 | L17/amo30 | 17 | 17030000156923 | 17030000156981 | 2 | Mme | Anne-Sophie | Lahaye | ||
| 17030000156984 | L17/amo30 | 17 | 17030000156923 | 17030000156981 | 3 | M. | Mathias | Gouëset | ||
| 17030000157197 | L17/amo30 | 17 | 17030000157013 | 17030000157196 | 1 | Mme | Jeanne | Loison | ||
| 17030000157198 | L17/amo30 | 17 | 17030000157013 | 17030000157196 | 2 | Mme | Pauline | Rapilly--Ferniot | ||
| 17030000157199 | L17/amo30 | 17 | 17030000157013 | 17030000157196 | 3 | Mme | Louise | Nahy-Schmidt | ||
| 17030000157307 | L17/amo30 | 17 | 17030000157200 | 17030000157306 | 1 | Mme | Emmanuelle | Dupas | ||
| 17030000157308 | L17/amo30 | 17 | 17030000157200 | 17030000157306 | 2 | Mme | Claire | Debré-Chaffaud | ||
| 17030000157309 | L17/amo30 | 17 | 17030000157200 | 17030000157306 | 3 | M. | Pierre | Chambolle | ||
| 17030000157441 | L17/amo30 | 17 | 17030000157341 | 17030000157440 | 1 | Mme | Catherine | Netoudykata | ||
| 17030000157442 | L17/amo30 | 17 | 17030000157341 | 17030000157440 | 2 | Mme | Marion | Hureau | ||
| 17030000157443 | L17/amo30 | 17 | 17030000157341 | 17030000157440 | 3 | Mme | Carolina | Faye | ||
| 17030000157444 | L17/amo30 | 17 | 17030000157341 | 17030000157440 | 4 | M. | Arnaud | Pinçon | ||
| 17030000157535 | L17/amo30 | 17 | 17030000157445 | 17030000157534 | 1 | Mme | Agathe | Arsenne | ||
| 17030000157536 | L17/amo30 | 17 | 17030000157445 | 17030000157534 | 2 | M. | Lou | Noirclere | ||
| 17030000157537 | L17/amo30 | 17 | 17030000157445 | 17030000157534 | 3 | Mme | Marion | Froger | ||
| 17030000157538 | L17/amo30 | 17 | 17030000157445 | 17030000157534 | 4 | Mme | Chloé | Coupat | ||
| 17030000157539 | L17/amo30 | 17 | 17030000157445 | 17030000157534 | 5 | M. | Jules | Viot | ||
| 17030000157639 | L17/amo30 | 17 | 17030000157540 | 17030000157638 | 1 | M. | Thomas | Gagnieu | ||
| 17030000157640 | L17/amo30 | 17 | 17030000157540 | 17030000157638 | 2 | Mme | Aurore | Meyrieux | ||
| 17030000157641 | L17/amo30 | 17 | 17030000157540 | 17030000157638 | 3 | M. | Alexandre | Moulin-Comte | ||
| 17030000157642 | L17/amo30 | 17 | 17030000157540 | 17030000157638 | 4 | M. | Jérôme | Cochet | ||
| 17030000157747 | L17/amo30 | 17 | 17030000157643 | 17030000157746 | 1 | M. | Bastien | Tissier | ||
| 17030000157748 | L17/amo30 | 17 | 17030000157643 | 17030000157746 | 2 | M. | Paul | Madinier | ||
| 17030000157749 | L17/amo30 | 17 | 17030000157643 | 17030000157746 | 3 | M. | Luc | Foschia |