Vorgaenge

19 rows where siz_nr = 437

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
2872 2872 8 437 437 98/42/36G ERL 199203431 199203431
5852 5852 15 437 437 98/42/38bG UEB an RR 199700832 199700832
10030 10030 11 437 437 98/42/31G ERL 199203566 199203566
11087 11087 5 437 437 98/42/29G ERL 199203480 199203480
12070 12070 6 437 437 98/42/34Ga ERL 199203509 199203509
15251 15251 9 437 437 98/42/26G ZUS 199700699 199700699
16361 16361 4 437 437 98/42/24Ga ZUS 199700783 199700783
18633 18633 17 437 437 98/42/28G ZUS 199700557 199700557
21112 21112 1 437 437 98/42/23aGa KTS 199700722 199700722
22158 22158 7 437 437 98/42/37Ga ERL 199203513 199203513
22645 22645 19 437 437 98/42/21G ZUS 199700735 199700735
22733 22733 2 437 437 98/42/22Ga ZUS 199700766 199700766
26743 26743 16 437 437 98/42/38cG UEB an RR 199700833 199700833
30120 30120 3 437 437 98/42/27Ga NEI 199700753 199700753
30361 30361 13 437 437 98/42/38dG UEB an RR 199700834 199700834
31391 31391 10 437 437 98/42/30Ga ERL 199203451 199203451
32463 32463 14 437 437 98/42/38aG UEB an RR 199700831 199700831
32982 32982 18 437 437 98/42/25Ga ZUS 199700738 199700738
33039 33039 12 437 437 98/42/23bGa KTS 199700256 199700256

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