Vorgaenge

19 rows where siz_nr = 199

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
2540 2540 19 199 199 92/07/29G   198802676 198802676
3884 3884 6 199 199 92/07/25G   198802174 198802174
5390 5390 15 199 199 92/07/28.08G   198802639 198802639
6114 6114 4 199 199 92/07/28.03G UEB an RR 198802630 198802630
7290 7290 11 199 199 92/07/28.04G   198802633 198802633
7336 7336 1 199 199 92/07/26aG   198400326 198400326
9705 9705 12 199 199 92/07/28.05G   198802634 198802634
15397 15397 16 199 199 92/07/28.09G   198802640 198802640
15850 15850 3 199 199 92/07/24G   198801863 198801863
16379 16379 2 199 199 92/07/28.01G UEB an RR 198802629 198802629
17683 17683 9 199 199 92/07/26bG   198802131 198802131
19655 19655 18 199 199 92/07/26aGb   198000076 198000076
21033 21033 14 199 199 92/07/28.07G   198802636 198802636
22343 22343 7 199 199 92/07/26aGa   198802104 198802104
25963 25963 10 199 199 92/07/28.02G   198802631 198802631
26472 26472 13 199 199 92/07/28.06G   198802635 198802635
28592 28592 17 199 199 92/07/27G URS an RR 198802632 198802632
30033 30033 5 199 199 92/07/22G   198801901 198801901
31306 31306 8 199 199 92/07/23G   198801843 198801843

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