Vorgaenge

24 rows where siz_nr = 131

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
856 856 6 131 131 90/11/11bG   198800908 198800908
1261 1261 14 131 131 90/11/G   198801497 198801497
1460 1460 9 131 131 90/11/07G   198802290 198802290
2412 2412 10 131 131 90/11/12G   198801293 198801293
2696 2696 21 131 131 90/11/08G   198801487 198801487
2750 2750 1 131 131 90/11/07Gf   198400496 198400496
3082 3082 12 131 131 90/11/13G   198800917 198800917
3958 3958 4 131 131 90/11/09G   198800874 198800874
6255 6255 7 131 131 90/11/11aG   198800916 198800916
8381 8381 20 131 131 90/11/01G   198801485 198801485
8995 8995 8 131 131 90/11/07Ge   198400466 198400466
9381 9381 19 131 131 90/11/02G   198801491 198801491
11064 11064 15 131 131 90/11/06G   198801498 198801498
11210 11210 5 131 131 90/11/04G   198801288 198801288
13313 13313 23 131 131 90/11/07Gd   198400497 198400497
14172 14172 22 131 131 90/11/07Gc   198801119 198801119
19578 19578 16 131 131 90/11/08Ga   198801499 198801499
19639 19639 18 131 131 90/11/15bG   198801512 198801512
20162 20162 2 131 131 90/11/07Gb   198000093 198000093
21764 21764 13 131 131 90/11/05G   198801496 198801496
23414 23414 11 131 131 90/11/03G   198400434 198400434
24349 24349 3 131 131 90/11/10G   198801042 198801042
30388 30388 17 131 131 90/11/15aG   198801511 198801511
31622 31622 24 131 131 90/11/07Ga   198802254 198802254

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