Aller au contenu
blackout

dossiers.document_co_signataire

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

309 313 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
16060000001985L16/dossiers16160600000019401606000000194044PA6073692014-12-09False
16060000001986L16/dossiers16160600000019401606000000194045PA3942014-12-09False
16060000001987L16/dossiers16160600000019401606000000194046PA3424152014-12-09False
16060000001988L16/dossiers16160600000019401606000000194047PA6086862014-12-09False
16060000001989L16/dossiers16160600000019401606000000194048PA6081582014-12-09False
16060000001990L16/dossiers16160600000019401606000000194049PA6051432014-12-09False
16060000001991L16/dossiers16160600000019401606000000194050PA5082014-12-09False
16060000001992L16/dossiers16160600000019401606000000194051PA6083632014-12-09False
16060000001993L16/dossiers16160600000019401606000000194052PA5362014-12-09False
16060000001994L16/dossiers16160600000019401606000000194053PA6086412014-12-09False
16060000001995L16/dossiers16160600000019401606000000194054PA5432014-12-09False
16060000001996L16/dossiers16160600000019401606000000194055PA6065072014-12-09False
16060000001997L16/dossiers16160600000019401606000000194056PA3328432014-12-09False
16060000001998L16/dossiers16160600000019401606000000194057PA6058302014-12-09False
16060000001999L16/dossiers16160600000019401606000000194058PA6050692014-12-09False
16060000002000L16/dossiers16160600000019401606000000194059PA6802014-12-09False
16060000002001L16/dossiers16160600000019401606000000194060PA6427392014-12-09False
16060000002002L16/dossiers16160600000019401606000000194061PA6052612014-12-09False
16060000002003L16/dossiers16160600000019401606000000194062PA6095352014-12-09False
16060000002004L16/dossiers16160600000019401606000000194063PA6056432014-12-09False
16060000002005L16/dossiers16160600000019401606000000194064PA6080982014-12-09False
16060000002006L16/dossiers16160600000019401606000000194065PA2671882014-12-09False
16060000002007L16/dossiers16160600000019401606000000194066PA6082352014-12-09False
16060000002008L16/dossiers16160600000019401606000000194067PA3301182014-12-09False
16060000002009L16/dossiers16160600000019401606000000194068PA6066652014-12-09False
16060000002010L16/dossiers16160600000019401606000000194069PA6092222014-12-09False
16060000002011L16/dossiers16160600000019401606000000194070PA8722014-12-09False
16060000002012L16/dossiers16160600000019401606000000194071PA6430202014-12-09False
16060000002013L16/dossiers16160600000019401606000000194072PA6072562014-12-09False
16060000002014L16/dossiers16160600000019401606000000194073PA3319242014-12-09False
16060000002015L16/dossiers16160600000019401606000000194074PA2679232014-12-09False
16060000002016L16/dossiers16160600000019401606000000194075PA6057582014-12-09False
16060000002017L16/dossiers16160600000019401606000000194076PA6060402014-12-09False
16060000002018L16/dossiers16160600000019401606000000194077PA6065732014-12-09False
16060000002019L16/dossiers16160600000019401606000000194078PA6064122014-12-09False
16060000002020L16/dossiers16160600000019401606000000194079PA6087182014-12-09False
16060000002021L16/dossiers16160600000019401606000000194080PA11932014-12-09False
16060000002022L16/dossiers16160600000019401606000000194081PA11982014-12-09False
16060000002023L16/dossiers16160600000019401606000000194082PA12142014-12-09False
16060000002024L16/dossiers16160600000019401606000000194083PA3312822014-12-09False
16060000002025L16/dossiers16160600000019401606000000194084PA6053492014-12-09False
16060000002026L16/dossiers16160600000019401606000000194085PA3320152014-12-09False
16060000002027L16/dossiers16160600000019401606000000194086PA6061712014-12-09False
16060000002028L16/dossiers16160600000019401606000000194087PA3336112014-12-09False
16060000002029L16/dossiers16160600000019401606000000194088PA6097752014-12-09False
16060000002030L16/dossiers16160600000019401606000000194089PA6096912014-12-09False
16060000002031L16/dossiers16160600000019401606000000194090PA13532014-12-09False
16060000002032L16/dossiers16160600000019401606000000194091PA23742014-12-09False
16060000002033L16/dossiers16160600000019401606000000194092PA6085742014-12-09False
16060000002034L16/dossiers16160600000019401606000000194093PA3369712014-12-09False