Vorgaenge

33 rows where siz_nr = 295

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
1440 1440 16 295 295 94/45/26dG   199202650 199202650
3662 3662 28 295 295 94/45/20.02G UEB an RR 199202990 199202990
3994 3994 24 295 295 94/45/19G   199202365 199202365
4114 4114 22 295 295 94/45/20.07G UEB an RR 199203299 199203299
7230 7230 9 295 295 94/45/19Gb   199202286 199202286
8147 8147 23 295 295 94/45/20.08G   199203000 199203000
8232 8232 29 295 295 94/45/19Ga   199202363 199202363
8578 8578 6 295 295 94/45/22G   199202385 199202385
8901 8901 31 295 295 94/45/25G   198802476 198802476
10658 10658 5 295 295 94/45/16G   199202338 199202338
11610 11610 27 295 295 94/45/22Gf   199202362 199202362
13774 13774 1 295 295 94/45/18G STL an RR 199202350 199202350
15228 15228 13 295 295 94/45/26aG UEB an RR 199203443 199203443
17268 17268 4 295 295 94/45/16Ga   199201620 199201620
18197 18197 10 295 295 94/45/22Ge   199202283 199202283
18451 18451 8 295 295 94/45/17G   199203017 199203017
19728 19728 19 295 295 94/45/20.03G UEB an RR 199202995 199202995
20687 20687 14 295 295 94/45/26bG UEB an RR 199203028 199203028
23612 23612 7 295 295 94/45/22Gd   199202389 199202389
23651 23651 30 295 295 94/45/22Gc   199202386 199202386
23937 23937 32 295 295 94/45/20.06G   199202998 199202998
24086 24086 20 295 295 94/45/20.04G   199202996 199202996
26312 26312 15 295 295 94/45/26cG   199202508 199202508
26933 26933 18 295 295 94/45/20.09G UEB an RR 199203003 199203003
27172 27172 11 295 295 94/45/22Gb   199202284 199202284
27382 27382 12 295 295 94/45/22Ga   199202375 199202375
27619 27619 25 295 295 94/45/20.11G   199202623 199202623
27709 27709 17 295 295 94/45/20.10G UEB an RR 199203002 199203002
28294 28294 3 295 295 94/45/21G   199202817 199202817
28481 28481 33 295 295 94/45/23G   198802685 198802685
28499 28499 26 295 295 94/45/20.01G UEB an BGR 199202988 199202988
30192 30192 21 295 295 94/45/20.05G UEB an RR 199202997 199202997
30850 30850 2 295 295 94/45/24G   198802665 198802665

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