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
16060000000834L16/dossiers16160600000007821606000000078252PA793688cosignataire
16060000000835L16/dossiers16160600000007821606000000078253PA342384cosignataire
16060000000836L16/dossiers16160600000007821606000000078254PA795692cosignataire
16060000000837L16/dossiers16160600000007821606000000078255PA794066cosignataire
16060000000838L16/dossiers16160600000007821606000000078256PA795422cosignataire
16060000000839L16/dossiers16160600000007821606000000078257PA794686cosignataire
16060000000840L16/dossiers16160600000007821606000000078258PA795482cosignataire
16060000000841L16/dossiers16160600000007821606000000078259PA610654cosignataire
16060000000842L16/dossiers16160600000007821606000000078260PA721960cosignataire
16060000000843L16/dossiers16160600000007821606000000078261PA793872cosignataire
16060000000844L16/dossiers16160600000007821606000000078262PA793756cosignataire
16060000000845L16/dossiers16160600000007821606000000078263PA796062cosignataire
16060000000846L16/dossiers16160600000007821606000000078264PA719578cosignataire
16060000000847L16/dossiers16160600000007821606000000078265PA720422cosignataire
16060000000848L16/dossiers16160600000007821606000000078266PA721062cosignataire
16060000000849L16/dossiers16160600000007821606000000078267PA793884cosignataire
16060000000850L16/dossiers16160600000007821606000000078268PA722142cosignataire
16060000000851L16/dossiers16160600000007821606000000078269PA795982cosignataire
16060000000852L16/dossiers16160600000007821606000000078270PA793724cosignataire
16060000000853L16/dossiers16160600000007821606000000078271PA796018cosignataire
16060000000854L16/dossiers16160600000007821606000000078272PA795466cosignataire
16060000000855L16/dossiers16160600000007821606000000078273PA793744cosignataire
16060000000856L16/dossiers16160600000007821606000000078274PA718860cosignataire
16060000000857L16/dossiers16160600000007821606000000078275PA794106cosignataire
16060000000858L16/dossiers16160600000007821606000000078276PA794166cosignataire
16060000000859L16/dossiers16160600000007821606000000078277PA795164cosignataire
16060000000860L16/dossiers16160600000007821606000000078278PA795596cosignataire
16060000000861L16/dossiers16160600000007821606000000078279PA793110cosignataire
16060000000862L16/dossiers16160600000007821606000000078280PA642764cosignataire
16060000000863L16/dossiers16160600000007821606000000078281PA643143cosignataire
16060000000864L16/dossiers16160600000007821606000000078282PA342415cosignataire
16060000000865L16/dossiers16160600000007821606000000078283PA794094cosignataire
16060000000866L16/dossiers16160600000007821606000000078284PA793624cosignataire
16060000000867L16/dossiers16160600000007821606000000078285PA795762cosignataire
16060000000868L16/dossiers16160600000007821606000000078286PA1008cosignataire
16060000000869L16/dossiers16160600000007821606000000078287PA793394cosignataire
16060000000870L16/dossiers16160600000007821606000000078288PA795430cosignataire
16060000000871L16/dossiers16160600000007821606000000078289PA794854cosignataire
16060000000872L16/dossiers16160600000007821606000000078290PA609332cosignataire
16060000000873L16/dossiers16160600000007821606000000078291PA333285cosignataire
16060000000874L16/dossiers16160600000007821606000000078292PA1567cosignataire
16060000000875L16/dossiers16160600000007821606000000078293PA795828cosignataire
16060000000876L16/dossiers16160600000007821606000000078294PA643192cosignataire
16060000000877L16/dossiers16160600000007821606000000078295PA335054cosignataire
16060000000878L16/dossiers16160600000007821606000000078296PA795156cosignataire
16060000000879L16/dossiers16160600000007821606000000078297PA774958cosignataire
16060000000880L16/dossiers16160600000007821606000000078298PA643157cosignataire
16060000000881L16/dossiers16160600000007821606000000078299PA344201cosignataire
16060000000882L16/dossiers161606000000078216060000000782100PA794270cosignataire
16060000000883L16/dossiers161606000000078216060000000782101PA608172cosignataire