AN · données ouvertes
Explorateur / dossiers

dossiers.document_auteur

Chemin document.auteurs.auteur · présence : L17 100 %, L16 100 %, L15 100 %, L14 100 %

59 594 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…)
7acteur_acteur_refVARCHARdocument.auteurs.auteur.acteur.acteurRef · présence : L17 71 %, L16 72 %, L15 74 %, L14 86 %
8acteur_qualiteVARCHARdocument.auteurs.auteur.acteur.qualite · présence : L17 71 %, L16 72 %, L15 74 %, L14 86 % · 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
9organe_organe_refVARCHARdocument.auteurs.auteur.organe.organeRef · présence : L17 59 %, L16 58 %, L15 56 %, L14 56 %

Aperçu

_id_source_legislature_racine_id_parent_id_ordreacteur_acteur_refacteur_qualiteorgane_organe_ref
17060000000792L17/dossiers171706000000065017060000000650142PA793780cosignataire
17060000000793L17/dossiers171706000000065017060000000650143PA588884cosignataire
17060000000794L17/dossiers171706000000065017060000000650144PA841701cosignataire
17060000000795L17/dossiers171706000000065017060000000650145PA335999cosignataire
17060000000796L17/dossiers171706000000065017060000000650146PA795362cosignataire
17060000000797L17/dossiers171706000000065017060000000650147PA795454cosignataire
17060000000798L17/dossiers171706000000065017060000000650148PA840997cosignataire
17060000000799L17/dossiers171706000000065017060000000650149PA841885cosignataire
17060000000800L17/dossiers171706000000065017060000000650150PA841507cosignataire
17060000000801L17/dossiers171706000000065017060000000650151PA721210cosignataire
17060000000802L17/dossiers171706000000065017060000000650152PA793452cosignataire
17060000000803L17/dossiers171706000000065017060000000650153PA841351cosignataire
17060000000804L17/dossiers171706000000065017060000000650154PA793980cosignataire
17060000000805L17/dossiers171706000000065017060000000650155PA795010cosignataire
17060000000806L17/dossiers171706000000065017060000000650156PA841419cosignataire
17060000000807L17/dossiers171706000000065017060000000650157PA842013cosignataire
17060000000808L17/dossiers171706000000065017060000000650158PA840947cosignataire
17060000000809L17/dossiers171706000000065017060000000650159PA794022cosignataire
17060000000810L17/dossiers171706000000065017060000000650160PA794146cosignataire
17060000000811L17/dossiers171706000000065017060000000650161PA841223cosignataire
17060000000812L17/dossiers171706000000065017060000000650162PA795636cosignataire
17060000000813L17/dossiers171706000000065017060000000650163PA842045cosignataire
17060000000814L17/dossiers171706000000065017060000000650164PA793708cosignataire
17060000000815L17/dossiers171706000000065017060000000650165PA793664cosignataire
17060000000816L17/dossiers171706000000065017060000000650166PA794154cosignataire
17060000000817L17/dossiers171706000000065017060000000650167PA794778cosignataire
17060000000818L17/dossiers171706000000065017060000000650168PA606545cosignataire
17060000000819L17/dossiers171706000000065017060000000650169PA795076cosignataire
17060000000820L17/dossiers171706000000065017060000000650170PA722142cosignataire
17060000000821L17/dossiers171706000000065017060000000650171PA610002cosignataire
17060000000822L17/dossiers171706000000065017060000000650172PA795808cosignataire
17060000000823L17/dossiers171706000000065017060000000650173PA796018cosignataire
17060000000824L17/dossiers171706000000065017060000000650174PA736201cosignataire
17060000000825L17/dossiers171706000000065017060000000650175PA841713cosignataire
17060000000826L17/dossiers171706000000065017060000000650176PA793948cosignataire
17060000000827L17/dossiers171706000000065017060000000650177PA2940cosignataire
17060000000828L17/dossiers171706000000065017060000000650178PA796106cosignataire
17060000000829L17/dossiers171706000000065017060000000650179PA720838cosignataire
17060000000830L17/dossiers171706000000065017060000000650180PA795868cosignataire
17060000000831L17/dossiers171706000000065017060000000650181PA721896cosignataire
17060000000832L17/dossiers171706000000065017060000000650182PA795998cosignataire
17060000000833L17/dossiers171706000000065017060000000650183PA774962cosignataire
17060000000834L17/dossiers171706000000065017060000000650184PA335612cosignataire
17060000000835L17/dossiers171706000000065017060000000650185PA796010cosignataire
17060000000836L17/dossiers171706000000065017060000000650186PA842271cosignataire
17060000000837L17/dossiers171706000000065017060000000650187PA793174cosignataire
17060000000838L17/dossiers171706000000065017060000000650188PA795820cosignataire
17060000000839L17/dossiers171706000000065017060000000650189PA721270cosignataire
17060000000840L17/dossiers171706000000065017060000000650190PA795240cosignataire
17060000000841L17/dossiers171706000000065017060000000650191PA795876cosignataire