Vorgaenge

27 rows where siz_nr = 561

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
1006 1006 11 561 561 02/11/16bG KTS 200100454 200100454
4537 4537 26 561 561 02/11/02G GEW 200100488 200100488
6472 6472 19 561 561 02/11/04G KTS 200100472 200100472
7119 7119 18 561 561 02/11/09G MUE 200100470 200100470
7707 7707 12 561 561 02/11/03G UEB an PETK 200100456 200100456
7945 7945 23 561 561 02/11/11G ZUS 200100387 200100387
8015 8015 4 561 561 02/11/15G ZUS 200100222 200100222
8653 8653 16 561 561 02/11/01G BUE 200100431 200100431
9255 9255 27 561 561 02/11/09Gd MUE 200100490 200100490
9710 9710 2 561 561 02/11/09Gc MUE 200100491 200100491
9944 9944 3 561 561 02/11/13G ZUS 200100331 200100331
10245 10245 13 561 561 02/11/07bG ERL 199201910 199201910
10276 10276 24 561 561 02/11/12G ZUS 200100388 200100388
10370 10370 1 561 561 02/11/06G KTS 200100487 200100487
13117 13117 6 561 561 02/11/09Gb MUE 200100492 200100492
13268 13268 10 561 561 02/11/07bGd ERL 199202701 199202701
15455 15455 22 561 561 02/11/10G ZUS 200100329 200100329
15653 15653 7 561 561 02/11/16aG STL an REGK 199203516 199203516
16775 16775 15 561 561 02/11/14G ZUS 200100434 200100434
18430 18430 25 561 561 02/11/15Ga ERL 198000101 198000101
18815 18815 8 561 561 02/11/07bGc ERL 199700248 199700248
19155 19155 9 561 561 02/11/07bGb ERL 199201909 199201909
19743 19743 21 561 561 02/11/08G ZUA 200100334 200100334
21334 21334 5 561 561 02/11/07bGa ERL 199701856 199701856
21496 21496 14 561 561 02/11/07G ZUS 200100245 200100245
26221 26221 17 561 561 02/11/09Ga MUE 200100469 200100469
30744 30744 20 561 561 02/11/05G KTS 200100473 200100473

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