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
17060000001045L17/dossiers17170600000009691706000000096976PA841845cosignataire
17060000001046L17/dossiers17170600000009691706000000096977PA795982cosignataire
17060000001047L17/dossiers17170600000009691706000000096978PA795808cosignataire
17060000001048L17/dossiers17170600000009691706000000096979PA795466cosignataire
17060000001049L17/dossiers17170600000009691706000000096980PA793744cosignataire
17060000001050L17/dossiers17170600000009691706000000096981PA720952cosignataire
17060000001051L17/dossiers17170600000009691706000000096982PA794106cosignataire
17060000001052L17/dossiers17170600000009691706000000096983PA794166cosignataire
17060000001053L17/dossiers17170600000009691706000000096984PA793948cosignataire
17060000001054L17/dossiers17170600000009691706000000096985PA842299cosignataire
17060000001055L17/dossiers17170600000009691706000000096986PA795164cosignataire
17060000001056L17/dossiers17170600000009691706000000096987PA795596cosignataire
17060000001058L17/dossiers1717060000001057170600000010571PA720614auteur
17060000001059L17/dossiers1717060000001057170600000010572PA330240cosignataire
17060000001060L17/dossiers1717060000001057170600000010573PA841067cosignataire
17060000001061L17/dossiers1717060000001057170600000010574PA793432cosignataire
17060000001062L17/dossiers1717060000001057170600000010575PA841207cosignataire
17060000001063L17/dossiers1717060000001057170600000010576PA841495cosignataire
17060000001064L17/dossiers1717060000001057170600000010577PA796118cosignataire
17060000001065L17/dossiers1717060000001057170600000010578PA794562cosignataire
17060000001066L17/dossiers1717060000001057170600000010579PA842279cosignataire
17060000001067L17/dossiers17170600000010571706000000105710PA793238cosignataire
17060000001068L17/dossiers17170600000010571706000000105711PA793374cosignataire
17060000001069L17/dossiers17170600000010571706000000105712PA793158cosignataire
17060000001070L17/dossiers17170600000010571706000000105713PA794434cosignataire
17060000001071L17/dossiers17170600000010571706000000105714PA841645cosignataire
17060000001072L17/dossiers17170600000010571706000000105715PA840889cosignataire
17060000001073L17/dossiers17170600000010571706000000105716PA793548cosignataire
17060000001074L17/dossiers17170600000010571706000000105717PA795644cosignataire
17060000001075L17/dossiers17170600000010571706000000105718PA840119cosignataire
17060000001076L17/dossiers17170600000010571706000000105719PA793166cosignataire
17060000001077L17/dossiers17170600000010571706000000105720PA793928cosignataire
17060000001078L17/dossiers17170600000010571706000000105721PA794762cosignataire
17060000001079L17/dossiers17170600000010571706000000105722PA793146cosignataire
17060000001080L17/dossiers17170600000010571706000000105723PA840135cosignataire
17060000001081L17/dossiers17170600000010571706000000105724PA842073cosignataire
17060000001082L17/dossiers17170600000010571706000000105725PA841761cosignataire
17060000001083L17/dossiers17170600000010571706000000105726PA841621cosignataire
17060000001084L17/dossiers17170600000010571706000000105727PA793246cosignataire
17060000001085L17/dossiers17170600000010571706000000105728PA840773cosignataire
17060000001086L17/dossiers17170600000010571706000000105729PA841613cosignataire
17060000001087L17/dossiers17170600000010571706000000105730PA840143cosignataire
17060000001088L17/dossiers17170600000010571706000000105731PA840801cosignataire
17060000001089L17/dossiers17170600000010571706000000105732PA794678cosignataire
17060000001090L17/dossiers17170600000010571706000000105733PA841139cosignataire
17060000001091L17/dossiers17170600000010571706000000105734PA793892cosignataire
17060000001092L17/dossiers17170600000010571706000000105735PA841737cosignataire
17060000001093L17/dossiers17170600000010571706000000105736PA796034cosignataire
17060000001094L17/dossiers17170600000010571706000000105737PA793832cosignataire
17060000001095L17/dossiers17170600000010571706000000105738PA841605cosignataire