Vorgaenge

31 rows where siz_nr = 128

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
2905 2905 13 128 128 90/07/11aG   198801107 198801107
4736 4736 29 128 128 90/07/07G   198400446 198400446
4807 4807 9 128 128 90/07/01   198801266 198801266
5201 5201 20 128 128 90/07/18bG   198801474 198801474
5366 5366 7 128 128 90/07/01b   198801247 198801247
6895 6895 16 128 128 90/07/04G   198801450 198801450
9269 9269 26 128 128 90/07/19G   198801436 198801436
10226 10226 2 128 128 90/07/20G   198800922 198800922
10858 10858 31 128 128 90/07/06G STL an RR 198400500 198400500
11043 11043 27 128 128 90/07/08G   198801444 198801444
11182 11182 30 128 128 90/07/06Gd STL an RR 198400498 198400498
13301 13301 10 128 128 90/07/17G   198800915 198800915
14337 14337 23 128 128 90/07/18cG   198801475 198801475
15785 15785 15 128 128 90/07/05G STL an RR 198000063 198000063
15856 15856 8 128 128 90/07/01a   198801251 198801251
16471 16471 4 128 128 90/07/06Gc   198802255 198802255
16585 16585 18 128 128 90/07/   198801461 198801461
17466 17466 24 128 128 90/07/16G   198800899 198800899
20017 20017 21 128 128 90/07/02G   198801471 198801471
20900 20900 12 128 128 90/07/11bG   198800722 198800722
22055 22055 17 128 128 90/07/13G   198801457 198801457
22492 22492 14 128 128 90/07/03G   198400421 198400421
23060 23060 22 128 128 90/07/02Ga   198801454 198801454
23293 23293 25 128 128 90/07/09G   198800924 198800924
24954 24954 11 128 128 90/07/11cG   198800732 198800732
27013 27013 3 128 128 90/07/06Gb STL an RR 198400501 198400501
30854 30854 1 128 128 90/07/06Ga STL an RR 198400499 198400499
30889 30889 19 128 128 90/07/18aG   198801473 198801473
31065 31065 6 128 128 90/07/14G   198801286 198801286
31789 31789 28 128 128 90/07/12G   198801458 198801458
33135 33135 5 128 128 90/07/15G   198800921 198800921

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