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
16060000000784L16/dossiers1616060000000782160600000007822PA719930cosignataire
16060000000785L16/dossiers1616060000000782160600000007823PA795058cosignataire
16060000000786L16/dossiers1616060000000782160600000007824PA794008cosignataire
16060000000787L16/dossiers1616060000000782160600000007825PA267306cosignataire
16060000000788L16/dossiers1616060000000782160600000007826PA795228cosignataire
16060000000789L16/dossiers1616060000000782160600000007827PA793262cosignataire
16060000000790L16/dossiers1616060000000782160600000007828PA794906cosignataire
16060000000791L16/dossiers1616060000000782160600000007829PA794138cosignataire
16060000000792L16/dossiers16160600000007821606000000078210PA795588cosignataire
16060000000793L16/dossiers16160600000007821606000000078211PA795084cosignataire
16060000000794L16/dossiers16160600000007821606000000078212PA588884cosignataire
16060000000795L16/dossiers16160600000007821606000000078213PA720430cosignataire
16060000000796L16/dossiers16160600000007821606000000078214PA793772cosignataire
16060000000797L16/dossiers16160600000007821606000000078215PA795616cosignataire
16060000000798L16/dossiers16160600000007821606000000078216PA793444cosignataire
16060000000799L16/dossiers16160600000007821606000000078217PA794938cosignataire
16060000000800L16/dossiers16160600000007821606000000078218PA795318cosignataire
16060000000801L16/dossiers16160600000007821606000000078219PA796090cosignataire
16060000000802L16/dossiers16160600000007821606000000078220PA793912cosignataire
16060000000803L16/dossiers16160600000007821606000000078221PA795580cosignataire
16060000000804L16/dossiers16160600000007821606000000078222PA791812cosignataire
16060000000805L16/dossiers16160600000007821606000000078223PA793736cosignataire
16060000000806L16/dossiers16160600000007821606000000078224PA721202cosignataire
16060000000807L16/dossiers16160600000007821606000000078225PA721210cosignataire
16060000000808L16/dossiers16160600000007821606000000078226PA795136cosignataire
16060000000809L16/dossiers16160600000007821606000000078227PA793680cosignataire
16060000000810L16/dossiers16160600000007821606000000078228PA793452cosignataire
16060000000811L16/dossiers16160600000007821606000000078229PA793464cosignataire
16060000000812L16/dossiers16160600000007821606000000078230PA795200cosignataire
16060000000813L16/dossiers16160600000007821606000000078231PA795844cosignataire
16060000000814L16/dossiers16160600000007821606000000078232PA794458cosignataire
16060000000815L16/dossiers16160600000007821606000000078233PA794786cosignataire
16060000000816L16/dossiers16160600000007821606000000078234PA794870cosignataire
16060000000817L16/dossiers16160600000007821606000000078235PA720286cosignataire
16060000000818L16/dossiers16160600000007821606000000078236PA796070cosignataire
16060000000819L16/dossiers16160600000007821606000000078237PA796132cosignataire
16060000000820L16/dossiers16160600000007821606000000078238PA795310cosignataire
16060000000821L16/dossiers16160600000007821606000000078239PA794478cosignataire
16060000000822L16/dossiers16160600000007821606000000078240PA794082cosignataire
16060000000823L16/dossiers16160600000007821606000000078241PA795438cosignataire
16060000000824L16/dossiers16160600000007821606000000078242PA794130cosignataire
16060000000825L16/dossiers16160600000007821606000000078243PA720846cosignataire
16060000000826L16/dossiers16160600000007821606000000078244PA795516cosignataire
16060000000827L16/dossiers16160600000007821606000000078245PA795672cosignataire
16060000000828L16/dossiers16160600000007821606000000078246PA795746cosignataire
16060000000829L16/dossiers16160600000007821606000000078247PA795108cosignataire
16060000000830L16/dossiers16160600000007821606000000078248PA794402cosignataire
16060000000831L16/dossiers16160600000007821606000000078249PA795298cosignataire
16060000000832L16/dossiers16160600000007821606000000078250PA791824cosignataire
16060000000833L16/dossiers16160600000007821606000000078251PA793532cosignataire