Vorgaenge

30 rows where siz_nr = 167

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
842 842 17 167 167 91/20/22aG   198801921 198801921
1039 1039 18 167 167 91/20/22bG   198801922 198801922
1232 1232 21 167 167 91/20/01G   198801739 198801739
2690 2690 3 167 167 91/20/14G   198801050 198801050
3793 3793 10 167 167 91/20/03G   198801894 198801894
4675 4675 6 167 167 91/20/21aG   198801659 198801659
5388 5388 26 167 167 91/20/19G   198801716 198801716
7880 7880 14 167 167 91/20/20G   198801902 198801902
9605 9605 20 167 167 91/20/01Ga   198801738 198801738
9672 9672 13 167 167 91/20/08G   198801900 198801900
12546 12546 9 167 167 91/20/21bG   198801883 198801883
13724 13724 30 167 167 91/20/22aGa   198400504 198400504
15106 15106 12 167 167 91/20/04Ga   198801899 198801899
16083 16083 16 167 167 91/20/12Ga   198801919 198801919
20844 20844 8 167 167 91/20/14Ga   198801548 198801548
21055 21055 22 167 167 91/20/05G   198801741 198801741
21217 21217 25 167 167 91/20/13G   198801909 198801909
21461 21461 27 167 167 91/20/15Ga   198801743 198801743
21482 21482 4 167 167 91/20/10aG   198801105 198801105
21833 21833 24 167 167 91/20/02Ga   198801908 198801908
23752 23752 15 167 167 91/20/20Gb   198801914 198801914
24272 24272 11 167 167 91/20/20Ga   198801896 198801896
24546 24546 2 167 167 91/20/16G   198801426 198801426
25007 25007 7 167 167 91/20/17G   198801425 198801425
26344 26344 29 167 167 91/20/10bG   198801175 198801175
27735 27735 5 167 167 91/20/06Ga   198802249 198802249
28003 28003 28 167 167 91/20/18Ga   198801321 198801321
28128 28128 1 167 167 91/20/07Ga STL an RR 198802244 198802244
31260 31260 23 167 167 91/20/09Ga   198801754 198801754
31452 31452 19 167 167 91/20/11Ga   198801911 198801911

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