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
17060000039432L17/dossiers17170600000394161706000003941615PA7933822025-09-17False
17060000039433L17/dossiers17170600000394161706000003941616PA8415532025-09-17False
17060000039434L17/dossiers17170600000394161706000003941617PA7933742025-09-17False
17060000039435L17/dossiers17170600000394161706000003941618PA7933222025-09-17False
17060000039436L17/dossiers17170600000394161706000003941619PA7194362025-09-17False
17060000039437L17/dossiers17170600000394161706000003941620PA7932542025-09-17False
17060000039438L17/dossiers17170600000394161706000003941621PA8408892025-09-17False
17060000039439L17/dossiers17170600000394161706000003941622PA8417692025-09-17False
17060000039440L17/dossiers17170600000394161706000003941623PA8407572025-09-17False
17060000039441L17/dossiers17170600000394161706000003941624PA7932982025-09-17False
17060000039442L17/dossiers17170600000394161706000003941625PA7214742025-09-17False
17060000039443L17/dossiers17170600000394161706000003941626PA7938322025-09-17False
17060000039447L17/dossiers1717060000039445170600000394451PA8410672025-09-30False
17060000039448L17/dossiers1717060000039445170600000394452PA2675612025-09-30False
17060000039449L17/dossiers1717060000039445170600000394453PA7933742025-09-30False
17060000039450L17/dossiers1717060000039445170600000394454PA5692025-09-30False
17060000039451L17/dossiers1717060000039445170600000394455PA8407012025-09-30False
17060000039452L17/dossiers1717060000039445170600000394456PA7204682025-09-30False
17060000039453L17/dossiers1717060000039445170600000394457PA7933222025-09-30False
17060000039454L17/dossiers1717060000039445170600000394458PA8408012025-09-30False
17060000039455L17/dossiers1717060000039445170600000394459PA8420852025-09-30False
17060000039456L17/dossiers17170600000394451706000003944510PA7945982025-09-30False
17060000039457L17/dossiers17170600000394451706000003944511PA7947702025-09-30False
17060000039458L17/dossiers17170600000394451706000003944512PA8420972025-09-30False
17060000039459L17/dossiers17170600000394451706000003944513PA7933822025-09-30False
17060000039460L17/dossiers17170600000394451706000003944514PA8415532025-09-30False
17060000039461L17/dossiers17170600000394451706000003944515PA8408892025-09-30False
17060000039462L17/dossiers17170600000394451706000003944516PA8417692025-09-30False
17060000039463L17/dossiers17170600000394451706000003944517PA7945702025-09-30False
17060000039464L17/dossiers17170600000394451706000003944518PA8412072025-09-30False
17060000039465L17/dossiers17170600000394451706000003944519PA3096432025-09-30False
17060000039466L17/dossiers17170600000394451706000003944520PA7938322025-09-30False
17060000039467L17/dossiers17170600000394451706000003944521PA7214742025-09-30False
17060000039474L17/dossiers1717060000039472170600000394721PA7199302025-06-10False
17060000039475L17/dossiers1717060000039472170600000394722PA3332852025-06-10False
17060000039479L17/dossiers1717060000039477170600000394771PA6428472026-06-02False
17060000039480L17/dossiers1717060000039477170600000394772PA7188842026-06-02False
17060000039481L17/dossiers1717060000039477170600000394773PA4085782026-06-02False
17060000039482L17/dossiers1717060000039477170600000394774PA7749542026-06-02False
17060000039483L17/dossiers1717060000039477170600000394775PA7199682026-06-02False
17060000039484L17/dossiers1717060000039477170600000394776PA7214102026-06-02False
17060000039485L17/dossiers1717060000039477170600000394777PA2667932026-06-02False
17060000039486L17/dossiers1717060000039477170600000394778PA7218162026-06-02False
17060000039487L17/dossiers1717060000039477170600000394779PA3422402026-06-02False
17060000039488L17/dossiers17170600000394771706000003947710PA3300082026-06-02False
17060000039489L17/dossiers17170600000394771706000003947711PA7935082026-06-02False
17060000039490L17/dossiers17170600000394771706000003947712PA7188382026-06-02False
17060000039491L17/dossiers17170600000394771706000003947713PA8410472026-06-02False
17060000039492L17/dossiers17170600000394771706000003947714PA7188502026-06-02False
17060000039493L17/dossiers17170600000394771706000003947715PA7223902026-06-02False