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
17060000049631L17/dossiers17170600000495451706000004954585PA8406732026-02-12False
17060000049632L17/dossiers17170600000495451706000004954586PA3421962026-02-12False
17060000049633L17/dossiers17170600000495451706000004954587PA8266352026-02-12False
17060000049634L17/dossiers17170600000495451706000004954588PA8413272026-02-12False
17060000049635L17/dossiers17170600000495451706000004954589PA8417172026-02-12False
17060000049636L17/dossiers17170600000495451706000004954590PA8412432026-02-12False
17060000049637L17/dossiers17170600000495451706000004954591PA7749602026-02-12False
17060000049638L17/dossiers17170600000495451706000004954592PA3403432026-02-12False
17060000049639L17/dossiers17170600000495451706000004954593PA8416812026-02-12False
17060000049640L17/dossiers17170600000495451706000004954594PA8418932026-02-12False
17060000049641L17/dossiers17170600000495451706000004954595PA7938162026-02-12False
17060000049642L17/dossiers17170600000495451706000004954596PA7199302026-02-12False
17060000049643L17/dossiers17170600000495451706000004954597PA7953502026-02-12False
17060000049644L17/dossiers17170600000495451706000004954598PA7944942026-02-12False
17060000049645L17/dossiers17170600000495451706000004954599PA7195122026-02-12False
17060000049646L17/dossiers171706000004954517060000049545100PA7209922026-02-12False
17060000049650L17/dossiers1717060000049648170600000496481PA7199302026-01-07False
17060000049651L17/dossiers1717060000049648170600000496482PA8406652026-01-07False
17060000049652L17/dossiers1717060000049648170600000496483PA7954302026-01-07False
17060000049653L17/dossiers1717060000049648170600000496484PA8419192026-01-07False
17060000049654L17/dossiers1717060000049648170600000496485PA6065732026-01-07False
17060000049655L17/dossiers1717060000049648170600000496486PA8416332026-01-07False
17060000049656L17/dossiers1717060000049648170600000496487PA7948542026-01-07False
17060000049657L17/dossiers1717060000049648170600000496488PA8421952026-01-07False
17060000049658L17/dossiers1717060000049648170600000496489PA6093322026-01-07False
17060000049659L17/dossiers17170600000496481706000004964810PA8416652026-01-07False
17060000049660L17/dossiers17170600000496481706000004964811PA8226172026-01-07False
17060000049661L17/dossiers17170600000496481706000004964812PA3332852026-01-07False
17060000049662L17/dossiers17170600000496481706000004964813PA8409392026-01-07False
17060000049663L17/dossiers17170600000496481706000004964814PA3319732026-01-07False
17060000049664L17/dossiers17170600000496481706000004964815PA8401712026-01-07False
17060000049665L17/dossiers17170600000496481706000004964816PA15672026-01-07False
17060000049666L17/dossiers17170600000496481706000004964817PA8414712026-01-07False
17060000049667L17/dossiers17170600000496481706000004964818PA8422632026-01-07False
17060000049668L17/dossiers17170600000496481706000004964819PA8418132026-01-07False
17060000049669L17/dossiers17170600000496481706000004964820PA8418532026-01-07False
17060000049670L17/dossiers17170600000496481706000004964821PA16542026-01-07False
17060000049671L17/dossiers17170600000496481706000004964822PA7221502026-01-07False
17060000049672L17/dossiers17170600000496481706000004964823PA6431922026-01-07False
17060000049673L17/dossiers17170600000496481706000004964824PA3350542026-01-07False
17060000049674L17/dossiers17170600000496481706000004964825PA7951562026-01-07False
17060000049675L17/dossiers17170600000496481706000004964826PA7749582026-01-07False
17060000049676L17/dossiers17170600000496481706000004964827PA8407652026-01-07False
17060000049677L17/dossiers17170600000496481706000004964828PA8414632026-01-07False
17060000049678L17/dossiers17170600000496481706000004964829PA6431572026-01-07False
17060000049679L17/dossiers17170600000496481706000004964830PA8411072026-01-07False
17060000049680L17/dossiers17170600000496481706000004964831PA8413812026-01-07False
17060000049681L17/dossiers17170600000496481706000004964832PA8407932026-01-07False
17060000049682L17/dossiers17170600000496481706000004964833PA7942702026-01-07False
17060000049683L17/dossiers17170600000496481706000004964834PA6081722026-01-07False