Vorgaenge
53 rows where siz_nr = 348
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
241 | 241 | 37 | 348 348 | 199203611 199203611 | ||
242 | 242 | 40 | 348 348 | 199203624 199203624 | ||
1216 | 1216 | 33 | 348 348 | 199203604 199203604 | ||
1325 | 1325 | 32 | 348 348 | 199203563 199203563 | ||
1820 | 1820 | 44 | 348 348 | 199203191 199203191 | ||
1991 | 1991 | 12 | 348 348 | 199203567 199203567 | ||
3210 | 3210 | 6 | 348 348 | 199203118 199203118 | ||
3326 | 3326 | 53 | 348 348 | 199203606 199203606 | ||
3722 | 3722 | 43 | 348 348 | 199203628 199203628 | ||
3746 | 3746 | 9 | 348 348 | 199203561 199203561 | ||
3854 | 3854 | 35 | 348 348 | 199203607 199203607 | ||
4487 | 4487 | 36 | 348 348 | 199203608 199203608 | ||
5605 | 5605 | 38 | 348 348 | 199203612 199203612 | ||
6466 | 6466 | 22 | 348 348 | 199203593 199203593 | ||
6857 | 6857 | 49 | 348 348 | 199203569 199203569 | ||
7405 | 7405 | 5 | 348 348 | 199203584 199203584 | ||
7471 | 7471 | 27 | 348 348 | 199203600 199203600 | ||
8911 | 8911 | 39 | 348 348 | 199203613 199203613 | ||
9536 | 9536 | 15 | 348 348 | 199203571 199203571 | ||
9565 | 9565 | 30 | 348 348 | 199203626 199203626 | ||
10529 | 10529 | 47 | 348 348 | 199203572 199203572 | ||
11141 | 11141 | 41 | 348 348 | 199203625 199203625 | ||
11362 | 11362 | 3 | 348 348 | 199203579 199203579 | ||
12088 | 12088 | 19 | 348 348 | 199203576 199203576 | ||
13079 | 13079 | 2 | 348 348 | 199203583 199203583 | ||
17564 | 17564 | 29 | 348 348 | 199203603 199203603 | ||
19549 | 19549 | 26 | 348 348 | 199203598 199203598 | ||
20123 | 20123 | 45 | 348 348 | 199203589 199203589 | ||
21611 | 21611 | 21 | 348 348 | 199203592 199203592 | ||
21766 | 21766 | 20 | 348 348 | 199203564 199203564 | ||
21955 | 21955 | 1 | 348 348 | 199203084 199203084 | ||
23129 | 23129 | 4 | 348 348 | 199203580 199203580 | ||
23630 | 23630 | 48 | 348 348 | 199203550 199203550 | ||
24144 | 24144 | 13 | 348 348 | 199203568 199203568 | ||
24243 | 24243 | 28 | 348 348 | 199203602 199203602 | ||
24647 | 24647 | 17 | 348 348 | 199203574 199203574 | ||
24782 | 24782 | 7 | 348 348 | 199203582 199203582 | ||
25775 | 25775 | 50 | 348 348 | 199203577 199203577 | ||
25799 | 25799 | 51 | 348 348 | 199203594 199203594 | ||
26607 | 26607 | 18 | 348 348 | 199203575 199203575 | ||
26714 | 26714 | 25 | 348 348 | 199203597 199203597 | ||
26820 | 26820 | 31 | 348 348 | 199203565 199203565 | ||
27407 | 27407 | 52 | 348 348 | 199203599 199203599 | ||
27609 | 27609 | 10 | 348 348 | 199203562 199203562 | ||
28025 | 28025 | 14 | 348 348 | 199203570 199203570 | ||
28034 | 28034 | 34 | 348 348 | 199203605 199203605 | ||
28871 | 28871 | 54 | 348 348 | 199203591 199203591 | ||
29084 | 29084 | 16 | 348 348 | 199203573 199203573 | ||
31434 | 31434 | 11 | 348 348 | 199203566 199203566 | ||
31898 | 31898 | 46 | 348 348 | 199203581 199203581 | ||
32316 | 32316 | 24 | 348 348 | 199203596 199203596 | ||
32386 | 32386 | 55 | 348 348 | 199203578 199203578 | ||
32687 | 32687 | 23 | 348 348 | 199203595 199203595 |
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");