Vorgaenge

32 rows where siz_nr = 389

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
1786 1786 5 389 389 97/26/01G SCR 199700151 199700151
4681 4681 25 389 389 97/26/21G ERL 198802272 198802272
5321 5321 26 389 389 97/26/03G STL an RR 199203109 199203109
6052 6052 21 389 389 97/26/19G ERL 199700138 199700138
7085 7085 11 389 389 97/26/14G ZUS 199700224 199700224
7508 7508 16 389 389 97/26/01Gl SCR 199700185 199700185
8680 8680 18 389 389 97/26/01Gk SCR 199700187 199700187
9079 9079 31 389 389 97/26/04G STL an RR 199203083 199203083
10160 10160 27 389 389 97/26/06G UEB an PETK 199700232 199700232
10478 10478 7 389 389 97/26/12G ZUA 199700217 199700217
10559 10559 32 389 389 97/26/09G GEW 199700241 199700241
10859 10859 29 389 389 97/26/16G ZUS 199700216 199700216
11029 11029 1 389 389 97/26/18G ERL 198802380 198802380
11872 11872 2 389 389 97/26/20G UEB an RR 199203945 199203945
12587 12587 19 389 389 97/26/17G ERL 199203030 199203030
13286 13286 22 389 389 97/26/01Gj SCR 199700139 199700139
13390 13390 4 389 389 97/26/15G ZUS 199203930 199203930
13526 13526 30 389 389 97/26/01Gi SCR 199700150 199700150
14594 14594 24 389 389 97/26/01Gh SCR 199700173 199700173
15050 15050 28 389 389 97/26/05G KTS 199203884 199203884
15323 15323 3 389 389 97/26/11G ZUA 199700104 199700104
16515 16515 14 389 389 97/26/01Gg SCR 199700183 199700183
18139 18139 10 389 389 97/26/10G ZUS 199700214 199700214
21479 21479 13 389 389 97/26/01Gf SCR 199700181 199700181
23450 23450 12 389 389 97/26/01Ge SCR 199700177 199700177
23868 23868 23 389 389 97/26/01Gd SCR 199700144 199700144
26202 26202 17 389 389 97/26/01Gc SCR 199700186 199700186
27512 27512 15 389 389 97/26/01Gb SCR 199700184 199700184
28783 28783 6 389 389 97/26/01Ga SCR 199700175 199700175
30508 30508 20 389 389 97/26/07G KTS 199700237 199700237
30727 30727 9 389 389 97/26/13G ZUS 199700215 199700215
32280 32280 8 389 389 97/26/08G BUE 199700220 199700220

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