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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 15020000031163 | L15/amo20 | 15 | 15020000031100 | 15020000031161 | 2 | M. | Quentin | Simon | ||
| 15020000031205 | L15/amo20 | 15 | 15020000031164 | 15020000031204 | 1 | Mme | Anita | Royer | ||
| 15020000031206 | L15/amo20 | 15 | 15020000031164 | 15020000031204 | 2 | Mme | Marie | Faverjon | ||
| 15020000031207 | L15/amo20 | 15 | 15020000031164 | 15020000031204 | 3 | M. | Jordan | Esnault | ||
| 15020000031256 | L15/amo20 | 15 | 15020000031208 | 15020000031255 | 1 | Mme | Anne | Thibierge | ||
| 15020000031257 | L15/amo20 | 15 | 15020000031208 | 15020000031255 | 2 | M. | Emmanuel | Grelier | ||
| 15020000031258 | L15/amo20 | 15 | 15020000031208 | 15020000031255 | 3 | Mme | Fanny | Pacreau | ||
| 15020000031312 | L15/amo20 | 15 | 15020000031259 | 15020000031311 | 1 | M. | Stéphan | Fautrat | ||
| 15020000031313 | L15/amo20 | 15 | 15020000031259 | 15020000031311 | 2 | Mme | Maïté | Sève | ||
| 15020000031314 | L15/amo20 | 15 | 15020000031259 | 15020000031311 | 3 | Mme | Gabrielle | Perret | ||
| 15020000031315 | L15/amo20 | 15 | 15020000031259 | 15020000031311 | 4 | M. | Jordan | Challier | ||
| 15020000031356 | L15/amo20 | 15 | 15020000031316 | 15020000031355 | 1 | Mme | Nadège | Condat | ||
| 15020000031357 | L15/amo20 | 15 | 15020000031316 | 15020000031355 | 2 | Mme | Ariane | Forgues-Enaud | ||
| 15020000031358 | L15/amo20 | 15 | 15020000031316 | 15020000031355 | 3 | M. | Guillaume | Jollet | ||
| 15020000031401 | L15/amo20 | 15 | 15020000031359 | 15020000031400 | 1 | Mme | Amandine | Rollin | ||
| 15020000031402 | L15/amo20 | 15 | 15020000031359 | 15020000031400 | 2 | Mme | Marion | Nowak | ||
| 15020000031403 | L15/amo20 | 15 | 15020000031359 | 15020000031400 | 3 | M. | Stéphane | Feutry | ||
| 15020000031455 | L15/amo20 | 15 | 15020000031404 | 15020000031454 | 1 | M. | Julien | Ibos | ||
| 15020000031456 | L15/amo20 | 15 | 15020000031404 | 15020000031454 | 2 | Mme | Mariel | Missud | ||
| 15020000031457 | L15/amo20 | 15 | 15020000031404 | 15020000031454 | 3 | Mme | Alice | Dekker | ||
| 15020000031458 | L15/amo20 | 15 | 15020000031404 | 15020000031454 | 4 | Mme | Agnès | Oberdorff | ||
| 15020000031459 | L15/amo20 | 15 | 15020000031404 | 15020000031454 | 5 | Mme | Laura | Verkaeren | ||
| 15020000031499 | L15/amo20 | 15 | 15020000031460 | 15020000031498 | 1 | Mme | Pascale | Condette | ||
| 15020000031500 | L15/amo20 | 15 | 15020000031460 | 15020000031498 | 2 | M. | Guillaume | Leger | ||
| 15020000031501 | L15/amo20 | 15 | 15020000031460 | 15020000031498 | 3 | M. | Aymeric | Provost | ||
| 15020000031536 | L15/amo20 | 15 | 15020000031502 | 15020000031535 | 1 | Mme | Soizic | Le Coq | ||
| 15020000031537 | L15/amo20 | 15 | 15020000031502 | 15020000031535 | 2 | Mme | Marie-Amélie | Wolff-Boutbien | ||
| 15020000031569 | L15/amo20 | 15 | 15020000031538 | 15020000031568 | 1 | Mme | Floriane | Souchet | ||
| 15020000031570 | L15/amo20 | 15 | 15020000031538 | 15020000031568 | 2 | Mme | Zakia | Ouhmida-Mortreau | ||
| 15020000031606 | L15/amo20 | 15 | 15020000031574 | 15020000031605 | 1 | Mme | Elisabeth | Tremblay | ||
| 15020000031607 | L15/amo20 | 15 | 15020000031574 | 15020000031605 | 2 | M. | Frédéric | Petry | ||
| 15020000031608 | L15/amo20 | 15 | 15020000031574 | 15020000031605 | 3 | M. | Thomas | Lesage | ||
| 15020000031609 | L15/amo20 | 15 | 15020000031574 | 15020000031605 | 4 | M. | Philippe | Algoet | ||
| 15020000031610 | L15/amo20 | 15 | 15020000031574 | 15020000031605 | 5 | M. | Michel | Chatelais | ||
| 15020000031611 | L15/amo20 | 15 | 15020000031574 | 15020000031605 | 6 | M. | Pierre-Yves | Douet | ||
| 15020000031667 | L15/amo20 | 15 | 15020000031612 | 15020000031666 | 1 | Mme | Josiane | Collon | ||
| 15020000031668 | L15/amo20 | 15 | 15020000031612 | 15020000031666 | 2 | Mme | Agathe | Kwantes | ||
| 15020000031669 | L15/amo20 | 15 | 15020000031612 | 15020000031666 | 3 | M. | Marwane | Mennane | ||
| 15020000031725 | L15/amo20 | 15 | 15020000031670 | 15020000031724 | 1 | Mme | Nacira | Megherbi | ||
| 15020000031726 | L15/amo20 | 15 | 15020000031670 | 15020000031724 | 2 | Mme | Noémie | Chardon | ||
| 15020000031772 | L15/amo20 | 15 | 15020000031727 | 15020000031771 | 1 | M. | Gilles | Guillamot | ||
| 15020000031773 | L15/amo20 | 15 | 15020000031727 | 15020000031771 | 2 | Mme | Anaïs | Fournier | ||
| 15020000031839 | L15/amo20 | 15 | 15020000031774 | 15020000031838 | 1 | Mme | Clémence | Aubry | ||
| 15020000031840 | L15/amo20 | 15 | 15020000031774 | 15020000031838 | 2 | M. | Bérenger | Ambroise | ||
| 15020000031903 | L15/amo20 | 15 | 15020000031895 | 15020000031902 | 1 | Mme | Nathalie | Parent-Heckler | ||
| 15020000031904 | L15/amo20 | 15 | 15020000031895 | 15020000031902 | 2 | Mme | Nathalie | Greffin | ||
| 15020000031958 | L15/amo20 | 15 | 15020000031905 | 15020000031957 | 1 | Mme | Sandrine | Poulet | ||
| 15020000031959 | L15/amo20 | 15 | 15020000031905 | 15020000031957 | 2 | Mme | Maryll | Vignal | ||
| 15020000031960 | L15/amo20 | 15 | 15020000031905 | 15020000031957 | 3 | Mme | Marie-Hélène | Fillatre | ||
| 15020000031961 | L15/amo20 | 15 | 15020000031905 | 15020000031957 | 4 | M. | Paul-Arthur | Leblois |