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
17060000005249L17/dossiers17170600000051561706000000515692PA7190062023-07-04False
17060000005250L17/dossiers17170600000051561706000000515693PA7218522023-07-04False
17060000005251L17/dossiers17170600000051561706000000515694PA7120142023-07-04False
17060000005252L17/dossiers17170600000051561706000000515695PA7953862023-07-04False
17060000005253L17/dossiers17170600000051561706000000515696PA7216322023-07-04False
17060000005254L17/dossiers17170600000051561706000000515697PA7204462023-07-04False
17060000005255L17/dossiers17170600000051561706000000515698PA7952162023-07-04False
17060000005256L17/dossiers17170600000051561706000000515699PA7197182023-07-04False
17060000005257L17/dossiers171706000000515617060000005156100PA3341162023-07-04False
17060000005258L17/dossiers171706000000515617060000005156101PA7957302023-07-04False
17060000005259L17/dossiers171706000000515617060000005156102PA7949742023-07-04False
17060000005260L17/dossiers171706000000515617060000005156103PA7942062023-07-04False
17060000005261L17/dossiers171706000000515617060000005156104PA7190802023-07-04False
17060000005262L17/dossiers171706000000515617060000005156105PA7191542023-07-04False
17060000005263L17/dossiers171706000000515617060000005156106PA7201462023-07-04False
17060000005264L17/dossiers171706000000515617060000005156107PA6774832023-07-04False
17060000005265L17/dossiers171706000000515617060000005156108PA7193382023-07-04False
17060000005266L17/dossiers171706000000515617060000005156109PA7203702023-07-04False
17060000005267L17/dossiers171706000000515617060000005156110PA7943862023-07-04False
17060000005268L17/dossiers171706000000515617060000005156111PA7951762023-07-04False
17060000005269L17/dossiers171706000000515617060000005156112PA7198822023-07-04False
17060000005270L17/dossiers171706000000515617060000005156113PA7956642023-07-04False
17060000005271L17/dossiers171706000000515617060000005156114PA8172032023-07-04False
17060000005272L17/dossiers171706000000515617060000005156115PA7948782023-07-04False
17060000005273L17/dossiers171706000000515617060000005156116PA7957222023-07-04False
17060000005274L17/dossiers171706000000515617060000005156117PA7935882023-07-04False
17060000005275L17/dossiers171706000000515617060000005156118PA7196322023-07-04False
17060000005276L17/dossiers171706000000515617060000005156119PA7950502023-07-04False
17060000005277L17/dossiers171706000000515617060000005156120PA7192022023-07-04False
17060000005278L17/dossiers171706000000515617060000005156121PA7204802023-07-04False
17060000005279L17/dossiers171706000000515617060000005156122PA7959262023-07-04False
17060000005280L17/dossiers171706000000515617060000005156123PA7204142023-07-04False
17060000005281L17/dossiers171706000000515617060000005156124PA7189302023-07-04False
17060000005282L17/dossiers171706000000515617060000005156125PA7217102023-07-04False
17060000005283L17/dossiers171706000000515617060000005156126PA7218442023-07-04False
17060000005284L17/dossiers171706000000515617060000005156127PA24492023-07-04False
17060000005285L17/dossiers171706000000515617060000005156128PA7196002023-07-04False
17060000005286L17/dossiers171706000000515617060000005156129PA7219162023-07-04False
17060000005287L17/dossiers171706000000515617060000005156130PA7223982023-07-04False
17060000005288L17/dossiers171706000000515617060000005156131PA7216782023-07-04False
17060000005289L17/dossiers171706000000515617060000005156132PA7209002023-07-04False
17060000005290L17/dossiers171706000000515617060000005156133PA7214262023-07-04False
17060000005291L17/dossiers171706000000515617060000005156134PA7200662023-07-04False
17060000005292L17/dossiers171706000000515617060000005156135PA7222522023-07-04False
17060000005293L17/dossiers171706000000515617060000005156136PA7955282023-07-04False
17060000005294L17/dossiers171706000000515617060000005156137PA7214582023-07-04False
17060000005295L17/dossiers171706000000515617060000005156138PA7932702023-07-04False
17060000005296L17/dossiers171706000000515617060000005156139PA3406432023-07-04False
17060000005297L17/dossiers171706000000515617060000005156140PA7222922023-07-04False
17060000005298L17/dossiers171706000000515617060000005156141PA7201382023-07-04False