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
17060000002765L17/dossiers17170600000027481706000000274817PA793182cosignataire
17060000002766L17/dossiers17170600000027481706000000274818PA793134cosignataire
17060000002767L17/dossiers17170600000027481706000000274819PA840075cosignataire
17060000002768L17/dossiers17170600000027481706000000274820PA720468cosignataire
17060000002769L17/dossiers17170600000027481706000000274821PA840159cosignataire
17060000002770L17/dossiers17170600000027481706000000274822PA793548cosignataire
17060000002771L17/dossiers17170600000027481706000000274823PA795644cosignataire
17060000002772L17/dossiers17170600000027481706000000274824PA642988cosignataire
17060000002773L17/dossiers17170600000027481706000000274825PA793166cosignataire
17060000002774L17/dossiers17170600000027481706000000274826PA794762cosignataire
17060000002775L17/dossiers17170600000027481706000000274827PA793146cosignataire
17060000002776L17/dossiers17170600000027481706000000274828PA840135cosignataire
17060000002777L17/dossiers17170600000027481706000000274829PA842073cosignataire
17060000002778L17/dossiers17170600000027481706000000274830PA793246cosignataire
17060000002779L17/dossiers17170600000027481706000000274831PA840143cosignataire
17060000002780L17/dossiers17170600000027481706000000274832PA794678cosignataire
17060000002781L17/dossiers17170600000027481706000000274833PA793892cosignataire
17060000002782L17/dossiers17170600000027481706000000274834PA841737cosignataire
17060000002783L17/dossiers17170600000027481706000000274835PA796034cosignataire
17060000002784L17/dossiers17170600000027481706000000274836PA793832cosignataire
17060000002785L17/dossiers17170600000027481706000000274837PA793102cosignataire
17060000002786L17/dossiers17170600000027481706000000274838PA841605cosignataire
17060000002787L17/dossiers17170600000027481706000000274839PA793362cosignataire
17060000002788L17/dossiers17170600000027481706000000274840PA794418cosignataire
17060000002789L17/dossiers17170600000027481706000000274841PA793592cosignataire
17060000002790L17/dossiers17170600000027481706000000274842PA840757cosignataire
17060000002791L17/dossiers17170600000027481706000000274843PA841451cosignataire
17060000002792L17/dossiers17170600000027481706000000274844PA794734cosignataire
17060000002793L17/dossiers17170600000027481706000000274845PA793218cosignataire
17060000002794L17/dossiers17170600000027481706000000274846PA795900cosignataire
17060000002795L17/dossiers17170600000027481706000000274847PA842085cosignataire
17060000002796L17/dossiers17170600000027481706000000274848PA794598cosignataire
17060000002797L17/dossiers17170600000027481706000000274849PA794030cosignataire
17060000002798L17/dossiers17170600000027481706000000274850PA841075cosignataire
17060000002799L17/dossiers17170600000027481706000000274851PA840869cosignataire
17060000002800L17/dossiers17170600000027481706000000274852PA794354cosignataire
17060000002801L17/dossiers17170600000027481706000000274853PA841837cosignataire
17060000002802L17/dossiers17170600000027481706000000274854PA840857cosignataire
17060000002803L17/dossiers17170600000027481706000000274855PA793290cosignataire
17060000002804L17/dossiers17170600000027481706000000274856PA793608cosignataire
17060000002805L17/dossiers17170600000027481706000000274857PA841873cosignataire
17060000002806L17/dossiers17170600000027481706000000274858PA793672cosignataire
17060000002807L17/dossiers17170600000027481706000000274859PA721932cosignataire
17060000002808L17/dossiers17170600000027481706000000274860PA795974cosignataire
17060000002809L17/dossiers17170600000027481706000000274861PA794590cosignataire
17060000002810L17/dossiers17170600000027481706000000274862PA841587cosignataire
17060000002811L17/dossiers17170600000027481706000000274863PA841563cosignataire
17060000002812L17/dossiers17170600000027481706000000274864PA794530cosignataire
17060000002813L17/dossiers17170600000027481706000000274865PA840837cosignataire
17060000002814L17/dossiers17170600000027481706000000274866PA794770cosignataire