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
17060000035920L17/dossiers1717060000035918170600000359181PA7940082025-05-05False
17060000035921L17/dossiers1717060000035918170600000359182PA8401712025-05-05False
17060000035922L17/dossiers1717060000035918170600000359183PA6427642025-05-05False
17060000035923L17/dossiers1717060000035918170600000359184PA8408292025-05-05False
17060000035924L17/dossiers1717060000035918170600000359185PA7203622025-05-05False
17060000035925L17/dossiers1717060000035918170600000359186PA6426952025-05-05False
17060000035926L17/dossiers1717060000035918170600000359187PA6065072025-05-05False
17060000035927L17/dossiers1717060000035918170600000359188PA7220002025-05-05False
17060000035928L17/dossiers1717060000035918170600000359189PA8412952025-05-05False
17060000035929L17/dossiers17170600000359181706000003591810PA7933942025-05-05False
17060000035930L17/dossiers17170600000359181706000003591811PA7954302025-05-05False
17060000035931L17/dossiers17170600000359181706000003591812PA6431752025-05-05False
17060000035932L17/dossiers17170600000359181706000003591813PA7948542025-05-05False
17060000035933L17/dossiers17170600000359181706000003591814PA7946582025-05-05False
17060000035934L17/dossiers17170600000359181706000003591815PA6056942025-05-05False
17060000035935L17/dossiers17170600000359181706000003591816PA8402352025-05-05False
17060000035936L17/dossiers17170600000359181706000003591817PA8226172025-05-05False
17060000035937L17/dossiers17170600000359181706000003591818PA7197362025-05-05False
17060000035938L17/dossiers17170600000359181706000003591819PA7212962025-05-05False
17060000035939L17/dossiers17170600000359181706000003591820PA8422632025-05-05False
17060000035940L17/dossiers17170600000359181706000003591821PA8418532025-05-05False
17060000035941L17/dossiers17170600000359181706000003591822PA7221502025-05-05False
17060000035942L17/dossiers17170600000359181706000003591823PA7197562025-05-05False
17060000035943L17/dossiers17170600000359181706000003591824PA8407652025-05-05False
17060000035944L17/dossiers17170600000359181706000003591825PA7190802025-05-05False
17060000035945L17/dossiers17170600000359181706000003591826PA8411072025-05-05False
17060000035946L17/dossiers17170600000359181706000003591827PA8413592025-05-05False
17060000035947L17/dossiers17170600000359181706000003591828PA8413672025-05-05False
17060000035948L17/dossiers17170600000359181706000003591829PA3419812025-05-05False
17060000035949L17/dossiers17170600000359181706000003591830PA7214262025-05-05False
17060000035950L17/dossiers17170600000359181706000003591831PA8406732025-05-05False
17060000035951L17/dossiers17170600000359181706000003591832PA3421962025-05-05False
17060000035952L17/dossiers17170600000359181706000003591833PA8412432025-05-05False
17060000035953L17/dossiers17170600000359181706000003591834PA3403432025-05-05False
17060000035954L17/dossiers17170600000359181706000003591835PA7944862025-05-05False
17060000035958L17/dossiers1717060000035956170600000359561PA7959502025-05-23False
17060000035959L17/dossiers1717060000035956170600000359562PA7211582025-05-23False
17060000035960L17/dossiers1717060000035956170600000359563PA7951442025-05-23False
17060000035961L17/dossiers1717060000035956170600000359564PA7221902025-05-23False
17060000035962L17/dossiers1717060000035956170600000359565PA6429352025-05-23False
17060000035963L17/dossiers1717060000035956170600000359566PA7192182025-05-23False
17060000035964L17/dossiers1717060000035956170600000359567PA6426952025-05-23False
17060000035965L17/dossiers1717060000035956170600000359568PA6065072025-05-23False
17060000035966L17/dossiers1717060000035956170600000359569PA7959902025-05-23False
17060000035967L17/dossiers17170600000359561706000003595610PA7943302025-05-23False
17060000035968L17/dossiers17170600000359561706000003595611PA7220002025-05-23False
17060000035969L17/dossiers17170600000359561706000003595612PA7947982025-05-23False
17060000035970L17/dossiers17170600000359561706000003595613PA7217502025-05-23False
17060000035971L17/dossiers17170600000359561706000003595614PA7953302025-05-23False
17060000035972L17/dossiers17170600000359561706000003595615PA8423112025-05-23False