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
17060000034763L17/dossiers17170600000347101706000003471052PA7954822025-04-17False
17060000034764L17/dossiers17170600000347101706000003471053PA6106542025-04-17False
17060000034765L17/dossiers17170600000347101706000003471054PA8411912025-04-17False
17060000034766L17/dossiers17170600000347101706000003471055PA7219602025-04-17False
17060000034767L17/dossiers17170600000347101706000003471056PA7938722025-04-17False
17060000034768L17/dossiers17170600000347101706000003471057PA8172112025-04-17False
17060000034769L17/dossiers17170600000347101706000003471058PA7937562025-04-17False
17060000034770L17/dossiers17170600000347101706000003471059PA7960622025-04-17False
17060000034771L17/dossiers17170600000347101706000003471060PA7195782025-04-17False
17060000034772L17/dossiers17170600000347101706000003471061PA7210622025-04-17False
17060000034773L17/dossiers17170600000347101706000003471062PA8418452025-04-17False
17060000034774L17/dossiers17170600000347101706000003471063PA7959822025-04-17False
17060000034775L17/dossiers17170600000347101706000003471064PA7954662025-04-17False
17060000034776L17/dossiers17170600000347101706000003471065PA7937442025-04-17False
17060000034777L17/dossiers17170600000347101706000003471066PA7209522025-04-17False
17060000034778L17/dossiers17170600000347101706000003471067PA7941062025-04-17False
17060000034779L17/dossiers17170600000347101706000003471068PA7941662025-04-17False
17060000034780L17/dossiers17170600000347101706000003471069PA7951642025-04-17False
17060000034781L17/dossiers17170600000347101706000003471070PA7955962025-04-17False
17060000034785L17/dossiers1717060000034783170600000347831PA8226172025-06-19False
17060000034786L17/dossiers1717060000034783170600000347832PA8406652025-06-19False
17060000034787L17/dossiers1717060000034783170600000347833PA6109682025-06-19False
17060000034788L17/dossiers1717060000034783170600000347834PA6427642025-06-19False
17060000034789L17/dossiers1717060000034783170600000347835PA8417012025-06-19False
17060000034790L17/dossiers1717060000034783170600000347836PA8408292025-06-19False
17060000034791L17/dossiers1717060000034783170600000347837PA8422112025-06-19False
17060000034792L17/dossiers1717060000034783170600000347838PA8413152025-06-19False
17060000034793L17/dossiers1717060000034783170600000347839PA7940942025-06-19False
17060000034794L17/dossiers17170600000347831706000003478310PA7957622025-06-19False
17060000034795L17/dossiers17170600000347831706000003478311PA6082642025-06-19False
17060000034796L17/dossiers17170600000347831706000003478312PA7958682025-06-19False
17060000034797L17/dossiers17170600000347831706000003478313PA7199222025-06-19False
17060000034798L17/dossiers17170600000347831706000003478314PA8409032025-06-19False
17060000034799L17/dossiers17170600000347831706000003478315PA8412952025-06-19False
17060000034800L17/dossiers17170600000347831706000003478316PA10082025-06-19False
17060000034801L17/dossiers17170600000347831706000003478317PA7954302025-06-19False
17060000034802L17/dossiers17170600000347831706000003478318PA6065732025-06-19False
17060000034803L17/dossiers17170600000347831706000003478319PA8416332025-06-19False
17060000034804L17/dossiers17170600000347831706000003478320PA6431752025-06-19False
17060000034805L17/dossiers17170600000347831706000003478321PA7948542025-06-19False
17060000034806L17/dossiers17170600000347831706000003478322PA8421952025-06-19False
17060000034807L17/dossiers17170600000347831706000003478323PA7946582025-06-19False
17060000034808L17/dossiers17170600000347831706000003478324PA6056942025-06-19False
17060000034809L17/dossiers17170600000347831706000003478325PA6093322025-06-19False
17060000034810L17/dossiers17170600000347831706000003478326PA8416652025-06-19False
17060000034811L17/dossiers17170600000347831706000003478327PA8415392025-06-19False
17060000034812L17/dossiers17170600000347831706000003478328PA3319732025-06-19False
17060000034813L17/dossiers17170600000347831706000003478329PA8401712025-06-19False
17060000034814L17/dossiers17170600000347831706000003478330PA15672025-06-19False
17060000034815L17/dossiers17170600000347831706000003478331PA8422632025-06-19False