Vorgaenge
64 rows where siz_nr = 543
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
891 | 891 | 2 | 543 543 | 200100249 200100249 | ||
1337 | 1337 | 61 | 543 543 | 200100251 200100251 | ||
2466 | 2466 | 12 | 543 543 | 200100261 200100261 | ||
2561 | 2561 | 35 | 543 543 | 200100188 200100188 | ||
3497 | 3497 | 54 | 543 543 | 200100221 200100221 | ||
4315 | 4315 | 28 | 543 543 | 200100225 200100225 | ||
5154 | 5154 | 29 | 543 543 | 200100227 200100227 | ||
5616 | 5616 | 10 | 543 543 | 200100256 200100256 | ||
6681 | 6681 | 48 | 543 543 | 200100213 200100213 | ||
6714 | 6714 | 18 | 543 543 | 200100275 200100275 | ||
7139 | 7139 | 52 | 543 543 | 199700978 199700978 | ||
7286 | 7286 | 63 | 543 543 | 200100149 200100149 | ||
7932 | 7932 | 44 | 543 543 | 200100238 200100238 | ||
7943 | 7943 | 11 | 543 543 | 200100258 200100258 | ||
8869 | 8869 | 60 | 543 543 | 200100243 200100243 | ||
9068 | 9068 | 7 | 543 543 | 200100252 200100252 | ||
9297 | 9297 | 16 | 543 543 | 200100266 200100266 | ||
10617 | 10617 | 32 | 543 543 | 200100240 200100240 | ||
11188 | 11188 | 23 | 543 543 | 200100191 200100191 | ||
11353 | 11353 | 46 | 543 543 | 200100209 200100209 | ||
11464 | 11464 | 22 | 543 543 | 200100192 200100192 | ||
11838 | 11838 | 4 | 543 543 | 200100246 200100246 | ||
12370 | 12370 | 58 | 543 543 | 200100214 200100214 | ||
12447 | 12447 | 51 | 543 543 | 200100219 200100219 | ||
12665 | 12665 | 55 | 543 543 | 200100230 200100230 | ||
12928 | 12928 | 15 | 543 543 | 200100265 200100265 | ||
12967 | 12967 | 25 | 543 543 | 200100217 200100217 | ||
13016 | 13016 | 37 | 543 543 | 200100223 200100223 | ||
13263 | 13263 | 31 | 543 543 | 200100231 200100231 | ||
13898 | 13898 | 64 | 543 543 | 200100224 200100224 | ||
14220 | 14220 | 57 | 543 543 | 200100212 200100212 | ||
14263 | 14263 | 1 | 543 543 | 200100236 200100236 | ||
15145 | 15145 | 39 | 543 543 | 200100226 200100226 | ||
15354 | 15354 | 34 | 543 543 | 200100187 200100187 | ||
15826 | 15826 | 49 | 543 543 | 200100215 200100215 | ||
16605 | 16605 | 6 | 543 543 | 200100250 200100250 | ||
16816 | 16816 | 3 | 543 543 | 200100254 200100254 | ||
17736 | 17736 | 8 | 543 543 | 200100253 200100253 | ||
17893 | 17893 | 65 | 543 543 | 200100222 200100222 | ||
20269 | 20269 | 43 | 543 543 | 200100237 200100237 | ||
21260 | 21260 | 33 | 543 543 | 200100242 200100242 | ||
21294 | 21294 | 56 | 543 543 | 200100193 200100193 | ||
21992 | 21992 | 9 | 543 543 | 200100255 200100255 | ||
23180 | 23180 | 41 | 543 543 | 200100234 200100234 | ||
24130 | 24130 | 36 | 543 543 | 200100233 200100233 | ||
24132 | 24132 | 53 | 543 543 | 199700931 199700931 | ||
24487 | 24487 | 21 | 543 543 | 200100186 200100186 | ||
24750 | 24750 | 5 | 543 543 | 200100248 200100248 | ||
25059 | 25059 | 19 | 543 543 | 200100030 200100030 | ||
25628 | 25628 | 27 | 543 543 | 200100271 200100271 | ||
26615 | 26615 | 13 | 543 543 | 200100263 200100263 | ||
27736 | 27736 | 62 | 543 543 | 200100262 200100262 | ||
28411 | 28411 | 50 | 543 543 | 200100216 200100216 | ||
28412 | 28412 | 24 | 543 543 | 200100218 200100218 | ||
28515 | 28515 | 17 | 543 543 | 200100276 200100276 | ||
29312 | 29312 | 30 | 543 543 | 200100228 200100228 | ||
29853 | 29853 | 42 | 543 543 | 200100235 200100235 | ||
30486 | 30486 | 59 | 543 543 | 200100229 200100229 | ||
31281 | 31281 | 14 | 543 543 | 200100264 200100264 | ||
31607 | 31607 | 40 | 543 543 | 200100244 200100244 | ||
31693 | 31693 | 45 | 543 543 | 200100239 200100239 | ||
31891 | 31891 | 20 | 543 543 | 199701754 199701754 | ||
31987 | 31987 | 38 | 543 543 | 200100232 200100232 | ||
32391 | 32391 | 47 | 543 543 | 200100211 200100211 |
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");