Vorgaenge

17 rows where siz_nr = 75

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: laufnr_ges

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
1606 1606 15 75 75     198800652 198800652
4917 4917 5 75 75     198800542 198800542
5650 5650 12 75 75     198800673 198800673
9490 9490 11 75 75     198800672 198800672
13055 13055 13 75 75     198800649 198800649
14119 14119 17 75 75     198800654 198800654
14274 14274 18 75 75     198800674 198800674
15640 15640 16 75 75     198800653 198800653
16193 16193 3 75 75     198800651 198800651
20382 20382 2 75 75     198800507 198800507
20861 20861 7 75 75     198800665 198800665
24841 24841 8 75 75     198800665 198800665
25035 25035 1 75 75     198800655 198800655
28261 28261 4 75 75     198800656 198800656
29183 29183 10 75 75     198800671 198800671
29380 29380 9 75 75     198800670 198800670
30141 30141 14 75 75     198800650 198800650

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