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
17060000031867L17/dossiers17170600000317681706000003176898PA8421952025-06-23False
17060000031868L17/dossiers17170600000317681706000003176899PA6093322025-06-23False
17060000031869L17/dossiers171706000003176817060000031768100PA8416652025-06-23False
17060000031870L17/dossiers171706000003176817060000031768101PA3332852025-06-23False
17060000031871L17/dossiers171706000003176817060000031768102PA8409392025-06-23False
17060000031872L17/dossiers171706000003176817060000031768103PA8415392025-06-23False
17060000031873L17/dossiers171706000003176817060000031768104PA3319732025-06-23False
17060000031874L17/dossiers171706000003176817060000031768105PA8401712025-06-23False
17060000031875L17/dossiers171706000003176817060000031768106PA15672025-06-23False
17060000031876L17/dossiers171706000003176817060000031768107PA8414712025-06-23False
17060000031877L17/dossiers171706000003176817060000031768108PA8422632025-06-23False
17060000031878L17/dossiers171706000003176817060000031768109PA8418132025-06-23False
17060000031879L17/dossiers171706000003176817060000031768110PA8418532025-06-23False
17060000031880L17/dossiers171706000003176817060000031768111PA16542025-06-23False
17060000031881L17/dossiers171706000003176817060000031768112PA6431922025-06-23False
17060000031882L17/dossiers171706000003176817060000031768113PA3350542025-06-23False
17060000031883L17/dossiers171706000003176817060000031768114PA7951562025-06-23False
17060000031884L17/dossiers171706000003176817060000031768115PA7749582025-06-23False
17060000031885L17/dossiers171706000003176817060000031768116PA8407652025-06-23False
17060000031886L17/dossiers171706000003176817060000031768117PA8414632025-06-23False
17060000031887L17/dossiers171706000003176817060000031768118PA6431572025-06-23False
17060000031888L17/dossiers171706000003176817060000031768119PA8411072025-06-23False
17060000031889L17/dossiers171706000003176817060000031768120PA8413812025-06-23False
17060000031890L17/dossiers171706000003176817060000031768121PA8407932025-06-23False
17060000031891L17/dossiers171706000003176817060000031768122PA7942702025-06-23False
17060000031892L17/dossiers171706000003176817060000031768123PA6081722025-06-23False
17060000031893L17/dossiers171706000003176817060000031768124PA6075532025-06-23False
17060000031894L17/dossiers171706000003176817060000031768125PA8409552025-06-23False
17060000031895L17/dossiers171706000003176817060000031768126PA8413672025-06-23False
17060000031896L17/dossiers171706000003176817060000031768127PA3419812025-06-23False
17060000031897L17/dossiers171706000003176817060000031768128PA8406732025-06-23False
17060000031898L17/dossiers171706000003176817060000031768129PA3421962025-06-23False
17060000031899L17/dossiers171706000003176817060000031768130PA8266352025-06-23False
17060000031900L17/dossiers171706000003176817060000031768131PA8413272025-06-23False
17060000031901L17/dossiers171706000003176817060000031768132PA8417172025-06-23False
17060000031902L17/dossiers171706000003176817060000031768133PA8412432025-06-23False
17060000031903L17/dossiers171706000003176817060000031768134PA7749602025-06-23False
17060000031904L17/dossiers171706000003176817060000031768135PA3403432025-06-23False
17060000031905L17/dossiers171706000003176817060000031768136PA8410912025-06-23False
17060000031906L17/dossiers171706000003176817060000031768137PA8416812025-06-23False
17060000031907L17/dossiers171706000003176817060000031768138PA8418932025-06-23False
17060000031908L17/dossiers171706000003176817060000031768139PA7938162025-06-23False
17060000031909L17/dossiers171706000003176817060000031768140PA7199302025-06-23False
17060000031910L17/dossiers171706000003176817060000031768141PA7944942025-06-23False
17060000031911L17/dossiers171706000003176817060000031768142PA7209922025-06-23False
17060000031921L17/dossiers1717060000031919170600000319191PA9422025-04-24False
17060000031922L17/dossiers1717060000031919170600000319192PA8413592025-04-24False
17060000031923L17/dossiers1717060000031919170600000319193PA8226172025-04-24False
17060000031924L17/dossiers1717060000031919170600000319194PA6076192025-04-24False
17060000031925L17/dossiers1717060000031919170600000319195PA7209602025-04-24False