Vorgaenge

49 rows where siz_nr = 549

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
178 178 49 549 549 01/49/33G UEB an RR 199701748 199701748
337 337 39 549 549 01/49/18G WAH 200100292 200100292
500 500 30 549 549 01/49/28G ERL 199701922 199701922
526 526 14 549 549 01/49/15G GEW 200100338 200100338
1254 1254 22 549 549 01/49/08bG KTS 199701860 199701860
2416 2416 48 549 549 01/49/32.01G UEB an RR 200100273 200100273
3144 3144 47 549 549 01/49/07G STL an RR 198400444 198400444
3399 3399 9 549 549 01/49/27G ERL 199203704 199203704
3772 3772 12 549 549 01/49/26G ERL 199701284 199701284
5505 5505 38 549 549 01/49/08aG KTS 199701861 199701861
5830 5830 40 549 549 01/49/02G BUE 200100279 200100279
6215 6215 21 549 549 01/49/29G ERL 199700977 199700977
6451 6451 41 549 549 01/49/03G UEB an WAK 200100294 200100294
6486 6486 7 549 549 01/49/21G ZUS 200100277 200100277
6645 6645 29 549 549 01/49/31G MUE 200100328 200100328
7529 7529 35 549 549 01/49/04G UEB an BKK 200100308 200100308
8157 8157 13 549 549 01/49/31Ge MUE 200100336 200100336
9278 9278 27 549 549 01/49/30G ERL 198802558 198802558
9406 9406 24 549 549 01/49/31Gd MUE 200100348 200100348
11650 11650 44 549 549 01/49/32.05G UEB an RR 200100280 200100280
11692 11692 18 549 549 01/49/11G UEB an PETK 200100344 200100344
13765 13765 2 549 549 01/49/32.04G UEB an RR 200100283 200100283
14692 14692 34 549 549 01/49/22G ZUS 200100296 200100296
16142 16142 17 549 549 01/49/13G UEB an PETK 200100342 200100342
16648 16648 15 549 549 01/49/17G GEW 200100340 200100340
17594 17594 10 549 549 01/49/16G GEW 200100339 200100339
17654 17654 32 549 549 01/49/23G ZUS 200100152 200100152
20820 20820 31 549 549 01/49/19G ZUS 200100186 200100186
21259 21259 6 549 549 01/49/32.06G NUE 200100282 200100282
21434 21434 11 549 549 01/49/12G UEB an PETK 200100343 200100343
21980 21980 5 549 549 01/49/32.02G UEB an RR 200100274 200100274
22933 22933 33 549 549 01/49/20G ZUS 200100278 200100278
23210 23210 43 549 549 01/49/32.07G NUE 200100281 200100281
23636 23636 28 549 549 01/49/10G KTS 199701826 199701826
24237 24237 16 549 549 01/49/14G UEB an PETK 200100341 200100341
24356 24356 46 549 549 01/49/34G SCR 200100297 200100297
24469 24469 36 549 549 01/49/05G UEB an UVEK 200100321 200100321
24696 24696 25 549 549 01/49/31Gc MUE 200100349 200100349
24890 24890 45 549 549 01/49/34Gb SCR 200100289 200100289
26431 26431 4 549 549 01/49/23Ga ERL 198802267 198802267
27761 27761 20 549 549 01/49/35G ERL 199700985 199700985
28736 28736 26 549 549 01/49/31Gb MUE 200100350 200100350
28937 28937 1 549 549 01/49/06G KTS 200100346 200100346
29209 29209 37 549 549 01/49/09G KTS 200100322 200100322
29297 29297 23 549 549 01/49/31Ga MUE 200100347 200100347
29868 29868 42 549 549 01/49/32.03G UEB an RR 200100284 200100284
30310 30310 3 549 549 01/49/34Ga SCR 200100298 200100298
31334 31334 8 549 549 01/49/25G STL an RR 199700900 199700900
32199 32199 19 549 549 01/49/30Ga ERL 199203039 199203039

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