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
17060000040621L17/dossiers17170600000405701706000004057050PA7749622025-12-16False
17060000040622L17/dossiers17170600000405701706000004057051PA7952402025-12-16False
17060000040623L17/dossiers17170600000405701706000004057052PA7191382025-12-16False
17060000040624L17/dossiers17170600000405701706000004057053PA8413592025-12-16False
17060000040625L17/dossiers17170600000405701706000004057054PA6056942025-12-16False
17060000040626L17/dossiers17170600000405701706000004057055PA8402352025-12-16False
17060000040627L17/dossiers17170600000405701706000004057056PA7212962025-12-16False
17060000040628L17/dossiers17170600000405701706000004057057PA7222522025-12-16False
17060000040629L17/dossiers17170600000405701706000004057058PA7946582025-12-16False
17060000040630L17/dossiers17170600000405701706000004057059PA7950262025-12-16False
17060000040631L17/dossiers17170600000405701706000004057060PA7957622025-12-16False
17060000040635L17/dossiers1717060000040633170600000406331PA7933742025-07-11False
17060000040636L17/dossiers1717060000040633170600000406332PA6428472025-07-11False
17060000040637L17/dossiers1717060000040633170600000406333PA7188842025-07-11False
17060000040638L17/dossiers1717060000040633170600000406334PA3422402025-07-11False
17060000040639L17/dossiers1717060000040633170600000406335PA8408172025-07-11False
17060000040640L17/dossiers1717060000040633170600000406336PA7191382025-07-11False
17060000040641L17/dossiers1717060000040633170600000406337PA7945542025-07-11False
17060000040642L17/dossiers1717060000040633170600000406338PA7223902025-07-11False
17060000040643L17/dossiers1717060000040633170600000406339PA7120152025-07-11False
17060000040644L17/dossiers17170600000406331706000004063310PA7201542025-07-11False
17060000040645L17/dossiers17170600000406331706000004063311PA6088262025-07-11False
17060000040646L17/dossiers17170600000406331706000004063312PA6431752025-07-11False
17060000040647L17/dossiers17170600000406331706000004063313PA6056942025-07-11False
17060000040648L17/dossiers17170600000406331706000004063314PA2673182025-07-11False
17060000040649L17/dossiers17170600000406331706000004063315PA8421252025-07-11False
17060000040650L17/dossiers17170600000406331706000004063316PA3457222025-07-11False
17060000040651L17/dossiers17170600000406331706000004063317PA7947022025-07-11False
17060000040652L17/dossiers17170600000406331706000004063318PA7202302025-07-11False
17060000040653L17/dossiers17170600000406331706000004063319PA7209762025-07-11False
17060000040654L17/dossiers17170600000406331706000004063320PA8419312025-07-11False
17060000040655L17/dossiers17170600000406331706000004063321PA8413592025-07-11False
17060000040656L17/dossiers17170600000406331706000004063322PA7935722025-07-11False
17060000040657L17/dossiers17170600000406331706000004063323PA7949942025-07-11False
17060000040658L17/dossiers17170600000406331706000004063324PA7952702025-07-11False
17060000040659L17/dossiers17170600000406331706000004063325PA7930942025-07-11False
17060000040660L17/dossiers17170600000406331706000004063326PA8406572025-07-11False
17060000040661L17/dossiers17170600000406331706000004063327PA7214262025-07-11False
17060000040662L17/dossiers17170600000406331706000004063328PA2668082025-07-11False
17060000040663L17/dossiers17170600000406331706000004063329PA8419272025-07-11False
17060000040664L17/dossiers17170600000406331706000004063330PA8420972025-07-11False
17060000040665L17/dossiers17170600000406331706000004063331PA7934162025-07-11False
17060000040666L17/dossiers17170600000406331706000004063332PA7950262025-07-11False
17060000040667L17/dossiers17170600000406331706000004063333PA7931942025-07-11False
17060000040668L17/dossiers17170600000406331706000004063334PA29522025-07-11False
17060000040672L17/dossiers1717060000040670170600000406701PA8417012026-03-03False
17060000040673L17/dossiers1717060000040670170600000406702PA8416812026-03-03False
17060000040674L17/dossiers1717060000040670170600000406703PA3457222026-03-03False
17060000040675L17/dossiers1717060000040670170600000406704PA7221902026-03-03False
17060000040676L17/dossiers1717060000040670170600000406705PA7932102026-03-03False