AN · données ouvertes
Explorateur / dossiers

dossiers.document_co_signataire

Chemin document.coSignataires.coSignataire · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %

305 151 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.coSignataires.coSignataire.acteur.acteurRef · présence : L17 25 %, L16 26 %, L15 28 %, L14 29 %
8date_cosignatureDATEdocument.coSignataires.coSignataire.dateCosignature · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
9date_retrait_cosignatureDATEdocument.coSignataires.coSignataire.dateRetraitCosignature · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
10editeBOOLEANdocument.coSignataires.coSignataire.edite · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
11organe_organe_refVARCHARdocument.coSignataires.coSignataire.organe.organeRef · présence : L17 0 %, L16 1 %, L15 1 %, L14 2 %
12organe_et_apparentesBOOLEANdocument.coSignataires.coSignataire.organe.etApparentes · présence : L17 0 %, L16 1 %, L15 1 %, L14 2 %

Aperçu

_id_source_legislature_racine_id_parent_id_ordreacteur_acteur_refdate_cosignaturedate_retrait_cosignatureediteorgane_organe_reforgane_et_apparentes
17060000008054L17/dossiers1717060000008052170600000080521PA7935082024-09-17False
17060000008055L17/dossiers1717060000008052170600000080522PA8410472024-09-17False
17060000008056L17/dossiers1717060000008052170600000080523PA3467822024-09-17False
17060000008057L17/dossiers1717060000008052170600000080524PA7192722024-09-17False
17060000008061L17/dossiers1717060000008059170600000080591PA7935082024-09-17False
17060000008062L17/dossiers1717060000008059170600000080592PA8410472024-09-17False
17060000008063L17/dossiers1717060000008059170600000080593PA3467822024-09-17False
17060000008064L17/dossiers1717060000008059170600000080594PA7192722024-09-17False
17060000008068L17/dossiers1717060000008066170600000080661PA7935082024-09-17False
17060000008069L17/dossiers1717060000008066170600000080662PA8410472024-09-17False
17060000008070L17/dossiers1717060000008066170600000080663PA7203862024-09-17False
17060000008071L17/dossiers1717060000008066170600000080664PA7192722024-09-17False
17060000008075L17/dossiers1717060000008073170600000080731PA7935082024-09-17False
17060000008076L17/dossiers1717060000008073170600000080732PA8410472024-09-17False
17060000008077L17/dossiers1717060000008073170600000080733PA3467822024-09-17False
17060000008078L17/dossiers1717060000008073170600000080734PA7192722024-09-17False
17060000008082L17/dossiers1717060000008080170600000080801PA7935082024-09-17False
17060000008083L17/dossiers1717060000008080170600000080802PA8410472024-09-17False
17060000008084L17/dossiers1717060000008080170600000080803PA13272024-09-17False
17060000008085L17/dossiers1717060000008080170600000080804PA7192722024-09-17False
17060000008089L17/dossiers1717060000008087170600000080871PA6428472025-02-17False
17060000008090L17/dossiers1717060000008087170600000080872PA7749542025-02-17False
17060000008091L17/dossiers1717060000008087170600000080873PA7214102025-02-17False
17060000008092L17/dossiers1717060000008087170600000080874PA7935082025-02-17False
17060000008093L17/dossiers1717060000008087170600000080875PA8410472025-02-17False
17060000008094L17/dossiers1717060000008087170600000080876PA7223902025-02-17False
17060000008095L17/dossiers1717060000008087170600000080877PA3325232024-09-172025-02-17False
17060000008096L17/dossiers1717060000008087170600000080878PA3309092025-02-17False
17060000008097L17/dossiers1717060000008087170600000080879PA7203862025-02-17False
17060000008098L17/dossiers17170600000080871706000000808710PA6088262025-02-17False
17060000008099L17/dossiers17170600000080871706000000808711PA13272025-02-17False
17060000008100L17/dossiers17170600000080871706000000808712PA2667972025-02-17False
17060000008101L17/dossiers17170600000080871706000000808713PA7940582025-02-17False
17060000008102L17/dossiers17170600000080871706000000808714PA6084162025-02-17False
17060000008103L17/dossiers17170600000080871706000000808715PA3467822025-02-17False
17060000008104L17/dossiers17170600000080871706000000808716PA7933422025-02-17False
17060000008105L17/dossiers17170600000080871706000000808717PA7192722025-02-17False
17060000008106L17/dossiers17170600000080871706000000808718PA7930942025-02-17False
17060000008107L17/dossiers17170600000080871706000000808719PA7941182025-02-17False
17060000008108L17/dossiers17170600000080871706000000808720PA6070902025-02-17False
17060000008112L17/dossiers1717060000008110170600000081101PA8419312024-10-07False
17060000008113L17/dossiers1717060000008110170600000081102PA2677632024-10-07False
17060000008114L17/dossiers1717060000008110170600000081103PA7947022024-10-07False
17060000008115L17/dossiers1717060000008110170600000081104PA7950502024-10-07False
17060000008116L17/dossiers1717060000008110170600000081105PA7209762024-10-07False
17060000008117L17/dossiers1717060000008110170600000081106PA8422272024-10-07False
17060000008118L17/dossiers1717060000008110170600000081107PA7200922024-10-07False
17060000008119L17/dossiers1717060000008110170600000081108PA7214862024-10-07False
17060000008120L17/dossiers1717060000008110170600000081109PA7195502024-10-07False
17060000008121L17/dossiers17170600000081101706000000811010PA7194362024-10-07False