Vorgaenge
49 rows where siz_nr = 217
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
596 | 596 | 5 | 217 217 | 199202339 199202339 | ||
1207 | 1207 | 39 | 217 217 | 199201678 199201678 | ||
2213 | 2213 | 24 | 217 217 | 199202265 199202265 | ||
4189 | 4189 | 14 | 217 217 | 199202526 199202526 | ||
4600 | 4600 | 16 | 217 217 | 199202384 199202384 | ||
5427 | 5427 | 1 | 217 217 | 198802234 198802234 | ||
5671 | 5671 | 40 | 217 217 | 199201677 199201677 | ||
6246 | 6246 | 43 | 217 217 | 199201689 199201689 | ||
7735 | 7735 | 8 | 217 217 | 199201632 199201632 | ||
9137 | 9137 | 7 | 217 217 | 199202700 199202700 | ||
10270 | 10270 | 21 | 217 217 | 199201686 199201686 | ||
10358 | 10358 | 36 | 217 217 | 199202476 199202476 | ||
11704 | 11704 | 34 | 217 217 | 199201672 199201672 | ||
11916 | 11916 | 20 | 217 217 | 199201690 199201690 | ||
13068 | 13068 | 37 | 217 217 | 199201804 199201804 | ||
13843 | 13843 | 11 | 217 217 | 199201650 199201650 | ||
14048 | 14048 | 22 | 217 217 | 199201693 199201693 | ||
14292 | 14292 | 44 | 217 217 | 199202694 199202694 | ||
14359 | 14359 | 9 | 217 217 | 199201633 199201633 | ||
14532 | 14532 | 38 | 217 217 | 199201755 199201755 | ||
14770 | 14770 | 10 | 217 217 | 199201649 199201649 | ||
15805 | 15805 | 3 | 217 217 | 199201660 199201660 | ||
16552 | 16552 | 15 | 217 217 | 198400519 198400519 | ||
16948 | 16948 | 32 | 217 217 | 199201668 199201668 | ||
17193 | 17193 | 48 | 217 217 | 199201768 199201768 | ||
17333 | 17333 | 28 | 217 217 | 199201909 199201909 | ||
17362 | 17362 | 26 | 217 217 | 199202703 199202703 | ||
17850 | 17850 | 47 | 217 217 | 199201671 199201671 | ||
17960 | 17960 | 18 | 217 217 | 199201687 199201687 | ||
18055 | 18055 | 4 | 217 217 | 199201658 199201658 | ||
18607 | 18607 | 29 | 217 217 | 199202068 199202068 | ||
21039 | 21039 | 46 | 217 217 | 199202093 199202093 | ||
22277 | 22277 | 27 | 217 217 | 199202313 199202313 | ||
22944 | 22944 | 41 | 217 217 | 199201661 199201661 | ||
23040 | 23040 | 30 | 217 217 | 199202701 199202701 | ||
23259 | 23259 | 13 | 217 217 | 199202697 199202697 | ||
23364 | 23364 | 17 | 217 217 | 199201694 199201694 | ||
23685 | 23685 | 35 | 217 217 | 199201657 199201657 | ||
23773 | 23773 | 2 | 217 217 | 199202708 199202708 | ||
23927 | 23927 | 33 | 217 217 | 199201669 199201669 | ||
24227 | 24227 | 45 | 217 217 | 199202698 199202698 | ||
24737 | 24737 | 19 | 217 217 | 199201691 199201691 | ||
25516 | 25516 | 25 | 217 217 | 199202702 199202702 | ||
26506 | 26506 | 23 | 217 217 | 199201908 199201908 | ||
27391 | 27391 | 12 | 217 217 | 199201910 199201910 | ||
29407 | 29407 | 49 | 217 217 | 199201765 199201765 | ||
32059 | 32059 | 31 | 217 217 | 199201688 199201688 | ||
32547 | 32547 | 6 | 217 217 | 199202371 199202371 | ||
32780 | 32780 | 42 | 217 217 | 199201670 199201670 |
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");