decision_law_refs

1,553,534 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link from_decision_id sr article raw_text
bge_10_I_1,151.1,51 BGE 10 I 1 bge_10_I_1 151.1 51 Art. 51 leg
bge_10_I_244,151.1,29 BGE 10 I 244 bge_10_I_244 151.1 29 Art. 29 leg
bge_10_I_353,151.1,6 BGE 10 I 353 bge_10_I_353 151.1 6 Art. 6 leg
bge_10_I_53,151.1,5 BGE 10 I 53 bge_10_I_53 151.1 5 Art. 5 leg
bge_10_I_542,151.1,46 BGE 10 I 542 bge_10_I_542 151.1 46 Art. 46 leg
bge_10_I_551,151.1,22 BGE 10 I 551 bge_10_I_551 151.1 22 Art. 22 Abs. 2 leg
bge_10_I_99,916.371,45 BGE 10 I 99 bge_10_I_99 916.371 45 art. 45 ou
bge_11_I_139,151.1,17 BGE 11 I 139 bge_11_I_139 151.1 17 Art. 17 leg
bge_11_I_151,151.1,59 BGE 11 I 151 bge_11_I_151 151.1 59 Art. 59 leg
bge_11_I_220,151.1,33 BGE 11 I 220 bge_11_I_220 151.1 33 Art. 33 leg
bge_11_I_346,151.1,47 BGE 11 I 346 bge_11_I_346 151.1 47 Art. 47 leg
bge_11_I_43,151.1,29 BGE 11 I 43 bge_11_I_43 151.1 29 Art. 29 leg
bge_11_I_445,151.1,56 BGE 11 I 445 bge_11_I_445 151.1 56 Art. 56 leg
bge_11_I_45,151.1,45 BGE 11 I 45 bge_11_I_45 151.1 45 Art. 45 leg
bge_11_I_69,151.1,739 BGE 11 I 69 bge_11_I_69 151.1 739 Art. 739 leg
bge_12_I_160,151.1,3 BGE 12 I 160 bge_12_I_160 151.1 3 Art. 3 leg
bge_12_I_463,151.1,12 BGE 12 I 463 bge_12_I_463 151.1 12 Art. 12 leg
bge_12_I_463,151.1,15 BGE 12 I 463 bge_12_I_463 151.1 15 Art. 15 leg
bge_12_I_463,151.1,17 BGE 12 I 463 bge_12_I_463 151.1 17 Art. 17 leg
bge_12_I_49,151.1,8 BGE 12 I 49 bge_12_I_49 151.1 8 Art. 8 leg
bge_12_I_587,151.1,3 BGE 12 I 587 bge_12_I_587 151.1 3 Art. 3 leg
bge_13_I_135,748.0,2 BGE 13 I 135 bge_13_I_135 748.0 2 art. 2 la
bge_13_I_210,151.1,7 BGE 13 I 210 bge_13_I_210 151.1 7 Art. 7 leg
bge_13_I_295,151.1,73 BGE 13 I 295 bge_13_I_295 151.1 73 Art. 73 leg
bge_14_I_182,151.1,2 BGE 14 I 182 bge_14_I_182 151.1 2 Art. 2 leg
bge_14_I_224,151.1,59 BGE 14 I 224 bge_14_I_224 151.1 59 Art. 59 Al. 2 leg
bge_14_I_261,151.1,7 BGE 14 I 261 bge_14_I_261 151.1 7 Art. 7 leg
bge_14_I_450,151.1,2 BGE 14 I 450 bge_14_I_450 151.1 2 Art. 2 leg
bge_14_I_559,151.1,5 BGE 14 I 559 bge_14_I_559 151.1 5 Art. 5 leg
bge_14_I_568,916.310,83bis BGE 14 I 568 bge_14_I_568 916.310 83bis art. 83 bis oe
bge_14_I_658,151.1,3 BGE 14 I 658 bge_14_I_658 151.1 3 Art. 3 leg
bge_14_I_81,151.1,6 BGE 14 I 81 bge_14_I_81 151.1 6 Art. 6 leg
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
bge_151 II 742,231.1,10 None bge_151 II 742 231.1 10 Art. 10 Abs. 1 URG
bge_151 II 742,241,2 None bge_151 II 742 241 2 Art. 2 UWG
bge_151 II 742,241,3 None bge_151 II 742 241 3 Art. 3 Abs. 1 lit. d UWG
bge_151 II 742,241,5 None bge_151 II 742 241 5 Art. 5 lit. c UWG
bge_151 II 742,251,27 None bge_151 II 742 251 27 Art. 27 KG

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