Vorgaenge
30 rows where siz_nr = 193
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
252 | 252 | 17 | 193 193 | 198802640 198802640 | ||
564 | 564 | 22 | 193 193 | 198802633 198802633 | ||
787 | 787 | 21 | 193 193 | 198802631 198802631 | ||
2027 | 2027 | 27 | 193 193 | 198802632 198802632 | ||
2100 | 2100 | 4 | 193 193 | 198802104 198802104 | ||
2104 | 2104 | 20 | 193 193 | 198802129 198802129 | ||
2427 | 2427 | 11 | 193 193 | 198802636 198802636 | ||
7458 | 7458 | 15 | 193 193 | 198802122 198802122 | ||
8895 | 8895 | 24 | 193 193 | 198802635 198802635 | ||
9609 | 9609 | 1 | 193 193 | 198802086 198802086 | ||
10445 | 10445 | 9 | 193 193 | 198802169 198802169 | ||
10674 | 10674 | 7 | 193 193 | 198802630 198802630 | ||
12698 | 12698 | 30 | 193 193 | 198802659 198802659 | ||
14404 | 14404 | 29 | 193 193 | 198802128 198802128 | ||
18137 | 18137 | 25 | 193 193 | 198802127 198802127 | ||
19576 | 19576 | 26 | 193 193 | 198802171 198802171 | ||
20359 | 20359 | 2 | 193 193 | 198802629 198802629 | ||
21651 | 21651 | 18 | 193 193 | 198802125 198802125 | ||
21698 | 21698 | 16 | 193 193 | 198802639 198802639 | ||
22003 | 22003 | 12 | 193 193 | 198802120 198802120 | ||
22574 | 22574 | 28 | 193 193 | 198802123 198802123 | ||
24486 | 24486 | 23 | 193 193 | 198802634 198802634 | ||
24646 | 24646 | 8 | 193 193 | 198802168 198802168 | ||
26951 | 26951 | 10 | 193 193 | 198802170 198802170 | ||
28337 | 28337 | 14 | 193 193 | 198802121 198802121 | ||
30616 | 30616 | 3 | 193 193 | 198802660 198802660 | ||
30766 | 30766 | 5 | 193 193 | 198802106 198802106 | ||
32102 | 32102 | 19 | 193 193 | 198802126 198802126 | ||
32127 | 32127 | 6 | 193 193 | 198802118 198802118 | ||
32238 | 32238 | 13 | 193 193 | 198802638 198802638 |
Advanced export
JSON shape: default, array, newline-delimited
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");