Vorgaenge

40 rows where siz_nr = 484

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
629 629 24 484 484 2000/02/24G ERL 199700324 199700324
965 965 5 484 484 2000/02/10G GEW 199701458 199701458
1889 1889 11 484 484 2000/02/13G ZUS 199701422 199701422
1992 1992 29 484 484 2000/02/15G MUE 199701433 199701433
2344 2344 26 484 484 2000/02/21G UEB an RR 199701428 199701428
3496 3496 39 484 484 2000/02/19G SCR 199701407 199701407
6526 6526 14 484 484 2000/02/01G BUE 199701402 199701402
6865 6865 13 484 484 2000/02/23G ERL 199700205 199700205
7245 7245 22 484 484 2000/02/19Gf SCR 199701405 199701405
8585 8585 25 484 484 2000/02/21Gf UEB an RR 199701426 199701426
8694 8694 35 484 484 2000/02/04G KTS 199701444 199701444
9638 9638 3 484 484 2000/02/08G GEW 199701456 199701456
9890 9890 20 484 484 2000/02/19Ge SCR 199701412 199701412
9946 9946 38 484 484 2000/02/21Ge NUE 199701427 199701427
12738 12738 37 484 484 2000/02/18G UEB an RR 199701170 199701170
13157 13157 17 484 484 2000/02/26G KTS 199701309 199701309
14628 14628 36 484 484 2000/02/21Gd NUE 199701431 199701431
15332 15332 23 484 484 2000/02/03G KTS 199701436 199701436
15763 15763 33 484 484 2000/02/19Gd SCR 199701399 199701399
16431 16431 4 484 484 2000/02/09G GEW 199701457 199701457
17388 17388 1 484 484 2000/02/15Gb MUE 199701455 199701455
20004 20004 34 484 484 2000/02/19Gc SCR 199701404 199701404
20186 20186 6 484 484 2000/02/11G GEW 199701459 199701459
20205 20205 10 484 484 2000/02/06G KTS 199700989 199700989
20765 20765 40 484 484 2000/02/15Ga MUE 199701460 199701460
21352 21352 15 484 484 2000/02/20G ZUS 199701414 199701414
22812 22812 21 484 484 2000/02/19Gb SCR 199701413 199701413
23395 23395 18 484 484 2000/02/21Gc NUE 199701424 199701424
24480 24480 31 484 484 2000/02/16G URS an RR 199701394 199701394
25580 25580 30 484 484 2000/02/02G KTS 199701435 199701435
26609 26609 16 484 484 2000/02/12G ZUS 199701351 199701351
26631 26631 19 484 484 2000/02/19Ga SCR 199701411 199701411
26699 26699 8 484 484 2000/02/07G KTS 199701051 199701051
26795 26795 9 484 484 2000/02/25G STL an RR 199700161 199700161
26859 26859 28 484 484 2000/02/21Gb UEB an RR 199701429 199701429
29405 29405 2 484 484 2000/02/05G STL an RR 198802629 198802629
29481 29481 27 484 484 2000/02/21Ga UEB an RR 199701430 199701430
29641 29641 12 484 484 2000/02/14G ZUS 199701421 199701421
31628 31628 7 484 484 2000/02/22G ERL 199700246 199700246
32368 32368 32 484 484 2000/02/17G NUE an RR 199701393 199701393

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