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
17060000002008L17/dossiers17170600000019651706000000196543PA841139cosignataire
17060000002009L17/dossiers17170600000019651706000000196544PA793892cosignataire
17060000002010L17/dossiers17170600000019651706000000196545PA841737cosignataire
17060000002011L17/dossiers17170600000019651706000000196546PA796034cosignataire
17060000002012L17/dossiers17170600000019651706000000196547PA793832cosignataire
17060000002013L17/dossiers17170600000019651706000000196548PA793102cosignataire
17060000002014L17/dossiers17170600000019651706000000196549PA841605cosignataire
17060000002015L17/dossiers17170600000019651706000000196550PA793362cosignataire
17060000002016L17/dossiers17170600000019651706000000196551PA794418cosignataire
17060000002017L17/dossiers17170600000019651706000000196552PA793592cosignataire
17060000002018L17/dossiers17170600000019651706000000196553PA840757cosignataire
17060000002019L17/dossiers17170600000019651706000000196554PA841451cosignataire
17060000002020L17/dossiers17170600000019651706000000196555PA794734cosignataire
17060000002021L17/dossiers17170600000019651706000000196556PA793218cosignataire
17060000002022L17/dossiers17170600000019651706000000196557PA795900cosignataire
17060000002023L17/dossiers17170600000019651706000000196558PA793632cosignataire
17060000002024L17/dossiers17170600000019651706000000196559PA842085cosignataire
17060000002025L17/dossiers17170600000019651706000000196560PA794598cosignataire
17060000002026L17/dossiers17170600000019651706000000196561PA841439cosignataire
17060000002027L17/dossiers17170600000019651706000000196562PA794030cosignataire
17060000002028L17/dossiers17170600000019651706000000196563PA841749cosignataire
17060000002029L17/dossiers17170600000019651706000000196564PA841075cosignataire
17060000002030L17/dossiers17170600000019651706000000196565PA840869cosignataire
17060000002031L17/dossiers17170600000019651706000000196566PA794354cosignataire
17060000002032L17/dossiers17170600000019651706000000196567PA795912cosignataire
17060000002033L17/dossiers17170600000019651706000000196568PA841837cosignataire
17060000002034L17/dossiers17170600000019651706000000196569PA796026cosignataire
17060000002035L17/dossiers17170600000019651706000000196570PA840857cosignataire
17060000002036L17/dossiers17170600000019651706000000196571PA793290cosignataire
17060000002037L17/dossiers17170600000019651706000000196572PA642988cosignataire
17060000002038L17/dossiers17170600000019651706000000196573PA793608cosignataire
17060000002039L17/dossiers17170600000019651706000000196574PA841873cosignataire
17060000002040L17/dossiers17170600000019651706000000196575PA840967cosignataire
17060000002041L17/dossiers17170600000019651706000000196576PA793672cosignataire
17060000002042L17/dossiers17170600000019651706000000196577PA793904cosignataire
17060000002043L17/dossiers17170600000019651706000000196578PA721932cosignataire
17060000002044L17/dossiers17170600000019651706000000196579PA795974cosignataire
17060000002045L17/dossiers17170600000019651706000000196580PA794590cosignataire
17060000002046L17/dossiers17170600000019651706000000196581PA841587cosignataire
17060000002047L17/dossiers17170600000019651706000000196582PA841563cosignataire
17060000002048L17/dossiers17170600000019651706000000196583PA794530cosignataire
17060000002049L17/dossiers17170600000019651706000000196584PA840837cosignataire
17060000002050L17/dossiers17170600000019651706000000196585PA794770cosignataire
17060000002051L17/dossiers17170600000019651706000000196586PA841825cosignataire
17060000002052L17/dossiers17170600000019651706000000196587PA793330cosignataire
17060000002053L17/dossiers17170600000019651706000000196588PA793314cosignataire
17060000002054L17/dossiers17170600000019651706000000196589PA793616cosignataire
17060000002055L17/dossiers17170600000019651706000000196590PA719436cosignataire
17060000002056L17/dossiers17170600000019651706000000196591PA793354cosignataire
17060000002057L17/dossiers17170600000019651706000000196592PA795786cosignataire