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
17060000038893L17/dossiers17170600000388231706000003882369PA7959822025-06-04False
17060000038894L17/dossiers17170600000388231706000003882370PA7954662025-06-04False
17060000038895L17/dossiers17170600000388231706000003882371PA7937442025-06-04False
17060000038896L17/dossiers17170600000388231706000003882372PA7209522025-06-04False
17060000038897L17/dossiers17170600000388231706000003882373PA7941062025-06-04False
17060000038898L17/dossiers17170600000388231706000003882374PA7941662025-06-04False
17060000038899L17/dossiers17170600000388231706000003882375PA7951642025-06-04False
17060000038900L17/dossiers17170600000388231706000003882376PA7955962025-06-04False
17060000038907L17/dossiers1717060000038905170600000389051PA8408172025-07-08False
17060000038908L17/dossiers1717060000038905170600000389052PA7188502025-07-08False
17060000038909L17/dossiers1717060000038905170600000389053PA16302025-07-08False
17060000038910L17/dossiers1717060000038905170600000389054PA7192722025-07-08False
17060000038911L17/dossiers1717060000038905170600000389055PA7943542025-06-102025-07-07False
17060000038912L17/dossiers1717060000038905170600000389056PA7187842025-07-08False
17060000038913L17/dossiers1717060000038905170600000389057PA7936162025-06-102025-07-07False
17060000038914L17/dossiers1717060000038905170600000389058PA8413592025-07-08False
17060000038915L17/dossiers1717060000038905170600000389059PA7930942025-07-08False
17060000038916L17/dossiers17170600000389051706000003890510PA7941782025-07-08False
17060000038917L17/dossiers17170600000389051706000003890511PA7953862025-07-08False
17060000038918L17/dossiers17170600000389051706000003890512PA7955282025-07-08False
17060000038919L17/dossiers17170600000389051706000003890513PA6427252025-07-08False
17060000038920L17/dossiers17170600000389051706000003890514PA6430892025-07-08False
17060000038921L17/dossiers17170600000389051706000003890515PA7223902025-07-08False
17060000038922L17/dossiers17170600000389051706000003890516PA2675612025-07-072025-07-08False
17060000038923L17/dossiers17170600000389051706000003890517PA7214102025-07-08False
17060000038924L17/dossiers17170600000389051706000003890518PA8406572025-07-072025-07-08False
17060000038925L17/dossiers17170600000389051706000003890519PA6088262025-07-08False
17060000038926L17/dossiers17170600000389051706000003890520PA8407212025-07-082025-07-08False
17060000038927L17/dossiers17170600000389051706000003890521PA6955122025-07-08False
17060000038928L17/dossiers17170600000389051706000003890522PA6070902025-07-08False
17060000038929L17/dossiers17170600000389051706000003890523PA2672852025-07-08False
17060000038930L17/dossiers17170600000389051706000003890524PA4085782025-07-08False
17060000038931L17/dossiers17170600000389051706000003890525PA7214422025-07-08False
17060000038935L17/dossiers1717060000038933170600000389331PA7937802025-07-02False
17060000038936L17/dossiers1717060000038933170600000389332PA8418852025-07-02False
17060000038937L17/dossiers1717060000038933170600000389333PA7939802025-07-02False
17060000038938L17/dossiers1717060000038933170600000389334PA7936642025-07-02False
17060000038939L17/dossiers1717060000038933170600000389335PA7941542025-07-02False
17060000038940L17/dossiers1717060000038933170600000389336PA6100022025-07-02False
17060000038941L17/dossiers1717060000038933170600000389337PA7958082025-07-02False
17060000038945L17/dossiers1717060000038943170600000389431PA7961062025-06-10False
17060000038946L17/dossiers1717060000038943170600000389432PA7208382025-06-10False
17060000038947L17/dossiers1717060000038943170600000389433PA7947102025-06-10False
17060000038948L17/dossiers1717060000038943170600000389434PA7958682025-06-10False
17060000038949L17/dossiers1717060000038943170600000389435PA7218962025-06-10False
17060000038950L17/dossiers1717060000038943170600000389436PA7959982025-06-10False
17060000038951L17/dossiers1717060000038943170600000389437PA7749622025-06-10False
17060000038952L17/dossiers1717060000038943170600000389438PA3356122025-06-10False
17060000038953L17/dossiers1717060000038943170600000389439PA7960102025-06-10False
17060000038954L17/dossiers17170600000389431706000003894310PA8422712025-06-10False