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
17060000000995L17/dossiers17170600000009691706000000096926PA793736cosignataire
17060000000996L17/dossiers17170600000009691706000000096927PA721202cosignataire
17060000000997L17/dossiers17170600000009691706000000096928PA795136cosignataire
17060000000998L17/dossiers17170600000009691706000000096929PA793464cosignataire
17060000000999L17/dossiers17170600000009691706000000096930PA842155cosignataire
17060000001000L17/dossiers17170600000009691706000000096931PA795200cosignataire
17060000001001L17/dossiers17170600000009691706000000096932PA795844cosignataire
17060000001002L17/dossiers17170600000009691706000000096933PA721896cosignataire
17060000001003L17/dossiers17170600000009691706000000096934PA841251cosignataire
17060000001004L17/dossiers17170600000009691706000000096935PA794786cosignataire
17060000001005L17/dossiers17170600000009691706000000096936PA794870cosignataire
17060000001006L17/dossiers17170600000009691706000000096937PA796070cosignataire
17060000001007L17/dossiers17170600000009691706000000096938PA795310cosignataire
17060000001008L17/dossiers17170600000009691706000000096939PA794478cosignataire
17060000001009L17/dossiers17170600000009691706000000096940PA841947cosignataire
17060000001010L17/dossiers17170600000009691706000000096941PA794082cosignataire
17060000001011L17/dossiers17170600000009691706000000096942PA795998cosignataire
17060000001012L17/dossiers17170600000009691706000000096943PA794130cosignataire
17060000001013L17/dossiers17170600000009691706000000096944PA720846cosignataire
17060000001014L17/dossiers17170600000009691706000000096945PA841729cosignataire
17060000001015L17/dossiers17170600000009691706000000096946PA795516cosignataire
17060000001016L17/dossiers17170600000009691706000000096947PA795672cosignataire
17060000001017L17/dossiers17170600000009691706000000096948PA795746cosignataire
17060000001018L17/dossiers17170600000009691706000000096949PA774962cosignataire
17060000001019L17/dossiers17170600000009691706000000096950PA795108cosignataire
17060000001020L17/dossiers17170600000009691706000000096951PA335612cosignataire
17060000001021L17/dossiers17170600000009691706000000096952PA841515cosignataire
17060000001022L17/dossiers17170600000009691706000000096953PA795298cosignataire
17060000001023L17/dossiers17170600000009691706000000096954PA791824cosignataire
17060000001024L17/dossiers17170600000009691706000000096955PA842029cosignataire
17060000001025L17/dossiers17170600000009691706000000096956PA793532cosignataire
17060000001026L17/dossiers17170600000009691706000000096957PA795636cosignataire
17060000001027L17/dossiers17170600000009691706000000096958PA796010cosignataire
17060000001028L17/dossiers17170600000009691706000000096959PA342384cosignataire
17060000001029L17/dossiers17170600000009691706000000096960PA795422cosignataire
17060000001030L17/dossiers17170600000009691706000000096961PA794686cosignataire
17060000001031L17/dossiers17170600000009691706000000096962PA841215cosignataire
17060000001032L17/dossiers17170600000009691706000000096963PA795482cosignataire
17060000001033L17/dossiers17170600000009691706000000096964PA795820cosignataire
17060000001034L17/dossiers17170600000009691706000000096965PA610654cosignataire
17060000001035L17/dossiers17170600000009691706000000096966PA841191cosignataire
17060000001036L17/dossiers17170600000009691706000000096967PA721960cosignataire
17060000001037L17/dossiers17170600000009691706000000096968PA793872cosignataire
17060000001038L17/dossiers17170600000009691706000000096969PA817211cosignataire
17060000001039L17/dossiers17170600000009691706000000096970PA793756cosignataire
17060000001040L17/dossiers17170600000009691706000000096971PA796062cosignataire
17060000001041L17/dossiers17170600000009691706000000096972PA719578cosignataire
17060000001042L17/dossiers17170600000009691706000000096973PA721062cosignataire
17060000001043L17/dossiers17170600000009691706000000096974PA794778cosignataire
17060000001044L17/dossiers17170600000009691706000000096975PA795076cosignataire