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
17060000002815L17/dossiers17170600000027481706000000274867PA793616cosignataire
17060000002816L17/dossiers17170600000027481706000000274868PA794322cosignataire
17060000002817L17/dossiers17170600000027481706000000274869PA793852cosignataire
17060000002818L17/dossiers17170600000027481706000000274870PA840915cosignataire
17060000002819L17/dossiers17170600000027481706000000274871PA793696cosignataire
17060000002820L17/dossiers17170600000027481706000000274872PA794670cosignataire
17060000002821L17/dossiers17170600000027481706000000274873PA841199cosignataire
17060000002822L17/dossiers17170600000027481706000000274874PA794582cosignataire
17060000002823L17/dossiers17170600000027481706000000274875PA793656cosignataire
17060000002824L17/dossiers17170600000027481706000000274876PA795966cosignataire
17060000002825L17/dossiers17170600000027481706000000274877PA793254cosignataire
17060000002826L17/dossiers17170600000027481706000000274878PA841955cosignataire
17060000002827L17/dossiers17170600000027481706000000274879PA841981cosignataire
17060000002828L17/dossiers17170600000027481706000000274880PA842227cosignataire
17060000002829L17/dossiers17170600000027481706000000274881PA794442cosignataire
17060000002830L17/dossiers17170600000027481706000000274882PA795410cosignataire
17060000002831L17/dossiers17170600000027481706000000274883PA842097cosignataire
17060000002832L17/dossiers17170600000027481706000000274884PA794570cosignataire
17060000002833L17/dossiers17170600000027481706000000274885PA794954cosignataire
17060000002834L17/dossiers17170600000027481706000000274886PA842255cosignataire
17060000002835L17/dossiers17170600000027481706000000274887PA793382cosignataire
17060000002836L17/dossiers17170600000027481706000000274888PA795778cosignataire
17060000002837L17/dossiers17170600000027481706000000274889PA794502cosignataire
17060000002838L17/dossiers17170600000027481706000000274890PA841553cosignataire
17060000002839L17/dossiers17170600000027481706000000274891PA793298cosignataire
17060000002840L17/dossiers17170600000027481706000000274892PA840781cosignataire
17060000002841L17/dossiers17170600000027481706000000274893PA841575cosignataire
17060000002842L17/dossiers17170600000027481706000000274894PA841479cosignataire
17060000002843L17/dossiers17170600000027481706000000274895PA840889cosignataire
17060000002844L17/dossiers17170600000027481706000000274896PA841973cosignataire
17060000002845L17/dossiers17170600000027481706000000274897PA840701cosignataire
17060000002846L17/dossiers17170600000027481706000000274898PA840721cosignataire
17060000002847L17/dossiers17170600000027481706000000274899PA793322cosignataire
17060000002848L17/dossiers171706000000274817060000002748100PA840773cosignataire
17060000002849L17/dossiers171706000000274817060000002748101PA840983cosignataire
17060000002850L17/dossiers171706000000274817060000002748102PA841183cosignataire
17060000002851L17/dossiers171706000000274817060000002748103PA841395cosignataire
17060000002852L17/dossiers171706000000274817060000002748104PA841769cosignataire
17060000002853L17/dossiers171706000000274817060000002748105PA840657cosignataire
17060000002854L17/dossiers171706000000274817060000002748106PA840809cosignataire
17060000002856L17/dossiers1717060000002855170600000028551PA294auteur
17060000002864L17/dossiers1717060000002863170600000028631PO230434
17060000002867L17/dossiers1717060000002866170600000028661PO230434
17060000002870L17/dossiers1717060000002869170600000028691PO230434
17060000002873L17/dossiers1717060000002872170600000028721PO230434
17060000002876L17/dossiers1717060000002875170600000028751PO44313
17060000002879L17/dossiers1717060000002878170600000028781PO230434
17060000002882L17/dossiers1717060000002881170600000028811PO230434
17060000002885L17/dossiers1717060000002884170600000028841PO230434
17060000002888L17/dossiers1717060000002887170600000028871PO230434