Vorgaenge

16 rows where siz_nr = 563

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
1010 1010 12 563 563 02/11/24.01G URS an RR 200100416 200100416
1075 1075 4 563 563 02/11/23.01G ERL 199701652 199701652
2361 2361 15 563 563 02/11/23.02G ERL 200100142 200100142
7160 7160 10 563 563 02/11/20G ERL 199701540 199701540
8555 8555 9 563 563 02/11/17Ga ERL 200100124 200100124
9801 9801 8 563 563 02/11/26dG UEB an RR 200100506 200100506
14157 14157 1 563 563 02/11/26bG UEB an RR 200100504 200100504
16577 16577 5 563 563 02/11/23.03G NUE 200100225 200100225
18914 18914 3 563 563 02/11/22G ERL 199701691 199701691
20383 20383 11 563 563 02/11/25.01G UEB an RR 200100402 200100402
24053 24053 2 563 563 02/11/19G ERL 199701582 199701582
24757 24757 6 563 563 02/11/26aG UEB an RR 200100503 200100503
32081 32081 14 563 563 02/11/24.02G NUE 200100418 200100418
32440 32440 16 563 563 02/11/21G ERL 199203062 199203062
32593 32593 13 563 563 02/11/25.02G UEB an RR 200100415 200100415
32742 32742 7 563 563 02/11/26cG UEB an RR 200100505 200100505

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