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
17060000046796L17/dossiers171706000004667517060000046675120PA7946702025-09-302025-10-01False
17060000046797L17/dossiers171706000004667517060000046675121PA8411992025-09-302025-10-01False
17060000046798L17/dossiers171706000004667517060000046675122PA8419552025-09-302025-10-01False
17060000046799L17/dossiers171706000004667517060000046675123PA7954102025-09-302025-10-01False
17060000046800L17/dossiers171706000004667517060000046675124PA7948942025-09-302025-10-01False
17060000046801L17/dossiers171706000004667517060000046675125PA7945702025-09-302025-10-01False
17060000046802L17/dossiers171706000004667517060000046675126PA7949542025-09-302025-10-01False
17060000046803L17/dossiers171706000004667517060000046675127PA8422552025-09-302025-10-01False
17060000046804L17/dossiers171706000004667517060000046675128PA7945022025-09-302025-10-01False
17060000046811L17/dossiers1717060000046809170600000468091PA7953862025-09-30False
17060000046812L17/dossiers1717060000046809170600000468092PA7951762025-09-30False
17060000046813L17/dossiers1717060000046809170600000468093PA7955282025-09-30False
17060000046814L17/dossiers1717060000046809170600000468094PA7201382025-09-30False
17060000046815L17/dossiers1717060000046809170600000468095PA29602025-09-30False
17060000046819L17/dossiers1717060000046817170600000468171PA7918242025-09-30False
17060000046820L17/dossiers1717060000046817170600000468172PA7208922025-09-30False
17060000046821L17/dossiers1717060000046817170600000468173PA7952282025-09-30False
17060000046822L17/dossiers1717060000046817170600000468174PA7932622025-09-30False
17060000046823L17/dossiers1717060000046817170600000468175PA7949062025-09-30False
17060000046824L17/dossiers1717060000046817170600000468176PA7941382025-09-30False
17060000046825L17/dossiers1717060000046817170600000468177PA7955882025-09-30False
17060000046826L17/dossiers1717060000046817170600000468178PA7950842025-09-30False
17060000046827L17/dossiers1717060000046817170600000468179PA8421052025-09-30False
17060000046828L17/dossiers17170600000468171706000004681710PA8416572025-09-30False
17060000046829L17/dossiers17170600000468171706000004681711PA7204302025-09-30False
17060000046830L17/dossiers17170600000468171706000004681712PA7937722025-09-30False
17060000046831L17/dossiers17170600000468171706000004681713PA7956162025-09-30False
17060000046832L17/dossiers17170600000468171706000004681714PA7934442025-09-30False
17060000046833L17/dossiers17170600000468171706000004681715PA7949382025-09-30False
17060000046834L17/dossiers17170600000468171706000004681716PA7953182025-09-30False
17060000046835L17/dossiers17170600000468171706000004681717PA8410232025-09-30False
17060000046836L17/dossiers17170600000468171706000004681718PA7960902025-09-30False
17060000046837L17/dossiers17170600000468171706000004681719PA7939122025-09-30False
17060000046838L17/dossiers17170600000468171706000004681720PA8421872025-09-30False
17060000046839L17/dossiers17170600000468171706000004681721PA8420372025-09-30False
17060000046840L17/dossiers17170600000468171706000004681722PA7937362025-09-30False
17060000046841L17/dossiers17170600000468171706000004681723PA7212022025-09-30False
17060000046842L17/dossiers17170600000468171706000004681724PA7951362025-09-30False
17060000046843L17/dossiers17170600000468171706000004681725PA7934642025-09-30False
17060000046844L17/dossiers17170600000468171706000004681726PA8421552025-09-30False
17060000046845L17/dossiers17170600000468171706000004681727PA7952002025-09-30False
17060000046846L17/dossiers17170600000468171706000004681728PA7958442025-09-30False
17060000046847L17/dossiers17170600000468171706000004681729PA8412512025-09-30False
17060000046848L17/dossiers17170600000468171706000004681730PA7947862025-09-30False
17060000046849L17/dossiers17170600000468171706000004681731PA7948702025-09-30False
17060000046850L17/dossiers17170600000468171706000004681732PA7960702025-09-30False
17060000046851L17/dossiers17170600000468171706000004681733PA7953102025-09-30False
17060000046852L17/dossiers17170600000468171706000004681734PA7944782025-09-30False
17060000046853L17/dossiers17170600000468171706000004681735PA8419472025-09-30False
17060000046854L17/dossiers17170600000468171706000004681736PA7940822025-09-30False