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
16060000000884L16/dossiers161606000000078216060000000782102PA609590cosignataire
16060000000885L16/dossiers161606000000078216060000000782103PA342196cosignataire
16060000000886L16/dossiers161606000000078216060000000782104PA774960cosignataire
16060000000887L16/dossiers161606000000078216060000000782105PA340343cosignataire
16060000000888L16/dossiers161606000000078216060000000782106PA793816cosignataire
16060000000889L16/dossiers161606000000078216060000000782107PA608695cosignataire
16060000000890L16/dossiers161606000000078216060000000782108PA794494cosignataire
16060000000891L16/dossiers161606000000078216060000000782109PA793780cosignataire
16060000000892L16/dossiers161606000000078216060000000782110PA335999cosignataire
16060000000893L16/dossiers161606000000078216060000000782111PA795362cosignataire
16060000000894L16/dossiers161606000000078216060000000782112PA795454cosignataire
16060000000895L16/dossiers161606000000078216060000000782113PA793980cosignataire
16060000000896L16/dossiers161606000000078216060000000782114PA795010cosignataire
16060000000897L16/dossiers161606000000078216060000000782115PA794022cosignataire
16060000000898L16/dossiers161606000000078216060000000782116PA722344cosignataire
16060000000899L16/dossiers161606000000078216060000000782117PA794146cosignataire
16060000000900L16/dossiers161606000000078216060000000782118PA795636cosignataire
16060000000901L16/dossiers161606000000078216060000000782119PA795794cosignataire
16060000000902L16/dossiers161606000000078216060000000782120PA793708cosignataire
16060000000903L16/dossiers161606000000078216060000000782121PA793664cosignataire
16060000000904L16/dossiers161606000000078216060000000782122PA794154cosignataire
16060000000905L16/dossiers161606000000078216060000000782123PA794778cosignataire
16060000000906L16/dossiers161606000000078216060000000782124PA795076cosignataire
16060000000907L16/dossiers161606000000078216060000000782125PA610002cosignataire
16060000000908L16/dossiers161606000000078216060000000782126PA795808cosignataire
16060000000909L16/dossiers161606000000078216060000000782127PA720952cosignataire
16060000000910L16/dossiers161606000000078216060000000782128PA736201cosignataire
16060000000911L16/dossiers161606000000078216060000000782129PA793948cosignataire
16060000000912L16/dossiers161606000000078216060000000782130PA720838cosignataire
16060000000913L16/dossiers161606000000078216060000000782131PA721118cosignataire
16060000000914L16/dossiers161606000000078216060000000782132PA795868cosignataire
16060000000915L16/dossiers161606000000078216060000000782133PA795192cosignataire
16060000000916L16/dossiers161606000000078216060000000782134PA718926cosignataire
16060000000917L16/dossiers161606000000078216060000000782135PA721896cosignataire
16060000000918L16/dossiers161606000000078216060000000782136PA722202cosignataire
16060000000919L16/dossiers161606000000078216060000000782137PA795998cosignataire
16060000000920L16/dossiers161606000000078216060000000782138PA774962cosignataire
16060000000921L16/dossiers161606000000078216060000000782139PA335612cosignataire
16060000000922L16/dossiers161606000000078216060000000782140PA795184cosignataire
16060000000923L16/dossiers161606000000078216060000000782141PA796010cosignataire
16060000000924L16/dossiers161606000000078216060000000782142PA793174cosignataire
16060000000925L16/dossiers161606000000078216060000000782143PA795820cosignataire
16060000000926L16/dossiers161606000000078216060000000782144PA721270cosignataire
16060000000927L16/dossiers161606000000078216060000000782145PA795876cosignataire
16060000000928L16/dossiers161606000000078216060000000782146PA720692cosignataire
16060000000929L16/dossiers161606000000078216060000000782147PA605745cosignataire
16060000000930L16/dossiers161606000000078216060000000782148PA794650cosignataire
16060000000931L16/dossiers161606000000078216060000000782149PA722110cosignataire
16060000000932L16/dossiers161606000000078216060000000782150PA720992cosignataire
16060000000934L16/dossiers1616060000000933160600000009331PA720614auteur