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
17060000034604L17/dossiers17170600000345611706000003456142PA7932702025-04-17False
17060000034605L17/dossiers17170600000345611706000003456143PA8412432025-04-17False
17060000034606L17/dossiers17170600000345611706000003456144PA7934162025-04-17False
17060000034607L17/dossiers17170600000345611706000003456145PA7201902025-04-17False
17060000034608L17/dossiers17170600000345611706000003456146PA7195502025-04-17False
17060000034609L17/dossiers17170600000345611706000003456147PA6073952025-04-17False
17060000034610L17/dossiers17170600000345611706000003456148PA7221022025-04-17False
17060000034611L17/dossiers17170600000345611706000003456149PA7195122025-04-17False
17060000034612L17/dossiers17170600000345611706000003456150PA7950262025-04-17False
17060000034613L17/dossiers17170600000345611706000003456151PA7950462025-04-17False
17060000034617L17/dossiers1717060000034615170600000346151PA7201622025-06-04False
17060000034618L17/dossiers1717060000034615170600000346152PA7943302025-06-04False
17060000034619L17/dossiers1717060000034615170600000346153PA7939122025-06-04False
17060000034620L17/dossiers1717060000034615170600000346154PA8413592025-06-04False
17060000034621L17/dossiers1717060000034615170600000346155PA7939802025-06-04False
17060000034622L17/dossiers1717060000034615170600000346156PA7958202025-06-04False
17060000034623L17/dossiers1717060000034615170600000346157PA7941182025-06-04False
17060000034624L17/dossiers1717060000034615170600000346158PA7950262025-06-04False
17060000034625L17/dossiers1717060000034615170600000346159PA6109682025-06-04False
17060000034626L17/dossiers17170600000346151706000003461510PA8408292025-06-04False
17060000034627L17/dossiers17170600000346151706000003461511PA8422112025-06-04False
17060000034628L17/dossiers17170600000346151706000003461512PA8413152025-06-04False
17060000034629L17/dossiers17170600000346151706000003461513PA8415072025-06-04False
17060000034630L17/dossiers17170600000346151706000003461514PA7940942025-06-04False
17060000034631L17/dossiers17170600000346151706000003461515PA7918122025-06-04False
17060000034632L17/dossiers17170600000346151706000003461516PA10082025-06-04False
17060000034633L17/dossiers17170600000346151706000003461517PA7933942025-06-04False
17060000034634L17/dossiers17170600000346151706000003461518PA7948542025-06-04False
17060000034635L17/dossiers17170600000346151706000003461519PA6056942025-06-04False
17060000034636L17/dossiers17170600000346151706000003461520PA8414192025-06-04False
17060000034637L17/dossiers17170600000346151706000003461521PA3319732025-06-04False
17060000034638L17/dossiers17170600000346151706000003461522PA8401712025-06-04False
17060000034639L17/dossiers17170600000346151706000003461523PA8422632025-06-04False
17060000034640L17/dossiers17170600000346151706000003461524PA6431922025-06-04False
17060000034641L17/dossiers17170600000346151706000003461525PA7959982025-06-04False
17060000034642L17/dossiers17170600000346151706000003461526PA3350542025-06-04False
17060000034643L17/dossiers17170600000346151706000003461527PA8412232025-06-04False
17060000034644L17/dossiers17170600000346151706000003461528PA8416932025-06-04False
17060000034645L17/dossiers17170600000346151706000003461529PA7194122025-06-04False
17060000034646L17/dossiers17170600000346151706000003461530PA7951082025-06-04False
17060000034647L17/dossiers17170600000346151706000003461531PA7749582025-06-04False
17060000034648L17/dossiers17170600000346151706000003461532PA8414632025-06-04False
17060000034649L17/dossiers17170600000346151706000003461533PA8411072025-06-04False
17060000034650L17/dossiers17170600000346151706000003461534PA7948302025-06-04False
17060000034651L17/dossiers17170600000346151706000003461535PA7203342025-06-04False
17060000034652L17/dossiers17170600000346151706000003461536PA7932102025-06-04False
17060000034653L17/dossiers17170600000346151706000003461537PA6081722025-06-04False
17060000034654L17/dossiers17170600000346151706000003461538PA6075532025-06-04False
17060000034655L17/dossiers17170600000346151706000003461539PA7952702025-06-04False
17060000034656L17/dossiers17170600000346151706000003461540PA7958762025-06-04False