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
17060000044163L17/dossiers1717060000044157170600000441575PA3300082026-04-02False
17060000044164L17/dossiers1717060000044157170600000441576PA7935082026-04-02False
17060000044165L17/dossiers1717060000044157170600000441577PA7198902026-04-02False
17060000044166L17/dossiers1717060000044157170600000441578PA7220002026-04-02False
17060000044167L17/dossiers1717060000044157170600000441579PA7947982026-04-02False
17060000044168L17/dossiers17170600000441571706000004415710PA7194722026-04-02False
17060000044169L17/dossiers17170600000441571706000004415711PA7192862026-04-02False
17060000044170L17/dossiers17170600000441571706000004415712PA7223902026-04-02False
17060000044171L17/dossiers17170600000441571706000004415713PA2670422026-04-02False
17060000044172L17/dossiers17170600000441571706000004415714PA7120152026-03-262026-04-02False
17060000044173L17/dossiers17170600000441571706000004415715PA7221342026-04-02False
17060000044174L17/dossiers17170600000441571706000004415716PA7222842026-04-02False
17060000044175L17/dossiers17170600000441571706000004415717PA7223662026-04-02False
17060000044176L17/dossiers17170600000441571706000004415718PA7223582026-04-02False
17060000044177L17/dossiers17170600000441571706000004415719PA15922026-04-02False
17060000044178L17/dossiers17170600000441571706000004415720PA8414712026-04-02False
17060000044179L17/dossiers17170600000441571706000004415721PA7220702026-04-02False
17060000044180L17/dossiers17170600000441571706000004415722PA6084162026-04-02False
17060000044181L17/dossiers17170600000441571706000004415723PA7223742026-04-02False
17060000044182L17/dossiers17170600000441571706000004415724PA7197782026-04-02False
17060000044183L17/dossiers17170600000441571706000004415725PA7210042026-04-02False
17060000044184L17/dossiers17170600000441571706000004415726PA7953902026-04-02False
17060000044185L17/dossiers17170600000441571706000004415727PA7953342026-04-02False
17060000044186L17/dossiers17170600000441571706000004415728PA7219842026-04-02False
17060000044187L17/dossiers17170600000441571706000004415729PA7194122026-04-02False
17060000044188L17/dossiers17170600000441571706000004415730PA7194042026-04-02False
17060000044189L17/dossiers17170600000441571706000004415731PA7203422026-04-02False
17060000044190L17/dossiers17170600000441571706000004415732PA7948382026-04-02False
17060000044191L17/dossiers17170600000441571706000004415733PA6057822026-04-02False
17060000044192L17/dossiers17170600000441571706000004415734PA7201462026-04-02False
17060000044193L17/dossiers17170600000441571706000004415735PA6076192026-04-02False
17060000044194L17/dossiers17170600000441571706000004415736PA7948302026-04-02False
17060000044195L17/dossiers17170600000441571706000004415737PA7196322026-04-02False
17060000044196L17/dossiers17170600000441571706000004415738PA8413592026-04-02False
17060000044197L17/dossiers17170600000441571706000004415739PA7211822026-04-02False
17060000044198L17/dossiers17170600000441571706000004415740PA7949942026-04-02False
17060000044199L17/dossiers17170600000441571706000004415741PA7201002026-04-02False
17060000044200L17/dossiers17170600000441571706000004415742PA3357582026-04-02False
17060000044201L17/dossiers17170600000441571706000004415743PA7955282026-04-02False
17060000044202L17/dossiers17170600000441571706000004415744PA7932702026-04-02False
17060000044203L17/dossiers17170600000441571706000004415745PA7211102026-04-02False
17060000044204L17/dossiers17170600000441571706000004415746PA7213142026-04-02False
17060000044205L17/dossiers17170600000441571706000004415747PA7572252026-04-02False
17060000044206L17/dossiers17170600000441571706000004415748PA7948022026-04-02False
17060000044207L17/dossiers17170600000441571706000004415749PA7201902026-04-02False
17060000044208L17/dossiers17170600000441571706000004415750PA7195502026-04-02False
17060000044209L17/dossiers17170600000441571706000004415751PA7195122026-04-02False
17060000044210L17/dossiers17170600000441571706000004415752PA7950262026-04-02False
17060000044211L17/dossiers17170600000441571706000004415753PA7199682026-04-02False
17060000044212L17/dossiers17170600000441571706000004415754PA7954022026-04-02False