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
17060000031982L17/dossiers17170600000319371706000003193744PA7951082025-04-04False
17060000031983L17/dossiers17170600000319371706000003193745PA8415152025-04-04False
17060000031984L17/dossiers17170600000319371706000003193746PA7952982025-04-04False
17060000031985L17/dossiers17170600000319371706000003193747PA7918242025-04-04False
17060000031986L17/dossiers17170600000319371706000003193748PA8420292025-04-04False
17060000031987L17/dossiers17170600000319371706000003193749PA7935322025-04-04False
17060000031988L17/dossiers17170600000319371706000003193750PA3423842025-04-04False
17060000031989L17/dossiers17170600000319371706000003193751PA7954222025-04-04False
17060000031990L17/dossiers17170600000319371706000003193752PA7946862025-04-04False
17060000031991L17/dossiers17170600000319371706000003193753PA8412152025-04-04False
17060000031992L17/dossiers17170600000319371706000003193754PA7954822025-04-04False
17060000031993L17/dossiers17170600000319371706000003193755PA6106542025-04-04False
17060000031994L17/dossiers17170600000319371706000003193756PA7219602025-04-04False
17060000031995L17/dossiers17170600000319371706000003193757PA7938722025-04-04False
17060000031996L17/dossiers17170600000319371706000003193758PA8172112025-04-04False
17060000031997L17/dossiers17170600000319371706000003193759PA7960622025-04-04False
17060000031998L17/dossiers17170600000319371706000003193760PA7195782025-04-04False
17060000031999L17/dossiers17170600000319371706000003193761PA7210622025-04-04False
17060000032000L17/dossiers17170600000319371706000003193762PA8418452025-04-04False
17060000032001L17/dossiers17170600000319371706000003193763PA7959822025-04-04False
17060000032002L17/dossiers17170600000319371706000003193764PA7954662025-04-04False
17060000032003L17/dossiers17170600000319371706000003193765PA7937442025-04-04False
17060000032004L17/dossiers17170600000319371706000003193766PA7209522025-04-04False
17060000032005L17/dossiers17170600000319371706000003193767PA7941062025-04-04False
17060000032006L17/dossiers17170600000319371706000003193768PA7941662025-04-04False
17060000032007L17/dossiers17170600000319371706000003193769PA7951642025-04-04False
17060000032008L17/dossiers17170600000319371706000003193770PA7955962025-04-04False
17060000032009L17/dossiers17170600000319371706000003193771PA3424152025-04-04False
17060000032010L17/dossiers17170600000319371706000003193772PA7940082025-04-04False
17060000032011L17/dossiers17170600000319371706000003193773PA8414192025-04-04False
17060000032012L17/dossiers17170600000319371706000003193774PA7749622025-04-04False
17060000032013L17/dossiers17170600000319371706000003193775PA7960102025-04-04False
17060000032014L17/dossiers17170600000319371706000003193776PA7958762025-04-04False
17060000032015L17/dossiers17170600000319371706000003193777PA7221422025-04-04False
17060000032019L17/dossiers1717060000032017170600000320171PA7208922025-03-28False
17060000032020L17/dossiers1717060000032017170600000320172PA7952282025-03-28False
17060000032021L17/dossiers1717060000032017170600000320173PA7932622025-03-28False
17060000032022L17/dossiers1717060000032017170600000320174PA7949062025-03-28False
17060000032023L17/dossiers1717060000032017170600000320175PA7941382025-03-28False
17060000032024L17/dossiers1717060000032017170600000320176PA7955882025-03-28False
17060000032025L17/dossiers1717060000032017170600000320177PA7950842025-03-28False
17060000032026L17/dossiers1717060000032017170600000320178PA8421052025-03-28False
17060000032027L17/dossiers1717060000032017170600000320179PA8416572025-03-28False
17060000032028L17/dossiers17170600000320171706000003201710PA7204302025-03-28False
17060000032029L17/dossiers17170600000320171706000003201711PA7937722025-03-28False
17060000032030L17/dossiers17170600000320171706000003201712PA7956162025-03-28False
17060000032031L17/dossiers17170600000320171706000003201713PA7934442025-03-28False
17060000032032L17/dossiers17170600000320171706000003201714PA7949382025-03-28False
17060000032033L17/dossiers17170600000320171706000003201715PA7953182025-03-28False
17060000032034L17/dossiers17170600000320171706000003201716PA8410232025-03-28False