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
17060000026987L17/dossiers17170600000269671706000002696719PA3423842025-02-18False
17060000026988L17/dossiers17170600000269671706000002696720PA8411912025-02-18False
17060000026989L17/dossiers17170600000269671706000002696721PA7951642025-02-18False
17060000026990L17/dossiers17170600000269671706000002696722PA7936642025-02-18False
17060000026991L17/dossiers17170600000269671706000002696723PA7932622025-02-18False
17060000026992L17/dossiers17170600000269671706000002696724PA8406652025-02-18False
17060000026993L17/dossiers17170600000269671706000002696725PA7941382025-02-18False
17060000026994L17/dossiers17170600000269671706000002696726PA6109682025-02-18False
17060000026995L17/dossiers17170600000269671706000002696727PA7955882025-02-18False
17060000026996L17/dossiers17170600000269671706000002696728PA7950842025-02-18False
17060000026997L17/dossiers17170600000269671706000002696729PA7937802025-02-18False
17060000026998L17/dossiers17170600000269671706000002696730PA5888842025-02-18False
17060000026999L17/dossiers17170600000269671706000002696731PA8417012025-02-18False
17060000027000L17/dossiers17170600000269671706000002696732PA3359992025-02-18False
17060000027001L17/dossiers17170600000269671706000002696733PA8416572025-02-18False
17060000027002L17/dossiers17170600000269671706000002696734PA7954542025-02-18False
17060000027003L17/dossiers17170600000269671706000002696735PA7937722025-02-18False
17060000027004L17/dossiers17170600000269671706000002696736PA7956162025-02-18False
17060000027005L17/dossiers17170600000269671706000002696737PA7934442025-02-18False
17060000027006L17/dossiers17170600000269671706000002696738PA8418852025-02-18False
17060000027007L17/dossiers17170600000269671706000002696739PA8415072025-02-18False
17060000027008L17/dossiers17170600000269671706000002696740PA7940942025-02-18False
17060000027009L17/dossiers17170600000269671706000002696741PA7949382025-02-18False
17060000027010L17/dossiers17170600000269671706000002696742PA7936242025-02-18False
17060000027011L17/dossiers17170600000269671706000002696743PA8410232025-02-18False
17060000027012L17/dossiers17170600000269671706000002696744PA7939122025-02-18False
17060000027013L17/dossiers17170600000269671706000002696745PA8421872025-02-18False
17060000027014L17/dossiers17170600000269671706000002696746PA8420372025-02-18False
17060000027015L17/dossiers17170600000269671706000002696747PA7918122025-02-18False
17060000027016L17/dossiers17170600000269671706000002696748PA7212022025-02-18False
17060000027017L17/dossiers17170600000269671706000002696749PA7212102025-02-18False
17060000027018L17/dossiers17170600000269671706000002696750PA7951362025-02-18False
17060000027019L17/dossiers17170600000269671706000002696751PA7934522025-02-18False
17060000027020L17/dossiers17170600000269671706000002696752PA7933942025-02-18False
17060000027021L17/dossiers17170600000269671706000002696753PA7952002025-02-18False
17060000027022L17/dossiers17170600000269671706000002696754PA8413512025-02-18False
17060000027023L17/dossiers17170600000269671706000002696755PA7948542025-02-18False
17060000027024L17/dossiers17170600000269671706000002696756PA7958442025-02-18False
17060000027025L17/dossiers17170600000269671706000002696757PA7218962025-02-18False
17060000027026L17/dossiers17170600000269671706000002696758PA8412512025-02-18False
17060000027027L17/dossiers17170600000269671706000002696759PA7947862025-02-18False
17060000027028L17/dossiers17170600000269671706000002696760PA7948702025-02-18False
17060000027029L17/dossiers17170600000269671706000002696761PA7939802025-02-18False
17060000027030L17/dossiers17170600000269671706000002696762PA7960702025-02-18False
17060000027031L17/dossiers17170600000269671706000002696763PA7950102025-02-18False
17060000027032L17/dossiers17170600000269671706000002696764PA8414192025-02-18False
17060000027033L17/dossiers17170600000269671706000002696765PA8415392025-02-18False
17060000027034L17/dossiers17170600000269671706000002696766PA7953102025-02-18False
17060000027035L17/dossiers17170600000269671706000002696767PA8420132025-02-18False
17060000027036L17/dossiers17170600000269671706000002696768PA8419472025-02-18False