Vorgaenge
53 rows where siz_nr = 475
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
223 | 223 | 22 | 475 475 | 199701338 199701338 | ||
246 | 246 | 27 | 475 475 | 199701351 199701351 | ||
1702 | 1702 | 11 | 475 475 | 199701354 199701354 | ||
4720 | 4720 | 18 | 475 475 | 199701368 199701368 | ||
4878 | 4878 | 8 | 475 475 | 199701344 199701344 | ||
5863 | 5863 | 50 | 475 475 | 199701339 199701339 | ||
5964 | 5964 | 42 | 475 475 | 199701353 199701353 | ||
6069 | 6069 | 16 | 475 475 | 199701364 199701364 | ||
6259 | 6259 | 25 | 475 475 | 199701337 199701337 | ||
6631 | 6631 | 2 | 475 475 | 199701359 199701359 | ||
7108 | 7108 | 10 | 475 475 | 199701347 199701347 | ||
7184 | 7184 | 48 | 475 475 | 199701204 199701204 | ||
9414 | 9414 | 5 | 475 475 | 199701341 199701341 | ||
9721 | 9721 | 12 | 475 475 | 199701357 199701357 | ||
10087 | 10087 | 45 | 475 475 | 199701363 199701363 | ||
10280 | 10280 | 33 | 475 475 | 199701328 199701328 | ||
10327 | 10327 | 30 | 475 475 | 199701263 199701263 | ||
10339 | 10339 | 31 | 475 475 | 199701350 199701350 | ||
10748 | 10748 | 38 | 475 475 | 199701390 199701390 | ||
10879 | 10879 | 47 | 475 475 | 199701106 199701106 | ||
12164 | 12164 | 23 | 475 475 | 199701331 199701331 | ||
12260 | 12260 | 7 | 475 475 | 199701343 199701343 | ||
12798 | 12798 | 32 | 475 475 | 199701333 199701333 | ||
13892 | 13892 | 39 | 475 475 | 199701391 199701391 | ||
14382 | 14382 | 13 | 475 475 | 199701360 199701360 | ||
15807 | 15807 | 19 | 475 475 | 199701355 199701355 | ||
16590 | 16590 | 29 | 475 475 | 199701330 199701330 | ||
16920 | 16920 | 26 | 475 475 | 199701348 199701348 | ||
18431 | 18431 | 34 | 475 475 | 199701371 199701371 | ||
18739 | 18739 | 24 | 475 475 | 199701329 199701329 | ||
19769 | 19769 | 51 | 475 475 | 199701322 199701322 | ||
20731 | 20731 | 9 | 475 475 | 199701342 199701342 | ||
20867 | 20867 | 52 | 475 475 | 199701336 199701336 | ||
21046 | 21046 | 4 | 475 475 | 199701340 199701340 | ||
21613 | 21613 | 17 | 475 475 | 199701364 199701364 | ||
22177 | 22177 | 44 | 475 475 | 199700992 199700992 | ||
22603 | 22603 | 20 | 475 475 | 199700782 199700782 | ||
22972 | 22972 | 46 | 475 475 | 199701352 199701352 | ||
23541 | 23541 | 54 | 475 475 | 199701334 199701334 | ||
24426 | 24426 | 3 | 475 475 | 199701335 199701335 | ||
24532 | 24532 | 40 | 475 475 | 199701392 199701392 | ||
24800 | 24800 | 28 | 475 475 | 199701349 199701349 | ||
27293 | 27293 | 15 | 475 475 | 199701362 199701362 | ||
27673 | 27673 | 37 | 475 475 | 199701388 199701388 | ||
27935 | 27935 | 35 | 475 475 | 199701372 199701372 | ||
28059 | 28059 | 6 | 475 475 | 199701370 199701370 | ||
28488 | 28488 | 43 | 475 475 | 199701389 199701389 | ||
29147 | 29147 | 36 | 475 475 | 199701387 199701387 | ||
29397 | 29397 | 14 | 475 475 | 199701361 199701361 | ||
30596 | 30596 | 49 | 475 475 | 199701369 199701369 | ||
30684 | 30684 | 1 | 475 475 | 199701321 199701321 | ||
30720 | 30720 | 21 | 475 475 | 199701332 199701332 | ||
32610 | 32610 | 41 | 475 475 | 199701353 199701353 |
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");