Vorgaenge
72 rows where siz_nr = 555
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
160 | 160 | 46 | 555 555 | 200100353 200100353 | ||
180 | 180 | 30 | 555 555 | 200100379 200100379 | ||
375 | 375 | 29 | 555 555 | 200100378 200100378 | ||
988 | 988 | 5 | 555 555 | 199701925 199701925 | ||
1304 | 1304 | 12 | 555 555 | 200100362 200100362 | ||
2480 | 2480 | 58 | 555 555 | 200100360 200100360 | ||
4423 | 4423 | 64 | 555 555 | 199203180 199203180 | ||
4757 | 4757 | 44 | 555 555 | 200100334 200100334 | ||
4897 | 4897 | 39 | 555 555 | 199701862 199701862 | ||
5449 | 5449 | 41 | 555 555 | 200100330 200100330 | ||
5778 | 5778 | 66 | 555 555 | 199700197 199700197 | ||
5882 | 5882 | 53 | 555 555 | 200100388 200100388 | ||
6074 | 6074 | 15 | 555 555 | 200100393 200100393 | ||
6642 | 6642 | 57 | 555 555 | 199202688 199202688 | ||
7383 | 7383 | 73 | 555 555 | 200100355 200100355 | ||
7442 | 7442 | 6 | 555 555 | 199701369 199701369 | ||
8014 | 8014 | 11 | 555 555 | 200100359 200100359 | ||
8321 | 8321 | 3 | 555 555 | 200100391 200100391 | ||
8374 | 8374 | 21 | 555 555 | 200100369 200100369 | ||
9005 | 9005 | 54 | 555 555 | 199701924 199701924 | ||
9151 | 9151 | 28 | 555 555 | 200100377 200100377 | ||
9775 | 9775 | 22 | 555 555 | 200100370 200100370 | ||
9914 | 9914 | 63 | 555 555 | 199701153 199701153 | ||
11091 | 11091 | 69 | 555 555 | 199701542 199701542 | ||
11329 | 11329 | 52 | 555 555 | 200100385 200100385 | ||
11381 | 11381 | 67 | 555 555 | 199701394 199701394 | ||
11392 | 11392 | 61 | 555 555 | 199700161 199700161 | ||
11512 | 11512 | 68 | 555 555 | 199203826 199203826 | ||
11804 | 11804 | 17 | 555 555 | 200100395 200100395 | ||
11987 | 11987 | 38 | 555 555 | 200100400 200100400 | ||
12193 | 12193 | 65 | 555 555 | 199701268 199701268 | ||
12311 | 12311 | 9 | 555 555 | 200100401 200100401 | ||
12490 | 12490 | 47 | 555 555 | 200100356 200100356 | ||
13583 | 13583 | 1 | 555 555 | 200100366 200100366 | ||
14260 | 14260 | 31 | 555 555 | 200100383 200100383 | ||
14410 | 14410 | 4 | 555 555 | 200100173 200100173 | ||
14827 | 14827 | 25 | 555 555 | 200100374 200100374 | ||
14906 | 14906 | 26 | 555 555 | 200100375 200100375 | ||
15612 | 15612 | 20 | 555 555 | 200100368 200100368 | ||
15794 | 15794 | 70 | 555 555 | 200100389 200100389 | ||
15863 | 15863 | 18 | 555 555 | 200100365 200100365 | ||
16898 | 16898 | 16 | 555 555 | 200100395 200100395 | ||
18231 | 18231 | 62 | 555 555 | 199701151 199701151 | ||
18338 | 18338 | 51 | 555 555 | 200100363 200100363 | ||
18820 | 18820 | 40 | 555 555 | 200100358 200100358 | ||
18857 | 18857 | 34 | 555 555 | 200100392 200100392 | ||
19447 | 19447 | 59 | 555 555 | 198802630 198802630 | ||
20336 | 20336 | 32 | 555 555 | 200100384 200100384 | ||
20389 | 20389 | 24 | 555 555 | 200100373 200100373 | ||
21016 | 21016 | 7 | 555 555 | 200100352 200100352 | ||
21082 | 21082 | 49 | 555 555 | 200100333 200100333 | ||
21423 | 21423 | 48 | 555 555 | 200100386 200100386 | ||
23584 | 23584 | 43 | 555 555 | 200100357 200100357 | ||
24358 | 24358 | 10 | 555 555 | 200100361 200100361 | ||
24420 | 24420 | 37 | 555 555 | 200100399 200100399 | ||
24829 | 24829 | 2 | 555 555 | 200100372 200100372 | ||
25599 | 25599 | 55 | 555 555 | 199701847 199701847 | ||
26538 | 26538 | 45 | 555 555 | 200100329 200100329 | ||
27148 | 27148 | 19 | 555 555 | 200100367 200100367 | ||
27323 | 27323 | 23 | 555 555 | 200100371 200100371 | ||
27355 | 27355 | 71 | 555 555 | 200100397 200100397 | ||
27685 | 27685 | 60 | 555 555 | 199701368 199701368 | ||
27985 | 27985 | 8 | 555 555 | 198802629 198802629 | ||
28517 | 28517 | 56 | 555 555 | 199701857 199701857 | ||
29620 | 29620 | 35 | 555 555 | 200100014 200100014 | ||
29934 | 29934 | 33 | 555 555 | 200100390 200100390 | ||
30031 | 30031 | 50 | 555 555 | 200100387 200100387 | ||
32734 | 32734 | 36 | 555 555 | 200100398 200100398 | ||
33024 | 33024 | 14 | 555 555 | 200100393 200100393 | ||
33090 | 33090 | 72 | 555 555 | 200100331 200100331 | ||
33126 | 33126 | 27 | 555 555 | 200100376 200100376 | ||
33175 | 33175 | 42 | 555 555 | 200100332 200100332 |
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");