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
17060000001655L17/dossiers17170600000016321706000000163223PA721202cosignataire
17060000001656L17/dossiers17170600000016321706000000163224PA795136cosignataire
17060000001657L17/dossiers17170600000016321706000000163225PA793464cosignataire
17060000001658L17/dossiers17170600000016321706000000163226PA842155cosignataire
17060000001659L17/dossiers17170600000016321706000000163227PA795200cosignataire
17060000001660L17/dossiers17170600000016321706000000163228PA795844cosignataire
17060000001661L17/dossiers17170600000016321706000000163229PA841251cosignataire
17060000001662L17/dossiers17170600000016321706000000163230PA794786cosignataire
17060000001663L17/dossiers17170600000016321706000000163231PA794870cosignataire
17060000001664L17/dossiers17170600000016321706000000163232PA796070cosignataire
17060000001665L17/dossiers17170600000016321706000000163233PA795310cosignataire
17060000001666L17/dossiers17170600000016321706000000163234PA794478cosignataire
17060000001667L17/dossiers17170600000016321706000000163235PA841947cosignataire
17060000001668L17/dossiers17170600000016321706000000163236PA794082cosignataire
17060000001669L17/dossiers17170600000016321706000000163237PA794130cosignataire
17060000001670L17/dossiers17170600000016321706000000163238PA720846cosignataire
17060000001671L17/dossiers17170600000016321706000000163239PA841729cosignataire
17060000001672L17/dossiers17170600000016321706000000163240PA795516cosignataire
17060000001673L17/dossiers17170600000016321706000000163241PA795672cosignataire
17060000001674L17/dossiers17170600000016321706000000163242PA795746cosignataire
17060000001675L17/dossiers17170600000016321706000000163243PA795108cosignataire
17060000001676L17/dossiers17170600000016321706000000163244PA841515cosignataire
17060000001677L17/dossiers17170600000016321706000000163245PA795298cosignataire
17060000001678L17/dossiers17170600000016321706000000163246PA791824cosignataire
17060000001679L17/dossiers17170600000016321706000000163247PA842029cosignataire
17060000001680L17/dossiers17170600000016321706000000163248PA793532cosignataire
17060000001681L17/dossiers17170600000016321706000000163249PA342384cosignataire
17060000001682L17/dossiers17170600000016321706000000163250PA795422cosignataire
17060000001683L17/dossiers17170600000016321706000000163251PA794686cosignataire
17060000001684L17/dossiers17170600000016321706000000163252PA841215cosignataire
17060000001685L17/dossiers17170600000016321706000000163253PA795482cosignataire
17060000001686L17/dossiers17170600000016321706000000163254PA610654cosignataire
17060000001687L17/dossiers17170600000016321706000000163255PA841191cosignataire
17060000001688L17/dossiers17170600000016321706000000163256PA721960cosignataire
17060000001689L17/dossiers17170600000016321706000000163257PA793872cosignataire
17060000001690L17/dossiers17170600000016321706000000163258PA817211cosignataire
17060000001691L17/dossiers17170600000016321706000000163259PA793756cosignataire
17060000001692L17/dossiers17170600000016321706000000163260PA796062cosignataire
17060000001693L17/dossiers17170600000016321706000000163261PA719578cosignataire
17060000001694L17/dossiers17170600000016321706000000163262PA721062cosignataire
17060000001695L17/dossiers17170600000016321706000000163263PA841845cosignataire
17060000001696L17/dossiers17170600000016321706000000163264PA795982cosignataire
17060000001697L17/dossiers17170600000016321706000000163265PA795466cosignataire
17060000001698L17/dossiers17170600000016321706000000163266PA793744cosignataire
17060000001699L17/dossiers17170600000016321706000000163267PA720952cosignataire
17060000001700L17/dossiers17170600000016321706000000163268PA794106cosignataire
17060000001701L17/dossiers17170600000016321706000000163269PA794166cosignataire
17060000001702L17/dossiers17170600000016321706000000163270PA795164cosignataire
17060000001703L17/dossiers17170600000016321706000000163271PA795596cosignataire
17060000001705L17/dossiers1717060000001704170600000017041PA720892auteur