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
17060000047984L17/dossiers17170600000479451706000004794538PA8417292026-07-27False
17060000047985L17/dossiers17170600000479451706000004794539PA7955162026-07-27False
17060000047986L17/dossiers17170600000479451706000004794540PA7956722026-07-27False
17060000047987L17/dossiers17170600000479451706000004794541PA8415152026-07-27False
17060000047988L17/dossiers17170600000479451706000004794542PA7957462026-07-27False
17060000047989L17/dossiers17170600000479451706000004794543PA7951082026-07-27False
17060000047990L17/dossiers17170600000479451706000004794544PA7952982026-07-27False
17060000047991L17/dossiers17170600000479451706000004794545PA7918242026-07-27False
17060000047992L17/dossiers17170600000479451706000004794546PA8420292026-07-27False
17060000047993L17/dossiers17170600000479451706000004794547PA7935322026-07-27False
17060000047994L17/dossiers17170600000479451706000004794548PA3423842026-07-27False
17060000047995L17/dossiers17170600000479451706000004794549PA7954222026-07-27False
17060000047996L17/dossiers17170600000479451706000004794550PA7946862026-07-27False
17060000047997L17/dossiers17170600000479451706000004794551PA8412152026-07-27False
17060000047998L17/dossiers17170600000479451706000004794552PA7954822026-07-27False
17060000047999L17/dossiers17170600000479451706000004794553PA6106542026-07-27False
17060000048000L17/dossiers17170600000479451706000004794554PA8411912026-07-27False
17060000048001L17/dossiers17170600000479451706000004794555PA7219602026-07-27False
17060000048002L17/dossiers17170600000479451706000004794556PA7938722026-07-27False
17060000048003L17/dossiers17170600000479451706000004794557PA7208922026-07-27False
17060000048004L17/dossiers17170600000479451706000004794558PA8172112026-07-27False
17060000048005L17/dossiers17170600000479451706000004794559PA7937562026-07-27False
17060000048006L17/dossiers17170600000479451706000004794560PA7960622026-07-27False
17060000048007L17/dossiers17170600000479451706000004794561PA7195782026-07-27False
17060000048008L17/dossiers17170600000479451706000004794562PA7210622026-07-27False
17060000048009L17/dossiers17170600000479451706000004794563PA8418452026-07-27False
17060000048010L17/dossiers17170600000479451706000004794564PA7959822026-07-27False
17060000048011L17/dossiers17170600000479451706000004794565PA7954662026-07-27False
17060000048012L17/dossiers17170600000479451706000004794566PA7937442026-07-27False
17060000048013L17/dossiers17170600000479451706000004794567PA7209522026-07-27False
17060000048014L17/dossiers17170600000479451706000004794568PA7941062026-07-27False
17060000048015L17/dossiers17170600000479451706000004794569PA7941662026-07-27False
17060000048016L17/dossiers17170600000479451706000004794570PA7951642026-07-27False
17060000048017L17/dossiers17170600000479451706000004794571PA7955962026-07-27False
17060000048018L17/dossiers17170600000479451706000004794572PA8414192026-07-27False
17060000048019L17/dossiers17170600000479451706000004794573PA7936642026-07-27False
17060000048020L17/dossiers17170600000479451706000004794574PA7958082026-07-27False
17060000048021L17/dossiers17170600000479451706000004794575PA8416332026-07-27False
17060000048022L17/dossiers17170600000479451706000004794576PA7950762026-07-27False
17060000048026L17/dossiers1717060000048024170600000480241PA8408292026-01-19False
17060000048027L17/dossiers1717060000048024170600000480242PA7940942026-01-19False
17060000048028L17/dossiers1717060000048024170600000480243PA6082642026-01-19False
17060000048029L17/dossiers1717060000048024170600000480244PA10082026-01-19False
17060000048030L17/dossiers1717060000048024170600000480245PA7948542026-01-19False
17060000048031L17/dossiers1717060000048024170600000480246PA8409392026-01-19False
17060000048032L17/dossiers1717060000048024170600000480247PA3319732026-01-19False
17060000048033L17/dossiers1717060000048024170600000480248PA8414632026-01-19False
17060000048034L17/dossiers1717060000048024170600000480249PA6081722026-01-19False
17060000048035L17/dossiers17170600000480241706000004802410PA3419812026-01-19False
17060000048036L17/dossiers17170600000480241706000004802411PA8416812026-01-19False