Vorgaenge
39 rows where siz_nr = 424
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
421 | 421 | 17 | 424 424 | 199700618 199700618 | ||
569 | 569 | 1 | 424 424 | 199700596 199700596 | ||
1643 | 1643 | 3 | 424 424 | 199700522 199700522 | ||
3015 | 3015 | 24 | 424 424 | 199700595 199700595 | ||
3352 | 3352 | 7 | 424 424 | 199700597 199700597 | ||
4454 | 4454 | 38 | 424 424 | 199700640 199700640 | ||
4574 | 4574 | 32 | 424 424 | 199700641 199700641 | ||
5304 | 5304 | 41 | 424 424 | 199700583 199700583 | ||
5436 | 5436 | 40 | 424 424 | 199700604 199700604 | ||
6361 | 6361 | 39 | 424 424 | 199700579 199700579 | ||
6803 | 6803 | 21 | 424 424 | 199700622 199700622 | ||
9240 | 9240 | 9 | 424 424 | 199700600 199700600 | ||
9474 | 9474 | 25 | 424 424 | 199700609 199700609 | ||
9654 | 9654 | 31 | 424 424 | 199700639 199700639 | ||
10021 | 10021 | 26 | 424 424 | 199700613 199700613 | ||
10763 | 10763 | 34 | 424 424 | 199700580 199700580 | ||
11989 | 11989 | 29 | 424 424 | 199700625 199700625 | ||
12209 | 12209 | 15 | 424 424 | 199700616 199700616 | ||
13496 | 13496 | 20 | 424 424 | 199700621 199700621 | ||
14918 | 14918 | 4 | 424 424 | 199700165 199700165 | ||
15545 | 15545 | 8 | 424 424 | 199700598 199700598 | ||
15701 | 15701 | 30 | 424 424 | 199700638 199700638 | ||
15787 | 15787 | 13 | 424 424 | 199700605 199700605 | ||
16991 | 16991 | 14 | 424 424 | 199700614 199700614 | ||
18101 | 18101 | 19 | 424 424 | 199700620 199700620 | ||
18864 | 18864 | 10 | 424 424 | 199700601 199700601 | ||
19019 | 19019 | 12 | 424 424 | 199700603 199700603 | ||
19341 | 19341 | 18 | 424 424 | 199700619 199700619 | ||
19858 | 19858 | 2 | 424 424 | 199700617 199700617 | ||
20204 | 20204 | 37 | 424 424 | 199700612 199700612 | ||
20360 | 20360 | 36 | 424 424 | 199700624 199700624 | ||
24766 | 24766 | 33 | 424 424 | 199700626 199700626 | ||
25276 | 25276 | 23 | 424 424 | 199700608 199700608 | ||
27441 | 27441 | 5 | 424 424 | 199700610 199700610 | ||
27915 | 27915 | 11 | 424 424 | 199700602 199700602 | ||
28090 | 28090 | 22 | 424 424 | 199700623 199700623 | ||
28943 | 28943 | 28 | 424 424 | 199202988 199202988 | ||
30793 | 30793 | 35 | 424 424 | 199700594 199700594 | ||
31802 | 31802 | 27 | 424 424 | 199700611 199700611 |
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");