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
17060000034713L17/dossiers1717060000034710170600000347102PA7952282025-04-17False
17060000034714L17/dossiers1717060000034710170600000347103PA7932622025-04-17False
17060000034715L17/dossiers1717060000034710170600000347104PA7949062025-04-17False
17060000034716L17/dossiers1717060000034710170600000347105PA7941382025-04-17False
17060000034717L17/dossiers1717060000034710170600000347106PA7955882025-04-17False
17060000034718L17/dossiers1717060000034710170600000347107PA7950842025-04-17False
17060000034719L17/dossiers1717060000034710170600000347108PA8421052025-04-17False
17060000034720L17/dossiers1717060000034710170600000347109PA8416572025-04-17False
17060000034721L17/dossiers17170600000347101706000003471010PA7204302025-04-17False
17060000034722L17/dossiers17170600000347101706000003471011PA7937722025-04-17False
17060000034723L17/dossiers17170600000347101706000003471012PA7956162025-04-17False
17060000034724L17/dossiers17170600000347101706000003471013PA7934442025-04-17False
17060000034725L17/dossiers17170600000347101706000003471014PA7949382025-04-17False
17060000034726L17/dossiers17170600000347101706000003471015PA7953182025-04-17False
17060000034727L17/dossiers17170600000347101706000003471016PA8410232025-04-17False
17060000034728L17/dossiers17170600000347101706000003471017PA7960902025-04-17False
17060000034729L17/dossiers17170600000347101706000003471018PA7939122025-04-17False
17060000034730L17/dossiers17170600000347101706000003471019PA8421872025-04-17False
17060000034731L17/dossiers17170600000347101706000003471020PA8420372025-04-17False
17060000034732L17/dossiers17170600000347101706000003471021PA7918122025-04-17False
17060000034733L17/dossiers17170600000347101706000003471022PA7937362025-04-17False
17060000034734L17/dossiers17170600000347101706000003471023PA7212022025-04-17False
17060000034735L17/dossiers17170600000347101706000003471024PA7951362025-04-17False
17060000034736L17/dossiers17170600000347101706000003471025PA7934642025-04-17False
17060000034737L17/dossiers17170600000347101706000003471026PA8421552025-04-17False
17060000034738L17/dossiers17170600000347101706000003471027PA7952002025-04-17False
17060000034739L17/dossiers17170600000347101706000003471028PA7958442025-04-17False
17060000034740L17/dossiers17170600000347101706000003471029PA8412512025-04-17False
17060000034741L17/dossiers17170600000347101706000003471030PA7947862025-04-17False
17060000034742L17/dossiers17170600000347101706000003471031PA7948702025-04-17False
17060000034743L17/dossiers17170600000347101706000003471032PA7960702025-04-17False
17060000034744L17/dossiers17170600000347101706000003471033PA7953102025-04-17False
17060000034745L17/dossiers17170600000347101706000003471034PA7944782025-04-17False
17060000034746L17/dossiers17170600000347101706000003471035PA8419472025-04-17False
17060000034747L17/dossiers17170600000347101706000003471036PA7940822025-04-17False
17060000034748L17/dossiers17170600000347101706000003471037PA7941302025-04-17False
17060000034749L17/dossiers17170600000347101706000003471038PA7208462025-04-17False
17060000034750L17/dossiers17170600000347101706000003471039PA8417292025-04-17False
17060000034751L17/dossiers17170600000347101706000003471040PA7955162025-04-17False
17060000034752L17/dossiers17170600000347101706000003471041PA7956722025-04-17False
17060000034753L17/dossiers17170600000347101706000003471042PA7957462025-04-17False
17060000034754L17/dossiers17170600000347101706000003471043PA7951082025-04-17False
17060000034755L17/dossiers17170600000347101706000003471044PA8415152025-04-17False
17060000034756L17/dossiers17170600000347101706000003471045PA7952982025-04-17False
17060000034757L17/dossiers17170600000347101706000003471046PA7918242025-04-17False
17060000034758L17/dossiers17170600000347101706000003471047PA8420292025-04-17False
17060000034759L17/dossiers17170600000347101706000003471048PA7935322025-04-17False
17060000034760L17/dossiers17170600000347101706000003471049PA7954222025-04-17False
17060000034761L17/dossiers17170600000347101706000003471050PA7946862025-04-17False
17060000034762L17/dossiers17170600000347101706000003471051PA8412152025-04-17False