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
17060000028015L17/dossiers17170600000279901706000002799024PA7208222025-03-11False
17060000028016L17/dossiers17170600000279901706000002799025PA7206682025-03-11False
17060000028017L17/dossiers17170600000279901706000002799026PA7938442025-03-11False
17060000028018L17/dossiers17170600000279901706000002799027PA8411312025-03-11False
17060000028019L17/dossiers17170600000279901706000002799028PA7931822025-03-11False
17060000028020L17/dossiers17170600000279901706000002799029PA7931342025-03-11False
17060000028021L17/dossiers17170600000279901706000002799030PA7941982025-03-11False
17060000028022L17/dossiers17170600000279901706000002799031PA7956442025-03-11False
17060000028023L17/dossiers17170600000279901706000002799032PA7947622025-03-11False
17060000028024L17/dossiers17170600000279901706000002799033PA7931462025-03-11False
17060000028025L17/dossiers17170600000279901706000002799034PA8420732025-03-11False
17060000028026L17/dossiers17170600000279901706000002799035PA8417612025-03-11False
17060000028027L17/dossiers17170600000279901706000002799036PA8416212025-03-11False
17060000028028L17/dossiers17170600000279901706000002799037PA7946782025-03-11False
17060000028029L17/dossiers17170600000279901706000002799038PA8417372025-03-11False
17060000028030L17/dossiers17170600000279901706000002799039PA7933622025-03-11False
17060000028031L17/dossiers17170600000279901706000002799040PA8407572025-03-11False
17060000028032L17/dossiers17170600000279901706000002799041PA7947342025-03-11False
17060000028033L17/dossiers17170600000279901706000002799042PA6429882025-03-11False
17060000028034L17/dossiers17170600000279901706000002799043PA7959002025-03-11False
17060000028035L17/dossiers17170600000279901706000002799044PA7940302025-03-11False
17060000028036L17/dossiers17170600000279901706000002799045PA8418372025-03-11False
17060000028037L17/dossiers17170600000279901706000002799046PA7960262025-03-11False
17060000028038L17/dossiers17170600000279901706000002799047PA8409672025-03-11False
17060000028039L17/dossiers17170600000279901706000002799048PA7939042025-03-11False
17060000028040L17/dossiers17170600000279901706000002799049PA7959742025-03-11False
17060000028041L17/dossiers17170600000279901706000002799050PA7945902025-03-11False
17060000028042L17/dossiers17170600000279901706000002799051PA8415632025-03-11False
17060000028043L17/dossiers17170600000279901706000002799052PA7933142025-03-11False
17060000028044L17/dossiers17170600000279901706000002799053PA7933302025-03-11False
17060000028045L17/dossiers17170600000279901706000002799054PA7936162025-03-11False
17060000028046L17/dossiers17170600000279901706000002799055PA7194362025-03-11False
17060000028047L17/dossiers17170600000279901706000002799056PA7933542025-03-11False
17060000028048L17/dossiers17170600000279901706000002799057PA7957862025-03-11False
17060000028049L17/dossiers17170600000279901706000002799058PA7936962025-03-11False
17060000028050L17/dossiers17170600000279901706000002799059PA7946702025-03-11False
17060000028051L17/dossiers17170600000279901706000002799060PA8411992025-03-11False
17060000028052L17/dossiers17170600000279901706000002799061PA7945822025-03-11False
17060000028053L17/dossiers17170600000279901706000002799062PA7959662025-03-11False
17060000028054L17/dossiers17170600000279901706000002799063PA7932302025-03-11False
17060000028055L17/dossiers17170600000279901706000002799064PA7932542025-03-11False
17060000028056L17/dossiers17170600000279901706000002799065PA8422272025-03-11False
17060000028057L17/dossiers17170600000279901706000002799066PA7944422025-03-11False
17060000028058L17/dossiers17170600000279901706000002799067PA7954102025-03-11False
17060000028059L17/dossiers17170600000279901706000002799068PA7948942025-03-11False
17060000028060L17/dossiers17170600000279901706000002799069PA7945702025-03-11False
17060000028061L17/dossiers17170600000279901706000002799070PA7949542025-03-11False
17060000028062L17/dossiers17170600000279901706000002799071PA7933822025-03-11False
17060000028063L17/dossiers17170600000279901706000002799072PA7949462025-03-11False
17060000028064L17/dossiers17170600000279901706000002799073PA8415752025-03-11False