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
17060000019940L17/dossiers1717060000019937170600000199372PA4085782025-02-17False
17060000019941L17/dossiers1717060000019937170600000199373PA7749542025-02-17False
17060000019942L17/dossiers1717060000019937170600000199374PA7199682025-02-17False
17060000019943L17/dossiers1717060000019937170600000199375PA2667932025-02-17False
17060000019944L17/dossiers1717060000019937170600000199376PA3422402025-02-17False
17060000019945L17/dossiers1717060000019937170600000199377PA7935082025-02-17False
17060000019946L17/dossiers1717060000019937170600000199378PA7188502025-02-17False
17060000019947L17/dossiers1717060000019937170600000199379PA7223902025-02-17False
17060000019948L17/dossiers17170600000199371706000001993710PA3309092025-02-17False
17060000019949L17/dossiers17170600000199371706000001993711PA3325232024-12-032025-02-17False
17060000019950L17/dossiers17170600000199371706000001993712PA7203862025-02-17False
17060000019951L17/dossiers17170600000199371706000001993713PA6088262025-02-17False
17060000019952L17/dossiers17170600000199371706000001993714PA2667972025-02-17False
17060000019953L17/dossiers17170600000199371706000001993715PA7940582025-02-17False
17060000019954L17/dossiers17170600000199371706000001993716PA7223282025-02-17False
17060000019955L17/dossiers17170600000199371706000001993717PA8409792025-02-17False
17060000019956L17/dossiers17170600000199371706000001993718PA6080162025-02-17False
17060000019957L17/dossiers17170600000199371706000001993719PA6060982025-02-17False
17060000019958L17/dossiers17170600000199371706000001993720PA7192722025-02-17False
17060000019959L17/dossiers17170600000199371706000001993721PA7940382025-02-17False
17060000019960L17/dossiers17170600000199371706000001993722PA7206442025-02-17False
17060000019961L17/dossiers17170600000199371706000001993723PA7930942025-02-17False
17060000019962L17/dossiers17170600000199371706000001993724PA7941182025-02-17False
17060000019966L17/dossiers1717060000019964170600000199641PA7934322025-03-11False
17060000019967L17/dossiers1717060000019964170600000199642PA7961182025-03-11False
17060000019968L17/dossiers1717060000019964170600000199643PA7945622025-03-11False
17060000019969L17/dossiers1717060000019964170600000199644PA2675612025-03-11False
17060000019970L17/dossiers1717060000019964170600000199645PA7933742025-03-11False
17060000019971L17/dossiers1717060000019964170600000199646PA7931582025-03-11False
17060000019972L17/dossiers1717060000019964170600000199647PA3096432025-03-11False
17060000019973L17/dossiers1717060000019964170600000199648PA7206682025-03-11False
17060000019974L17/dossiers1717060000019964170600000199649PA7948862025-03-11False
17060000019975L17/dossiers17170600000199641706000001996410PA7960422025-03-11False
17060000019976L17/dossiers17170600000199641706000001996411PA7938442025-03-11False
17060000019977L17/dossiers17170600000199641706000001996412PA8411312025-03-11False
17060000019978L17/dossiers17170600000199641706000001996413PA7931822025-03-11False
17060000019979L17/dossiers17170600000199641706000001996414PA8407212025-03-11False
17060000019980L17/dossiers17170600000199641706000001996415PA7204682025-03-11False
17060000019981L17/dossiers17170600000199641706000001996416PA7941982025-03-11False
17060000019982L17/dossiers17170600000199641706000001996417PA8401592025-03-11False
17060000019983L17/dossiers17170600000199641706000001996418PA7935482025-03-11False
17060000019984L17/dossiers17170600000199641706000001996419PA7933222025-03-11False
17060000019985L17/dossiers17170600000199641706000001996420PA7956442025-03-11False
17060000019986L17/dossiers17170600000199641706000001996421PA7939282025-03-11False
17060000019987L17/dossiers17170600000199641706000001996422PA7931462025-03-11False
17060000019988L17/dossiers17170600000199641706000001996423PA8401352025-03-11False
17060000019989L17/dossiers17170600000199641706000001996424PA8420732025-03-11False
17060000019990L17/dossiers17170600000199641706000001996425PA7932462025-03-11False
17060000019991L17/dossiers17170600000199641706000001996426PA8416132025-03-11False
17060000019992L17/dossiers17170600000199641706000001996427PA7946782025-03-11False