Aller au contenu
blackout

dossiers.document_co_signataire

Chemin document.coSignataires.coSignataire · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %

309 756 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 26 %, 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
16060000016985L16/dossiers16160600000169041606000001690480PA7191862023-01-17False
16060000016986L16/dossiers16160600000169041606000001690481PA6431842023-01-17False
16060000016987L16/dossiers16160600000169041606000001690482PA7197982023-01-17False
16060000016988L16/dossiers16160600000169041606000001690483PA7944502023-01-17False
16060000016989L16/dossiers16160600000169041606000001690484PA7210042023-01-17False
16060000016990L16/dossiers16160600000169041606000001690485PA7200222023-01-17False
16060000016991L16/dossiers16160600000169041606000001690486PA7196642023-01-17False
16060000016992L16/dossiers16160600000169041606000001690487PA7194122023-01-17False
16060000016993L16/dossiers16160600000169041606000001690488PA7194042023-01-17False
16060000016994L16/dossiers16160600000169041606000001690489PA7214662023-01-17False
16060000016995L16/dossiers16160600000169041606000001690490PA3457222023-01-17False
16060000016996L16/dossiers16160600000169041606000001690491PA7193882023-01-17False
16060000016997L16/dossiers16160600000169041606000001690492PA7197562023-01-17False
16060000016998L16/dossiers16160600000169041606000001690493PA7203422023-01-17False
16060000016999L16/dossiers16160600000169041606000001690494PA7190062023-01-17False
16060000017000L16/dossiers16160600000169041606000001690495PA7218522023-01-17False
16060000017001L16/dossiers16160600000169041606000001690496PA7120142023-01-17False
16060000017002L16/dossiers16160600000169041606000001690497PA7953862023-01-17False
16060000017003L16/dossiers16160600000169041606000001690498PA7216322023-01-17False
16060000017004L16/dossiers16160600000169041606000001690499PA7204462023-01-17False
16060000017005L16/dossiers161606000001690416060000016904100PA7952162023-01-17False
16060000017006L16/dossiers161606000001690416060000016904101PA7173792023-01-17False
16060000017007L16/dossiers161606000001690416060000016904102PA7197182023-01-17False
16060000017008L16/dossiers161606000001690416060000016904103PA3341162023-01-17False
16060000017009L16/dossiers161606000001690416060000016904104PA7957302023-01-17False
16060000017010L16/dossiers161606000001690416060000016904105PA7949742023-01-17False
16060000017011L16/dossiers161606000001690416060000016904106PA7942062023-01-17False
16060000017012L16/dossiers161606000001690416060000016904107PA7190802023-01-17False
16060000017013L16/dossiers161606000001690416060000016904108PA7191542023-01-17False
16060000017014L16/dossiers161606000001690416060000016904109PA7201462023-01-17False
16060000017015L16/dossiers161606000001690416060000016904110PA6774832023-01-17False
16060000017016L16/dossiers161606000001690416060000016904111PA7193382023-01-17False
16060000017017L16/dossiers161606000001690416060000016904112PA7203702023-01-17False
16060000017018L16/dossiers161606000001690416060000016904113PA7943862023-01-17False
16060000017019L16/dossiers161606000001690416060000016904114PA7951762023-01-17False
16060000017020L16/dossiers161606000001690416060000016904115PA7198822023-01-17False
16060000017021L16/dossiers161606000001690416060000016904116PA7956642023-01-17False
16060000017022L16/dossiers161606000001690416060000016904117PA7948782023-01-17False
16060000017023L16/dossiers161606000001690416060000016904118PA7957222023-01-17False
16060000017024L16/dossiers161606000001690416060000016904119PA7935882023-01-17False
16060000017025L16/dossiers161606000001690416060000016904120PA7196322023-01-17False
16060000017026L16/dossiers161606000001690416060000016904121PA7950502023-01-17False
16060000017027L16/dossiers161606000001690416060000016904122PA7192022023-01-17False
16060000017028L16/dossiers161606000001690416060000016904123PA7204802023-01-17False
16060000017029L16/dossiers161606000001690416060000016904124PA7959262023-01-17False
16060000017030L16/dossiers161606000001690416060000016904125PA7204142023-01-17False
16060000017031L16/dossiers161606000001690416060000016904126PA7189302023-01-17False
16060000017032L16/dossiers161606000001690416060000016904127PA7217102023-01-17False
16060000017033L16/dossiers161606000001690416060000016904128PA7218442023-01-17False
16060000017034L16/dossiers161606000001690416060000016904129PA7189102023-01-17False