amo50.mandat_collaborateurs_collaborateur
Chemin mandat.collaborateurs.collaborateur · présence : L17 0 %, L16 2 %
2 210 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 | mandat.collaborateurs.collaborateur.qualite · présence : L17 0 %, L16 2 % · 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 | mandat.collaborateurs.collaborateur.prenom · présence : L17 0 %, L16 2 % |
| 9 | nom | VARCHAR | mandat.collaborateurs.collaborateur.nom · présence : L17 0 %, L16 2 % |
| 10 | date_debut | VARCHAR | mandat.collaborateurs.collaborateur.dateDebut · présence : L17 0 %, L16 2 % |
| 11 | date_fin | VARCHAR | mandat.collaborateurs.collaborateur.dateFin · présence : L17 0 %, L16 2 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | qualite | prenom | nom | date_debut | date_fin |
|---|---|---|---|---|---|---|---|---|---|---|
| 16050000023084 | L16/amo50 | 16 | 16050000023082 | 16050000023083 | 1 | Mme | Suzanne | Evain | ||
| 16050000023085 | L16/amo50 | 16 | 16050000023082 | 16050000023083 | 2 | M. | Hugo | Gaspar | ||
| 16050000023086 | L16/amo50 | 16 | 16050000023082 | 16050000023083 | 3 | M. | Nicolas | Maineray | ||
| 16050000023090 | L16/amo50 | 16 | 16050000023088 | 16050000023089 | 1 | M. | Patrick | Dorville | ||
| 16050000023091 | L16/amo50 | 16 | 16050000023088 | 16050000023089 | 2 | Mme | Pauline | Pawlotsky | ||
| 16050000023092 | L16/amo50 | 16 | 16050000023088 | 16050000023089 | 3 | M. | Quentin | Cherrier-Lagarde | ||
| 16050000023093 | L16/amo50 | 16 | 16050000023088 | 16050000023089 | 4 | M. | Simon | Roussel | ||
| 16050000023094 | L16/amo50 | 16 | 16050000023088 | 16050000023089 | 5 | M. | Maxime | Verin | ||
| 16050000023098 | L16/amo50 | 16 | 16050000023096 | 16050000023097 | 1 | Mme | Agathe | Colin | ||
| 16050000023099 | L16/amo50 | 16 | 16050000023096 | 16050000023097 | 2 | Mme | Alice | Bénard | ||
| 16050000023100 | L16/amo50 | 16 | 16050000023096 | 16050000023097 | 3 | Mme | Vanessa | Picart | ||
| 16050000023101 | L16/amo50 | 16 | 16050000023096 | 16050000023097 | 4 | M. | Thomas | Krebs | ||
| 16050000023102 | L16/amo50 | 16 | 16050000023096 | 16050000023097 | 5 | M. | Arnaud | Merveille | ||
| 16050000023106 | L16/amo50 | 16 | 16050000023104 | 16050000023105 | 1 | M. | Thibaud | Soret | ||
| 16050000023107 | L16/amo50 | 16 | 16050000023104 | 16050000023105 | 2 | M. | Yves | Niort | ||
| 16050000023108 | L16/amo50 | 16 | 16050000023104 | 16050000023105 | 3 | M. | Christophe | Bourdy | ||
| 16050000023112 | L16/amo50 | 16 | 16050000023110 | 16050000023111 | 1 | M. | Quentin | Jarno | ||
| 16050000023113 | L16/amo50 | 16 | 16050000023110 | 16050000023111 | 2 | Mme | Elsa | Le Pallec | ||
| 16050000023114 | L16/amo50 | 16 | 16050000023110 | 16050000023111 | 3 | M. | Baptiste | Normand | ||
| 16050000023115 | L16/amo50 | 16 | 16050000023110 | 16050000023111 | 4 | M. | Sébastien | Tranchant | ||
| 16050000023119 | L16/amo50 | 16 | 16050000023117 | 16050000023118 | 1 | M. | Christophe | Nayl | ||
| 16050000023120 | L16/amo50 | 16 | 16050000023117 | 16050000023118 | 2 | Mme | Maëva | Dano | ||
| 16050000023121 | L16/amo50 | 16 | 16050000023117 | 16050000023118 | 3 | M. | Victor | Gallou | ||
| 16050000023125 | L16/amo50 | 16 | 16050000023123 | 16050000023124 | 1 | Mme | Virginie | Larralde | ||
| 16050000023126 | L16/amo50 | 16 | 16050000023123 | 16050000023124 | 2 | Mme | Cassandre | Métayer | ||
| 16050000023127 | L16/amo50 | 16 | 16050000023123 | 16050000023124 | 3 | M. | Adam | Benammi | ||
| 16050000023131 | L16/amo50 | 16 | 16050000023129 | 16050000023130 | 1 | Mme | Nadia | Souffoy | ||
| 16050000023132 | L16/amo50 | 16 | 16050000023129 | 16050000023130 | 2 | Mme | Lisa | Wingerter | ||
| 16050000023133 | L16/amo50 | 16 | 16050000023129 | 16050000023130 | 3 | Mme | Amandine | Herbaux | ||
| 16050000023134 | L16/amo50 | 16 | 16050000023129 | 16050000023130 | 4 | Mme | Caroline | Le Bayon | ||
| 16050000023138 | L16/amo50 | 16 | 16050000023136 | 16050000023137 | 1 | M. | Jean-Rémy | Dushimiyimana | ||
| 16050000023139 | L16/amo50 | 16 | 16050000023136 | 16050000023137 | 2 | Mme | Sharon | Thiriet | ||
| 16050000023140 | L16/amo50 | 16 | 16050000023136 | 16050000023137 | 3 | M. | Karim | Chafi | ||
| 16050000023144 | L16/amo50 | 16 | 16050000023142 | 16050000023143 | 1 | M. | Thibaud | Muller | ||
| 16050000023145 | L16/amo50 | 16 | 16050000023142 | 16050000023143 | 2 | Mme | Nadia | Lazrag | ||
| 16050000023146 | L16/amo50 | 16 | 16050000023142 | 16050000023143 | 3 | M. | Vivien | Schanen | ||
| 16050000023150 | L16/amo50 | 16 | 16050000023148 | 16050000023149 | 1 | M. | Arnaud | De Sousa | ||
| 16050000023151 | L16/amo50 | 16 | 16050000023148 | 16050000023149 | 2 | Mme | Sonia | Morel | ||
| 16050000023152 | L16/amo50 | 16 | 16050000023148 | 16050000023149 | 3 | M. | Cédric | Morzelle | ||
| 16050000023156 | L16/amo50 | 16 | 16050000023154 | 16050000023155 | 1 | Mme | Christelle | Pilleux | ||
| 16050000023157 | L16/amo50 | 16 | 16050000023154 | 16050000023155 | 2 | Mme | Audrey | Levavasseur | ||
| 16050000023158 | L16/amo50 | 16 | 16050000023154 | 16050000023155 | 3 | M. | Stéphane | Guehrar | ||
| 16050000023162 | L16/amo50 | 16 | 16050000023160 | 16050000023161 | 1 | M. | Jonathan | Mesika | ||
| 16050000023163 | L16/amo50 | 16 | 16050000023160 | 16050000023161 | 2 | M. | Arnaud | Schlippi | ||
| 16050000023164 | L16/amo50 | 16 | 16050000023160 | 16050000023161 | 3 | M. | Olivier | Stano | ||
| 16050000023165 | L16/amo50 | 16 | 16050000023160 | 16050000023161 | 4 | M. | Bernard | Mourot | ||
| 16050000023169 | L16/amo50 | 16 | 16050000023167 | 16050000023168 | 1 | M. | Jean-Baptiste | Orban | ||
| 16050000023170 | L16/amo50 | 16 | 16050000023167 | 16050000023168 | 2 | Mme | Carine | George | ||
| 16050000023171 | L16/amo50 | 16 | 16050000023167 | 16050000023168 | 3 | Mme | Anne | Chouzenoux | ||
| 16050000023172 | L16/amo50 | 16 | 16050000023167 | 16050000023168 | 4 | M. | Charles | Rouvier |