Vorgaenge

17 rows where siz_nr = 538

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk, laufnr_ges

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
5521 5521 13 538 538 01/26/14G ZUS 200100070 200100070
5911 5911 10 538 538 01/26/05G UEB an FKOM 200100144 200100144
6640 6640 8 538 538 01/26/02G BUE 200100127 200100127
7539 7539 15 538 538 01/26/09G KTS 199701665 199701665
8659 8659 12 538 538 01/26/11G   199701541 199701541
9217 9217 6 538 538 01/26/03G UEB an FKOM 200100128 200100128
9870 9870 7 538 538 01/26/04G UEB an JSSK 200100129 200100129
12961 12961 2 538 538 01/26/12G KTS 200100151 200100151
20605 20605 9 538 538 01/26/13G ZUS 200100138 200100138
23296 23296 4 538 538 01/26/07cG STL an RR 199700040 199700040
23785 23785 3 538 538 01/26/13cG ZUS 200100134 200100134
23981 23981 11 538 538 01/26/08G KTS 200100145 200100145
28418 28418 14 538 538 01/26/10G KTS 199701624 199701624
28482 28482 16 538 538 01/26/06G KTS 200100156 200100156
28506 28506 17 538 538 01/26/13bG ZUS 200100134 200100134
31733 31733 1 538 538 01/26/07aG   199700982 199700982
32631 32631 5 538 538 01/26/07bG STL an RR 199202907 199202907

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