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
17060000049970L17/dossiers17170600000499541706000004995415PA7944942026-01-19False
17060000049974L17/dossiers1717060000049972170600000499721PA7946582026-03-11False
17060000049975L17/dossiers1717060000049972170600000499722PA8406652026-03-11False
17060000049976L17/dossiers1717060000049972170600000499723PA6427642026-03-11False
17060000049977L17/dossiers1717060000049972170600000499724PA6431432026-03-11False
17060000049978L17/dossiers1717060000049972170600000499725PA3424152026-03-11False
17060000049979L17/dossiers1717060000049972170600000499726PA6067932026-03-11False
17060000049980L17/dossiers1717060000049972170600000499727PA7203622026-03-11False
17060000049981L17/dossiers1717060000049972170600000499728PA8422112026-03-11False
17060000049982L17/dossiers1717060000049972170600000499729PA8413152026-03-11False
17060000049983L17/dossiers17170600000499721706000004997210PA7940942026-03-11False
17060000049984L17/dossiers17170600000499721706000004997211PA7936242026-03-11False
17060000049985L17/dossiers17170600000499721706000004997212PA7957622026-03-11False
17060000049986L17/dossiers17170600000499721706000004997213PA6082642026-03-11False
17060000049987L17/dossiers17170600000499721706000004997214PA8409032026-03-11False
17060000049988L17/dossiers17170600000499721706000004997215PA8412952026-03-11False
17060000049989L17/dossiers17170600000499721706000004997216PA10082026-03-11False
17060000049990L17/dossiers17170600000499721706000004997217PA7933942026-03-11False
17060000049991L17/dossiers17170600000499721706000004997218PA7954302026-03-11False
17060000049992L17/dossiers17170600000499721706000004997219PA8419192026-03-11False
17060000049993L17/dossiers17170600000499721706000004997220PA6065732026-03-11False
17060000049994L17/dossiers17170600000499721706000004997221PA8416332026-03-11False
17060000049995L17/dossiers17170600000499721706000004997222PA7948542026-03-11False
17060000049996L17/dossiers17170600000499721706000004997223PA8421952026-03-11False
17060000049997L17/dossiers17170600000499721706000004997224PA6093322026-03-11False
17060000049998L17/dossiers17170600000499721706000004997225PA8416652026-03-11False
17060000049999L17/dossiers17170600000499721706000004997226PA8226172026-03-11False
17060000050000L17/dossiers17170600000499721706000004997227PA3332852026-03-11False
17060000050001L17/dossiers17170600000499721706000004997228PA8409392026-03-11False
17060000050002L17/dossiers17170600000499721706000004997229PA8415392026-03-11False
17060000050003L17/dossiers17170600000499721706000004997230PA3319732026-03-11False
17060000050004L17/dossiers17170600000499721706000004997231PA8401712026-03-11False
17060000050005L17/dossiers17170600000499721706000004997232PA15672026-03-11False
17060000050006L17/dossiers17170600000499721706000004997233PA8414712026-03-11False
17060000050007L17/dossiers17170600000499721706000004997234PA8422632026-03-11False
17060000050008L17/dossiers17170600000499721706000004997235PA8418132026-03-11False
17060000050009L17/dossiers17170600000499721706000004997236PA8418532026-03-11False
17060000050010L17/dossiers17170600000499721706000004997237PA16542026-03-11False
17060000050011L17/dossiers17170600000499721706000004997238PA7221502026-03-11False
17060000050012L17/dossiers17170600000499721706000004997239PA6431922026-03-11False
17060000050013L17/dossiers17170600000499721706000004997240PA3350542026-03-11False
17060000050014L17/dossiers17170600000499721706000004997241PA7951562026-03-11False
17060000050015L17/dossiers17170600000499721706000004997242PA7749582026-03-11False
17060000050016L17/dossiers17170600000499721706000004997243PA8407652026-03-11False
17060000050017L17/dossiers17170600000499721706000004997244PA8414632026-03-11False
17060000050018L17/dossiers17170600000499721706000004997245PA6431572026-03-11False
17060000050019L17/dossiers17170600000499721706000004997246PA8411072026-03-11False
17060000050020L17/dossiers17170600000499721706000004997247PA8413812026-03-11False
17060000050021L17/dossiers17170600000499721706000004997248PA8407932026-03-11False
17060000050022L17/dossiers17170600000499721706000004997249PA7942702026-03-11False