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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17030000142313 | L17/amo30 | 17 | 17030000142117 | 17030000142311 | 2 | Mme | Diane | Virecoulon | ||
| 17030000142314 | L17/amo30 | 17 | 17030000142117 | 17030000142311 | 3 | M. | Quentin | Desiré | ||
| 17030000142315 | L17/amo30 | 17 | 17030000142117 | 17030000142311 | 4 | Mme | Ludine | Wagner | ||
| 17030000142704 | L17/amo30 | 17 | 17030000142517 | 17030000142703 | 1 | Mme | Fabienne | Tirtiaux | ||
| 17030000142705 | L17/amo30 | 17 | 17030000142517 | 17030000142703 | 2 | M. | Mathieu | Girandola | ||
| 17030000142706 | L17/amo30 | 17 | 17030000142517 | 17030000142703 | 3 | Mme | Lou | Esposito | ||
| 17030000142707 | L17/amo30 | 17 | 17030000142517 | 17030000142703 | 4 | M. | Maxime | Jambou | ||
| 17030000142849 | L17/amo30 | 17 | 17030000142710 | 17030000142848 | 1 | M. | Cyril | Berthier | ||
| 17030000142850 | L17/amo30 | 17 | 17030000142710 | 17030000142848 | 2 | M. | David | Ouzilou | ||
| 17030000142851 | L17/amo30 | 17 | 17030000142710 | 17030000142848 | 3 | Mme | Maelle | Savidan Midroit | ||
| 17030000143013 | L17/amo30 | 17 | 17030000142854 | 17030000143012 | 1 | Mme | Jacqueline | Lebrun | ||
| 17030000143014 | L17/amo30 | 17 | 17030000142854 | 17030000143012 | 2 | Mme | Karin | Kamalanavin | ||
| 17030000143015 | L17/amo30 | 17 | 17030000142854 | 17030000143012 | 3 | M. | Bastien | Da Silva Matias | ||
| 17030000143092 | L17/amo30 | 17 | 17030000143018 | 17030000143091 | 1 | Mme | Cécile | Muschotti | ||
| 17030000143093 | L17/amo30 | 17 | 17030000143018 | 17030000143091 | 2 | Mme | Christine | Christiansen | ||
| 17030000143094 | L17/amo30 | 17 | 17030000143018 | 17030000143091 | 3 | M. | Pierre-Antoine | Joly | ||
| 17030000143095 | L17/amo30 | 17 | 17030000143018 | 17030000143091 | 4 | M. | Jean | Payebien | ||
| 17030000143096 | L17/amo30 | 17 | 17030000143018 | 17030000143091 | 5 | M. | Céleste | Macquet | ||
| 17030000143233 | L17/amo30 | 17 | 17030000143099 | 17030000143232 | 1 | M. | Emmanuel | Rey | ||
| 17030000143234 | L17/amo30 | 17 | 17030000143099 | 17030000143232 | 2 | Mme | Isabelle | Lenglain | ||
| 17030000143235 | L17/amo30 | 17 | 17030000143099 | 17030000143232 | 3 | M. | Lucas | Leruste | ||
| 17030000143236 | L17/amo30 | 17 | 17030000143099 | 17030000143232 | 4 | Mme | Clara | Martinovic | ||
| 17030000144890 | L17/amo30 | 17 | 17030000144768 | 17030000144889 | 1 | Mme | Laétitia | Boutrais | ||
| 17030000144891 | L17/amo30 | 17 | 17030000144768 | 17030000144889 | 2 | Mme | Manon | Amirshahi | ||
| 17030000144892 | L17/amo30 | 17 | 17030000144768 | 17030000144889 | 3 | Mme | Sarah | Robin | ||
| 17030000144893 | L17/amo30 | 17 | 17030000144768 | 17030000144889 | 4 | Mme | Maritza | Munoz | ||
| 17030000146671 | L17/amo30 | 17 | 17030000146618 | 17030000146670 | 1 | M. | Olivier | Castel | ||
| 17030000146672 | L17/amo30 | 17 | 17030000146618 | 17030000146670 | 2 | M. | Jean-Claude | Benard | ||
| 17030000146673 | L17/amo30 | 17 | 17030000146618 | 17030000146670 | 3 | Mme | Sabine | Kulifekai-Sako | ||
| 17030000146674 | L17/amo30 | 17 | 17030000146618 | 17030000146670 | 4 | Mme | Logokiuva | Taalo | ||
| 17030000146847 | L17/amo30 | 17 | 17030000146783 | 17030000146846 | 1 | M. | Vianney | Calibre | ||
| 17030000146848 | L17/amo30 | 17 | 17030000146783 | 17030000146846 | 2 | Mme | Marine | Defalt | ||
| 17030000146849 | L17/amo30 | 17 | 17030000146783 | 17030000146846 | 3 | Mme | Stéphanie | Sloboda | ||
| 17030000147525 | L17/amo30 | 17 | 17030000147283 | 17030000147524 | 1 | M. | Michel | Chassereau | ||
| 17030000147526 | L17/amo30 | 17 | 17030000147283 | 17030000147524 | 2 | Mme | Océane | Cherré | ||
| 17030000147527 | L17/amo30 | 17 | 17030000147283 | 17030000147524 | 3 | M. | Gauthier | Boiza | ||
| 17030000147681 | L17/amo30 | 17 | 17030000147541 | 17030000147680 | 1 | M. | Cyril | Blondel | ||
| 17030000147682 | L17/amo30 | 17 | 17030000147541 | 17030000147680 | 2 | Mme | Delphine | Martin | ||
| 17030000147683 | L17/amo30 | 17 | 17030000147541 | 17030000147680 | 3 | M. | Guillaume | Seris | ||
| 17030000147860 | L17/amo30 | 17 | 17030000147685 | 17030000147859 | 1 | M. | Stéphane | Exposito | ||
| 17030000147861 | L17/amo30 | 17 | 17030000147685 | 17030000147859 | 2 | M. | Aurélien | Carré | ||
| 17030000148033 | L17/amo30 | 17 | 17030000147863 | 17030000148032 | 1 | Mme | Julie | Lebihan | ||
| 17030000148034 | L17/amo30 | 17 | 17030000147863 | 17030000148032 | 2 | M. | Stevie | Coudray | ||
| 17030000148035 | L17/amo30 | 17 | 17030000147863 | 17030000148032 | 3 | Mme | Anne-Laure | Payet | ||
| 17030000148036 | L17/amo30 | 17 | 17030000147863 | 17030000148032 | 4 | Mme | Coralie | Payet | ||
| 17030000149735 | L17/amo30 | 17 | 17030000149651 | 17030000149734 | 1 | M. | Anthony | Gony | ||
| 17030000149736 | L17/amo30 | 17 | 17030000149651 | 17030000149734 | 2 | M. | Alexandre | Gore | ||
| 17030000149737 | L17/amo30 | 17 | 17030000149651 | 17030000149734 | 3 | M. | Guillaume | Poignet | ||
| 17030000149738 | L17/amo30 | 17 | 17030000149651 | 17030000149734 | 4 | M. | Julien | Roussel | ||
| 17030000149847 | L17/amo30 | 17 | 17030000149739 | 17030000149846 | 1 | M. | Hendrik | Porte |