Vorgaenge

33 rows where siz_nr = 341

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
750 750 14 341 341 96/07/05aG KTS 199203443 199203443
1172 1172 2 341 341 96/07/01G RÜR an RR 199203438 199203438
1969 1969 32 341 341 96/07/09G ZUS 199203382 199203382
2950 2950 7 341 341 96/07/14G UEB an RPLK 199202051 199202051
3062 3062 17 341 341 96/07/15G MUE 199203452 199203452
3398 3398 3 341 341 96/07/16G ZUS 199202010 199202010
5402 5402 10 341 341 96/07/07G KTS 199203142 199203142
5929 5929 28 341 341 96/07/14Gf UEB an RPLK 199203066 199203066
6093 6093 11 341 341 96/07/05cG KTS 199203445 199203445
9189 9189 18 341 341 96/07/17G ERL 199202789 199202789
10149 10149 24 341 341 96/07/14Ge UEB an RPLK 199203324 199203324
10511 10511 29 341 341 96/07/15Gc MUE 199203470 199203470
10935 10935 12 341 341 96/07/20G ERL 199202845 199202845
11755 11755 4 341 341 96/07/18G ERL 199202825 199202825
12116 12116 33 341 341 96/07/21G ERL 199202934 199202934
12627 12627 6 341 341 96/07/19G ERL 198802428 198802428
12914 12914 27 341 341 96/07/08G BUE 199203380 199203380
13188 13188 31 341 341 96/07/05bG KTS 199203441 199203441
13758 13758 21 341 341 96/07/11G GEW 199203458 199203458
14640 14640 1 341 341 96/07/01Ga RÜR an RR 198802307 198802307
16484 16484 8 341 341 96/07/14Gd UEB an RPLK 199202804 199202804
21367 21367 15 341 341 96/07/02G KTS 199203449 199203449
22704 22704 30 341 341 96/07/14Gc UEB an RPLK 199203308 199203308
23089 23089 13 341 341 96/07/15Gb MUE 199203429 199203429
25605 25605 26 341 341 96/07/06G KTS 199203461 199203461
25633 25633 23 341 341 96/07/13G GEW 199203460 199203460
25730 25730 5 341 341 96/07/14Gb UEB an RPLK 198802423 198802423
26249 26249 20 341 341 96/07/10G GEW 199203457 199203457
26776 26776 16 341 341 96/07/03G UEB an GVK 199203450 199203450
27973 27973 25 341 341 96/07/04G KTS 199203424 199203424
29453 29453 22 341 341 96/07/12G GEW 199203459 199203459
30015 30015 9 341 341 96/07/14Ga UEB an RPLK 198802462 198802462
31017 31017 19 341 341 96/07/15Ga MUE 199203453 199203453

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