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
17060000001350L17/dossiers17170600000012951706000000129555PA795164cosignataire
17060000001351L17/dossiers17170600000012951706000000129556PA795596cosignataire
17060000001352L17/dossiers17170600000012951706000000129557PA796090cosignataire
17060000001353L17/dossiers17170600000012951706000000129558PA795868cosignataire
17060000001355L17/dossiers1717060000001354170600000013541PA794008auteur
17060000001356L17/dossiers1717060000001354170600000013542PA795228cosignataire
17060000001357L17/dossiers1717060000001354170600000013543PA610968cosignataire
17060000001358L17/dossiers1717060000001354170600000013544PA793780cosignataire
17060000001359L17/dossiers1717060000001354170600000013545PA588884cosignataire
17060000001360L17/dossiers1717060000001354170600000013546PA841701cosignataire
17060000001361L17/dossiers1717060000001354170600000013547PA795362cosignataire
17060000001362L17/dossiers1717060000001354170600000013548PA795454cosignataire
17060000001363L17/dossiers1717060000001354170600000013549PA840997cosignataire
17060000001364L17/dossiers17170600000013541706000000135410PA841885cosignataire
17060000001365L17/dossiers17170600000013541706000000135411PA721210cosignataire
17060000001366L17/dossiers17170600000013541706000000135412PA793452cosignataire
17060000001367L17/dossiers17170600000013541706000000135413PA841351cosignataire
17060000001368L17/dossiers17170600000013541706000000135414PA793980cosignataire
17060000001369L17/dossiers17170600000013541706000000135415PA795010cosignataire
17060000001370L17/dossiers17170600000013541706000000135416PA841419cosignataire
17060000001371L17/dossiers17170600000013541706000000135417PA842013cosignataire
17060000001372L17/dossiers17170600000013541706000000135418PA794146cosignataire
17060000001373L17/dossiers17170600000013541706000000135419PA841223cosignataire
17060000001374L17/dossiers17170600000013541706000000135420PA795636cosignataire
17060000001375L17/dossiers17170600000013541706000000135421PA842045cosignataire
17060000001376L17/dossiers17170600000013541706000000135422PA793708cosignataire
17060000001377L17/dossiers17170600000013541706000000135423PA793664cosignataire
17060000001378L17/dossiers17170600000013541706000000135424PA794154cosignataire
17060000001379L17/dossiers17170600000013541706000000135425PA794778cosignataire
17060000001380L17/dossiers17170600000013541706000000135426PA795076cosignataire
17060000001381L17/dossiers17170600000013541706000000135427PA722142cosignataire
17060000001382L17/dossiers17170600000013541706000000135428PA795808cosignataire
17060000001383L17/dossiers17170600000013541706000000135429PA796018cosignataire
17060000001384L17/dossiers17170600000013541706000000135430PA736201cosignataire
17060000001385L17/dossiers17170600000013541706000000135431PA841713cosignataire
17060000001386L17/dossiers17170600000013541706000000135432PA793948cosignataire
17060000001387L17/dossiers17170600000013541706000000135433PA2940cosignataire
17060000001388L17/dossiers17170600000013541706000000135434PA793262cosignataire
17060000001389L17/dossiers17170600000013541706000000135435PA794906cosignataire
17060000001390L17/dossiers17170600000013541706000000135436PA794138cosignataire
17060000001391L17/dossiers17170600000013541706000000135437PA795588cosignataire
17060000001392L17/dossiers17170600000013541706000000135438PA795084cosignataire
17060000001393L17/dossiers17170600000013541706000000135439PA842105cosignataire
17060000001394L17/dossiers17170600000013541706000000135440PA841657cosignataire
17060000001395L17/dossiers17170600000013541706000000135441PA720430cosignataire
17060000001396L17/dossiers17170600000013541706000000135442PA793772cosignataire
17060000001397L17/dossiers17170600000013541706000000135443PA795616cosignataire
17060000001398L17/dossiers17170600000013541706000000135444PA794938cosignataire
17060000001399L17/dossiers17170600000013541706000000135445PA795318cosignataire
17060000001400L17/dossiers17170600000013541706000000135446PA841023cosignataire