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
17060000036698L17/dossiers17170600000366371706000003663760PA8416812026-03-24False
17060000036699L17/dossiers17170600000366371706000003663761PA8418932026-03-24False
17060000036700L17/dossiers17170600000366371706000003663762PA7938162026-03-24False
17060000036701L17/dossiers17170600000366371706000003663763PA7199302026-03-24False
17060000036702L17/dossiers17170600000366371706000003663764PA7944942026-03-24False
17060000036703L17/dossiers17170600000366371706000003663765PA7209922026-03-24False
17060000036704L17/dossiers17170600000366371706000003663766PA7214742026-03-24False
17060000036705L17/dossiers17170600000366371706000003663767PA29402026-03-24False
17060000036706L17/dossiers17170600000366371706000003663768PA2677632025-05-272025-06-02False
17060000036707L17/dossiers17170600000366371706000003663769PA7952402026-03-24False
17060000036708L17/dossiers17170600000366371706000003663770PA8408172025-05-272025-06-02False
17060000036709L17/dossiers17170600000366371706000003663771PA6056942026-03-24False
17060000036710L17/dossiers17170600000366371706000003663772PA7191382025-05-272025-06-02False
17060000036711L17/dossiers17170600000366371706000003663773PA7945542025-05-272025-06-02False
17060000036712L17/dossiers17170600000366371706000003663774PA8413592026-03-24False
17060000036713L17/dossiers17170600000366371706000003663775PA6076192026-03-24False
17060000036714L17/dossiers17170600000366371706000003663776PA7192862025-05-272025-06-02False
17060000036715L17/dossiers17170600000366371706000003663777PA9422025-05-272025-06-02False
17060000036716L17/dossiers17170600000366371706000003663778PA7950262026-03-24False
17060000036717L17/dossiers17170600000366371706000003663779PA2670422025-05-272025-06-02False
17060000036718L17/dossiers17170600000366371706000003663780PA7946582026-03-24False
17060000036719L17/dossiers17170600000366371706000003663781PA6774832026-03-24False
17060000036720L17/dossiers17170600000366371706000003663782PA8226172025-05-272025-06-02False
17060000036721L17/dossiers17170600000366371706000003663783PA15922025-05-272025-06-02False
17060000036722L17/dossiers17170600000366371706000003663784PA7221502026-03-24False
17060000036723L17/dossiers17170600000366371706000003663785PA7222522026-03-24False
17060000036724L17/dossiers17170600000366371706000003663786PA8410172025-05-272025-06-02False
17060000036725L17/dossiers17170600000366371706000003663787PA7952002026-03-24False
17060000036726L17/dossiers17170600000366371706000003663788PA7952442025-05-272025-06-02False
17060000036727L17/dossiers17170600000366371706000003663789PA7209762025-05-272025-06-02False
17060000036728L17/dossiers17170600000366371706000003663790PA8416572026-03-24False
17060000036729L17/dossiers17170600000366371706000003663791PA7955882026-03-24False
17060000036730L17/dossiers17170600000366371706000003663792PA8419312025-05-272025-06-02False
17060000036731L17/dossiers17170600000366371706000003663793PA7214862025-05-272025-06-02False
17060000036732L17/dossiers17170600000366371706000003663794PA7918242026-03-24False
17060000036733L17/dossiers17170600000366371706000003663795PA7932102025-05-272025-06-02False
17060000036734L17/dossiers17170600000366371706000003663796PA7947862026-03-24False
17060000036735L17/dossiers17170600000366371706000003663797PA7211102025-05-272025-06-02False
17060000036736L17/dossiers17170600000366371706000003663798PA8421872026-03-24False
17060000036737L17/dossiers17170600000366371706000003663799PA7209602025-05-272025-06-02False
17060000036738L17/dossiers171706000003663717060000036637100PA7953102026-03-24False
17060000036739L17/dossiers171706000003663717060000036637101PA7937962025-05-272025-06-02False
17060000036740L17/dossiers171706000003663717060000036637102PA7941062026-03-24False
17060000036741L17/dossiers171706000003663717060000036637103PA29522025-05-272025-06-02False
17060000036742L17/dossiers171706000003663717060000036637104PA7940822026-03-24False
17060000036743L17/dossiers171706000003663717060000036637105PA7955162026-03-24False
17060000036744L17/dossiers171706000003663717060000036637106PA7960782025-05-272025-06-02False
17060000036745L17/dossiers171706000003663717060000036637107PA7951362026-03-24False
17060000036746L17/dossiers171706000003663717060000036637108PA7941662026-03-24False
17060000036747L17/dossiers171706000003663717060000036637109PA7954222026-03-24False