Vorgaenge

20 rows where siz_nr = 88

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: laufnr_ges

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
542 542 6 88 88 89/01/12G   198800582 198800582
824 824 19 88 88 89/01/04G   198800776 198800776
2697 2697 13 88 88 89/01/07aG   198400247 198400247
3370 3370 10 88 88 89/01/15G   198800573 198800573
6176 6176 11 88 88 89/01/05G   198800611 198800611
6300 6300 12 88 88 89/01/14G   198800613 198800613
8257 8257 5 88 88 89/01/13cG   198800929 198800929
9479 9479 4 88 88 89/01/13bG   198800928 198800928
10600 10600 7 88 88 89/01/09G   198800591 198800591
11810 11810 20 88 88 89/01/01.bG   198800783 198800783
12025 12025 8 88 88 89/01/08G   198800591 198800591
15073 15073 18 88 88 89/01/11G   198800493 198800493
16566 16566 14 88 88 89/01/06G   198800620 198800620
20160 20160 2 88 88 89/01/10G   198400245 198400245
20253 20253 16 88 88 89/01/01.aG   198800770 198800770
20598 20598 3 88 88 89/01/13aG   198800927 198800927
21160 21160 15 88 88 89/01/07dG   198800683 198800683
22748 22748 1 88 88 89/01/07bG   198400197 198400197
25015 25015 9 88 88 89/01/07cG   198800723 198800723
32006 32006 17 88 88 89/01/13dG   198800930 198800930

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