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
17060000032668L17/dossiers17170600000326051706000003260562PA8418452025-04-01False
17060000032669L17/dossiers17170600000326051706000003260563PA7959822025-04-01False
17060000032670L17/dossiers17170600000326051706000003260564PA7954662025-04-01False
17060000032671L17/dossiers17170600000326051706000003260565PA7937442025-04-01False
17060000032672L17/dossiers17170600000326051706000003260566PA7209522025-04-01False
17060000032673L17/dossiers17170600000326051706000003260567PA7941062025-04-01False
17060000032674L17/dossiers17170600000326051706000003260568PA7941662025-04-01False
17060000032675L17/dossiers17170600000326051706000003260569PA7951642025-04-01False
17060000032676L17/dossiers17170600000326051706000003260570PA7955962025-04-01False
17060000032680L17/dossiers1717060000032678170600000326781PA7219322025-04-04False
17060000032681L17/dossiers1717060000032678170600000326782PA7936162025-04-04False
17060000032682L17/dossiers1717060000032678170600000326783PA6429882025-04-04False
17060000032683L17/dossiers1717060000032678170600000326784PA7938922025-04-04False
17060000032684L17/dossiers1717060000032678170600000326785PA8407812025-04-04False
17060000032685L17/dossiers1717060000032678170600000326786PA8417492025-04-04False
17060000032686L17/dossiers1717060000032678170600000326787PA7947702025-04-04False
17060000032687L17/dossiers1717060000032678170600000326788PA7949462025-04-04False
17060000032688L17/dossiers1717060000032678170600000326789PA7194362025-04-04False
17060000032689L17/dossiers17170600000326781706000003267810PA7931582025-04-04False
17060000032690L17/dossiers17170600000326781706000003267811PA8420852025-04-04False
17060000032691L17/dossiers17170600000326781706000003267812PA7945622025-04-04False
17060000032692L17/dossiers17170600000326781706000003267813PA7932462025-04-04False
17060000032693L17/dossiers17170600000326781706000003267814PA7957862025-04-04False
17060000032694L17/dossiers17170600000326781706000003267815PA7947622025-04-04False
17060000032695L17/dossiers17170600000326781706000003267816PA8409672025-04-04False
17060000032696L17/dossiers17170600000326781706000003267817PA7954102025-04-04False
17060000032697L17/dossiers17170600000326781706000003267818PA7932182025-04-04False
17060000032698L17/dossiers17170600000326781706000003267819PA7931022025-04-04False
17060000032699L17/dossiers17170600000326781706000003267820PA7944182025-04-04False
17060000032700L17/dossiers17170600000326781706000003267821PA7931342025-04-04False
17060000032701L17/dossiers17170600000326781706000003267822PA7945822025-04-04False
17060000032702L17/dossiers17170600000326781706000003267823PA7931822025-04-04False
17060000032703L17/dossiers17170600000326781706000003267824PA7932982025-04-04False
17060000032704L17/dossiers17170600000326781706000003267825PA7949542025-04-04False
17060000032705L17/dossiers17170600000326781706000003267826PA8418372025-04-04False
17060000032706L17/dossiers17170600000326781706000003267827PA8416052025-04-04False
17060000032707L17/dossiers17170600000326781706000003267828PA7960422025-04-04False
17060000032708L17/dossiers17170600000326781706000003267829PA7959742025-04-04False
17060000032709L17/dossiers17170600000326781706000003267830PA7944342025-04-04False
17060000032710L17/dossiers17170600000326781706000003267831PA7932382025-04-04False
17060000032711L17/dossiers17170600000326781706000003267832PA8415632025-04-04False
17060000032712L17/dossiers17170600000326781706000003267833PA7960342025-04-04False
17060000032713L17/dossiers17170600000326781706000003267834PA7936082025-04-04False
17060000032714L17/dossiers17170600000326781706000003267835PA7935922025-04-04False
17060000032715L17/dossiers17170600000326781706000003267836PA8408012025-04-04False
17060000032716L17/dossiers17170600000326781706000003267837PA7959122025-04-04False
17060000032717L17/dossiers17170600000326781706000003267838PA8410672025-04-04False
17060000032718L17/dossiers17170600000326781706000003267839PA8411312025-04-04False
17060000032719L17/dossiers17170600000326781706000003267840PA7960262025-04-04False
17060000032720L17/dossiers17170600000326781706000003267841PA7946702025-04-04False