Vorgaenge

62 rows where siz_nr = 554

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
287 287 50 554 554 02/02/29G MUE 200100399 200100399
674 674 11 554 554 02/02/05G GEW 200100397 200100397
986 986 37 554 554 02/02/24G ZUS 200100321 200100321
1699 1699 3 554 554 02/02/31.05G UEB an RR 200100310 200100310
2695 2695 36 554 554 02/02/14G UEB an BRK 200100358 200100358
2987 2987 6 554 554 02/02/12G UEB an BKK 200100331 200100331
3331 3331 42 554 554 02/02/20G KTS 200100353 200100353
4104 4104 14 554 554 02/02/17bG STL an RR 199701151 199701151
4869 4869 32 554 554 02/02/31.10G UEB an RR 200100323 200100323
5092 5092 47 554 554 02/02/28G ZUS 200100363 200100363
5364 5364 35 554 554 02/02/09G UEB an BKK 199701847 199701847
5416 5416 58 554 554 02/02/18G KTS 200100379 200100379
6293 6293 31 554 554 02/02/31.08G UEB an RR 200100315 200100315
6956 6956 59 554 554 02/02/01G GEW 200100393 200100393
7956 7956 49 554 554 02/02/11G UEB an BKK 200100388 200100388
9274 9274 12 554 554 02/02/31.12G NUE 200100325 200100325
11252 11252 30 554 554 02/02/31.07G UEB an RR 200100313 200100313
12941 12941 43 554 554 02/02/26G ZUS 200100356 200100356
13076 13076 57 554 554 02/02/29Gc MUE 200100367 200100367
14211 14211 44 554 554 02/02/09Ge UEB an BKK 200100386 200100386
14892 14892 52 554 554 02/02/32G ERL 200100082 200100082
15941 15941 17 554 554 02/02/17aG STL an RR 199701268 199701268
16292 16292 10 554 554 02/02/19G KTS 200100389 200100389
16390 16390 38 554 554 02/02/07G UEB an BKK 200100330 200100330
16658 16658 20 554 554 02/02/33G SCR 200100351 200100351
16984 16984 29 554 554 02/02/30.01G URS an RR 200100314 200100314
17554 17554 28 554 554 02/02/31.06G NUE 200100312 200100312
17627 17627 55 554 554 02/02/29Gb MUE 200100359 200100359
17811 17811 8 554 554 02/02/23G ZUS 200100173 200100173
18279 18279 41 554 554 02/02/08G UEB an BKK 200100329 200100329
18527 18527 16 554 554 02/02/17cG STL an RR 199700161 199700161
18538 18538 33 554 554 02/02/31.11G UEB an RR 200100326 200100326
19165 19165 5 554 554 02/02/33Ge SCR 200100337 200100337
19433 19433 60 554 554 02/02/02G GEW 200100393 200100393
19456 19456 27 554 554 02/02/31.04G UEB an RR 200100311 200100311
19498 19498 7 554 554 02/02/15G UEB an UVEK 200100355 200100355
20248 20248 2 554 554 02/02/03G   200100395 200100395
20996 20996 61 554 554 02/02/04G GEW 200100395 200100395
21490 21490 48 554 554 02/02/13G UEB an BRK 200100385 200100385
21612 21612 26 554 554 02/02/31.03G UEB an RR 200100317 200100317
21660 21660 62 554 554 02/02/09Gd UEB an BKK 199701542 199701542
21707 21707 51 554 554 02/02/21G KTS 199701862 199701862
21960 21960 22 554 554 02/02/33Gd SCR 200100304 200100304
22094 22094 54 554 554 02/02/31.01G UEB an RR 200100291 200100291
22739 22739 9 554 554 02/02/22aG KTS 199701925 199701925
23075 23075 13 554 554 02/02/33Gc SCR 200100345 200100345
23624 23624 15 554 554 02/02/09Gc UEB an BKK 199701153 199701153
23758 23758 19 554 554 02/02/28Ga ERL 199202688 199202688
23794 23794 34 554 554 02/02/22bG KTS 199701924 199701924
24713 24713 45 554 554 02/02/16G UEB an FKOM 200100333 200100333
24966 24966 4 554 554 02/02/31.09G UEB an FKOM 200100324 200100324
25540 25540 56 554 554 02/02/29Ga MUE 200100362 200100362
26540 26540 23 554 554 02/02/33Gb SCR 200100306 200100306
27320 27320 18 554 554 02/02/09Gb UEB an BKK 199701857 199701857
28018 28018 24 554 554 02/02/09Ga UEB an BKK 198802630 198802630
28045 28045 25 554 554 02/02/31.02G NUE 200100316 200100316
28286 28286 21 554 554 02/02/33Ga SCR 200100303 200100303
28325 28325 40 554 554 02/02/06G UEB an BKK 200100334 200100334
29499 29499 46 554 554 02/02/10G UEB an BKK 200100387 200100387
29804 29804 53 554 554 02/02/25G ZUS 200100270 200100270
30374 30374 39 554 554 02/02/27G ZUS 200100357 200100357
32794 32794 1 554 554 02/02/14Ga UEB an BRK 198802629 198802629

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