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
17060000045986L17/dossiers1717060000045978170600000459787PA8412952025-11-24False
17060000045987L17/dossiers1717060000045978170600000459788PA10082025-11-24False
17060000045988L17/dossiers1717060000045978170600000459789PA7933942025-11-24False
17060000045989L17/dossiers17170600000459781706000004597810PA7954302025-11-24False
17060000045990L17/dossiers17170600000459781706000004597811PA8419192025-11-24False
17060000045991L17/dossiers17170600000459781706000004597812PA8416332025-11-24False
17060000045992L17/dossiers17170600000459781706000004597813PA7948542025-11-24False
17060000045993L17/dossiers17170600000459781706000004597814PA8421952025-11-24False
17060000045994L17/dossiers17170600000459781706000004597815PA8416652025-11-24False
17060000045995L17/dossiers17170600000459781706000004597816PA8401712025-11-24False
17060000045996L17/dossiers17170600000459781706000004597817PA8422632025-11-24False
17060000045997L17/dossiers17170600000459781706000004597818PA3350542025-11-24False
17060000045998L17/dossiers17170600000459781706000004597819PA8407652025-11-24False
17060000045999L17/dossiers17170600000459781706000004597820PA8414632025-11-24False
17060000046000L17/dossiers17170600000459781706000004597821PA6431572025-11-24False
17060000046001L17/dossiers17170600000459781706000004597822PA8407932025-11-24False
17060000046002L17/dossiers17170600000459781706000004597823PA7942702025-11-24False
17060000046003L17/dossiers17170600000459781706000004597824PA8409552025-11-24False
17060000046004L17/dossiers17170600000459781706000004597825PA8417172025-11-24False
17060000046005L17/dossiers17170600000459781706000004597826PA3403432025-11-24False
17060000046006L17/dossiers17170600000459781706000004597827PA8416812025-11-24False
17060000046007L17/dossiers17170600000459781706000004597828PA8418932025-11-24False
17060000046008L17/dossiers17170600000459781706000004597829PA7938162025-11-24False
17060000046012L17/dossiers1717060000046010170600000460101PA8409972025-09-16False
17060000046013L17/dossiers1717060000046010170600000460102PA7940082025-09-16False
17060000046014L17/dossiers1717060000046010170600000460103PA6109682025-09-16False
17060000046015L17/dossiers1717060000046010170600000460104PA7937802025-09-16False
17060000046016L17/dossiers1717060000046010170600000460105PA5888842025-09-16False
17060000046017L17/dossiers1717060000046010170600000460106PA8417012025-09-16False
17060000046018L17/dossiers1717060000046010170600000460107PA7953622025-09-16False
17060000046019L17/dossiers1717060000046010170600000460108PA7954542025-09-16False
17060000046020L17/dossiers1717060000046010170600000460109PA8418852025-09-16False
17060000046021L17/dossiers17170600000460101706000004601010PA8415072025-09-16False
17060000046022L17/dossiers17170600000460101706000004601011PA7212102025-09-16False
17060000046023L17/dossiers17170600000460101706000004601012PA7934522025-09-16False
17060000046024L17/dossiers17170600000460101706000004601013PA8413512025-09-16False
17060000046025L17/dossiers17170600000460101706000004601014PA7939802025-09-16False
17060000046026L17/dossiers17170600000460101706000004601015PA7950102025-09-16False
17060000046027L17/dossiers17170600000460101706000004601016PA8414192025-09-16False
17060000046028L17/dossiers17170600000460101706000004601017PA8420132025-09-16False
17060000046029L17/dossiers17170600000460101706000004601018PA8409472025-09-16False
17060000046030L17/dossiers17170600000460101706000004601019PA7940222025-09-16False
17060000046031L17/dossiers17170600000460101706000004601020PA7941462025-09-16False
17060000046032L17/dossiers17170600000460101706000004601021PA8412232025-09-16False
17060000046033L17/dossiers17170600000460101706000004601022PA7956362025-09-16False
17060000046034L17/dossiers17170600000460101706000004601023PA8420452025-09-16False
17060000046035L17/dossiers17170600000460101706000004601024PA7937082025-09-16False
17060000046036L17/dossiers17170600000460101706000004601025PA7936642025-09-16False
17060000046037L17/dossiers17170600000460101706000004601026PA7941542025-09-16False
17060000046038L17/dossiers17170600000460101706000004601027PA7947782025-09-16False