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
17060000029788L17/dossiers1717060000029785170600000297852PA7952282025-06-19False
17060000029789L17/dossiers1717060000029785170600000297853PA7932622025-06-19False
17060000029790L17/dossiers1717060000029785170600000297854PA7949062025-06-19False
17060000029791L17/dossiers1717060000029785170600000297855PA7941382025-06-19False
17060000029792L17/dossiers1717060000029785170600000297856PA7955882025-06-19False
17060000029793L17/dossiers1717060000029785170600000297857PA7950842025-06-19False
17060000029794L17/dossiers1717060000029785170600000297858PA8421052025-06-19False
17060000029795L17/dossiers1717060000029785170600000297859PA8408292025-06-19False
17060000029796L17/dossiers17170600000297851706000002978510PA8416572025-06-19False
17060000029797L17/dossiers17170600000297851706000002978511PA7204302025-06-19False
17060000029798L17/dossiers17170600000297851706000002978512PA7937722025-06-19False
17060000029799L17/dossiers17170600000297851706000002978513PA7956162025-06-19False
17060000029800L17/dossiers17170600000297851706000002978514PA7934442025-06-19False
17060000029801L17/dossiers17170600000297851706000002978515PA8418852025-06-19False
17060000029802L17/dossiers17170600000297851706000002978516PA7940942025-06-19False
17060000029803L17/dossiers17170600000297851706000002978517PA7949382025-06-19False
17060000029804L17/dossiers17170600000297851706000002978518PA7953182025-06-19False
17060000029805L17/dossiers17170600000297851706000002978519PA8410232025-06-19False
17060000029806L17/dossiers17170600000297851706000002978520PA7960902025-06-19False
17060000029807L17/dossiers17170600000297851706000002978521PA7939122025-06-19False
17060000029808L17/dossiers17170600000297851706000002978522PA8421872025-06-19False
17060000029809L17/dossiers17170600000297851706000002978523PA8420372025-06-19False
17060000029810L17/dossiers17170600000297851706000002978524PA7918122025-06-19False
17060000029811L17/dossiers17170600000297851706000002978525PA8409032025-06-19False
17060000029812L17/dossiers17170600000297851706000002978526PA7937362025-06-19False
17060000029813L17/dossiers17170600000297851706000002978527PA7212022025-06-19False
17060000029814L17/dossiers17170600000297851706000002978528PA7951362025-06-19False
17060000029815L17/dossiers17170600000297851706000002978529PA9422025-06-19False
17060000029816L17/dossiers17170600000297851706000002978530PA10082025-06-19False
17060000029817L17/dossiers17170600000297851706000002978531PA7933942025-06-19False
17060000029818L17/dossiers17170600000297851706000002978532PA7934642025-06-19False
17060000029819L17/dossiers17170600000297851706000002978533PA8419192025-06-19False
17060000029820L17/dossiers17170600000297851706000002978534PA8421552025-06-19False
17060000029821L17/dossiers17170600000297851706000002978535PA7952002025-06-19False
17060000029822L17/dossiers17170600000297851706000002978536PA7948542025-06-19False
17060000029823L17/dossiers17170600000297851706000002978537PA8421952025-06-19False
17060000029824L17/dossiers17170600000297851706000002978538PA8416652025-06-19False
17060000029825L17/dossiers17170600000297851706000002978539PA8412512025-06-19False
17060000029826L17/dossiers17170600000297851706000002978540PA7947862025-06-19False
17060000029827L17/dossiers17170600000297851706000002978541PA7948702025-06-19False
17060000029828L17/dossiers17170600000297851706000002978542PA7960702025-06-19False
17060000029829L17/dossiers17170600000297851706000002978543PA7950102025-06-19False
17060000029830L17/dossiers17170600000297851706000002978544PA8414192025-06-19False
17060000029831L17/dossiers17170600000297851706000002978545PA8409392025-06-19False
17060000029832L17/dossiers17170600000297851706000002978546PA8415392025-06-19False
17060000029833L17/dossiers17170600000297851706000002978547PA3319732025-06-19False
17060000029834L17/dossiers17170600000297851706000002978548PA8401712025-06-19False
17060000029835L17/dossiers17170600000297851706000002978549PA15672025-06-19False
17060000029836L17/dossiers17170600000297851706000002978550PA7953102025-06-19False
17060000029837L17/dossiers17170600000297851706000002978551PA7944782025-06-19False