Vorgaenge

36 rows where siz_nr = 319

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
1280 1280 3 319 319 95/26/19G UEB an STPO 198400451 198400451
3546 3546 22 319 319 95/26/09G UEB an GVK 199203148 199203148
3725 3725 29 319 319 95/26/02G   199202578 199202578
4311 4311 16 319 319 95/26/05G STL an RR 199202557 199202557
4804 4804 28 319 319 95/26/16G   199202594 199202594
4854 4854 35 319 319 95/26/07G STL an RR 199202565 199202565
5765 5765 26 319 319 95/26/11G   199202556 199202556
6597 6597 20 319 319 95/26/18G   199203145 199203145
9009 9009 34 319 319 95/26/25G STL an THEK 199202253 199202253
9506 9506 18 319 319 95/26/20G   199202495 199202495
10031 10031 25 319 319 95/26/13G   199203149 199203149
10228 10228 17 319 319 95/26/23G ZUS 199202593 199202593
12439 12439 12 319 319 95/26/19Gg UEB an STPO 198802435 198802435
12480 12480 8 319 319 95/26/06G STL an RR 199202558 199202558
13643 13643 6 319 319 95/26/19Gf UEB an STPO 198802315 198802315
15942 15942 36 319 319 95/26/19Ge UEB an STPO 198000086 198000086
16001 16001 31 319 319 95/26/10G   199202600 199202600
16927 16927 10 319 319 95/26/19Gd UEB an STPO 198400489 198400489
17672 17672 14 319 319 95/26/14G   199202546 199202546
17909 17909 19 319 319 95/26/19Gc UEB an STPO 199202561 199202561
18195 18195 32 319 319 95/26/22G   199202534 199202534
20289 20289 27 319 319 95/26/24aG   199202571 199202571
20992 20992 13 319 319 95/26/07Gc STL an RR 199202564 199202564
21224 21224 15 319 319 95/26/25Gc   198802582 198802582
21362 21362 7 319 319 95/26/19Gb UEB an STPO 199202562 199202562
23439 23439 11 319 319 95/26/25Gb   199202192 199202192
24884 24884 9 319 319 95/26/07Gb STL an RR 199202566 199202566
25513 25513 4 319 319 95/26/25Ga   198000084 198000084
26244 26244 30 319 319 95/26/24bG   199203017 199203017
28741 28741 21 319 319 95/26/21G   199203146 199203146
28927 28927 5 319 319 95/26/19Ga UEB an STPO 198802256 198802256
29731 29731 2 319 319 95/26/07Ga STL an RR 199202567 199202567
30481 30481 24 319 319 95/26/12G   199203150 199203150
31551 31551 1 319 319 95/ UEB an STPO 199203894 199203894
31761 31761 23 319 319 95/26/04G UEB an GVK 199203147 199203147
32203 32203 33 319 319 95/26/17G   199202544 199202544

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