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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 15020000014996 | L15/amo20 | 15 | 15020000014951 | 15020000014995 | 1 | Mme | Céline | Herrmann | ||
| 15020000014997 | L15/amo20 | 15 | 15020000014951 | 15020000014995 | 2 | M. | Clément | Ourgaud | ||
| 15020000014998 | L15/amo20 | 15 | 15020000014951 | 15020000014995 | 3 | M. | Aliaume | Couchard | ||
| 15020000015059 | L15/amo20 | 15 | 15020000015045 | 15020000015058 | 1 | Mme | Janique | Joly | ||
| 15020000015060 | L15/amo20 | 15 | 15020000015045 | 15020000015058 | 2 | M. | Eric | Sequert | ||
| 15020000015224 | L15/amo20 | 15 | 15020000015061 | 15020000015223 | 1 | Mme | Rebecca | Fougnies | ||
| 15020000015225 | L15/amo20 | 15 | 15020000015061 | 15020000015223 | 2 | M. | Magnuson | Lopes | ||
| 15020000015226 | L15/amo20 | 15 | 15020000015061 | 15020000015223 | 3 | Mme | Sinaa | Thabet | ||
| 15020000015227 | L15/amo20 | 15 | 15020000015061 | 15020000015223 | 4 | Mme | Marion | Boutoille | ||
| 15020000015228 | L15/amo20 | 15 | 15020000015061 | 15020000015223 | 5 | M. | Grégoire | Daubigny | ||
| 15020000015229 | L15/amo20 | 15 | 15020000015061 | 15020000015223 | 6 | Mme | Angel | Ruggeri | ||
| 15020000015230 | L15/amo20 | 15 | 15020000015061 | 15020000015223 | 7 | M. | Antoine | Astic | ||
| 15020000015316 | L15/amo20 | 15 | 15020000015231 | 15020000015315 | 1 | Mme | Sandrine | Le-Vourch | ||
| 15020000015317 | L15/amo20 | 15 | 15020000015231 | 15020000015315 | 2 | M. | Noé | Girardot-Champsaur | ||
| 15020000015318 | L15/amo20 | 15 | 15020000015231 | 15020000015315 | 3 | M. | Arnaud | Battefort | ||
| 15020000015391 | L15/amo20 | 15 | 15020000015319 | 15020000015390 | 1 | M. | Bertrand | Varin | ||
| 15020000015392 | L15/amo20 | 15 | 15020000015319 | 15020000015390 | 2 | Mme | Krystel | Doosterlinck | ||
| 15020000015393 | L15/amo20 | 15 | 15020000015319 | 15020000015390 | 3 | M. | Benjamin | Boutin | ||
| 15020000015420 | L15/amo20 | 15 | 15020000015394 | 15020000015419 | 1 | Mme | Clara | Leibundguth | ||
| 15020000015421 | L15/amo20 | 15 | 15020000015394 | 15020000015419 | 2 | M. | Boris | Marchal | ||
| 15020000015528 | L15/amo20 | 15 | 15020000015423 | 15020000015527 | 1 | M. | Francois-Xavier | Royer | ||
| 15020000015529 | L15/amo20 | 15 | 15020000015423 | 15020000015527 | 2 | M. | Rémy | Barges | ||
| 15020000015530 | L15/amo20 | 15 | 15020000015423 | 15020000015527 | 3 | M. | Guillaume | Fillon | ||
| 15020000015531 | L15/amo20 | 15 | 15020000015423 | 15020000015527 | 4 | M. | NICOLAS | Delaire | ||
| 15020000015532 | L15/amo20 | 15 | 15020000015423 | 15020000015527 | 5 | Mme | Frédérique | Riam | ||
| 15020000015533 | L15/amo20 | 15 | 15020000015423 | 15020000015527 | 6 | M. | Lucas | Menais | ||
| 15020000015588 | L15/amo20 | 15 | 15020000015535 | 15020000015587 | 1 | Mme | Stéphanie | Costa | ||
| 15020000015589 | L15/amo20 | 15 | 15020000015535 | 15020000015587 | 2 | M. | Sebastien | Arzalier | ||
| 15020000015590 | L15/amo20 | 15 | 15020000015535 | 15020000015587 | 3 | M. | Frédéric | Milhiet | ||
| 15020000015689 | L15/amo20 | 15 | 15020000015649 | 15020000015688 | 1 | M. | Guillaume | Travaglini | ||
| 15020000015690 | L15/amo20 | 15 | 15020000015649 | 15020000015688 | 2 | M. | Maxime | Munier | ||
| 15020000015772 | L15/amo20 | 15 | 15020000015691 | 15020000015771 | 1 | Mme | Marie | Bonnet | ||
| 15020000015773 | L15/amo20 | 15 | 15020000015691 | 15020000015771 | 2 | Mme | Evelyne | Gatto | ||
| 15020000015774 | L15/amo20 | 15 | 15020000015691 | 15020000015771 | 3 | Mme | Lucie | Philippe | ||
| 15020000015775 | L15/amo20 | 15 | 15020000015691 | 15020000015771 | 4 | Mme | Clara | Courtet | ||
| 15020000015776 | L15/amo20 | 15 | 15020000015691 | 15020000015771 | 5 | Mme | Marie-Eve | Malouines | ||
| 15020000015855 | L15/amo20 | 15 | 15020000015777 | 15020000015854 | 1 | M. | Arnaud | Marignier | ||
| 15020000015856 | L15/amo20 | 15 | 15020000015777 | 15020000015854 | 2 | M. | Maxime | Audap | ||
| 15020000015857 | L15/amo20 | 15 | 15020000015777 | 15020000015854 | 3 | M. | Thomas | Batigne | ||
| 15020000015889 | L15/amo20 | 15 | 15020000015858 | 15020000015888 | 1 | Mme | Soizic | Kerbrat | ||
| 15020000015890 | L15/amo20 | 15 | 15020000015858 | 15020000015888 | 2 | M. | Yann | Cumunel | ||
| 15020000015891 | L15/amo20 | 15 | 15020000015858 | 15020000015888 | 3 | M. | Denoual | Le Roux | ||
| 15020000016002 | L15/amo20 | 15 | 15020000015892 | 15020000016001 | 1 | Mme | Soukaïna | Ben Jaafar | ||
| 15020000016003 | L15/amo20 | 15 | 15020000015892 | 15020000016001 | 2 | M. | Guillaume | Ramon | ||
| 15020000016004 | L15/amo20 | 15 | 15020000015892 | 15020000016001 | 3 | M. | Romain | Brochard | ||
| 15020000016005 | L15/amo20 | 15 | 15020000015892 | 15020000016001 | 4 | M. | Olivier | Lange | ||
| 15020000016006 | L15/amo20 | 15 | 15020000015892 | 15020000016001 | 5 | Mme | Aurélie | Gadjendra | ||
| 15020000016120 | L15/amo20 | 15 | 15020000016062 | 15020000016119 | 1 | Mme | Alice | d'Eramo | ||
| 15020000016121 | L15/amo20 | 15 | 15020000016062 | 15020000016119 | 2 | Mme | Marie-Sophie | Bessout | ||
| 15020000016122 | L15/amo20 | 15 | 15020000016062 | 15020000016119 | 3 | Mme | Agnès | Alfonso-Chariol |