AN · données ouvertes
Explorateur / amo20

amo20.acteur_mandat_collaborateurs_collaborateur

Chemin acteur.mandats.mandat.collaborateurs.collaborateur · présence : L17 54 %, L15 45 %

3 846 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 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
8prenomVARCHARacteur.mandats.mandat.collaborateurs.collaborateur.prenom · présence : L17 54 %, L15 45 %
9nomVARCHARacteur.mandats.mandat.collaborateurs.collaborateur.nom · présence : L17 54 %, L15 45 %
10date_debutVARCHARacteur.mandats.mandat.collaborateurs.collaborateur.dateDebut · présence : L17 54 %, L15 45 %
11date_finVARCHARacteur.mandats.mandat.collaborateurs.collaborateur.dateFin · présence : L17 54 %, L15 45 %

Aperçu

_id_source_legislature_racine_id_parent_id_ordrequaliteprenomnomdate_debutdate_fin
17020000039307L17/amo201717020000039258170200000393061M.JeanBaylac
17020000039308L17/amo201717020000039258170200000393062MmeCharlotteDe Souza
17020000039309L17/amo201717020000039258170200000393063MmePattyTeillet
17020000039310L17/amo201717020000039258170200000393064M.NadimPayan
17020000039358L17/amo201717020000039311170200000393571MmeVirginieRapin
17020000039359L17/amo201717020000039311170200000393572MmeCharlotteRey
17020000039360L17/amo201717020000039311170200000393573MmeEmiliaRios Vera
17020000039398L17/amo201717020000039373170200000393971M.GautierBoband
17020000039399L17/amo201717020000039373170200000393972MmeBlandinede Joussineau de Tourdonnet
17020000039400L17/amo201717020000039373170200000393973M.TimothéGagnard
17020000039437L17/amo201717020000039401170200000394361M.BryanVigié
17020000039438L17/amo201717020000039401170200000394362M.BaptisteDollé
17020000039472L17/amo201717020000039439170200000394711MmeCynthiaTuttle
17020000039473L17/amo201717020000039439170200000394712MmeLaetitiaRigaudière
17020000039474L17/amo201717020000039439170200000394713MmeDiankéJuwara
17020000039475L17/amo201717020000039439170200000394714M.GokhanUnver
17020000039490L17/amo201717020000039476170200000394891MmeEmilieTurroc
17020000039491L17/amo201717020000039476170200000394892M.JoëlNaccache
17020000039492L17/amo201717020000039476170200000394893MmeValérieAttrait
17020000039591L17/amo201717020000039493170200000395901MmeIsabelleD'Artagnan
17020000039592L17/amo201717020000039493170200000395902M.MilanBourg
17020000039593L17/amo201717020000039493170200000395903M.Jean-ChristopheTurpin
17020000039635L17/amo201717020000039594170200000396341M.SachaFontaine
17020000039636L17/amo201717020000039594170200000396342MmeEmmaNessah
17020000039721L17/amo201717020000039637170200000397201MmeNadiaChonville
17020000039722L17/amo201717020000039637170200000397202M.ThibaultGradel
17020000039723L17/amo201717020000039637170200000397203MmeWalattaZébina
17020000039724L17/amo201717020000039637170200000397204MmeMaevaLefort
17020000039742L17/amo201717020000039725170200000397411MmeLucieAcapandié
17020000039743L17/amo201717020000039725170200000397412MmeLauraCorré
17020000039784L17/amo201717020000039744170200000397831M.AntoninBonin
17020000039785L17/amo201717020000039744170200000397832M.Erwan PierrickLe Naour
17020000039786L17/amo201717020000039744170200000397833M.AntoineMellies
17020000039787L17/amo201717020000039744170200000397834MmeNathalieThai
17020000039788L17/amo201717020000039744170200000397835MmeValentineAuroux-Delage
17020000039789L17/amo201717020000039744170200000397836M.JoostLumia
17020000039865L17/amo201717020000039790170200000398641MmeMaëVeltz
17020000039866L17/amo201717020000039790170200000398642M.JulienGuimiot
17020000039867L17/amo201717020000039790170200000398643M.HugoMons
17020000039938L17/amo201717020000039868170200000399371M.LaurentMiermont
17020000039939L17/amo201717020000039868170200000399372MmeElodieSchwander
17020000039940L17/amo201717020000039868170200000399373M.ThierryGonçalvès
17020000039941L17/amo201717020000039868170200000399374M.PaulDelage
17020000039977L17/amo201717020000039942170200000399761MmeCoraliedu Repaire
17020000039978L17/amo201717020000039942170200000399762M.AttoumaniFaradji
17020000039979L17/amo201717020000039942170200000399763M.JacquesToto
17020000039980L17/amo201717020000039942170200000399764M.Hubertde Jacquelin
17020000040026L17/amo201717020000039981170200000400251M.Jean-PierreXowie
17020000040027L17/amo201717020000039981170200000400252M.EmmanuelDianaï
17020000040028L17/amo201717020000039981170200000400253M.KenzoVendegou