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
17060000002159L17/dossiers17170600000021061706000000210653PA795672cosignataire
17060000002160L17/dossiers17170600000021061706000000210654PA795746cosignataire
17060000002161L17/dossiers17170600000021061706000000210655PA795108cosignataire
17060000002162L17/dossiers17170600000021061706000000210656PA841515cosignataire
17060000002163L17/dossiers17170600000021061706000000210657PA335612cosignataire
17060000002164L17/dossiers17170600000021061706000000210658PA795298cosignataire
17060000002165L17/dossiers17170600000021061706000000210659PA791824cosignataire
17060000002166L17/dossiers17170600000021061706000000210660PA842029cosignataire
17060000002167L17/dossiers17170600000021061706000000210661PA793532cosignataire
17060000002168L17/dossiers17170600000021061706000000210662PA795636cosignataire
17060000002169L17/dossiers17170600000021061706000000210663PA796010cosignataire
17060000002170L17/dossiers17170600000021061706000000210664PA342384cosignataire
17060000002171L17/dossiers17170600000021061706000000210665PA795422cosignataire
17060000002172L17/dossiers17170600000021061706000000210666PA794686cosignataire
17060000002173L17/dossiers17170600000021061706000000210667PA841215cosignataire
17060000002174L17/dossiers17170600000021061706000000210668PA795482cosignataire
17060000002175L17/dossiers17170600000021061706000000210669PA610654cosignataire
17060000002176L17/dossiers17170600000021061706000000210670PA841191cosignataire
17060000002177L17/dossiers17170600000021061706000000210671PA721960cosignataire
17060000002178L17/dossiers17170600000021061706000000210672PA793872cosignataire
17060000002179L17/dossiers17170600000021061706000000210673PA817211cosignataire
17060000002180L17/dossiers17170600000021061706000000210674PA793756cosignataire
17060000002181L17/dossiers17170600000021061706000000210675PA796062cosignataire
17060000002182L17/dossiers17170600000021061706000000210676PA719578cosignataire
17060000002183L17/dossiers17170600000021061706000000210677PA721062cosignataire
17060000002184L17/dossiers17170600000021061706000000210678PA795876cosignataire
17060000002185L17/dossiers17170600000021061706000000210679PA795076cosignataire
17060000002186L17/dossiers17170600000021061706000000210680PA841845cosignataire
17060000002187L17/dossiers17170600000021061706000000210681PA795982cosignataire
17060000002188L17/dossiers17170600000021061706000000210682PA605745cosignataire
17060000002189L17/dossiers17170600000021061706000000210683PA795808cosignataire
17060000002190L17/dossiers17170600000021061706000000210684PA796018cosignataire
17060000002191L17/dossiers17170600000021061706000000210685PA795466cosignataire
17060000002192L17/dossiers17170600000021061706000000210686PA793744cosignataire
17060000002193L17/dossiers17170600000021061706000000210687PA720952cosignataire
17060000002194L17/dossiers17170600000021061706000000210688PA794106cosignataire
17060000002195L17/dossiers17170600000021061706000000210689PA794166cosignataire
17060000002196L17/dossiers17170600000021061706000000210690PA795164cosignataire
17060000002197L17/dossiers17170600000021061706000000210691PA795596cosignataire
17060000002199L17/dossiers1717060000002198170600000021981PA720892auteur
17060000002200L17/dossiers1717060000002198170600000021982PA794008cosignataire
17060000002201L17/dossiers1717060000002198170600000021983PA721270cosignataire
17060000002202L17/dossiers1717060000002198170600000021984PA795228cosignataire
17060000002203L17/dossiers1717060000002198170600000021985PA793262cosignataire
17060000002204L17/dossiers1717060000002198170600000021986PA794906cosignataire
17060000002205L17/dossiers1717060000002198170600000021987PA794138cosignataire
17060000002206L17/dossiers1717060000002198170600000021988PA795588cosignataire
17060000002207L17/dossiers1717060000002198170600000021989PA795084cosignataire
17060000002208L17/dossiers17170600000021981706000000219810PA842105cosignataire
17060000002209L17/dossiers17170600000021981706000000219811PA841657cosignataire