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
17060000004919L17/dossiers17170600000049031706000000490315PA7942142023-04-28False
17060000004920L17/dossiers17170600000049031706000000490316PA7215222023-04-28False
17060000004921L17/dossiers17170600000049031706000000490317PA7203622023-04-28False
17060000004922L17/dossiers17170600000049031706000000490318PA7199102023-04-28False
17060000004923L17/dossiers17170600000049031706000000490319PA7218282023-04-28False
17060000004924L17/dossiers17170600000049031706000000490320PA7935002023-04-28False
17060000004925L17/dossiers17170600000049031706000000490321PA6426952023-04-28False
17060000004926L17/dossiers17170600000049031706000000490322PA6065072023-04-28False
17060000004927L17/dossiers17170600000049031706000000490323PA7935282023-04-28False
17060000004928L17/dossiers17170600000049031706000000490324PA7190322023-04-28False
17060000004929L17/dossiers17170600000049031706000000490325PA7187102023-04-28False
17060000004930L17/dossiers17170600000049031706000000490326PA7219082023-04-28False
17060000004931L17/dossiers17170600000049031706000000490327PA7959902023-04-28False
17060000004932L17/dossiers17170600000049031706000000490328PA7943302023-04-28False
17060000004933L17/dossiers17170600000049031706000000490329PA7213282023-04-28False
17060000004934L17/dossiers17170600000049031706000000490330PA7198902023-04-28False
17060000004935L17/dossiers17170600000049031706000000490331PA7220002023-04-28False
17060000004936L17/dossiers17170600000049031706000000490332PA7947982023-04-28False
17060000004937L17/dossiers17170600000049031706000000490333PA7217502023-04-28False
17060000004938L17/dossiers17170600000049031706000000490334PA7953302023-04-28False
17060000004939L17/dossiers17170600000049031706000000490335PA7199222023-04-28False
17060000004940L17/dossiers17170600000049031706000000490336PA7958642023-04-28False
17060000004941L17/dossiers17170600000049031706000000490337PA7194722023-04-28False
17060000004942L17/dossiers17170600000049031706000000490338PA7955082023-04-28False
17060000004943L17/dossiers17170600000049031706000000490339PA7950682023-04-28False
17060000004944L17/dossiers17170600000049031706000000490340PA7959082023-04-28False
17060000004945L17/dossiers17170600000049031706000000490341PA7192942023-04-28False
17060000004946L17/dossiers17170600000049031706000000490342PA7198142023-04-28False
17060000004947L17/dossiers17170600000049031706000000490343PA7191182023-04-28False
17060000004948L17/dossiers17170600000049031706000000490344PA7938762023-04-28False
17060000004949L17/dossiers17170600000049031706000000490345PA7209322023-04-28False
17060000004950L17/dossiers17170600000049031706000000490346PA7945102023-04-28False
17060000004951L17/dossiers17170600000049031706000000490347PA7949822023-04-28False
17060000004952L17/dossiers17170600000049031706000000490348PA7208622023-04-28False
17060000004953L17/dossiers17170600000049031706000000490349PA7223822023-04-28False
17060000004954L17/dossiers17170600000049031706000000490350PA7201542023-04-28False
17060000004955L17/dossiers17170600000049031706000000490351PA7210942023-04-28False
17060000004956L17/dossiers17170600000049031706000000490352PA6431752023-04-28False
17060000004957L17/dossiers17170600000049031706000000490353PA7946582023-04-28False
17060000004958L17/dossiers17170600000049031706000000490354PA7958842023-04-28False
17060000004959L17/dossiers17170600000049031706000000490355PA7221342023-04-28False
17060000004960L17/dossiers17170600000049031706000000490356PA7223662023-04-28False
17060000004961L17/dossiers17170600000049031706000000490357PA7223582023-04-28False
17060000004962L17/dossiers17170600000049031706000000490358PA7210242023-04-28False
17060000004963L17/dossiers17170600000049031706000000490359PA7191082023-04-28False
17060000004964L17/dossiers17170600000049031706000000490360PA7217222023-04-28False
17060000004965L17/dossiers17170600000049031706000000490361PA7202222023-04-28False
17060000004966L17/dossiers17170600000049031706000000490362PA2673362023-04-28False
17060000004967L17/dossiers17170600000049031706000000490363PA7186742023-04-28False
17060000004968L17/dossiers17170600000049031706000000490364PA7948462023-04-28False