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
17060000042376L17/dossiers1717060000042372170600000423723PA7208922025-07-11False
17060000042377L17/dossiers1717060000042372170600000423724PA7952282025-07-11False
17060000042378L17/dossiers1717060000042372170600000423725PA7932622025-07-11False
17060000042379L17/dossiers1717060000042372170600000423726PA7949062025-07-11False
17060000042380L17/dossiers1717060000042372170600000423727PA7941382025-07-11False
17060000042381L17/dossiers1717060000042372170600000423728PA7955882025-07-11False
17060000042382L17/dossiers1717060000042372170600000423729PA7950842025-07-11False
17060000042383L17/dossiers17170600000423721706000004237210PA8421052025-07-11False
17060000042384L17/dossiers17170600000423721706000004237211PA8416572025-07-11False
17060000042385L17/dossiers17170600000423721706000004237212PA7204302025-07-11False
17060000042386L17/dossiers17170600000423721706000004237213PA7937722025-07-11False
17060000042387L17/dossiers17170600000423721706000004237214PA7956162025-07-11False
17060000042388L17/dossiers17170600000423721706000004237215PA7949382025-07-11False
17060000042389L17/dossiers17170600000423721706000004237216PA7953182025-07-11False
17060000042390L17/dossiers17170600000423721706000004237217PA8410232025-07-11False
17060000042391L17/dossiers17170600000423721706000004237218PA7960902025-07-11False
17060000042392L17/dossiers17170600000423721706000004237219PA7939122025-07-11False
17060000042393L17/dossiers17170600000423721706000004237220PA8421872025-07-11False
17060000042394L17/dossiers17170600000423721706000004237221PA8420372025-07-11False
17060000042395L17/dossiers17170600000423721706000004237222PA7212022025-07-11False
17060000042396L17/dossiers17170600000423721706000004237223PA7951362025-07-11False
17060000042397L17/dossiers17170600000423721706000004237224PA7934642025-07-11False
17060000042398L17/dossiers17170600000423721706000004237225PA8421552025-07-11False
17060000042399L17/dossiers17170600000423721706000004237226PA7952002025-07-11False
17060000042400L17/dossiers17170600000423721706000004237227PA7958442025-07-11False
17060000042401L17/dossiers17170600000423721706000004237228PA8412512025-07-11False
17060000042402L17/dossiers17170600000423721706000004237229PA7947862025-07-11False
17060000042403L17/dossiers17170600000423721706000004237230PA7948702025-07-11False
17060000042404L17/dossiers17170600000423721706000004237231PA7960702025-07-11False
17060000042405L17/dossiers17170600000423721706000004237232PA7953102025-07-11False
17060000042406L17/dossiers17170600000423721706000004237233PA7944782025-07-11False
17060000042407L17/dossiers17170600000423721706000004237234PA8419472025-07-11False
17060000042408L17/dossiers17170600000423721706000004237235PA7940822025-07-11False
17060000042409L17/dossiers17170600000423721706000004237236PA7941302025-07-11False
17060000042410L17/dossiers17170600000423721706000004237237PA7208462025-07-11False
17060000042411L17/dossiers17170600000423721706000004237238PA8417292025-07-11False
17060000042412L17/dossiers17170600000423721706000004237239PA7955162025-07-11False
17060000042413L17/dossiers17170600000423721706000004237240PA7956722025-07-11False
17060000042414L17/dossiers17170600000423721706000004237241PA7957462025-07-11False
17060000042415L17/dossiers17170600000423721706000004237242PA7951082025-07-11False
17060000042416L17/dossiers17170600000423721706000004237243PA8415152025-07-11False
17060000042417L17/dossiers17170600000423721706000004237244PA7952982025-07-11False
17060000042418L17/dossiers17170600000423721706000004237245PA7918242025-07-11False
17060000042419L17/dossiers17170600000423721706000004237246PA8420292025-07-11False
17060000042420L17/dossiers17170600000423721706000004237247PA7935322025-07-11False
17060000042421L17/dossiers17170600000423721706000004237248PA3423842025-07-11False
17060000042422L17/dossiers17170600000423721706000004237249PA7954222025-07-11False
17060000042423L17/dossiers17170600000423721706000004237250PA7946862025-07-11False
17060000042424L17/dossiers17170600000423721706000004237251PA8412152025-07-11False
17060000042425L17/dossiers17170600000423721706000004237252PA7954822025-07-11False