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
17060000000742L17/dossiers17170600000006501706000000065092PA795136cosignataire
17060000000743L17/dossiers17170600000006501706000000065093PA793464cosignataire
17060000000744L17/dossiers17170600000006501706000000065094PA842155cosignataire
17060000000745L17/dossiers17170600000006501706000000065095PA795200cosignataire
17060000000746L17/dossiers17170600000006501706000000065096PA795844cosignataire
17060000000747L17/dossiers17170600000006501706000000065097PA841251cosignataire
17060000000748L17/dossiers17170600000006501706000000065098PA794786cosignataire
17060000000749L17/dossiers17170600000006501706000000065099PA794870cosignataire
17060000000750L17/dossiers171706000000065017060000000650100PA796070cosignataire
17060000000751L17/dossiers171706000000065017060000000650101PA795310cosignataire
17060000000752L17/dossiers171706000000065017060000000650102PA794478cosignataire
17060000000753L17/dossiers171706000000065017060000000650103PA841947cosignataire
17060000000754L17/dossiers171706000000065017060000000650104PA794082cosignataire
17060000000755L17/dossiers171706000000065017060000000650105PA794130cosignataire
17060000000756L17/dossiers171706000000065017060000000650106PA720846cosignataire
17060000000757L17/dossiers171706000000065017060000000650107PA841729cosignataire
17060000000758L17/dossiers171706000000065017060000000650108PA795516cosignataire
17060000000759L17/dossiers171706000000065017060000000650109PA795746cosignataire
17060000000760L17/dossiers171706000000065017060000000650110PA795108cosignataire
17060000000761L17/dossiers171706000000065017060000000650111PA841515cosignataire
17060000000762L17/dossiers171706000000065017060000000650112PA795672cosignataire
17060000000763L17/dossiers171706000000065017060000000650113PA795298cosignataire
17060000000764L17/dossiers171706000000065017060000000650114PA791824cosignataire
17060000000765L17/dossiers171706000000065017060000000650115PA842029cosignataire
17060000000766L17/dossiers171706000000065017060000000650116PA793532cosignataire
17060000000767L17/dossiers171706000000065017060000000650117PA342384cosignataire
17060000000768L17/dossiers171706000000065017060000000650118PA795422cosignataire
17060000000769L17/dossiers171706000000065017060000000650119PA794686cosignataire
17060000000770L17/dossiers171706000000065017060000000650120PA841215cosignataire
17060000000771L17/dossiers171706000000065017060000000650121PA795482cosignataire
17060000000772L17/dossiers171706000000065017060000000650122PA610654cosignataire
17060000000773L17/dossiers171706000000065017060000000650123PA841191cosignataire
17060000000774L17/dossiers171706000000065017060000000650124PA721960cosignataire
17060000000775L17/dossiers171706000000065017060000000650125PA793872cosignataire
17060000000776L17/dossiers171706000000065017060000000650126PA817211cosignataire
17060000000777L17/dossiers171706000000065017060000000650127PA793756cosignataire
17060000000778L17/dossiers171706000000065017060000000650128PA796062cosignataire
17060000000779L17/dossiers171706000000065017060000000650129PA841167cosignataire
17060000000780L17/dossiers171706000000065017060000000650130PA719578cosignataire
17060000000781L17/dossiers171706000000065017060000000650131PA721062cosignataire
17060000000782L17/dossiers171706000000065017060000000650132PA841845cosignataire
17060000000783L17/dossiers171706000000065017060000000650133PA795982cosignataire
17060000000784L17/dossiers171706000000065017060000000650134PA795466cosignataire
17060000000785L17/dossiers171706000000065017060000000650135PA793744cosignataire
17060000000786L17/dossiers171706000000065017060000000650136PA720952cosignataire
17060000000787L17/dossiers171706000000065017060000000650137PA794106cosignataire
17060000000788L17/dossiers171706000000065017060000000650138PA794166cosignataire
17060000000789L17/dossiers171706000000065017060000000650139PA795164cosignataire
17060000000790L17/dossiers171706000000065017060000000650140PA795596cosignataire
17060000000791L17/dossiers171706000000065017060000000650141PA610968cosignataire