Vorgaenge
51 rows where siz_nr = 494
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
516 | 516 | 2 | 494 494 | 199701526 199701526 | ||
1309 | 1309 | 40 | 494 494 | 199701537 199701537 | ||
1549 | 1549 | 7 | 494 494 | 199701557 199701557 | ||
1562 | 1562 | 49 | 494 494 | 199701558 199701558 | ||
1684 | 1684 | 4 | 494 494 | 199701551 199701551 | ||
2395 | 2395 | 33 | 494 494 | 199701552 199701552 | ||
2857 | 2857 | 11 | 494 494 | 199701565 199701565 | ||
4927 | 4927 | 17 | 494 494 | 199701573 199701573 | ||
6036 | 6036 | 18 | 494 494 | 199701574 199701574 | ||
7098 | 7098 | 16 | 494 494 | 199701571 199701571 | ||
8844 | 8844 | 38 | 494 494 | 199701536 199701536 | ||
9261 | 9261 | 1 | 494 494 | 199701547 199701547 | ||
9823 | 9823 | 44 | 494 494 | 199701548 199701548 | ||
10506 | 10506 | 15 | 494 494 | 199701570 199701570 | ||
10836 | 10836 | 13 | 494 494 | 199701568 199701568 | ||
10929 | 10929 | 5 | 494 494 | 199701554 199701554 | ||
11927 | 11927 | 6 | 494 494 | 199701555 199701555 | ||
12353 | 12353 | 19 | 494 494 | 199701590 199701590 | ||
13306 | 13306 | 50 | 494 494 | 199701566 199701566 | ||
13750 | 13750 | 25 | 494 494 | 199701534 199701534 | ||
16195 | 16195 | 37 | 494 494 | 199700516 199700516 | ||
16262 | 16262 | 28 | 494 494 | 199701538 199701538 | ||
16468 | 16468 | 12 | 494 494 | 199701567 199701567 | ||
16597 | 16597 | 36 | 494 494 | 199701346 199701346 | ||
17609 | 17609 | 52 | 494 494 | 199701546 199701546 | ||
17897 | 17897 | 32 | 494 494 | 199701556 199701556 | ||
17979 | 17979 | 27 | 494 494 | 199701540 199701540 | ||
18081 | 18081 | 26 | 494 494 | 199701535 199701535 | ||
18239 | 18239 | 35 | 494 494 | 199701578 199701578 | ||
19511 | 19511 | 39 | 494 494 | 199701479 199701479 | ||
20903 | 20903 | 23 | 494 494 | 199701531 199701531 | ||
21884 | 21884 | 9 | 494 494 | 199701560 199701560 | ||
22756 | 22756 | 31 | 494 494 | 199701544 199701544 | ||
23118 | 23118 | 24 | 494 494 | 199701532 199701532 | ||
23213 | 23213 | 34 | 494 494 | 199701562 199701562 | ||
23276 | 23276 | 29 | 494 494 | 199701539 199701539 | ||
23941 | 23941 | 30 | 494 494 | 199701541 199701541 | ||
24905 | 24905 | 10 | 494 494 | 199701561 199701561 | ||
25414 | 25414 | 45 | 494 494 | 199701589 199701589 | ||
25986 | 25986 | 46 | 494 494 | 199701533 199701533 | ||
26251 | 26251 | 47 | 494 494 | 199701542 199701542 | ||
27541 | 27541 | 48 | 494 494 | 199701549 199701549 | ||
28827 | 28827 | 43 | 494 494 | 199701564 199701564 | ||
29629 | 29629 | 51 | 494 494 | 199701572 199701572 | ||
30081 | 30081 | 3 | 494 494 | 199701550 199701550 | ||
30175 | 30175 | 14 | 494 494 | 199701569 199701569 | ||
30789 | 30789 | 22 | 494 494 | 199701530 199701530 | ||
31574 | 31574 | 8 | 494 494 | 199701559 199701559 | ||
32039 | 32039 | 41 | 494 494 | 199701543 199701543 | ||
32295 | 32295 | 42 | 494 494 | 199701528 199701528 | ||
32720 | 32720 | 20 | 494 494 | 199701588 199701588 |
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");