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
17060000021230L17/dossiers17170600000211861706000002118643PA2677942025-02-17False
17060000021231L17/dossiers17170600000211861706000002118644PA7941782025-02-17False
17060000021232L17/dossiers17170600000211861706000002118645PA7941182025-02-17False
17060000021233L17/dossiers17170600000211861706000002118646PA6070902025-02-17False
17060000021234L17/dossiers17170600000211861706000002118647PA7940422025-02-17False
17060000021235L17/dossiers17170600000211861706000002118648PA6084162025-02-17False
17060000021236L17/dossiers17170600000211861706000002118649PA7947502025-02-17False
17060000021237L17/dossiers17170600000211861706000002118650PA8421412025-02-17False
17060000021238L17/dossiers17170600000211861706000002118651PA7949942025-02-17False
17060000021239L17/dossiers17170600000211861706000002118652PA6430892025-02-17False
17060000021243L17/dossiers1717060000021241170600000212411PA7939922026-04-01False
17060000021244L17/dossiers1717060000021241170600000212412PA7959502026-04-01False
17060000021245L17/dossiers1717060000021241170600000212413PA7951442026-04-01False
17060000021246L17/dossiers1717060000021241170600000212414PA7202562026-04-01False
17060000021247L17/dossiers1717060000021241170600000212415PA2677632026-04-01False
17060000021248L17/dossiers1717060000021241170600000212416PA6428472026-04-01False
17060000021249L17/dossiers1717060000021241170600000212417PA7203622026-04-01False
17060000021250L17/dossiers1717060000021241170600000212418PA7952782026-04-01False
17060000021251L17/dossiers1717060000021241170600000212419PA6872142026-04-01False
17060000021252L17/dossiers17170600000212411706000002124110PA7199682026-04-01False
17060000021253L17/dossiers17170600000212411706000002124111PA7218162026-04-01False
17060000021254L17/dossiers17170600000212411706000002124112PA6065072026-04-01False
17060000021255L17/dossiers17170600000212411706000002124113PA7190322026-04-01False
17060000021256L17/dossiers17170600000212411706000002124114PA8413392026-04-01False
17060000021257L17/dossiers17170600000212411706000002124115PA7943302026-04-01False
17060000021258L17/dossiers17170600000212411706000002124116PA8408172026-04-01False
17060000021259L17/dossiers17170600000212411706000002124117PA7220002026-04-01False
17060000021260L17/dossiers17170600000212411706000002124118PA7217502026-04-01False
17060000021261L17/dossiers17170600000212411706000002124119PA7191382026-04-01False
17060000021262L17/dossiers17170600000212411706000002124120PA7945542026-04-01False
17060000021263L17/dossiers17170600000212411706000002124121PA8423112026-04-01False
17060000021264L17/dossiers17170600000212411706000002124122PA7199222026-04-01False
17060000021265L17/dossiers17170600000212411706000002124123PA7939402026-04-01False
17060000021266L17/dossiers17170600000212411706000002124124PA7194722026-04-01False
17060000021267L17/dossiers17170600000212411706000002124125PA6428682026-04-01False
17060000021268L17/dossiers17170600000212411706000002124126PA8409032026-04-01False
17060000021269L17/dossiers17170600000212411706000002124127PA7954022026-04-01False
17060000021270L17/dossiers17170600000212411706000002124128PA8414312026-04-01False
17060000021271L17/dossiers17170600000212411706000002124129PA7188502026-04-01False
17060000021272L17/dossiers17170600000212411706000002124130PA7223902026-04-01False
17060000021273L17/dossiers17170600000212411706000002124131PA9422026-04-01False
17060000021274L17/dossiers17170600000212411706000002124132PA7937162026-04-01False
17060000021275L17/dossiers17170600000212411706000002124133PA7954302026-04-01False
17060000021276L17/dossiers17170600000212411706000002124134PA7949822026-04-01False
17060000021277L17/dossiers17170600000212411706000002124135PA7940422026-04-01False
17060000021278L17/dossiers17170600000212411706000002124136PA6088262026-04-01False
17060000021279L17/dossiers17170600000212411706000002124137PA7946582026-04-01False
17060000021280L17/dossiers17170600000212411706000002124138PA6056942026-04-01False
17060000021281L17/dossiers17170600000212411706000002124139PA7221342026-04-01False
17060000021282L17/dossiers17170600000212411706000002124140PA8402352026-04-01False