AN · données ouvertes
Explorateur / dossiers

dossiers.document_auteur

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

59 600 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
17060000111204L17/dossiers1717060000111203170600001112031PA736239rapporteur
17060000111205L17/dossiers1717060000111203170600001112032PO211493
17060000111207L17/dossiers1717060000111206170600001112061PA827988rapporteur
17060000111208L17/dossiers1717060000111206170600001112062PO882540
17060000111210L17/dossiers1717060000111209170600001112091PA736223rapporteur
17060000111211L17/dossiers1717060000111209170600001112092PO211493
17060000111213L17/dossiers1717060000111212170600001112121PA736230rapporteur
17060000111214L17/dossiers1717060000111212170600001112122PO211490
17060000111216L17/dossiers1717060000111215170600001112151PA736185rapporteur
17060000111217L17/dossiers1717060000111215170600001112152PO211493
17060000111219L17/dossiers1717060000111218170600001112181PA827914rapporteur
17060000111220L17/dossiers1717060000111218170600001112182PO211490
17060000111222L17/dossiers1717060000111221170600001112211PA429875rapporteur
17060000111223L17/dossiers1717060000111221170600001112212PA382672rapporteur
17060000111224L17/dossiers1717060000111221170600001112213PA736191rapporteur
17060000111225L17/dossiers1717060000111221170600001112214PA775186rapporteur
17060000111226L17/dossiers1717060000111221170600001112215PA775242rapporteur
17060000111227L17/dossiers1717060000111221170600001112216PA268048rapporteur
17060000111228L17/dossiers1717060000111221170600001112217PA703514rapporteur
17060000111229L17/dossiers1717060000111221170600001112218PA827934rapporteur
17060000111230L17/dossiers1717060000111221170600001112219PA394676rapporteur
17060000111231L17/dossiers17170600001112211706000011122110PA345916rapporteur
17060000111232L17/dossiers17170600001112211706000011122111PA709298rapporteur
17060000111233L17/dossiers17170600001112211706000011122112PA775182rapporteur
17060000111234L17/dossiers17170600001112211706000011122113PA429867rapporteur
17060000111235L17/dossiers17170600001112211706000011122114PA736208rapporteur
17060000111236L17/dossiers17170600001112211706000011122115PA415467rapporteur
17060000111237L17/dossiers17170600001112211706000011122116PA828006rapporteur
17060000111238L17/dossiers17170600001112211706000011122117PA736211rapporteur
17060000111239L17/dossiers17170600001112211706000011122118PA827922rapporteur
17060000111240L17/dossiers17170600001112211706000011122119PA415446rapporteur
17060000111241L17/dossiers17170600001112211706000011122120PA429884rapporteur
17060000111242L17/dossiers17170600001112211706000011122121PA775210rapporteur
17060000111243L17/dossiers17170600001112211706000011122122PA429833rapporteur
17060000111244L17/dossiers17170600001112211706000011122123PA415448rapporteur
17060000111245L17/dossiers17170600001112211706000011122124PA343988rapporteur
17060000111246L17/dossiers17170600001112211706000011122125PA703493rapporteur
17060000111247L17/dossiers17170600001112211706000011122126PA827928rapporteur
17060000111248L17/dossiers17170600001112211706000011122127PA775288rapporteur
17060000111249L17/dossiers17170600001112211706000011122128PA775214rapporteur
17060000111250L17/dossiers17170600001112211706000011122129PA415447rapporteur
17060000111251L17/dossiers17170600001112211706000011122130PA736238rapporteur
17060000111252L17/dossiers17170600001112211706000011122131PA267387rapporteur
17060000111253L17/dossiers17170600001112211706000011122132PA415499rapporteur
17060000111254L17/dossiers17170600001112211706000011122133PA703505rapporteur
17060000111255L17/dossiers17170600001112211706000011122134PA827904rapporteur
17060000111256L17/dossiers17170600001112211706000011122135PA775260rapporteur
17060000111257L17/dossiers17170600001112211706000011122136PA711156rapporteur
17060000111258L17/dossiers17170600001112211706000011122137PA736158rapporteur
17060000111259L17/dossiers17170600001112211706000011122138PA775284rapporteur