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
17060000002311L17/dossiers1717060000002310170600000023101PA720614auteur
17060000002312L17/dossiers1717060000002310170600000023102PA330240cosignataire
17060000002313L17/dossiers1717060000002310170600000023103PA793432cosignataire
17060000002314L17/dossiers1717060000002310170600000023104PA841495cosignataire
17060000002315L17/dossiers1717060000002310170600000023105PA794562cosignataire
17060000002316L17/dossiers1717060000002310170600000023106PA842279cosignataire
17060000002317L17/dossiers1717060000002310170600000023107PA793158cosignataire
17060000002318L17/dossiers1717060000002310170600000023108PA794434cosignataire
17060000002319L17/dossiers1717060000002310170600000023109PA841645cosignataire
17060000002320L17/dossiers17170600000023101706000000231010PA842001cosignataire
17060000002321L17/dossiers17170600000023101706000000231011PA720822cosignataire
17060000002322L17/dossiers17170600000023101706000000231012PA794886cosignataire
17060000002323L17/dossiers17170600000023101706000000231013PA796042cosignataire
17060000002324L17/dossiers17170600000023101706000000231014PA841487cosignataire
17060000002325L17/dossiers17170600000023101706000000231015PA841131cosignataire
17060000002326L17/dossiers17170600000023101706000000231016PA793182cosignataire
17060000002327L17/dossiers17170600000023101706000000231017PA793134cosignataire
17060000002328L17/dossiers17170600000023101706000000231018PA840075cosignataire
17060000002329L17/dossiers17170600000023101706000000231019PA720468cosignataire
17060000002330L17/dossiers17170600000023101706000000231020PA840159cosignataire
17060000002331L17/dossiers17170600000023101706000000231021PA793548cosignataire
17060000002332L17/dossiers17170600000023101706000000231022PA795644cosignataire
17060000002333L17/dossiers17170600000023101706000000231023PA642988cosignataire
17060000002334L17/dossiers17170600000023101706000000231024PA793166cosignataire
17060000002335L17/dossiers17170600000023101706000000231025PA794762cosignataire
17060000002336L17/dossiers17170600000023101706000000231026PA793146cosignataire
17060000002337L17/dossiers17170600000023101706000000231027PA840135cosignataire
17060000002338L17/dossiers17170600000023101706000000231028PA842073cosignataire
17060000002339L17/dossiers17170600000023101706000000231029PA793246cosignataire
17060000002340L17/dossiers17170600000023101706000000231030PA840143cosignataire
17060000002341L17/dossiers17170600000023101706000000231031PA794678cosignataire
17060000002342L17/dossiers17170600000023101706000000231032PA793892cosignataire
17060000002343L17/dossiers17170600000023101706000000231033PA841737cosignataire
17060000002344L17/dossiers17170600000023101706000000231034PA796034cosignataire
17060000002345L17/dossiers17170600000023101706000000231035PA793832cosignataire
17060000002346L17/dossiers17170600000023101706000000231036PA793102cosignataire
17060000002347L17/dossiers17170600000023101706000000231037PA841605cosignataire
17060000002348L17/dossiers17170600000023101706000000231038PA793362cosignataire
17060000002349L17/dossiers17170600000023101706000000231039PA794418cosignataire
17060000002350L17/dossiers17170600000023101706000000231040PA793592cosignataire
17060000002351L17/dossiers17170600000023101706000000231041PA840757cosignataire
17060000002352L17/dossiers17170600000023101706000000231042PA841451cosignataire
17060000002353L17/dossiers17170600000023101706000000231043PA794734cosignataire
17060000002354L17/dossiers17170600000023101706000000231044PA793218cosignataire
17060000002355L17/dossiers17170600000023101706000000231045PA795900cosignataire
17060000002356L17/dossiers17170600000023101706000000231046PA842085cosignataire
17060000002357L17/dossiers17170600000023101706000000231047PA794598cosignataire
17060000002358L17/dossiers17170600000023101706000000231048PA794030cosignataire
17060000002359L17/dossiers17170600000023101706000000231049PA841075cosignataire
17060000002360L17/dossiers17170600000023101706000000231050PA840869cosignataire