Aller au contenu
blackout

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
17060000056612L17/dossiers1717060000056610170600000566101PA7188842026-02-05False
17060000056613L17/dossiers1717060000056610170600000566102PA2667972026-02-05False
17060000056614L17/dossiers1717060000056610170600000566103PA7933422026-02-05False
17060000056615L17/dossiers1717060000056610170600000566104PA7203862026-02-05False
17060000056616L17/dossiers1717060000056610170600000566105PA8700092026-02-05False
17060000056617L17/dossiers1717060000056610170600000566106PA7188382026-02-05False
17060000056618L17/dossiers1717060000056610170600000566107PA7199682026-02-05False
17060000056619L17/dossiers1717060000056610170600000566108PA7206442026-02-05False
17060000056620L17/dossiers1717060000056610170600000566109PA4085782026-02-05False
17060000056621L17/dossiers17170600000566101706000005661010PA8421212026-02-05False
17060000056622L17/dossiers17170600000566101706000005661011PA6080162026-02-05False
17060000056623L17/dossiers17170600000566101706000005661012PA7940582026-02-05False
17060000056624L17/dossiers17170600000566101706000005661013PA7223902026-02-05False
17060000056625L17/dossiers17170600000566101706000005661014PA7218162026-02-05False
17060000056626L17/dossiers17170600000566101706000005661015PA7935082026-02-05False
17060000056627L17/dossiers17170600000566101706000005661016PA3325232026-02-05False
17060000056628L17/dossiers17170600000566101706000005661017PA6428472026-02-05False
17060000056629L17/dossiers17170600000566101706000005661018PA7187842026-02-05False
17060000056630L17/dossiers17170600000566101706000005661019PA16302026-02-05False
17060000056631L17/dossiers17170600000566101706000005661020PA8421412026-02-05False
17060000056632L17/dossiers17170600000566101706000005661021PA6088262026-02-05False
17060000056633L17/dossiers17170600000566101706000005661022PA6084162026-02-05False
17060000056634L17/dossiers17170600000566101706000005661023PA3300082026-02-05False
17060000056635L17/dossiers17170600000566101706000005661024PA3309092026-02-05False
17060000056639L17/dossiers1717060000056637170600000566371PA7208922026-01-13False
17060000056640L17/dossiers1717060000056637170600000566372PA7952282026-01-13False
17060000056641L17/dossiers1717060000056637170600000566373PA7932622026-01-13False
17060000056642L17/dossiers1717060000056637170600000566374PA7949062026-01-13False
17060000056643L17/dossiers1717060000056637170600000566375PA7941382026-01-13False
17060000056644L17/dossiers1717060000056637170600000566376PA7955882026-01-13False
17060000056645L17/dossiers1717060000056637170600000566377PA7950842026-01-13False
17060000056646L17/dossiers1717060000056637170600000566378PA8421052026-01-13False
17060000056647L17/dossiers1717060000056637170600000566379PA7204302026-01-13False
17060000056648L17/dossiers17170600000566371706000005663710PA7937722026-01-13False
17060000056649L17/dossiers17170600000566371706000005663711PA7956162026-01-13False
17060000056650L17/dossiers17170600000566371706000005663712PA7934442026-01-13False
17060000056651L17/dossiers17170600000566371706000005663713PA7949382026-01-13False
17060000056652L17/dossiers17170600000566371706000005663714PA7953182026-01-13False
17060000056653L17/dossiers17170600000566371706000005663715PA8410232026-01-13False
17060000056654L17/dossiers17170600000566371706000005663716PA7960902026-01-13False
17060000056655L17/dossiers17170600000566371706000005663717PA7939122026-01-13False
17060000056656L17/dossiers17170600000566371706000005663718PA8421872026-01-13False
17060000056657L17/dossiers17170600000566371706000005663719PA8420372026-01-13False
17060000056658L17/dossiers17170600000566371706000005663720PA7918122026-01-13False
17060000056659L17/dossiers17170600000566371706000005663721PA7937362026-01-13False
17060000056660L17/dossiers17170600000566371706000005663722PA7212022026-01-13False
17060000056661L17/dossiers17170600000566371706000005663723PA7951362026-01-13False
17060000056662L17/dossiers17170600000566371706000005663724PA7934642026-01-13False
17060000056663L17/dossiers17170600000566371706000005663725PA8421552026-01-13False
17060000056664L17/dossiers17170600000566371706000005663726PA7952002026-01-13False