Vorgaenge

46 rows where siz_nr = 218

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
1155 1155 25 218 218 92/38/09bG   198802660 198802660
1535 1535 42 218 218 92/38/08bG   198802621 198802621
1885 1885 20 218 218 92/38/11eG   198802614 198802614
2114 2114 43 218 218 92/38/21G   198802643 198802643
2294 2294 34 218 218 92/38/05fG   198802535 198802535
2365 2365 44 218 218 92/38/08aG   198400527 198400527
2426 2426 24 218 218 92/38/22G   199201649 199201649
2716 2716 5 218 218 92/38/10G   198400246 198400246
4217 4217 3 218 218 92/38/18G   198400434 198400434
6240 6240 18 218 218 92/38/17G   199201644 199201644
6418 6418 36 218 218 92/38/11aG   198802521 198802521
6914 6914 12 218 218 92/38/15.2G   199201638 199201638
7298 7298 1 218 218 92/38/21.1G RÜR an RR 198802234 198802234
8066 8066 21 218 218 92/38/09cG   198802518 198802518
8184 8184 30 218 218 92/38/03G   198801373 198801373
8647 8647 9 218 218 92/38/05dG   198802572 198802572
10725 10725 22 218 218 92/38/09aG   198802520 198802520
11607 11607 2 218 218 92/38/09dG   198802570 198802570
12398 12398 29 218 218 92/38/05bG   198802544 198802544
14846 14846 14 218 218 92/38/15.3G   199201639 199201639
14970 14970 45 218 218 92/38/18Gb   198000095 198000095
15206 15206 27 218 218 92/38/23G   198802321 198802321
15317 15317 8 218 218 92/38/05gG   198802571 198802571
15798 15798 40 218 218 92/38/20G   198802455 198802455
15832 15832 10 218 218 92/38/18Ga   198802657 198802657
16280 16280 15 218 218 92/38/15.4G   199201640 199201640
16311 16311 16 218 218 92/38/04G   199201642 199201642
16809 16809 23 218 218 92/38/11dG   199201634 199201634
17030 17030 32 218 218 92/38/13G   199202702 199202702
17859 17859 39 218 218 92/38/22Gb   199201768 199201768
18269 18269 11 218 218 92/38/15.1G   199201637 199201637
19571 19571 26 218 218 92/38/21.2G RÜR an RR 198400519 198400519
20878 20878 33 218 218 92/38/14G   199201648 199201648
21252 21252 7 218 218 92/38/16G   198802690 198802690
21380 21380 17 218 218 92/38/19G   199201654 199201654
21400 21400 28 218 218 92/38/11bG   198802543 198802543
22635 22635 41 218 218 92/38/15.5G   199201641 199201641
24199 24199 6 218 218 92/38/06.1G STL an RR 198802232 198802232
25613 25613 46 218 218 92/38/07G   198400431 198400431
25802 25802 19 218 218 92/38/22Ga   199201658 199201658
26134 26134 38 218 218 92/38/11cG   198802588 198802588
26809 26809 35 218 218 92/38/05cG   198802536 198802536
28329 28329 13 218 218 92/38/12G   199201624 199201624
29190 29190 37 218 218 92/38/05aG   199201614 199201614
31638 31638 31 218 218 92/38/05eG   198802542 198802542
31702 31702 4 218 218 92/38/06.2G STL 198802245 198802245

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