Vorgaenge

54 rows where siz_nr = 456

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
368 368 43 456 456 99/15/24G ERL 199700318 199700318
649 649 4 456 456 99/15/17G UEB an TAGK 198802377 198802377
1438 1438 38 456 456 99/15/14G RÜR an BGR 199700821 199700821
1769 1769 33 456 456 99/15/20.09G UEB an STEK 199701029 199701029
1956 1956 44 456 456 99/15/14Gd RÜR an BGR 199700903 199700903
2629 2629 25 456 456 99/15/20.03G UEB an RR 199701017 199701017
2932 2932 5 456 456 99/15/05G KTS 199701067 199701067
3842 3842 39 456 456 99/15/13G GEW 199700993 199700993
4446 4446 1 456 456 99/15/17Gg UEB an TAGK 199202936 199202936
6153 6153 23 456 456 99/15/14Gc RÜR an BGR 199700764 199700764
6389 6389 29 456 456 99/15/20.04G UEB an RR 199701019 199701019
6820 6820 40 456 456 99/15/20.01G NUE 199700987 199700987
7340 7340 28 456 456 99/15/20.06G UEB an RR 199701021 199701021
7356 7356 48 456 456 99/15/11G KTS 199701080 199701080
7367 7367 11 456 456 99/15/08G KTS 199701073 199701073
7430 7430 53 456 456 99/15/21G SCR 199701018 199701018
7466 7466 20 456 456 99/15/18G MUE 199701068 199701068
8579 8579 35 456 456 99/15/21Gc SCR 199701046 199701046
8804 8804 37 456 456 99/15/18Gd MUE 199701049 199701049
9262 9262 45 456 456 99/15/26G ERL 199203206 199203206
9685 9685 27 456 456 99/15/20.05G UEB an RR 199701020 199701020
9903 9903 41 456 456 99/15/19.01G NUE 199700986 199700986
9947 9947 8 456 456 99/15/01G BUE 199701065 199701065
10309 10309 6 456 456 99/15/17Gf UEB an TAGK 199701028 199701028
10754 10754 15 456 456 99/15/18Gc MUE 199701072 199701072
11290 11290 16 456 456 99/15/12G GEW 199701087 199701087
12980 12980 50 456 456 99/15/23G ZUS 199701063 199701063
13077 13077 42 456 456 99/15/14Gb RÜR an BGR 199700981 199700981
14107 14107 7 456 456 99/15/15G ZUS 199701025 199701025
14645 14645 49 456 456 99/15/17Ge UEB an TAGK 199202093 199202093
15862 15862 17 456 456 99/15/13Ga GEW 199701088 199701088
17748 17748 14 456 456 99/15/02G KTS 199701070 199701070
20967 20967 12 456 456 99/15/09G KTS 199701077 199701077
21149 21149 13 456 456 99/15/17Gd UEB an TAGK 199203944 199203944
21221 21221 47 456 456 99/15/07G KTS 199700360 199700360
23550 23550 54 456 456 99/15/17Gc UEB an TAGK 198802355 198802355
24079 24079 3 456 456 99/15/17Gb UEB an TAGK 198802477 198802477
24926 24926 31 456 456 99/15/20.07G UEB an RR 199701052 199701052
25890 25890 52 456 456 99/15/17Ga UEB an TAGK 198802478 198802478
26102 26102 19 456 456 99/15/14Ga RÜR an BGR 199701060 199701060
26616 26616 10 456 456 99/14/16G ZUA 199701066 199701066
27122 27122 9 456 456 99/15/22G ZUS 199701064 199701064
27633 27633 2 456 456 99/15/03G KTS 199701043 199701043
28906 28906 32 456 456 99/15/20.08G UEB an RR 199701031 199701031
29009 29009 22 456 456 99/15/25G ERL 199203670 199203670
29271 29271 34 456 456 99/15/21Gb SCR 199701041 199701041
29513 29513 21 456 456 99/15/06G STL an GSK 199700156 199700156
29528 29528 30 456 456 99/15/21Ga SCR 199701026 199701026
29632 29632 51 456 456 99/15/10G KTS 199700779 199700779
30064 30064 26 456 456 99/15/19.02G URS an RR 199701022 199701022
30746 30746 24 456 456 99/15/20.02G NUE 199701012 199701012
32149 32149 18 456 456 99/15/18Gb MUE 199701090 199701090
32588 32588 46 456 456 99/15/18Ga MUE 199701075 199701075
32741 32741 36 456 456 99/15/04G UEB an PETK 199701048 199701048

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