Vorgaenge

24 rows where siz_nr = 213

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
2839 2839 15 213 213 92/26/12G   199202696 199202696
3724 3724 3 213 213 92/26/03G   198400520 198400520
6026 6026 9 213 213 92/26/14G   198802648 198802648
6789 6789 6 213 213 92/26/09G   198802655 198802655
7988 7988 2 213 213 92/26/02.08G STL an RR 198802478 198802478
9826 9826 14 213 213 92/26/10G   199202693 199202693
10840 10840 10 213 213 92/26/06G   199202695 199202695
13375 13375 21 213 213 92/26/02.05G   198802353 198802353
14745 14745 4 213 213 92/26/17G   198802452 198802452
15403 15403 24 213 213 92/26/02.01G   198802222 198802222
15795 15795 13 213 213 92/26/15G   199202692 199202692
15991 15991 16 213 213 92/26/02.06G STL an RR 198802377 198802377
17620 17620 7 213 213 92/26/11G   198802656 198802656
18895 18895 23 213 213 92/26/02.03G   198802237 198802237
19418 19418 17 213 213 92/26/02.10G STL an RR 198802477 198802477
19620 19620 19 213 213 92/27/02.09G   198802482 198802482
22224 22224 18 213 213 92/26/07G   198801401 198801401
24192 24192 22 213 213 92/26/05G   198400243 198400243
25640 25640 1 213 213 92/26/02.02G   198400455 198400455
27701 27701 11 213 213 92/26/02.04G STL an RR 198802355 198802355
27901 27901 5 213 213 92/26/18G   198802653 198802653
28048 28048 20 213 213 92/26/16G   198802537 198802537
30292 30292 8 213 213 92/26/02.07G STL an RR 198802426 198802426
30357 30357 12 213 213 92/26/04G STL an RR 198400464 198400464

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