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
17060000001503L17/dossiers17170600000014721706000000147231PA1567cosignataire
17060000001504L17/dossiers17170600000014721706000000147232PA841471cosignataire
17060000001505L17/dossiers17170600000014721706000000147233PA842263cosignataire
17060000001506L17/dossiers17170600000014721706000000147234PA841813cosignataire
17060000001507L17/dossiers17170600000014721706000000147235PA841853cosignataire
17060000001508L17/dossiers17170600000014721706000000147236PA1654cosignataire
17060000001509L17/dossiers17170600000014721706000000147237PA643192cosignataire
17060000001510L17/dossiers17170600000014721706000000147238PA335054cosignataire
17060000001511L17/dossiers17170600000014721706000000147239PA795156cosignataire
17060000001512L17/dossiers17170600000014721706000000147240PA774958cosignataire
17060000001513L17/dossiers17170600000014721706000000147241PA840765cosignataire
17060000001514L17/dossiers17170600000014721706000000147242PA841463cosignataire
17060000001515L17/dossiers17170600000014721706000000147243PA643157cosignataire
17060000001516L17/dossiers17170600000014721706000000147244PA841107cosignataire
17060000001517L17/dossiers17170600000014721706000000147245PA841381cosignataire
17060000001518L17/dossiers17170600000014721706000000147246PA840793cosignataire
17060000001519L17/dossiers17170600000014721706000000147247PA794270cosignataire
17060000001520L17/dossiers17170600000014721706000000147248PA608172cosignataire
17060000001521L17/dossiers17170600000014721706000000147249PA607553cosignataire
17060000001522L17/dossiers17170600000014721706000000147250PA840955cosignataire
17060000001523L17/dossiers17170600000014721706000000147251PA841367cosignataire
17060000001524L17/dossiers17170600000014721706000000147252PA341981cosignataire
17060000001525L17/dossiers17170600000014721706000000147253PA840673cosignataire
17060000001526L17/dossiers17170600000014721706000000147254PA342196cosignataire
17060000001527L17/dossiers17170600000014721706000000147255PA826635cosignataire
17060000001528L17/dossiers17170600000014721706000000147256PA841327cosignataire
17060000001529L17/dossiers17170600000014721706000000147257PA841717cosignataire
17060000001530L17/dossiers17170600000014721706000000147258PA841243cosignataire
17060000001531L17/dossiers17170600000014721706000000147259PA774960cosignataire
17060000001532L17/dossiers17170600000014721706000000147260PA340343cosignataire
17060000001533L17/dossiers17170600000014721706000000147261PA841091cosignataire
17060000001534L17/dossiers17170600000014721706000000147262PA841681cosignataire
17060000001535L17/dossiers17170600000014721706000000147263PA841893cosignataire
17060000001536L17/dossiers17170600000014721706000000147264PA793816cosignataire
17060000001537L17/dossiers17170600000014721706000000147265PA794494cosignataire
17060000001538L17/dossiers17170600000014721706000000147266PA720992cosignataire
17060000001540L17/dossiers1717060000001539170600000015391PA720892auteur
17060000001541L17/dossiers1717060000001539170600000015392PA795228cosignataire
17060000001542L17/dossiers1717060000001539170600000015393PA793262cosignataire
17060000001543L17/dossiers1717060000001539170600000015394PA794906cosignataire
17060000001544L17/dossiers1717060000001539170600000015395PA794138cosignataire
17060000001545L17/dossiers1717060000001539170600000015396PA795588cosignataire
17060000001546L17/dossiers1717060000001539170600000015397PA795084cosignataire
17060000001547L17/dossiers1717060000001539170600000015398PA842105cosignataire
17060000001548L17/dossiers1717060000001539170600000015399PA793780cosignataire
17060000001549L17/dossiers17170600000015391706000000153910PA588884cosignataire
17060000001550L17/dossiers17170600000015391706000000153911PA841657cosignataire
17060000001551L17/dossiers17170600000015391706000000153912PA796106cosignataire
17060000001552L17/dossiers17170600000015391706000000153913PA795454cosignataire
17060000001553L17/dossiers17170600000015391706000000153914PA720430cosignataire