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
17060000002058L17/dossiers17170600000019651706000000196593PA794322cosignataire
17060000002059L17/dossiers17170600000019651706000000196594PA793852cosignataire
17060000002060L17/dossiers17170600000019651706000000196595PA840915cosignataire
17060000002061L17/dossiers17170600000019651706000000196596PA793696cosignataire
17060000002062L17/dossiers17170600000019651706000000196597PA795552cosignataire
17060000002063L17/dossiers17170600000019651706000000196598PA794670cosignataire
17060000002064L17/dossiers17170600000019651706000000196599PA841199cosignataire
17060000002065L17/dossiers171706000000196517060000001965100PA794582cosignataire
17060000002066L17/dossiers171706000000196517060000001965101PA793656cosignataire
17060000002067L17/dossiers171706000000196517060000001965102PA795966cosignataire
17060000002068L17/dossiers171706000000196517060000001965103PA793230cosignataire
17060000002069L17/dossiers171706000000196517060000001965104PA793254cosignataire
17060000002070L17/dossiers171706000000196517060000001965105PA841955cosignataire
17060000002071L17/dossiers171706000000196517060000001965106PA841981cosignataire
17060000002072L17/dossiers171706000000196517060000001965107PA842227cosignataire
17060000002073L17/dossiers171706000000196517060000001965108PA794442cosignataire
17060000002074L17/dossiers171706000000196517060000001965109PA795410cosignataire
17060000002075L17/dossiers171706000000196517060000001965110PA842097cosignataire
17060000002076L17/dossiers171706000000196517060000001965111PA794894cosignataire
17060000002077L17/dossiers171706000000196517060000001965112PA794570cosignataire
17060000002078L17/dossiers171706000000196517060000001965113PA794954cosignataire
17060000002079L17/dossiers171706000000196517060000001965114PA841777cosignataire
17060000002080L17/dossiers171706000000196517060000001965115PA796050cosignataire
17060000002081L17/dossiers171706000000196517060000001965116PA842255cosignataire
17060000002082L17/dossiers171706000000196517060000001965117PA793382cosignataire
17060000002083L17/dossiers171706000000196517060000001965118PA795778cosignataire
17060000002084L17/dossiers171706000000196517060000001965119PA794502cosignataire
17060000002085L17/dossiers171706000000196517060000001965120PA841553cosignataire
17060000002086L17/dossiers171706000000196517060000001965121PA793298cosignataire
17060000002087L17/dossiers171706000000196517060000001965122PA840781cosignataire
17060000002088L17/dossiers171706000000196517060000001965123PA794946cosignataire
17060000002089L17/dossiers171706000000196517060000001965124PA841575cosignataire
17060000002090L17/dossiers171706000000196517060000001965125PA841479cosignataire
17060000002091L17/dossiers171706000000196517060000001965126PA841067cosignataire
17060000002092L17/dossiers171706000000196517060000001965127PA841207cosignataire
17060000002093L17/dossiers171706000000196517060000001965128PA267561cosignataire
17060000002094L17/dossiers171706000000196517060000001965129PA840889cosignataire
17060000002095L17/dossiers171706000000196517060000001965130PA840701cosignataire
17060000002096L17/dossiers171706000000196517060000001965131PA840721cosignataire
17060000002097L17/dossiers171706000000196517060000001965132PA793322cosignataire
17060000002098L17/dossiers171706000000196517060000001965133PA840773cosignataire
17060000002099L17/dossiers171706000000196517060000001965134PA840983cosignataire
17060000002100L17/dossiers171706000000196517060000001965135PA841183cosignataire
17060000002101L17/dossiers171706000000196517060000001965136PA841395cosignataire
17060000002102L17/dossiers171706000000196517060000001965137PA841769cosignataire
17060000002103L17/dossiers171706000000196517060000001965138PA840657cosignataire
17060000002104L17/dossiers171706000000196517060000001965139PA840685cosignataire
17060000002105L17/dossiers171706000000196517060000001965140PA840809cosignataire
17060000002107L17/dossiers1717060000002106170600000021061PA720892auteur
17060000002108L17/dossiers1717060000002106170600000021062PA795228cosignataire