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
17060000044269L17/dossiers17170600000442581706000004425810PA16302025-09-16False
17060000044270L17/dossiers17170600000442581706000004425811PA7944662025-09-16False
17060000044271L17/dossiers17170600000442581706000004425812PA8413592025-09-16False
17060000044272L17/dossiers17170600000442581706000004425813PA7212342025-09-16False
17060000044276L17/dossiers1717060000044274170600000442741PA7958082025-10-01False
17060000044277L17/dossiers1717060000044274170600000442742PA5888842025-10-01False
17060000044278L17/dossiers1717060000044274170600000442743PA8417012025-10-01False
17060000044279L17/dossiers1717060000044274170600000442744PA7953622025-10-01False
17060000044280L17/dossiers1717060000044274170600000442745PA8418852025-10-01False
17060000044281L17/dossiers1717060000044274170600000442746PA8415072025-10-01False
17060000044282L17/dossiers1717060000044274170600000442747PA8421872025-10-01False
17060000044283L17/dossiers1717060000044274170600000442748PA7212102025-10-01False
17060000044284L17/dossiers1717060000044274170600000442749PA8416652025-10-01False
17060000044285L17/dossiers17170600000442741706000004427410PA8420132025-10-01False
17060000044286L17/dossiers17170600000442741706000004427411PA8401712025-09-162025-10-01False
17060000044287L17/dossiers17170600000442741706000004427412PA8409472025-10-01False
17060000044288L17/dossiers17170600000442741706000004427413PA7941302025-10-01False
17060000044289L17/dossiers17170600000442741706000004427414PA7941462025-10-01False
17060000044290L17/dossiers17170600000442741706000004427415PA8412232025-10-01False
17060000044291L17/dossiers17170600000442741706000004427416PA7749622025-10-01False
17060000044292L17/dossiers17170600000442741706000004427417PA8407652025-10-01False
17060000044293L17/dossiers17170600000442741706000004427418PA7956362025-10-01False
17060000044294L17/dossiers17170600000442741706000004427419PA8420452025-10-01False
17060000044295L17/dossiers17170600000442741706000004427420PA8413592025-10-01False
17060000044296L17/dossiers17170600000442741706000004427421PA7937082025-10-01False
17060000044297L17/dossiers17170600000442741706000004427422PA6081722025-10-01False
17060000044298L17/dossiers17170600000442741706000004427423PA7936642025-10-01False
17060000044299L17/dossiers17170600000442741706000004427424PA7200922025-10-01False
17060000044300L17/dossiers17170600000442741706000004427425PA7941542025-10-01False
17060000044301L17/dossiers17170600000442741706000004427426PA3419812025-10-01False
17060000044302L17/dossiers17170600000442741706000004427427PA7952402025-10-01False
17060000044303L17/dossiers17170600000442741706000004427428PA3421962025-10-01False
17060000044304L17/dossiers17170600000442741706000004427429PA7950762025-10-01False
17060000044305L17/dossiers17170600000442741706000004427430PA6100022025-10-01False
17060000044306L17/dossiers17170600000442741706000004427431PA8417132025-10-01False
17060000044307L17/dossiers17170600000442741706000004427432PA8418932025-10-01False
17060000044308L17/dossiers17170600000442741706000004427433PA29402025-10-01False
17060000044312L17/dossiers1717060000044310170600000443101PA7947622025-09-17False
17060000044313L17/dossiers1717060000044310170600000443102PA7931462025-09-17False
17060000044314L17/dossiers1717060000044310170600000443103PA8401352025-09-17False
17060000044315L17/dossiers1717060000044310170600000443104PA8417612025-09-17False
17060000044316L17/dossiers1717060000044310170600000443105PA8416212025-09-17False
17060000044317L17/dossiers1717060000044310170600000443106PA7932462025-09-17False
17060000044318L17/dossiers1717060000044310170600000443107PA8401432025-09-17False
17060000044319L17/dossiers1717060000044310170600000443108PA8408012025-09-17False
17060000044320L17/dossiers1717060000044310170600000443109PA7938922025-09-17False
17060000044321L17/dossiers17170600000443101706000004431010PA8417372025-09-17False
17060000044322L17/dossiers17170600000443101706000004431011PA7960342025-09-17False
17060000044323L17/dossiers17170600000443101706000004431012PA7931022025-09-17False
17060000044324L17/dossiers17170600000443101706000004431013PA8416052025-09-17False