Vorgaenge

19 rows where siz_nr = 200

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
1027 1027 9 200 200 92/10/03G   198802141 198802141
1446 1446 17 200 200 92/10/04cG   198801690 198801690
1749 1749 7 200 200 92/10/10G   198802201 198802201
2156 2156 14 200 200 92/10/08G   198801875 198801875
3734 3734 13 200 200 92/10/02G   198400462 198400462
6053 6053 18 200 200 92/10/14aG   198802680 198802680
10973 10973 16 200 200 92/10/04bG   198802124 198802124
14175 14175 12 200 200 92/10/13bG   198802072 198802072
15637 15637 1 200 200 92/10/06G   198400223 198400223
16116 16116 4 200 200 92/10/04aG   198801213 198801213
16967 16967 5 200 200 92/10/10Gb   198802199 198802199
21862 21862 2 200 200 92/10/12G   198000077 198000077
22373 22373 8 200 200 92/10/10Ga   198802208 198802208
25378 25378 3 200 200 92/10/11G   198400255 198400255
28346 28346 19 200 200 92/10/09G   198801187 198801187
31679 31679 6 200 200 92/10/13aG   198802178 198802178
31707 31707 11 200 200 92/10/14cG   198802682 198802682
32086 32086 15 200 200 92/10/07G   198802174 198802174
32921 32921 10 200 200 92/10/14bG   198802681 198802681

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