decision_law_refs

9 rows where from_decision_id = "bge_100 IA 119"

✎ View and edit SQL

This data as json, CSV (advanced)

Link from_decision_id sr article raw_text
bge_100 IA 119,101,4 None bge_100 IA 119 101 4 Art. 4 BV
bge_100 IA 119,220,11 None bge_100 IA 119 220 11 Art. 11 Abs. 1 OR
bge_100 IA 119,220,176 None bge_100 IA 119 220 176 Art. 176 OR
bge_100 IA 119,220,320 None bge_100 IA 119 220 320 Art. 320 Abs. 1 OR
bge_100 IA 119,220,327 None bge_100 IA 119 220 327 Art. 327 Abs. 2 OR
bge_100 IA 119,220,333 None bge_100 IA 119 220 333 Art. 333 Abs. 4 OR
bge_100 IA 119,220,343 None bge_100 IA 119 220 343 Art. 343 Abs. 4 OR
bge_100 IA 119,220,352 None bge_100 IA 119 220 352 Art. 352 OR
bge_100 IA 119,272,336 None bge_100 IA 119 272 336 Art. 336 ZPO

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