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
17060000001401L17/dossiers17170600000013541706000000135447PA793912cosignataire
17060000001402L17/dossiers17170600000013541706000000135448PA842187cosignataire
17060000001403L17/dossiers17170600000013541706000000135449PA842037cosignataire
17060000001404L17/dossiers17170600000013541706000000135450PA791812cosignataire
17060000001405L17/dossiers17170600000013541706000000135451PA795136cosignataire
17060000001406L17/dossiers17170600000013541706000000135452PA793464cosignataire
17060000001407L17/dossiers17170600000013541706000000135453PA842155cosignataire
17060000001408L17/dossiers17170600000013541706000000135454PA795200cosignataire
17060000001409L17/dossiers17170600000013541706000000135455PA795844cosignataire
17060000001410L17/dossiers17170600000013541706000000135456PA841251cosignataire
17060000001411L17/dossiers17170600000013541706000000135457PA793744cosignataire
17060000001412L17/dossiers17170600000013541706000000135458PA841633cosignataire
17060000001414L17/dossiers1717060000001413170600000014131PA720892auteur
17060000001415L17/dossiers1717060000001413170600000014132PA793262cosignataire
17060000001416L17/dossiers1717060000001413170600000014133PA794906cosignataire
17060000001417L17/dossiers1717060000001413170600000014134PA794138cosignataire
17060000001418L17/dossiers1717060000001413170600000014135PA795588cosignataire
17060000001419L17/dossiers1717060000001413170600000014136PA795084cosignataire
17060000001420L17/dossiers1717060000001413170600000014137PA842105cosignataire
17060000001421L17/dossiers1717060000001413170600000014138PA841657cosignataire
17060000001422L17/dossiers1717060000001413170600000014139PA720430cosignataire
17060000001423L17/dossiers17170600000014131706000000141310PA793772cosignataire
17060000001424L17/dossiers17170600000014131706000000141311PA795616cosignataire
17060000001425L17/dossiers17170600000014131706000000141312PA793444cosignataire
17060000001426L17/dossiers17170600000014131706000000141313PA794938cosignataire
17060000001427L17/dossiers17170600000014131706000000141314PA795318cosignataire
17060000001428L17/dossiers17170600000014131706000000141315PA841023cosignataire
17060000001429L17/dossiers17170600000014131706000000141316PA793912cosignataire
17060000001430L17/dossiers17170600000014131706000000141317PA842187cosignataire
17060000001431L17/dossiers17170600000014131706000000141318PA842037cosignataire
17060000001432L17/dossiers17170600000014131706000000141319PA791812cosignataire
17060000001433L17/dossiers17170600000014131706000000141320PA793736cosignataire
17060000001434L17/dossiers17170600000014131706000000141321PA721202cosignataire
17060000001435L17/dossiers17170600000014131706000000141322PA795136cosignataire
17060000001436L17/dossiers17170600000014131706000000141323PA793464cosignataire
17060000001437L17/dossiers17170600000014131706000000141324PA842155cosignataire
17060000001438L17/dossiers17170600000014131706000000141325PA795200cosignataire
17060000001439L17/dossiers17170600000014131706000000141326PA795844cosignataire
17060000001440L17/dossiers17170600000014131706000000141327PA841251cosignataire
17060000001441L17/dossiers17170600000014131706000000141328PA794786cosignataire
17060000001442L17/dossiers17170600000014131706000000141329PA794870cosignataire
17060000001443L17/dossiers17170600000014131706000000141330PA796070cosignataire
17060000001444L17/dossiers17170600000014131706000000141331PA794478cosignataire
17060000001445L17/dossiers17170600000014131706000000141332PA841947cosignataire
17060000001446L17/dossiers17170600000014131706000000141333PA794082cosignataire
17060000001447L17/dossiers17170600000014131706000000141334PA794130cosignataire
17060000001448L17/dossiers17170600000014131706000000141335PA720846cosignataire
17060000001449L17/dossiers17170600000014131706000000141336PA841729cosignataire
17060000001450L17/dossiers17170600000014131706000000141337PA795516cosignataire
17060000001451L17/dossiers17170600000014131706000000141338PA841515cosignataire