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
17060000051988L17/dossiers1717060000051981170600000519816PA7206682025-12-02False
17060000051989L17/dossiers1717060000051981170600000519817PA8410672025-12-02False
17060000051990L17/dossiers1717060000051981170600000519818PA8407012025-12-02False
17060000051991L17/dossiers1717060000051981170600000519819PA7931342025-12-02False
17060000051992L17/dossiers17170600000519811706000005198110PA8400752025-12-02False
17060000051993L17/dossiers17170600000519811706000005198111PA7948862025-12-02False
17060000051994L17/dossiers17170600000519811706000005198112PA7204682025-12-02False
17060000051995L17/dossiers17170600000519811706000005198113PA8412072025-12-02False
17060000051996L17/dossiers17170600000519811706000005198114PA7960422025-12-02False
17060000051997L17/dossiers17170600000519811706000005198115PA8414872025-12-02False
17060000051998L17/dossiers17170600000519811706000005198116PA8401352025-12-02False
17060000051999L17/dossiers17170600000519811706000005198117PA8416212025-12-02False
17060000052000L17/dossiers17170600000519811706000005198118PA7941982025-12-02False
17060000052001L17/dossiers17170600000519811706000005198119PA8417612025-12-02False
17060000052002L17/dossiers17170600000519811706000005198120PA7939282025-12-02False
17060000052003L17/dossiers17170600000519811706000005198121PA7947622025-12-02False
17060000052004L17/dossiers17170600000519811706000005198122PA7938922025-12-02False
17060000052005L17/dossiers17170600000519811706000005198123PA7932462025-12-02False
17060000052006L17/dossiers17170600000519811706000005198124PA7938322025-12-02False
17060000052007L17/dossiers17170600000519811706000005198125PA8401432025-12-02False
17060000052008L17/dossiers17170600000519811706000005198126PA7933622025-12-02False
17060000052009L17/dossiers17170600000519811706000005198127PA8417372025-12-02False
17060000052010L17/dossiers17170600000519811706000005198128PA7960342025-12-02False
17060000052011L17/dossiers17170600000519811706000005198129PA8408012025-12-02False
17060000052012L17/dossiers17170600000519811706000005198130PA7944182025-12-02False
17060000052013L17/dossiers17170600000519811706000005198131PA7935922025-12-02False
17060000052014L17/dossiers17170600000519811706000005198132PA7932182025-12-02False
17060000052015L17/dossiers17170600000519811706000005198133PA8414512025-12-02False
17060000052016L17/dossiers17170600000519811706000005198134PA7959002025-12-02False
17060000052017L17/dossiers17170600000519811706000005198135PA7931022025-12-02False
17060000052018L17/dossiers17170600000519811706000005198136PA8420852025-12-02False
17060000052019L17/dossiers17170600000519811706000005198137PA7940302025-12-02False
17060000052020L17/dossiers17170600000519811706000005198138PA8410752025-12-02False
17060000052021L17/dossiers17170600000519811706000005198139PA8408572025-12-02False
17060000052022L17/dossiers17170600000519811706000005198140PA7945982025-12-02False
17060000052023L17/dossiers17170600000519811706000005198141PA8408692025-12-02False
17060000052024L17/dossiers17170600000519811706000005198142PA7960262025-12-02False
17060000052025L17/dossiers17170600000519811706000005198143PA8409672025-12-02False
17060000052026L17/dossiers17170600000519811706000005198144PA8418372025-12-02False
17060000052027L17/dossiers17170600000519811706000005198145PA7939042025-12-02False
17060000052028L17/dossiers17170600000519811706000005198146PA6429882025-12-02False
17060000052029L17/dossiers17170600000519811706000005198147PA7932902025-12-02False
17060000052030L17/dossiers17170600000519811706000005198148PA7936082025-12-02False
17060000052031L17/dossiers17170600000519811706000005198149PA7959742025-12-02False
17060000052032L17/dossiers17170600000519811706000005198150PA7933142025-12-02False
17060000052033L17/dossiers17170600000519811706000005198151PA8415632025-12-02False
17060000052034L17/dossiers17170600000519811706000005198152PA7947702025-12-02False
17060000052035L17/dossiers17170600000519811706000005198153PA7936162025-12-02False
17060000052036L17/dossiers17170600000519811706000005198154PA8415872025-12-02False
17060000052037L17/dossiers17170600000519811706000005198155PA7957862025-12-02False