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
17060000019731L17/dossiers17170600000196641706000001966466PA7213142025-03-04False
17060000019732L17/dossiers17170600000196641706000001966467PA7572252025-03-04False
17060000019733L17/dossiers17170600000196641706000001966468PA7201902025-03-04False
17060000019734L17/dossiers17170600000196641706000001966469PA8416812025-03-04False
17060000019735L17/dossiers17170600000196641706000001966470PA7944862025-03-04False
17060000019736L17/dossiers17170600000196641706000001966471PA7195502025-03-04False
17060000019737L17/dossiers17170600000196641706000001966472PA7937962025-03-04False
17060000019738L17/dossiers17170600000196641706000001966473PA7223362025-03-04False
17060000019739L17/dossiers17170600000196641706000001966474PA6073952025-03-04False
17060000019740L17/dossiers17170600000196641706000001966475PA7221022025-03-04False
17060000019741L17/dossiers17170600000196641706000001966476PA7195122025-03-04False
17060000019742L17/dossiers17170600000196641706000001966477PA7214742025-03-04False
17060000019743L17/dossiers17170600000196641706000001966478PA7204462025-03-04False
17060000019744L17/dossiers17170600000196641706000001966479PA7195582025-03-04False
17060000019745L17/dossiers17170600000196641706000001966480PA7198902025-03-04False
17060000019746L17/dossiers17170600000196641706000001966481PA6774832025-03-04False
17060000019747L17/dossiers17170600000196641706000001966482PA7213362025-03-04False
17060000019748L17/dossiers17170600000196641706000001966483PA7933942025-03-04False
17060000019749L17/dossiers17170600000196641706000001966484PA7197982025-03-04False
17060000019750L17/dossiers17170600000196641706000001966485PA7959502025-03-04False
17060000019751L17/dossiers17170600000196641706000001966486PA7211582025-03-04False
17060000019752L17/dossiers17170600000196641706000001966487PA7951442025-03-04False
17060000019753L17/dossiers17170600000196641706000001966488PA7221902025-03-04False
17060000019754L17/dossiers17170600000196641706000001966489PA6429352025-03-04False
17060000019755L17/dossiers17170600000196641706000001966490PA6426952025-03-04False
17060000019756L17/dossiers17170600000196641706000001966491PA6065072025-03-04False
17060000019757L17/dossiers17170600000196641706000001966492PA7959902025-03-04False
17060000019758L17/dossiers17170600000196641706000001966493PA7220002025-03-04False
17060000019759L17/dossiers17170600000196641706000001966494PA7947982025-03-04False
17060000019760L17/dossiers17170600000196641706000001966495PA7217502025-03-04False
17060000019761L17/dossiers17170600000196641706000001966496PA7953302025-03-04False
17060000019762L17/dossiers17170600000196641706000001966497PA8423112025-03-04False
17060000019763L17/dossiers17170600000196641706000001966498PA7199222025-03-04False
17060000019764L17/dossiers17170600000196641706000001966499PA7939402025-03-04False
17060000019765L17/dossiers171706000001966417060000019664100PA7194722025-03-04False
17060000019766L17/dossiers171706000001966417060000019664101PA7958642025-03-04False
17060000019767L17/dossiers171706000001966417060000019664102PA7959082025-03-04False
17060000019768L17/dossiers171706000001966417060000019664103PA7191182025-03-04False
17060000019769L17/dossiers171706000001966417060000019664104PA7223822025-03-04False
17060000019770L17/dossiers171706000001966417060000019664105PA7946582025-03-04False
17060000019771L17/dossiers171706000001966417060000019664106PA8402352025-03-04False
17060000019772L17/dossiers171706000001966417060000019664107PA7223662025-03-04False
17060000019773L17/dossiers171706000001966417060000019664108PA7197362025-03-04False
17060000019774L17/dossiers171706000001966417060000019664109PA7223582025-03-04False
17060000019775L17/dossiers171706000001966417060000019664110PA7210242025-03-04False
17060000019776L17/dossiers171706000001966417060000019664111PA7186742025-03-04False
17060000019777L17/dossiers171706000001966417060000019664112PA7212962025-03-04False
17060000019778L17/dossiers171706000001966417060000019664113PA7217642025-03-04False
17060000019779L17/dossiers171706000001966417060000019664114PA8417092025-03-04False
17060000019780L17/dossiers171706000001966417060000019664115PA2672002025-03-04False