Vorgaenge
40 rows where siz_nr = 96
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
1195 | 1195 | 12 | 96 96 | 198801003 198801003 | ||
1285 | 1285 | 25 | 96 96 | 198801022 198801022 | ||
2056 | 2056 | 18 | 96 96 | 198801016 198801016 | ||
2164 | 2164 | 38 | 96 96 | 198801034 198801034 | ||
4397 | 4397 | 36 | 96 96 | 198801031 198801031 | ||
4408 | 4408 | 11 | 96 96 | 198800995 198800995 | ||
4631 | 4631 | 2 | 96 96 | 198801037 198801037 | ||
4846 | 4846 | 39 | 96 96 | 198801035 198801035 | ||
6028 | 6028 | 5 | 96 96 | 198801036 198801036 | ||
7059 | 7059 | 22 | 96 96 | 198801018 198801018 | ||
7429 | 7429 | 8 | 96 96 | 198801004 198801004 | ||
8822 | 8822 | 3 | 96 96 | 198801019 198801019 | ||
11100 | 11100 | 14 | 96 96 | 198801006 198801006 | ||
12943 | 12943 | 1 | 96 96 | 198802259 198802259 | ||
13180 | 13180 | 4 | 96 96 | 198802267 198802267 | ||
13512 | 13512 | 40 | 96 96 | 198801015 198801015 | ||
14338 | 14338 | 28 | 96 96 | 198802265 198802265 | ||
14997 | 14997 | 29 | 96 96 | 198802266 198802266 | ||
15587 | 15587 | 13 | 96 96 | 198801005 198801005 | ||
16139 | 16139 | 10 | 96 96 | 198800988 198800988 | ||
16300 | 16300 | 9 | 96 96 | 198801008 198801008 | ||
16497 | 16497 | 21 | 96 96 | 198801017 198801017 | ||
17107 | 17107 | 35 | 96 96 | 198801030 198801030 | ||
17121 | 17121 | 27 | 96 96 | 198801023 198801023 | ||
18647 | 18647 | 26 | 96 96 | 198802264 198802264 | ||
19004 | 19004 | 7 | 96 96 | 198801039 198801039 | ||
21150 | 21150 | 37 | 96 96 | 198801033 198801033 | ||
21222 | 21222 | 34 | 96 96 | 198801028 198801028 | ||
22168 | 22168 | 23 | 96 96 | 198801020 198801020 | ||
22449 | 22449 | 19 | 96 96 | 198802261 198802261 | ||
23574 | 23574 | 6 | 96 96 | 198801032 198801032 | ||
27113 | 27113 | 30 | 96 96 | 198801024 198801024 | ||
28251 | 28251 | 20 | 96 96 | 198802262 198802262 | ||
28385 | 28385 | 15 | 96 96 | 198801007 198801007 | ||
28552 | 28552 | 24 | 96 96 | 198801021 198801021 | ||
31011 | 31011 | 16 | 96 96 | 198801038 198801038 | ||
31095 | 31095 | 32 | 96 96 | 198801026 198801026 | ||
31565 | 31565 | 17 | 96 96 | 198802260 198802260 | ||
31991 | 31991 | 31 | 96 96 | 198801025 198801025 | ||
32487 | 32487 | 33 | 96 96 | 198801027 198801027 |
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");