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
17060000001147L17/dossiers17170600000011161706000000111631PA796070cosignataire
17060000001148L17/dossiers17170600000011161706000000111632PA795310cosignataire
17060000001149L17/dossiers17170600000011161706000000111633PA794478cosignataire
17060000001150L17/dossiers17170600000011161706000000111634PA841947cosignataire
17060000001151L17/dossiers17170600000011161706000000111635PA794082cosignataire
17060000001152L17/dossiers17170600000011161706000000111636PA794130cosignataire
17060000001153L17/dossiers17170600000011161706000000111637PA720846cosignataire
17060000001154L17/dossiers17170600000011161706000000111638PA841729cosignataire
17060000001155L17/dossiers17170600000011161706000000111639PA795516cosignataire
17060000001156L17/dossiers17170600000011161706000000111640PA795672cosignataire
17060000001157L17/dossiers17170600000011161706000000111641PA795746cosignataire
17060000001158L17/dossiers17170600000011161706000000111642PA795108cosignataire
17060000001159L17/dossiers17170600000011161706000000111643PA841515cosignataire
17060000001160L17/dossiers17170600000011161706000000111644PA795298cosignataire
17060000001161L17/dossiers17170600000011161706000000111645PA791824cosignataire
17060000001162L17/dossiers17170600000011161706000000111646PA842029cosignataire
17060000001163L17/dossiers17170600000011161706000000111647PA793532cosignataire
17060000001164L17/dossiers17170600000011161706000000111648PA342384cosignataire
17060000001165L17/dossiers17170600000011161706000000111649PA795422cosignataire
17060000001166L17/dossiers17170600000011161706000000111650PA794686cosignataire
17060000001167L17/dossiers17170600000011161706000000111651PA841215cosignataire
17060000001168L17/dossiers17170600000011161706000000111652PA795482cosignataire
17060000001169L17/dossiers17170600000011161706000000111653PA610654cosignataire
17060000001170L17/dossiers17170600000011161706000000111654PA841191cosignataire
17060000001171L17/dossiers17170600000011161706000000111655PA721960cosignataire
17060000001172L17/dossiers17170600000011161706000000111656PA793872cosignataire
17060000001173L17/dossiers17170600000011161706000000111657PA817211cosignataire
17060000001174L17/dossiers17170600000011161706000000111658PA795164cosignataire
17060000001176L17/dossiers1717060000001175170600000011751PA720614auteur
17060000001177L17/dossiers1717060000001175170600000011752PA793432cosignataire
17060000001178L17/dossiers1717060000001175170600000011753PA841495cosignataire
17060000001179L17/dossiers1717060000001175170600000011754PA794562cosignataire
17060000001180L17/dossiers1717060000001175170600000011755PA842279cosignataire
17060000001181L17/dossiers1717060000001175170600000011756PA793238cosignataire
17060000001182L17/dossiers1717060000001175170600000011757PA793374cosignataire
17060000001183L17/dossiers1717060000001175170600000011758PA794434cosignataire
17060000001184L17/dossiers1717060000001175170600000011759PA793158cosignataire
17060000001185L17/dossiers17170600000011751706000000117510PA841645cosignataire
17060000001186L17/dossiers17170600000011751706000000117511PA720668cosignataire
17060000001187L17/dossiers17170600000011751706000000117512PA793844cosignataire
17060000001188L17/dossiers17170600000011751706000000117513PA841131cosignataire
17060000001189L17/dossiers17170600000011751706000000117514PA793134cosignataire
17060000001190L17/dossiers17170600000011751706000000117515PA840075cosignataire
17060000001191L17/dossiers17170600000011751706000000117516PA720468cosignataire
17060000001192L17/dossiers17170600000011751706000000117517PA794198cosignataire
17060000001193L17/dossiers17170600000011751706000000117518PA793548cosignataire
17060000001194L17/dossiers17170600000011751706000000117519PA795644cosignataire
17060000001195L17/dossiers17170600000011751706000000117520PA841613cosignataire
17060000001196L17/dossiers17170600000011751706000000117521PA642988cosignataire
17060000001197L17/dossiers17170600000011751706000000117522PA793928cosignataire