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
17060000018400L17/dossiers1717060000018394170600000183945PA8408292024-12-11False
17060000018401L17/dossiers1717060000018394170600000183946PA8417452024-12-11False
17060000018402L17/dossiers1717060000018394170600000183947PA7952782024-12-11False
17060000018403L17/dossiers1717060000018394170600000183948PA8051662024-12-11False
17060000018404L17/dossiers1717060000018394170600000183949PA7199682024-12-11False
17060000018405L17/dossiers17170600000183941706000001839410PA8408172024-12-11False
17060000018406L17/dossiers17170600000183941706000001839411PA6082642024-12-11False
17060000018407L17/dossiers17170600000183941706000001839412PA8409032024-12-11False
17060000018408L17/dossiers17170600000183941706000001839413PA8414312024-12-11False
17060000018409L17/dossiers17170600000183941706000001839414PA7223902024-12-11False
17060000018410L17/dossiers17170600000183941706000001839415PA7935202024-12-11False
17060000018411L17/dossiers17170600000183941706000001839416PA7954302024-12-11False
17060000018412L17/dossiers17170600000183941706000001839417PA8407132024-12-11False
17060000018413L17/dossiers17170600000183941706000001839418PA7221342024-12-11False
17060000018414L17/dossiers17170600000183941706000001839419PA2677802024-12-11False
17060000018415L17/dossiers17170600000183941706000001839420PA8402352024-12-11False
17060000018416L17/dossiers17170600000183941706000001839421PA7223582024-12-11False
17060000018417L17/dossiers17170600000183941706000001839422PA7212962024-12-11False
17060000018418L17/dossiers17170600000183941706000001839423PA8401712024-12-11False
17060000018419L17/dossiers17170600000183941706000001839424PA2673182024-12-11False
17060000018420L17/dossiers17170600000183941706000001839425PA7952582024-12-11False
17060000018421L17/dossiers17170600000183941706000001839426PA8422632024-12-11False
17060000018422L17/dossiers17170600000183941706000001839427PA7200382024-12-11False
17060000018423L17/dossiers17170600000183941706000001839428PA7200222024-12-11False
17060000018424L17/dossiers17170600000183941706000001839429PA7953742024-12-11False
17060000018425L17/dossiers17170600000183941706000001839430PA8409792024-12-11False
17060000018426L17/dossiers17170600000183941706000001839431PA8416012024-12-11False
17060000018427L17/dossiers17170600000183941706000001839432PA7947022024-12-11False
17060000018428L17/dossiers17170600000183941706000001839433PA6080162024-12-11False
17060000018429L17/dossiers17170600000183941706000001839434PA7941142024-12-11False
17060000018430L17/dossiers17170600000183941706000001839435PA6057822024-12-11False
17060000018431L17/dossiers17170600000183941706000001839436PA7945182024-12-11False
17060000018432L17/dossiers17170600000183941706000001839437PA7951002024-12-11False
17060000018433L17/dossiers17170600000183941706000001839438PA7207282024-12-11False
17060000018434L17/dossiers17170600000183941706000001839439PA7196402024-12-11False
17060000018435L17/dossiers17170600000183941706000001839440PA7948102024-12-11False
17060000018436L17/dossiers17170600000183941706000001839441PA7940382024-12-11False
17060000018437L17/dossiers17170600000183941706000001839442PA7957222024-12-11False
17060000018438L17/dossiers17170600000183941706000001839443PA7951242024-12-11False
17060000018439L17/dossiers17170600000183941706000001839444PA7203342024-12-11False
17060000018440L17/dossiers17170600000183941706000001839445PA7196322024-12-11False
17060000018441L17/dossiers17170600000183941706000001839446PA7211822024-12-11False
17060000018442L17/dossiers17170600000183941706000001839447PA7212342024-12-11False
17060000018443L17/dossiers17170600000183941706000001839448PA7937082024-12-11False
17060000018444L17/dossiers17170600000183941706000001839449PA7935722024-12-11False
17060000018445L17/dossiers17170600000183941706000001839450PA7207202024-12-11False
17060000018446L17/dossiers17170600000183941706000001839451PA7200922024-12-11False
17060000018447L17/dossiers17170600000183941706000001839452PA8266352024-12-11False
17060000018448L17/dossiers17170600000183941706000001839453PA7932702024-12-11False
17060000018449L17/dossiers17170600000183941706000001839454PA8416812024-12-11False