Aller au contenu
blackout

dossiers.document_co_signataire

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

309 130 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
17060000077765L17/dossiers1717060000077763170600000777631PA21612015-12-17True
17060000077766L17/dossiers1717060000077763170600000777632PA25382015-12-17True
17060000077767L17/dossiers1717060000077763170600000777633PA2270992015-12-17True
17060000077768L17/dossiers1717060000077763170600000777634PA7035402015-12-17False
17060000077769L17/dossiers1717060000077763170600000777635PA2271082015-12-17False
17060000077770L17/dossiers1717060000077763170600000777636PA7035322015-12-17False
17060000077771L17/dossiers1717060000077763170600000777637PA5282015-12-17False
17060000077772L17/dossiers1717060000077763170600000777638PA5502015-12-17False
17060000077773L17/dossiers1717060000077763170600000777639PA5692015-12-17False
17060000077774L17/dossiers17170600000777631706000007776310PA7035222015-12-17False
17060000077775L17/dossiers17170600000777631706000007776311PA7035002015-12-17False
17060000077776L17/dossiers17170600000777631706000007776312PA3039972015-12-17False
17060000077777L17/dossiers17170600000777631706000007776313PA7035252015-12-17False
17060000077778L17/dossiers17170600000777631706000007776314PA7162015-12-17False
17060000077779L17/dossiers17170600000777631706000007776315PA3040852015-12-17False
17060000077780L17/dossiers17170600000777631706000007776316PA7035102015-12-17False
17060000077781L17/dossiers17170600000777631706000007776317PA7035142015-12-17False
17060000077782L17/dossiers17170600000777631706000007776318PA7252015-12-17False
17060000077783L17/dossiers17170600000777631706000007776319PA4298842015-12-17False
17060000077784L17/dossiers17170600000777631706000007776320PA4298702015-12-17False
17060000077785L17/dossiers17170600000777631706000007776321PA7372015-12-17False
17060000077786L17/dossiers17170600000777631706000007776322PA4298622015-12-17False
17060000077787L17/dossiers17170600000777631706000007776323PA7097502015-12-17False
17060000077788L17/dossiers17170600000777631706000007776324PA7035132015-12-17False
17060000077789L17/dossiers17170600000777631706000007776325PA4298542015-12-17False
17060000077790L17/dossiers17170600000777631706000007776326PA4154622015-12-17False
17060000077791L17/dossiers17170600000777631706000007776327PA7061082015-12-17False
17060000077792L17/dossiers17170600000777631706000007776328PA3421542015-12-17False
17060000077793L17/dossiers17170600000777631706000007776329PA9802015-12-17False
17060000077794L17/dossiers17170600000777631706000007776330PA3040792015-12-17False
17060000077795L17/dossiers17170600000777631706000007776331PA10192015-12-17False
17060000077796L17/dossiers17170600000777631706000007776332PA4298692015-12-17False
17060000077797L17/dossiers17170600000777631706000007776333PA10462015-12-17False
17060000077798L17/dossiers17170600000777631706000007776334PA7092982015-12-17False
17060000077799L17/dossiers17170600000777631706000007776335PA10902015-12-17False
17060000077800L17/dossiers17170600000777631706000007776336PA4253222015-12-17False
17060000077801L17/dossiers17170600000777631706000007776337PA7035392015-12-17False
17060000077802L17/dossiers17170600000777631706000007776338PA2674192015-12-17False
17060000077803L17/dossiers17170600000777631706000007776339PA2671122015-12-17False
17060000077808L17/dossiers1717060000077806170600000778061PA7035222016-05-10False
17060000077809L17/dossiers1717060000077806170600000778062PA3047372016-05-10False
17060000077810L17/dossiers1717060000077806170600000778063PA4298632016-05-10False
17060000077813L17/dossiers1717060000077811170600000778111PA2673402016-05-25True
17060000077814L17/dossiers1717060000077811170600000778112PA7035322016-05-25False
17060000077815L17/dossiers1717060000077811170600000778113PA4154462016-05-25False
17060000077816L17/dossiers1717060000077811170600000778114PA2270992016-05-25False
17060000077817L17/dossiers1717060000077811170600000778115PA5502016-05-25False
17060000077818L17/dossiers1717060000077811170600000778116PA5692016-05-25False
17060000077819L17/dossiers1717060000077811170600000778117PA7061082016-05-25False
17060000077820L17/dossiers1717060000077811170600000778118PA7092982016-05-25False