Vorgaenge

39 rows where siz_nr = 109

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
25 25 23 109 109 89/26/27G   198800985 198800985
1935 1935 6 109 109 89/26/30G   198800958 198800958
3272 3272 24 109 109 89/26/38G   198800987 198800987
3284 3284 11 109 109 89/26/16G   198801091 198801091
5568 5568 8 109 109 89/26/39G   198800961 198800961
6223 6223 12 109 109 89/26/10cG   198800724 198800724
8912 8912 15 109 109 89/26/10aG   198800506 198800506
10315 10315 19 109 109 89/26/37G   198800981 198800981
10482 10482 16 109 109 89/26/34G   198800965 198800965
11124 11124 27 109 109 89/26/25G   198800972 198800972
11384 11384 25 109 109 89/26/02G   198800831 198800831
14385 14385 38 109 109 89/26/06aG   198400353 198400353
14573 14573 34 109 109 89/26/10bG   198800674 198800674
14581 14581 30 109 109 89/26/20G   198800977 198800977
15962 15962 1 109 109 89/26/17G   198801111 198801111
16261 16261 7 109 109 89/26/31G   198800959 198800959
16342 16342 3 109 109 89/26/15G   198800835 198800835
17657 17657 31 109 109 89/26/32G   198800962 198800962
19601 19601 9 109 109 89/26/33G   198800963 198800963
19651 19651 36 109 109 89/26/22G   198800553 198800553
20621 20621 39 109 109 89/26/04G   198801138 198801138
21182 21182 21 109 109 89/26/24G   198800983 198800983
21419 21419 22 109 109 89/26/26G   198800984 198800984
22673 22673 10 109 109 89/26/05G   198801135 198801135
22747 22747 32 109 109 89/26/06bG   198800546 198800546
23285 23285 35 109 109 89/26/03G   198800832 198800832
23770 23770 33 109 109 89/26/35G   198800967 198800967
24701 24701 2 109 109 89/26/21G   198800979 198800979
26029 26029 28 109 109 89/26/28G   198800974 198800974
27421 27421 26 109 109 89/26/29G   198800833 198800833
27599 27599 17 109 109 89/26/36G   198800969 198800969
28655 28655 13 109 109 89/26/09G   198801145 198801145
28963 28963 29 109 109 89/26/18G   198800975 198800975
29915 29915 20 109 109 89/26/23G   198800982 198800982
29992 29992 5 109 109 89/26/19G   198800796 198800796
30340 30340 14 109 109 89/26/13G   198801146 198801146
30908 30908 18 109 109 89/26/07G   198800824 198800824
31548 31548 37 109 109 89/26/14G   198800828 198800828
33017 33017 4 109 109 89/26/40G   198800510 198800510

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "Vorgaenge" (
            "nummer" INTEGER,
            "siz_nr" INTEGER,
            "beschlnr" TEXT,
            "Vermerk" TEXT,
            "laufnr_ges" INTEGER,
            FOREIGN KEY ("laufnr_ges") REFERENCES "Geschaefte"("laufnr_ges") ON DELETE CASCADE,
            FOREIGN KEY ("siz_nr") REFERENCES "Sitzungen"("siz_nr") ON DELETE CASCADE
        );
CREATE INDEX idx_Vorgaenge_vermerk ON "Vorgaenge" ("Vermerk");
CREATE INDEX idx_Vorgaenge_siz_nr ON "Vorgaenge" ("siz_nr");
CREATE INDEX idx_Vorgaenge_laufnr_ges ON "Vorgaenge" ("laufnr_ges");