Vorgaenge

57 rows where siz_nr = 111

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
2021 2021 28 111 111 89/26/65G   198000050 198000050
2269 2269 43 111 111 89/26/58dG   198400332 198400332
3207 3207 40 111 111 89/26/45.G   198000054 198000054
5132 5132 4 111 111 89/26/66bG   198400333 198400333
5734 5734 15 111 111 89/26/76G   198400351 198400351
6821 6821 57 111 111 89/26/58bG   198400330 198400330
7187 7187 36 111 111 89/26/57G   198400142 198400142
7526 7526 47 111 111 89/26/48bG   198400258 198400258
7844 7844 29 111 111 89/26/48aG   198400469 198400469
8011 8011 52 111 111 89/26/62G   198400298 198400298
8183 8183 24 111 111 89/26/79bG   198400224 198400224
8539 8539 8 111 111 89/26/70/1G   198000053 198000053
8577 8577 39 111 111 89/26/52bG   198000033 198000033
8854 8854 16 111 111 89/26/54G   198400284 198400284
9141 9141 13 111 111 89/26/67G   198400263 198400263
9171 9171 38 111 111 89/26/70/3G   198400188 198400188
9556 9556 5 111 111 89/26/46aG   198000059 198000059
9779 9779 48 111 111 89/26/72G   198400295 198400295
9867 9867 30 111 111 89/26/60aG   198400470 198400470
10203 10203 25 111 111 89/26/66aG   198400389 198400389
10793 10793 35 111 111 89/26/52aG   198000033 198000033
11092 11092 21 111 111 89/26/41.6G   199201541 199201541
11231 11231 23 111 111 89/26/47G   198400339 198400339
11339 11339 31 111 111 89/26/60bG   198400471 198400471
11408 11408 12 111 111 89/26/51G   198400261 198400261
12493 12493 18 111 111 89/29/41.2G   198000034 198000034
12949 12949 51 111 111 89/26/71G   198400267 198400267
13399 13399 53 111 111 89/26/56G   198400303 198400303
13988 13988 46 111 111 89/26/53G   198400283 198400283
14524 14524 44 111 111 89/26/41.3G   198000035 198000035
14786 14786 50 111 111 89/26/70/2G   198400266 198400266
14869 14869 49 111 111 89/29/41.1G   199201540 199201540
16888 16888 11 111 111 89/26/55G   198400165 198400165
17165 17165 1 111 111 89/26/81G   198400199 198400199
18480 18480 17 111 111 89/26/61G   198400287 198400287
18552 18552 10 111 111 89/26/78G   198400162 198400162
18768 18768 32 111 111 89/26/42.G   198400184 198400184
20722 20722 37 111 111 89/26/75G   198400186 198400186
21284 21284 45 111 111 89/26/80G   198400277 198400277
22231 22231 56 111 111 89/26/79aG   198400251 198400251
22679 22679 27 111 111 89/26/44.G   198400240 198400240
24914 24914 54 111 111 89/26/58aG   198000058 198000058
25253 25253 42 111 111 89/26/82G   198400352 198400352
25791 25791 34 111 111 89/26/52cG   198000033 198000033
26215 26215 7 111 111 89/26/43.G   198000052 198000052
26701 26701 14 111 111 89/26/68G   198400264 198400264
27297 27297 20 111 111 89/26/41.5G   198000084 198000084
27762 27762 33 111 111 89/26/77G   198400155 198400155
28069 28069 55 111 111 89/26/50G   198400260 198400260
28203 28203 6 111 111 89/26/46bG   198400334 198400334
28910 28910 3 111 111 89/26/58cG   198400331 198400331
30732 30732 19 111 111 89/26/41.4G   198000036 198000036
31135 31135 9 111 111 89/26/69G   198400209 198400209
31549 31549 22 111 111 89/26/73G   198400338 198400338
31590 31590 26 111 111 89/26/49G   198400121 198400121
31780 31780 2 111 111 89/26/64G   198400336 198400336
33052 33052 41 111 111 89/26/63G   198400299 198400299

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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");