decision_law_refs

1,674,560 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link from_decision_id sr article raw_text
bge_100 IA 1,101,4 None bge_100 IA 1 101 4 Art. 4 BV
bge_100 IA 1,131.212,28 None bge_100 IA 1 131.212 28 Art. 28 KV
bge_100 IA 1,131.212,30 None bge_100 IA 1 131.212 30 Art. 30 Abs. 3 KV
bge_100 IA 1,131.212,48 None bge_100 IA 1 131.212 48 Art. 48 Abs. 2 KV
bge_100 IA 1,131.212,56 None bge_100 IA 1 131.212 56 Art. 56 Abs. 2 KV
bge_100 IA 1,311.0,366 None bge_100 IA 1 311.0 366 Art. 366 Abs. 2 lit. a StGB
bge_100 IA 106,455,30 None bge_100 IA 106 455 30 art. 30 al. 2 lit. e LPA
bge_100 IA 106,741.01,55 None bge_100 IA 106 741.01 55 Art. 55 SVG
bge_100 IA 106,741.01,91 None bge_100 IA 106 741.01 91 art. 91 al. 3 LCR
bge_100 IA 109,101,4 None bge_100 IA 109 101 4 Art. 4 BV
bge_100 IA 109,210,25 None bge_100 IA 109 210 25 art. 25 al. 1 CC
bge_100 IA 109,210,308 None bge_100 IA 109 210 308 art. 308 CC
bge_100 IA 109,210,311 None bge_100 IA 109 210 311 art. 311 CC
bge_100 IA 109,210,312 None bge_100 IA 109 210 312 art. 312 al. 1 CC
bge_100 IA 109,210,313 None bge_100 IA 109 210 313 art. 313 CC
bge_100 IA 109,272,58 None bge_100 IA 109 272 58 art. 58 CPC
bge_100 IA 109,272,61 None bge_100 IA 109 272 61 art. 61 al. 3 CPC
bge_100 IA 109,272,92 None bge_100 IA 109 272 92 art. 92 CPC
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
bge_100 IA 12,101,4 None bge_100 IA 12 101 4 Art. 4 BV
bge_100 IA 12,210,145 None bge_100 IA 12 210 145 Art. 145 ZGB
bge_100 IA 12,210,2 None bge_100 IA 12 210 2 art. 2 CC
bge_100 IA 12,210,8 None bge_100 IA 12 210 8 Art. 8 ZGB
bge_100 IA 131,210,664 None bge_100 IA 131 210 664 art. 664 CC
bge_100 IA 147,101,22ter None bge_100 IA 147 101 22ter Art. 22 ter BV
bge_100 IA 157,101,22ter None bge_100 IA 157 101 22ter Art. 22ter BV
bge_100 IA 163,101,31 None bge_100 IA 163 101 31 Art. 31 BV
bge_100 IA 163,101,33 None bge_100 IA 163 101 33 Art. 33 BV
bge_100 IA 163,311.0,321 None bge_100 IA 163 311.0 321 Art. 321 StGB
bge_100 IA 163,513.1,14 None bge_100 IA 163 513.1 14 Art. 14 AO
bge_100 IA 163,513.1,9 None bge_100 IA 163 513.1 9 Art. 9 AO
bge_100 IA 169,101,31 None bge_100 IA 169 101 31 Art. 31 BV
bge_100 IA 18,210,188 None bge_100 IA 18 210 188 art. 188 CC
bge_100 IA 18,281.1,204 None bge_100 IA 18 281.1 204 art. 204 LEF
bge_100 IA 18,281.1,291 None bge_100 IA 18 281.1 291 art. 291 LEF
bge_100 IA 180,101,4 None bge_100 IA 180 101 4 Art. 4 BV
bge_100 IA 189,101,4 None bge_100 IA 189 101 4 Art. 4 BV
bge_100 IA 189,131.212,125 None bge_100 IA 189 131.212 125 Art. 125 KV
bge_100 IA 189,311.0,52 None bge_100 IA 189 311.0 52 art. 52 CP
bge_100 IA 200,172.220.1,5 None bge_100 IA 200 172.220.1 5 Art. 5 BPG
bge_100 IA 209,101,4 None bge_100 IA 209 101 4 Art. 4 BV
bge_100 IA 216,220,400 None bge_100 IA 216 220 400 art. 400 CO

Next page

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