Vorgaenge

36 rows where siz_nr = 224

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
630 630 13 224 224 92/46/11aG   199201877 199201877
1511 1511 9 224 224 92/46/06bG   199201667 199201667
2286 2286 21 224 224 92/46/06aG   198400490 198400490
2840 2840 19 224 224 92/46/06aGm   198000098 198000098
3544 3544 35 224 224 92/46/06aGl UEB an RR 198000097 198000097
4617 4617 20 224 224 92/46/06aGk   198000099 198000099
4723 4723 10 224 224 92/46/06aGj   198400459 198400459
5583 5583 31 224 224 92/46/03cG   198802358 198802358
8552 8552 26 224 224 92/46/08G   199201676 199201676
10443 10443 22 224 224 92/46/06aGi UEB an RR 198400491 198400491
11048 11048 5 224 224 92/46/01G   199202715 199202715
11581 11581 15 224 224 92/46/11dG   199201878 199201878
12557 12557 12 224 224 92/46/07G   199201719 199201719
13445 13445 34 224 224 92/46/11bG   199201888 199201888
14145 14145 11 224 224 92/46/06aGh   198400460 198400460
14312 14312 25 224 224 92/46/03aG   199201778 199201778
14503 14503 27 224 224 92/46/09G   199201677 199201677
15099 15099 36 224 224 92/46/07Gd   199201705 199201705
16547 16547 28 224 224 92/46/10G   199201678 199201678
18843 18843 14 224 224 92/46/11cG   199202004 199202004
19911 19911 24 224 224 92/46/03aGb   198802519 198802519
20517 20517 4 224 224 92/46/07Gc   199201716 199201716
21840 21840 6 224 224 92/46/03bG   198802568 198802568
22160 22160 29 224 224 92/46/05G   199201685 199201685
22223 22223 18 224 224 92/46/06aGg UEB an RR 198000096 198000096
24510 24510 33 224 224 92/46/07Gb   199202717 199202717
28215 28215 32 224 224 92/46/07Ga   199201704 199201704
28370 28370 30 224 224 92/46/06aGf   198400492 198400492
28761 28761 2 224 224 92/46/06aGe   198400493 198400493
29216 29216 23 224 224 92/46/06aGd   198400494 198400494
30252 30252 1 224 224 92/46/06aGc   198800562 198800562
30731 30731 16 224 224 92/46/03bGa   198802613 198802613
30748 30748 7 224 224 92/46/04G   198800547 198800547
31360 31360 17 224 224 92/46/06aGb   198400463 198400463
31455 31455 8 224 224 92/46/03aGa   199201615 199201615
31493 31493 3 224 224 92/46/06aGa   198400442 198400442

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