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
17060000035758L17/dossiers1717060000035751170600000357516PA7949822025-05-20False
17060000035759L17/dossiers1717060000035751170600000357517PA8402352025-05-20False
17060000035760L17/dossiers1717060000035751170600000357518PA7223662025-05-20False
17060000035761L17/dossiers1717060000035751170600000357519PA7186742025-05-20False
17060000035762L17/dossiers17170600000357511706000003575110PA8416932025-05-20False
17060000035763L17/dossiers17170600000357511706000003575111PA7200222025-05-20False
17060000035764L17/dossiers17170600000357511706000003575112PA3457222025-05-20False
17060000035765L17/dossiers17170600000357511706000003575113PA7203422025-05-20False
17060000035766L17/dossiers17170600000357511706000003575114PA7222522025-05-20False
17060000035767L17/dossiers17170600000357511706000003575115PA7948022025-05-20False
17060000035768L17/dossiers17170600000357511706000003575116PA7944862025-05-20False
17060000035769L17/dossiers17170600000357511706000003575117PA7959202025-05-20False
17060000035770L17/dossiers17170600000357511706000003575118PA7221022025-05-20False
17060000035771L17/dossiers17170600000357511706000003575119PA7195122025-05-20False
17060000035772L17/dossiers17170600000357511706000003575120PA29602025-05-20False
17060000035773L17/dossiers17170600000357511706000003575121PA7211582025-05-20False
17060000035774L17/dossiers17170600000357511706000003575122PA7221902025-05-20False
17060000035775L17/dossiers17170600000357511706000003575123PA6429352025-05-20False
17060000035776L17/dossiers17170600000357511706000003575124PA6426952025-05-20False
17060000035777L17/dossiers17170600000357511706000003575125PA7219082025-05-152025-05-20False
17060000035778L17/dossiers17170600000357511706000003575126PA7959902025-05-20False
17060000035779L17/dossiers17170600000357511706000003575127PA7943302025-05-20False
17060000035780L17/dossiers17170600000357511706000003575128PA7198902025-05-20False
17060000035781L17/dossiers17170600000357511706000003575129PA7220002025-05-20False
17060000035782L17/dossiers17170600000357511706000003575130PA7947982025-05-20False
17060000035783L17/dossiers17170600000357511706000003575131PA7217502025-05-20False
17060000035784L17/dossiers17170600000357511706000003575132PA7953302025-05-20False
17060000035785L17/dossiers17170600000357511706000003575133PA8423112025-05-20False
17060000035786L17/dossiers17170600000357511706000003575134PA7939402025-05-20False
17060000035787L17/dossiers17170600000357511706000003575135PA7958642025-05-20False
17060000035788L17/dossiers17170600000357511706000003575136PA7959082025-05-20False
17060000035789L17/dossiers17170600000357511706000003575137PA7191182025-05-20False
17060000035790L17/dossiers17170600000357511706000003575138PA7223822025-05-20False
17060000035791L17/dossiers17170600000357511706000003575139PA7201542025-05-20False
17060000035792L17/dossiers17170600000357511706000003575140PA7946582025-05-20False
17060000035793L17/dossiers17170600000357511706000003575141PA7221342025-05-20False
17060000035794L17/dossiers17170600000357511706000003575142PA7197362025-05-20False
17060000035795L17/dossiers17170600000357511706000003575143PA7223582025-05-20False
17060000035796L17/dossiers17170600000357511706000003575144PA7210242025-05-20False
17060000035797L17/dossiers17170600000357511706000003575145PA7212962025-05-20False
17060000035798L17/dossiers17170600000357511706000003575146PA7217642025-05-20False
17060000035799L17/dossiers17170600000357511706000003575147PA8417092025-05-20False
17060000035800L17/dossiers17170600000357511706000003575148PA2672002025-05-20False
17060000035801L17/dossiers17170600000357511706000003575149PA7203542025-05-20False
17060000035802L17/dossiers17170600000357511706000003575150PA7193722025-05-20False
17060000035803L17/dossiers17170600000357511706000003575151PA6431842025-05-20False
17060000035804L17/dossiers17170600000357511706000003575152PA7197982025-05-20False
17060000035805L17/dossiers17170600000357511706000003575153PA7210042025-05-20False
17060000035806L17/dossiers17170600000357511706000003575154PA7194122025-05-20False
17060000035807L17/dossiers17170600000357511706000003575155PA7194042025-05-20False