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
17060000000692L17/dossiers17170600000006501706000000065042PA795156cosignataire
17060000000693L17/dossiers17170600000006501706000000065043PA774958cosignataire
17060000000694L17/dossiers17170600000006501706000000065044PA840765cosignataire
17060000000695L17/dossiers17170600000006501706000000065045PA841463cosignataire
17060000000696L17/dossiers17170600000006501706000000065046PA643157cosignataire
17060000000697L17/dossiers17170600000006501706000000065047PA841107cosignataire
17060000000698L17/dossiers17170600000006501706000000065048PA841381cosignataire
17060000000699L17/dossiers17170600000006501706000000065049PA840793cosignataire
17060000000700L17/dossiers17170600000006501706000000065050PA794270cosignataire
17060000000701L17/dossiers17170600000006501706000000065051PA608172cosignataire
17060000000702L17/dossiers17170600000006501706000000065052PA607553cosignataire
17060000000703L17/dossiers17170600000006501706000000065053PA840955cosignataire
17060000000704L17/dossiers17170600000006501706000000065054PA841367cosignataire
17060000000705L17/dossiers17170600000006501706000000065055PA341981cosignataire
17060000000706L17/dossiers17170600000006501706000000065056PA840673cosignataire
17060000000707L17/dossiers17170600000006501706000000065057PA342196cosignataire
17060000000708L17/dossiers17170600000006501706000000065058PA826635cosignataire
17060000000709L17/dossiers17170600000006501706000000065059PA841327cosignataire
17060000000710L17/dossiers17170600000006501706000000065060PA841717cosignataire
17060000000711L17/dossiers17170600000006501706000000065061PA841243cosignataire
17060000000712L17/dossiers17170600000006501706000000065062PA774960cosignataire
17060000000713L17/dossiers17170600000006501706000000065063PA340343cosignataire
17060000000714L17/dossiers17170600000006501706000000065064PA841091cosignataire
17060000000715L17/dossiers17170600000006501706000000065065PA841681cosignataire
17060000000716L17/dossiers17170600000006501706000000065066PA841893cosignataire
17060000000717L17/dossiers17170600000006501706000000065067PA793816cosignataire
17060000000718L17/dossiers17170600000006501706000000065068PA794494cosignataire
17060000000719L17/dossiers17170600000006501706000000065069PA720992cosignataire
17060000000720L17/dossiers17170600000006501706000000065070PA795228cosignataire
17060000000721L17/dossiers17170600000006501706000000065071PA793262cosignataire
17060000000722L17/dossiers17170600000006501706000000065072PA794906cosignataire
17060000000723L17/dossiers17170600000006501706000000065073PA794138cosignataire
17060000000724L17/dossiers17170600000006501706000000065074PA795588cosignataire
17060000000725L17/dossiers17170600000006501706000000065075PA795084cosignataire
17060000000726L17/dossiers17170600000006501706000000065076PA842105cosignataire
17060000000727L17/dossiers17170600000006501706000000065077PA841657cosignataire
17060000000728L17/dossiers17170600000006501706000000065078PA720430cosignataire
17060000000729L17/dossiers17170600000006501706000000065079PA793772cosignataire
17060000000730L17/dossiers17170600000006501706000000065080PA795616cosignataire
17060000000731L17/dossiers17170600000006501706000000065081PA793444cosignataire
17060000000732L17/dossiers17170600000006501706000000065082PA794938cosignataire
17060000000733L17/dossiers17170600000006501706000000065083PA795318cosignataire
17060000000734L17/dossiers17170600000006501706000000065084PA841023cosignataire
17060000000735L17/dossiers17170600000006501706000000065085PA796090cosignataire
17060000000736L17/dossiers17170600000006501706000000065086PA793912cosignataire
17060000000737L17/dossiers17170600000006501706000000065087PA842187cosignataire
17060000000738L17/dossiers17170600000006501706000000065088PA842037cosignataire
17060000000739L17/dossiers17170600000006501706000000065089PA791812cosignataire
17060000000740L17/dossiers17170600000006501706000000065090PA793736cosignataire
17060000000741L17/dossiers17170600000006501706000000065091PA721202cosignataire