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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 17020000009285 | L17/amo20 | 17 | 17020000009260 | 17020000009282 | 3 | M. | Nicolas | Bighetti de Flogny | ||
| 17020000009286 | L17/amo20 | 17 | 17020000009260 | 17020000009282 | 4 | Mme | Edith | Frechou | ||
| 17020000009287 | L17/amo20 | 17 | 17020000009260 | 17020000009282 | 5 | Mme | Elsa | Plisson | ||
| 17020000009348 | L17/amo20 | 17 | 17020000009288 | 17020000009347 | 1 | M. | Maxime | David | ||
| 17020000009349 | L17/amo20 | 17 | 17020000009288 | 17020000009347 | 2 | Mme | Mathilde | Desjonquères | ||
| 17020000009350 | L17/amo20 | 17 | 17020000009288 | 17020000009347 | 3 | Mme | Stéphanie | Labeau | ||
| 17020000009351 | L17/amo20 | 17 | 17020000009288 | 17020000009347 | 4 | M. | Marceau | Perez | ||
| 17020000009428 | L17/amo20 | 17 | 17020000009352 | 17020000009427 | 1 | Mme | Marie | Milan-Homolle | ||
| 17020000009429 | L17/amo20 | 17 | 17020000009352 | 17020000009427 | 2 | Mme | Claire | Yannacopoulos | ||
| 17020000009430 | L17/amo20 | 17 | 17020000009352 | 17020000009427 | 3 | M. | Evan | Ferroti | ||
| 17020000009431 | L17/amo20 | 17 | 17020000009352 | 17020000009427 | 4 | M. | Boris | Bessenay | ||
| 17020000009490 | L17/amo20 | 17 | 17020000009443 | 17020000009489 | 1 | Mme | Claire | Rives | ||
| 17020000009491 | L17/amo20 | 17 | 17020000009443 | 17020000009489 | 2 | M. | Dorian | Terral | ||
| 17020000009492 | L17/amo20 | 17 | 17020000009443 | 17020000009489 | 3 | M. | Alexy | Rodriguez | ||
| 17020000009556 | L17/amo20 | 17 | 17020000009493 | 17020000009555 | 1 | Mme | Sophie | Roulet | ||
| 17020000009557 | L17/amo20 | 17 | 17020000009493 | 17020000009555 | 2 | Mme | Eloïse | Favennec-Bécot | ||
| 17020000009669 | L17/amo20 | 17 | 17020000009616 | 17020000009668 | 1 | Mme | Amandine | Rollin | ||
| 17020000009670 | L17/amo20 | 17 | 17020000009616 | 17020000009668 | 2 | M. | Omar | Joui | ||
| 17020000009694 | L17/amo20 | 17 | 17020000009671 | 17020000009693 | 1 | Mme | Mariel | Missud | ||
| 17020000009695 | L17/amo20 | 17 | 17020000009671 | 17020000009693 | 2 | Mme | Alice | Dekker | ||
| 17020000009696 | L17/amo20 | 17 | 17020000009671 | 17020000009693 | 3 | Mme | Agnès | Oberdorff | ||
| 17020000009697 | L17/amo20 | 17 | 17020000009671 | 17020000009693 | 4 | Mme | Laura | Verkaeren | ||
| 17020000009698 | L17/amo20 | 17 | 17020000009671 | 17020000009693 | 5 | M. | Nicolas | Dupiech | ||
| 17020000009746 | L17/amo20 | 17 | 17020000009699 | 17020000009745 | 1 | Mme | Elisabeth | Tremblay | ||
| 17020000009747 | L17/amo20 | 17 | 17020000009699 | 17020000009745 | 2 | M. | Frédéric | Petry | ||
| 17020000009748 | L17/amo20 | 17 | 17020000009699 | 17020000009745 | 3 | M. | Philippe | Algoet | ||
| 17020000009749 | L17/amo20 | 17 | 17020000009699 | 17020000009745 | 4 | M. | Michel | Chatelais | ||
| 17020000009750 | L17/amo20 | 17 | 17020000009699 | 17020000009745 | 5 | Mme | Mathilde | Cohidon-Ramage | ||
| 17020000009812 | L17/amo20 | 17 | 17020000009751 | 17020000009811 | 1 | Mme | Agathe | Kwantes | ||
| 17020000009813 | L17/amo20 | 17 | 17020000009751 | 17020000009811 | 2 | M. | Marwane | Mennane | ||
| 17020000009814 | L17/amo20 | 17 | 17020000009751 | 17020000009811 | 3 | Mme | Cécile | Fleurance | ||
| 17020000009815 | L17/amo20 | 17 | 17020000009751 | 17020000009811 | 4 | Mme | Pauline | Idasiak | ||
| 17020000009879 | L17/amo20 | 17 | 17020000009816 | 17020000009878 | 1 | M. | Antoine | Guiony | ||
| 17020000009880 | L17/amo20 | 17 | 17020000009816 | 17020000009878 | 2 | Mme | Françoise | Raymond | ||
| 17020000010034 | L17/amo20 | 17 | 17020000009944 | 17020000010033 | 1 | Mme | Sandrine | Poulet | ||
| 17020000010035 | L17/amo20 | 17 | 17020000009944 | 17020000010033 | 2 | Mme | Maryll | Vignal | ||
| 17020000010036 | L17/amo20 | 17 | 17020000009944 | 17020000010033 | 3 | Mme | Marie-Hélène | Fillâtre | ||
| 17020000010037 | L17/amo20 | 17 | 17020000009944 | 17020000010033 | 4 | M. | Paul-Arthur | Leblois | ||
| 17020000010075 | L17/amo20 | 17 | 17020000010038 | 17020000010074 | 1 | Mme | Elodie | Trembley | ||
| 17020000010076 | L17/amo20 | 17 | 17020000010038 | 17020000010074 | 2 | M. | Augustin | Delavenne | ||
| 17020000010123 | L17/amo20 | 17 | 17020000010077 | 17020000010122 | 1 | M. | Jérôme | Hébert | ||
| 17020000010124 | L17/amo20 | 17 | 17020000010077 | 17020000010122 | 2 | Mme | Margot | Judas | ||
| 17020000010125 | L17/amo20 | 17 | 17020000010077 | 17020000010122 | 3 | Mme | Mathilde | Brunel | ||
| 17020000010161 | L17/amo20 | 17 | 17020000010126 | 17020000010160 | 1 | Mme | Nastasia | Dufour | ||
| 17020000010162 | L17/amo20 | 17 | 17020000010126 | 17020000010160 | 2 | Mme | Margaux | Escudier | ||
| 17020000010246 | L17/amo20 | 17 | 17020000010163 | 17020000010245 | 1 | M. | Nicolas | Le Graët | ||
| 17020000010247 | L17/amo20 | 17 | 17020000010163 | 17020000010245 | 2 | Mme | Christine | Le Gouëf | ||
| 17020000010248 | L17/amo20 | 17 | 17020000010163 | 17020000010245 | 3 | M. | Quentin | Jarno | ||
| 17020000010298 | L17/amo20 | 17 | 17020000010249 | 17020000010297 | 1 | Mme | Nadia | Thami | ||
| 17020000010299 | L17/amo20 | 17 | 17020000010249 | 17020000010297 | 2 | Mme | Lisa | Wingerter |