Vorgaenge
51 rows where siz_nr = 76
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
135 | 135 | 4 | 76 76 | 88/37/13G | 198802223 198802223 | |
571 | 571 | 24 | 76 76 | 88/37/14pG | 198400273 198400273 | |
1556 | 1556 | 27 | 76 76 | 88/37/15G | 198800561 198800561 | |
2124 | 2124 | 37 | 76 76 | 88/37/18G | 198800665 198800665 | |
2233 | 2233 | 3 | 76 76 | 88/37/14dG | 198400149 198400149 | |
5341 | 5341 | 12 | 76 76 | 88/37/14bG | 198400268 198400268 | |
5668 | 5668 | 28 | 76 76 | 88/37/14jG | 198400276 198400276 | |
6522 | 6522 | 38 | 76 76 | 88/37/05G | 198800496 198800496 | |
6932 | 6932 | 46 | 76 76 | 88/37/24gG | 198800655 198800655 | |
7953 | 7953 | 17 | 76 76 | 88/37/24dG | 198800652 198800652 | |
7989 | 7989 | 48 | 76 76 | 88/37/01G | 198800663 198800663 | |
8050 | 8050 | 43 | 76 76 | 88/37/14hG | 198400274 198400274 | |
8058 | 8058 | 32 | 76 76 | 88/37/04G | 198800565 198800565 | |
9258 | 9258 | 10 | 76 76 | 88/37/01Gb | 198800532 198800532 | |
10433 | 10433 | 44 | 76 76 | 88/37/11G | 199201546 199201546 | |
11130 | 11130 | 6 | 76 76 | 88/37/09G | 198800513 198800513 | |
11572 | 11572 | 36 | 76 76 | 88/37/03G | 198800664 198800664 | |
13223 | 13223 | 35 | 76 76 | 88/37/18Ga | 198800673 198800673 | |
13456 | 13456 | 47 | 76 76 | 88/37/14fG | 198400172 198400172 | |
14137 | 14137 | 5 | 76 76 | 88/37/06G | 198800511 198800511 | |
15796 | 15796 | 34 | 76 76 | 88/37/14mG | 198400279 198400279 | |
15986 | 15986 | 2 | 76 76 | 88/37/14oG | 198400182 198400182 | |
18002 | 18002 | 1 | 76 76 | 88/37/14cG | 198400195 198400195 | |
18735 | 18735 | 22 | 76 76 | 88/37/23G | 198800555 198800555 | |
18973 | 18973 | 30 | 76 76 | 88/37/14kG | 198400281 198400281 | |
19425 | 19425 | 31 | 76 76 | 88/37/01Ga | 198800661 198800661 | |
19632 | 19632 | 49 | 76 76 | 88/37/14eG | 198400262 198400262 | |
19690 | 19690 | 42 | 76 76 | 88/37/24hG | 198800656 198800656 | |
21506 | 21506 | 51 | 76 76 | 88/37/14nG | 198400147 198400147 | |
21718 | 21718 | 13 | 76 76 | 88/37/14gG | 198400270 198400270 | |
21865 | 21865 | 8 | 76 76 | 88/37/08G | 198800516 198800516 | |
22220 | 22220 | 39 | 76 76 | 88/37/05Ga | 198800496 198800496 | |
22750 | 22750 | 29 | 76 76 | 88/37/20G | 198400122 198400122 | |
23524 | 23524 | 9 | 76 76 | 88/37/14lG | 198400221 198400221 | |
24236 | 24236 | 26 | 76 76 | 88/37/14iG | 198400275 198400275 | |
24656 | 24656 | 50 | 76 76 | 88/37/19G | 198800490 198800490 | |
26050 | 26050 | 23 | 76 76 | 88/37/22G | 198800559 198800559 | |
27039 | 27039 | 11 | 76 76 | 88/37/10G | 198800536 198800536 | |
27453 | 27453 | 33 | 76 76 | 88/37/04Ga | 198800566 198800566 | |
28315 | 28315 | 21 | 76 76 | 88/37/14aG | 198400233 198400233 | |
28574 | 28574 | 19 | 76 76 | 88/37/24fG | 198800654 198800654 | |
29578 | 29578 | 25 | 76 76 | 88/37/16G | 198800560 198800560 | |
29707 | 29707 | 16 | 76 76 | 88/37/24aG | 198800650 198800650 | |
29710 | 29710 | 41 | 76 76 | 88/37/24cG | 198800651 198800651 | |
29764 | 29764 | 7 | 76 76 | 88/37/07G | 198800515 198800515 | |
29952 | 29952 | 18 | 76 76 | 88/37/24eG | 198800653 198800653 | |
30953 | 30953 | 20 | 76 76 | 88/37/21G | 198000031 198000031 | |
30969 | 30969 | 14 | 76 76 | 88/37/12G | 199201547 199201547 | |
31603 | 31603 | 40 | 76 76 | 88/37/24iG | 198800674 198800674 | |
32186 | 32186 | 45 | 76 76 | 88/35/18 | 198800648 198800648 | |
32799 | 32799 | 15 | 76 76 | 88/37/24bG | 198800649 198800649 |
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");