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
17060000001907L17/dossiers171706000000177917060000001779128PA774960cosignataire
17060000001908L17/dossiers171706000000177917060000001779129PA841091cosignataire
17060000001909L17/dossiers171706000000177917060000001779130PA841681cosignataire
17060000001910L17/dossiers171706000000177917060000001779131PA841893cosignataire
17060000001911L17/dossiers171706000000177917060000001779132PA793816cosignataire
17060000001912L17/dossiers171706000000177917060000001779133PA794494cosignataire
17060000001913L17/dossiers171706000000177917060000001779134PA720992cosignataire
17060000001914L17/dossiers171706000000177917060000001779135PA610968cosignataire
17060000001915L17/dossiers171706000000177917060000001779136PA793780cosignataire
17060000001916L17/dossiers171706000000177917060000001779137PA588884cosignataire
17060000001917L17/dossiers171706000000177917060000001779138PA841701cosignataire
17060000001918L17/dossiers171706000000177917060000001779139PA335999cosignataire
17060000001919L17/dossiers171706000000177917060000001779140PA795362cosignataire
17060000001920L17/dossiers171706000000177917060000001779141PA795454cosignataire
17060000001921L17/dossiers171706000000177917060000001779142PA840997cosignataire
17060000001922L17/dossiers171706000000177917060000001779143PA841885cosignataire
17060000001923L17/dossiers171706000000177917060000001779144PA841507cosignataire
17060000001924L17/dossiers171706000000177917060000001779145PA721210cosignataire
17060000001925L17/dossiers171706000000177917060000001779146PA793452cosignataire
17060000001926L17/dossiers171706000000177917060000001779147PA841351cosignataire
17060000001927L17/dossiers171706000000177917060000001779148PA793980cosignataire
17060000001928L17/dossiers171706000000177917060000001779149PA795010cosignataire
17060000001929L17/dossiers171706000000177917060000001779150PA841419cosignataire
17060000001930L17/dossiers171706000000177917060000001779151PA842013cosignataire
17060000001931L17/dossiers171706000000177917060000001779152PA840947cosignataire
17060000001932L17/dossiers171706000000177917060000001779153PA794022cosignataire
17060000001933L17/dossiers171706000000177917060000001779154PA794146cosignataire
17060000001934L17/dossiers171706000000177917060000001779155PA841223cosignataire
17060000001935L17/dossiers171706000000177917060000001779156PA795636cosignataire
17060000001936L17/dossiers171706000000177917060000001779157PA842045cosignataire
17060000001937L17/dossiers171706000000177917060000001779158PA793708cosignataire
17060000001938L17/dossiers171706000000177917060000001779159PA793664cosignataire
17060000001939L17/dossiers171706000000177917060000001779160PA794154cosignataire
17060000001940L17/dossiers171706000000177917060000001779161PA794778cosignataire
17060000001941L17/dossiers171706000000177917060000001779162PA606545cosignataire
17060000001942L17/dossiers171706000000177917060000001779163PA795076cosignataire
17060000001943L17/dossiers171706000000177917060000001779164PA722142cosignataire
17060000001944L17/dossiers171706000000177917060000001779165PA610002cosignataire
17060000001945L17/dossiers171706000000177917060000001779166PA795808cosignataire
17060000001946L17/dossiers171706000000177917060000001779167PA796018cosignataire
17060000001947L17/dossiers171706000000177917060000001779168PA736201cosignataire
17060000001948L17/dossiers171706000000177917060000001779169PA841713cosignataire
17060000001949L17/dossiers171706000000177917060000001779170PA793948cosignataire
17060000001950L17/dossiers171706000000177917060000001779171PA2940cosignataire
17060000001951L17/dossiers171706000000177917060000001779172PA796106cosignataire
17060000001952L17/dossiers171706000000177917060000001779173PA720838cosignataire
17060000001953L17/dossiers171706000000177917060000001779174PA795868cosignataire
17060000001954L17/dossiers171706000000177917060000001779175PA721896cosignataire
17060000001955L17/dossiers171706000000177917060000001779176PA795998cosignataire
17060000001956L17/dossiers171706000000177917060000001779177PA774962cosignataire