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
17060000075158L17/dossiers17170600000751241706000007512434PA227094auteur
17060000075159L17/dossiers17170600000751241706000007512435PA404656auteur
17060000075160L17/dossiers17170600000751241706000007512436PA267328auteur
17060000075161L17/dossiers17170600000751241706000007512437PA345785auteur
17060000075162L17/dossiers17170600000751241706000007512438PA313924auteur
17060000075163L17/dossiers17170600000751241706000007512439PA569auteur
17060000075164L17/dossiers17170600000751241706000007512440PA711156auteur
17060000075165L17/dossiers17170600000751241706000007512441PA736213auteur
17060000075166L17/dossiers17170600000751241706000007512442PA703527auteur
17060000075167L17/dossiers17170600000751241706000007512443PA736218auteur
17060000075168L17/dossiers17170600000751241706000007512444PA2197auteur
17060000075169L17/dossiers17170600000751241706000007512445PA703513auteur
17060000075170L17/dossiers17170600000751241706000007512446PA1344auteur
17060000075171L17/dossiers17170600000751241706000007512447PA703521auteur
17060000075172L17/dossiers17170600000751241706000007512448PA736205auteur
17060000075173L17/dossiers17170600000751241706000007512449PA758431auteur
17060000075174L17/dossiers17170600000751241706000007512450PA736166auteur
17060000075175L17/dossiers17170600000751241706000007512451PA736167auteur
17060000075176L17/dossiers17170600000751241706000007512452PA415462auteur
17060000075178L17/dossiers1717060000075177170600000751771PO78718
17060000075180L17/dossiers1717060000075179170600000751791PO78718
17060000075182L17/dossiers1717060000075181170600000751811PO78718
17060000075184L17/dossiers1717060000075183170600000751831PO78718
17060000075186L17/dossiers1717060000075185170600000751851PO78718
17060000075188L17/dossiers1717060000075187170600000751871PO78718
17060000075190L17/dossiers1717060000075189170600000751891PO78718
17060000075192L17/dossiers1717060000075191170600000751911PO78718
17060000075194L17/dossiers1717060000075193170600000751931PO78718
17060000075196L17/dossiers1717060000075195170600000751951PO78718
17060000075198L17/dossiers1717060000075197170600000751971PO78718
17060000075200L17/dossiers1717060000075199170600000751991PO78718
17060000075202L17/dossiers1717060000075201170600000752011PO78718
17060000075204L17/dossiers1717060000075203170600000752031PO78718
17060000075206L17/dossiers1717060000075205170600000752051PO78718
17060000075208L17/dossiers1717060000075207170600000752071PA703527rapporteur
17060000075209L17/dossiers1717060000075207170600000752072PO211494
17060000075211L17/dossiers1717060000075210170600000752101PA736213rapporteur
17060000075212L17/dossiers1717060000075210170600000752102PO211495
17060000075214L17/dossiers1717060000075213170600000752131PA736216rapporteur
17060000075215L17/dossiers1717060000075213170600000752132PO211490
17060000075217L17/dossiers1717060000075216170600000752161PA569rapporteur
17060000075218L17/dossiers1717060000075216170600000752162PO211495
17060000075220L17/dossiers1717060000075219170600000752191PA703510rapporteur
17060000075221L17/dossiers1717060000075219170600000752192PO211495
17060000075223L17/dossiers1717060000075222170600000752221PA703522rapporteur
17060000075224L17/dossiers1717060000075222170600000752222PO211495
17060000075226L17/dossiers1717060000075225170600000752251PA267081rapporteur
17060000075227L17/dossiers1717060000075225170600000752252PO211493
17060000075229L17/dossiers1717060000075228170600000752281PA643211rapporteur
17060000075230L17/dossiers1717060000075228170600000752282PA758716rapporteur