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 151 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
17060000004779L17/dossiers17170600000046871706000000468791PA7200662023-07-21False
17060000004780L17/dossiers17170600000046871706000000468792PA7948382023-07-21False
17060000004781L17/dossiers17170600000046871706000000468793PA7204462023-07-21False
17060000004782L17/dossiers17170600000046871706000000468794PA7197562023-07-21False
17060000004783L17/dossiers17170600000046871706000000468795PA7209322023-07-21False
17060000004784L17/dossiers17170600000046871706000000468796PA7193882023-07-21False
17060000004785L17/dossiers17170600000046871706000000468797PA6059632023-07-21False
17060000004786L17/dossiers17170600000046871706000000468798PA7201542023-07-21False
17060000004787L17/dossiers17170600000046871706000000468799PA7189622023-07-21False
17060000004788L17/dossiers171706000000468717060000004687100PA7209002023-07-21False
17060000004789L17/dossiers171706000000468717060000004687101PA7189302023-07-21False
17060000004790L17/dossiers171706000000468717060000004687102PA7199182023-07-21False
17060000004791L17/dossiers171706000000468717060000004687103PA7201742023-07-21False
17060000004792L17/dossiers171706000000468717060000004687104PA7221342023-07-21False
17060000004793L17/dossiers171706000000468717060000004687105PA7193962023-07-21False
17060000004794L17/dossiers171706000000468717060000004687106PA7221022023-07-21False
17060000004795L17/dossiers171706000000468717060000004687107PA7938762023-07-21False
17060000004796L17/dossiers171706000000468717060000004687108PA7196322023-07-21False
17060000004797L17/dossiers171706000000468717060000004687109PA7935002023-07-21False
17060000004798L17/dossiers171706000000468717060000004687110PA7950462023-07-21False
17060000004799L17/dossiers171706000000468717060000004687111PA7941942023-07-21False
17060000004800L17/dossiers171706000000468717060000004687112PA7947022023-07-21False
17060000004801L17/dossiers171706000000468717060000004687113PA7204802023-07-21False
17060000004802L17/dossiers171706000000468717060000004687114PA7201382023-07-21False
17060000004803L17/dossiers171706000000468717060000004687115PA7214262023-07-21False
17060000004804L17/dossiers171706000000468717060000004687116PA7200542023-07-21False
17060000004805L17/dossiers171706000000468717060000004687117PA2673362023-07-21False
17060000004806L17/dossiers171706000000468717060000004687118PA7217222023-07-21False
17060000004807L17/dossiers171706000000468717060000004687119PA7948462023-07-21False
17060000004808L17/dossiers171706000000468717060000004687120PA7218442023-07-21False
17060000004809L17/dossiers171706000000468717060000004687121PA7953302023-07-21False
17060000004810L17/dossiers171706000000468717060000004687122PA7943862023-07-21False
17060000004811L17/dossiers171706000000468717060000004687123PA7223662023-07-21False
17060000004812L17/dossiers171706000000468717060000004687124PA7932782023-07-21False
17060000004813L17/dossiers171706000000468717060000004687125PA7937162023-07-21False
17060000004814L17/dossiers171706000000468717060000004687126PA7220542023-07-21False
17060000004815L17/dossiers171706000000468717060000004687127PA7195122023-07-21False
17060000004816L17/dossiers171706000000468717060000004687128PA7933062023-07-21False
17060000004817L17/dossiers171706000000468717060000004687129PA29602023-07-21False
17060000004818L17/dossiers171706000000468717060000004687130PA7947982023-07-21False
17060000004819L17/dossiers171706000000468717060000004687131PA7949742023-07-21False
17060000004820L17/dossiers171706000000468717060000004687132PA3457222023-07-21False
17060000004821L17/dossiers171706000000468717060000004687133PA6431842023-07-21False
17060000004822L17/dossiers171706000000468717060000004687134PA7191182023-07-21False
17060000004823L17/dossiers171706000000468717060000004687135PA7950262023-07-21False
17060000004824L17/dossiers171706000000468717060000004687136PA7211502023-07-21False
17060000004825L17/dossiers171706000000468717060000004687137PA7203422023-07-21False
17060000004826L17/dossiers171706000000468717060000004687138PA7210942023-07-21False
17060000004827L17/dossiers171706000000468717060000004687139PA7953502023-07-21False
17060000004828L17/dossiers171706000000468717060000004687140PA6431752023-07-21False