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
17060000020915L17/dossiers171706000002081417060000020814100PA3403432025-03-24False
17060000020916L17/dossiers171706000002081417060000020814101PA7947862025-03-24False
17060000020917L17/dossiers171706000002081417060000020814102PA8417012025-03-24False
17060000020918L17/dossiers171706000002081417060000020814103PA7205602025-03-24False
17060000020919L17/dossiers171706000002081417060000020814104PA7932102025-03-24False
17060000020920L17/dossiers171706000002081417060000020814105PA8422712025-03-24False
17060000020921L17/dossiers171706000002081417060000020814106PA8402352025-03-24False
17060000020922L17/dossiers171706000002081417060000020814107PA7223902025-03-24False
17060000020923L17/dossiers171706000002081417060000020814108PA8413272025-03-24False
17060000020924L17/dossiers171706000002081417060000020814109PA7948702025-03-24False
17060000020925L17/dossiers171706000002081417060000020814110PA7953622025-03-24False
17060000020926L17/dossiers171706000002081417060000020814111PA7200382025-03-24False
17060000020927L17/dossiers171706000002081417060000020814112PA7958202025-03-24False
17060000020928L17/dossiers171706000002081417060000020814113PA8416932025-03-24False
17060000020929L17/dossiers171706000002081417060000020814114PA3309092025-03-24False
17060000020930L17/dossiers171706000002081417060000020814115PA8406732025-03-24False
17060000020931L17/dossiers171706000002081417060000020814116PA7209522025-03-24False
17060000020932L17/dossiers171706000002081417060000020814117PA7954542025-03-24False
17060000020933L17/dossiers171706000002081417060000020814118PA7219842025-03-24False
17060000020934L17/dossiers171706000002081417060000020814119PA7212702025-03-24False
17060000020935L17/dossiers171706000002081417060000020814120PA7957222025-03-24False
17060000020936L17/dossiers171706000002081417060000020814121PA6088262025-03-24False
17060000020937L17/dossiers171706000002081417060000020814122PA8409552025-03-24False
17060000020938L17/dossiers171706000002081417060000020814123PA7941062025-03-24False
17060000020939L17/dossiers171706000002081417060000020814124PA8409972025-03-24False
17060000020940L17/dossiers171706000002081417060000020814125PA7947022025-03-24False
17060000020941L17/dossiers171706000002081417060000020814126PA7952402025-03-24False
17060000020942L17/dossiers171706000002081417060000020814127PA7196322025-03-24False
17060000020943L17/dossiers171706000002081417060000020814128PA16302025-03-24False
17060000020944L17/dossiers171706000002081417060000020814129PA6081722025-03-24False
17060000020945L17/dossiers171706000002081417060000020814130PA7952282025-03-24False
17060000020946L17/dossiers171706000002081417060000020814131PA8418852025-03-24False
17060000020947L17/dossiers171706000002081417060000020814132PA7941142025-03-24False
17060000020948L17/dossiers171706000002081417060000020814133PA7958762025-03-24False
17060000020949L17/dossiers171706000002081417060000020814134PA8409792025-03-24False
17060000020950L17/dossiers171706000002081417060000020814135PA7749582025-03-24False
17060000020951L17/dossiers171706000002081417060000020814136PA7949062025-03-24False
17060000020952L17/dossiers171706000002081417060000020814137PA8415072025-03-24False
17060000020953L17/dossiers171706000002081417060000020814138PA7948302025-03-24False
17060000020954L17/dossiers171706000002081417060000020814139PA8422992025-03-24False
17060000020955L17/dossiers171706000002081417060000020814140PA6955122025-03-24False
17060000020956L17/dossiers171706000002081417060000020814141PA3350542025-03-24False
17060000020957L17/dossiers171706000002081417060000020814142PA7941382025-03-24False
17060000020958L17/dossiers171706000002081417060000020814143PA7940082025-03-24False
17060000020959L17/dossiers171706000002081417060000020814144PA7207202025-03-24False
17060000020960L17/dossiers171706000002081417060000020814145PA7961062025-03-24False
17060000020961L17/dossiers171706000002081417060000020814146PA7192722025-03-24False
17060000020962L17/dossiers171706000002081417060000020814147PA8422632025-03-24False
17060000020963L17/dossiers171706000002081417060000020814148PA7955882025-03-24False
17060000020964L17/dossiers171706000002081417060000020814149PA7212102025-03-24False