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 151 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
17060000010323L17/dossiers1717060000010314170600000103148PA6084162025-02-17False
17060000010324L17/dossiers1717060000010314170600000103149PA3467822025-02-17False
17060000010325L17/dossiers17170600000103141706000001031410PA6955122025-02-17False
17060000010326L17/dossiers17170600000103141706000001031411PA6080162025-02-17False
17060000010327L17/dossiers17170600000103141706000001031412PA6060982025-02-17False
17060000010328L17/dossiers17170600000103141706000001031413PA7940382025-02-17False
17060000010329L17/dossiers17170600000103141706000001031414PA7187842025-02-17False
17060000010330L17/dossiers17170600000103141706000001031415PA7214422025-02-17False
17060000010331L17/dossiers17170600000103141706000001031416PA7930942025-02-17False
17060000010332L17/dossiers17170600000103141706000001031417PA6070902025-02-17False
17060000010333L17/dossiers17170600000103141706000001031418PA7218162025-02-17False
17060000010334L17/dossiers17170600000103141706000001031419PA7188842025-02-17False
17060000010335L17/dossiers17170600000103141706000001031420PA16302025-02-17False
17060000010339L17/dossiers1717060000010337170600000103371PA7961062024-10-15False
17060000010340L17/dossiers1717060000010337170600000103372PA7208382024-10-15False
17060000010341L17/dossiers1717060000010337170600000103373PA7958682024-10-15False
17060000010342L17/dossiers1717060000010337170600000103374PA2673062024-10-15False
17060000010343L17/dossiers1717060000010337170600000103375PA7218962024-10-15False
17060000010344L17/dossiers1717060000010337170600000103376PA7959982024-10-15False
17060000010345L17/dossiers1717060000010337170600000103377PA7749622024-10-15False
17060000010346L17/dossiers1717060000010337170600000103378PA3356122024-10-15False
17060000010347L17/dossiers1717060000010337170600000103379PA7960102024-10-15False
17060000010348L17/dossiers17170600000103371706000001033710PA8422712024-10-15False
17060000010349L17/dossiers17170600000103371706000001033711PA7931742024-10-15False
17060000010350L17/dossiers17170600000103371706000001033712PA7212702024-10-15False
17060000010351L17/dossiers17170600000103371706000001033713PA7952402024-10-15False
17060000010352L17/dossiers17170600000103371706000001033714PA7958762024-10-15False
17060000010353L17/dossiers17170600000103371706000001033715PA6057452024-10-15False
17060000010354L17/dossiers17170600000103371706000001033716PA8422992024-10-15False
17060000010358L17/dossiers1717060000010356170600000103561PA7930942024-10-15False
17060000010359L17/dossiers1717060000010356170600000103562PA7223902024-10-15False
17060000010360L17/dossiers1717060000010356170600000103563PA7203862024-10-15False
17060000010361L17/dossiers1717060000010356170600000103564PA7940582024-10-15False
17060000010362L17/dossiers1717060000010356170600000103565PA7187842024-10-15False
17060000010363L17/dossiers1717060000010356170600000103566PA16302024-10-15False
17060000010364L17/dossiers1717060000010356170600000103567PA6088262024-10-15False
17060000010365L17/dossiers1717060000010356170600000103568PA7940382024-10-15False
17060000010366L17/dossiers1717060000010356170600000103569PA6070902024-10-15False
17060000010367L17/dossiers17170600000103561706000001035610PA7214102024-10-15False
17060000010371L17/dossiers1717060000010369170600000103691PA3359992024-10-15False
17060000010372L17/dossiers1717060000010369170600000103692PA29402024-10-15False
17060000010373L17/dossiers1717060000010369170600000103693PA7940082024-10-15False
17060000010374L17/dossiers1717060000010369170600000103694PA7955162024-10-15False
17060000010375L17/dossiers1717060000010369170600000103695PA7937442024-10-15False
17060000010376L17/dossiers1717060000010369170600000103696PA9422024-10-15False
17060000010377L17/dossiers1717060000010369170600000103697PA6076192024-10-15False
17060000010378L17/dossiers1717060000010369170600000103698PA7940942024-10-15False
17060000010379L17/dossiers1717060000010369170600000103699PA7959982024-10-15False
17060000010380L17/dossiers17170600000103691706000001036910PA7961062024-10-15False
17060000010381L17/dossiers17170600000103691706000001036911PA6109682024-10-15False