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
17060000024798L17/dossiers17170600000247791706000002477918PA7200922025-04-10False
17060000024799L17/dossiers17170600000247791706000002477919PA7201382025-04-10False
17060000024800L17/dossiers17170600000247791706000002477920PA7211102025-04-10False
17060000024801L17/dossiers17170600000247791706000002477921PA7937962025-04-10False
17060000024802L17/dossiers17170600000247791706000002477922PA7214742025-04-10False
17060000024803L17/dossiers17170600000247791706000002477923PA7931942025-04-10False
17060000024811L17/dossiers1717060000024808170600000248081PA7940082025-01-21False
17060000024812L17/dossiers1717060000024808170600000248082PA7221902025-01-21False
17060000024816L17/dossiers1717060000024814170600000248141PA7943302025-01-30False
17060000024817L17/dossiers1717060000024814170600000248142PA7951242025-01-30False
17060000024818L17/dossiers1717060000024814170600000248143PA7214862025-01-30False
17060000024819L17/dossiers1717060000024814170600000248144PA13272025-01-30False
17060000024820L17/dossiers1717060000024814170600000248145PA3422402025-01-30False
17060000024821L17/dossiers1717060000024814170600000248146PA7948382025-01-30False
17060000024822L17/dossiers1717060000024814170600000248147PA8415392025-01-232025-01-29False
17060000024823L17/dossiers1717060000024814170600000248148PA7945542025-01-30False
17060000024824L17/dossiers1717060000024814170600000248149PA8420972025-01-30False
17060000024825L17/dossiers17170600000248141706000002481410PA7931942025-01-30False
17060000024826L17/dossiers17170600000248141706000002481411PA7935082025-01-30False
17060000024840L17/dossiers1717060000024838170600000248381PA7939922025-02-12False
17060000024841L17/dossiers1717060000024838170600000248382PA7952782025-02-12False
17060000024842L17/dossiers1717060000024838170600000248383PA7190322025-02-12False
17060000024843L17/dossiers1717060000024838170600000248384PA6428682025-02-12False
17060000024844L17/dossiers1717060000024838170600000248385PA2677802025-02-12False
17060000024845L17/dossiers1717060000024838170600000248386PA7944702025-02-12False
17060000024846L17/dossiers1717060000024838170600000248387PA7220702025-02-12False
17060000024847L17/dossiers1717060000024838170600000248388PA7192822025-02-12False
17060000024848L17/dossiers1717060000024838170600000248389PA8421252025-02-12False
17060000024849L17/dossiers17170600000248381706000002483810PA7944662025-02-12False
17060000024850L17/dossiers17170600000248381706000002483811PA7218442025-02-12False
17060000024851L17/dossiers17170600000248381706000002483812PA7935722025-02-12False
17060000024852L17/dossiers17170600000248381706000002483813PA7950262025-02-12False
17060000024856L17/dossiers1717060000024854170600000248541PA7197782025-03-03False
17060000024857L17/dossiers1717060000024854170600000248542PA7942782025-03-03False
17060000024858L17/dossiers1717060000024854170600000248543PA7952782025-03-03False
17060000024859L17/dossiers1717060000024854170600000248544PA3322282025-03-03False
17060000024860L17/dossiers1717060000024854170600000248545PA6872142025-03-03False
17060000024861L17/dossiers1717060000024854170600000248546PA7190322025-03-03False
17060000024862L17/dossiers1717060000024854170600000248547PA8413392025-03-03False
17060000024863L17/dossiers1717060000024854170600000248548PA6428682025-03-03False
17060000024864L17/dossiers1717060000024854170600000248549PA8414312025-03-03False
17060000024865L17/dossiers17170600000248541706000002485410PA2677802025-03-03False
17060000024866L17/dossiers17170600000248541706000002485411PA7944702025-03-03False
17060000024867L17/dossiers17170600000248541706000002485412PA7942342025-03-03False
17060000024868L17/dossiers17170600000248541706000002485413PA7220702025-03-03False
17060000024869L17/dossiers17170600000248541706000002485414PA7192822025-03-03False
17060000024870L17/dossiers17170600000248541706000002485415PA8421252025-03-03False
17060000024871L17/dossiers17170600000248541706000002485416PA7944262025-03-03False
17060000024872L17/dossiers17170600000248541706000002485417PA7948382025-03-03False
17060000024873L17/dossiers17170600000248541706000002485418PA7202302025-03-03False