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
17060000019887L17/dossiers17170600000198251706000001982561PA7960622025-05-14False
17060000019888L17/dossiers17170600000198251706000001982562PA7195782025-05-14False
17060000019889L17/dossiers17170600000198251706000001982563PA7210622025-05-14False
17060000019890L17/dossiers17170600000198251706000001982564PA8418452025-05-14False
17060000019891L17/dossiers17170600000198251706000001982565PA7959822025-05-14False
17060000019892L17/dossiers17170600000198251706000001982566PA7954662025-05-14False
17060000019893L17/dossiers17170600000198251706000001982567PA7937442025-05-14False
17060000019894L17/dossiers17170600000198251706000001982568PA7209522025-05-14False
17060000019895L17/dossiers17170600000198251706000001982569PA7941062025-05-14False
17060000019896L17/dossiers17170600000198251706000001982570PA7941662025-05-14False
17060000019897L17/dossiers17170600000198251706000001982571PA7951642025-05-14False
17060000019898L17/dossiers17170600000198251706000001982572PA7955962025-05-14False
17060000019899L17/dossiers17170600000198251706000001982573PA7947782025-05-14False
17060000019900L17/dossiers17170600000198251706000001982574PA8416652025-05-14False
17060000019901L17/dossiers17170600000198251706000001982575PA8413512025-05-14False
17060000019902L17/dossiers17170600000198251706000001982576PA6093322025-05-14False
17060000019903L17/dossiers17170600000198251706000001982577PA8420132025-05-14False
17060000019904L17/dossiers17170600000198251706000001982578PA6109682025-05-14False
17060000019905L17/dossiers17170600000198251706000001982579PA8401712025-05-14False
17060000019906L17/dossiers17170600000198251706000001982580PA7950762025-05-14False
17060000019907L17/dossiers17170600000198251706000001982581PA7936642025-05-14False
17060000019908L17/dossiers17170600000198251706000001982582PA6100022025-05-14False
17060000019909L17/dossiers17170600000198251706000001982583PA8414192025-05-14False
17060000019910L17/dossiers17170600000198251706000001982584PA8417012025-05-14False
17060000019911L17/dossiers17170600000198251706000001982585PA8418852025-05-14False
17060000019912L17/dossiers17170600000198251706000001982586PA8415072025-05-14False
17060000019913L17/dossiers17170600000198251706000001982587PA7950102025-05-14False
17060000019914L17/dossiers17170600000198251706000001982588PA7221422025-05-14False
17060000019915L17/dossiers17170600000198251706000001982589PA7212102025-05-14False
17060000019916L17/dossiers17170600000198251706000001982590PA7941542025-05-14False
17060000019917L17/dossiers17170600000198251706000001982591PA7937082025-05-14False
17060000019918L17/dossiers17170600000198251706000001982592PA7208382025-05-14False
17060000019919L17/dossiers17170600000198251706000001982593PA8418132025-05-14False
17060000019920L17/dossiers17170600000198251706000001982594PA7952402025-05-14False
17060000019921L17/dossiers17170600000198251706000001982595PA7958202025-05-14False
17060000019922L17/dossiers17170600000198251706000001982596PA8422992025-05-14False
17060000019923L17/dossiers17170600000198251706000001982597PA8417132025-05-14False
17060000019924L17/dossiers17170600000198251706000001982598PA7960182025-05-14False
17060000019925L17/dossiers17170600000198251706000001982599PA5888842025-05-14False
17060000019926L17/dossiers171706000001982517060000019825100PA29402025-05-14False
17060000019927L17/dossiers171706000001982517060000019825101PA7939802025-05-14False
17060000019928L17/dossiers171706000001982517060000019825102PA7941462025-05-14False
17060000019929L17/dossiers171706000001982517060000019825103PA8409972025-05-14False
17060000019930L17/dossiers171706000001982517060000019825104PA7956362025-05-14False
17060000019931L17/dossiers171706000001982517060000019825105PA7362012025-05-14False
17060000019932L17/dossiers171706000001982517060000019825106PA7954542025-05-14False
17060000019933L17/dossiers171706000001982517060000019825107PA7953622025-05-14False
17060000019934L17/dossiers171706000001982517060000019825108PA7934522025-05-14False
17060000019935L17/dossiers171706000001982517060000019825109PA8409472025-05-14False
17060000019939L17/dossiers1717060000019937170600000199371PA6428472025-02-17False