Vorgaenge

17 rows where siz_nr = 97

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: laufnr_ges

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
1774 1774 4 97 97 89/10/15.01G   198801037 198801037
4286 4286 12 97 97 89/10/09G   198801004 198801004
4563 4563 7 97 97 89/10/01.01G   198800988 198800988
4777 4777 11 97 97 89/10/03G   198801007 198801007
8238 8238 13 97 97 89/10/15.03G   198801039 198801039
10720 10720 8 97 97 89/10/02G   198800995 198800995
16022 16022 6 97 97 89/10/13G   198800621 198800621
17438 17438 2 97 97 89/10/06.01G   198800504 198800504
19491 19491 3 97 97 89/10/01.03G SCR 198801020 198801020
20627 20627 15 97 97 89/10/10G   198800622 198800622
20816 20816 17 97 97 89/10/01.02G   198801018 198801018
21465 21465 16 97 97 89/10/12G   198800553 198800553
23295 23295 9 97 97 89/10/08G   198801003 198801003
25042 25042 10 97 97 89/10/04G   198801006 198801006
25410 25410 5 97 97 89/10/05G   198400129 198400129
27765 27765 14 97 97 89/10/11G   198800622 198800622
29606 29606 1 97 97 89/10/15.02G   198801038 198801038

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