Vorgaenge
37 rows where siz_nr = 506
This data as json, copyable, CSV (advanced)
Suggested facets: Vermerk
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
576 | 576 | 12 | 506 506 | 00/37/09G | KTS | 199701676 199701676 |
1219 | 1219 | 7 | 506 506 | 00/37/21G | MUE | 199701709 199701709 |
2032 | 2032 | 1 | 506 506 | 00/37/07G | UEB an PETK | 199701679 199701679 |
2685 | 2685 | 15 | 506 506 | 00/37/16G | ZUS | 199701693 199701693 |
3297 | 3297 | 11 | 506 506 | 00/37/08G | KTS | 199701680 199701680 |
3915 | 3915 | 3 | 506 506 | 00/37/06G | KTS | 199701682 199701682 |
5360 | 5360 | 4 | 506 506 | 00/37/04G | KTS | 199701708 199701708 |
6737 | 6737 | 27 | 506 506 | 00/37/10aG | STL an RR | 199700603 199700603 |
7130 | 7130 | 19 | 506 506 | 00/37/17G | UEB an RPLK | 199701667 199701667 |
7250 | 7250 | 30 | 506 506 | 00/37/25G | ERL | 199700647 199700647 |
7812 | 7812 | 35 | 506 506 | 00/37/22G | ZUS | 199700612 199700612 |
8658 | 8658 | 26 | 506 506 | 00/37/27G | ERL | 199700416 199700416 |
11187 | 11187 | 22 | 506 506 | 00/37/02G | GES an KANZ | 199701706 199701706 |
12152 | 12152 | 9 | 506 506 | 00/37/21Gf | MUE | 199701719 199701719 |
12344 | 12344 | 20 | 506 506 | 00/37/14G | ZUS | 199701683 199701683 |
12925 | 12925 | 14 | 506 506 | 00/37/03G | KTS | 199701715 199701715 |
13419 | 13419 | 25 | 506 506 | 00/37/27Ga | ERL | 199700415 199700415 |
14264 | 14264 | 2 | 506 506 | 00/37/28G | ERL | 199700656 199700656 |
17138 | 17138 | 33 | 506 506 | 00/37/11G | KTS | 199701589 199701589 |
17668 | 17668 | 6 | 506 506 | 00/37/21Ge | MUE | 199701670 199701670 |
18795 | 18795 | 34 | 506 506 | 00/37/12G | BUE | 199701692 199701692 |
19297 | 19297 | 28 | 506 506 | 00/37/19G | ERL | 199203173 199203173 |
19838 | 19838 | 29 | 506 506 | 00/37/24G | ERL | 199700857 199700857 |
22619 | 22619 | 23 | 506 506 | 00/37/10bG | STL an RR | 199700531 199700531 |
23813 | 23813 | 18 | 506 506 | 00/37/18G | ZUS | 199701705 199701705 |
23879 | 23879 | 10 | 506 506 | 00/37/21Gd | MUE | 199701721 199701721 |
24094 | 24094 | 16 | 506 506 | 00/37/05G | UEB an RPLK | 199701697 199701697 |
25478 | 25478 | 21 | 506 506 | 00/37/19Ga | ZUS | 199701707 199701707 |
25624 | 25624 | 36 | 506 506 | 00/37/21Gc | MUE | 199701725 199701725 |
27313 | 27313 | 8 | 506 506 | 00/37/21Gb | MUE | 199701710 199701710 |
27368 | 27368 | 5 | 506 506 | 00/37/17Ga | UEB an RPLK | 199701585 199701585 |
27921 | 27921 | 37 | 506 506 | 00/37/21Ga | MUE | 199701681 199701681 |
28673 | 28673 | 24 | 506 506 | 00/37/26G | ERL | 199700147 199700147 |
29099 | 29099 | 13 | 506 506 | 00/37/15G | ZUS | 199701677 199701677 |
29390 | 29390 | 17 | 506 506 | 00/37/23G | ZUS | 199701694 199701694 |
29966 | 29966 | 32 | 506 506 | 00/37/13G | GEW | 199701703 199701703 |
33086 | 33086 | 31 | 506 506 | 00/37/20G | ZUS | 199701696 199701696 |
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");