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 264 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
17060000051935L17/dossiers17170600000519081706000005190826PA7952002025-12-02False
17060000051936L17/dossiers17170600000519081706000005190827PA7958442025-12-02False
17060000051937L17/dossiers17170600000519081706000005190828PA8412512025-12-02False
17060000051938L17/dossiers17170600000519081706000005190829PA7947862025-12-02False
17060000051939L17/dossiers17170600000519081706000005190830PA7948702025-12-02False
17060000051940L17/dossiers17170600000519081706000005190831PA7960702025-12-02False
17060000051941L17/dossiers17170600000519081706000005190832PA7953102025-12-02False
17060000051942L17/dossiers17170600000519081706000005190833PA7944782025-12-02False
17060000051943L17/dossiers17170600000519081706000005190834PA8419472025-12-02False
17060000051944L17/dossiers17170600000519081706000005190835PA7940822025-12-02False
17060000051945L17/dossiers17170600000519081706000005190836PA7941302025-12-02False
17060000051946L17/dossiers17170600000519081706000005190837PA7208462025-12-02False
17060000051947L17/dossiers17170600000519081706000005190838PA8417292025-12-02False
17060000051948L17/dossiers17170600000519081706000005190839PA7955162025-12-02False
17060000051949L17/dossiers17170600000519081706000005190840PA7956722025-12-02False
17060000051950L17/dossiers17170600000519081706000005190841PA8415152025-12-02False
17060000051951L17/dossiers17170600000519081706000005190842PA7957462025-12-02False
17060000051952L17/dossiers17170600000519081706000005190843PA7951082025-12-02False
17060000051953L17/dossiers17170600000519081706000005190844PA7952982025-12-02False
17060000051954L17/dossiers17170600000519081706000005190845PA7918242025-12-02False
17060000051955L17/dossiers17170600000519081706000005190846PA8420292025-12-02False
17060000051956L17/dossiers17170600000519081706000005190847PA7935322025-12-02False
17060000051957L17/dossiers17170600000519081706000005190848PA3423842025-12-02False
17060000051958L17/dossiers17170600000519081706000005190849PA7954222025-12-02False
17060000051959L17/dossiers17170600000519081706000005190850PA7946862025-12-02False
17060000051960L17/dossiers17170600000519081706000005190851PA8412152025-12-02False
17060000051961L17/dossiers17170600000519081706000005190852PA7954822025-12-02False
17060000051962L17/dossiers17170600000519081706000005190853PA6106542025-12-02False
17060000051963L17/dossiers17170600000519081706000005190854PA8411912025-12-02False
17060000051964L17/dossiers17170600000519081706000005190855PA7219602025-12-02False
17060000051965L17/dossiers17170600000519081706000005190856PA7938722025-12-02False
17060000051966L17/dossiers17170600000519081706000005190857PA8172112025-12-02False
17060000051967L17/dossiers17170600000519081706000005190858PA7937562025-12-02False
17060000051968L17/dossiers17170600000519081706000005190859PA7960622025-12-02False
17060000051969L17/dossiers17170600000519081706000005190860PA7195782025-12-02False
17060000051970L17/dossiers17170600000519081706000005190861PA7210622025-12-02False
17060000051971L17/dossiers17170600000519081706000005190862PA8418452025-12-02False
17060000051972L17/dossiers17170600000519081706000005190863PA7959822025-12-02False
17060000051973L17/dossiers17170600000519081706000005190864PA7954662025-12-02False
17060000051974L17/dossiers17170600000519081706000005190865PA7937442025-12-02False
17060000051975L17/dossiers17170600000519081706000005190866PA7209522025-12-02False
17060000051976L17/dossiers17170600000519081706000005190867PA7941062025-12-02False
17060000051977L17/dossiers17170600000519081706000005190868PA7941662025-12-02False
17060000051978L17/dossiers17170600000519081706000005190869PA7951642025-12-02False
17060000051979L17/dossiers17170600000519081706000005190870PA7955962025-12-02False
17060000051983L17/dossiers1717060000051981170600000519811PA7945622025-12-02False
17060000051984L17/dossiers1717060000051981170600000519812PA7932382025-12-02False
17060000051985L17/dossiers1717060000051981170600000519813PA7931582025-12-02False
17060000051986L17/dossiers1717060000051981170600000519814PA7944342025-12-02False
17060000051987L17/dossiers1717060000051981170600000519815PA8416452025-12-02False