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
16060000016935L16/dossiers16160600000169041606000001690430PA7217502023-01-17False
16060000016936L16/dossiers16160600000169041606000001690431PA7953302023-01-17False
16060000016937L16/dossiers16160600000169041606000001690432PA7199222023-01-17False
16060000016938L16/dossiers16160600000169041606000001690433PA7939402023-01-17False
16060000016939L16/dossiers16160600000169041606000001690434PA7958642023-01-17False
16060000016940L16/dossiers16160600000169041606000001690435PA7194722023-01-17False
16060000016941L16/dossiers16160600000169041606000001690436PA7955082023-01-17False
16060000016942L16/dossiers16160600000169041606000001690437PA7950682023-01-17False
16060000016943L16/dossiers16160600000169041606000001690438PA7959082023-01-17False
16060000016944L16/dossiers16160600000169041606000001690439PA7192942023-01-17False
16060000016945L16/dossiers16160600000169041606000001690440PA7198142023-01-17False
16060000016946L16/dossiers16160600000169041606000001690441PA7191182023-01-17False
16060000016947L16/dossiers16160600000169041606000001690442PA7938762023-01-17False
16060000016948L16/dossiers16160600000169041606000001690443PA7209322023-01-17False
16060000016949L16/dossiers16160600000169041606000001690444PA7945102023-01-17False
16060000016950L16/dossiers16160600000169041606000001690445PA7949822023-01-17False
16060000016951L16/dossiers16160600000169041606000001690446PA7208622023-01-17False
16060000016952L16/dossiers16160600000169041606000001690447PA7223822023-01-17False
16060000016953L16/dossiers16160600000169041606000001690448PA7201542023-01-17False
16060000016954L16/dossiers16160600000169041606000001690449PA7210942023-01-17False
16060000016955L16/dossiers16160600000169041606000001690450PA6431752023-01-17False
16060000016956L16/dossiers16160600000169041606000001690451PA7946582023-01-17False
16060000016957L16/dossiers16160600000169041606000001690452PA7958842023-01-17False
16060000016958L16/dossiers16160600000169041606000001690453PA7221342023-01-17False
16060000016959L16/dossiers16160600000169041606000001690454PA7223662023-01-17False
16060000016960L16/dossiers16160600000169041606000001690455PA7223582023-01-17False
16060000016961L16/dossiers16160600000169041606000001690456PA7210242023-01-17False
16060000016962L16/dossiers16160600000169041606000001690457PA7191082023-01-17False
16060000016963L16/dossiers16160600000169041606000001690458PA7217222023-01-17False
16060000016964L16/dossiers16160600000169041606000001690459PA7202222023-01-17False
16060000016965L16/dossiers16160600000169041606000001690460PA2673362023-01-17False
16060000016966L16/dossiers16160600000169041606000001690461PA7186742023-01-17False
16060000016967L16/dossiers16160600000169041606000001690462PA7948462023-01-17False
16060000016968L16/dossiers16160600000169041606000001690463PA7212962023-01-17False
16060000016969L16/dossiers16160600000169041606000001690464PA2673182023-01-17False
16060000016970L16/dossiers16160600000169041606000001690465PA7218802023-01-17False
16060000016971L16/dossiers16160600000169041606000001690466PA7959342023-01-17False
16060000016972L16/dossiers16160600000169041606000001690467PA7201742023-01-17False
16060000016973L16/dossiers16160600000169041606000001690468PA7959582023-01-17False
16060000016974L16/dossiers16160600000169041606000001690469PA7220542023-01-17False
16060000016975L16/dossiers16160600000169041606000001690470PA7200542023-01-17False
16060000016976L16/dossiers16160600000169041606000001690471PA7220702023-01-17False
16060000016977L16/dossiers16160600000169041606000001690472PA7931902023-01-17False
16060000016978L16/dossiers16160600000169041606000001690473PA7211502023-01-17False
16060000016979L16/dossiers16160600000169041606000001690474PA7940042023-01-17False
16060000016980L16/dossiers16160600000169041606000001690475PA3318352023-01-17False
16060000016981L16/dossiers16160600000169041606000001690476PA7956522023-01-17False
16060000016982L16/dossiers16160600000169041606000001690477PA7203542023-01-17False
16060000016983L16/dossiers16160600000169041606000001690478PA7200742023-01-17False
16060000016984L16/dossiers16160600000169041606000001690479PA7193722023-01-17False