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
17060000018718L17/dossiers17170600000186711706000001867146PA7937962025-06-04False
17060000018719L17/dossiers17170600000186711706000001867147PA7199302025-06-04False
17060000018720L17/dossiers17170600000186711706000001867148PA3421962025-06-04False
17060000018721L17/dossiers17170600000186711706000001867149PA8418852025-06-04False
17060000018722L17/dossiers17170600000186711706000001867150PA8412152025-06-04False
17060000018723L17/dossiers17170600000186711706000001867151PA2677942025-06-04False
17060000018724L17/dossiers17170600000186711706000001867152PA7941542025-06-04False
17060000018725L17/dossiers17170600000186711706000001867153PA7944862025-06-04False
17060000018726L17/dossiers17170600000186711706000001867154PA7221422025-06-04False
17060000018727L17/dossiers17170600000186711706000001867155PA8407652025-06-04False
17060000018728L17/dossiers17170600000186711706000001867156PA8409392025-06-04False
17060000018729L17/dossiers17170600000186711706000001867157PA7201002025-06-04False
17060000018730L17/dossiers17170600000186711706000001867158PA8421172025-06-04False
17060000018731L17/dossiers17170600000186711706000001867159PA8226172025-06-04False
17060000018732L17/dossiers17170600000186711706000001867160PA6431432025-06-04False
17060000018733L17/dossiers17170600000186711706000001867161PA6067932025-06-04False
17060000018734L17/dossiers17170600000186711706000001867162PA8422112025-06-04False
17060000018735L17/dossiers17170600000186711706000001867163PA7940942025-06-04False
17060000018736L17/dossiers17170600000186711706000001867164PA7936242025-06-04False
17060000018737L17/dossiers17170600000186711706000001867165PA7957622025-06-04False
17060000018738L17/dossiers17170600000186711706000001867166PA8409032025-06-04False
17060000018739L17/dossiers17170600000186711706000001867167PA8412952025-06-04False
17060000018740L17/dossiers17170600000186711706000001867168PA7954302025-06-04False
17060000018741L17/dossiers17170600000186711706000001867169PA8419192025-06-04False
17060000018742L17/dossiers17170600000186711706000001867170PA6065732025-06-04False
17060000018743L17/dossiers17170600000186711706000001867171PA7948542025-06-04False
17060000018744L17/dossiers17170600000186711706000001867172PA8421952025-06-04False
17060000018745L17/dossiers17170600000186711706000001867173PA3332852025-06-04False
17060000018746L17/dossiers17170600000186711706000001867174PA8415392025-06-04False
17060000018747L17/dossiers17170600000186711706000001867175PA15672025-06-04False
17060000018748L17/dossiers17170600000186711706000001867176PA8414712025-06-04False
17060000018749L17/dossiers17170600000186711706000001867177PA8422632025-06-04False
17060000018750L17/dossiers17170600000186711706000001867178PA16542025-06-04False
17060000018751L17/dossiers17170600000186711706000001867179PA8414632025-06-04False
17060000018752L17/dossiers17170600000186711706000001867180PA8411072025-06-04False
17060000018753L17/dossiers17170600000186711706000001867181PA8413812025-06-04False
17060000018754L17/dossiers17170600000186711706000001867182PA7942702025-06-04False
17060000018755L17/dossiers17170600000186711706000001867183PA6075532025-06-04False
17060000018756L17/dossiers17170600000186711706000001867184PA3419812025-06-04False
17060000018757L17/dossiers17170600000186711706000001867185PA8406732025-06-04False
17060000018758L17/dossiers17170600000186711706000001867186PA8266352025-06-04False
17060000018759L17/dossiers17170600000186711706000001867187PA8417172025-06-04False
17060000018760L17/dossiers17170600000186711706000001867188PA3403432025-06-04False
17060000018761L17/dossiers17170600000186711706000001867189PA8410912025-06-04False
17060000018762L17/dossiers17170600000186711706000001867190PA8416812025-06-04False
17060000018763L17/dossiers17170600000186711706000001867191PA8418932025-06-04False
17060000018764L17/dossiers17170600000186711706000001867192PA7938162025-06-04False
17060000018765L17/dossiers17170600000186711706000001867193PA7944942025-06-04False
17060000018766L17/dossiers17170600000186711706000001867194PA7209922025-06-04False
17060000018767L17/dossiers17170600000186711706000001867195PA7950262025-06-04False