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
16060000001086L16/dossiers16160600000010221606000000102264PA795828cosignataire
16060000001087L16/dossiers16160600000010221606000000102265PA794082cosignataire
16060000001088L16/dossiers16160600000010221606000000102266PA643192cosignataire
16060000001089L16/dossiers16160600000010221606000000102267PA722344cosignataire
16060000001090L16/dossiers16160600000010221606000000102268PA722202cosignataire
16060000001091L16/dossiers16160600000010221606000000102269PA335054cosignataire
16060000001092L16/dossiers16160600000010221606000000102270PA795998cosignataire
16060000001093L16/dossiers16160600000010221606000000102271PA795438cosignataire
16060000001094L16/dossiers16160600000010221606000000102272PA795156cosignataire
16060000001095L16/dossiers16160600000010221606000000102273PA794130cosignataire
16060000001096L16/dossiers16160600000010221606000000102274PA720846cosignataire
16060000001097L16/dossiers16160600000010221606000000102275PA794146cosignataire
16060000001098L16/dossiers16160600000010221606000000102276PA795516cosignataire
16060000001099L16/dossiers16160600000010221606000000102277PA795672cosignataire
16060000001100L16/dossiers16160600000010221606000000102278PA795184cosignataire
16060000001101L16/dossiers16160600000010221606000000102279PA795746cosignataire
16060000001102L16/dossiers16160600000010221606000000102280PA774962cosignataire
16060000001103L16/dossiers16160600000010221606000000102281PA795108cosignataire
16060000001104L16/dossiers16160600000010221606000000102282PA335612cosignataire
16060000001105L16/dossiers16160600000010221606000000102283PA794402cosignataire
16060000001106L16/dossiers16160600000010221606000000102284PA795298cosignataire
16060000001107L16/dossiers16160600000010221606000000102285PA791824cosignataire
16060000001108L16/dossiers16160600000010221606000000102286PA793532cosignataire
16060000001109L16/dossiers16160600000010221606000000102287PA774958cosignataire
16060000001110L16/dossiers16160600000010221606000000102288PA795636cosignataire
16060000001111L16/dossiers16160600000010221606000000102289PA796010cosignataire
16060000001112L16/dossiers16160600000010221606000000102290PA793688cosignataire
16060000001113L16/dossiers16160600000010221606000000102291PA342384cosignataire
16060000001114L16/dossiers16160600000010221606000000102292PA795692cosignataire
16060000001115L16/dossiers16160600000010221606000000102293PA794066cosignataire
16060000001116L16/dossiers16160600000010221606000000102294PA795422cosignataire
16060000001117L16/dossiers16160600000010221606000000102295PA794686cosignataire
16060000001118L16/dossiers16160600000010221606000000102296PA795482cosignataire
16060000001119L16/dossiers16160600000010221606000000102297PA793174cosignataire
16060000001120L16/dossiers16160600000010221606000000102298PA795820cosignataire
16060000001121L16/dossiers16160600000010221606000000102299PA643157cosignataire
16060000001122L16/dossiers161606000000102216060000001022100PA610654cosignataire
16060000001123L16/dossiers161606000000102216060000001022101PA721960cosignataire
16060000001124L16/dossiers161606000000102216060000001022102PA793872cosignataire
16060000001125L16/dossiers161606000000102216060000001022103PA795794cosignataire
16060000001126L16/dossiers161606000000102216060000001022104PA344201cosignataire
16060000001127L16/dossiers161606000000102216060000001022105PA721270cosignataire
16060000001128L16/dossiers161606000000102216060000001022106PA793708cosignataire
16060000001129L16/dossiers161606000000102216060000001022107PA794270cosignataire
16060000001130L16/dossiers161606000000102216060000001022108PA817211cosignataire
16060000001131L16/dossiers161606000000102216060000001022109PA793756cosignataire
16060000001132L16/dossiers161606000000102216060000001022110PA608172cosignataire
16060000001133L16/dossiers161606000000102216060000001022111PA793664cosignataire
16060000001134L16/dossiers161606000000102216060000001022112PA796062cosignataire
16060000001135L16/dossiers161606000000102216060000001022113PA607553cosignataire