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
17060000052300L17/dossiers171706000005212917060000052129170PA2677802026-07-03False
17060000052301L17/dossiers171706000005212917060000052129171PA8411512026-07-03False
17060000052302L17/dossiers171706000005212917060000052129172PA7188502026-07-03False
17060000052306L17/dossiers1717060000052304170600000523041PA7210042025-12-02False
17060000052307L17/dossiers1717060000052304170600000523042PA7211582025-12-02False
17060000052308L17/dossiers1717060000052304170600000523043PA7954022025-12-02False
17060000052309L17/dossiers1717060000052304170600000523044PA7958842025-12-02False
17060000052310L17/dossiers1717060000052304170600000523045PA7210242025-12-02False
17060000052311L17/dossiers1717060000052304170600000523046PA7953342025-12-02False
17060000052312L17/dossiers1717060000052304170600000523047PA7953262025-12-02False
17060000052313L17/dossiers1717060000052304170600000523048PA7950462025-12-02False
17060000052317L17/dossiers1717060000052315170600000523151PA7208922025-12-02False
17060000052318L17/dossiers1717060000052315170600000523152PA7952282025-12-02False
17060000052319L17/dossiers1717060000052315170600000523153PA7932622025-12-02False
17060000052320L17/dossiers1717060000052315170600000523154PA7949062025-12-02False
17060000052321L17/dossiers1717060000052315170600000523155PA7941382025-12-02False
17060000052322L17/dossiers1717060000052315170600000523156PA7955882025-12-02False
17060000052323L17/dossiers1717060000052315170600000523157PA7950842025-12-02False
17060000052324L17/dossiers1717060000052315170600000523158PA8421052025-12-02False
17060000052325L17/dossiers1717060000052315170600000523159PA8416572025-12-02False
17060000052326L17/dossiers17170600000523151706000005231510PA7204302025-12-02False
17060000052327L17/dossiers17170600000523151706000005231511PA7937722025-12-02False
17060000052328L17/dossiers17170600000523151706000005231512PA7956162025-12-02False
17060000052329L17/dossiers17170600000523151706000005231513PA7934442025-12-02False
17060000052330L17/dossiers17170600000523151706000005231514PA7949382025-12-02False
17060000052331L17/dossiers17170600000523151706000005231515PA7953182025-12-02False
17060000052332L17/dossiers17170600000523151706000005231516PA8410232025-12-02False
17060000052333L17/dossiers17170600000523151706000005231517PA7960902025-12-02False
17060000052334L17/dossiers17170600000523151706000005231518PA8421872025-12-02False
17060000052335L17/dossiers17170600000523151706000005231519PA8420372025-12-02False
17060000052336L17/dossiers17170600000523151706000005231520PA7918122025-12-02False
17060000052337L17/dossiers17170600000523151706000005231521PA7937362025-12-02False
17060000052338L17/dossiers17170600000523151706000005231522PA7212022025-12-02False
17060000052339L17/dossiers17170600000523151706000005231523PA7951362025-12-02False
17060000052340L17/dossiers17170600000523151706000005231524PA7934642025-12-02False
17060000052341L17/dossiers17170600000523151706000005231525PA8421552025-12-02False
17060000052342L17/dossiers17170600000523151706000005231526PA7952002025-12-02False
17060000052343L17/dossiers17170600000523151706000005231527PA7958442025-12-02False
17060000052344L17/dossiers17170600000523151706000005231528PA8412512025-12-02False
17060000052345L17/dossiers17170600000523151706000005231529PA7947862025-12-02False
17060000052346L17/dossiers17170600000523151706000005231530PA7948702025-12-02False
17060000052347L17/dossiers17170600000523151706000005231531PA7960702025-12-02False
17060000052348L17/dossiers17170600000523151706000005231532PA7953102025-12-02False
17060000052349L17/dossiers17170600000523151706000005231533PA7944782025-12-02False
17060000052350L17/dossiers17170600000523151706000005231534PA8419472025-12-02False
17060000052351L17/dossiers17170600000523151706000005231535PA7940822025-12-02False
17060000052352L17/dossiers17170600000523151706000005231536PA7941302025-12-02False
17060000052353L17/dossiers17170600000523151706000005231537PA7208462025-12-02False
17060000052354L17/dossiers17170600000523151706000005231538PA8417292025-12-02False
17060000052355L17/dossiers17170600000523151706000005231539PA7955162025-12-02False