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 151 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
17060000012408L17/dossiers17170600000123451706000001234562PA7936562025-03-07False
17060000012409L17/dossiers17170600000123451706000001234563PA7959662025-03-07False
17060000012410L17/dossiers17170600000123451706000001234564PA7932302025-03-07False
17060000012411L17/dossiers17170600000123451706000001234565PA7932542025-03-07False
17060000012412L17/dossiers17170600000123451706000001234566PA8419812025-03-07False
17060000012413L17/dossiers17170600000123451706000001234567PA7944422025-03-07False
17060000012414L17/dossiers17170600000123451706000001234568PA8420972025-03-07False
17060000012415L17/dossiers17170600000123451706000001234569PA7945702025-03-07False
17060000012416L17/dossiers17170600000123451706000001234570PA7949542025-03-07False
17060000012417L17/dossiers17170600000123451706000001234571PA7945022025-03-07False
17060000012418L17/dossiers17170600000123451706000001234572PA8417772024-10-152025-03-07False
17060000012419L17/dossiers17170600000123451706000001234573PA7932982025-03-07False
17060000012420L17/dossiers17170600000123451706000001234574PA8407812025-03-07False
17060000012421L17/dossiers17170600000123451706000001234575PA7949462025-03-07False
17060000012425L17/dossiers1717060000012423170600000124231PA7942782024-10-17False
17060000012426L17/dossiers1717060000012423170600000124232PA7939922024-10-17False
17060000012427L17/dossiers1717060000012423170600000124233PA8414312024-10-17False
17060000012428L17/dossiers1717060000012423170600000124234PA7944702024-10-17False
17060000012429L17/dossiers1717060000012423170600000124235PA7944262024-10-17False
17060000012430L17/dossiers1717060000012423170600000124236PA7933982024-10-17False
17060000012431L17/dossiers1717060000012423170600000124237PA7935722024-10-17False
17060000012432L17/dossiers1717060000012423170600000124238PA7952702024-10-17False
17060000012433L17/dossiers1717060000012423170600000124239PA2677802024-10-17False
17060000012434L17/dossiers17170600000124231706000001242310PA7220462024-10-17False
17060000012435L17/dossiers17170600000124231706000001242311PA7944862024-10-17False
17060000012436L17/dossiers17170600000124231706000001242312PA7943302024-10-17False
17060000012437L17/dossiers17170600000124231706000001242313PA7749542024-10-17False
17060000012438L17/dossiers17170600000124231706000001242314PA7203422024-10-17False
17060000012439L17/dossiers17170600000124231706000001242315PA7190242024-10-17False
17060000012440L17/dossiers17170600000124231706000001242316PA7947022024-10-17False
17060000012441L17/dossiers17170600000124231706000001242317PA7946582024-10-17False
17060000012442L17/dossiers17170600000124231706000001242318PA8402352024-10-17False
17060000012446L17/dossiers1717060000012444170600000124441PA7942782024-10-17False
17060000012447L17/dossiers1717060000012444170600000124442PA7939922024-10-17False
17060000012448L17/dossiers1717060000012444170600000124443PA8414312024-10-17False
17060000012449L17/dossiers1717060000012444170600000124444PA7944702024-10-17False
17060000012450L17/dossiers1717060000012444170600000124445PA7944262024-10-17False
17060000012451L17/dossiers1717060000012444170600000124446PA7933982024-10-17False
17060000012452L17/dossiers1717060000012444170600000124447PA7218442024-10-17False
17060000012453L17/dossiers1717060000012444170600000124448PA7935722024-10-17False
17060000012454L17/dossiers1717060000012444170600000124449PA7952702024-10-17False
17060000012455L17/dossiers17170600000124441706000001244410PA7205522024-10-17False
17060000012456L17/dossiers17170600000124441706000001244411PA2677802024-10-17False
17060000012457L17/dossiers17170600000124441706000001244412PA7220462024-10-17False
17060000012458L17/dossiers17170600000124441706000001244413PA7944862024-10-17False
17060000012459L17/dossiers17170600000124441706000001244414PA7943302024-10-17False
17060000012460L17/dossiers17170600000124441706000001244415PA7749542024-10-17False
17060000012461L17/dossiers17170600000124441706000001244416PA7203422024-10-17False
17060000012462L17/dossiers17170600000124441706000001244417PA7190242024-10-17False
17060000012463L17/dossiers17170600000124441706000001244418PA7947022024-10-17False