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
17060000030156L17/dossiers17170600000300691706000003006986PA8416332025-05-02False
17060000030157L17/dossiers17170600000300691706000003006987PA8417132025-05-02False
17060000030158L17/dossiers17170600000300691706000003006988PA8415072025-05-02False
17060000030159L17/dossiers17170600000300691706000003006989PA8414712025-05-02False
17060000030160L17/dossiers17170600000300691706000003006990PA8422632025-05-02False
17060000030161L17/dossiers17170600000300691706000003006991PA7941462025-05-02False
17060000030162L17/dossiers17170600000300691706000003006992PA8407652025-05-02False
17060000030163L17/dossiers17170600000300691706000003006993PA7940942025-05-02False
17060000030164L17/dossiers17170600000300691706000003006994PA8413592025-05-02False
17060000030165L17/dossiers17170600000300691706000003006995PA8418132025-05-02False
17060000030178L17/dossiers1717060000030176170600000301761PA7199302025-03-27False
17060000030179L17/dossiers1717060000030176170600000301762PA6082642025-03-27False
17060000030180L17/dossiers1717060000030176170600000301763PA8407932025-03-27False
17060000030181L17/dossiers1717060000030176170600000301764PA8418932025-03-27False
17060000030182L17/dossiers1717060000030176170600000301765PA6109682025-03-27False
17060000030183L17/dossiers1717060000030176170600000301766PA8417012025-03-27False
17060000030184L17/dossiers1717060000030176170600000301767PA10082025-03-27False
17060000030185L17/dossiers1717060000030176170600000301768PA8401712025-03-27False
17060000030186L17/dossiers1717060000030176170600000301769PA8406732025-03-27False
17060000030187L17/dossiers17170600000301761706000003017610PA7948022025-03-27False
17060000030188L17/dossiers17170600000301761706000003017611PA6427642025-03-27False
17060000030189L17/dossiers17170600000301761706000003017612PA8408292025-03-27False
17060000030190L17/dossiers17170600000301761706000003017613PA7940942025-03-27False
17060000030191L17/dossiers17170600000301761706000003017614PA7957622025-03-27False
17060000030192L17/dossiers17170600000301761706000003017615PA8412952025-03-27False
17060000030193L17/dossiers17170600000301761706000003017616PA7933942025-03-27False
17060000030194L17/dossiers17170600000301761706000003017617PA6065732025-03-27False
17060000030195L17/dossiers17170600000301761706000003017618PA7948542025-03-27False
17060000030196L17/dossiers17170600000301761706000003017619PA6093322025-03-27False
17060000030197L17/dossiers17170600000301761706000003017620PA8416652025-03-27False
17060000030198L17/dossiers17170600000301761706000003017621PA3319732025-03-27False
17060000030199L17/dossiers17170600000301761706000003017622PA7212962025-03-27False
17060000030200L17/dossiers17170600000301761706000003017623PA8414712025-03-27False
17060000030201L17/dossiers17170600000301761706000003017624PA8422632025-03-27False
17060000030202L17/dossiers17170600000301761706000003017625PA8418532025-03-27False
17060000030203L17/dossiers17170600000301761706000003017626PA6431922025-03-27False
17060000030204L17/dossiers17170600000301761706000003017627PA8422712025-03-27False
17060000030205L17/dossiers17170600000301761706000003017628PA8419312025-03-27False
17060000030206L17/dossiers17170600000301761706000003017629PA8414632025-03-27False
17060000030207L17/dossiers17170600000301761706000003017630PA6076192025-03-27False
17060000030208L17/dossiers17170600000301761706000003017631PA8411072025-03-27False
17060000030209L17/dossiers17170600000301761706000003017632PA8413812025-03-27False
17060000030210L17/dossiers17170600000301761706000003017633PA7942702025-03-27False
17060000030211L17/dossiers17170600000301761706000003017634PA6081722025-03-27False
17060000030212L17/dossiers17170600000301761706000003017635PA6075532025-03-27False
17060000030213L17/dossiers17170600000301761706000003017636PA3421962025-03-27False
17060000030214L17/dossiers17170600000301761706000003017637PA8417172025-03-27False
17060000030215L17/dossiers17170600000301761706000003017638PA7938162025-03-27False
17060000030219L17/dossiers1717060000030217170600000302171PA2677632025-03-17False
17060000030220L17/dossiers1717060000030217170600000302172PA6428472025-03-17False