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 151 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
17060000006923L17/dossiers1717060000006914170600000069148PA7951082024-10-30False
17060000006924L17/dossiers1717060000006914170600000069149PA3332852024-10-30False
17060000006925L17/dossiers17170600000069141706000000691410PA7749622024-10-30False
17060000006926L17/dossiers17170600000069141706000000691411PA7946862024-10-30False
17060000006927L17/dossiers17170600000069141706000000691412PA7956722024-10-30False
17060000006928L17/dossiers17170600000069141706000000691413PA6076192024-10-30False
17060000006929L17/dossiers17170600000069141706000000691414PA29402024-10-30False
17060000006930L17/dossiers17170600000069141706000000691415PA7950762024-10-30False
17060000006931L17/dossiers17170600000069141706000000691416PA8415072024-10-30False
17060000006932L17/dossiers17170600000069141706000000691417PA7941542024-10-30False
17060000006933L17/dossiers17170600000069141706000000691418PA8420132024-10-30False
17060000006934L17/dossiers17170600000069141706000000691419PA8409972024-10-30False
17060000006935L17/dossiers17170600000069141706000000691420PA7934522024-10-30False
17060000006936L17/dossiers17170600000069141706000000691421PA8420452024-10-30False
17060000006937L17/dossiers17170600000069141706000000691422PA8412232024-10-30False
17060000006938L17/dossiers17170600000069141706000000691423PA8417132024-10-30False
17060000006939L17/dossiers17170600000069141706000000691424PA6065452024-10-30False
17060000006940L17/dossiers17170600000069141706000000691425PA7937082024-10-30False
17060000006941L17/dossiers17170600000069141706000000691426PA8418852024-10-30False
17060000006942L17/dossiers17170600000069141706000000691427PA7937802024-10-30False
17060000006943L17/dossiers17170600000069141706000000691428PA8414192024-10-30False
17060000006944L17/dossiers17170600000069141706000000691429PA7947782024-10-30False
17060000006945L17/dossiers17170600000069141706000000691430PA7950102024-10-30False
17060000006946L17/dossiers17170600000069141706000000691431PA8422112024-10-30False
17060000006947L17/dossiers17170600000069141706000000691432PA7209522024-10-30False
17060000006948L17/dossiers17170600000069141706000000691433PA8415392024-10-30False
17060000006949L17/dossiers17170600000069141706000000691434PA8421872024-10-30False
17060000006950L17/dossiers17170600000069141706000000691435PA8417012024-10-30False
17060000006951L17/dossiers17170600000069141706000000691436PA8401712024-10-30False
17060000006952L17/dossiers17170600000069141706000000691437PA3424152024-10-30False
17060000006953L17/dossiers17170600000069141706000000691438PA7954542024-10-30False
17060000006954L17/dossiers17170600000069141706000000691439PA7221422024-10-30False
17060000006955L17/dossiers17170600000069141706000000691440PA8406652024-10-30False
17060000006956L17/dossiers17170600000069141706000000691441PA7952402024-10-30False
17060000006957L17/dossiers17170600000069141706000000691442PA8422632024-10-30False
17060000006958L17/dossiers17170600000069141706000000691443PA7192862024-10-30False
17060000006959L17/dossiers17170600000069141706000000691444PA8409472024-10-30False
17060000006963L17/dossiers1717060000006961170600000069611PA6429352026-01-20False
17060000006964L17/dossiers1717060000006961170600000069612PA3322282026-01-20False
17060000006965L17/dossiers1717060000006961170600000069613PA8051662026-01-20False
17060000006966L17/dossiers1717060000006961170600000069614PA3096432026-01-20False
17060000006967L17/dossiers1717060000006961170600000069615PA7190242026-01-20False
17060000006968L17/dossiers1717060000006961170600000069616PA7201622026-01-20False
17060000006969L17/dossiers1717060000006961170600000069617PA7214102026-01-20False
17060000006970L17/dossiers1717060000006961170600000069618PA2667932026-01-20False
17060000006971L17/dossiers1717060000006961170600000069619PA6426952026-01-20False
17060000006972L17/dossiers17170600000069611706000000696110PA3422402026-01-20False
17060000006973L17/dossiers17170600000069611706000000696111PA7935082026-01-20False
17060000006974L17/dossiers17170600000069611706000000696112PA7198902026-01-20False
17060000006975L17/dossiers17170600000069611706000000696113PA8408172026-01-20False