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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17030000083307 | L17/amo30 | 17 | 17030000083200 | 17030000083306 | 1 | M. | Théo | Kececioglu | ||
| 17030000083308 | L17/amo30 | 17 | 17030000083200 | 17030000083306 | 2 | M. | Kévin | Jacquet | ||
| 17030000083309 | L17/amo30 | 17 | 17030000083200 | 17030000083306 | 3 | M. | Simon | Hocké-Douard | ||
| 17030000083310 | L17/amo30 | 17 | 17030000083200 | 17030000083306 | 4 | M. | Valentin | Grezet | ||
| 17030000083449 | L17/amo30 | 17 | 17030000083334 | 17030000083448 | 1 | M. | François-Joseph | Fazi | ||
| 17030000083450 | L17/amo30 | 17 | 17030000083334 | 17030000083448 | 2 | Mme | Vanina | Batistini Fenocchi | ||
| 17030000083451 | L17/amo30 | 17 | 17030000083334 | 17030000083448 | 3 | Mme | Juliette | Fricot | ||
| 17030000085210 | L17/amo30 | 17 | 17030000085128 | 17030000085209 | 1 | M. | Stéphane | Herb | ||
| 17030000085211 | L17/amo30 | 17 | 17030000085128 | 17030000085209 | 2 | M. | Gemel | Ben Saïd | ||
| 17030000085212 | L17/amo30 | 17 | 17030000085128 | 17030000085209 | 3 | Mme | Sarah | Richard | ||
| 17030000085427 | L17/amo30 | 17 | 17030000085323 | 17030000085426 | 1 | M. | Colas | Valat | ||
| 17030000085428 | L17/amo30 | 17 | 17030000085323 | 17030000085426 | 2 | M. | Kévin | Havet | ||
| 17030000085429 | L17/amo30 | 17 | 17030000085323 | 17030000085426 | 3 | M. | Thomas | Brault | ||
| 17030000085430 | L17/amo30 | 17 | 17030000085323 | 17030000085426 | 4 | M. | Roméo | Le Floch | ||
| 17030000085431 | L17/amo30 | 17 | 17030000085323 | 17030000085426 | 5 | Mme | Mariam | Soufane | ||
| 17030000086005 | L17/amo30 | 17 | 17030000085957 | 17030000086004 | 1 | Mme | Lucile | Vuillermoz | ||
| 17030000086006 | L17/amo30 | 17 | 17030000085957 | 17030000086004 | 2 | M. | Arthur | Job | ||
| 17030000086007 | L17/amo30 | 17 | 17030000085957 | 17030000086004 | 3 | M. | Medhi | Renard | ||
| 17030000086381 | L17/amo30 | 17 | 17030000086238 | 17030000086380 | 1 | Mme | Anaïs | Roussange-Chaillou | ||
| 17030000086382 | L17/amo30 | 17 | 17030000086238 | 17030000086380 | 2 | Mme | Nelly | Dioudonnat | ||
| 17030000086383 | L17/amo30 | 17 | 17030000086238 | 17030000086380 | 3 | M. | Florent | Bouchez | ||
| 17030000086384 | L17/amo30 | 17 | 17030000086238 | 17030000086380 | 4 | Mme | Catherine | Polge | ||
| 17030000086635 | L17/amo30 | 17 | 17030000086501 | 17030000086634 | 1 | Mme | Carine | Dronet | ||
| 17030000086636 | L17/amo30 | 17 | 17030000086501 | 17030000086634 | 2 | Mme | Karine | Le Gal | ||
| 17030000086637 | L17/amo30 | 17 | 17030000086501 | 17030000086634 | 3 | Mme | Claire | Gérault | ||
| 17030000086638 | L17/amo30 | 17 | 17030000086501 | 17030000086634 | 4 | Mme | Rita | Leonhardmair | ||
| 17030000086639 | L17/amo30 | 17 | 17030000086501 | 17030000086634 | 5 | Mme | Gamze | Atalay | ||
| 17030000087013 | L17/amo30 | 17 | 17030000086864 | 17030000087012 | 1 | Mme | Delphine | Jimenez-Grenier | ||
| 17030000087014 | L17/amo30 | 17 | 17030000086864 | 17030000087012 | 2 | M. | Denis | Bersauter | ||
| 17030000087015 | L17/amo30 | 17 | 17030000086864 | 17030000087012 | 3 | Mme | Mathilde | Blondel | ||
| 17030000087016 | L17/amo30 | 17 | 17030000086864 | 17030000087012 | 4 | Mme | Christel | Camus | ||
| 17030000087017 | L17/amo30 | 17 | 17030000086864 | 17030000087012 | 5 | Mme | Yaëlle | Reynaud | ||
| 17030000087395 | L17/amo30 | 17 | 17030000087153 | 17030000087394 | 1 | M. | Hugo | Gaspar | ||
| 17030000087396 | L17/amo30 | 17 | 17030000087153 | 17030000087394 | 2 | Mme | Esther | Albouy | ||
| 17030000087397 | L17/amo30 | 17 | 17030000087153 | 17030000087394 | 3 | Mme | Domitille | Lécroart | ||
| 17030000087398 | L17/amo30 | 17 | 17030000087153 | 17030000087394 | 4 | M. | Matteo | Vailly | ||
| 17030000087835 | L17/amo30 | 17 | 17030000087536 | 17030000087834 | 1 | Mme | Maëva | Dano | ||
| 17030000087836 | L17/amo30 | 17 | 17030000087536 | 17030000087834 | 2 | M. | Victor | Gallou | ||
| 17030000087837 | L17/amo30 | 17 | 17030000087536 | 17030000087834 | 3 | Mme | Laurine | Orêve | ||
| 17030000089060 | L17/amo30 | 17 | 17030000088822 | 17030000089059 | 1 | M. | Jérôme | Petit | ||
| 17030000089061 | L17/amo30 | 17 | 17030000088822 | 17030000089059 | 2 | Mme | Martine | Planteblat | ||
| 17030000089062 | L17/amo30 | 17 | 17030000088822 | 17030000089059 | 3 | Mme | Charlotte | Watine | ||
| 17030000089063 | L17/amo30 | 17 | 17030000088822 | 17030000089059 | 4 | Mme | Catherine | Bafoil | ||
| 17030000089261 | L17/amo30 | 17 | 17030000089150 | 17030000089260 | 1 | M. | Joé | Mendes Monteiro | ||
| 17030000089262 | L17/amo30 | 17 | 17030000089150 | 17030000089260 | 2 | Mme | Margaux | Belot | ||
| 17030000089263 | L17/amo30 | 17 | 17030000089150 | 17030000089260 | 3 | Mme | Muriel | Tancrez | ||
| 17030000089264 | L17/amo30 | 17 | 17030000089150 | 17030000089260 | 4 | M. | Enzo | Amand | ||
| 17030000089861 | L17/amo30 | 17 | 17030000089694 | 17030000089860 | 1 | Mme | Nathalie | Lozito | ||
| 17030000089862 | L17/amo30 | 17 | 17030000089694 | 17030000089860 | 2 | Mme | Catherine | Rieffel | ||
| 17030000089863 | L17/amo30 | 17 | 17030000089694 | 17030000089860 | 3 | Mme | Sylvie | Gruner |