Vorgaenge
35 rows where siz_nr = 534
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
2142 | 2142 | 16 | 534 534 | 200100101 200100101 | ||
4591 | 4591 | 21 | 534 534 | 200100106 200100106 | ||
4899 | 4899 | 5 | 534 534 | 200100082 200100082 | ||
5017 | 5017 | 22 | 534 534 | 200100108 200100108 | ||
5026 | 5026 | 8 | 534 534 | 200100066 200100066 | ||
6736 | 6736 | 14 | 534 534 | 200100098 200100098 | ||
6967 | 6967 | 23 | 534 534 | 200100109 200100109 | ||
7940 | 7940 | 13 | 534 534 | 200100069 200100069 | ||
8371 | 8371 | 9 | 534 534 | 200100070 200100070 | ||
8821 | 8821 | 36 | 534 534 | 200100014 200100014 | ||
9315 | 9315 | 11 | 534 534 | 200100068 200100068 | ||
10405 | 10405 | 7 | 534 534 | 200100090 200100090 | ||
11634 | 11634 | 18 | 534 534 | 200100103 200100103 | ||
12645 | 12645 | 34 | 534 534 | 200100107 200100107 | ||
15467 | 15467 | 24 | 534 534 | 200100110 200100110 | ||
15484 | 15484 | 32 | 534 534 | 200100067 200100067 | ||
15657 | 15657 | 26 | 534 534 | 199701757 199701757 | ||
16086 | 16086 | 6 | 534 534 | 200100089 200100089 | ||
16248 | 16248 | 20 | 534 534 | 200100105 200100105 | ||
20099 | 20099 | 15 | 534 534 | 200100097 200100097 | ||
20650 | 20650 | 3 | 534 534 | 200100078 200100078 | ||
20741 | 20741 | 10 | 534 534 | 200100068 200100068 | ||
20756 | 20756 | 31 | 534 534 | 200100088 200100088 | ||
22477 | 22477 | 27 | 534 534 | 198400464 198400464 | ||
23763 | 23763 | 25 | 534 534 | 200100111 200100111 | ||
24028 | 24028 | 28 | 534 534 | 199202265 199202265 | ||
26635 | 26635 | 30 | 534 534 | 199700901 199700901 | ||
27478 | 27478 | 19 | 534 534 | 200100104 200100104 | ||
27479 | 27479 | 29 | 534 534 | 199203780 199203780 | ||
28250 | 28250 | 35 | 534 534 | 200100018 200100018 | ||
28314 | 28314 | 33 | 534 534 | 200100067 200100067 | ||
28849 | 28849 | 1 | 534 534 | 200100055 200100055 | ||
29932 | 29932 | 2 | 534 534 | 200100087 200100087 | ||
31308 | 31308 | 17 | 534 534 | 200100102 200100102 | ||
31404 | 31404 | 12 | 534 534 | 200100066 200100066 |
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");