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
17060000047686L17/dossiers1717060000047681170600000476814PA8417012025-10-14False
17060000047687L17/dossiers1717060000047681170600000476815PA7953622025-10-14False
17060000047688L17/dossiers1717060000047681170600000476816PA7954542025-10-14False
17060000047689L17/dossiers1717060000047681170600000476817PA8418852025-10-14False
17060000047690L17/dossiers1717060000047681170600000476818PA8415072025-10-14False
17060000047691L17/dossiers1717060000047681170600000476819PA7212102025-10-14False
17060000047692L17/dossiers17170600000476811706000004768110PA7934522025-10-14False
17060000047693L17/dossiers17170600000476811706000004768111PA8413512025-10-14False
17060000047694L17/dossiers17170600000476811706000004768112PA7939802025-10-14False
17060000047695L17/dossiers17170600000476811706000004768113PA7950102025-10-14False
17060000047696L17/dossiers17170600000476811706000004768114PA8409472025-10-14False
17060000047697L17/dossiers17170600000476811706000004768115PA7940222025-10-14False
17060000047698L17/dossiers17170600000476811706000004768116PA7941462025-10-14False
17060000047699L17/dossiers17170600000476811706000004768117PA8412232025-10-14False
17060000047700L17/dossiers17170600000476811706000004768118PA7956362025-10-14False
17060000047701L17/dossiers17170600000476811706000004768119PA8420452025-10-14False
17060000047702L17/dossiers17170600000476811706000004768120PA7937082025-10-14False
17060000047703L17/dossiers17170600000476811706000004768121PA7936642025-10-14False
17060000047704L17/dossiers17170600000476811706000004768122PA7941542025-10-14False
17060000047705L17/dossiers17170600000476811706000004768123PA7947782025-10-14False
17060000047706L17/dossiers17170600000476811706000004768124PA6065452025-10-14False
17060000047707L17/dossiers17170600000476811706000004768125PA7950762025-10-14False
17060000047708L17/dossiers17170600000476811706000004768126PA7221422025-10-14False
17060000047709L17/dossiers17170600000476811706000004768127PA6100022025-10-14False
17060000047710L17/dossiers17170600000476811706000004768128PA7958082025-10-14False
17060000047711L17/dossiers17170600000476811706000004768129PA7960182025-10-14False
17060000047712L17/dossiers17170600000476811706000004768130PA8417132025-10-14False
17060000047713L17/dossiers17170600000476811706000004768131PA29402025-10-14False
17060000047717L17/dossiers1717060000047715170600000477151PA6109682025-10-14False
17060000047718L17/dossiers1717060000047715170600000477152PA7937802025-10-14False
17060000047719L17/dossiers1717060000047715170600000477153PA8417012025-10-14False
17060000047720L17/dossiers1717060000047715170600000477154PA7953622025-10-14False
17060000047721L17/dossiers1717060000047715170600000477155PA8409972025-10-14False
17060000047722L17/dossiers1717060000047715170600000477156PA8418852025-10-14False
17060000047723L17/dossiers1717060000047715170600000477157PA8415072025-10-14False
17060000047724L17/dossiers1717060000047715170600000477158PA7940942025-10-14False
17060000047725L17/dossiers1717060000047715170600000477159PA7212102025-10-14False
17060000047726L17/dossiers17170600000477151706000004771510PA7934522025-10-14False
17060000047727L17/dossiers17170600000477151706000004771511PA7954302025-10-14False
17060000047728L17/dossiers17170600000477151706000004771512PA8413512025-10-14False
17060000047729L17/dossiers17170600000477151706000004771513PA7939802025-10-14False
17060000047730L17/dossiers17170600000477151706000004771514PA7950102025-10-14False
17060000047731L17/dossiers17170600000477151706000004771515PA8414192025-10-14False
17060000047732L17/dossiers17170600000477151706000004771516PA8420132025-10-14False
17060000047733L17/dossiers17170600000477151706000004771517PA8422632025-10-14False
17060000047734L17/dossiers17170600000477151706000004771518PA8409472025-10-14False
17060000047735L17/dossiers17170600000477151706000004771519PA7941462025-10-14False
17060000047736L17/dossiers17170600000477151706000004771520PA8412232025-10-14False
17060000047737L17/dossiers17170600000477151706000004771521PA8420452025-10-14False
17060000047738L17/dossiers17170600000477151706000004771522PA7936642025-10-14False