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
17060000050866L17/dossiers17170600000508381706000005083827PA7935922025-11-18False
17060000050867L17/dossiers17170600000508381706000005083828PA7948862025-11-18False
17060000050868L17/dossiers17170600000508381706000005083829PA7945822025-11-18False
17060000050869L17/dossiers17170600000508381706000005083830PA8417612025-11-18False
17060000050870L17/dossiers17170600000508381706000005083831PA7946782025-11-18False
17060000050871L17/dossiers17170600000508381706000005083832PA7941982025-11-18False
17060000050872L17/dossiers17170600000508381706000005083833PA8418732025-11-18False
17060000050873L17/dossiers17170600000508381706000005083834PA8408572025-11-18False
17060000050874L17/dossiers17170600000508381706000005083835PA7960342025-11-18False
17060000050875L17/dossiers17170600000508381706000005083836PA8417372025-11-18False
17060000050879L17/dossiers1717060000050877170600000508771PA7198902025-11-18False
17060000050880L17/dossiers1717060000050877170600000508772PA7203542025-11-18False
17060000050881L17/dossiers1717060000050877170600000508773PA7120142025-11-18False
17060000050882L17/dossiers1717060000050877170600000508774PA7201462025-11-18False
17060000050883L17/dossiers1717060000050877170600000508775PA8419272025-11-18False
17060000050884L17/dossiers1717060000050877170600000508776PA7944862025-11-18False
17060000050885L17/dossiers1717060000050877170600000508777PA7221022025-11-18False
17060000050886L17/dossiers1717060000050877170600000508778PA29602025-11-18False
17060000050893L17/dossiers1717060000050891170600000508911PA8410672025-11-21False
17060000050894L17/dossiers1717060000050891170600000508912PA8414952025-11-21False
17060000050895L17/dossiers1717060000050891170600000508913PA7961182025-11-21False
17060000050896L17/dossiers1717060000050891170600000508914PA7945622025-11-21False
17060000050897L17/dossiers1717060000050891170600000508915PA7932382025-11-21False
17060000050898L17/dossiers1717060000050891170600000508916PA7933742025-11-21False
17060000050899L17/dossiers1717060000050891170600000508917PA7931582025-11-21False
17060000050900L17/dossiers1717060000050891170600000508918PA7944342025-11-21False
17060000050901L17/dossiers1717060000050891170600000508919PA8416452025-11-21False
17060000050902L17/dossiers17170600000508911706000005089110PA8420012025-11-21False
17060000050903L17/dossiers17170600000508911706000005089111PA7206682025-11-21False
17060000050904L17/dossiers17170600000508911706000005089112PA7948862025-11-21False
17060000050905L17/dossiers17170600000508911706000005089113PA8411312025-11-21False
17060000050906L17/dossiers17170600000508911706000005089114PA7931342025-11-21False
17060000050907L17/dossiers17170600000508911706000005089115PA8407212025-11-21False
17060000050908L17/dossiers17170600000508911706000005089116PA7204682025-11-21False
17060000050909L17/dossiers17170600000508911706000005089117PA7941982025-11-21False
17060000050910L17/dossiers17170600000508911706000005089118PA7933222025-11-21False
17060000050911L17/dossiers17170600000508911706000005089119PA7956442025-11-21False
17060000050912L17/dossiers17170600000508911706000005089120PA8401192025-11-21False
17060000050913L17/dossiers17170600000508911706000005089121PA7931662025-11-21False
17060000050914L17/dossiers17170600000508911706000005089122PA7939282025-11-21False
17060000050915L17/dossiers17170600000508911706000005089123PA8401352025-11-21False
17060000050916L17/dossiers17170600000508911706000005089124PA8416212025-11-21False
17060000050917L17/dossiers17170600000508911706000005089125PA7932462025-11-21False
17060000050918L17/dossiers17170600000508911706000005089126PA8401432025-11-21False
17060000050919L17/dossiers17170600000508911706000005089127PA7946782025-11-21False
17060000050920L17/dossiers17170600000508911706000005089128PA8411392025-11-21False
17060000050921L17/dossiers17170600000508911706000005089129PA7938922025-11-21False
17060000050922L17/dossiers17170600000508911706000005089130PA8417372025-11-21False
17060000050923L17/dossiers17170600000508911706000005089131PA7960342025-11-21False
17060000050924L17/dossiers17170600000508911706000005089132PA7938322025-11-21False