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
17060000000627L17/dossiers1717060000000626170600000006261PA643210auteur
17060000000629L17/dossiers1717060000000628170600000006281PA643210auteur
17060000000631L17/dossiers1717060000000630170600000006301PA643210auteur
17060000000633L17/dossiers1717060000000632170600000006321PA643210auteur
17060000000635L17/dossiers1717060000000634170600000006341PA643210auteur
17060000000637L17/dossiers1717060000000636170600000006361PA643210auteur
17060000000639L17/dossiers1717060000000638170600000006381PA643210auteur
17060000000641L17/dossiers1717060000000640170600000006401PA643210auteur
17060000000646L17/dossiers1717060000000645170600000006451PA643210auteur
17060000000651L17/dossiers1717060000000650170600000006501PA719930auteur
17060000000652L17/dossiers1717060000000650170600000006502PA720892cosignataire
17060000000653L17/dossiers1717060000000650170600000006503PA794008cosignataire
17060000000654L17/dossiers1717060000000650170600000006504PA267306cosignataire
17060000000655L17/dossiers1717060000000650170600000006505PA840665cosignataire
17060000000656L17/dossiers1717060000000650170600000006506PA642764cosignataire
17060000000657L17/dossiers1717060000000650170600000006507PA643143cosignataire
17060000000658L17/dossiers1717060000000650170600000006508PA840829cosignataire
17060000000659L17/dossiers1717060000000650170600000006509PA342415cosignataire
17060000000660L17/dossiers17170600000006501706000000065010PA606793cosignataire
17060000000661L17/dossiers17170600000006501706000000065011PA842211cosignataire
17060000000662L17/dossiers17170600000006501706000000065012PA841315cosignataire
17060000000663L17/dossiers17170600000006501706000000065013PA794094cosignataire
17060000000664L17/dossiers17170600000006501706000000065014PA793624cosignataire
17060000000665L17/dossiers17170600000006501706000000065015PA795762cosignataire
17060000000666L17/dossiers17170600000006501706000000065016PA608264cosignataire
17060000000667L17/dossiers17170600000006501706000000065017PA840903cosignataire
17060000000668L17/dossiers17170600000006501706000000065018PA841295cosignataire
17060000000669L17/dossiers17170600000006501706000000065019PA1008cosignataire
17060000000670L17/dossiers17170600000006501706000000065020PA793394cosignataire
17060000000671L17/dossiers17170600000006501706000000065021PA795430cosignataire
17060000000672L17/dossiers17170600000006501706000000065022PA841919cosignataire
17060000000673L17/dossiers17170600000006501706000000065023PA606573cosignataire
17060000000674L17/dossiers17170600000006501706000000065024PA841633cosignataire
17060000000675L17/dossiers17170600000006501706000000065025PA794854cosignataire
17060000000676L17/dossiers17170600000006501706000000065026PA842195cosignataire
17060000000677L17/dossiers17170600000006501706000000065027PA609332cosignataire
17060000000678L17/dossiers17170600000006501706000000065028PA841665cosignataire
17060000000679L17/dossiers17170600000006501706000000065029PA333285cosignataire
17060000000680L17/dossiers17170600000006501706000000065030PA840939cosignataire
17060000000681L17/dossiers17170600000006501706000000065031PA841539cosignataire
17060000000682L17/dossiers17170600000006501706000000065032PA331973cosignataire
17060000000683L17/dossiers17170600000006501706000000065033PA840171cosignataire
17060000000684L17/dossiers17170600000006501706000000065034PA1567cosignataire
17060000000685L17/dossiers17170600000006501706000000065035PA841471cosignataire
17060000000686L17/dossiers17170600000006501706000000065036PA842263cosignataire
17060000000687L17/dossiers17170600000006501706000000065037PA841813cosignataire
17060000000688L17/dossiers17170600000006501706000000065038PA841853cosignataire
17060000000689L17/dossiers17170600000006501706000000065039PA1654cosignataire
17060000000690L17/dossiers17170600000006501706000000065040PA643192cosignataire
17060000000691L17/dossiers17170600000006501706000000065041PA335054cosignataire