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
17060000050215L17/dossiers1717060000050208170600000502086PA7958202026-10-02False
17060000050216L17/dossiers1717060000050208170600000502087PA7201542026-10-02False
17060000050217L17/dossiers1717060000050208170600000502088PA7195122026-10-02False
17060000050218L17/dossiers1717060000050208170600000502089PA7221342026-10-02False
17060000050219L17/dossiers17170600000502081706000005020810PA7200922026-10-02False
17060000050220L17/dossiers17170600000502081706000005020811PA8423112026-10-02False
17060000050221L17/dossiers17170600000502081706000005020812PA7930942026-10-02False
17060000050222L17/dossiers17170600000502081706000005020813PA7215842026-10-02False
17060000050223L17/dossiers17170600000502081706000005020814PA7942062026-10-02False
17060000050224L17/dossiers17170600000502081706000005020815PA8419272026-10-02False
17060000050225L17/dossiers17170600000502081706000005020816PA7190322026-10-02False
17060000050226L17/dossiers17170600000502081706000005020817PA3322282026-10-02False
17060000050227L17/dossiers17170600000502081706000005020818PA7946582026-10-02False
17060000050228L17/dossiers17170600000502081706000005020819PA7120142026-10-02False
17060000050229L17/dossiers17170600000502081706000005020820PA7935722026-10-02False
17060000050230L17/dossiers17170600000502081706000005020821PA8402352026-10-02False
17060000050231L17/dossiers17170600000502081706000005020822PA3421962026-10-02False
17060000050232L17/dossiers17170600000502081706000005020823PA3332852026-10-02False
17060000050233L17/dossiers17170600000502081706000005020824PA7223902026-10-02False
17060000050234L17/dossiers17170600000502081706000005020825PA2670422026-10-02False
17060000050235L17/dossiers17170600000502081706000005020826PA7200382026-10-02False
17060000050236L17/dossiers17170600000502081706000005020827PA8413392026-10-02False
17060000050237L17/dossiers17170600000502081706000005020828PA7203422026-10-02False
17060000050238L17/dossiers17170600000502081706000005020829PA7203542026-10-02False
17060000050239L17/dossiers17170600000502081706000005020830PA15922026-10-02False
17060000050240L17/dossiers17170600000502081706000005020831PA7221022026-10-02False
17060000050241L17/dossiers17170600000502081706000005020832PA7197362026-10-02False
17060000050242L17/dossiers17170600000502081706000005020833PA6076192026-10-02False
17060000050243L17/dossiers17170600000502081706000005020834PA6073952026-10-02False
17060000050244L17/dossiers17170600000502081706000005020835PA3096432026-10-02False
17060000050245L17/dossiers17170600000502081706000005020836PA7947022026-10-02False
17060000050246L17/dossiers17170600000502081706000005020837PA8414192026-10-02False
17060000050247L17/dossiers17170600000502081706000005020838PA7194042026-10-02False
17060000050248L17/dossiers17170600000502081706000005020839PA7948022026-10-02False
17060000050249L17/dossiers17170600000502081706000005020840PA7194122026-10-02False
17060000050250L17/dossiers17170600000502081706000005020841PA7223662026-10-02False
17060000050251L17/dossiers17170600000502081706000005020842PA7220702026-10-02False
17060000050252L17/dossiers17170600000502081706000005020843PA8793892026-10-02False
17060000050253L17/dossiers17170600000502081706000005020844PA7201462026-10-02False
17060000050254L17/dossiers17170600000502081706000005020845PA7197562026-10-02False
17060000050255L17/dossiers17170600000502081706000005020846PA7193382026-10-02False
17060000050256L17/dossiers17170600000502081706000005020847PA7219842026-10-02False
17060000050257L17/dossiers17170600000502081706000005020848PA7935562026-10-02False
17060000050258L17/dossiers17170600000502081706000005020849PA7198902026-10-02False
17060000050265L17/dossiers1717060000050263170600000502631PA8406652026-07-09False
17060000050266L17/dossiers1717060000050263170600000502632PA8408292026-07-09False
17060000050267L17/dossiers1717060000050263170600000502633PA6067932026-07-09False
17060000050268L17/dossiers1717060000050263170600000502634PA8401752026-07-09False
17060000050269L17/dossiers1717060000050263170600000502635PA7191382026-07-09False
17060000050270L17/dossiers1717060000050263170600000502636PA3332852026-07-09False