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
17060000001957L17/dossiers171706000000177917060000001779178PA335612cosignataire
17060000001958L17/dossiers171706000000177917060000001779179PA796010cosignataire
17060000001959L17/dossiers171706000000177917060000001779180PA842271cosignataire
17060000001960L17/dossiers171706000000177917060000001779181PA795820cosignataire
17060000001961L17/dossiers171706000000177917060000001779182PA721270cosignataire
17060000001962L17/dossiers171706000000177917060000001779183PA795240cosignataire
17060000001963L17/dossiers171706000000177917060000001779184PA795876cosignataire
17060000001964L17/dossiers171706000000177917060000001779185PA605745cosignataire
17060000001966L17/dossiers1717060000001965170600000019651PA720614auteur
17060000001967L17/dossiers1717060000001965170600000019652PA330240cosignataire
17060000001968L17/dossiers1717060000001965170600000019653PA793432cosignataire
17060000001969L17/dossiers1717060000001965170600000019654PA841495cosignataire
17060000001970L17/dossiers1717060000001965170600000019655PA796118cosignataire
17060000001971L17/dossiers1717060000001965170600000019656PA794562cosignataire
17060000001972L17/dossiers1717060000001965170600000019657PA842279cosignataire
17060000001973L17/dossiers1717060000001965170600000019658PA793238cosignataire
17060000001974L17/dossiers1717060000001965170600000019659PA793374cosignataire
17060000001975L17/dossiers17170600000019651706000000196510PA793158cosignataire
17060000001976L17/dossiers17170600000019651706000000196511PA794434cosignataire
17060000001977L17/dossiers17170600000019651706000000196512PA841645cosignataire
17060000001978L17/dossiers17170600000019651706000000196513PA842001cosignataire
17060000001979L17/dossiers17170600000019651706000000196514PA720822cosignataire
17060000001980L17/dossiers17170600000019651706000000196515PA720668cosignataire
17060000001981L17/dossiers17170600000019651706000000196516PA794886cosignataire
17060000001982L17/dossiers17170600000019651706000000196517PA796042cosignataire
17060000001983L17/dossiers17170600000019651706000000196518PA793844cosignataire
17060000001984L17/dossiers17170600000019651706000000196519PA841487cosignataire
17060000001985L17/dossiers17170600000019651706000000196520PA841131cosignataire
17060000001986L17/dossiers17170600000019651706000000196521PA793182cosignataire
17060000001987L17/dossiers17170600000019651706000000196522PA793134cosignataire
17060000001988L17/dossiers17170600000019651706000000196523PA840075cosignataire
17060000001989L17/dossiers17170600000019651706000000196524PA720468cosignataire
17060000001990L17/dossiers17170600000019651706000000196525PA794198cosignataire
17060000001991L17/dossiers17170600000019651706000000196526PA840159cosignataire
17060000001992L17/dossiers17170600000019651706000000196527PA793548cosignataire
17060000001993L17/dossiers17170600000019651706000000196528PA795644cosignataire
17060000001994L17/dossiers17170600000019651706000000196529PA840119cosignataire
17060000001995L17/dossiers17170600000019651706000000196530PA793166cosignataire
17060000001996L17/dossiers17170600000019651706000000196531PA793928cosignataire
17060000001997L17/dossiers17170600000019651706000000196532PA794762cosignataire
17060000001998L17/dossiers17170600000019651706000000196533PA793146cosignataire
17060000001999L17/dossiers17170600000019651706000000196534PA840135cosignataire
17060000002000L17/dossiers17170600000019651706000000196535PA842073cosignataire
17060000002001L17/dossiers17170600000019651706000000196536PA841761cosignataire
17060000002002L17/dossiers17170600000019651706000000196537PA841621cosignataire
17060000002003L17/dossiers17170600000019651706000000196538PA793246cosignataire
17060000002004L17/dossiers17170600000019651706000000196539PA841613cosignataire
17060000002005L17/dossiers17170600000019651706000000196540PA840143cosignataire
17060000002006L17/dossiers17170600000019651706000000196541PA840801cosignataire
17060000002007L17/dossiers17170600000019651706000000196542PA794678cosignataire