Aller au contenu
blackout

dossiers.document_co_signataire

Chemin document.coSignataires.coSignataire · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %

309 313 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 26 %, 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
17060000111145L17/dossiers1717060000111143170600001111431PA8736252026-07-09True
17060000111152L17/dossiers1717060000111150170600001111501PA7598342026-07-22True
17060000111155L17/dossiers1717060000111153170600001111531PA7209082026-07-22True
17060000111158L17/dossiers1717060000111156170600001111561PA7218362026-07-27True
17060000111161L17/dossiers1717060000111159170600001111591PA7218362026-07-27True
17060000111164L17/dossiers1717060000111162170600001111621PA8736242026-09-10True
17060000111165L17/dossiers1717060000111162170600001111622PA7959502026-09-10True
17060000111168L17/dossiers1717060000111166170600001111661PA7218362026-09-16True
17060000111171L17/dossiers1717060000111169170600001111691PA7598342026-09-16True
17060000111172L17/dossiers1717060000111169170600001111692PA6078462026-09-16True
17060000111173L17/dossiers1717060000111169170600001111693PA7200662026-09-16True
17060000111176L17/dossiers1717060000111174170600001111741PA7209082026-09-16True
17060000111452L17/dossiers1717060000111450170600001114501PA7211342026-10-14True
17060000111455L17/dossiers1717060000111453170600001114531PA7211342026-10-14True
17060000111458L17/dossiers1717060000111456170600001114561PA7218362026-10-22True
17060000111461L17/dossiers1717060000111459170600001114591PA7218362026-10-22True
16060000000622L16/dossiers1616060000000620160600000006201PA3314812022-10-19True
16060000000623L16/dossiers1616060000000620160600000006202PA7221902022-10-19True
16060000000626L16/dossiers1616060000000624160600000006241PA3314812022-11-02True
16060000000627L16/dossiers1616060000000624160600000006242PA7221902022-11-02True
16060000000630L16/dossiers1616060000000628160600000006281PA7221902022-10-20True
16060000000631L16/dossiers1616060000000628160600000006282PA3314812022-10-20True
16060000000632L16/dossiers1616060000000628160600000006283PA8018622022-10-20True
16060000000635L16/dossiers1616060000000633160600000006331PA7221902022-10-26True
16060000000636L16/dossiers1616060000000633160600000006332PA3314812022-10-26True
16060000000637L16/dossiers1616060000000633160600000006333PA8018622022-10-26True
16060000000658L16/dossiers1616060000000656160600000006561PA3314812023-10-18True
16060000000659L16/dossiers1616060000000656160600000006562PA7939402023-10-18True
16060000000662L16/dossiers1616060000000660160600000006601PA3314812023-11-07True
16060000000663L16/dossiers1616060000000660160600000006602PA7939402023-11-07True
16060000000666L16/dossiers1616060000000664160600000006641PA3314812023-10-25True
16060000000667L16/dossiers1616060000000664160600000006642PA8266352023-10-25True
16060000000668L16/dossiers1616060000000664160600000006643PA7939402023-10-25True
16060000000671L16/dossiers1616060000000669160600000006691PA3314812023-10-30True
16060000000672L16/dossiers1616060000000669160600000006692PA8266352023-10-30True
16060000000673L16/dossiers1616060000000669160600000006693PA7939402023-10-30True
16060000001521L16/dossiers1616060000001519160600000015191PA3314812022-09-26True
16060000001522L16/dossiers1616060000001519160600000015192PA7221902022-09-26True
16060000001533L16/dossiers1616060000001531160600000015311PA3314812022-09-26True
16060000001534L16/dossiers1616060000001531160600000015312PA7221902022-09-26True
16060000001545L16/dossiers1616060000001543160600000015431PA3314812022-09-26True
16060000001546L16/dossiers1616060000001543160600000015432PA7221902022-09-26True
16060000001557L16/dossiers1616060000001555160600000015551PA7221902022-09-26True
16060000001558L16/dossiers1616060000001555160600000015552PA3314812022-09-26True
16060000001559L16/dossiers1616060000001555160600000015553PA8018622022-09-26True
16060000001564L16/dossiers1616060000001562160600000015621PA7221902022-09-26True
16060000001565L16/dossiers1616060000001562160600000015622PA3314812022-09-26True
16060000001566L16/dossiers1616060000001562160600000015623PA8018622022-09-26True
16060000001571L16/dossiers1616060000001569160600000015691PA7221902022-09-26True
16060000001572L16/dossiers1616060000001569160600000015692PA3314812022-09-26True