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
17060000000944L17/dossiers17170600000009021706000000090242PA841463cosignataire
17060000000945L17/dossiers17170600000009021706000000090243PA643157cosignataire
17060000000946L17/dossiers17170600000009021706000000090244PA841107cosignataire
17060000000947L17/dossiers17170600000009021706000000090245PA841381cosignataire
17060000000948L17/dossiers17170600000009021706000000090246PA840793cosignataire
17060000000949L17/dossiers17170600000009021706000000090247PA794270cosignataire
17060000000950L17/dossiers17170600000009021706000000090248PA608172cosignataire
17060000000951L17/dossiers17170600000009021706000000090249PA607553cosignataire
17060000000952L17/dossiers17170600000009021706000000090250PA840955cosignataire
17060000000953L17/dossiers17170600000009021706000000090251PA841367cosignataire
17060000000954L17/dossiers17170600000009021706000000090252PA341981cosignataire
17060000000955L17/dossiers17170600000009021706000000090253PA840673cosignataire
17060000000956L17/dossiers17170600000009021706000000090254PA342196cosignataire
17060000000957L17/dossiers17170600000009021706000000090255PA826635cosignataire
17060000000958L17/dossiers17170600000009021706000000090256PA841327cosignataire
17060000000959L17/dossiers17170600000009021706000000090257PA841717cosignataire
17060000000960L17/dossiers17170600000009021706000000090258PA841243cosignataire
17060000000961L17/dossiers17170600000009021706000000090259PA774960cosignataire
17060000000962L17/dossiers17170600000009021706000000090260PA340343cosignataire
17060000000963L17/dossiers17170600000009021706000000090261PA841091cosignataire
17060000000964L17/dossiers17170600000009021706000000090262PA841681cosignataire
17060000000965L17/dossiers17170600000009021706000000090263PA841893cosignataire
17060000000966L17/dossiers17170600000009021706000000090264PA793816cosignataire
17060000000967L17/dossiers17170600000009021706000000090265PA794494cosignataire
17060000000968L17/dossiers17170600000009021706000000090266PA720992cosignataire
17060000000970L17/dossiers1717060000000969170600000009691PA720892auteur
17060000000971L17/dossiers1717060000000969170600000009692PA795228cosignataire
17060000000972L17/dossiers1717060000000969170600000009693PA793262cosignataire
17060000000973L17/dossiers1717060000000969170600000009694PA794906cosignataire
17060000000974L17/dossiers1717060000000969170600000009695PA794138cosignataire
17060000000975L17/dossiers1717060000000969170600000009696PA795588cosignataire
17060000000976L17/dossiers1717060000000969170600000009697PA795084cosignataire
17060000000977L17/dossiers1717060000000969170600000009698PA842105cosignataire
17060000000978L17/dossiers1717060000000969170600000009699PA793780cosignataire
17060000000979L17/dossiers17170600000009691706000000096910PA841657cosignataire
17060000000980L17/dossiers17170600000009691706000000096911PA796106cosignataire
17060000000981L17/dossiers17170600000009691706000000096912PA720430cosignataire
17060000000982L17/dossiers17170600000009691706000000096913PA793772cosignataire
17060000000983L17/dossiers17170600000009691706000000096914PA795616cosignataire
17060000000984L17/dossiers17170600000009691706000000096915PA793444cosignataire
17060000000985L17/dossiers17170600000009691706000000096916PA794938cosignataire
17060000000986L17/dossiers17170600000009691706000000096917PA720838cosignataire
17060000000987L17/dossiers17170600000009691706000000096918PA795318cosignataire
17060000000988L17/dossiers17170600000009691706000000096919PA841023cosignataire
17060000000989L17/dossiers17170600000009691706000000096920PA796090cosignataire
17060000000990L17/dossiers17170600000009691706000000096921PA793912cosignataire
17060000000991L17/dossiers17170600000009691706000000096922PA795868cosignataire
17060000000992L17/dossiers17170600000009691706000000096923PA842187cosignataire
17060000000993L17/dossiers17170600000009691706000000096924PA842037cosignataire
17060000000994L17/dossiers17170600000009691706000000096925PA791812cosignataire