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
17060000002664L17/dossiers17170600000026341706000000263430PA795844cosignataire
17060000002665L17/dossiers17170600000026341706000000263431PA841251cosignataire
17060000002666L17/dossiers17170600000026341706000000263432PA794786cosignataire
17060000002667L17/dossiers17170600000026341706000000263433PA794870cosignataire
17060000002668L17/dossiers17170600000026341706000000263434PA796070cosignataire
17060000002669L17/dossiers17170600000026341706000000263435PA795310cosignataire
17060000002670L17/dossiers17170600000026341706000000263436PA794478cosignataire
17060000002671L17/dossiers17170600000026341706000000263437PA841947cosignataire
17060000002672L17/dossiers17170600000026341706000000263438PA794082cosignataire
17060000002673L17/dossiers17170600000026341706000000263439PA794130cosignataire
17060000002674L17/dossiers17170600000026341706000000263440PA720846cosignataire
17060000002675L17/dossiers17170600000026341706000000263441PA841729cosignataire
17060000002676L17/dossiers17170600000026341706000000263442PA795516cosignataire
17060000002677L17/dossiers17170600000026341706000000263443PA795672cosignataire
17060000002678L17/dossiers17170600000026341706000000263444PA795746cosignataire
17060000002679L17/dossiers17170600000026341706000000263445PA795108cosignataire
17060000002680L17/dossiers17170600000026341706000000263446PA841515cosignataire
17060000002681L17/dossiers17170600000026341706000000263447PA795298cosignataire
17060000002682L17/dossiers17170600000026341706000000263448PA791824cosignataire
17060000002683L17/dossiers17170600000026341706000000263449PA842029cosignataire
17060000002684L17/dossiers17170600000026341706000000263450PA793532cosignataire
17060000002685L17/dossiers17170600000026341706000000263451PA342384cosignataire
17060000002686L17/dossiers17170600000026341706000000263452PA795422cosignataire
17060000002687L17/dossiers17170600000026341706000000263453PA794686cosignataire
17060000002688L17/dossiers17170600000026341706000000263454PA841215cosignataire
17060000002689L17/dossiers17170600000026341706000000263455PA795482cosignataire
17060000002690L17/dossiers17170600000026341706000000263456PA610654cosignataire
17060000002691L17/dossiers17170600000026341706000000263457PA841191cosignataire
17060000002692L17/dossiers17170600000026341706000000263458PA721960cosignataire
17060000002693L17/dossiers17170600000026341706000000263459PA793872cosignataire
17060000002694L17/dossiers17170600000026341706000000263460PA817211cosignataire
17060000002695L17/dossiers17170600000026341706000000263461PA793756cosignataire
17060000002696L17/dossiers17170600000026341706000000263462PA796062cosignataire
17060000002697L17/dossiers17170600000026341706000000263463PA719578cosignataire
17060000002698L17/dossiers17170600000026341706000000263464PA721062cosignataire
17060000002699L17/dossiers17170600000026341706000000263465PA841845cosignataire
17060000002700L17/dossiers17170600000026341706000000263466PA795982cosignataire
17060000002701L17/dossiers17170600000026341706000000263467PA795466cosignataire
17060000002702L17/dossiers17170600000026341706000000263468PA793744cosignataire
17060000002703L17/dossiers17170600000026341706000000263469PA720952cosignataire
17060000002704L17/dossiers17170600000026341706000000263470PA794106cosignataire
17060000002705L17/dossiers17170600000026341706000000263471PA794166cosignataire
17060000002706L17/dossiers17170600000026341706000000263472PA795164cosignataire
17060000002707L17/dossiers17170600000026341706000000263473PA795596cosignataire
17060000002708L17/dossiers17170600000026341706000000263474PA610968cosignataire
17060000002709L17/dossiers17170600000026341706000000263475PA793780cosignataire
17060000002710L17/dossiers17170600000026341706000000263476PA588884cosignataire
17060000002711L17/dossiers17170600000026341706000000263477PA841701cosignataire
17060000002712L17/dossiers17170600000026341706000000263478PA795362cosignataire
17060000002713L17/dossiers17170600000026341706000000263479PA795454cosignataire