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
17060000025741L17/dossiers17170600000257151706000002571525PA7212022025-02-05False
17060000025742L17/dossiers17170600000257151706000002571526PA7951362025-02-05False
17060000025743L17/dossiers17170600000257151706000002571527PA7934642025-02-05False
17060000025744L17/dossiers17170600000257151706000002571528PA8421552025-02-05False
17060000025745L17/dossiers17170600000257151706000002571529PA7952002025-02-05False
17060000025746L17/dossiers17170600000257151706000002571530PA7958442025-02-05False
17060000025747L17/dossiers17170600000257151706000002571531PA8412512025-02-05False
17060000025748L17/dossiers17170600000257151706000002571532PA7947862025-02-05False
17060000025749L17/dossiers17170600000257151706000002571533PA7960702025-02-05False
17060000025750L17/dossiers17170600000257151706000002571534PA7953102025-02-05False
17060000025751L17/dossiers17170600000257151706000002571535PA7944782025-02-05False
17060000025752L17/dossiers17170600000257151706000002571536PA8419472025-02-05False
17060000025753L17/dossiers17170600000257151706000002571537PA7940822025-02-05False
17060000025754L17/dossiers17170600000257151706000002571538PA7941302025-02-05False
17060000025755L17/dossiers17170600000257151706000002571539PA7208462025-02-05False
17060000025756L17/dossiers17170600000257151706000002571540PA8417292025-02-05False
17060000025757L17/dossiers17170600000257151706000002571541PA7955162025-02-05False
17060000025758L17/dossiers17170600000257151706000002571542PA7956722025-02-05False
17060000025759L17/dossiers17170600000257151706000002571543PA7957462025-02-05False
17060000025760L17/dossiers17170600000257151706000002571544PA7951082025-02-05False
17060000025761L17/dossiers17170600000257151706000002571545PA8415152025-02-05False
17060000025762L17/dossiers17170600000257151706000002571546PA7952982025-02-05False
17060000025763L17/dossiers17170600000257151706000002571547PA7918242025-02-05False
17060000025764L17/dossiers17170600000257151706000002571548PA8420292025-02-05False
17060000025765L17/dossiers17170600000257151706000002571549PA7935322025-02-05False
17060000025766L17/dossiers17170600000257151706000002571550PA3423842025-02-05False
17060000025767L17/dossiers17170600000257151706000002571551PA7954222025-02-05False
17060000025768L17/dossiers17170600000257151706000002571552PA7946862025-02-05False
17060000025769L17/dossiers17170600000257151706000002571553PA8412152025-02-05False
17060000025770L17/dossiers17170600000257151706000002571554PA7954822025-02-05False
17060000025771L17/dossiers17170600000257151706000002571555PA6106542025-02-05False
17060000025772L17/dossiers17170600000257151706000002571556PA8411912025-02-05False
17060000025773L17/dossiers17170600000257151706000002571557PA7219602025-02-05False
17060000025774L17/dossiers17170600000257151706000002571558PA7938722025-02-05False
17060000025775L17/dossiers17170600000257151706000002571559PA8172112025-02-05False
17060000025776L17/dossiers17170600000257151706000002571560PA7960622025-02-05False
17060000025777L17/dossiers17170600000257151706000002571561PA7195782025-02-05False
17060000025778L17/dossiers17170600000257151706000002571562PA7210622025-02-05False
17060000025779L17/dossiers17170600000257151706000002571563PA8418452025-02-05False
17060000025780L17/dossiers17170600000257151706000002571564PA7959822025-02-05False
17060000025781L17/dossiers17170600000257151706000002571565PA7209522025-02-05False
17060000025782L17/dossiers17170600000257151706000002571566PA7941062025-02-05False
17060000025783L17/dossiers17170600000257151706000002571567PA7941662025-02-05False
17060000025784L17/dossiers17170600000257151706000002571568PA7951642025-02-05False
17060000025785L17/dossiers17170600000257151706000002571569PA7955962025-02-05False
17060000025789L17/dossiers1717060000025787170600000257871PA7959502025-03-04False
17060000025790L17/dossiers1717060000025787170600000257872PA7211582025-03-04False
17060000025791L17/dossiers1717060000025787170600000257873PA7951442025-03-04False
17060000025792L17/dossiers1717060000025787170600000257874PA7221902025-03-04False
17060000025793L17/dossiers1717060000025787170600000257875PA6429352025-03-04False