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
17060000002714L17/dossiers17170600000026341706000000263480PA840997cosignataire
17060000002715L17/dossiers17170600000026341706000000263481PA841885cosignataire
17060000002716L17/dossiers17170600000026341706000000263482PA721210cosignataire
17060000002717L17/dossiers17170600000026341706000000263483PA793452cosignataire
17060000002718L17/dossiers17170600000026341706000000263484PA793980cosignataire
17060000002719L17/dossiers17170600000026341706000000263485PA841419cosignataire
17060000002720L17/dossiers17170600000026341706000000263486PA794146cosignataire
17060000002721L17/dossiers17170600000026341706000000263487PA795636cosignataire
17060000002722L17/dossiers17170600000026341706000000263488PA842045cosignataire
17060000002723L17/dossiers17170600000026341706000000263489PA793708cosignataire
17060000002724L17/dossiers17170600000026341706000000263490PA793664cosignataire
17060000002725L17/dossiers17170600000026341706000000263491PA794154cosignataire
17060000002726L17/dossiers17170600000026341706000000263492PA794778cosignataire
17060000002727L17/dossiers17170600000026341706000000263493PA606545cosignataire
17060000002728L17/dossiers17170600000026341706000000263494PA795076cosignataire
17060000002729L17/dossiers17170600000026341706000000263495PA722142cosignataire
17060000002730L17/dossiers17170600000026341706000000263496PA795808cosignataire
17060000002731L17/dossiers17170600000026341706000000263497PA796018cosignataire
17060000002732L17/dossiers17170600000026341706000000263498PA736201cosignataire
17060000002733L17/dossiers17170600000026341706000000263499PA841713cosignataire
17060000002734L17/dossiers171706000000263417060000002634100PA793948cosignataire
17060000002735L17/dossiers171706000000263417060000002634101PA796106cosignataire
17060000002736L17/dossiers171706000000263417060000002634102PA720838cosignataire
17060000002737L17/dossiers171706000000263417060000002634103PA794710cosignataire
17060000002738L17/dossiers171706000000263417060000002634104PA795868cosignataire
17060000002739L17/dossiers171706000000263417060000002634105PA721896cosignataire
17060000002740L17/dossiers171706000000263417060000002634106PA795998cosignataire
17060000002741L17/dossiers171706000000263417060000002634107PA774962cosignataire
17060000002742L17/dossiers171706000000263417060000002634108PA335612cosignataire
17060000002743L17/dossiers171706000000263417060000002634109PA796010cosignataire
17060000002744L17/dossiers171706000000263417060000002634110PA795820cosignataire
17060000002745L17/dossiers171706000000263417060000002634111PA795876cosignataire
17060000002746L17/dossiers171706000000263417060000002634112PA605745cosignataire
17060000002747L17/dossiers171706000000263417060000002634113PA842299cosignataire
17060000002749L17/dossiers1717060000002748170600000027481PA720614auteur
17060000002750L17/dossiers1717060000002748170600000027482PA330240cosignataire
17060000002751L17/dossiers1717060000002748170600000027483PA793432cosignataire
17060000002752L17/dossiers1717060000002748170600000027484PA841495cosignataire
17060000002753L17/dossiers1717060000002748170600000027485PA796118cosignataire
17060000002754L17/dossiers1717060000002748170600000027486PA794562cosignataire
17060000002755L17/dossiers1717060000002748170600000027487PA842279cosignataire
17060000002756L17/dossiers1717060000002748170600000027488PA793158cosignataire
17060000002757L17/dossiers1717060000002748170600000027489PA794434cosignataire
17060000002758L17/dossiers17170600000027481706000000274810PA841645cosignataire
17060000002759L17/dossiers17170600000027481706000000274811PA842001cosignataire
17060000002760L17/dossiers17170600000027481706000000274812PA720822cosignataire
17060000002761L17/dossiers17170600000027481706000000274813PA720668cosignataire
17060000002762L17/dossiers17170600000027481706000000274814PA794886cosignataire
17060000002763L17/dossiers17170600000027481706000000274815PA841487cosignataire
17060000002764L17/dossiers17170600000027481706000000274816PA841131cosignataire