Vorgaenge

34 rows where siz_nr = 353

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
620 620 3 353 353 96/23/29G ERL 199202700 199202700
1884 1884 30 353 353 96/23/24.01G URS an RR 199203550 199203550
3957 3957 9 353 353 96/23/24.02G URS an RR 199203584 199203584
4135 4135 1 353 353 96/23/23G ERL 198802307 198802307
6484 6484 8 353 353 96/23/25.11G UEB an RR 199203580 199203580
6995 6995 17 353 353 96/23/26.04G ZUR 199203568 199203568
7455 7455 18 353 353 96/23/25.06G UEB an RR 199203570 199203570
7615 7615 5 353 353 96/23/30G ERL 199202707 199202707
9595 9595 29 353 353 96/23/25.10G UEB an RR 199203581 199203581
9798 9798 20 353 353 96/23/25.08G UEB an RR 199203573 199203573
9817 9817 10 353 353 96/23/26G UEB an RR 199203337 199203337
11008 11008 15 353 353 96/23/25.02G UEB an RR 199203566 199203566
11269 11269 24 353 353 96/23/27G SCR 199203592 199203592
12097 12097 6 353 353 96/23/25.13G UEB an RR 199203578 199203578
12548 12548 34 353 353 96/23/28G ERL 199202348 199202348
18422 18422 21 353 353 96/23/25.17G UEB an RR 199203574 199203574
19468 19468 25 353 353 96/23/27Ge SCR 199203604 199203604
20588 20588 16 353 353 96/23/25.03G UEB an RR 199203567 199203567
20700 20700 31 353 353 96/23/25.05G UEB an RR 199203569 199203569
20745 20745 14 353 353 96/25/24.01G UEB an RR 199203562 199203562
22266 22266 23 353 353 96/23/25.15G UEB an RR 199203576 199203576
23625 23625 2 353 353 96/23/23Ga ZUS 199203438 199203438
23681 23681 26 353 353 96/23/27Gd SCR 199203605 199203605
24041 24041 7 353 353 96/23/25.12G UEB an RR 199203579 199203579
24183 24183 11 353 353 96/23/31bG UEB an RR 199203674 199203674
24622 24622 13 353 353 96/23/27Gc SCR 199203561 199203561
24982 24982 28 353 353 96/23/25.07G UEB an RR 199203572 199203572
25783 25783 4 353 353 96/23/29Ga ERL 198802592 198802592
27651 27651 22 353 353 96/23/25.16G UEB an RR 199203575 199203575
28732 28732 32 353 353 96/23/27Gb SCR 199203606 199203606
28863 28863 27 353 353 96/23/27Ga SCR 199203607 199203607
29399 29399 12 353 353 96/23/31aG UEB an RR 199203675 199203675
30249 30249 19 353 353 96/23/25.09G UEB an RR 199203571 199203571
31448 31448 33 353 353 96/23/25.14G UEB an RR 199203577 199203577

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