Vorgaenge
51 rows where siz_nr = 455
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
763 | 763 | 47 | 455 455 | 199701080 199701080 | ||
840 | 840 | 35 | 455 455 | 199203690 199203690 | ||
859 | 859 | 31 | 455 455 | 199700041 199700041 | ||
2192 | 2192 | 5 | 455 455 | 199701066 199701066 | ||
2280 | 2280 | 33 | 455 455 | 199203670 199203670 | ||
2587 | 2587 | 14 | 455 455 | 199701060 199701060 | ||
2889 | 2889 | 21 | 455 455 | 199701076 199701076 | ||
3431 | 3431 | 16 | 455 455 | 199701068 199701068 | ||
4111 | 4111 | 28 | 455 455 | 199701092 199701092 | ||
4558 | 4558 | 4 | 455 455 | 199701064 199701064 | ||
4651 | 4651 | 29 | 455 455 | 199701092 199701092 | ||
4824 | 4824 | 22 | 455 455 | 199701081 199701081 | ||
6371 | 6371 | 36 | 455 455 | 199701048 199701048 | ||
7589 | 7589 | 18 | 455 455 | 199701070 199701070 | ||
8233 | 8233 | 43 | 455 455 | 199701096 199701096 | ||
8423 | 8423 | 8 | 455 455 | 199701082 199701082 | ||
8815 | 8815 | 10 | 455 455 | 199701054 199701054 | ||
8999 | 8999 | 13 | 455 455 | 199701098 199701098 | ||
9348 | 9348 | 42 | 455 455 | 199701089 199701089 | ||
9951 | 9951 | 34 | 455 455 | 199701108 199701108 | ||
10340 | 10340 | 51 | 455 455 | 199701043 199701043 | ||
13315 | 13315 | 24 | 455 455 | 199701086 199701086 | ||
13416 | 13416 | 44 | 455 455 | 199701062 199701062 | ||
14280 | 14280 | 11 | 455 455 | 199701095 199701095 | ||
14444 | 14444 | 2 | 455 455 | 199701050 199701050 | ||
14457 | 14457 | 3 | 455 455 | 199701065 199701065 | ||
15328 | 15328 | 6 | 455 455 | 199701073 199701073 | ||
15784 | 15784 | 41 | 455 455 | 199701084 199701084 | ||
16820 | 16820 | 30 | 455 455 | 199701094 199701094 | ||
18035 | 18035 | 49 | 455 455 | 199700360 199700360 | ||
19211 | 19211 | 27 | 455 455 | 199701090 199701090 | ||
20591 | 20591 | 37 | 455 455 | 199701049 199701049 | ||
21901 | 21901 | 40 | 455 455 | 199203206 199203206 | ||
22197 | 22197 | 46 | 455 455 | 199701085 199701085 | ||
22986 | 22986 | 38 | 455 455 | 199701109 199701109 | ||
23185 | 23185 | 50 | 455 455 | 199700779 199700779 | ||
23444 | 23444 | 23 | 455 455 | 199701083 199701083 | ||
24091 | 24091 | 26 | 455 455 | 199701088 199701088 | ||
25704 | 25704 | 25 | 455 455 | 199701087 199701087 | ||
26133 | 26133 | 39 | 455 455 | 199203482 199203482 | ||
27778 | 27778 | 9 | 455 455 | 199701053 199701053 | ||
28145 | 28145 | 17 | 455 455 | 199701069 199701069 | ||
28865 | 28865 | 52 | 455 455 | 199701071 199701071 | ||
28939 | 28939 | 7 | 455 455 | 199701077 199701077 | ||
29299 | 29299 | 20 | 455 455 | 199701074 199701074 | ||
30195 | 30195 | 32 | 455 455 | 199203663 199203663 | ||
30707 | 30707 | 19 | 455 455 | 199701072 199701072 | ||
31525 | 31525 | 48 | 455 455 | 199701063 199701063 | ||
31929 | 31929 | 12 | 455 455 | 199701097 199701097 | ||
32297 | 32297 | 1 | 455 455 | 199701067 199701067 | ||
32627 | 32627 | 45 | 455 455 | 199701075 199701075 |
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");