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
17060000037909L17/dossiers17170600000378741706000003787434PA6070902025-06-10False
17060000037910L17/dossiers17170600000378741706000003787435PA7188842025-06-10False
17060000037911L17/dossiers17170600000378741706000003787436PA3309092025-06-10False
17060000037912L17/dossiers17170600000378741706000003787437PA7120152025-06-10False
17060000037913L17/dossiers17170600000378741706000003787438PA6088262025-06-10False
17060000037914L17/dossiers17170600000378741706000003787439PA13272025-06-10False
17060000037915L17/dossiers17170600000378741706000003787440PA2667972025-06-10False
17060000037916L17/dossiers17170600000378741706000003787441PA7940582025-06-10False
17060000037917L17/dossiers17170600000378741706000003787442PA6955122025-06-10False
17060000037918L17/dossiers17170600000378741706000003787443PA8421412025-06-10False
17060000037919L17/dossiers17170600000378741706000003787444PA7192722025-06-10False
17060000037920L17/dossiers17170600000378741706000003787445PA7206442025-06-10False
17060000037921L17/dossiers17170600000378741706000003787446PA7187842025-06-10False
17060000037922L17/dossiers17170600000378741706000003787447PA7946582025-06-10False
17060000037923L17/dossiers17170600000378741706000003787448PA2677802025-06-10False
17060000037924L17/dossiers17170600000378741706000003787449PA8407212025-06-10False
17060000037925L17/dossiers17170600000378741706000003787450PA7955282025-06-10False
17060000037932L17/dossiers1717060000037930170600000379301PA7945622025-06-06False
17060000037933L17/dossiers1717060000037930170600000379302PA7931342025-06-06False
17060000037934L17/dossiers1717060000037930170600000379303PA8407012025-06-06False
17060000037935L17/dossiers1717060000037930170600000379304PA8407212025-06-06False
17060000037936L17/dossiers1717060000037930170600000379305PA7939282025-06-06False
17060000037937L17/dossiers1717060000037930170600000379306PA7947702025-06-06False
17060000037938L17/dossiers1717060000037930170600000379307PA8408092025-06-06False
17060000037939L17/dossiers1717060000037930170600000379308PA7940302025-06-06False
17060000037940L17/dossiers1717060000037930170600000379309PA7194362025-06-06False
17060000037941L17/dossiers17170600000379301706000003793010PA8419552025-06-06False
17060000037942L17/dossiers17170600000379301706000003793011PA8420852025-06-06False
17060000037943L17/dossiers17170600000379301706000003793012PA7936962025-06-06False
17060000037944L17/dossiers17170600000379301706000003793013PA8417692025-06-06False
17060000037945L17/dossiers17170600000379301706000003793014PA8407572025-06-06False
17060000037946L17/dossiers17170600000379301706000003793015PA2675612025-06-06False
17060000037947L17/dossiers17170600000379301706000003793016PA8400752025-06-06False
17060000037948L17/dossiers17170600000379301706000003793017PA8422552025-06-06False
17060000037949L17/dossiers17170600000379301706000003793018PA8409152025-06-06False
17060000037950L17/dossiers17170600000379301706000003793019PA7933742025-06-06False
17060000037951L17/dossiers17170600000379301706000003793020PA8419812025-06-06False
17060000037958L17/dossiers1717060000037956170600000379561PA8409972025-06-13False
17060000037959L17/dossiers1717060000037956170600000379562PA8412952025-06-13False
17060000037960L17/dossiers1717060000037956170600000379563PA7940822025-06-13False
17060000037961L17/dossiers1717060000037956170600000379564PA6431922025-06-13False
17060000037962L17/dossiers1717060000037956170600000379565PA7954822025-06-13False
17060000037969L17/dossiers1717060000037967170600000379671PA7958082025-06-25False
17060000037970L17/dossiers1717060000037967170600000379672PA7936642025-06-25False
17060000037971L17/dossiers1717060000037967170600000379673PA6100022025-06-25False
17060000037972L17/dossiers1717060000037967170600000379674PA6082642025-06-25False
17060000037973L17/dossiers1717060000037967170600000379675PA7952402025-06-25False
17060000037974L17/dossiers1717060000037967170600000379676PA7960102025-06-25False
17060000037975L17/dossiers1717060000037967170600000379677PA7940942025-06-25False
17060000037976L17/dossiers1717060000037967170600000379678PA8418932025-06-25False