Vorgaenge
29 rows where siz_nr = 164
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
1667 | 1667 | 6 | 164 164 | 91/06/05bG | 198400178 198400178 | |
1821 | 1821 | 19 | 164 164 | 91/06/11G | 198801345 198801345 | |
3383 | 3383 | 3 | 164 164 | 91/06/19G | 198800805 198800805 | |
3465 | 3465 | 20 | 164 164 | 91/06/21G | 198801386 198801386 | |
3747 | 3747 | 12 | 164 164 | 91/06/06aG | 198801535 198801535 | |
3776 | 3776 | 11 | 164 164 | 91/06/06bG | 198801534 198801534 | |
4119 | 4119 | 25 | 164 164 | 91/06/05cG | 198801624 198801624 | |
7833 | 7833 | 14 | 164 164 | 91/06/03G | 198802464 198802464 | |
9989 | 9989 | 7 | 164 164 | 91/06/20G | 198801364 198801364 | |
10019 | 10019 | 28 | 164 164 | 91/06/05aG | 198801573 198801573 | |
11131 | 11131 | 15 | 164 164 | 91/06/07G | 198801890 198801890 | |
11498 | 11498 | 5 | 164 164 | 91/06/12G | 198800870 198800870 | |
11710 | 11710 | 10 | 164 164 | 91/06/01G | 198801430 198801430 | |
11969 | 11969 | 2 | 164 164 | 91/06/22G | 198400453 198400453 | |
12916 | 12916 | 8 | 164 164 | 91/06/10G | 198801409 198801409 | |
14980 | 14980 | 13 | 164 164 | 91/06/09G | 198802331 198802331 | |
17211 | 17211 | 4 | 164 164 | 91/06/04G | 198400479 198400479 | |
18037 | 18037 | 1 | 164 164 | 91/06/22Gb | 198400211 198400211 | |
18420 | 18420 | 9 | 164 164 | 91/06/08G | 198801676 198801676 | |
21394 | 21394 | 29 | 164 164 | 91/06/17G | 198800852 198800852 | |
21812 | 21812 | 26 | 164 164 | 91/06/06eG | 198801713 198801713 | |
21977 | 21977 | 23 | 164 164 | 91/06/16G | 198400400 198400400 | |
24760 | 24760 | 27 | 164 164 | 91/06/06cG | 198801570 198801570 | |
24821 | 24821 | 24 | 164 164 | 91/06/06dG | 198801576 198801576 | |
25659 | 25659 | 21 | 164 164 | 91/06/22Ga | 198801388 198801388 | |
28475 | 28475 | 16 | 164 164 | 91/06/14G | 198801395 198801395 | |
28980 | 28980 | 18 | 164 164 | 91/06/18G | 198801399 198801399 | |
30045 | 30045 | 22 | 164 164 | 91/06/13G | 198801389 198801389 | |
30488 | 30488 | 17 | 164 164 | 91/06/15G | 198801396 198801396 |
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");