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
17060000047521L17/dossiers1717060000047512170600000475128PA7212102025-10-24False
17060000047522L17/dossiers1717060000047512170600000475129PA7934522025-10-24False
17060000047523L17/dossiers17170600000475121706000004751210PA8413512025-10-24False
17060000047524L17/dossiers17170600000475121706000004751211PA7939802025-10-24False
17060000047525L17/dossiers17170600000475121706000004751212PA7950102025-10-24False
17060000047526L17/dossiers17170600000475121706000004751213PA8409472025-10-24False
17060000047527L17/dossiers17170600000475121706000004751214PA7940222025-10-24False
17060000047528L17/dossiers17170600000475121706000004751215PA7941462025-10-24False
17060000047529L17/dossiers17170600000475121706000004751216PA7956362025-10-24False
17060000047530L17/dossiers17170600000475121706000004751217PA8420452025-10-24False
17060000047531L17/dossiers17170600000475121706000004751218PA7937082025-10-24False
17060000047532L17/dossiers17170600000475121706000004751219PA7936642025-10-24False
17060000047533L17/dossiers17170600000475121706000004751220PA7941542025-10-24False
17060000047534L17/dossiers17170600000475121706000004751221PA7947782025-10-24False
17060000047535L17/dossiers17170600000475121706000004751222PA6065452025-10-24False
17060000047536L17/dossiers17170600000475121706000004751223PA7950762025-10-24False
17060000047537L17/dossiers17170600000475121706000004751224PA7221422025-10-24False
17060000047538L17/dossiers17170600000475121706000004751225PA6100022025-10-24False
17060000047539L17/dossiers17170600000475121706000004751226PA7960182025-10-24False
17060000047540L17/dossiers17170600000475121706000004751227PA8417132025-10-24False
17060000047541L17/dossiers17170600000475121706000004751228PA29402025-10-24False
17060000047542L17/dossiers17170600000475121706000004751229PA7958082025-10-24False
17060000047543L17/dossiers17170600000475121706000004751230PA8412232025-10-24False
17060000047544L17/dossiers17170600000475121706000004751231PA8415072025-10-24False
17060000047545L17/dossiers17170600000475121706000004751232PA8414192025-10-24False
17060000047546L17/dossiers17170600000475121706000004751233PA8409972025-10-24False
17060000047550L17/dossiers1717060000047548170600000475481PA6429352025-10-14False
17060000047551L17/dossiers1717060000047548170600000475482PA7937722025-10-14False
17060000047552L17/dossiers1717060000047548170600000475483PA6082642025-10-14False
17060000047553L17/dossiers1717060000047548170600000475484PA8421872025-10-14False
17060000047554L17/dossiers1717060000047548170600000475485PA8420372025-10-14False
17060000047555L17/dossiers1717060000047548170600000475486PA7918122025-10-14False
17060000047556L17/dossiers1717060000047548170600000475487PA7951362025-10-14False
17060000047557L17/dossiers1717060000047548170600000475488PA7958442025-10-14False
17060000047558L17/dossiers1717060000047548170600000475489PA8416652025-10-14False
17060000047559L17/dossiers17170600000475481706000004754810PA7947862025-10-14False
17060000047560L17/dossiers17170600000475481706000004754811PA7956722025-10-14False
17060000047561L17/dossiers17170600000475481706000004754812PA7952442025-10-14False
17060000047562L17/dossiers17170600000475481706000004754813PA8422712025-10-14False
17060000047563L17/dossiers17170600000475481706000004754814PA8413592025-10-14False
17060000047564L17/dossiers17170600000475481706000004754815PA8172112025-10-14False
17060000047565L17/dossiers17170600000475481706000004754816PA7936642025-10-14False
17060000047566L17/dossiers17170600000475481706000004754817PA7200922025-10-14False
17060000047567L17/dossiers17170600000475481706000004754818PA8413272025-10-14False
17060000047568L17/dossiers17170600000475481706000004754819PA7960182025-10-14False
17060000047569L17/dossiers17170600000475481706000004754820PA7941062025-10-14False
17060000047573L17/dossiers1717060000047571170600000475711PA7208922025-10-14False
17060000047574L17/dossiers1717060000047571170600000475712PA7952282025-10-14False
17060000047575L17/dossiers1717060000047571170600000475713PA7932622025-10-14False
17060000047576L17/dossiers1717060000047571170600000475714PA7949062025-10-14False