AN · données ouvertes
Explorateur / dossiers

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
17060000023401L17/dossiers1717060000023394170600000233946PA7941382025-01-16False
17060000023402L17/dossiers1717060000023394170600000233947PA7955882025-01-16False
17060000023403L17/dossiers1717060000023394170600000233948PA7950842025-01-16False
17060000023404L17/dossiers1717060000023394170600000233949PA8421052025-01-16False
17060000023405L17/dossiers17170600000233941706000002339410PA8416572025-01-16False
17060000023406L17/dossiers17170600000233941706000002339411PA7204302025-01-16False
17060000023407L17/dossiers17170600000233941706000002339412PA7937722025-01-16False
17060000023408L17/dossiers17170600000233941706000002339413PA7956162025-01-16False
17060000023409L17/dossiers17170600000233941706000002339414PA7934442025-01-16False
17060000023410L17/dossiers17170600000233941706000002339415PA7949382025-01-16False
17060000023411L17/dossiers17170600000233941706000002339416PA7953182025-01-16False
17060000023412L17/dossiers17170600000233941706000002339417PA8410232025-01-16False
17060000023413L17/dossiers17170600000233941706000002339418PA7960902025-01-16False
17060000023414L17/dossiers17170600000233941706000002339419PA7939122025-01-16False
17060000023415L17/dossiers17170600000233941706000002339420PA8421872025-01-16False
17060000023416L17/dossiers17170600000233941706000002339421PA8420372025-01-16False
17060000023417L17/dossiers17170600000233941706000002339422PA7918122025-01-16False
17060000023418L17/dossiers17170600000233941706000002339423PA7937362025-01-16False
17060000023419L17/dossiers17170600000233941706000002339424PA7212022025-01-16False
17060000023420L17/dossiers17170600000233941706000002339425PA7951362025-01-16False
17060000023421L17/dossiers17170600000233941706000002339426PA7934642025-01-16False
17060000023422L17/dossiers17170600000233941706000002339427PA8421552025-01-16False
17060000023423L17/dossiers17170600000233941706000002339428PA7952002025-01-16False
17060000023424L17/dossiers17170600000233941706000002339429PA7958442025-01-16False
17060000023425L17/dossiers17170600000233941706000002339430PA8412512025-01-16False
17060000023426L17/dossiers17170600000233941706000002339431PA7947862025-01-16False
17060000023427L17/dossiers17170600000233941706000002339432PA7948702025-01-16False
17060000023428L17/dossiers17170600000233941706000002339433PA7960702025-01-16False
17060000023429L17/dossiers17170600000233941706000002339434PA7953102025-01-16False
17060000023430L17/dossiers17170600000233941706000002339435PA7944782025-01-16False
17060000023431L17/dossiers17170600000233941706000002339436PA8419472025-01-16False
17060000023432L17/dossiers17170600000233941706000002339437PA7940822025-01-16False
17060000023433L17/dossiers17170600000233941706000002339438PA7941302025-01-16False
17060000023434L17/dossiers17170600000233941706000002339439PA8417292025-01-16False
17060000023435L17/dossiers17170600000233941706000002339440PA7955162025-01-16False
17060000023436L17/dossiers17170600000233941706000002339441PA7956722025-01-16False
17060000023437L17/dossiers17170600000233941706000002339442PA8415152025-01-16False
17060000023438L17/dossiers17170600000233941706000002339443PA7957462025-01-16False
17060000023439L17/dossiers17170600000233941706000002339444PA7951082025-01-16False
17060000023440L17/dossiers17170600000233941706000002339445PA7952982025-01-16False
17060000023441L17/dossiers17170600000233941706000002339446PA7918242025-01-16False
17060000023442L17/dossiers17170600000233941706000002339447PA8420292025-01-16False
17060000023443L17/dossiers17170600000233941706000002339448PA7935322025-01-16False
17060000023444L17/dossiers17170600000233941706000002339449PA3423842025-01-16False
17060000023445L17/dossiers17170600000233941706000002339450PA7954222025-01-16False
17060000023446L17/dossiers17170600000233941706000002339451PA7946862025-01-16False
17060000023447L17/dossiers17170600000233941706000002339452PA8412152025-01-16False
17060000023448L17/dossiers17170600000233941706000002339453PA7954822025-01-16False
17060000023449L17/dossiers17170600000233941706000002339454PA6106542025-01-16False
17060000023450L17/dossiers17170600000233941706000002339455PA8411912025-01-16False