Vorgaenge

28 rows where siz_nr = 308

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
672 672 5 308 308 95/11/02G   198802654 198802654
704 704 12 308 308 95/11/19G   199202412 199202412
1487 1487 28 308 308 95/11/12G   198802222 198802222
1861 1861 25 308 308 95/11/12Gc   198802237 198802237
2678 2678 17 308 308 95/11/04G   199203081 199203081
4314 4314 19 308 308 95/11/15bG UEB an RPLK 199202423 199202423
4739 4739 16 308 308 95/11/18G   199202481 199202481
6282 6282 8 308 308 95/11/03aG   199202426 199202426
11579 11579 14 308 308 95/11/16G   199202415 199202415
12306 12306 2 308 308 95/11/08G   199202468 199202468
13813 13813 13 308 308 95/11/17G   199202445 199202445
13932 13932 9 308 308 95/11/06G KTS 198802697 198802697
14456 14456 21 308 308 95/11/10G   199202431 199202431
15157 15157 11 308 308 95/11/07aG   199202437 199202437
17435 17435 26 308 308 95/11/12Gb   199202297 199202297
18770 18770 27 308 308 95/11/03cG   199202428 199202428
19122 19122 24 308 308 95/11/06Ga   199202461 199202461
20725 20725 23 308 308 95/11/18Gb   199202479 199202479
24444 24444 15 308 308 95/11/18Ga   199202477 199202477
24503 24503 20 308 308 95/11/11G   199202459 199202459
24897 24897 10 308 308 95/11/14G   199202289 199202289
26643 26643 3 308 308 95/11/03bG   199202429 199202429
29699 29699 1 308 308 95/11/12Ga   198400455 198400455
30259 30259 4 308 308 95/11/09G   199202466 199202466
30280 30280 18 308 308 95/11/07bG   199202435 199202435
30360 30360 22 308 308 95/11/05G   199202432 199202432
31273 31273 7 308 308 95/11/13G   199202373 199202373
33029 33029 6 308 308 95/11/15aG UEB an RPLK 198800547 198800547

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