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
17060000047804L17/dossiers1717060000047797170600000477976PA7933742025-11-17False
17060000047808L17/dossiers1717060000047806170600000478061PA8412072025-10-29False
17060000047809L17/dossiers1717060000047806170600000478062PA8408892025-10-29False
17060000047810L17/dossiers1717060000047806170600000478063PA8407012025-10-29False
17060000047811L17/dossiers1717060000047806170600000478064PA8407212025-10-29False
17060000047812L17/dossiers1717060000047806170600000478065PA7933222025-10-29False
17060000047813L17/dossiers1717060000047806170600000478066PA8407732025-10-29False
17060000047814L17/dossiers1717060000047806170600000478067PA8409832025-10-29False
17060000047815L17/dossiers1717060000047806170600000478068PA8413952025-10-29False
17060000047816L17/dossiers1717060000047806170600000478069PA8406852025-10-29False
17060000047817L17/dossiers17170600000478061706000004780610PA7961182025-10-29False
17060000047818L17/dossiers17170600000478061706000004780611PA3096432025-10-29False
17060000047819L17/dossiers17170600000478061706000004780612PA7931342025-10-29False
17060000047820L17/dossiers17170600000478061706000004780613PA7932902025-10-29False
17060000047821L17/dossiers17170600000478061706000004780614PA8419312025-10-29False
17060000047822L17/dossiers17170600000478061706000004780615PA7933542025-10-29False
17060000047823L17/dossiers17170600000478061706000004780616PA7218162025-10-29False
17060000047824L17/dossiers17170600000478061706000004780617PA8401352025-10-29False
17060000047825L17/dossiers17170600000478061706000004780618PA7935922025-10-29False
17060000047826L17/dossiers17170600000478061706000004780619PA8420852025-10-29False
17060000047827L17/dossiers17170600000478061706000004780620PA7945702025-10-29False
17060000047828L17/dossiers17170600000478061706000004780621PA7956442025-10-29False
17060000047829L17/dossiers17170600000478061706000004780622PA7955402025-10-29False
17060000047830L17/dossiers17170600000478061706000004780623PA7945982025-10-29False
17060000047831L17/dossiers17170600000478061706000004780624PA6955122025-10-29False
17060000047832L17/dossiers17170600000478061706000004780625PA7219322025-10-29False
17060000047833L17/dossiers17170600000478061706000004780626PA8400752025-10-29False
17060000047834L17/dossiers17170600000478061706000004780627PA7946782025-10-29False
17060000047835L17/dossiers17170600000478061706000004780628PA8418732025-10-29False
17060000047836L17/dossiers17170600000478061706000004780629PA8409152025-10-29False
17060000047837L17/dossiers17170600000478061706000004780630PA8422552025-10-29False
17060000047838L17/dossiers17170600000478061706000004780631PA7933742025-10-29False
17060000047839L17/dossiers17170600000478061706000004780632PA7932462025-10-29False
17060000047840L17/dossiers17170600000478061706000004780633PA8408572025-10-29False
17060000047841L17/dossiers17170600000478061706000004780634PA7932302025-10-29False
17060000047842L17/dossiers17170600000478061706000004780635PA8418372025-10-29False
17060000047846L17/dossiers1717060000047844170600000478441PA7961062025-11-06False
17060000047847L17/dossiers1717060000047844170600000478442PA7947102025-11-06False
17060000047848L17/dossiers1717060000047844170600000478443PA7958682025-11-06False
17060000047849L17/dossiers1717060000047844170600000478444PA7218962025-11-06False
17060000047850L17/dossiers1717060000047844170600000478445PA7959982025-11-06False
17060000047851L17/dossiers1717060000047844170600000478446PA7749622025-11-06False
17060000047852L17/dossiers1717060000047844170600000478447PA3356122025-11-06False
17060000047853L17/dossiers1717060000047844170600000478448PA7960102025-11-06False
17060000047854L17/dossiers1717060000047844170600000478449PA8422712025-11-06False
17060000047855L17/dossiers17170600000478441706000004784410PA7931742025-11-06False
17060000047856L17/dossiers17170600000478441706000004784411PA7958202025-11-06False
17060000047857L17/dossiers17170600000478441706000004784412PA7212702025-11-06False
17060000047858L17/dossiers17170600000478441706000004784413PA7952402025-11-06False
17060000047859L17/dossiers17170600000478441706000004784414PA7958762025-11-06False