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
17060000000842L17/dossiers171706000000065017060000000650192PA605745cosignataire
17060000000844L17/dossiers1717060000000843170600000008431PA795164auteur
17060000000845L17/dossiers1717060000000843170600000008432PA795228cosignataire
17060000000846L17/dossiers1717060000000843170600000008433PA793912cosignataire
17060000000847L17/dossiers1717060000000843170600000008434PA842187cosignataire
17060000000848L17/dossiers1717060000000843170600000008435PA842037cosignataire
17060000000849L17/dossiers1717060000000843170600000008436PA796090cosignataire
17060000000850L17/dossiers1717060000000843170600000008437PA791812cosignataire
17060000000851L17/dossiers1717060000000843170600000008438PA793736cosignataire
17060000000852L17/dossiers1717060000000843170600000008439PA721202cosignataire
17060000000853L17/dossiers17170600000008431706000000084310PA795136cosignataire
17060000000854L17/dossiers17170600000008431706000000084311PA793464cosignataire
17060000000855L17/dossiers17170600000008431706000000084312PA842155cosignataire
17060000000856L17/dossiers17170600000008431706000000084313PA795200cosignataire
17060000000857L17/dossiers17170600000008431706000000084314PA795844cosignataire
17060000000858L17/dossiers17170600000008431706000000084315PA841251cosignataire
17060000000859L17/dossiers17170600000008431706000000084316PA794786cosignataire
17060000000860L17/dossiers17170600000008431706000000084317PA794870cosignataire
17060000000861L17/dossiers17170600000008431706000000084318PA796070cosignataire
17060000000862L17/dossiers17170600000008431706000000084319PA795310cosignataire
17060000000863L17/dossiers17170600000008431706000000084320PA794478cosignataire
17060000000864L17/dossiers17170600000008431706000000084321PA841947cosignataire
17060000000865L17/dossiers17170600000008431706000000084322PA794082cosignataire
17060000000866L17/dossiers17170600000008431706000000084323PA794130cosignataire
17060000000867L17/dossiers17170600000008431706000000084324PA720846cosignataire
17060000000868L17/dossiers17170600000008431706000000084325PA841729cosignataire
17060000000869L17/dossiers17170600000008431706000000084326PA795516cosignataire
17060000000870L17/dossiers17170600000008431706000000084327PA795672cosignataire
17060000000871L17/dossiers17170600000008431706000000084328PA795746cosignataire
17060000000872L17/dossiers17170600000008431706000000084329PA795108cosignataire
17060000000873L17/dossiers17170600000008431706000000084330PA841515cosignataire
17060000000874L17/dossiers17170600000008431706000000084331PA795298cosignataire
17060000000875L17/dossiers17170600000008431706000000084332PA791824cosignataire
17060000000876L17/dossiers17170600000008431706000000084333PA842029cosignataire
17060000000877L17/dossiers17170600000008431706000000084334PA793532cosignataire
17060000000878L17/dossiers17170600000008431706000000084335PA795636cosignataire
17060000000879L17/dossiers17170600000008431706000000084336PA342384cosignataire
17060000000880L17/dossiers17170600000008431706000000084337PA795422cosignataire
17060000000881L17/dossiers17170600000008431706000000084338PA794686cosignataire
17060000000882L17/dossiers17170600000008431706000000084339PA841215cosignataire
17060000000883L17/dossiers17170600000008431706000000084340PA795482cosignataire
17060000000884L17/dossiers17170600000008431706000000084341PA610654cosignataire
17060000000885L17/dossiers17170600000008431706000000084342PA841191cosignataire
17060000000886L17/dossiers17170600000008431706000000084343PA721960cosignataire
17060000000887L17/dossiers17170600000008431706000000084344PA793872cosignataire
17060000000888L17/dossiers17170600000008431706000000084345PA817211cosignataire
17060000000889L17/dossiers17170600000008431706000000084346PA793756cosignataire
17060000000890L17/dossiers17170600000008431706000000084347PA796062cosignataire
17060000000891L17/dossiers17170600000008431706000000084348PA719578cosignataire
17060000000892L17/dossiers17170600000008431706000000084349PA721062cosignataire