Vorgaenge

30 rows where siz_nr = 533

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
2959 2959 14 533 533 01/19/10.4G MUE 200100105 200100105
5821 5821 30 533 533 01/19/10.6G MUE 200100107 200100107
7239 7239 29 533 533 01/19/15G ZUS 199701931 199701931
8341 8341 10 533 533 01/19/11.1G URS an RR 200100000 200100000
10986 10986 23 533 533 01/19/12.1G UEB an RR 200100034 200100034
11261 11261 3 533 533 01/19/01G ZUA an RR 200100018 200100018
11354 11354 26 533 533 01/19/05G UEB an REGK 200100070 200100070
11859 11859 28 533 533 01/19/03G UEB an PETK 200100082 200100082
13299 13299 15 533 533 01/19/10.5G MUE 200100106 200100106
13945 13945 18 533 533 01/19/10.9G MUE 200100111 200100111
15026 15026 17 533 533 01/19/10.8G MUE 200100109 200100109
15793 15793 21 533 533 01/19/12.4G UEB an RR 200100038 200100038
16819 16819 5 533 533 01/19/08G STL an FKOM 199700901 199700901
17071 17071 27 533 533 01/19/16G ZUS 200100032 200100032
18010 18010 7 533 533 01/19/07G STL an RR 199203780 199203780
18167 18167 6 533 533 01/19/07bG STL an RR 199202265 199202265
18489 18489 19 533 533 01/19/02G UEB an FKOM 200100068 200100068
18911 18911 22 533 533 01/19/12.2G NUE 200100033 200100033
20427 20427 25 533 533 01/19/14G ZUS 200100042 200100042
20477 20477 13 533 533 01/19/10.3G MUE 200100104 200100104
20849 20849 2 533 533 01/19/11.2G NUE 200100055 200100055
23555 23555 16 533 533 01/19/10.7G MUE 200100108 200100108
24864 24864 12 533 533 01/19/2G MUE an RR 200100102 200100102
27957 27957 9 533 533 01/19/07bGa STL an RR 198400464 198400464
29391 29391 1 533 533 01/19/06G KTS an RR 200100067 200100067
29623 29623 4 533 533 01/19/13G ZUS 200100045 200100045
31115 31115 11 533 533 01/19/1G MUE an RR 200100097 200100097
32170 32170 8 533 533 01/19/09G KTS 199701757 199701757
32461 32461 20 533 533 01/19/04G UEB an GSK 200100066 200100066
33150 33150 24 533 533 01/19/12.3G UEB an RR 200100037 200100037

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