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
17060000004729L17/dossiers17170600000046871706000000468741PA7941382023-05-04False
17060000004730L17/dossiers17170600000046871706000000468742PA7952702023-05-04False
17060000004731L17/dossiers17170600000046871706000000468743PA7931902023-05-04False
17060000004732L17/dossiers17170600000046871706000000468744PA7948702023-05-04False
17060000004733L17/dossiers17170600000046871706000000468745PA6076192023-05-04False
17060000004734L17/dossiers17170600000046871706000000468746PA7956162023-05-04False
17060000004735L17/dossiers17170600000046871706000000468747PA7951362023-05-04False
17060000004736L17/dossiers17170600000046871706000000468748PA7955162023-05-04False
17060000004737L17/dossiers17170600000046871706000000468749PA7937922023-05-04False
17060000004738L17/dossiers17170600000046871706000000468750PA3332852023-05-04False
17060000004739L17/dossiers17170600000046871706000000468751PA7223742023-05-04False
17060000004740L17/dossiers17170600000046871706000000468752PA7200922023-05-04False
17060000004741L17/dossiers17170600000046871706000000468753PA7937722023-05-04False
17060000004742L17/dossiers17170600000046871706000000468754PA7954382023-05-15False
17060000004743L17/dossiers17170600000046871706000000468755PA7954662023-05-15False
17060000004744L17/dossiers17170600000046871706000000468756PA7935602023-05-15False
17060000004745L17/dossiers17170600000046871706000000468757PA7200382023-05-15False
17060000004746L17/dossiers17170600000046871706000000468758PA7937362023-05-15False
17060000004747L17/dossiers17170600000046871706000000468759PA7221102023-05-15False
17060000004748L17/dossiers17170600000046871706000000468760PA7953742023-05-15False
17060000004749L17/dossiers17170600000046871706000000468761PA7195582023-05-15False
17060000004750L17/dossiers17170600000046871706000000468762PA7948302023-05-15False
17060000004751L17/dossiers17170600000046871706000000468763PA7190242023-05-15False
17060000004752L17/dossiers17170600000046871706000000468764PA7221622023-05-15False
17060000004753L17/dossiers17170600000046871706000000468765PA7192942023-05-25False
17060000004754L17/dossiers17170600000046871706000000468766PA7936802023-07-06False
17060000004755L17/dossiers17170600000046871706000000468767PA15672023-07-06False
17060000004756L17/dossiers17170600000046871706000000468768PA7198742023-07-12False
17060000004757L17/dossiers17170600000046871706000000468769PA7212702023-07-20False
17060000004758L17/dossiers17170600000046871706000000468770PA7192862023-07-20False
17060000004759L17/dossiers17170600000046871706000000468771PA7954302023-07-20False
17060000004760L17/dossiers17170600000046871706000000468772PA3424152023-07-20False
17060000004761L17/dossiers17170600000046871706000000468773PA7951642023-07-20False
17060000004762L17/dossiers17170600000046871706000000468774PA7956922023-07-20False
17060000004763L17/dossiers17170600000046871706000000468775PA7954222023-07-20False
17060000004764L17/dossiers17170600000046871706000000468776PA7958442023-07-20False
17060000004765L17/dossiers17170600000046871706000000468777PA7939122023-07-20False
17060000004766L17/dossiers17170600000046871706000000468778PA7213282023-07-21False
17060000004767L17/dossiers17170600000046871706000000468779PA7217102023-07-21False
17060000004768L17/dossiers17170600000046871706000000468780PA7203342023-07-21False
17060000004769L17/dossiers17170600000046871706000000468781PA7120142023-07-21False
17060000004770L17/dossiers17170600000046871706000000468782PA7934162023-07-21False
17060000004771L17/dossiers17170600000046871706000000468783PA7193822023-07-21False
17060000004772L17/dossiers17170600000046871706000000468784PA7946582023-07-21False
17060000004773L17/dossiers17170600000046871706000000468785PA7951002023-07-21False
17060000004774L17/dossiers17170600000046871706000000468786PA7198902023-07-21False
17060000004775L17/dossiers17170600000046871706000000468787PA6428682023-07-21False
17060000004776L17/dossiers17170600000046871706000000468788PA7211702023-07-21False
17060000004777L17/dossiers17170600000046871706000000468789PA7216322023-07-21False
17060000004778L17/dossiers17170600000046871706000000468790PA7190322023-07-21False