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
17060000002109L17/dossiers1717060000002106170600000021063PA793262cosignataire
17060000002110L17/dossiers1717060000002106170600000021064PA794906cosignataire
17060000002111L17/dossiers1717060000002106170600000021065PA794138cosignataire
17060000002112L17/dossiers1717060000002106170600000021066PA795588cosignataire
17060000002113L17/dossiers1717060000002106170600000021067PA795084cosignataire
17060000002114L17/dossiers1717060000002106170600000021068PA842105cosignataire
17060000002115L17/dossiers1717060000002106170600000021069PA793780cosignataire
17060000002116L17/dossiers17170600000021061706000000210610PA588884cosignataire
17060000002117L17/dossiers17170600000021061706000000210611PA841657cosignataire
17060000002118L17/dossiers17170600000021061706000000210612PA796106cosignataire
17060000002119L17/dossiers17170600000021061706000000210613PA720430cosignataire
17060000002120L17/dossiers17170600000021061706000000210614PA793772cosignataire
17060000002121L17/dossiers17170600000021061706000000210615PA795616cosignataire
17060000002122L17/dossiers17170600000021061706000000210616PA795454cosignataire
17060000002123L17/dossiers17170600000021061706000000210617PA841885cosignataire
17060000002124L17/dossiers17170600000021061706000000210618PA793444cosignataire
17060000002125L17/dossiers17170600000021061706000000210619PA794938cosignataire
17060000002126L17/dossiers17170600000021061706000000210620PA720838cosignataire
17060000002127L17/dossiers17170600000021061706000000210621PA795318cosignataire
17060000002128L17/dossiers17170600000021061706000000210622PA841023cosignataire
17060000002129L17/dossiers17170600000021061706000000210623PA796090cosignataire
17060000002130L17/dossiers17170600000021061706000000210624PA793912cosignataire
17060000002131L17/dossiers17170600000021061706000000210625PA795868cosignataire
17060000002132L17/dossiers17170600000021061706000000210626PA842187cosignataire
17060000002133L17/dossiers17170600000021061706000000210627PA842037cosignataire
17060000002134L17/dossiers17170600000021061706000000210628PA791812cosignataire
17060000002135L17/dossiers17170600000021061706000000210629PA793736cosignataire
17060000002136L17/dossiers17170600000021061706000000210630PA721202cosignataire
17060000002137L17/dossiers17170600000021061706000000210631PA721210cosignataire
17060000002138L17/dossiers17170600000021061706000000210632PA795136cosignataire
17060000002139L17/dossiers17170600000021061706000000210633PA793452cosignataire
17060000002140L17/dossiers17170600000021061706000000210634PA793464cosignataire
17060000002141L17/dossiers17170600000021061706000000210635PA842155cosignataire
17060000002142L17/dossiers17170600000021061706000000210636PA795200cosignataire
17060000002143L17/dossiers17170600000021061706000000210637PA795844cosignataire
17060000002144L17/dossiers17170600000021061706000000210638PA721896cosignataire
17060000002145L17/dossiers17170600000021061706000000210639PA841251cosignataire
17060000002146L17/dossiers17170600000021061706000000210640PA794786cosignataire
17060000002147L17/dossiers17170600000021061706000000210641PA794870cosignataire
17060000002148L17/dossiers17170600000021061706000000210642PA796070cosignataire
17060000002149L17/dossiers17170600000021061706000000210643PA795010cosignataire
17060000002150L17/dossiers17170600000021061706000000210644PA795310cosignataire
17060000002151L17/dossiers17170600000021061706000000210645PA794478cosignataire
17060000002152L17/dossiers17170600000021061706000000210646PA841947cosignataire
17060000002153L17/dossiers17170600000021061706000000210647PA794082cosignataire
17060000002154L17/dossiers17170600000021061706000000210648PA795998cosignataire
17060000002155L17/dossiers17170600000021061706000000210649PA794130cosignataire
17060000002156L17/dossiers17170600000021061706000000210650PA720846cosignataire
17060000002157L17/dossiers17170600000021061706000000210651PA841729cosignataire
17060000002158L17/dossiers17170600000021061706000000210652PA795516cosignataire