Vorgaenge

50 rows where siz_nr = 459

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
1813 1813 2 459 459 99/20/29.01G UEB an RR 199701050 199701050
2304 2304 28 459 459 99/20/28G MUE 199701111 199701111
2886 2886 49 459 459 99/20/15G ZUS 199700023 199700023
2945 2945 24 459 459 99/20/30G ERL 199700975 199700975
3393 3393 15 459 459 99/20/31G SCR 199701094 199701094
5059 5059 41 459 459 99/20/31Gi SCR 199701096 199701096
5638 5638 33 459 459 99/20/28Gi MUE 199701118 199701118
6275 6275 1 459 459 99/20/20G STL an RR 199202907 199202907
6613 6613 23 459 459 99/20/28Gh MUE 199701107 199701107
7403 7403 19 459 459 99/20/27G ERL 199700044 199700044
7915 7915 16 459 459 99/20/31Gh SCR 199701097 199701097
8460 8460 43 459 459 99/20/28Gg MUE 199701138 199701138
9742 9742 39 459 459 99/20/23G ERL 199700667 199700667
10328 10328 7 459 459 99/20/29.02G UEB an RR 199701053 199701053
10390 10390 12 459 459 99/20/03G UEB an PETK 199701079 199701079
10896 10896 25 459 459 99/20/08G KTS 199700607 199700607
11120 11120 26 459 459 99/20/25G ERL 199203881 199203881
11819 11819 38 459 459 99/20/24G UEB an RR 199700900 199700900
11967 11967 40 459 459 99/20/31Gg SCR 199701089 199701089
15002 15002 27 459 459 99/20/18G ERL 199700122 199700122
16011 16011 3 459 459 99/20/17G ZUS 199701112 199701112
16346 16346 34 459 459 99/20/28Gf MUE 199701124 199701124
18785 18785 44 459 459 99/20/22G ERL 199700262 199700262
19367 19367 4 459 459 99/20/21G ERL 198802538 198802538
20275 20275 22 459 459 99/20/28Ge MUE 199701105 199701105
20325 20325 46 459 459 99/20/04G UEB an PETK 199701091 199701091
20469 20469 50 459 459 99/20/16G ZUS 199701099 199701099
21684 21684 45 459 459 99/20/26G ERL 199203924 199203924
21965 21965 35 459 459 99/20/14G GEW 199701125 199701125
22540 22540 8 459 459 99/20/28.03G NUE 199701054 199701054
23008 23008 30 459 459 99/20/02G KTS 199701119 199701119
23173 23173 13 459 459 99/20/31Gf SCR 199701081 199701081
24682 24682 10 459 459 99/20/31Ge SCR 199701074 199701074
26054 26054 14 459 459 99/20/31Gd SCR 199701092 199701092
26624 26624 48 459 459 99/20/06G STL an RR 199203006 199203006
26708 26708 20 459 459 99/20/12G KTS 199700512 199700512
26759 26759 6 459 459 99/20/09G KTS 199701051 199701051
27836 27836 31 459 459 99/20/28Gd MUE 199701121 199701121
27977 27977 18 459 459 99/20/19G ERL 199700001 199700001
28110 28110 47 459 459 99/20/28.04G UEB an RR 199701062 199701062
28847 28847 32 459 459 99/20/11G KTS 199701120 199701120
29548 29548 21 459 459 99/20/07G STL an RR 199203662 199203662
30176 30176 36 459 459 99/20/28Gc MUE 199701141 199701141
30308 30308 37 459 459 99/20/13G KTS 199701130 199701130
30440 30440 29 459 459 99/20/28Gb MUE 199701117 199701117
30664 30664 17 459 459 99/20/31Gc SCR 199701098 199701098
30759 30759 9 459 459 99/20/31Gb SCR 199701069 199701069
31906 31906 42 459 459 99/20/28Ga MUE 199701131 199701131
32302 32302 5 459 459 99/20/10G KTS 199701051 199701051
32745 32745 11 459 459 99/20/31Ga SCR 199701076 199701076

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