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
17060000001096L17/dossiers17170600000010571706000000105739PA793362cosignataire
17060000001097L17/dossiers17170600000010571706000000105740PA794418cosignataire
17060000001098L17/dossiers17170600000010571706000000105741PA841749cosignataire
17060000001099L17/dossiers17170600000010571706000000105742PA840869cosignataire
17060000001100L17/dossiers17170600000010571706000000105743PA795912cosignataire
17060000001101L17/dossiers17170600000010571706000000105744PA841837cosignataire
17060000001102L17/dossiers17170600000010571706000000105745PA840857cosignataire
17060000001103L17/dossiers17170600000010571706000000105746PA793290cosignataire
17060000001104L17/dossiers17170600000010571706000000105747PA840983cosignataire
17060000001105L17/dossiers17170600000010571706000000105748PA642988cosignataire
17060000001106L17/dossiers17170600000010571706000000105749PA841183cosignataire
17060000001107L17/dossiers17170600000010571706000000105750PA719436cosignataire
17060000001108L17/dossiers17170600000010571706000000105751PA793354cosignataire
17060000001109L17/dossiers17170600000010571706000000105752PA794322cosignataire
17060000001110L17/dossiers17170600000010571706000000105753PA793852cosignataire
17060000001111L17/dossiers17170600000010571706000000105754PA840915cosignataire
17060000001112L17/dossiers17170600000010571706000000105755PA793696cosignataire
17060000001113L17/dossiers17170600000010571706000000105756PA795552cosignataire
17060000001114L17/dossiers17170600000010571706000000105757PA794670cosignataire
17060000001115L17/dossiers17170600000010571706000000105758PA795778cosignataire
17060000001117L17/dossiers1717060000001116170600000011161PA720892auteur
17060000001118L17/dossiers1717060000001116170600000011162PA795228cosignataire
17060000001119L17/dossiers1717060000001116170600000011163PA793262cosignataire
17060000001120L17/dossiers1717060000001116170600000011164PA794906cosignataire
17060000001121L17/dossiers1717060000001116170600000011165PA794138cosignataire
17060000001122L17/dossiers1717060000001116170600000011166PA795588cosignataire
17060000001123L17/dossiers1717060000001116170600000011167PA795084cosignataire
17060000001124L17/dossiers1717060000001116170600000011168PA842105cosignataire
17060000001125L17/dossiers1717060000001116170600000011169PA841657cosignataire
17060000001126L17/dossiers17170600000011161706000000111610PA720430cosignataire
17060000001127L17/dossiers17170600000011161706000000111611PA793772cosignataire
17060000001128L17/dossiers17170600000011161706000000111612PA795616cosignataire
17060000001129L17/dossiers17170600000011161706000000111613PA793444cosignataire
17060000001130L17/dossiers17170600000011161706000000111614PA794938cosignataire
17060000001131L17/dossiers17170600000011161706000000111615PA795318cosignataire
17060000001132L17/dossiers17170600000011161706000000111616PA841023cosignataire
17060000001133L17/dossiers17170600000011161706000000111617PA793912cosignataire
17060000001134L17/dossiers17170600000011161706000000111618PA842187cosignataire
17060000001135L17/dossiers17170600000011161706000000111619PA842037cosignataire
17060000001136L17/dossiers17170600000011161706000000111620PA791812cosignataire
17060000001137L17/dossiers17170600000011161706000000111621PA793736cosignataire
17060000001138L17/dossiers17170600000011161706000000111622PA721202cosignataire
17060000001139L17/dossiers17170600000011161706000000111623PA795136cosignataire
17060000001140L17/dossiers17170600000011161706000000111624PA793464cosignataire
17060000001141L17/dossiers17170600000011161706000000111625PA842155cosignataire
17060000001142L17/dossiers17170600000011161706000000111626PA795200cosignataire
17060000001143L17/dossiers17170600000011161706000000111627PA795844cosignataire
17060000001144L17/dossiers17170600000011161706000000111628PA841251cosignataire
17060000001145L17/dossiers17170600000011161706000000111629PA794786cosignataire
17060000001146L17/dossiers17170600000011161706000000111630PA794870cosignataire