AN · données ouvertes
Explorateur / dossiers

dossiers.document_auteur

Chemin document.auteurs.auteur · présence : L17 100 %, L16 100 %, L15 100 %, L14 100 %

59 600 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
16060000001036L16/dossiers16160600000010221606000000102214PA643143cosignataire
16060000001037L16/dossiers16160600000010221606000000102215PA335999cosignataire
16060000001038L16/dossiers16160600000010221606000000102216PA342415cosignataire
16060000001039L16/dossiers16160600000010221606000000102217PA795058cosignataire
16060000001040L16/dossiers16160600000010221606000000102218PA795362cosignataire
16060000001041L16/dossiers16160600000010221606000000102219PA795454cosignataire
16060000001042L16/dossiers16160600000010221606000000102220PA720430cosignataire
16060000001043L16/dossiers16160600000010221606000000102221PA793772cosignataire
16060000001044L16/dossiers16160600000010221606000000102222PA795616cosignataire
16060000001045L16/dossiers16160600000010221606000000102223PA793444cosignataire
16060000001046L16/dossiers16160600000010221606000000102224PA794094cosignataire
16060000001047L16/dossiers16160600000010221606000000102225PA794938cosignataire
16060000001048L16/dossiers16160600000010221606000000102226PA720838cosignataire
16060000001049L16/dossiers16160600000010221606000000102227PA795318cosignataire
16060000001050L16/dossiers16160600000010221606000000102228PA793624cosignataire
16060000001051L16/dossiers16160600000010221606000000102229PA795762cosignataire
16060000001052L16/dossiers16160600000010221606000000102230PA796090cosignataire
16060000001053L16/dossiers16160600000010221606000000102231PA793912cosignataire
16060000001054L16/dossiers16160600000010221606000000102232PA795868cosignataire
16060000001055L16/dossiers16160600000010221606000000102233PA795192cosignataire
16060000001056L16/dossiers16160600000010221606000000102234PA795580cosignataire
16060000001057L16/dossiers16160600000010221606000000102235PA791812cosignataire
16060000001058L16/dossiers16160600000010221606000000102236PA793736cosignataire
16060000001059L16/dossiers16160600000010221606000000102237PA721202cosignataire
16060000001060L16/dossiers16160600000010221606000000102238PA721210cosignataire
16060000001061L16/dossiers16160600000010221606000000102239PA795136cosignataire
16060000001062L16/dossiers16160600000010221606000000102240PA793680cosignataire
16060000001063L16/dossiers16160600000010221606000000102241PA793452cosignataire
16060000001064L16/dossiers16160600000010221606000000102242PA1008cosignataire
16060000001065L16/dossiers16160600000010221606000000102243PA793394cosignataire
16060000001066L16/dossiers16160600000010221606000000102244PA795430cosignataire
16060000001067L16/dossiers16160600000010221606000000102245PA793464cosignataire
16060000001068L16/dossiers16160600000010221606000000102246PA718926cosignataire
16060000001069L16/dossiers16160600000010221606000000102247PA795200cosignataire
16060000001070L16/dossiers16160600000010221606000000102248PA794854cosignataire
16060000001071L16/dossiers16160600000010221606000000102249PA795844cosignataire
16060000001072L16/dossiers16160600000010221606000000102250PA794458cosignataire
16060000001073L16/dossiers16160600000010221606000000102251PA721896cosignataire
16060000001074L16/dossiers16160600000010221606000000102252PA609332cosignataire
16060000001075L16/dossiers16160600000010221606000000102253PA794786cosignataire
16060000001076L16/dossiers16160600000010221606000000102254PA794870cosignataire
16060000001077L16/dossiers16160600000010221606000000102255PA720286cosignataire
16060000001078L16/dossiers16160600000010221606000000102256PA793980cosignataire
16060000001079L16/dossiers16160600000010221606000000102257PA796070cosignataire
16060000001080L16/dossiers16160600000010221606000000102258PA795010cosignataire
16060000001081L16/dossiers16160600000010221606000000102259PA333285cosignataire
16060000001082L16/dossiers16160600000010221606000000102260PA796132cosignataire
16060000001083L16/dossiers16160600000010221606000000102261PA1567cosignataire
16060000001084L16/dossiers16160600000010221606000000102262PA795310cosignataire
16060000001085L16/dossiers16160600000010221606000000102263PA794478cosignataire