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
17060000047577L17/dossiers1717060000047571170600000475715PA7941382025-10-14False
17060000047578L17/dossiers1717060000047571170600000475716PA7955882025-10-14False
17060000047579L17/dossiers1717060000047571170600000475717PA7950842025-10-14False
17060000047580L17/dossiers1717060000047571170600000475718PA8421052025-10-14False
17060000047581L17/dossiers1717060000047571170600000475719PA8416572025-10-14False
17060000047582L17/dossiers17170600000475711706000004757110PA7204302025-10-14False
17060000047583L17/dossiers17170600000475711706000004757111PA7937722025-10-14False
17060000047584L17/dossiers17170600000475711706000004757112PA7956162025-10-14False
17060000047585L17/dossiers17170600000475711706000004757113PA7934442025-10-14False
17060000047586L17/dossiers17170600000475711706000004757114PA7949382025-10-14False
17060000047587L17/dossiers17170600000475711706000004757115PA7953182025-10-14False
17060000047588L17/dossiers17170600000475711706000004757116PA8410232025-10-14False
17060000047589L17/dossiers17170600000475711706000004757117PA7960902025-10-14False
17060000047590L17/dossiers17170600000475711706000004757118PA7939122025-10-14False
17060000047591L17/dossiers17170600000475711706000004757119PA8421872025-10-14False
17060000047592L17/dossiers17170600000475711706000004757120PA8420372025-10-14False
17060000047593L17/dossiers17170600000475711706000004757121PA7918122025-10-14False
17060000047594L17/dossiers17170600000475711706000004757122PA7937362025-10-14False
17060000047595L17/dossiers17170600000475711706000004757123PA7212022025-10-14False
17060000047596L17/dossiers17170600000475711706000004757124PA7951362025-10-14False
17060000047597L17/dossiers17170600000475711706000004757125PA7934642025-10-14False
17060000047598L17/dossiers17170600000475711706000004757126PA8421552025-10-14False
17060000047599L17/dossiers17170600000475711706000004757127PA7952002025-10-14False
17060000047600L17/dossiers17170600000475711706000004757128PA7958442025-10-14False
17060000047601L17/dossiers17170600000475711706000004757129PA8412512025-10-14False
17060000047602L17/dossiers17170600000475711706000004757130PA7947862025-10-14False
17060000047603L17/dossiers17170600000475711706000004757131PA7948702025-10-14False
17060000047604L17/dossiers17170600000475711706000004757132PA7960702025-10-14False
17060000047605L17/dossiers17170600000475711706000004757133PA7953102025-10-14False
17060000047606L17/dossiers17170600000475711706000004757134PA7944782025-10-14False
17060000047607L17/dossiers17170600000475711706000004757135PA8419472025-10-14False
17060000047608L17/dossiers17170600000475711706000004757136PA7940822025-10-14False
17060000047609L17/dossiers17170600000475711706000004757137PA7941302025-10-14False
17060000047610L17/dossiers17170600000475711706000004757138PA7208462025-10-14False
17060000047611L17/dossiers17170600000475711706000004757139PA8417292025-10-14False
17060000047612L17/dossiers17170600000475711706000004757140PA7955162025-10-14False
17060000047613L17/dossiers17170600000475711706000004757141PA7956722025-10-14False
17060000047614L17/dossiers17170600000475711706000004757142PA7957462025-10-14False
17060000047615L17/dossiers17170600000475711706000004757143PA7951082025-10-14False
17060000047616L17/dossiers17170600000475711706000004757144PA8415152025-10-14False
17060000047617L17/dossiers17170600000475711706000004757145PA7952982025-10-14False
17060000047618L17/dossiers17170600000475711706000004757146PA7918242025-10-14False
17060000047619L17/dossiers17170600000475711706000004757147PA8420292025-10-14False
17060000047620L17/dossiers17170600000475711706000004757148PA7935322025-10-14False
17060000047621L17/dossiers17170600000475711706000004757149PA3423842025-10-14False
17060000047622L17/dossiers17170600000475711706000004757150PA7954222025-10-14False
17060000047623L17/dossiers17170600000475711706000004757151PA7946862025-10-14False
17060000047624L17/dossiers17170600000475711706000004757152PA8412152025-10-14False
17060000047625L17/dossiers17170600000475711706000004757153PA7954822025-10-14False
17060000047626L17/dossiers17170600000475711706000004757154PA6106542025-10-14False