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
17060000024102L17/dossiers17170600000240701706000002407031PA7953102025-01-21False
17060000024103L17/dossiers17170600000240701706000002407032PA7944782025-01-21False
17060000024104L17/dossiers17170600000240701706000002407033PA8419472025-01-21False
17060000024105L17/dossiers17170600000240701706000002407034PA7940822025-01-21False
17060000024106L17/dossiers17170600000240701706000002407035PA7941302025-01-21False
17060000024107L17/dossiers17170600000240701706000002407036PA7208462025-01-21False
17060000024108L17/dossiers17170600000240701706000002407037PA8417292025-01-21False
17060000024109L17/dossiers17170600000240701706000002407038PA7955162025-01-21False
17060000024110L17/dossiers17170600000240701706000002407039PA7956722025-01-21False
17060000024111L17/dossiers17170600000240701706000002407040PA8415152025-01-21False
17060000024112L17/dossiers17170600000240701706000002407041PA7957462025-01-21False
17060000024113L17/dossiers17170600000240701706000002407042PA7951082025-01-21False
17060000024114L17/dossiers17170600000240701706000002407043PA7952982025-01-21False
17060000024115L17/dossiers17170600000240701706000002407044PA7918242025-01-21False
17060000024116L17/dossiers17170600000240701706000002407045PA8420292025-01-21False
17060000024117L17/dossiers17170600000240701706000002407046PA7935322025-01-21False
17060000024118L17/dossiers17170600000240701706000002407047PA3423842025-01-21False
17060000024119L17/dossiers17170600000240701706000002407048PA7954222025-01-21False
17060000024120L17/dossiers17170600000240701706000002407049PA7946862025-01-21False
17060000024121L17/dossiers17170600000240701706000002407050PA8412152025-01-21False
17060000024122L17/dossiers17170600000240701706000002407051PA7954822025-01-21False
17060000024123L17/dossiers17170600000240701706000002407052PA6106542025-01-21False
17060000024124L17/dossiers17170600000240701706000002407053PA8411912025-01-21False
17060000024125L17/dossiers17170600000240701706000002407054PA7219602025-01-21False
17060000024126L17/dossiers17170600000240701706000002407055PA7938722025-01-21False
17060000024127L17/dossiers17170600000240701706000002407056PA7208922025-01-21False
17060000024128L17/dossiers17170600000240701706000002407057PA8172112025-01-21False
17060000024129L17/dossiers17170600000240701706000002407058PA7937562025-01-21False
17060000024130L17/dossiers17170600000240701706000002407059PA7960622025-01-21False
17060000024131L17/dossiers17170600000240701706000002407060PA7195782025-01-21False
17060000024132L17/dossiers17170600000240701706000002407061PA7210622025-01-21False
17060000024133L17/dossiers17170600000240701706000002407062PA8418452025-01-21False
17060000024134L17/dossiers17170600000240701706000002407063PA7959822025-01-21False
17060000024135L17/dossiers17170600000240701706000002407064PA7954662025-01-21False
17060000024136L17/dossiers17170600000240701706000002407065PA7937442025-01-21False
17060000024137L17/dossiers17170600000240701706000002407066PA7209522025-01-21False
17060000024138L17/dossiers17170600000240701706000002407067PA7941062025-01-21False
17060000024139L17/dossiers17170600000240701706000002407068PA7941662025-01-21False
17060000024140L17/dossiers17170600000240701706000002407069PA7951642025-01-21False
17060000024141L17/dossiers17170600000240701706000002407070PA7955962025-01-21False
17060000024148L17/dossiers1717060000024146170600000241461PA7195582025-02-11False
17060000024149L17/dossiers1717060000024146170600000241462PA7202562025-02-11False
17060000024150L17/dossiers1717060000024146170600000241463PA7952782025-02-11False
17060000024151L17/dossiers1717060000024146170600000241464PA7190242025-02-11False
17060000024152L17/dossiers1717060000024146170600000241465PA6065072025-02-11False
17060000024153L17/dossiers1717060000024146170600000241466PA7190322025-02-11False
17060000024154L17/dossiers1717060000024146170600000241467PA8413392025-02-11False
17060000024155L17/dossiers1717060000024146170600000241468PA7943302025-02-11False
17060000024156L17/dossiers1717060000024146170600000241469PA7198902025-02-11False
17060000024157L17/dossiers17170600000241461706000002414610PA7220002025-02-11False