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
17060000014490L17/dossiers171706000001422517060000014225264PA7960102024-12-032025-01-14False
17060000014491L17/dossiers171706000001422517060000014225265PA8422712024-12-032025-01-14False
17060000014492L17/dossiers171706000001422517060000014225266PA7931742024-12-032025-01-14False
17060000014493L17/dossiers171706000001422517060000014225267PA7958202024-12-032025-01-14False
17060000014494L17/dossiers171706000001422517060000014225268PA7212702024-12-032025-01-14False
17060000014495L17/dossiers171706000001422517060000014225269PA7958762024-12-032025-01-14False
17060000014496L17/dossiers171706000001422517060000014225270PA6057452024-12-032025-01-14False
17060000014497L17/dossiers171706000001422517060000014225271PA8422992024-12-032025-01-14False
17060000014501L17/dossiers1717060000014499170600000144991PA7940582024-10-15False
17060000014502L17/dossiers1717060000014499170600000144992PA7199682024-10-15False
17060000014503L17/dossiers1717060000014499170600000144993PA7203862024-10-15False
17060000014504L17/dossiers1717060000014499170600000144994PA6070902024-10-15False
17060000014505L17/dossiers1717060000014499170600000144995PA7192722024-10-15False
17060000014506L17/dossiers1717060000014499170600000144996PA8409792024-10-15False
17060000014507L17/dossiers1717060000014499170600000144997PA6088262024-10-15False
17060000014508L17/dossiers1717060000014499170600000144998PA3467822024-10-15False
17060000014509L17/dossiers1717060000014499170600000144999PA3422402024-10-15False
17060000014510L17/dossiers17170600000144991706000001449910PA7933422024-10-15False
17060000014511L17/dossiers17170600000144991706000001449911PA7930942024-10-15False
17060000014512L17/dossiers17170600000144991706000001449912PA7188842024-10-15False
17060000014513L17/dossiers17170600000144991706000001449913PA7188382024-10-15False
17060000014514L17/dossiers17170600000144991706000001449914PA7940382024-10-15False
17060000014515L17/dossiers17170600000144991706000001449915PA7941782024-10-15False
17060000014516L17/dossiers17170600000144991706000001449916PA7214422024-10-15False
17060000014520L17/dossiers1717060000014518170600000145181PA7195582025-02-10False
17060000014521L17/dossiers1717060000014518170600000145182PA8422112025-02-10False
17060000014522L17/dossiers1717060000014518170600000145183PA7220462025-02-10False
17060000014523L17/dossiers1717060000014518170600000145184PA6872142025-02-10False
17060000014524L17/dossiers1717060000014518170600000145185PA3096432025-02-10False
17060000014525L17/dossiers1717060000014518170600000145186PA7190322025-02-10False
17060000014526L17/dossiers1717060000014518170600000145187PA8408172025-02-10False
17060000014527L17/dossiers1717060000014518170600000145188PA7192862025-02-10False
17060000014528L17/dossiers1717060000014518170600000145189PA8407132025-02-10False
17060000014529L17/dossiers17170600000145181706000001451810PA7949822025-02-10False
17060000014530L17/dossiers17170600000145181706000001451811PA7946582025-02-10False
17060000014531L17/dossiers17170600000145181706000001451812PA7942342025-02-10False
17060000014532L17/dossiers17170600000145181706000001451813PA2673182025-02-10False
17060000014533L17/dossiers17170600000145181706000001451814PA8418332025-02-10False
17060000014534L17/dossiers17170600000145181706000001451815PA7200382025-02-10False
17060000014535L17/dossiers17170600000145181706000001451816PA7200222025-02-10False
17060000014536L17/dossiers17170600000145181706000001451817PA3457222025-02-10False
17060000014537L17/dossiers17170600000145181706000001451818PA7948382025-02-10False
17060000014538L17/dossiers17170600000145181706000001451819PA7947022025-02-10False
17060000014539L17/dossiers17170600000145181706000001451820PA7202302025-02-10False
17060000014540L17/dossiers17170600000145181706000001451821PA7940382025-02-10False
17060000014541L17/dossiers17170600000145181706000001451822PA7948302025-02-10False
17060000014542L17/dossiers17170600000145181706000001451823PA8413812025-02-10False
17060000014543L17/dossiers17170600000145181706000001451824PA7933982025-02-10False
17060000014544L17/dossiers17170600000145181706000001451825PA7212342025-02-10False
17060000014545L17/dossiers17170600000145181706000001451826PA7218442025-02-10False