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
17060000001300L17/dossiers1717060000001295170600000012955PA793912cosignataire
17060000001301L17/dossiers1717060000001295170600000012956PA842187cosignataire
17060000001302L17/dossiers1717060000001295170600000012957PA842037cosignataire
17060000001303L17/dossiers1717060000001295170600000012958PA791812cosignataire
17060000001304L17/dossiers1717060000001295170600000012959PA721202cosignataire
17060000001305L17/dossiers17170600000012951706000000129510PA795136cosignataire
17060000001306L17/dossiers17170600000012951706000000129511PA793464cosignataire
17060000001307L17/dossiers17170600000012951706000000129512PA842155cosignataire
17060000001308L17/dossiers17170600000012951706000000129513PA795200cosignataire
17060000001309L17/dossiers17170600000012951706000000129514PA795844cosignataire
17060000001310L17/dossiers17170600000012951706000000129515PA841251cosignataire
17060000001311L17/dossiers17170600000012951706000000129516PA794786cosignataire
17060000001312L17/dossiers17170600000012951706000000129517PA794870cosignataire
17060000001313L17/dossiers17170600000012951706000000129518PA796070cosignataire
17060000001314L17/dossiers17170600000012951706000000129519PA795310cosignataire
17060000001315L17/dossiers17170600000012951706000000129520PA794478cosignataire
17060000001316L17/dossiers17170600000012951706000000129521PA841947cosignataire
17060000001317L17/dossiers17170600000012951706000000129522PA794082cosignataire
17060000001318L17/dossiers17170600000012951706000000129523PA794130cosignataire
17060000001319L17/dossiers17170600000012951706000000129524PA720846cosignataire
17060000001320L17/dossiers17170600000012951706000000129525PA841729cosignataire
17060000001321L17/dossiers17170600000012951706000000129526PA795516cosignataire
17060000001322L17/dossiers17170600000012951706000000129527PA841515cosignataire
17060000001323L17/dossiers17170600000012951706000000129528PA795672cosignataire
17060000001324L17/dossiers17170600000012951706000000129529PA795746cosignataire
17060000001325L17/dossiers17170600000012951706000000129530PA795108cosignataire
17060000001326L17/dossiers17170600000012951706000000129531PA795298cosignataire
17060000001327L17/dossiers17170600000012951706000000129532PA791824cosignataire
17060000001328L17/dossiers17170600000012951706000000129533PA842029cosignataire
17060000001329L17/dossiers17170600000012951706000000129534PA793532cosignataire
17060000001330L17/dossiers17170600000012951706000000129535PA342384cosignataire
17060000001331L17/dossiers17170600000012951706000000129536PA795422cosignataire
17060000001332L17/dossiers17170600000012951706000000129537PA841215cosignataire
17060000001333L17/dossiers17170600000012951706000000129538PA795482cosignataire
17060000001334L17/dossiers17170600000012951706000000129539PA610654cosignataire
17060000001335L17/dossiers17170600000012951706000000129540PA841191cosignataire
17060000001336L17/dossiers17170600000012951706000000129541PA721960cosignataire
17060000001337L17/dossiers17170600000012951706000000129542PA793872cosignataire
17060000001338L17/dossiers17170600000012951706000000129543PA817211cosignataire
17060000001339L17/dossiers17170600000012951706000000129544PA793756cosignataire
17060000001340L17/dossiers17170600000012951706000000129545PA796062cosignataire
17060000001341L17/dossiers17170600000012951706000000129546PA719578cosignataire
17060000001342L17/dossiers17170600000012951706000000129547PA721062cosignataire
17060000001343L17/dossiers17170600000012951706000000129548PA841845cosignataire
17060000001344L17/dossiers17170600000012951706000000129549PA795982cosignataire
17060000001345L17/dossiers17170600000012951706000000129550PA795466cosignataire
17060000001346L17/dossiers17170600000012951706000000129551PA793744cosignataire
17060000001347L17/dossiers17170600000012951706000000129552PA720952cosignataire
17060000001348L17/dossiers17170600000012951706000000129553PA794106cosignataire
17060000001349L17/dossiers17170600000012951706000000129554PA794166cosignataire