AN · données ouvertes
Explorateur / amo30

amo30.acteur_mandat_collaborateurs_collaborateur

Chemin acteur.mandats.mandat.collaborateurs.collaborateur · présence : L17 18 %

2 070 lignes (estimation)

Colonnes

#ColonneTypeCommentaire
1_idBIGINTidentifiant : code de la source × 10¹⁰ + rang
2_sourceVARCHARsource du catalogue (catalogue.py)
3_legislatureBIGINTcolonne constante de la source
4_racine_idBIGINT_id de la ligne racine
5_parent_idBIGINT_id de la ligne parente
6_ordreBIGINTrang dans le tableau d'origine (1…)
7qualiteVARCHARacteur.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
8prenomVARCHARacteur.mandats.mandat.collaborateurs.collaborateur.prenom · présence : L17 18 %
9nomVARCHARacteur.mandats.mandat.collaborateurs.collaborateur.nom · présence : L17 18 %
10date_debutVARCHARacteur.mandats.mandat.collaborateurs.collaborateur.dateDebut · présence : L17 18 %
11date_finVARCHARacteur.mandats.mandat.collaborateurs.collaborateur.dateFin · présence : L17 18 %

Aperçu

_id_source_legislature_racine_id_parent_id_ordrequaliteprenomnomdate_debutdate_fin
17030000137989L17/amo301717030000137847170300001379872M.SylvainJager
17030000137990L17/amo301717030000137847170300001379873MmeOlgaProkopieva
17030000138234L17/amo301717030000138029170300001382331MmeLéopoldineChambon
17030000138235L17/amo301717030000138029170300001382332M.Jean-BaptisteRolland
17030000138236L17/amo301717030000138029170300001382333M.LilianCorne
17030000138488L17/amo301717030000138361170300001384871M.YacineKhedim
17030000138489L17/amo301717030000138361170300001384872MmeBarbaraZauli
17030000138490L17/amo301717030000138361170300001384873MmeSarahMouheb
17030000138491L17/amo301717030000138361170300001384874MmeAgatheJamaux
17030000138492L17/amo301717030000138361170300001384875MmeSashaBernert
17030000138858L17/amo301717030000138689170300001388571MmeCatherineAlix
17030000138859L17/amo301717030000138689170300001388572M.ClémentNauleau
17030000138860L17/amo301717030000138689170300001388573MmeSophieAlix-Liorit
17030000139086L17/amo301717030000138924170300001390851M.YannLegargeant
17030000139087L17/amo301717030000138924170300001390852MmeAnneMion
17030000139088L17/amo301717030000138924170300001390853MmeMathildeMandin
17030000139679L17/amo301717030000139577170300001396781MmeBéatriceMoinard
17030000139680L17/amo301717030000139577170300001396782M.CharlyPorcher
17030000139953L17/amo301717030000139837170300001399521M.AlbanBourguignon
17030000139954L17/amo301717030000139837170300001399522MmeMorganeDuchesne
17030000139955L17/amo301717030000139837170300001399523M.AxelFerry
17030000139956L17/amo301717030000139837170300001399524M.HugoPage
17030000140284L17/amo301717030000140158170300001402831MmeEstelleBennouara
17030000140285L17/amo301717030000140158170300001402832MmeCarlaCamilleri
17030000140286L17/amo301717030000140158170300001402833MmeClaraRataud
17030000140436L17/amo301717030000140289170300001404351M.DimitriBourrié
17030000140437L17/amo301717030000140289170300001404352MmeLouiseLe Provost
17030000140438L17/amo301717030000140289170300001404353M.QuentinDagbert
17030000140439L17/amo301717030000140289170300001404354M.BastienVigier
17030000140440L17/amo301717030000140289170300001404355M.TristanParuch
17030000140644L17/amo301717030000140441170300001406431MmeMathildeLacazette
17030000140645L17/amo301717030000140441170300001406432M.HadrienThérasse
17030000140646L17/amo301717030000140441170300001406433MmeCamilleDiais
17030000140647L17/amo301717030000140441170300001406434MmeLéaGrino-Lacassagne
17030000140795L17/amo301717030000140648170300001407941M.XavierBrouard
17030000140796L17/amo301717030000140648170300001407942M.FrançoisPlaze
17030000140797L17/amo301717030000140648170300001407943MmeValérieDauge
17030000141029L17/amo301717030000140904170300001410281MmeVirginieVincent
17030000141030L17/amo301717030000140904170300001410282M.AmbroiseMejean
17030000141031L17/amo301717030000140904170300001410283M.AlexisIzard
17030000141522L17/amo301717030000141376170300001415211MmeAnneMartiréné
17030000141523L17/amo301717030000141376170300001415212M.GabrielSalesse
17030000141774L17/amo301717030000141637170300001417731M.Pierre-EmmanuelKentouri-Bonod
17030000141775L17/amo301717030000141637170300001417732MmeSabrinaAbib
17030000141776L17/amo301717030000141637170300001417733M.AntoineJumel
17030000141777L17/amo301717030000141637170300001417734M.JoséBrice
17030000141778L17/amo301717030000141637170300001417735M.AlexandreFlory
17030000141779L17/amo301717030000141637170300001417736MmeAlineDurand
17030000141780L17/amo301717030000141637170300001417737MmeChloéNoblet
17030000142312L17/amo301717030000142117170300001423111MmeAuréliaDrif