AN · données ouvertes
Explorateur / dossiers

dossiers.document_auteur

Chemin document.auteurs.auteur · présence : L17 100 %, L16 100 %, L15 100 %, L14 100 %

59 600 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
16060000001136L16/dossiers161606000000102216060000001022114PA719578cosignataire
16060000001137L16/dossiers161606000000102216060000001022115PA720422cosignataire
16060000001138L16/dossiers161606000000102216060000001022116PA609590cosignataire
16060000001139L16/dossiers161606000000102216060000001022117PA721062cosignataire
16060000001140L16/dossiers161606000000102216060000001022118PA794154cosignataire
16060000001141L16/dossiers161606000000102216060000001022119PA794778cosignataire
16060000001142L16/dossiers161606000000102216060000001022120PA795876cosignataire
16060000001143L16/dossiers161606000000102216060000001022121PA793884cosignataire
16060000001144L16/dossiers161606000000102216060000001022122PA342196cosignataire
16060000001145L16/dossiers161606000000102216060000001022123PA795076cosignataire
16060000001146L16/dossiers161606000000102216060000001022124PA720692cosignataire
16060000001147L16/dossiers161606000000102216060000001022125PA722142cosignataire
16060000001148L16/dossiers161606000000102216060000001022126PA795982cosignataire
16060000001149L16/dossiers161606000000102216060000001022127PA793724cosignataire
16060000001150L16/dossiers161606000000102216060000001022128PA605745cosignataire
16060000001151L16/dossiers161606000000102216060000001022129PA774960cosignataire
16060000001152L16/dossiers161606000000102216060000001022130PA610002cosignataire
16060000001153L16/dossiers161606000000102216060000001022131PA340343cosignataire
16060000001154L16/dossiers161606000000102216060000001022132PA795808cosignataire
16060000001155L16/dossiers161606000000102216060000001022133PA796018cosignataire
16060000001156L16/dossiers161606000000102216060000001022134PA795466cosignataire
16060000001157L16/dossiers161606000000102216060000001022135PA793744cosignataire
16060000001158L16/dossiers161606000000102216060000001022136PA720952cosignataire
16060000001159L16/dossiers161606000000102216060000001022137PA736201cosignataire
16060000001160L16/dossiers161606000000102216060000001022138PA794106cosignataire
16060000001161L16/dossiers161606000000102216060000001022139PA794166cosignataire
16060000001162L16/dossiers161606000000102216060000001022140PA794650cosignataire
16060000001163L16/dossiers161606000000102216060000001022141PA793948cosignataire
16060000001164L16/dossiers161606000000102216060000001022142PA793816cosignataire
16060000001165L16/dossiers161606000000102216060000001022143PA795164cosignataire
16060000001166L16/dossiers161606000000102216060000001022144PA608695cosignataire
16060000001167L16/dossiers161606000000102216060000001022145PA795596cosignataire
16060000001168L16/dossiers161606000000102216060000001022146PA794494cosignataire
16060000001169L16/dossiers161606000000102216060000001022147PA793110cosignataire
16060000001170L16/dossiers161606000000102216060000001022148PA720992cosignataire
16060000001171L16/dossiers161606000000102216060000001022149PA722110cosignataire
16060000001173L16/dossiers1616060000001172160600000011721PA720892auteur
16060000001174L16/dossiers1616060000001172160600000011722PA719930cosignataire
16060000001175L16/dossiers1616060000001172160600000011723PA794008cosignataire
16060000001176L16/dossiers1616060000001172160600000011724PA267306cosignataire
16060000001177L16/dossiers1616060000001172160600000011725PA795228cosignataire
16060000001178L16/dossiers1616060000001172160600000011726PA793262cosignataire
16060000001179L16/dossiers1616060000001172160600000011727PA794906cosignataire
16060000001180L16/dossiers1616060000001172160600000011728PA794138cosignataire
16060000001181L16/dossiers1616060000001172160600000011729PA795588cosignataire
16060000001182L16/dossiers16160600000011721606000000117210PA795084cosignataire
16060000001183L16/dossiers16160600000011721606000000117211PA588884cosignataire
16060000001184L16/dossiers16160600000011721606000000117212PA720430cosignataire
16060000001185L16/dossiers16160600000011721606000000117213PA793772cosignataire
16060000001186L16/dossiers16160600000011721606000000117214PA795616cosignataire