Vorgaenge

24 rows where siz_nr = 535

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
1628 1628 7 535 535 01/23/11G ZUS 200100068 200100068
5589 5589 1 535 535 01/23/05bG KTS 199701623 199701623
6256 6256 5 535 535 01/23/18G ERL 199203651 199203651
9827 9827 23 535 535 01/23/07G ZUS 200100044 200100044
10110 10110 13 535 535 01/23/16G MUE 200100130 200100130
10428 10428 15 535 535 01/23/12G ZUS 200100052 200100052
13110 13110 18 535 535 01/23/17.02G NUE 200100078 200100078
16814 16814 11 535 535 01/23/17.01G NUE 200100069 200100069
17007 17007 3 535 535 01/23/10G ZUS 200100029 200100029
17453 17453 2 535 535 01/23/16Ga MUE 200100131 200100131
18148 18148 20 535 535 01/23/17.04G UEB an RR 200100090 200100090
19231 19231 4 535 535 01/23/04G STL an GSK 199700156 199700156
19561 19561 19 535 535 01/23/17.03G UEB an RR 200100089 200100089
21000 21000 22 535 535 01/23/09G ZUA 200100019 200100019
21543 21543 17 535 535 01/23/19G UEB an RR 199701864 199701864
21903 21903 24 535 535 01/23/13G ZUS 200100015 200100015
24210 24210 21 535 535 01/23/15G ZUS 199701930 199701930
24290 24290 8 535 535 01/23/14G ZUS 200100066 200100066
25509 25509 9 535 535 01/23/02G UEB an BRK 200100113 200100113
26915 26915 10 535 535 01/23/20G ZUS 200100125 200100125
28733 28733 12 535 535 01/23/03G KTS 200100122 200100122
29006 29006 14 535 535 01/23/08G ZUS 200100048 200100048
31794 31794 6 535 535 01/23/06G UEB an GSK 199701810 199701810
33041 33041 16 535 535 01/23/05a KTS 199701756 199701756

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