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
17060000002613L17/dossiers17170600000025291706000000252984PA794954cosignataire
17060000002614L17/dossiers17170600000025291706000000252985PA842255cosignataire
17060000002615L17/dossiers17170600000025291706000000252986PA793382cosignataire
17060000002616L17/dossiers17170600000025291706000000252987PA794502cosignataire
17060000002617L17/dossiers17170600000025291706000000252988PA841553cosignataire
17060000002618L17/dossiers17170600000025291706000000252989PA793298cosignataire
17060000002619L17/dossiers17170600000025291706000000252990PA840781cosignataire
17060000002620L17/dossiers17170600000025291706000000252991PA841575cosignataire
17060000002621L17/dossiers17170600000025291706000000252992PA841479cosignataire
17060000002622L17/dossiers17170600000025291706000000252993PA840889cosignataire
17060000002623L17/dossiers17170600000025291706000000252994PA841973cosignataire
17060000002624L17/dossiers17170600000025291706000000252995PA840701cosignataire
17060000002625L17/dossiers17170600000025291706000000252996PA840721cosignataire
17060000002626L17/dossiers17170600000025291706000000252997PA793322cosignataire
17060000002627L17/dossiers17170600000025291706000000252998PA840773cosignataire
17060000002628L17/dossiers17170600000025291706000000252999PA840983cosignataire
17060000002629L17/dossiers171706000000252917060000002529100PA841183cosignataire
17060000002630L17/dossiers171706000000252917060000002529101PA841395cosignataire
17060000002631L17/dossiers171706000000252917060000002529102PA841769cosignataire
17060000002632L17/dossiers171706000000252917060000002529103PA840657cosignataire
17060000002633L17/dossiers171706000000252917060000002529104PA840809cosignataire
17060000002635L17/dossiers1717060000002634170600000026341PA721270auteur
17060000002636L17/dossiers1717060000002634170600000026342PA720892cosignataire
17060000002637L17/dossiers1717060000002634170600000026343PA794008cosignataire
17060000002638L17/dossiers1717060000002634170600000026344PA795228cosignataire
17060000002639L17/dossiers1717060000002634170600000026345PA793262cosignataire
17060000002640L17/dossiers1717060000002634170600000026346PA794906cosignataire
17060000002641L17/dossiers1717060000002634170600000026347PA794138cosignataire
17060000002642L17/dossiers1717060000002634170600000026348PA795588cosignataire
17060000002643L17/dossiers1717060000002634170600000026349PA795084cosignataire
17060000002644L17/dossiers17170600000026341706000000263410PA842105cosignataire
17060000002645L17/dossiers17170600000026341706000000263411PA841657cosignataire
17060000002646L17/dossiers17170600000026341706000000263412PA720430cosignataire
17060000002647L17/dossiers17170600000026341706000000263413PA793772cosignataire
17060000002648L17/dossiers17170600000026341706000000263414PA795616cosignataire
17060000002649L17/dossiers17170600000026341706000000263415PA793444cosignataire
17060000002650L17/dossiers17170600000026341706000000263416PA794938cosignataire
17060000002651L17/dossiers17170600000026341706000000263417PA795318cosignataire
17060000002652L17/dossiers17170600000026341706000000263418PA841023cosignataire
17060000002653L17/dossiers17170600000026341706000000263419PA796090cosignataire
17060000002654L17/dossiers17170600000026341706000000263420PA793912cosignataire
17060000002655L17/dossiers17170600000026341706000000263421PA842187cosignataire
17060000002656L17/dossiers17170600000026341706000000263422PA842037cosignataire
17060000002657L17/dossiers17170600000026341706000000263423PA791812cosignataire
17060000002658L17/dossiers17170600000026341706000000263424PA793736cosignataire
17060000002659L17/dossiers17170600000026341706000000263425PA721202cosignataire
17060000002660L17/dossiers17170600000026341706000000263426PA795136cosignataire
17060000002661L17/dossiers17170600000026341706000000263427PA793464cosignataire
17060000002662L17/dossiers17170600000026341706000000263428PA842155cosignataire
17060000002663L17/dossiers17170600000026341706000000263429PA795200cosignataire