Vorgaenge
55 rows where siz_nr = 208
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
372 | 372 | 40 | 208 208 | 92/20/09G | 198802198 198802198 | |
1303 | 1303 | 35 | 208 208 | 92/20/09Gf | 198802213 198802213 | |
2017 | 2017 | 6 | 208 208 | 92/20/31cG | 199201611 199201611 | |
2018 | 2018 | 51 | 208 208 | 92/20/11G | 198800635 198800635 | |
2874 | 2874 | 50 | 208 208 | 92/20/13.2G | 198800634 198800634 | |
3313 | 3313 | 27 | 208 208 | 92/20/31dG | 199201612 199201612 | |
3797 | 3797 | 46 | 208 208 | 92/20/15G | 198800729 198800729 | |
3802 | 3802 | 21 | 208 208 | 92/20/08G | 199201559 199201559 | |
3812 | 3812 | 17 | 208 208 | 92/20/26G | 199201576 199201576 | |
3995 | 3995 | 38 | 208 208 | 92/20/06bG | 198802203 198802203 | |
4044 | 4044 | 11 | 208 208 | 92/20/06dG | 198801994 198801994 | |
4190 | 4190 | 30 | 208 208 | 92/20/31hG | 199201616 199201616 | |
4426 | 4426 | 34 | 208 208 | 92/20/09Ge | 198802212 198802212 | |
4762 | 4762 | 29 | 208 208 | 92/20/31gG | 199201615 199201615 | |
4920 | 4920 | 16 | 208 208 | 92/20/10G | 199201575 199201575 | |
5182 | 5182 | 12 | 208 208 | 92/20/30G | 199201568 199201568 | |
5687 | 5687 | 42 | 208 208 | 92/20/12G | 198400139 198400139 | |
5904 | 5904 | 20 | 208 208 | 92/20/08Gd | 199201558 199201558 | |
6556 | 6556 | 39 | 208 208 | 92/20/09Gd | 198802205 198802205 | |
8202 | 8202 | 3 | 208 208 | 92/20/09Gc | 198802211 198802211 | |
8945 | 8945 | 18 | 208 208 | 92/20/08Gc | 199201563 199201563 | |
9453 | 9453 | 53 | 208 208 | 92/20/18.2G | 198800950 198800950 | |
11104 | 11104 | 32 | 208 208 | 92/20/22G | 198801174 198801174 | |
11295 | 11295 | 37 | 208 208 | 92/20/09Gb | 198802210 198802210 | |
12146 | 12146 | 24 | 208 208 | 92/20/20G | 198801452 198801452 | |
12712 | 12712 | 28 | 208 208 | 92/20/31eG | 199201613 199201613 | |
12756 | 12756 | 43 | 208 208 | 92/20/06cG | 198801011 198801011 | |
13001 | 13001 | 33 | 208 208 | 92/20/06aG | 198802047 198802047 | |
14038 | 14038 | 4 | 208 208 | 92/20/27G | 198802163 198802163 | |
15340 | 15340 | 2 | 208 208 | 92/20/03G | 199201571 199201571 | |
16178 | 16178 | 22 | 208 208 | 92/20/08Gb | 199201560 199201560 | |
16190 | 16190 | 52 | 208 208 | 92/20/25G | 198801209 198801209 | |
16246 | 16246 | 26 | 208 208 | 92/20/31bG | 199201610 199201610 | |
16742 | 16742 | 25 | 208 208 | 92/20/31aG | 199201609 199201609 | |
17485 | 17485 | 13 | 208 208 | 92/20/01G | 199201569 199201569 | |
18065 | 18065 | 45 | 208 208 | 92/20/14G | 198800718 198800718 | |
19217 | 19217 | 10 | 208 208 | 92/20/07G | 199201574 199201574 | |
19839 | 19839 | 5 | 208 208 | 92/20/20Ga | 198801448 198801448 | |
20412 | 20412 | 48 | 208 208 | 92/20/23G | 198801121 198801121 | |
21777 | 21777 | 19 | 208 208 | 92/20/28G | 199201565 199201565 | |
22900 | 22900 | 44 | 208 208 | 92/20/21G | 198801144 198801144 | |
24499 | 24499 | 14 | 208 208 | 92/20/04G | 199201572 199201572 | |
27037 | 27037 | 1 | 208 208 | 92/20/08Ga | 199201566 199201566 | |
27333 | 27333 | 36 | 208 208 | 92/20/09Ga | 198802209 198802209 | |
27626 | 27626 | 55 | 208 208 | 92/20/19G | 198801016 198801016 | |
27731 | 27731 | 15 | 208 208 | 92/20/05G | 199201573 199201573 | |
29048 | 29048 | 9 | 208 208 | 92/20/02G | 199201570 199201570 | |
29799 | 29799 | 54 | 208 208 | 92/20/17G | 198800951 198800951 | |
30135 | 30135 | 7 | 208 208 | 92/20/31fG | 199201614 199201614 | |
31074 | 31074 | 23 | 208 208 | 92/20/27Ga | 198000105 198000105 | |
31211 | 31211 | 49 | 208 208 | 92/20/24G | 198801122 198801122 | |
32572 | 32572 | 47 | 208 208 | 92/20/18.1G | 198800735 198800735 | |
32654 | 32654 | 8 | 208 208 | 92/20/28Ga | 199201564 199201564 | |
32805 | 32805 | 31 | 208 208 | 92/20/31iG | 199201617 199201617 | |
33167 | 33167 | 41 | 208 208 | 92/20/13.1G | 198800633 198800633 |
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");