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
17060000001706L17/dossiers1717060000001704170600000017042PA795228cosignataire
17060000001707L17/dossiers1717060000001704170600000017043PA793262cosignataire
17060000001708L17/dossiers1717060000001704170600000017044PA794906cosignataire
17060000001709L17/dossiers1717060000001704170600000017045PA794138cosignataire
17060000001710L17/dossiers1717060000001704170600000017046PA795588cosignataire
17060000001711L17/dossiers1717060000001704170600000017047PA795084cosignataire
17060000001712L17/dossiers1717060000001704170600000017048PA842105cosignataire
17060000001713L17/dossiers1717060000001704170600000017049PA841657cosignataire
17060000001714L17/dossiers17170600000017041706000000170410PA720430cosignataire
17060000001715L17/dossiers17170600000017041706000000170411PA793772cosignataire
17060000001716L17/dossiers17170600000017041706000000170412PA795616cosignataire
17060000001717L17/dossiers17170600000017041706000000170413PA793444cosignataire
17060000001718L17/dossiers17170600000017041706000000170414PA794938cosignataire
17060000001719L17/dossiers17170600000017041706000000170415PA795318cosignataire
17060000001720L17/dossiers17170600000017041706000000170416PA841023cosignataire
17060000001721L17/dossiers17170600000017041706000000170417PA796090cosignataire
17060000001722L17/dossiers17170600000017041706000000170418PA793912cosignataire
17060000001723L17/dossiers17170600000017041706000000170419PA842187cosignataire
17060000001724L17/dossiers17170600000017041706000000170420PA842037cosignataire
17060000001725L17/dossiers17170600000017041706000000170421PA791812cosignataire
17060000001726L17/dossiers17170600000017041706000000170422PA793736cosignataire
17060000001727L17/dossiers17170600000017041706000000170423PA721202cosignataire
17060000001728L17/dossiers17170600000017041706000000170424PA795136cosignataire
17060000001729L17/dossiers17170600000017041706000000170425PA793464cosignataire
17060000001730L17/dossiers17170600000017041706000000170426PA842155cosignataire
17060000001731L17/dossiers17170600000017041706000000170427PA795200cosignataire
17060000001732L17/dossiers17170600000017041706000000170428PA795844cosignataire
17060000001733L17/dossiers17170600000017041706000000170429PA841251cosignataire
17060000001734L17/dossiers17170600000017041706000000170430PA794786cosignataire
17060000001735L17/dossiers17170600000017041706000000170431PA794870cosignataire
17060000001736L17/dossiers17170600000017041706000000170432PA796070cosignataire
17060000001737L17/dossiers17170600000017041706000000170433PA795310cosignataire
17060000001738L17/dossiers17170600000017041706000000170434PA794478cosignataire
17060000001739L17/dossiers17170600000017041706000000170435PA841947cosignataire
17060000001740L17/dossiers17170600000017041706000000170436PA794082cosignataire
17060000001741L17/dossiers17170600000017041706000000170437PA794130cosignataire
17060000001742L17/dossiers17170600000017041706000000170438PA720846cosignataire
17060000001743L17/dossiers17170600000017041706000000170439PA841729cosignataire
17060000001744L17/dossiers17170600000017041706000000170440PA795516cosignataire
17060000001745L17/dossiers17170600000017041706000000170441PA795672cosignataire
17060000001746L17/dossiers17170600000017041706000000170442PA795746cosignataire
17060000001747L17/dossiers17170600000017041706000000170443PA774962cosignataire
17060000001748L17/dossiers17170600000017041706000000170444PA795108cosignataire
17060000001749L17/dossiers17170600000017041706000000170445PA841515cosignataire
17060000001750L17/dossiers17170600000017041706000000170446PA335612cosignataire
17060000001751L17/dossiers17170600000017041706000000170447PA795298cosignataire
17060000001752L17/dossiers17170600000017041706000000170448PA791824cosignataire
17060000001753L17/dossiers17170600000017041706000000170449PA842029cosignataire
17060000001754L17/dossiers17170600000017041706000000170450PA793532cosignataire
17060000001755L17/dossiers17170600000017041706000000170451PA795636cosignataire