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
17060000020812L17/dossiers17170600000207651706000002076546PA3467822025-02-17False
17060000020816L17/dossiers1717060000020814170600000208141PA7219602025-03-24False
17060000020817L17/dossiers1717060000020814170600000208142PA3421962025-03-24False
17060000020818L17/dossiers1717060000020814170600000208143PA7938722025-03-24False
17060000020819L17/dossiers1717060000020814170600000208144PA7208922025-03-24False
17060000020820L17/dossiers1717060000020814170600000208145PA8417172025-03-24False
17060000020821L17/dossiers1717060000020814170600000208146PA8172112025-03-24False
17060000020822L17/dossiers1717060000020814170600000208147PA8412432025-03-24False
17060000020823L17/dossiers1717060000020814170600000208148PA7937562025-03-24False
17060000020824L17/dossiers1717060000020814170600000208149PA7749602025-03-24False
17060000020825L17/dossiers17170600000208141706000002081410PA7960622025-03-24False
17060000020826L17/dossiers17170600000208141706000002081411PA8410912025-03-24False
17060000020827L17/dossiers17170600000208141706000002081412PA7195782025-03-24False
17060000020828L17/dossiers17170600000208141706000002081413PA8416812025-03-24False
17060000020829L17/dossiers17170600000208141706000002081414PA7210622025-03-24False
17060000020830L17/dossiers17170600000208141706000002081415PA7944942025-03-24False
17060000020831L17/dossiers17170600000208141706000002081416PA7959822025-03-24False
17060000020832L17/dossiers17170600000208141706000002081417PA7209922025-03-24False
17060000020833L17/dossiers17170600000208141706000002081418PA7954662025-03-24False
17060000020834L17/dossiers17170600000208141706000002081419PA7937442025-03-24False
17060000020835L17/dossiers17170600000208141706000002081420PA7941662025-03-24False
17060000020836L17/dossiers17170600000208141706000002081421PA7951642025-03-24False
17060000020837L17/dossiers17170600000208141706000002081422PA7955962025-03-24False
17060000020838L17/dossiers17170600000208141706000002081423PA7960902025-03-24False
17060000020839L17/dossiers17170600000208141706000002081424PA7211102025-03-24False
17060000020840L17/dossiers17170600000208141706000002081425PA7947502025-03-24False
17060000020841L17/dossiers17170600000208141706000002081426PA3315822025-03-24False
17060000020842L17/dossiers17170600000208141706000002081427PA3359992025-03-24False
17060000020843L17/dossiers17170600000208141706000002081428PA7942062025-03-24False
17060000020844L17/dossiers17170600000208141706000002081429PA2670422025-03-24False
17060000020845L17/dossiers17170600000208141706000002081430PA7940822025-03-24False
17060000020846L17/dossiers17170600000208141706000002081431PA3300082025-03-24False
17060000020847L17/dossiers17170600000208141706000002081432PA6057452025-03-24False
17060000020848L17/dossiers17170600000208141706000002081433PA7190522025-03-24False
17060000020849L17/dossiers17170600000208141706000002081434PA6431752025-03-24False
17060000020850L17/dossiers17170600000208141706000002081435PA6431922025-03-24False
17060000020851L17/dossiers17170600000208141706000002081436PA7206442025-03-24False
17060000020852L17/dossiers17170600000208141706000002081437PA7951002025-03-24False
17060000020853L17/dossiers17170600000208141706000002081438PA7937362025-03-24False
17060000020854L17/dossiers17170600000208141706000002081439PA7937962025-03-24False
17060000020855L17/dossiers17170600000208141706000002081440PA7941542025-03-24False
17060000020856L17/dossiers17170600000208141706000002081441PA7203422025-03-24False
17060000020857L17/dossiers17170600000208141706000002081442PA7931742025-03-24False
17060000020858L17/dossiers17170600000208141706000002081443PA7933982025-03-24False
17060000020859L17/dossiers17170600000208141706000002081444PA2667932025-03-032025-03-20False
17060000020860L17/dossiers17170600000208141706000002081445PA6427642025-03-24False
17060000020861L17/dossiers17170600000208141706000002081446PA7953742025-03-24False
17060000020862L17/dossiers17170600000208141706000002081447PA6076192025-03-24False
17060000020863L17/dossiers17170600000208141706000002081448PA2673062025-03-24False
17060000020864L17/dossiers17170600000208141706000002081449PA7946582025-03-24False