Vorgaenge

34 rows where siz_nr = 558

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
5603 5603 23 558 558 02/09/19.03G URS an RR 200100422 200100422
7073 7073 32 558 558 02/09/08G KTS 200100423 200100423
7433 7433 24 558 558 02/09/13G ZUS 200100427 200100427
8362 8362 28 558 558 02/09/01G BUE 200100404 200100404
8833 8833 7 558 558 02/09/07G STL an RR 199701537 199701537
10959 10959 18 558 558 02/09/11G WAH 200100430 200100430
11206 11206 29 558 558 02/09/01Ga BUE 200100405 200100405
11825 11825 19 558 558 02/09/03G UEB an PEGE 200100406 200100406
12678 12678 33 558 558 02/09/09G KTS 200100428 200100428
13831 13831 13 558 558 02/09/03Gg UEB an PEGE 198000096 198000096
14606 14606 30 558 558 02/09/12G WAH 200100407 200100407
15378 15378 21 558 558 02/09/02G UEB an PETK 200100410 200100410
15589 15589 6 558 558 02/09/13Ge KTS 200100420 200100420
15747 15747 17 558 558 02/09/06bG KTS 199701926 199701926
16709 16709 25 558 558 02/09/13Gd KTS 200100426 200100426
17052 17052 26 558 558 02/09/14G GEW 200100485 200100485
18545 18545 31 558 558 02/09/13Gc ZUS 200100424 200100424
18875 18875 11 558 558 02/09/06aG KTS 199700991 199700991
19686 19686 4 558 558 02/09/04G UEB an BRK 200100413 200100413
22608 22608 2 558 558 02/09/09Gc KTS 200100429 200100429
23301 23301 22 558 558 02/09/19.02G URS an RR 200100421 200100421
24225 24225 8 558 558 02/09/09Gb KTS 200100483 200100483
25086 25086 16 558 558 02/09/03Gf UEB an PEGE 199202778 199202778
27095 27095 20 558 558 02/09/02Ga UEB an PETK 200100409 200100409
28450 28450 12 558 558 02/09/06cG KTS 199701859 199701859
28544 28544 10 558 558 02/09/03Ge UEB an PEGE 199202639 199202639
29869 29869 15 558 558 02/09/09Ga KTS 200100484 200100484
30964 30964 5 558 558 02/09/03Gd UEB an PEGE 199203831 199203831
31706 31706 34 558 558 02/09/13Gb KTS 200100425 200100425
32156 32156 9 558 558 02/09/05G UEB an GSK 200100412 200100412
32529 32529 1 558 558 02/09/03Gc UEB an PEGE 198000097 198000097
32608 32608 14 558 558 02/09/03Gb UEB an PEGE 198400491 198400491
32929 32929 3 558 558 02/09/03Ga UEB an PEGE 199700023 199700023
32960 32960 27 558 558 02/09/13Ga KTS 200100365 200100365

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