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
17060000043592L17/dossiers17170600000435041706000004350487PA7201462025-10-07False
17060000043593L17/dossiers17170600000435041706000004350488PA6774832025-10-07False
17060000043594L17/dossiers17170600000435041706000004350489PA8419312025-10-07False
17060000043595L17/dossiers17170600000435041706000004350490PA7193382025-10-07False
17060000043596L17/dossiers17170600000435041706000004350491PA7203702025-10-07False
17060000043597L17/dossiers17170600000435041706000004350492PA7951762025-10-07False
17060000043598L17/dossiers17170600000435041706000004350493PA7956642025-10-07False
17060000043599L17/dossiers17170600000435041706000004350494PA7959622025-10-07False
17060000043600L17/dossiers17170600000435041706000004350495PA6076192025-10-07False
17060000043601L17/dossiers17170600000435041706000004350496PA7957222025-10-07False
17060000043602L17/dossiers17170600000435041706000004350497PA7196322025-10-07False
17060000043603L17/dossiers17170600000435041706000004350498PA7212342025-10-07False
17060000043604L17/dossiers17170600000435041706000004350499PA7935722025-10-07False
17060000043605L17/dossiers171706000004350417060000043504100PA7949942025-10-07False
17060000043606L17/dossiers171706000004350417060000043504101PA7219162025-10-07False
17060000043607L17/dossiers171706000004350417060000043504102PA7200922025-10-07False
17060000043608L17/dossiers171706000004350417060000043504103PA7952402025-10-07False
17060000043609L17/dossiers171706000004350417060000043504104PA3357582025-10-07False
17060000043610L17/dossiers171706000004350417060000043504105PA7214262025-10-07False
17060000043611L17/dossiers171706000004350417060000043504106PA7200662025-10-07False
17060000043612L17/dossiers171706000004350417060000043504107PA7222522025-10-07False
17060000043613L17/dossiers171706000004350417060000043504108PA7955282025-10-07False
17060000043614L17/dossiers171706000004350417060000043504109PA8419272025-10-07False
17060000043615L17/dossiers171706000004350417060000043504110PA7950762025-10-07False
17060000043616L17/dossiers171706000004350417060000043504111PA7958882025-10-07False
17060000043617L17/dossiers171706000004350417060000043504112PA7932702025-10-07False
17060000043618L17/dossiers171706000004350417060000043504113PA7749602025-10-07False
17060000043619L17/dossiers171706000004350417060000043504114PA7572252025-10-07False
17060000043620L17/dossiers171706000004350417060000043504115PA7934162025-10-07False
17060000043621L17/dossiers171706000004350417060000043504116PA7948022025-10-07False
17060000043622L17/dossiers171706000004350417060000043504117PA7201902025-10-07False
17060000043623L17/dossiers171706000004350417060000043504118PA7944862025-10-07False
17060000043624L17/dossiers171706000004350417060000043504119PA7195502025-10-07False
17060000043625L17/dossiers171706000004350417060000043504120PA7215842025-10-07False
17060000043626L17/dossiers171706000004350417060000043504121PA7959202025-10-07False
17060000043627L17/dossiers171706000004350417060000043504122PA6073952025-10-07False
17060000043628L17/dossiers171706000004350417060000043504123PA7221022025-10-07False
17060000043629L17/dossiers171706000004350417060000043504124PA7195122025-10-07False
17060000043630L17/dossiers171706000004350417060000043504125PA7214742025-10-07False
17060000043631L17/dossiers171706000004350417060000043504126PA7931942025-10-07False
17060000043632L17/dossiers171706000004350417060000043504127PA29602025-10-07False
17060000043633L17/dossiers171706000004350417060000043504128PA7950462025-10-07False
17060000043637L17/dossiers1717060000043635170600000436351PA8412952025-12-11False
17060000043638L17/dossiers1717060000043635170600000436352PA8406652025-12-11False
17060000043639L17/dossiers1717060000043635170600000436353PA6427642025-12-11False
17060000043640L17/dossiers1717060000043635170600000436354PA6431432025-12-11False
17060000043641L17/dossiers1717060000043635170600000436355PA8408292025-12-11False
17060000043642L17/dossiers1717060000043635170600000436356PA3424152025-12-11False
17060000043643L17/dossiers1717060000043635170600000436357PA6067932025-12-11False
17060000043644L17/dossiers1717060000043635170600000436358PA8422112025-12-11False