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
17060000062564L17/dossiers1717060000062559170600000625594PA3467822026-05-30False
17060000062565L17/dossiers1717060000062559170600000625595PA8700092026-05-30False
17060000062566L17/dossiers1717060000062559170600000625596PA16302026-05-30False
17060000062567L17/dossiers1717060000062559170600000625597PA7187842026-05-30False
17060000062568L17/dossiers1717060000062559170600000625598PA6430892026-05-30False
17060000062569L17/dossiers1717060000062559170600000625599PA2667972026-05-30False
17060000062570L17/dossiers17170600000625591706000006255910PA6088262026-04-292026-04-29False
17060000062571L17/dossiers17170600000625591706000006255911PA8421412026-05-30False
17060000062575L17/dossiers1717060000062573170600000625731PA7223902026-05-30False
17060000062576L17/dossiers1717060000062573170600000625732PA7930942026-05-30False
17060000062577L17/dossiers1717060000062573170600000625733PA8700092026-05-30False
17060000062578L17/dossiers1717060000062573170600000625734PA16302026-05-30False
17060000062579L17/dossiers1717060000062573170600000625735PA7187842026-05-30False
17060000062580L17/dossiers1717060000062573170600000625736PA6430892026-05-30False
17060000062581L17/dossiers1717060000062573170600000625737PA6088262026-05-30False
17060000062582L17/dossiers1717060000062573170600000625738PA2667972026-05-30False
17060000062586L17/dossiers1717060000062584170600000625841PA7952282026-04-28False
17060000062587L17/dossiers1717060000062584170600000625842PA7932622026-04-28False
17060000062588L17/dossiers1717060000062584170600000625843PA7949062026-04-28False
17060000062589L17/dossiers1717060000062584170600000625844PA7941382026-04-28False
17060000062590L17/dossiers1717060000062584170600000625845PA7955882026-04-28False
17060000062591L17/dossiers1717060000062584170600000625846PA7950842026-04-28False
17060000062592L17/dossiers1717060000062584170600000625847PA8421052026-04-28False
17060000062593L17/dossiers1717060000062584170600000625848PA8416572026-04-28False
17060000062594L17/dossiers1717060000062584170600000625849PA8415312026-04-28False
17060000062595L17/dossiers17170600000625841706000006258410PA7937722026-04-28False
17060000062596L17/dossiers17170600000625841706000006258411PA7956162026-04-28False
17060000062597L17/dossiers17170600000625841706000006258412PA7934442026-04-28False
17060000062598L17/dossiers17170600000625841706000006258413PA7949382026-04-28False
17060000062599L17/dossiers17170600000625841706000006258414PA7953182026-04-28False
17060000062600L17/dossiers17170600000625841706000006258415PA8410232026-04-28False
17060000062601L17/dossiers17170600000625841706000006258416PA7960902026-04-28False
17060000062602L17/dossiers17170600000625841706000006258417PA7939122026-04-28False
17060000062603L17/dossiers17170600000625841706000006258418PA8421872026-04-28False
17060000062604L17/dossiers17170600000625841706000006258419PA8420372026-04-28False
17060000062605L17/dossiers17170600000625841706000006258420PA7918122026-04-28False
17060000062606L17/dossiers17170600000625841706000006258421PA7212022026-04-28False
17060000062607L17/dossiers17170600000625841706000006258422PA7951362026-04-28False
17060000062608L17/dossiers17170600000625841706000006258423PA7934642026-04-28False
17060000062609L17/dossiers17170600000625841706000006258424PA8421552026-04-28False
17060000062610L17/dossiers17170600000625841706000006258425PA7952002026-04-28False
17060000062611L17/dossiers17170600000625841706000006258426PA7958442026-04-28False
17060000062612L17/dossiers17170600000625841706000006258427PA8412512026-04-28False
17060000062613L17/dossiers17170600000625841706000006258428PA7947862026-04-28False
17060000062614L17/dossiers17170600000625841706000006258429PA7948702026-04-28False
17060000062615L17/dossiers17170600000625841706000006258430PA7960702026-04-28False
17060000062616L17/dossiers17170600000625841706000006258431PA7953102026-04-28False
17060000062617L17/dossiers17170600000625841706000006258432PA8419472026-04-28False
17060000062618L17/dossiers17170600000625841706000006258433PA7940822026-04-28False
17060000062619L17/dossiers17170600000625841706000006258434PA7941302026-04-28False