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
17060000001198L17/dossiers17170600000011751706000000117523PA793146cosignataire
17060000001199L17/dossiers17170600000011751706000000117524PA840135cosignataire
17060000001200L17/dossiers17170600000011751706000000117525PA842073cosignataire
17060000001201L17/dossiers17170600000011751706000000117526PA841761cosignataire
17060000001202L17/dossiers17170600000011751706000000117527PA841621cosignataire
17060000001203L17/dossiers17170600000011751706000000117528PA795778cosignataire
17060000001204L17/dossiers17170600000011751706000000117529PA841749cosignataire
17060000001205L17/dossiers17170600000011751706000000117530PA840869cosignataire
17060000001206L17/dossiers17170600000011751706000000117531PA795912cosignataire
17060000001207L17/dossiers17170600000011751706000000117532PA841837cosignataire
17060000001208L17/dossiers17170600000011751706000000117533PA840857cosignataire
17060000001209L17/dossiers17170600000011751706000000117534PA793290cosignataire
17060000001210L17/dossiers17170600000011751706000000117535PA841873cosignataire
17060000001211L17/dossiers17170600000011751706000000117536PA721932cosignataire
17060000001212L17/dossiers17170600000011751706000000117537PA794590cosignataire
17060000001213L17/dossiers17170600000011751706000000117538PA794530cosignataire
17060000001214L17/dossiers17170600000011751706000000117539PA840837cosignataire
17060000001215L17/dossiers17170600000011751706000000117540PA841825cosignataire
17060000001216L17/dossiers17170600000011751706000000117541PA794770cosignataire
17060000001217L17/dossiers17170600000011751706000000117542PA719436cosignataire
17060000001218L17/dossiers17170600000011751706000000117543PA793354cosignataire
17060000001219L17/dossiers17170600000011751706000000117544PA795786cosignataire
17060000001220L17/dossiers17170600000011751706000000117545PA794322cosignataire
17060000001221L17/dossiers17170600000011751706000000117546PA793852cosignataire
17060000001222L17/dossiers17170600000011751706000000117547PA840915cosignataire
17060000001223L17/dossiers17170600000011751706000000117548PA793696cosignataire
17060000001224L17/dossiers17170600000011751706000000117549PA795552cosignataire
17060000001225L17/dossiers17170600000011751706000000117550PA794670cosignataire
17060000001226L17/dossiers17170600000011751706000000117551PA794954cosignataire
17060000001227L17/dossiers17170600000011751706000000117552PA842255cosignataire
17060000001228L17/dossiers17170600000011751706000000117553PA793382cosignataire
17060000001229L17/dossiers17170600000011751706000000117554PA794502cosignataire
17060000001230L17/dossiers17170600000011751706000000117555PA841553cosignataire
17060000001231L17/dossiers17170600000011751706000000117556PA840781cosignataire
17060000001232L17/dossiers17170600000011751706000000117557PA841479cosignataire
17060000001233L17/dossiers17170600000011751706000000117558PA841575cosignataire
17060000001235L17/dossiers1717060000001234170600000012341PA795778auteur
17060000001236L17/dossiers1717060000001234170600000012342PA796118cosignataire
17060000001237L17/dossiers1717060000001234170600000012343PA842001cosignataire
17060000001238L17/dossiers1717060000001234170600000012344PA720822cosignataire
17060000001239L17/dossiers1717060000001234170600000012345PA794886cosignataire
17060000001240L17/dossiers1717060000001234170600000012346PA796042cosignataire
17060000001241L17/dossiers1717060000001234170600000012347PA841487cosignataire
17060000001242L17/dossiers1717060000001234170600000012348PA793182cosignataire
17060000001243L17/dossiers1717060000001234170600000012349PA840159cosignataire
17060000001244L17/dossiers17170600000012341706000000123410PA793246cosignataire
17060000001245L17/dossiers17170600000012341706000000123411PA840143cosignataire
17060000001246L17/dossiers17170600000012341706000000123412PA840801cosignataire
17060000001247L17/dossiers17170600000012341706000000123413PA794678cosignataire
17060000001248L17/dossiers17170600000012341706000000123414PA841139cosignataire