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
17060000042741L17/dossiers17170600000426751706000004267565PA7937442025-07-11False
17060000042742L17/dossiers17170600000426751706000004267566PA7209522025-07-11False
17060000042743L17/dossiers17170600000426751706000004267567PA7941062025-07-11False
17060000042744L17/dossiers17170600000426751706000004267568PA7941662025-07-11False
17060000042745L17/dossiers17170600000426751706000004267569PA7951642025-07-11False
17060000042746L17/dossiers17170600000426751706000004267570PA7955962025-07-11False
17060000042750L17/dossiers1717060000042748170600000427481PA7937362025-07-11False
17060000042751L17/dossiers1717060000042748170600000427482PA7208922025-07-11False
17060000042752L17/dossiers1717060000042748170600000427483PA7952282025-07-11False
17060000042753L17/dossiers1717060000042748170600000427484PA7932622025-07-11False
17060000042754L17/dossiers1717060000042748170600000427485PA7949062025-07-11False
17060000042755L17/dossiers1717060000042748170600000427486PA7941382025-07-11False
17060000042756L17/dossiers1717060000042748170600000427487PA7955882025-07-11False
17060000042757L17/dossiers1717060000042748170600000427488PA7950842025-07-11False
17060000042758L17/dossiers1717060000042748170600000427489PA8421052025-07-11False
17060000042759L17/dossiers17170600000427481706000004274810PA8416572025-07-11False
17060000042760L17/dossiers17170600000427481706000004274811PA7204302025-07-11False
17060000042761L17/dossiers17170600000427481706000004274812PA7937722025-07-11False
17060000042762L17/dossiers17170600000427481706000004274813PA7956162025-07-11False
17060000042763L17/dossiers17170600000427481706000004274814PA7934442025-07-11False
17060000042764L17/dossiers17170600000427481706000004274815PA7949382025-07-11False
17060000042765L17/dossiers17170600000427481706000004274816PA7953182025-07-11False
17060000042766L17/dossiers17170600000427481706000004274817PA8410232025-07-11False
17060000042767L17/dossiers17170600000427481706000004274818PA7960902025-07-11False
17060000042768L17/dossiers17170600000427481706000004274819PA7939122025-07-11False
17060000042769L17/dossiers17170600000427481706000004274820PA8421872025-07-11False
17060000042770L17/dossiers17170600000427481706000004274821PA8420372025-07-11False
17060000042771L17/dossiers17170600000427481706000004274822PA7918122025-07-11False
17060000042772L17/dossiers17170600000427481706000004274823PA7212022025-07-11False
17060000042773L17/dossiers17170600000427481706000004274824PA7951362025-07-11False
17060000042774L17/dossiers17170600000427481706000004274825PA7934642025-07-11False
17060000042775L17/dossiers17170600000427481706000004274826PA8421552025-07-11False
17060000042776L17/dossiers17170600000427481706000004274827PA7952002025-07-11False
17060000042777L17/dossiers17170600000427481706000004274828PA7958442025-07-11False
17060000042778L17/dossiers17170600000427481706000004274829PA8412512025-07-11False
17060000042779L17/dossiers17170600000427481706000004274830PA7947862025-07-11False
17060000042780L17/dossiers17170600000427481706000004274831PA7960702025-07-11False
17060000042781L17/dossiers17170600000427481706000004274832PA7953102025-07-11False
17060000042782L17/dossiers17170600000427481706000004274833PA7944782025-07-11False
17060000042783L17/dossiers17170600000427481706000004274834PA8419472025-07-11False
17060000042784L17/dossiers17170600000427481706000004274835PA7940822025-07-11False
17060000042785L17/dossiers17170600000427481706000004274836PA7941302025-07-11False
17060000042786L17/dossiers17170600000427481706000004274837PA7208462025-07-11False
17060000042787L17/dossiers17170600000427481706000004274838PA8417292025-07-11False
17060000042788L17/dossiers17170600000427481706000004274839PA7955162025-07-11False
17060000042789L17/dossiers17170600000427481706000004274840PA7956722025-07-11False
17060000042790L17/dossiers17170600000427481706000004274841PA7957462025-07-11False
17060000042791L17/dossiers17170600000427481706000004274842PA7951082025-07-11False
17060000042792L17/dossiers17170600000427481706000004274843PA8415152025-07-11False
17060000042793L17/dossiers17170600000427481706000004274844PA7952982025-07-11False