decision_law_refs

13 rows where from_decision_id = "bge_151 II 737"

✎ View and edit SQL

This data as json, CSV (advanced)

Link from_decision_id sr article raw_text
bge_151 II 737,101,188 None bge_151 II 737 101 188 Art. 188 Abs. 1 BV
bge_151 II 737,101,189 None bge_151 II 737 101 189 Art. 189 BV
bge_151 II 737,142.20,126 None bge_151 II 737 142.20 126 Art. 126 Abs. 1 AIG
bge_151 II 737,142.20,126g None bge_151 II 737 142.20 126g Art. 126g AIG
bge_151 II 737,142.20,44 None bge_151 II 737 142.20 44 Art. 44 AIG
bge_151 II 737,142.20,45 None bge_151 II 737 142.20 45 Art. 45 AIG
bge_151 II 737,142.20,50 None bge_151 II 737 142.20 50 Art. 50 AIG
bge_151 II 737,142.20,52 None bge_151 II 737 142.20 52 Art. 52 AIG
bge_151 II 737,142.20,58a None bge_151 II 737 142.20 58a Art. 58a AIG
bge_151 II 737,142.20,85c None bge_151 II 737 142.20 85c Art. 85c Abs. 1 AIG
bge_151 II 737,173.110,105 None bge_151 II 737 173.110 105 Art. 105 Abs. 1 BGG
bge_151 II 737,173.110,95 None bge_151 II 737 173.110 95 Art. 95 BGG
bge_151 II 737,700.1,52 None bge_151 II 737 700.1 52 Art. 52 Abs. 2 RPV

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);