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
17060000110986L17/dossiers1717060000110985170600001109851PA788192rapporteur
17060000110987L17/dossiers1717060000110985170600001109852PO516753
17060000110989L17/dossiers1717060000110988170600001109881PA827988rapporteur
17060000110990L17/dossiers1717060000110988170600001109882PO211495
17060000110992L17/dossiers1717060000110991170600001109911PA827998rapporteur
17060000110993L17/dossiers1717060000110991170600001109912PO211491
17060000110995L17/dossiers1717060000110994170600001109941PA703506rapporteur
17060000110996L17/dossiers1717060000110994170600001109942PO211491
17060000110998L17/dossiers1717060000110997170600001109971PA590034rapporteur
17060000110999L17/dossiers1717060000110997170600001109972PO211491
17060000111001L17/dossiers1717060000111000170600001110001PA747422rapporteur
17060000111002L17/dossiers1717060000111000170600001110002PO211491
17060000111004L17/dossiers1717060000111003170600001110031PA703510rapporteur
17060000111005L17/dossiers1717060000111003170600001110032PO211495
17060000111007L17/dossiers1717060000111006170600001110061PA736188rapporteur
17060000111008L17/dossiers1717060000111006170600001110062PO211494
17060000111010L17/dossiers1717060000111009170600001110091PA763158rapporteur
17060000111011L17/dossiers1717060000111009170600001110092PA827958rapporteur
17060000111012L17/dossiers1717060000111009170600001110093PO211493
17060000111014L17/dossiers1717060000111013170600001110131PA775248rapporteur
17060000111015L17/dossiers1717060000111013170600001110132PO211495
17060000111017L17/dossiers1717060000111016170600001110161PA606375rapporteur
17060000111018L17/dossiers1717060000111016170600001110162PO211493
17060000111020L17/dossiers1717060000111019170600001110191PA736205rapporteur
17060000111021L17/dossiers1717060000111019170600001110192PO211495
17060000111023L17/dossiers1717060000111022170600001110221PA827918rapporteur
17060000111024L17/dossiers1717060000111022170600001110222PO516753
17060000111026L17/dossiers1717060000111025170600001110251PA703513rapporteur
17060000111027L17/dossiers1717060000111025170600001110252PO516753
17060000111029L17/dossiers1717060000111028170600001110281PA775212rapporteur
17060000111030L17/dossiers1717060000111028170600001110282PO211493
17060000111032L17/dossiers1717060000111031170600001110311PA607489rapporteur
17060000111033L17/dossiers1717060000111031170600001110312PO516754
17060000111035L17/dossiers1717060000111034170600001110341PA775288rapporteur
17060000111036L17/dossiers1717060000111034170600001110342PO211494
17060000111038L17/dossiers1717060000111037170600001110371PA304017rapporteur
17060000111039L17/dossiers1717060000111037170600001110372PO211490
17060000111041L17/dossiers1717060000111040170600001110401PA775202rapporteur
17060000111042L17/dossiers1717060000111040170600001110402PO211493
17060000111044L17/dossiers1717060000111043170600001110431PA775184rapporteur
17060000111045L17/dossiers1717060000111043170600001110432PO211495
17060000111047L17/dossiers1717060000111046170600001110461PA849528rapporteur
17060000111048L17/dossiers1717060000111046170600001110462PO211495
17060000111050L17/dossiers1717060000111049170600001110491PA775258rapporteur
17060000111051L17/dossiers1717060000111049170600001110492PO211493
17060000111053L17/dossiers1717060000111052170600001110521PA736192rapporteur
17060000111054L17/dossiers1717060000111052170600001110522PO211490
17060000111056L17/dossiers1717060000111055170600001110551PA703530rapporteur
17060000111057L17/dossiers1717060000111055170600001110552PA775208rapporteur
17060000111058L17/dossiers1717060000111055170600001110553PA775256rapporteur