Vorgaenge

36 rows where siz_nr = 381

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
269 269 30 381 381 97/15/42G SCR 199700097 199700097
2523 2523 2 381 381 97/15/43dG UEB an RR 199700166 199700166
3475 3475 20 381 381 97/15/43bG UEB an RR 199700164 199700164
4539 4539 31 381 381 97/15/43aG UEB an RR 199700163 199700163
4953 4953 9 381 381 97/15/37G ERL 198802540 198802540
5500 5500 3 381 381 97/15/37Gi ERL 198000108 198000108
5684 5684 28 381 381 97/15/42Gk SCR 199700092 199700092
7397 7397 11 381 381 97/15/41.02G UEB an RR 199700036 199700036
8025 8025 24 381 381 97/15/42Gj SCR 199700078 199700078
8110 8110 5 381 381 97/15/37Gh ERL 199202528 199202528
9057 9057 18 381 381 97/15/42Gi SCR 199700075 199700075
10243 10243 29 381 381 97/15/42Gh SCR 199700096 199700096
11671 11671 8 381 381 97/15/37Gg ERL 198802495 198802495
13504 13504 33 381 381 97/15/42Gg SCR 199700042 199700042
14826 14826 1 381 381 97/15/37Gf ERL 198802265 198802265
16356 16356 23 381 381 97/15/42Gf SCR 199700077 199700077
16944 16944 7 381 381 97/15/37Ge ERL 199202526 199202526
17314 17314 35 381 381 97/15/42Ge MUE 199700118 199700118
17584 17584 37 381 381 97/15/37Gd ERL 199202529 199202529
18331 18331 36 381 381 97/15/42Gd SCR 199700079 199700079
18465 18465 25 381 381 97/15/38G RÜR an RR 199203427 199203427
18856 18856 21 381 381 97/15/43cG UEB an RR 199700165 199700165
22130 22130 12 381 381 97/15/41.05G UEB an RR 199700039 199700039
22367 22367 14 381 381 97/15/41.03G UEB an RR 199700041 199700041
23200 23200 26 381 381 97/15/37Gc ZUA 199202525 199202525
24952 24952 13 381 381 97/15/41.04G UEB an RR 199700040 199700040
25656 25656 27 381 381 97/15/42Gc SCR 199700091 199700091
28026 28026 16 381 381 97/15/41.06G UEB an RR 199700044 199700044
28083 28083 22 381 381 97/15/42Gb SCR 199700089 199700089
28401 28401 17 381 381 97/15/40G URS an RR 199700045 199700045
28581 28581 6 381 381 97/15/37Gb ERL 198802411 198802411
29030 29030 19 381 381 97/15/43eG UEB an RR 199700167 199700167
29855 29855 15 381 381 97/15/41.07G UEB an ENEK 199700043 199700043
30169 30169 32 381 381 97/15/37Ga ERL 199202527 199202527
30335 30335 34 381 381 97/15/42Ga SCR 199700094 199700094
31177 31177 10 381 381 97/15/41.01G UEB an RR 199700033 199700033

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