Vorgaenge

20 rows where siz_nr = 511

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
4968 4968 15 511 511 00/42/39G ERL 199700464 199700464
6331 6331 5 511 511 00/42/30G ZUS 199701730 199701730
6620 6620 1 511 511 00/42/38G UEB an RR 199701579 199701579
7738 7738 12 511 511 00/42/37G ERL 199203567 199203567
10740 10740 11 511 511 00/42/25G ZUS 199701718 199701718
17136 17136 18 511 511 00/42/36G ERL 199203581 199203581
17415 17415 7 511 511 00/42/28G ZUS 199701744 199701744
18813 18813 4 511 511 00/42/27G ZUA 199701728 199701728
18926 18926 6 511 511 00/42/31G ZUS 199701729 199701729
19649 19649 19 511 511 00/42/35G ERL 199203620 199203620
21044 21044 16 511 511 00/42/32G ZUS 199701735 199701735
22009 22009 14 511 511 00/42/40G ERL 199700670 199700670
24692 24692 3 511 511 00/42/22G ZUS 199701706 199701706
28007 28007 9 511 511 00/42/41G UEB an RR 199701800 199701800
28179 28179 10 511 511 00/42/29G UEB an UVEK 199700701 199700701
28796 28796 20 511 511 00/42/23G KTS 199701658 199701658
29662 29662 8 511 511 00/42/26G ZUE 199701734 199701734
30180 30180 13 511 511 00/42/33G STL an RR 199701297 199701297
30536 30536 2 511 511 00/42/34G ERL 199701050 199701050
32710 32710 17 511 511 00/42/24G ZUS 199701660 199701660

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