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
16060000000985L16/dossiers16160600000009331606000000093352PA642988cosignataire
16060000000986L16/dossiers16160600000009331606000000093353PA793608cosignataire
16060000000987L16/dossiers16160600000009331606000000093354PA793672cosignataire
16060000000988L16/dossiers16160600000009331606000000093355PA793904cosignataire
16060000000989L16/dossiers16160600000009331606000000093356PA721932cosignataire
16060000000990L16/dossiers16160600000009331606000000093357PA795974cosignataire
16060000000991L16/dossiers16160600000009331606000000093358PA794590cosignataire
16060000000992L16/dossiers16160600000009331606000000093359PA794530cosignataire
16060000000993L16/dossiers16160600000009331606000000093360PA794770cosignataire
16060000000994L16/dossiers16160600000009331606000000093361PA793314cosignataire
16060000000995L16/dossiers16160600000009331606000000093362PA793330cosignataire
16060000000996L16/dossiers16160600000009331606000000093363PA793616cosignataire
16060000000997L16/dossiers16160600000009331606000000093364PA719436cosignataire
16060000000998L16/dossiers16160600000009331606000000093365PA793354cosignataire
16060000000999L16/dossiers16160600000009331606000000093366PA795786cosignataire
16060000001000L16/dossiers16160600000009331606000000093367PA794322cosignataire
16060000001001L16/dossiers16160600000009331606000000093368PA793852cosignataire
16060000001002L16/dossiers16160600000009331606000000093369PA793696cosignataire
16060000001003L16/dossiers16160600000009331606000000093370PA795552cosignataire
16060000001004L16/dossiers16160600000009331606000000093371PA794314cosignataire
16060000001005L16/dossiers16160600000009331606000000093372PA794670cosignataire
16060000001006L16/dossiers16160600000009331606000000093373PA794582cosignataire
16060000001007L16/dossiers16160600000009331606000000093374PA793656cosignataire
16060000001008L16/dossiers16160600000009331606000000093375PA795966cosignataire
16060000001009L16/dossiers16160600000009331606000000093376PA793230cosignataire
16060000001010L16/dossiers16160600000009331606000000093377PA793254cosignataire
16060000001011L16/dossiers16160600000009331606000000093378PA794442cosignataire
16060000001012L16/dossiers16160600000009331606000000093379PA795410cosignataire
16060000001013L16/dossiers16160600000009331606000000093380PA794894cosignataire
16060000001014L16/dossiers16160600000009331606000000093381PA794570cosignataire
16060000001015L16/dossiers16160600000009331606000000093382PA794954cosignataire
16060000001016L16/dossiers16160600000009331606000000093383PA796050cosignataire
16060000001017L16/dossiers16160600000009331606000000093384PA793382cosignataire
16060000001018L16/dossiers16160600000009331606000000093385PA795778cosignataire
16060000001019L16/dossiers16160600000009331606000000093386PA794502cosignataire
16060000001020L16/dossiers16160600000009331606000000093387PA793298cosignataire
16060000001021L16/dossiers16160600000009331606000000093388PA794946cosignataire
16060000001023L16/dossiers1616060000001022160600000010221PA719930auteur
16060000001024L16/dossiers1616060000001022160600000010222PA720892cosignataire
16060000001025L16/dossiers1616060000001022160600000010223PA794008cosignataire
16060000001026L16/dossiers1616060000001022160600000010224PA267306cosignataire
16060000001027L16/dossiers1616060000001022160600000010225PA795228cosignataire
16060000001028L16/dossiers1616060000001022160600000010226PA793262cosignataire
16060000001029L16/dossiers1616060000001022160600000010227PA794906cosignataire
16060000001030L16/dossiers1616060000001022160600000010228PA794138cosignataire
16060000001031L16/dossiers1616060000001022160600000010229PA795588cosignataire
16060000001032L16/dossiers16160600000010221606000000102210PA795084cosignataire
16060000001033L16/dossiers16160600000010221606000000102211PA793780cosignataire
16060000001034L16/dossiers16160600000010221606000000102212PA588884cosignataire
16060000001035L16/dossiers16160600000010221606000000102213PA642764cosignataire