Vorgaenge
42 rows where siz_nr = 124
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
163 | 163 | 26 | 124 124 | 198801261 198801261 | ||
961 | 961 | 8 | 124 124 | 198801435 198801435 | ||
3607 | 3607 | 6 | 124 124 | 198801279 198801279 | ||
3655 | 3655 | 12 | 124 124 | 198801443 198801443 | ||
4882 | 4882 | 21 | 124 124 | 198801268 198801268 | ||
5205 | 5205 | 37 | 124 124 | 198801278 198801278 | ||
5387 | 5387 | 36 | 124 124 | 198801277 198801277 | ||
5405 | 5405 | 23 | 124 124 | 198801270 198801270 | ||
5926 | 5926 | 30 | 124 124 | 198801288 198801288 | ||
6249 | 6249 | 11 | 124 124 | 198801442 198801442 | ||
6509 | 6509 | 2 | 124 124 | 198400503 198400503 | ||
7877 | 7877 | 13 | 124 124 | 198400491 198400491 | ||
9070 | 9070 | 17 | 124 124 | 198802318 198802318 | ||
9166 | 9166 | 14 | 124 124 | 198801432 198801432 | ||
10585 | 10585 | 24 | 124 124 | 198801271 198801271 | ||
12221 | 12221 | 10 | 124 124 | 198801441 198801441 | ||
12671 | 12671 | 1 | 124 124 | 198801440 198801440 | ||
13426 | 13426 | 22 | 124 124 | 198801269 198801269 | ||
13452 | 13452 | 35 | 124 124 | 198801275 198801275 | ||
13630 | 13630 | 9 | 124 124 | 198801438 198801438 | ||
13894 | 13894 | 20 | 124 124 | 198801267 198801267 | ||
15072 | 15072 | 25 | 124 124 | 198801260 198801260 | ||
16452 | 16452 | 41 | 124 124 | 198801285 198801285 | ||
17016 | 17016 | 34 | 124 124 | 198801274 198801274 | ||
17217 | 17217 | 39 | 124 124 | 198801281 198801281 | ||
17246 | 17246 | 29 | 124 124 | 198802316 198802316 | ||
18165 | 18165 | 16 | 124 124 | 198802317 198802317 | ||
18428 | 18428 | 18 | 124 124 | 198802318 198802318 | ||
19730 | 19730 | 7 | 124 124 | 198801283 198801283 | ||
20345 | 20345 | 28 | 124 124 | 198802315 198802315 | ||
22249 | 22249 | 33 | 124 124 | 198801273 198801273 | ||
23862 | 23862 | 19 | 124 124 | 198801266 198801266 | ||
24540 | 24540 | 4 | 124 124 | 198801276 198801276 | ||
26156 | 26156 | 38 | 124 124 | 198801280 198801280 | ||
28202 | 28202 | 32 | 124 124 | 198801272 198801272 | ||
29514 | 29514 | 27 | 124 124 | 198802314 198802314 | ||
30231 | 30231 | 40 | 124 124 | 198801282 198801282 | ||
30514 | 30514 | 15 | 124 124 | 198801434 198801434 | ||
31519 | 31519 | 5 | 124 124 | 198801284 198801284 | ||
31725 | 31725 | 42 | 124 124 | 198801265 198801265 | ||
31970 | 31970 | 31 | 124 124 | 198801246 198801246 | ||
32974 | 32974 | 3 | 124 124 | 198801433 198801433 |
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");