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
17060000018070L17/dossiers17170600000180201706000001802049PA7954222024-11-19False
17060000018071L17/dossiers17170600000180201706000001802050PA7946862024-11-19False
17060000018072L17/dossiers17170600000180201706000001802051PA8412152024-11-19False
17060000018073L17/dossiers17170600000180201706000001802052PA7954822024-11-19False
17060000018074L17/dossiers17170600000180201706000001802053PA6106542024-11-19False
17060000018075L17/dossiers17170600000180201706000001802054PA8411912024-11-19False
17060000018076L17/dossiers17170600000180201706000001802055PA7219602024-11-19False
17060000018077L17/dossiers17170600000180201706000001802056PA7938722024-11-19False
17060000018078L17/dossiers17170600000180201706000001802057PA8172112024-11-19False
17060000018079L17/dossiers17170600000180201706000001802058PA7937562024-11-19False
17060000018080L17/dossiers17170600000180201706000001802059PA7960622024-11-19False
17060000018081L17/dossiers17170600000180201706000001802060PA7195782024-11-19False
17060000018082L17/dossiers17170600000180201706000001802061PA7210622024-11-19False
17060000018083L17/dossiers17170600000180201706000001802062PA8418452024-11-19False
17060000018084L17/dossiers17170600000180201706000001802063PA7959822024-11-19False
17060000018085L17/dossiers17170600000180201706000001802064PA7954662024-11-19False
17060000018086L17/dossiers17170600000180201706000001802065PA7937442024-11-19False
17060000018087L17/dossiers17170600000180201706000001802066PA7209522024-11-19False
17060000018088L17/dossiers17170600000180201706000001802067PA7941062024-11-19False
17060000018089L17/dossiers17170600000180201706000001802068PA7941662024-11-19False
17060000018090L17/dossiers17170600000180201706000001802069PA7951642024-11-19False
17060000018091L17/dossiers17170600000180201706000001802070PA7955962024-11-19False
17060000018095L17/dossiers1717060000018093170600000180931PA6428472025-02-17False
17060000018096L17/dossiers1717060000018093170600000180932PA7188842025-02-17False
17060000018097L17/dossiers1717060000018093170600000180933PA7749542025-02-17False
17060000018098L17/dossiers1717060000018093170600000180934PA7199682025-02-17False
17060000018099L17/dossiers1717060000018093170600000180935PA3422402025-02-17False
17060000018100L17/dossiers1717060000018093170600000180936PA7935082025-02-17False
17060000018101L17/dossiers1717060000018093170600000180937PA7188502025-02-17False
17060000018102L17/dossiers1717060000018093170600000180938PA3325232024-11-192025-02-17False
17060000018103L17/dossiers1717060000018093170600000180939PA7203862025-02-17False
17060000018104L17/dossiers17170600000180931706000001809310PA6955122025-02-17False
17060000018105L17/dossiers17170600000180931706000001809311PA6080162025-02-17False
17060000018106L17/dossiers17170600000180931706000001809312PA7940382025-02-17False
17060000018107L17/dossiers17170600000180931706000001809313PA7206442025-02-17False
17060000018108L17/dossiers17170600000180931706000001809314PA7930942025-02-17False
17060000018109L17/dossiers17170600000180931706000001809315PA7941782025-02-17False
17060000018110L17/dossiers17170600000180931706000001809316PA6070902025-02-17False
17060000018114L17/dossiers1717060000018112170600000181121PA7949062025-01-22False
17060000018115L17/dossiers1717060000018112170600000181122PA8417292025-01-22False
17060000018116L17/dossiers1717060000018112170600000181123PA7932622025-01-22False
17060000018117L17/dossiers1717060000018112170600000181124PA7941382025-01-22False
17060000018118L17/dossiers1717060000018112170600000181125PA7955882025-01-22False
17060000018119L17/dossiers1717060000018112170600000181126PA7950842025-01-22False
17060000018120L17/dossiers1717060000018112170600000181127PA8421052025-01-22False
17060000018121L17/dossiers1717060000018112170600000181128PA8416572025-01-22False
17060000018122L17/dossiers1717060000018112170600000181129PA7937722025-01-22False
17060000018123L17/dossiers17170600000181121706000001811210PA7934442025-01-22False
17060000018124L17/dossiers17170600000181121706000001811211PA7953182025-01-22False
17060000018125L17/dossiers17170600000181121706000001811212PA8410232025-01-22False