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
17060000023610L17/dossiers17170600000235591706000002355950PA7946862025-01-21False
17060000023611L17/dossiers17170600000235591706000002355951PA8412152025-01-21False
17060000023612L17/dossiers17170600000235591706000002355952PA7954822025-01-21False
17060000023613L17/dossiers17170600000235591706000002355953PA6106542025-01-21False
17060000023614L17/dossiers17170600000235591706000002355954PA8411912025-01-21False
17060000023615L17/dossiers17170600000235591706000002355955PA7219602025-01-21False
17060000023616L17/dossiers17170600000235591706000002355956PA7938722025-01-21False
17060000023617L17/dossiers17170600000235591706000002355957PA8172112025-01-21False
17060000023618L17/dossiers17170600000235591706000002355958PA7937562025-01-21False
17060000023619L17/dossiers17170600000235591706000002355959PA7960622025-01-21False
17060000023620L17/dossiers17170600000235591706000002355960PA7195782025-01-21False
17060000023621L17/dossiers17170600000235591706000002355961PA7210622025-01-21False
17060000023622L17/dossiers17170600000235591706000002355962PA8418452025-01-21False
17060000023623L17/dossiers17170600000235591706000002355963PA7959822025-01-21False
17060000023624L17/dossiers17170600000235591706000002355964PA7954662025-01-21False
17060000023625L17/dossiers17170600000235591706000002355965PA7937442025-01-21False
17060000023626L17/dossiers17170600000235591706000002355966PA7209522025-01-21False
17060000023627L17/dossiers17170600000235591706000002355967PA7941062025-01-21False
17060000023628L17/dossiers17170600000235591706000002355968PA7941662025-01-21False
17060000023629L17/dossiers17170600000235591706000002355969PA7951642025-01-21False
17060000023630L17/dossiers17170600000235591706000002355970PA7955962025-01-21False
17060000023634L17/dossiers1717060000023632170600000236321PA8412072025-01-21False
17060000023635L17/dossiers1717060000023632170600000236322PA2675612025-01-21False
17060000023636L17/dossiers1717060000023632170600000236323PA7948862025-01-21False
17060000023637L17/dossiers1717060000023632170600000236324PA8400752025-01-21False
17060000023638L17/dossiers1717060000023632170600000236325PA8407012025-01-21False
17060000023639L17/dossiers1717060000023632170600000236326PA8407212025-01-21False
17060000023640L17/dossiers1717060000023632170600000236327PA7931662025-01-21False
17060000023641L17/dossiers1717060000023632170600000236328PA7945982025-01-21False
17060000023642L17/dossiers1717060000023632170600000236329PA8409832025-01-21False
17060000023643L17/dossiers17170600000236321706000002363210PA7959742025-01-21False
17060000023644L17/dossiers17170600000236321706000002363211PA7947702025-01-21False
17060000023645L17/dossiers17170600000236321706000002363212PA7933142025-01-21False
17060000023646L17/dossiers17170600000236321706000002363213PA7936162025-01-21False
17060000023647L17/dossiers17170600000236321706000002363214PA7951242025-01-21False
17060000023648L17/dossiers17170600000236321706000002363215PA8406572025-01-21False
17060000023649L17/dossiers17170600000236321706000002363216PA8422272025-01-21False
17060000023653L17/dossiers1717060000023651170600000236511PA8408172025-02-03False
17060000023654L17/dossiers1717060000023651170600000236512PA7194722025-02-03False
17060000023655L17/dossiers1717060000023651170600000236513PA7946582025-02-03False
17060000023656L17/dossiers1717060000023651170600000236514PA8421172025-02-03False
17060000023657L17/dossiers1717060000023651170600000236515PA7202302025-02-03False
17060000023658L17/dossiers1717060000023651170600000236516PA8419312025-02-03False
17060000023659L17/dossiers1717060000023651170600000236517PA7948302025-02-03False
17060000023660L17/dossiers1717060000023651170600000236518PA7212342025-02-03False
17060000023661L17/dossiers1717060000023651170600000236519PA7205522025-02-03False
17060000023662L17/dossiers17170600000236511706000002365110PA7941782025-02-03False
17060000023663L17/dossiers17170600000236511706000002365111PA7223362025-02-03False
17060000023664L17/dossiers17170600000236511706000002365112PA7950262025-02-03False
17060000023668L17/dossiers1717060000023666170600000236661PA7932702025-01-21False