Vorgaenge

27 rows where siz_nr = 85

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: laufnr_ges

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
2234 2234 6 85 85 88/49/01G   198800753 198800753
3266 3266 17 85 85 88/49/09dG   198400181 198400181
3414 3414 4 85 85 88/49/01Gb   198800750 198800750
3721 3721 10 85 85 88/49/14G   198800767 198800767
4054 4054 13 85 85 88/49/20G   198800564 198800564
4509 4509 3 85 85 88/49/03G   198800749 198800749
5088 5088 22 85 85 88/49/08G   198800599 198800599
5196 5196 24 85 85 88/49/04G   198800765 198800765
6559 6559 1 85 85 88/49/21G   198800583 198800583
7683 7683 19 85 85 88/49/19G   198400191 198400191
7914 7914 21 85 85 88/49/09aG   198400249 198400249
8700 8700 9 85 85 88/49/11G   198800764 198800764
10727 10727 26 85 85 88/49/17G   198400133 198400133
15606 15606 20 85 85 88/49/06G   198400472 198400472
17836 17836 23 85 85 88/49/16G   198800606 198800606
18983 18983 7 85 85 88/49/10G   198800610 198800610
20891 20891 18 85 85 88/49/19.01G   198400191 198400191
21289 21289 5 85 85 88/49/01Ga   198800751 198800751
22076 22076 12 85 85 88/49/18G   198800769 198800769
22943 22943 2 85 85 88/49/09cG   198400148 198400148
25795 25795 14 85 85 88/49/09eG   198400171 198400171
26006 26006 8 85 85 88/49/22G   198800763 198800763
26595 26595 11 85 85 88/49/15G   198800768 198800768
29184 29184 25 85 85 88/49/13G   198800766 198800766
30076 30076 27 85 85 88/49/12G   198800591 198800591
30460 30460 15 85 85 88/49/09bG   198800489 198800489
32369 32369 16 85 85 88/49/09bGa   198400179 198400179

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