AN · données ouvertes
Explorateur / dossiers

dossiers.document_auteur

Chemin document.auteurs.auteur · présence : L17 100 %, L16 100 %, L15 100 %, L14 100 %

59 600 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
17060000108374L17/dossiers1717060000108373170600001083731PA719080rapporteur
17060000108375L17/dossiers1717060000108373170600001083732PO419610
17060000108382L17/dossiers1717060000108376170600001083761PA795278rapporteur
17060000108383L17/dossiers1717060000108376170600001083762PA720190rapporteur
17060000108384L17/dossiers1717060000108376170600001083763PA841367rapporteur
17060000108385L17/dossiers1717060000108376170600001083764PO419604
17060000108393L17/dossiers1717060000108386170600001083861PA841243rapporteur
17060000108394L17/dossiers1717060000108386170600001083862PO872476
17060000108396L17/dossiers1717060000108395170600001083951PA840889rapporteur
17060000108397L17/dossiers1717060000108395170600001083952PO872098
17060000108403L17/dossiers1717060000108398170600001083981PA340343rapporteur
17060000108404L17/dossiers1717060000108398170600001083982PA340343rapporteur
17060000108405L17/dossiers1717060000108398170600001083983PO59051
17060000108407L17/dossiers1717060000108406170600001084061PA721296rapporteur
17060000108408L17/dossiers1717060000108406170600001084062PA335054rapporteur
17060000108409L17/dossiers1717060000108406170600001084063PO59051
17060000108417L17/dossiers1717060000108410170600001084101PA720354rapporteur
17060000108418L17/dossiers1717060000108410170600001084102PO402232
17060000108423L17/dossiers1717060000108419170600001084191PA608416rapporteur
17060000108424L17/dossiers1717060000108419170600001084192PO420120
17060000108429L17/dossiers1717060000108425170600001084251PA345722rapporteur
17060000108430L17/dossiers1717060000108425170600001084252PO59047
17060000108432L17/dossiers1717060000108431170600001084311PA335054rapporteur
17060000108433L17/dossiers1717060000108431170600001084312PO415287
17060000108435L17/dossiers1717060000108434170600001084341PA346782rapporteur
17060000108436L17/dossiers1717060000108434170600001084342PO876895
17060000108438L17/dossiers1717060000108437170600001084371PA346782rapporteur
17060000108439L17/dossiers1717060000108437170600001084372PO59048
17060000108441L17/dossiers1717060000108440170600001084401PA840955rapporteur
17060000108442L17/dossiers1717060000108440170600001084402PO59047
17060000108444L17/dossiers1717060000108443170600001084431PA335612rapporteur
17060000108445L17/dossiers1717060000108443170600001084432PO59047
17060000108447L17/dossiers1717060000108446170600001084461PA718784rapporteur
17060000108448L17/dossiers1717060000108446170600001084462PO415287
17060000108450L17/dossiers1717060000108449170600001084491PA842311rapporteur
17060000108451L17/dossiers1717060000108449170600001084492PO59051
17060000108459L17/dossiers1717060000108452170600001084521PA346782rapporteur général
17060000108460L17/dossiers1717060000108452170600001084522PO59048
17060000108465L17/dossiers1717060000108461170600001084611PA642847rapporteur
17060000108466L17/dossiers1717060000108461170600001084612PO420120
17060000108468L17/dossiers1717060000108467170600001084671PA840979rapporteur
17060000108469L17/dossiers1717060000108467170600001084672PO59051
17060000108471L17/dossiers1717060000108470170600001084701PA719968rapporteur
17060000108472L17/dossiers1717060000108470170600001084702PO420120
17060000108474L17/dossiers1717060000108473170600001084731PA608416rapporteur
17060000108475L17/dossiers1717060000108473170600001084732PO59051
17060000108480L17/dossiers1717060000108476170600001084761PA842121rapporteur
17060000108481L17/dossiers1717060000108476170600001084762PO419865
17060000108483L17/dossiers1717060000108482170600001084821PA774954rapporteur
17060000108484L17/dossiers1717060000108482170600001084822PO420120