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
17060000001554L17/dossiers17170600000015391706000000153915PA793772cosignataire
17060000001555L17/dossiers17170600000015391706000000153916PA795616cosignataire
17060000001556L17/dossiers17170600000015391706000000153917PA793444cosignataire
17060000001557L17/dossiers17170600000015391706000000153918PA841885cosignataire
17060000001558L17/dossiers17170600000015391706000000153919PA794938cosignataire
17060000001559L17/dossiers17170600000015391706000000153920PA720838cosignataire
17060000001560L17/dossiers17170600000015391706000000153921PA795318cosignataire
17060000001561L17/dossiers17170600000015391706000000153922PA841023cosignataire
17060000001562L17/dossiers17170600000015391706000000153923PA796090cosignataire
17060000001563L17/dossiers17170600000015391706000000153924PA793912cosignataire
17060000001564L17/dossiers17170600000015391706000000153925PA795868cosignataire
17060000001565L17/dossiers17170600000015391706000000153926PA842187cosignataire
17060000001566L17/dossiers17170600000015391706000000153927PA842037cosignataire
17060000001567L17/dossiers17170600000015391706000000153928PA791812cosignataire
17060000001568L17/dossiers17170600000015391706000000153929PA793736cosignataire
17060000001569L17/dossiers17170600000015391706000000153930PA721202cosignataire
17060000001570L17/dossiers17170600000015391706000000153931PA721210cosignataire
17060000001571L17/dossiers17170600000015391706000000153932PA795136cosignataire
17060000001572L17/dossiers17170600000015391706000000153933PA793452cosignataire
17060000001573L17/dossiers17170600000015391706000000153934PA793464cosignataire
17060000001574L17/dossiers17170600000015391706000000153935PA842155cosignataire
17060000001575L17/dossiers17170600000015391706000000153936PA795200cosignataire
17060000001576L17/dossiers17170600000015391706000000153937PA795844cosignataire
17060000001577L17/dossiers17170600000015391706000000153938PA721896cosignataire
17060000001578L17/dossiers17170600000015391706000000153939PA841251cosignataire
17060000001579L17/dossiers17170600000015391706000000153940PA794786cosignataire
17060000001580L17/dossiers17170600000015391706000000153941PA794870cosignataire
17060000001581L17/dossiers17170600000015391706000000153942PA796070cosignataire
17060000001582L17/dossiers17170600000015391706000000153943PA795010cosignataire
17060000001583L17/dossiers17170600000015391706000000153944PA795310cosignataire
17060000001584L17/dossiers17170600000015391706000000153945PA794478cosignataire
17060000001585L17/dossiers17170600000015391706000000153946PA841947cosignataire
17060000001586L17/dossiers17170600000015391706000000153947PA794082cosignataire
17060000001587L17/dossiers17170600000015391706000000153948PA795998cosignataire
17060000001588L17/dossiers17170600000015391706000000153949PA794130cosignataire
17060000001589L17/dossiers17170600000015391706000000153950PA720846cosignataire
17060000001590L17/dossiers17170600000015391706000000153951PA841729cosignataire
17060000001591L17/dossiers17170600000015391706000000153952PA795516cosignataire
17060000001592L17/dossiers17170600000015391706000000153953PA795672cosignataire
17060000001593L17/dossiers17170600000015391706000000153954PA795746cosignataire
17060000001594L17/dossiers17170600000015391706000000153955PA774962cosignataire
17060000001595L17/dossiers17170600000015391706000000153956PA795108cosignataire
17060000001596L17/dossiers17170600000015391706000000153957PA841515cosignataire
17060000001597L17/dossiers17170600000015391706000000153958PA335612cosignataire
17060000001598L17/dossiers17170600000015391706000000153959PA795298cosignataire
17060000001599L17/dossiers17170600000015391706000000153960PA791824cosignataire
17060000001600L17/dossiers17170600000015391706000000153961PA842029cosignataire
17060000001601L17/dossiers17170600000015391706000000153962PA793532cosignataire
17060000001602L17/dossiers17170600000015391706000000153963PA795636cosignataire
17060000001603L17/dossiers17170600000015391706000000153964PA796010cosignataire