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
17060000001857L17/dossiers17170600000017791706000000177978PA840829cosignataire
17060000001858L17/dossiers17170600000017791706000000177979PA342415cosignataire
17060000001859L17/dossiers17170600000017791706000000177980PA606793cosignataire
17060000001860L17/dossiers17170600000017791706000000177981PA842211cosignataire
17060000001861L17/dossiers17170600000017791706000000177982PA841315cosignataire
17060000001862L17/dossiers17170600000017791706000000177983PA794094cosignataire
17060000001863L17/dossiers17170600000017791706000000177984PA793624cosignataire
17060000001864L17/dossiers17170600000017791706000000177985PA795762cosignataire
17060000001865L17/dossiers17170600000017791706000000177986PA608264cosignataire
17060000001866L17/dossiers17170600000017791706000000177987PA840903cosignataire
17060000001867L17/dossiers17170600000017791706000000177988PA841295cosignataire
17060000001868L17/dossiers17170600000017791706000000177989PA1008cosignataire
17060000001869L17/dossiers17170600000017791706000000177990PA793394cosignataire
17060000001870L17/dossiers17170600000017791706000000177991PA795430cosignataire
17060000001871L17/dossiers17170600000017791706000000177992PA841919cosignataire
17060000001872L17/dossiers17170600000017791706000000177993PA606573cosignataire
17060000001873L17/dossiers17170600000017791706000000177994PA841633cosignataire
17060000001874L17/dossiers17170600000017791706000000177995PA794854cosignataire
17060000001875L17/dossiers17170600000017791706000000177996PA842195cosignataire
17060000001876L17/dossiers17170600000017791706000000177997PA609332cosignataire
17060000001877L17/dossiers17170600000017791706000000177998PA841665cosignataire
17060000001878L17/dossiers17170600000017791706000000177999PA333285cosignataire
17060000001879L17/dossiers171706000000177917060000001779100PA840939cosignataire
17060000001880L17/dossiers171706000000177917060000001779101PA841539cosignataire
17060000001881L17/dossiers171706000000177917060000001779102PA331973cosignataire
17060000001882L17/dossiers171706000000177917060000001779103PA840171cosignataire
17060000001883L17/dossiers171706000000177917060000001779104PA1567cosignataire
17060000001884L17/dossiers171706000000177917060000001779105PA841471cosignataire
17060000001885L17/dossiers171706000000177917060000001779106PA842263cosignataire
17060000001886L17/dossiers171706000000177917060000001779107PA841813cosignataire
17060000001887L17/dossiers171706000000177917060000001779108PA841853cosignataire
17060000001888L17/dossiers171706000000177917060000001779109PA1654cosignataire
17060000001889L17/dossiers171706000000177917060000001779110PA643192cosignataire
17060000001890L17/dossiers171706000000177917060000001779111PA335054cosignataire
17060000001891L17/dossiers171706000000177917060000001779112PA795156cosignataire
17060000001892L17/dossiers171706000000177917060000001779113PA840765cosignataire
17060000001893L17/dossiers171706000000177917060000001779114PA841463cosignataire
17060000001894L17/dossiers171706000000177917060000001779115PA643157cosignataire
17060000001895L17/dossiers171706000000177917060000001779116PA841107cosignataire
17060000001896L17/dossiers171706000000177917060000001779117PA840793cosignataire
17060000001897L17/dossiers171706000000177917060000001779118PA794270cosignataire
17060000001898L17/dossiers171706000000177917060000001779119PA608172cosignataire
17060000001899L17/dossiers171706000000177917060000001779120PA840955cosignataire
17060000001900L17/dossiers171706000000177917060000001779121PA841367cosignataire
17060000001901L17/dossiers171706000000177917060000001779122PA341981cosignataire
17060000001902L17/dossiers171706000000177917060000001779123PA342196cosignataire
17060000001903L17/dossiers171706000000177917060000001779124PA826635cosignataire
17060000001904L17/dossiers171706000000177917060000001779125PA841327cosignataire
17060000001905L17/dossiers171706000000177917060000001779126PA841717cosignataire
17060000001906L17/dossiers171706000000177917060000001779127PA841243cosignataire