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
17060000044531L17/dossiers17170600000444521706000004445278PA7941062025-11-12False
17060000044532L17/dossiers17170600000444521706000004445279PA7941662025-11-12False
17060000044533L17/dossiers17170600000444521706000004445280PA7951642025-11-12False
17060000044534L17/dossiers17170600000444521706000004445281PA7955962025-11-12False
17060000044535L17/dossiers17170600000444521706000004445282PA7208922025-11-12False
17060000044536L17/dossiers17170600000444521706000004445283PA7212702025-11-12False
17060000044537L17/dossiers17170600000444521706000004445284PA3421962025-11-12False
17060000044538L17/dossiers17170600000444521706000004445285PA7221422025-11-12False
17060000044539L17/dossiers17170600000444521706000004445286PA6057452025-11-12False
17060000044540L17/dossiers17170600000444521706000004445287PA7195502025-11-12False
17060000044547L17/dossiers1717060000044545170600000445451PA8413592025-10-09False
17060000044548L17/dossiers1717060000044545170600000445452PA6056942025-10-09False
17060000044549L17/dossiers1717060000044545170600000445453PA2677632025-10-09False
17060000044550L17/dossiers1717060000044545170600000445454PA8408172025-10-09False
17060000044551L17/dossiers1717060000044545170600000445455PA7952702025-10-09False
17060000044552L17/dossiers1717060000044545170600000445456PA7203542025-10-09False
17060000044553L17/dossiers1717060000044545170600000445457PA7191382025-10-09False
17060000044554L17/dossiers1717060000044545170600000445458PA7223902025-10-09False
17060000044555L17/dossiers1717060000044545170600000445459PA7221422025-10-09False
17060000044556L17/dossiers17170600000445451706000004454510PA8406732025-10-09False
17060000044557L17/dossiers17170600000445451706000004454511PA2673182025-10-09False
17060000044558L17/dossiers17170600000445451706000004454512PA7945542025-10-09False
17060000044559L17/dossiers17170600000445451706000004454513PA7202302025-10-09False
17060000044560L17/dossiers17170600000445451706000004454514PA7937962025-10-09False
17060000044561L17/dossiers17170600000445451706000004454515PA7941142025-10-09False
17060000044562L17/dossiers17170600000445451706000004454516PA8409392025-10-09False
17060000044566L17/dossiers1717060000044564170600000445641PA8419272025-09-16False
17060000044570L17/dossiers1717060000044568170600000445681PA2677802025-09-16False
17060000044571L17/dossiers1717060000044568170600000445682PA8226172025-09-16False
17060000044572L17/dossiers1717060000044568170600000445683PA7194122025-09-16False
17060000044573L17/dossiers1717060000044568170600000445684PA7947022025-09-16False
17060000044574L17/dossiers1717060000044568170600000445685PA7202302025-09-16False
17060000044575L17/dossiers1717060000044568170600000445686PA7942062025-09-16False
17060000044576L17/dossiers1717060000044568170600000445687PA8419312025-09-16False
17060000044577L17/dossiers1717060000044568170600000445688PA6076192025-09-16False
17060000044578L17/dossiers1717060000044568170600000445689PA7212342025-09-16False
17060000044579L17/dossiers17170600000445681706000004456810PA7201902025-09-16False
17060000044580L17/dossiers17170600000445681706000004456811PA7937962025-09-16False
17060000044581L17/dossiers17170600000445681706000004456812PA7959202025-09-16False
17060000044582L17/dossiers17170600000445681706000004456813PA7221622025-09-16False
17060000044583L17/dossiers17170600000445681706000004456814PA7195122025-09-16False
17060000044584L17/dossiers17170600000445681706000004456815PA7214742025-09-16False
17060000044585L17/dossiers17170600000445681706000004456816PA3315822025-09-16False
17060000044586L17/dossiers17170600000445681706000004456817PA6088262025-09-16False
17060000044587L17/dossiers17170600000445681706000004456818PA7944262025-09-16False
17060000044588L17/dossiers17170600000445681706000004456819PA2677632025-09-16False
17060000044589L17/dossiers17170600000445681706000004456820PA8408172025-09-16False
17060000044590L17/dossiers17170600000445681706000004456821PA7945542025-09-16False
17060000044591L17/dossiers17170600000445681706000004456822PA8413592025-09-16False
17060000044592L17/dossiers17170600000445681706000004456823PA7947982025-09-16False