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
17060000025242L17/dossiers17170600000252231706000002522318PA7941542025-03-27False
17060000025243L17/dossiers17170600000252231706000002522319PA7192182025-03-27False
17060000025244L17/dossiers17170600000252231706000002522320PA8408172025-03-27False
17060000025245L17/dossiers17170600000252231706000002522321PA6082642025-03-27False
17060000025246L17/dossiers17170600000252231706000002522322PA7191382025-03-27False
17060000025247L17/dossiers17170600000252231706000002522323PA7945542025-03-27False
17060000025248L17/dossiers17170600000252231706000002522324PA7192862025-03-27False
17060000025249L17/dossiers17170600000252231706000002522325PA8416332025-03-27False
17060000025250L17/dossiers17170600000252231706000002522326PA7948542025-03-27False
17060000025251L17/dossiers17170600000252231706000002522327PA8416652025-03-27False
17060000025252L17/dossiers17170600000252231706000002522328PA8414192025-03-27False
17060000025253L17/dossiers17170600000252231706000002522329PA7203542025-03-27False
17060000025254L17/dossiers17170600000252231706000002522330PA7194122025-03-27False
17060000025255L17/dossiers17170600000252231706000002522331PA7194042025-03-27False
17060000025256L17/dossiers17170600000252231706000002522332PA7749622025-03-27False
17060000025257L17/dossiers17170600000252231706000002522333PA8409792025-03-27False
17060000025258L17/dossiers17170600000252231706000002522334PA7193382025-03-27False
17060000025259L17/dossiers17170600000252231706000002522335PA6076192025-03-27False
17060000025260L17/dossiers17170600000252231706000002522336PA8413812025-03-27False
17060000025261L17/dossiers17170600000252231706000002522337PA8413592025-03-27False
17060000025262L17/dossiers17170600000252231706000002522338PA7212342025-03-27False
17060000025263L17/dossiers17170600000252231706000002522339PA7930942025-03-27False
17060000025264L17/dossiers17170600000252231706000002522340PA7952402025-03-27False
17060000025265L17/dossiers17170600000252231706000002522341PA7950262025-03-27False
17060000025266L17/dossiers17170600000252231706000002522342PA29402025-03-27False
17060000025267L17/dossiers17170600000252231706000002522343PA7936642025-03-27False
17060000025268L17/dossiers17170600000252231706000002522344PA9422025-03-27False
17060000025269L17/dossiers17170600000252231706000002522345PA8412232025-03-27False
17060000025270L17/dossiers17170600000252231706000002522346PA7937962025-03-27False
17060000025271L17/dossiers17170600000252231706000002522347PA7197982025-03-27False
17060000025272L17/dossiers17170600000252231706000002522348PA8406732025-03-27False
17060000025273L17/dossiers17170600000252231706000002522349PA8422112025-03-27False
17060000025274L17/dossiers17170600000252231706000002522350PA3421962025-03-27False
17060000025275L17/dossiers17170600000252231706000002522351PA7938162025-03-27False
17060000025276L17/dossiers17170600000252231706000002522352PA7949822025-03-27False
17060000025277L17/dossiers17170600000252231706000002522353PA7950462025-02-212025-02-23False
17060000025278L17/dossiers17170600000252231706000002522354PA6431842025-03-27False
17060000025279L17/dossiers17170600000252231706000002522355PA6081722025-03-27False
17060000025280L17/dossiers17170600000252231706000002522356PA7948302025-03-27False
17060000025281L17/dossiers17170600000252231706000002522357PA6426952025-03-27False
17060000025282L17/dossiers17170600000252231706000002522358PA8402352025-03-27False
17060000025283L17/dossiers17170600000252231706000002522359PA7201542025-03-27False
17060000025284L17/dossiers17170600000252231706000002522360PA8416012025-03-27False
17060000025285L17/dossiers17170600000252231706000002522361PA7120142025-03-27False
17060000025286L17/dossiers17170600000252231706000002522362PA7947982025-03-27False
17060000025287L17/dossiers17170600000252231706000002522363PA7197362025-03-27False
17060000025288L17/dossiers17170600000252231706000002522364PA7223662025-03-27False
17060000025289L17/dossiers17170600000252231706000002522365PA7195502025-03-27False
17060000025290L17/dossiers17170600000252231706000002522366PA7197562025-03-27False
17060000025297L17/dossiers1717060000025295170600000252951PA6428472025-03-05False