Vorgaenge
38 rows where siz_nr = 502
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
1078 | 1078 | 35 | 502 502 | 199701650 199701650 | ||
1974 | 1974 | 11 | 502 502 | 199701658 199701658 | ||
3286 | 3286 | 14 | 502 502 | 199701645 199701645 | ||
4516 | 4516 | 36 | 502 502 | 199701660 199701660 | ||
6499 | 6499 | 18 | 502 502 | 199701648 199701648 | ||
6762 | 6762 | 23 | 502 502 | 199701651 199701651 | ||
7579 | 7579 | 19 | 502 502 | 199701633 199701633 | ||
9071 | 9071 | 28 | 502 502 | 199700821 199700821 | ||
9098 | 9098 | 38 | 502 502 | 199203208 199203208 | ||
9455 | 9455 | 10 | 502 502 | 199701641 199701641 | ||
9520 | 9520 | 2 | 502 502 | 199701668 199701668 | ||
10558 | 10558 | 34 | 502 502 | 199701429 199701429 | ||
13371 | 13371 | 30 | 502 502 | 199700463 199700463 | ||
13489 | 13489 | 27 | 502 502 | 199700510 199700510 | ||
13557 | 13557 | 20 | 502 502 | 199701634 199701634 | ||
14664 | 14664 | 31 | 502 502 | 199701426 199701426 | ||
15182 | 15182 | 8 | 502 502 | 199701671 199701671 | ||
16130 | 16130 | 5 | 502 502 | 199701662 199701662 | ||
18316 | 18316 | 16 | 502 502 | 199701667 199701667 | ||
18703 | 18703 | 32 | 502 502 | 199701428 199701428 | ||
18720 | 18720 | 37 | 502 502 | 199701643 199701643 | ||
19068 | 19068 | 1 | 502 502 | 199701656 199701656 | ||
19338 | 19338 | 26 | 502 502 | 199701655 199701655 | ||
21376 | 21376 | 24 | 502 502 | 199701653 199701653 | ||
22361 | 22361 | 13 | 502 502 | 199701644 199701644 | ||
23540 | 23540 | 21 | 502 502 | 199701652 199701652 | ||
23742 | 23742 | 7 | 502 502 | 199701669 199701669 | ||
24252 | 24252 | 25 | 502 502 | 199701654 199701654 | ||
25514 | 25514 | 12 | 502 502 | 199701642 199701642 | ||
26411 | 26411 | 3 | 502 502 | 199701661 199701661 | ||
26630 | 26630 | 15 | 502 502 | 199701659 199701659 | ||
27246 | 27246 | 4 | 502 502 | 199701664 199701664 | ||
29070 | 29070 | 33 | 502 502 | 199701430 199701430 | ||
29144 | 29144 | 29 | 502 502 | 199701391 199701391 | ||
30283 | 30283 | 39 | 502 502 | 199701657 199701657 | ||
32850 | 32850 | 9 | 502 502 | 199701598 199701598 | ||
32910 | 32910 | 6 | 502 502 | 199701663 199701663 | ||
33006 | 33006 | 22 | 502 502 | 199701649 199701649 |
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");