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
17060000001452L17/dossiers17170600000014131706000000141339PA795672cosignataire
17060000001453L17/dossiers17170600000014131706000000141340PA795746cosignataire
17060000001454L17/dossiers17170600000014131706000000141341PA795108cosignataire
17060000001455L17/dossiers17170600000014131706000000141342PA795164cosignataire
17060000001456L17/dossiers17170600000014131706000000141343PA588884cosignataire
17060000001457L17/dossiers17170600000014131706000000141344PA721210cosignataire
17060000001458L17/dossiers17170600000014131706000000141345PA793452cosignataire
17060000001459L17/dossiers17170600000014131706000000141346PA795636cosignataire
17060000001460L17/dossiers17170600000014131706000000141347PA795076cosignataire
17060000001461L17/dossiers17170600000014131706000000141348PA795808cosignataire
17060000001462L17/dossiers17170600000014131706000000141349PA796018cosignataire
17060000001463L17/dossiers17170600000014131706000000141350PA796106cosignataire
17060000001464L17/dossiers17170600000014131706000000141351PA720838cosignataire
17060000001465L17/dossiers17170600000014131706000000141352PA795868cosignataire
17060000001466L17/dossiers17170600000014131706000000141353PA721896cosignataire
17060000001467L17/dossiers17170600000014131706000000141354PA795998cosignataire
17060000001468L17/dossiers17170600000014131706000000141355PA774962cosignataire
17060000001469L17/dossiers17170600000014131706000000141356PA796010cosignataire
17060000001470L17/dossiers17170600000014131706000000141357PA795876cosignataire
17060000001471L17/dossiers17170600000014131706000000141358PA605745cosignataire
17060000001473L17/dossiers1717060000001472170600000014721PA719930auteur
17060000001474L17/dossiers1717060000001472170600000014722PA840665cosignataire
17060000001475L17/dossiers1717060000001472170600000014723PA642764cosignataire
17060000001476L17/dossiers1717060000001472170600000014724PA643143cosignataire
17060000001477L17/dossiers1717060000001472170600000014725PA840829cosignataire
17060000001478L17/dossiers1717060000001472170600000014726PA342415cosignataire
17060000001479L17/dossiers1717060000001472170600000014727PA606793cosignataire
17060000001480L17/dossiers1717060000001472170600000014728PA842211cosignataire
17060000001481L17/dossiers1717060000001472170600000014729PA841315cosignataire
17060000001482L17/dossiers17170600000014721706000000147210PA794094cosignataire
17060000001483L17/dossiers17170600000014721706000000147211PA793624cosignataire
17060000001484L17/dossiers17170600000014721706000000147212PA795762cosignataire
17060000001485L17/dossiers17170600000014721706000000147213PA608264cosignataire
17060000001486L17/dossiers17170600000014721706000000147214PA840903cosignataire
17060000001487L17/dossiers17170600000014721706000000147215PA841295cosignataire
17060000001488L17/dossiers17170600000014721706000000147216PA1008cosignataire
17060000001489L17/dossiers17170600000014721706000000147217PA793394cosignataire
17060000001490L17/dossiers17170600000014721706000000147218PA795430cosignataire
17060000001491L17/dossiers17170600000014721706000000147219PA841919cosignataire
17060000001492L17/dossiers17170600000014721706000000147220PA606573cosignataire
17060000001493L17/dossiers17170600000014721706000000147221PA841633cosignataire
17060000001494L17/dossiers17170600000014721706000000147222PA794854cosignataire
17060000001495L17/dossiers17170600000014721706000000147223PA842195cosignataire
17060000001496L17/dossiers17170600000014721706000000147224PA609332cosignataire
17060000001497L17/dossiers17170600000014721706000000147225PA841665cosignataire
17060000001498L17/dossiers17170600000014721706000000147226PA333285cosignataire
17060000001499L17/dossiers17170600000014721706000000147227PA840939cosignataire
17060000001500L17/dossiers17170600000014721706000000147228PA841539cosignataire
17060000001501L17/dossiers17170600000014721706000000147229PA331973cosignataire
17060000001502L17/dossiers17170600000014721706000000147230PA840171cosignataire