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
17060000046970L17/dossiers17170600000469311706000004693138PA7208462025-09-30False
17060000046971L17/dossiers17170600000469311706000004693139PA8417292025-09-30False
17060000046972L17/dossiers17170600000469311706000004693140PA7955162025-09-30False
17060000046973L17/dossiers17170600000469311706000004693141PA7956722025-09-30False
17060000046974L17/dossiers17170600000469311706000004693142PA7957462025-09-30False
17060000046975L17/dossiers17170600000469311706000004693143PA7951082025-09-30False
17060000046976L17/dossiers17170600000469311706000004693144PA8415152025-09-30False
17060000046977L17/dossiers17170600000469311706000004693145PA7952982025-09-30False
17060000046978L17/dossiers17170600000469311706000004693146PA7918242025-09-30False
17060000046979L17/dossiers17170600000469311706000004693147PA8420292025-09-30False
17060000046980L17/dossiers17170600000469311706000004693148PA7935322025-09-30False
17060000046981L17/dossiers17170600000469311706000004693149PA3423842025-09-30False
17060000046982L17/dossiers17170600000469311706000004693150PA7954222025-09-30False
17060000046983L17/dossiers17170600000469311706000004693151PA7946862025-09-30False
17060000046984L17/dossiers17170600000469311706000004693152PA8412152025-09-30False
17060000046985L17/dossiers17170600000469311706000004693153PA7954822025-09-30False
17060000046986L17/dossiers17170600000469311706000004693154PA6106542025-09-30False
17060000046987L17/dossiers17170600000469311706000004693155PA8411912025-09-30False
17060000046988L17/dossiers17170600000469311706000004693156PA7219602025-09-30False
17060000046989L17/dossiers17170600000469311706000004693157PA7938722025-09-30False
17060000046990L17/dossiers17170600000469311706000004693158PA8172112025-09-30False
17060000046991L17/dossiers17170600000469311706000004693159PA7937562025-09-30False
17060000046992L17/dossiers17170600000469311706000004693160PA7960622025-09-30False
17060000046993L17/dossiers17170600000469311706000004693161PA7195782025-09-30False
17060000046994L17/dossiers17170600000469311706000004693162PA7210622025-09-30False
17060000046995L17/dossiers17170600000469311706000004693163PA8418452025-09-30False
17060000046996L17/dossiers17170600000469311706000004693164PA7959822025-09-30False
17060000046997L17/dossiers17170600000469311706000004693165PA7937442025-09-30False
17060000046998L17/dossiers17170600000469311706000004693166PA7209522025-09-30False
17060000046999L17/dossiers17170600000469311706000004693167PA7941062025-09-30False
17060000047000L17/dossiers17170600000469311706000004693168PA7941662025-09-30False
17060000047001L17/dossiers17170600000469311706000004693169PA7951642025-09-30False
17060000047002L17/dossiers17170600000469311706000004693170PA7955962025-09-30False
17060000047006L17/dossiers1717060000047004170600000470041PA7212962025-10-30False
17060000047007L17/dossiers1717060000047004170600000470042PA2677632025-10-30False
17060000047008L17/dossiers1717060000047004170600000470043PA7214262025-10-30False
17060000047009L17/dossiers1717060000047004170600000470044PA6082642025-10-30False
17060000047010L17/dossiers1717060000047004170600000470045PA8407652025-10-30False
17060000047011L17/dossiers1717060000047004170600000470046PA29402025-10-30False
17060000047012L17/dossiers1717060000047004170600000470047PA7943302025-10-30False
17060000047013L17/dossiers1717060000047004170600000470048PA7222522025-10-30False
17060000047014L17/dossiers1717060000047004170600000470049PA7949822025-10-30False
17060000047015L17/dossiers17170600000470041706000004700410PA7193382025-10-30False
17060000047016L17/dossiers17170600000470041706000004700411PA7950262025-10-30False
17060000047017L17/dossiers17170600000470041706000004700412PA7214742025-10-30False
17060000047018L17/dossiers17170600000470041706000004700413PA8409972025-10-30False
17060000047019L17/dossiers17170600000470041706000004700414PA8413592025-10-30False
17060000047020L17/dossiers17170600000470041706000004700415PA7200922025-10-30False
17060000047021L17/dossiers17170600000470041706000004700416PA8416652025-10-30False
17060000047022L17/dossiers17170600000470041706000004700417PA7220002025-10-30False