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
17060000002411L17/dossiers171706000000231017060000002310101PA841395cosignataire
17060000002412L17/dossiers171706000000231017060000002310102PA841769cosignataire
17060000002413L17/dossiers171706000000231017060000002310103PA840657cosignataire
17060000002414L17/dossiers171706000000231017060000002310104PA840809cosignataire
17060000002416L17/dossiers1717060000002415170600000024151PA794008auteur
17060000002417L17/dossiers1717060000002415170600000024152PA720892cosignataire
17060000002418L17/dossiers1717060000002415170600000024153PA721270cosignataire
17060000002419L17/dossiers1717060000002415170600000024154PA793262cosignataire
17060000002420L17/dossiers1717060000002415170600000024155PA795228cosignataire
17060000002421L17/dossiers1717060000002415170600000024156PA794906cosignataire
17060000002422L17/dossiers1717060000002415170600000024157PA794138cosignataire
17060000002423L17/dossiers1717060000002415170600000024158PA795588cosignataire
17060000002424L17/dossiers1717060000002415170600000024159PA795084cosignataire
17060000002425L17/dossiers17170600000024151706000000241510PA842105cosignataire
17060000002426L17/dossiers17170600000024151706000000241511PA841657cosignataire
17060000002427L17/dossiers17170600000024151706000000241512PA720430cosignataire
17060000002428L17/dossiers17170600000024151706000000241513PA793772cosignataire
17060000002429L17/dossiers17170600000024151706000000241514PA795616cosignataire
17060000002430L17/dossiers17170600000024151706000000241515PA793444cosignataire
17060000002431L17/dossiers17170600000024151706000000241516PA794938cosignataire
17060000002432L17/dossiers17170600000024151706000000241517PA795318cosignataire
17060000002433L17/dossiers17170600000024151706000000241518PA841023cosignataire
17060000002434L17/dossiers17170600000024151706000000241519PA796090cosignataire
17060000002435L17/dossiers17170600000024151706000000241520PA793912cosignataire
17060000002436L17/dossiers17170600000024151706000000241521PA842187cosignataire
17060000002437L17/dossiers17170600000024151706000000241522PA842037cosignataire
17060000002438L17/dossiers17170600000024151706000000241523PA791812cosignataire
17060000002439L17/dossiers17170600000024151706000000241524PA793736cosignataire
17060000002440L17/dossiers17170600000024151706000000241525PA721202cosignataire
17060000002441L17/dossiers17170600000024151706000000241526PA795136cosignataire
17060000002442L17/dossiers17170600000024151706000000241527PA793464cosignataire
17060000002443L17/dossiers17170600000024151706000000241528PA842155cosignataire
17060000002444L17/dossiers17170600000024151706000000241529PA795200cosignataire
17060000002445L17/dossiers17170600000024151706000000241530PA795844cosignataire
17060000002446L17/dossiers17170600000024151706000000241531PA841251cosignataire
17060000002447L17/dossiers17170600000024151706000000241532PA794786cosignataire
17060000002448L17/dossiers17170600000024151706000000241533PA794870cosignataire
17060000002449L17/dossiers17170600000024151706000000241534PA796070cosignataire
17060000002450L17/dossiers17170600000024151706000000241535PA795310cosignataire
17060000002451L17/dossiers17170600000024151706000000241536PA794478cosignataire
17060000002452L17/dossiers17170600000024151706000000241537PA841947cosignataire
17060000002453L17/dossiers17170600000024151706000000241538PA794082cosignataire
17060000002454L17/dossiers17170600000024151706000000241539PA794130cosignataire
17060000002455L17/dossiers17170600000024151706000000241540PA720846cosignataire
17060000002456L17/dossiers17170600000024151706000000241541PA841729cosignataire
17060000002457L17/dossiers17170600000024151706000000241542PA795516cosignataire
17060000002458L17/dossiers17170600000024151706000000241543PA841515cosignataire
17060000002459L17/dossiers17170600000024151706000000241544PA795672cosignataire
17060000002460L17/dossiers17170600000024151706000000241545PA795746cosignataire
17060000002461L17/dossiers17170600000024151706000000241546PA795108cosignataire