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
16060000000935L16/dossiers1616060000000933160600000009332PA793432cosignataire
16060000000936L16/dossiers1616060000000933160600000009333PA796118cosignataire
16060000000937L16/dossiers1616060000000933160600000009334PA794562cosignataire
16060000000938L16/dossiers1616060000000933160600000009335PA793238cosignataire
16060000000939L16/dossiers1616060000000933160600000009336PA793374cosignataire
16060000000940L16/dossiers1616060000000933160600000009337PA793158cosignataire
16060000000941L16/dossiers1616060000000933160600000009338PA794434cosignataire
16060000000942L16/dossiers1616060000000933160600000009339PA794522cosignataire
16060000000943L16/dossiers16160600000009331606000000093310PA720822cosignataire
16060000000944L16/dossiers16160600000009331606000000093311PA720668cosignataire
16060000000945L16/dossiers16160600000009331606000000093312PA794886cosignataire
16060000000946L16/dossiers16160600000009331606000000093313PA796042cosignataire
16060000000947L16/dossiers16160600000009331606000000093314PA793844cosignataire
16060000000948L16/dossiers16160600000009331606000000093315PA793182cosignataire
16060000000949L16/dossiers16160600000009331606000000093316PA793134cosignataire
16060000000950L16/dossiers16160600000009331606000000093317PA795836cosignataire
16060000000951L16/dossiers16160600000009331606000000093318PA794638cosignataire
16060000000952L16/dossiers16160600000009331606000000093319PA720468cosignataire
16060000000953L16/dossiers16160600000009331606000000093320PA794198cosignataire
16060000000954L16/dossiers16160600000009331606000000093321PA793548cosignataire
16060000000955L16/dossiers16160600000009331606000000093322PA794222cosignataire
16060000000956L16/dossiers16160600000009331606000000093323PA795644cosignataire
16060000000957L16/dossiers16160600000009331606000000093324PA793166cosignataire
16060000000958L16/dossiers16160600000009331606000000093325PA793928cosignataire
16060000000959L16/dossiers16160600000009331606000000093326PA794762cosignataire
16060000000960L16/dossiers16160600000009331606000000093327PA793146cosignataire
16060000000961L16/dossiers16160600000009331606000000093328PA794718cosignataire
16060000000962L16/dossiers16160600000009331606000000093329PA793246cosignataire
16060000000963L16/dossiers16160600000009331606000000093330PA793964cosignataire
16060000000964L16/dossiers16160600000009331606000000093331PA794538cosignataire
16060000000965L16/dossiers16160600000009331606000000093332PA794678cosignataire
16060000000966L16/dossiers16160600000009331606000000093333PA793892cosignataire
16060000000967L16/dossiers16160600000009331606000000093334PA796034cosignataire
16060000000968L16/dossiers16160600000009331606000000093335PA793832cosignataire
16060000000969L16/dossiers16160600000009331606000000093336PA793102cosignataire
16060000000970L16/dossiers16160600000009331606000000093337PA793362cosignataire
16060000000971L16/dossiers16160600000009331606000000093338PA794418cosignataire
16060000000972L16/dossiers16160600000009331606000000093339PA793592cosignataire
16060000000973L16/dossiers16160600000009331606000000093340PA795540cosignataire
16060000000974L16/dossiers16160600000009331606000000093341PA794734cosignataire
16060000000975L16/dossiers16160600000009331606000000093342PA793218cosignataire
16060000000976L16/dossiers16160600000009331606000000093343PA795900cosignataire
16060000000977L16/dossiers16160600000009331606000000093344PA796110cosignataire
16060000000978L16/dossiers16160600000009331606000000093345PA793632cosignataire
16060000000979L16/dossiers16160600000009331606000000093346PA794598cosignataire
16060000000980L16/dossiers16160600000009331606000000093347PA794030cosignataire
16060000000981L16/dossiers16160600000009331606000000093348PA794354cosignataire
16060000000982L16/dossiers16160600000009331606000000093349PA795912cosignataire
16060000000983L16/dossiers16160600000009331606000000093350PA796026cosignataire
16060000000984L16/dossiers16160600000009331606000000093351PA793290cosignataire