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
17060000002210L17/dossiers17170600000021981706000000219812PA720430cosignataire
17060000002211L17/dossiers17170600000021981706000000219813PA793772cosignataire
17060000002212L17/dossiers17170600000021981706000000219814PA795616cosignataire
17060000002213L17/dossiers17170600000021981706000000219815PA793444cosignataire
17060000002214L17/dossiers17170600000021981706000000219816PA794938cosignataire
17060000002215L17/dossiers17170600000021981706000000219817PA795318cosignataire
17060000002216L17/dossiers17170600000021981706000000219818PA841023cosignataire
17060000002217L17/dossiers17170600000021981706000000219819PA793912cosignataire
17060000002218L17/dossiers17170600000021981706000000219820PA842187cosignataire
17060000002219L17/dossiers17170600000021981706000000219821PA842037cosignataire
17060000002220L17/dossiers17170600000021981706000000219822PA791812cosignataire
17060000002221L17/dossiers17170600000021981706000000219823PA793736cosignataire
17060000002222L17/dossiers17170600000021981706000000219824PA721202cosignataire
17060000002223L17/dossiers17170600000021981706000000219825PA795136cosignataire
17060000002224L17/dossiers17170600000021981706000000219826PA793464cosignataire
17060000002225L17/dossiers17170600000021981706000000219827PA842155cosignataire
17060000002226L17/dossiers17170600000021981706000000219828PA795200cosignataire
17060000002227L17/dossiers17170600000021981706000000219829PA795844cosignataire
17060000002228L17/dossiers17170600000021981706000000219830PA841251cosignataire
17060000002229L17/dossiers17170600000021981706000000219831PA794786cosignataire
17060000002230L17/dossiers17170600000021981706000000219832PA794870cosignataire
17060000002231L17/dossiers17170600000021981706000000219833PA796070cosignataire
17060000002232L17/dossiers17170600000021981706000000219834PA795310cosignataire
17060000002233L17/dossiers17170600000021981706000000219835PA794478cosignataire
17060000002234L17/dossiers17170600000021981706000000219836PA841947cosignataire
17060000002235L17/dossiers17170600000021981706000000219837PA794082cosignataire
17060000002236L17/dossiers17170600000021981706000000219838PA794130cosignataire
17060000002237L17/dossiers17170600000021981706000000219839PA720846cosignataire
17060000002238L17/dossiers17170600000021981706000000219840PA841729cosignataire
17060000002239L17/dossiers17170600000021981706000000219841PA841515cosignataire
17060000002240L17/dossiers17170600000021981706000000219842PA795516cosignataire
17060000002241L17/dossiers17170600000021981706000000219843PA795672cosignataire
17060000002242L17/dossiers17170600000021981706000000219844PA795746cosignataire
17060000002243L17/dossiers17170600000021981706000000219845PA795108cosignataire
17060000002244L17/dossiers17170600000021981706000000219846PA795298cosignataire
17060000002245L17/dossiers17170600000021981706000000219847PA791824cosignataire
17060000002246L17/dossiers17170600000021981706000000219848PA842029cosignataire
17060000002247L17/dossiers17170600000021981706000000219849PA793532cosignataire
17060000002248L17/dossiers17170600000021981706000000219850PA342384cosignataire
17060000002249L17/dossiers17170600000021981706000000219851PA795422cosignataire
17060000002250L17/dossiers17170600000021981706000000219852PA794686cosignataire
17060000002251L17/dossiers17170600000021981706000000219853PA841215cosignataire
17060000002252L17/dossiers17170600000021981706000000219854PA795482cosignataire
17060000002253L17/dossiers17170600000021981706000000219855PA610654cosignataire
17060000002254L17/dossiers17170600000021981706000000219856PA841191cosignataire
17060000002255L17/dossiers17170600000021981706000000219857PA721960cosignataire
17060000002256L17/dossiers17170600000021981706000000219858PA793872cosignataire
17060000002257L17/dossiers17170600000021981706000000219859PA817211cosignataire
17060000002258L17/dossiers17170600000021981706000000219860PA793756cosignataire
17060000002259L17/dossiers17170600000021981706000000219861PA796062cosignataire