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
17060000002512L17/dossiers17170600000024151706000000241597PA796018cosignataire
17060000002513L17/dossiers17170600000024151706000000241598PA736201cosignataire
17060000002514L17/dossiers17170600000024151706000000241599PA841713cosignataire
17060000002515L17/dossiers171706000000241517060000002415100PA793948cosignataire
17060000002516L17/dossiers171706000000241517060000002415101PA796106cosignataire
17060000002517L17/dossiers171706000000241517060000002415102PA720838cosignataire
17060000002518L17/dossiers171706000000241517060000002415103PA794710cosignataire
17060000002519L17/dossiers171706000000241517060000002415104PA795868cosignataire
17060000002520L17/dossiers171706000000241517060000002415105PA721896cosignataire
17060000002521L17/dossiers171706000000241517060000002415106PA795998cosignataire
17060000002522L17/dossiers171706000000241517060000002415107PA774962cosignataire
17060000002523L17/dossiers171706000000241517060000002415108PA335612cosignataire
17060000002524L17/dossiers171706000000241517060000002415109PA796010cosignataire
17060000002525L17/dossiers171706000000241517060000002415110PA795820cosignataire
17060000002526L17/dossiers171706000000241517060000002415111PA795876cosignataire
17060000002527L17/dossiers171706000000241517060000002415112PA605745cosignataire
17060000002528L17/dossiers171706000000241517060000002415113PA842299cosignataire
17060000002530L17/dossiers1717060000002529170600000025291PA720614auteur
17060000002531L17/dossiers1717060000002529170600000025292PA330240cosignataire
17060000002532L17/dossiers1717060000002529170600000025293PA793432cosignataire
17060000002533L17/dossiers1717060000002529170600000025294PA841495cosignataire
17060000002534L17/dossiers1717060000002529170600000025295PA794562cosignataire
17060000002535L17/dossiers1717060000002529170600000025296PA842279cosignataire
17060000002536L17/dossiers1717060000002529170600000025297PA793158cosignataire
17060000002537L17/dossiers1717060000002529170600000025298PA794434cosignataire
17060000002538L17/dossiers1717060000002529170600000025299PA841645cosignataire
17060000002539L17/dossiers17170600000025291706000000252910PA842001cosignataire
17060000002540L17/dossiers17170600000025291706000000252911PA720822cosignataire
17060000002541L17/dossiers17170600000025291706000000252912PA794886cosignataire
17060000002542L17/dossiers17170600000025291706000000252913PA796042cosignataire
17060000002543L17/dossiers17170600000025291706000000252914PA841487cosignataire
17060000002544L17/dossiers17170600000025291706000000252915PA841131cosignataire
17060000002545L17/dossiers17170600000025291706000000252916PA793182cosignataire
17060000002546L17/dossiers17170600000025291706000000252917PA793134cosignataire
17060000002547L17/dossiers17170600000025291706000000252918PA840075cosignataire
17060000002548L17/dossiers17170600000025291706000000252919PA720468cosignataire
17060000002549L17/dossiers17170600000025291706000000252920PA840159cosignataire
17060000002550L17/dossiers17170600000025291706000000252921PA793548cosignataire
17060000002551L17/dossiers17170600000025291706000000252922PA795644cosignataire
17060000002552L17/dossiers17170600000025291706000000252923PA642988cosignataire
17060000002553L17/dossiers17170600000025291706000000252924PA793166cosignataire
17060000002554L17/dossiers17170600000025291706000000252925PA794762cosignataire
17060000002555L17/dossiers17170600000025291706000000252926PA793146cosignataire
17060000002556L17/dossiers17170600000025291706000000252927PA840135cosignataire
17060000002557L17/dossiers17170600000025291706000000252928PA842073cosignataire
17060000002558L17/dossiers17170600000025291706000000252929PA793246cosignataire
17060000002559L17/dossiers17170600000025291706000000252930PA840143cosignataire
17060000002560L17/dossiers17170600000025291706000000252931PA794678cosignataire
17060000002561L17/dossiers17170600000025291706000000252932PA793892cosignataire
17060000002562L17/dossiers17170600000025291706000000252933PA841737cosignataire