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
17060000023669L17/dossiers1717060000023666170600000236662PA8418012025-01-21False
17060000023670L17/dossiers1717060000023666170600000236663PA7221022025-01-21False
17060000023671L17/dossiers1717060000023666170600000236664PA8402352025-01-21False
17060000023675L17/dossiers1717060000023673170600000236731PA7208922025-02-24False
17060000023676L17/dossiers1717060000023673170600000236732PA7952282025-02-24False
17060000023677L17/dossiers1717060000023673170600000236733PA7932622025-02-24False
17060000023678L17/dossiers1717060000023673170600000236734PA7949062025-02-24False
17060000023679L17/dossiers1717060000023673170600000236735PA7941382025-02-24False
17060000023680L17/dossiers1717060000023673170600000236736PA7955882025-02-24False
17060000023681L17/dossiers1717060000023673170600000236737PA7950842025-02-24False
17060000023682L17/dossiers1717060000023673170600000236738PA8421052025-02-24False
17060000023683L17/dossiers1717060000023673170600000236739PA8416572025-02-24False
17060000023684L17/dossiers17170600000236731706000002367310PA7204302025-02-24False
17060000023685L17/dossiers17170600000236731706000002367311PA7937722025-02-24False
17060000023686L17/dossiers17170600000236731706000002367312PA7956162025-02-24False
17060000023687L17/dossiers17170600000236731706000002367313PA7934442025-02-24False
17060000023688L17/dossiers17170600000236731706000002367314PA7949382025-02-24False
17060000023689L17/dossiers17170600000236731706000002367315PA7953182025-02-24False
17060000023690L17/dossiers17170600000236731706000002367316PA8410232025-02-24False
17060000023691L17/dossiers17170600000236731706000002367317PA7960902025-02-24False
17060000023692L17/dossiers17170600000236731706000002367318PA7939122025-02-24False
17060000023693L17/dossiers17170600000236731706000002367319PA8421872025-02-24False
17060000023694L17/dossiers17170600000236731706000002367320PA8420372025-02-24False
17060000023695L17/dossiers17170600000236731706000002367321PA7918122025-02-24False
17060000023696L17/dossiers17170600000236731706000002367322PA7937362025-02-24False
17060000023697L17/dossiers17170600000236731706000002367323PA7212022025-02-24False
17060000023698L17/dossiers17170600000236731706000002367324PA7934642025-02-24False
17060000023699L17/dossiers17170600000236731706000002367325PA8421552025-02-24False
17060000023700L17/dossiers17170600000236731706000002367326PA7952002025-02-24False
17060000023701L17/dossiers17170600000236731706000002367327PA7958442025-02-24False
17060000023702L17/dossiers17170600000236731706000002367328PA8412512025-02-24False
17060000023703L17/dossiers17170600000236731706000002367329PA7947862025-02-24False
17060000023704L17/dossiers17170600000236731706000002367330PA7948702025-02-24False
17060000023705L17/dossiers17170600000236731706000002367331PA7960702025-02-24False
17060000023706L17/dossiers17170600000236731706000002367332PA7953102025-02-24False
17060000023707L17/dossiers17170600000236731706000002367333PA7944782025-02-24False
17060000023708L17/dossiers17170600000236731706000002367334PA8419472025-02-24False
17060000023709L17/dossiers17170600000236731706000002367335PA7940822025-02-24False
17060000023710L17/dossiers17170600000236731706000002367336PA7941302025-02-24False
17060000023711L17/dossiers17170600000236731706000002367337PA7208462025-02-24False
17060000023712L17/dossiers17170600000236731706000002367338PA8417292025-02-24False
17060000023713L17/dossiers17170600000236731706000002367339PA7955162025-02-24False
17060000023714L17/dossiers17170600000236731706000002367340PA7956722025-02-24False
17060000023715L17/dossiers17170600000236731706000002367341PA7957462025-02-24False
17060000023716L17/dossiers17170600000236731706000002367342PA7951082025-02-24False
17060000023717L17/dossiers17170600000236731706000002367343PA8415152025-02-24False
17060000023718L17/dossiers17170600000236731706000002367344PA7952982025-02-24False
17060000023719L17/dossiers17170600000236731706000002367345PA7918242025-02-24False
17060000023720L17/dossiers17170600000236731706000002367346PA8420292025-02-24False
17060000023721L17/dossiers17170600000236731706000002367347PA7935322025-02-24False