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
17060000052038L17/dossiers17170600000519811706000005198156PA7194362025-12-02False
17060000052039L17/dossiers17170600000519811706000005198157PA7945822025-12-02False
17060000052040L17/dossiers17170600000519811706000005198158PA8411992025-12-02False
17060000052041L17/dossiers17170600000519811706000005198159PA7932302025-12-02False
17060000052042L17/dossiers17170600000519811706000005198160PA7943222025-12-02False
17060000052043L17/dossiers17170600000519811706000005198161PA8409152025-12-02False
17060000052044L17/dossiers17170600000519811706000005198162PA7932542025-12-02False
17060000052045L17/dossiers17170600000519811706000005198163PA7955522025-12-02False
17060000052046L17/dossiers17170600000519811706000005198164PA8422272025-12-02False
17060000052047L17/dossiers17170600000519811706000005198165PA7959662025-12-02False
17060000052048L17/dossiers17170600000519811706000005198166PA8419812025-12-02False
17060000052049L17/dossiers17170600000519811706000005198167PA7954102025-12-02False
17060000052050L17/dossiers17170600000519811706000005198168PA8420972025-12-02False
17060000052051L17/dossiers17170600000519811706000005198169PA7948942025-12-02False
17060000052052L17/dossiers17170600000519811706000005198170PA7949542025-12-02False
17060000052053L17/dossiers17170600000519811706000005198171PA8422552025-12-02False
17060000052054L17/dossiers17170600000519811706000005198172PA7933822025-12-02False
17060000052055L17/dossiers17170600000519811706000005198173PA7945022025-12-02False
17060000052056L17/dossiers17170600000519811706000005198174PA8407812025-12-02False
17060000052057L17/dossiers17170600000519811706000005198175PA8413952025-12-02False
17060000052058L17/dossiers17170600000519811706000005198176PA8407212025-12-02False
17060000052062L17/dossiers1717060000052060170600000520601PA8406572025-12-02False
17060000052063L17/dossiers1717060000052060170600000520602PA8406852025-12-02False
17060000052064L17/dossiers1717060000052060170600000520603PA8408572025-12-02False
17060000052065L17/dossiers1717060000052060170600000520604PA8407212025-12-02False
17060000052069L17/dossiers1717060000052067170600000520671PA6428472026-01-22False
17060000052070L17/dossiers1717060000052067170600000520672PA7188842026-01-22False
17060000052071L17/dossiers1717060000052067170600000520673PA7214102026-01-22False
17060000052072L17/dossiers1717060000052067170600000520674PA2667932026-01-22False
17060000052073L17/dossiers1717060000052067170600000520675PA3422402026-01-22False
17060000052074L17/dossiers1717060000052067170600000520676PA3300082026-01-22False
17060000052075L17/dossiers1717060000052067170600000520677PA7935082026-01-22False
17060000052076L17/dossiers1717060000052067170600000520678PA8410472026-01-22False
17060000052077L17/dossiers1717060000052067170600000520679PA7223902026-01-22False
17060000052078L17/dossiers17170600000520671706000005206710PA3325232026-01-22False
17060000052079L17/dossiers17170600000520671706000005206711PA7120152026-01-22False
17060000052080L17/dossiers17170600000520671706000005206712PA2667972026-01-22False
17060000052081L17/dossiers17170600000520671706000005206713PA6088262025-12-032026-01-22False
17060000052082L17/dossiers17170600000520671706000005206714PA7940582026-01-22False
17060000052083L17/dossiers17170600000520671706000005206715PA6084162026-01-22False
17060000052084L17/dossiers17170600000520671706000005206716PA3467822026-01-22False
17060000052085L17/dossiers17170600000520671706000005206717PA6427252026-01-22False
17060000052086L17/dossiers17170600000520671706000005206718PA6080162026-01-22False
17060000052087L17/dossiers17170600000520671706000005206719PA7933422026-01-22False
17060000052088L17/dossiers17170600000520671706000005206720PA7192722026-01-22False
17060000052089L17/dossiers17170600000520671706000005206721PA6431042026-01-22False
17060000052090L17/dossiers17170600000520671706000005206722PA7940382026-01-22False
17060000052091L17/dossiers17170600000520671706000005206723PA7187842026-01-22False
17060000052092L17/dossiers17170600000520671706000005206724PA7949942026-01-22False
17060000052093L17/dossiers17170600000520671706000005206725PA7930942026-01-22False