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
17060000002462L17/dossiers17170600000024151706000000241547PA795298cosignataire
17060000002463L17/dossiers17170600000024151706000000241548PA791824cosignataire
17060000002464L17/dossiers17170600000024151706000000241549PA842029cosignataire
17060000002465L17/dossiers17170600000024151706000000241550PA793532cosignataire
17060000002466L17/dossiers17170600000024151706000000241551PA342384cosignataire
17060000002467L17/dossiers17170600000024151706000000241552PA795422cosignataire
17060000002468L17/dossiers17170600000024151706000000241553PA794686cosignataire
17060000002469L17/dossiers17170600000024151706000000241554PA841215cosignataire
17060000002470L17/dossiers17170600000024151706000000241555PA795482cosignataire
17060000002471L17/dossiers17170600000024151706000000241556PA610654cosignataire
17060000002472L17/dossiers17170600000024151706000000241557PA841191cosignataire
17060000002473L17/dossiers17170600000024151706000000241558PA721960cosignataire
17060000002474L17/dossiers17170600000024151706000000241559PA793872cosignataire
17060000002475L17/dossiers17170600000024151706000000241560PA817211cosignataire
17060000002476L17/dossiers17170600000024151706000000241561PA793756cosignataire
17060000002477L17/dossiers17170600000024151706000000241562PA796062cosignataire
17060000002478L17/dossiers17170600000024151706000000241563PA719578cosignataire
17060000002479L17/dossiers17170600000024151706000000241564PA721062cosignataire
17060000002480L17/dossiers17170600000024151706000000241565PA841845cosignataire
17060000002481L17/dossiers17170600000024151706000000241566PA795982cosignataire
17060000002482L17/dossiers17170600000024151706000000241567PA795466cosignataire
17060000002483L17/dossiers17170600000024151706000000241568PA793744cosignataire
17060000002484L17/dossiers17170600000024151706000000241569PA720952cosignataire
17060000002485L17/dossiers17170600000024151706000000241570PA794106cosignataire
17060000002486L17/dossiers17170600000024151706000000241571PA794166cosignataire
17060000002487L17/dossiers17170600000024151706000000241572PA795164cosignataire
17060000002488L17/dossiers17170600000024151706000000241573PA795596cosignataire
17060000002489L17/dossiers17170600000024151706000000241574PA610968cosignataire
17060000002490L17/dossiers17170600000024151706000000241575PA793780cosignataire
17060000002491L17/dossiers17170600000024151706000000241576PA588884cosignataire
17060000002492L17/dossiers17170600000024151706000000241577PA841701cosignataire
17060000002493L17/dossiers17170600000024151706000000241578PA795362cosignataire
17060000002494L17/dossiers17170600000024151706000000241579PA795454cosignataire
17060000002495L17/dossiers17170600000024151706000000241580PA840997cosignataire
17060000002496L17/dossiers17170600000024151706000000241581PA841885cosignataire
17060000002497L17/dossiers17170600000024151706000000241582PA721210cosignataire
17060000002498L17/dossiers17170600000024151706000000241583PA793452cosignataire
17060000002499L17/dossiers17170600000024151706000000241584PA793980cosignataire
17060000002500L17/dossiers17170600000024151706000000241585PA841419cosignataire
17060000002501L17/dossiers17170600000024151706000000241586PA794146cosignataire
17060000002502L17/dossiers17170600000024151706000000241587PA795636cosignataire
17060000002503L17/dossiers17170600000024151706000000241588PA842045cosignataire
17060000002504L17/dossiers17170600000024151706000000241589PA793708cosignataire
17060000002505L17/dossiers17170600000024151706000000241590PA793664cosignataire
17060000002506L17/dossiers17170600000024151706000000241591PA794154cosignataire
17060000002507L17/dossiers17170600000024151706000000241592PA794778cosignataire
17060000002508L17/dossiers17170600000024151706000000241593PA606545cosignataire
17060000002509L17/dossiers17170600000024151706000000241594PA795076cosignataire
17060000002510L17/dossiers17170600000024151706000000241595PA722142cosignataire
17060000002511L17/dossiers17170600000024151706000000241596PA795808cosignataire