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
17060000000893L17/dossiers17170600000008431706000000084350PA795076cosignataire
17060000000894L17/dossiers17170600000008431706000000084351PA841845cosignataire
17060000000895L17/dossiers17170600000008431706000000084352PA795982cosignataire
17060000000896L17/dossiers17170600000008431706000000084353PA795466cosignataire
17060000000897L17/dossiers17170600000008431706000000084354PA793744cosignataire
17060000000898L17/dossiers17170600000008431706000000084355PA720952cosignataire
17060000000899L17/dossiers17170600000008431706000000084356PA794106cosignataire
17060000000900L17/dossiers17170600000008431706000000084357PA794166cosignataire
17060000000901L17/dossiers17170600000008431706000000084358PA795596cosignataire
17060000000903L17/dossiers1717060000000902170600000009021PA719930auteur
17060000000904L17/dossiers1717060000000902170600000009022PA840665cosignataire
17060000000905L17/dossiers1717060000000902170600000009023PA642764cosignataire
17060000000906L17/dossiers1717060000000902170600000009024PA643143cosignataire
17060000000907L17/dossiers1717060000000902170600000009025PA840829cosignataire
17060000000908L17/dossiers1717060000000902170600000009026PA342415cosignataire
17060000000909L17/dossiers1717060000000902170600000009027PA606793cosignataire
17060000000910L17/dossiers1717060000000902170600000009028PA842211cosignataire
17060000000911L17/dossiers1717060000000902170600000009029PA841315cosignataire
17060000000912L17/dossiers17170600000009021706000000090210PA794094cosignataire
17060000000913L17/dossiers17170600000009021706000000090211PA793624cosignataire
17060000000914L17/dossiers17170600000009021706000000090212PA795762cosignataire
17060000000915L17/dossiers17170600000009021706000000090213PA608264cosignataire
17060000000916L17/dossiers17170600000009021706000000090214PA840903cosignataire
17060000000917L17/dossiers17170600000009021706000000090215PA841295cosignataire
17060000000918L17/dossiers17170600000009021706000000090216PA1008cosignataire
17060000000919L17/dossiers17170600000009021706000000090217PA793394cosignataire
17060000000920L17/dossiers17170600000009021706000000090218PA795430cosignataire
17060000000921L17/dossiers17170600000009021706000000090219PA841919cosignataire
17060000000922L17/dossiers17170600000009021706000000090220PA606573cosignataire
17060000000923L17/dossiers17170600000009021706000000090221PA841633cosignataire
17060000000924L17/dossiers17170600000009021706000000090222PA794854cosignataire
17060000000925L17/dossiers17170600000009021706000000090223PA842195cosignataire
17060000000926L17/dossiers17170600000009021706000000090224PA609332cosignataire
17060000000927L17/dossiers17170600000009021706000000090225PA841665cosignataire
17060000000928L17/dossiers17170600000009021706000000090226PA333285cosignataire
17060000000929L17/dossiers17170600000009021706000000090227PA840939cosignataire
17060000000930L17/dossiers17170600000009021706000000090228PA841539cosignataire
17060000000931L17/dossiers17170600000009021706000000090229PA331973cosignataire
17060000000932L17/dossiers17170600000009021706000000090230PA840171cosignataire
17060000000933L17/dossiers17170600000009021706000000090231PA1567cosignataire
17060000000934L17/dossiers17170600000009021706000000090232PA841471cosignataire
17060000000935L17/dossiers17170600000009021706000000090233PA842263cosignataire
17060000000936L17/dossiers17170600000009021706000000090234PA841813cosignataire
17060000000937L17/dossiers17170600000009021706000000090235PA841853cosignataire
17060000000938L17/dossiers17170600000009021706000000090236PA1654cosignataire
17060000000939L17/dossiers17170600000009021706000000090237PA643192cosignataire
17060000000940L17/dossiers17170600000009021706000000090238PA335054cosignataire
17060000000941L17/dossiers17170600000009021706000000090239PA795156cosignataire
17060000000942L17/dossiers17170600000009021706000000090240PA774958cosignataire
17060000000943L17/dossiers17170600000009021706000000090241PA840765cosignataire