Vorgaenge

34 rows where siz_nr = 416

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
1124 1124 20 416 416 98/07/16G SCR 199700494 199700494
1737 1737 12 416 416 98/07/16Gi MUE 199700525 199700525
2868 2868 34 416 416 98/07/21G ERL 199700263 199700263
4479 4479 1 416 416 98/07/22G ERL 198802390 198802390
5036 5036 14 416 416 98/07/28G STL an RR 199203670 199203670
6236 6236 18 416 416 98/07/29G UEB an RR 199700540 199700540
6310 6310 25 416 416 98/07/20.02G UEB an RR 199700458 199700458
6368 6368 26 416 416 98/07/20.05G UEB an RR 199700464 199700464
6692 6692 22 416 416 98/07/16Gh SCR 199700504 199700504
7805 7805 5 416 416 98/07/12G ZUA 199700418 199700418
8260 8260 2 416 416 98/07/13G ZUS 199700465 199700465
10743 10743 19 416 416 98/07/26G ERL 199203542 199203542
12092 12092 13 416 416 98/07/17G STL an RR 199700160 199700160
12216 12216 23 416 416 98/07/14G ZUS 199700499 199700499
12851 12851 6 416 416 98/07/11G ZUA 199700452 199700452
13826 13826 16 416 416 98/07/18G ZUS 199700498 199700498
19854 19854 9 416 416 98/07/17Ga STL an RR 199203925 199203925
20089 20089 31 416 416 98/07/19G NUE 199700456 199700456
21042 21042 30 416 416 98/07/16Gg SCR 199700439 199700439
21913 21913 21 416 416 98/07/16Gf SCR 199700495 199700495
22193 22193 4 416 416 98/07/27G ERL 199203126 199203126
22937 22937 33 416 416 98/07/20.03G UEB an GSK 199700459 199700459
23146 23146 10 416 416 98/07/16Ge MUE 199700514 199700514
23509 23509 24 416 416 98/07/20.01G UEB an RR 199700457 199700457
24089 24089 11 416 416 98/07/16Gd MUE 199700523 199700523
25094 25094 3 416 416 98/07/16Gc SCR 199700493 199700493
26440 26440 28 416 416 98/07/16Gb SCR 199700468 199700468
27590 27590 29 416 416 98/07/20.06G UEB an RR 199700467 199700467
27729 27729 8 416 416 98/07/24G ERL 199203128 199203128
27860 27860 32 416 416 98/07/16Ga MUE 199700524 199700524
28720 28720 7 416 416 98/07/15G ZUS 199700503 199700503
29929 29929 15 416 416 98/07/25G ERL 199203251 199203251
31557 31557 17 416 416 98/07/23G ERL 199203167 199203167
31952 31952 27 416 416 98/07/20.04G UEB an RR 199700463 199700463

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