decision_law_refs

5 rows where from_decision_id = "bge_100 IA 362"

✎ View and edit SQL

This data as json, CSV (advanced)

Link from_decision_id sr article raw_text
bge_100 IA 362,131.212,34 None bge_100 IA 362 131.212 34 Art. 34 KV
bge_100 IA 362,131.212,45 None bge_100 IA 362 131.212 45 Art. 45 Abs. 4 KV
bge_100 IA 362,817.02,16 None bge_100 IA 362 817.02 16 Art. 16 LGV
bge_100 IA 362,817.02,2 None bge_100 IA 362 817.02 2 Art. 2 LGV
bge_100 IA 362,817.02,3 None bge_100 IA 362 817.02 3 Art. 3 LGV

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE decision_law_refs (
    from_decision_id TEXT NOT NULL,
    sr               TEXT NOT NULL,
    article          TEXT NOT NULL,
    raw_text         TEXT,
    PRIMARY KEY (from_decision_id, sr, article),
    FOREIGN KEY (from_decision_id) REFERENCES decisions(decision_id) ON DELETE CASCADE
);
CREATE INDEX idx_dlr_law      ON decision_law_refs(sr, article);
CREATE INDEX idx_dlr_decision ON decision_law_refs(from_decision_id);