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
17060000039898L17/dossiers17170600000398761706000003987621PA7958082025-09-12False
17060000039899L17/dossiers17170600000398761706000003987622PA6082642025-09-12False
17060000039900L17/dossiers17170600000398761706000003987623PA6065452025-09-12False
17060000039901L17/dossiers17170600000398761706000003987624PA8414632025-09-12False
17060000039902L17/dossiers17170600000398761706000003987625PA7960182025-09-12False
17060000039918L17/dossiers1717060000039916170600000399161PA7188842025-06-30False
17060000039919L17/dossiers1717060000039916170600000399162PA7199682025-06-30False
17060000039920L17/dossiers1717060000039916170600000399163PA7188502025-06-30False
17060000039921L17/dossiers1717060000039916170600000399164PA7223902025-06-30False
17060000039922L17/dossiers1717060000039916170600000399165PA3325232025-06-30False
17060000039923L17/dossiers1717060000039916170600000399166PA8409792025-06-30False
17060000039924L17/dossiers1717060000039916170600000399167PA6427252025-06-30False
17060000039925L17/dossiers1717060000039916170600000399168PA7187842025-06-30False
17060000039926L17/dossiers1717060000039916170600000399169PA7214422025-06-30False
17060000039927L17/dossiers17170600000399161706000003991610PA7941782025-06-30False
17060000039928L17/dossiers17170600000399161706000003991611PA6428472025-06-30False
17060000039929L17/dossiers17170600000399161706000003991612PA3467822025-06-30False
17060000039930L17/dossiers17170600000399161706000003991613PA6088262025-06-30False
17060000039931L17/dossiers17170600000399161706000003991614PA16302025-06-30False
17060000039935L17/dossiers1717060000039933170600000399331PA7208922025-06-24False
17060000039936L17/dossiers1717060000039933170600000399332PA7952282025-06-24False
17060000039937L17/dossiers1717060000039933170600000399333PA7932622025-06-24False
17060000039938L17/dossiers1717060000039933170600000399334PA7949062025-06-24False
17060000039939L17/dossiers1717060000039933170600000399335PA7941382025-06-24False
17060000039940L17/dossiers1717060000039933170600000399336PA7955882025-06-24False
17060000039941L17/dossiers1717060000039933170600000399337PA7950842025-06-24False
17060000039942L17/dossiers1717060000039933170600000399338PA8421052025-06-24False
17060000039943L17/dossiers1717060000039933170600000399339PA8416572025-06-24False
17060000039944L17/dossiers17170600000399331706000003993310PA7204302025-06-24False
17060000039945L17/dossiers17170600000399331706000003993311PA7937722025-06-24False
17060000039946L17/dossiers17170600000399331706000003993312PA7956162025-06-24False
17060000039947L17/dossiers17170600000399331706000003993313PA7934442025-06-24False
17060000039948L17/dossiers17170600000399331706000003993314PA7949382025-06-24False
17060000039949L17/dossiers17170600000399331706000003993315PA7953182025-06-24False
17060000039950L17/dossiers17170600000399331706000003993316PA8410232025-06-24False
17060000039951L17/dossiers17170600000399331706000003993317PA7960902025-06-24False
17060000039952L17/dossiers17170600000399331706000003993318PA7939122025-06-24False
17060000039953L17/dossiers17170600000399331706000003993319PA8421872025-06-24False
17060000039954L17/dossiers17170600000399331706000003993320PA8420372025-06-24False
17060000039955L17/dossiers17170600000399331706000003993321PA7918122025-06-24False
17060000039956L17/dossiers17170600000399331706000003993322PA7937362025-06-24False
17060000039957L17/dossiers17170600000399331706000003993323PA7212022025-06-24False
17060000039958L17/dossiers17170600000399331706000003993324PA7951362025-06-24False
17060000039959L17/dossiers17170600000399331706000003993325PA7934642025-06-24False
17060000039960L17/dossiers17170600000399331706000003993326PA8421552025-06-24False
17060000039961L17/dossiers17170600000399331706000003993327PA7952002025-06-24False
17060000039962L17/dossiers17170600000399331706000003993328PA7958442025-06-24False
17060000039963L17/dossiers17170600000399331706000003993329PA8412512025-06-24False
17060000039964L17/dossiers17170600000399331706000003993330PA7947862025-06-24False
17060000039965L17/dossiers17170600000399331706000003993331PA7948702025-06-24False