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
17060000024158L17/dossiers17170600000241461706000002414611PA7953302025-02-11False
17060000024159L17/dossiers17170600000241461706000002414612PA7191382025-02-11False
17060000024160L17/dossiers17170600000241461706000002414613PA7939402025-02-11False
17060000024161L17/dossiers17170600000241461706000002414614PA7959082025-02-11False
17060000024162L17/dossiers17170600000241461706000002414615PA7192862025-02-11False
17060000024163L17/dossiers17170600000241461706000002414616PA7935202025-02-11False
17060000024164L17/dossiers17170600000241461706000002414617PA7201542025-02-11False
17060000024165L17/dossiers17170600000241461706000002414618PA6431752025-02-11False
17060000024166L17/dossiers17170600000241461706000002414619PA6071932025-02-11False
17060000024167L17/dossiers17170600000241461706000002414620PA7946582025-02-11False
17060000024168L17/dossiers17170600000241461706000002414621PA6056942025-02-11False
17060000024169L17/dossiers17170600000241461706000002414622PA2677802025-02-11False
17060000024170L17/dossiers17170600000241461706000002414623PA8402352025-02-11False
17060000024171L17/dossiers17170600000241461706000002414624PA8414192025-02-11False
17060000024172L17/dossiers17170600000241461706000002414625PA7952582025-02-11False
17060000024173L17/dossiers17170600000241461706000002414626PA2672002025-02-11False
17060000024174L17/dossiers17170600000241461706000002414627PA7203542025-02-11False
17060000024175L17/dossiers17170600000241461706000002414628PA7200382025-02-11False
17060000024176L17/dossiers17170600000241461706000002414629PA6431842025-02-11False
17060000024177L17/dossiers17170600000241461706000002414630PA7194122025-02-11False
17060000024178L17/dossiers17170600000241461706000002414631PA7194042025-02-11False
17060000024179L17/dossiers17170600000241461706000002414632PA3457222025-02-11False
17060000024180L17/dossiers17170600000241461706000002414633PA7203422025-02-11False
17060000024181L17/dossiers17170600000241461706000002414634PA7120142025-02-11False
17060000024182L17/dossiers17170600000241461706000002414635PA8416012025-02-11False
17060000024183L17/dossiers17170600000241461706000002414636PA7947022025-02-11False
17060000024184L17/dossiers17170600000241461706000002414637PA7209762025-02-11False
17060000024185L17/dossiers17170600000241461706000002414638PA8419312025-02-11False
17060000024186L17/dossiers17170600000241461706000002414639PA7193382025-02-11False
17060000024187L17/dossiers17170600000241461706000002414640PA7196402025-02-11False
17060000024188L17/dossiers17170600000241461706000002414641PA7951762025-02-11False
17060000024189L17/dossiers17170600000241461706000002414642PA7956642025-02-11False
17060000024190L17/dossiers17170600000241461706000002414643PA7958202025-02-11False
17060000024191L17/dossiers17170600000241461706000002414644PA7948302025-02-11False
17060000024192L17/dossiers17170600000241461706000002414645PA6057452025-01-282025-01-28False
17060000024193L17/dossiers17170600000241461706000002414646PA7203342025-02-11False
17060000024194L17/dossiers17170600000241461706000002414647PA8413812025-02-11False
17060000024195L17/dossiers17170600000241461706000002414648PA8413592025-02-11False
17060000024196L17/dossiers17170600000241461706000002414649PA7942702025-02-11False
17060000024197L17/dossiers17170600000241461706000002414650PA7935722025-02-11False
17060000024198L17/dossiers17170600000241461706000002414651PA7952402025-02-11False
17060000024199L17/dossiers17170600000241461706000002414652PA7214262025-02-11False
17060000024200L17/dossiers17170600000241461706000002414653PA7214582025-02-11False
17060000024201L17/dossiers17170600000241461706000002414654PA8412432025-02-11False
17060000024202L17/dossiers17170600000241461706000002414655PA7211102025-02-11False
17060000024203L17/dossiers17170600000241461706000002414656PA7572252025-02-11False
17060000024204L17/dossiers17170600000241461706000002414657PA7934162025-02-11False
17060000024205L17/dossiers17170600000241461706000002414658PA7209602025-02-11False
17060000024206L17/dossiers17170600000241461706000002414659PA7201902025-02-11False
17060000024207L17/dossiers17170600000241461706000002414660PA7944862025-02-11False