Vorgaenge

39 rows where siz_nr = 423

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
148 148 32 423 423 98/20/19.04G ERL 198400510 198400510
268 268 7 423 423 98/20/02G KTS 199700583 199700583
667 667 6 423 423 98/20/09G ZUA 199700574 199700574
1536 1536 37 423 423 98/20/23bG UEB an RR 199700640 199700640
2640 2640 3 423 423 98/20/13G ZUS 199700581 199700581
3402 3402 15 423 423 98/20/16.01G UEB an RR 199700559 199700559
3962 3962 24 423 423 98/20/18G ZUA 199202988 199202988
4381 4381 23 423 423 98/20/12G ZUS 199700608 199700608
4389 4389 16 423 423 98/20/17G SCR 199700588 199700588
4536 4536 9 423 423 98/20/04G KTS 199700165 199700165
5573 5573 12 423 423 98/20/17Gi SCR 199700576 199700576
6439 6439 18 423 423 98/20/17Gh SCR 199700590 199700590
7377 7377 10 423 423 98/20/05G KTS 199700610 199700610
8655 8655 31 423 423 98/20/10G ZUS 199700580 199700580
8679 8679 30 423 423 98/20/06G KTS 199700626 199700626
9570 9570 22 423 423 98/20/15G MUE 199700623 199700623
10589 10589 2 423 423 98/20/11G ZUS 199700579 199700579
12171 12171 36 423 423 98/20/17Gg SCR 199700575 199700575
13833 13833 13 423 423 98/20/17Gf SCR 199700577 199700577
14383 14383 34 423 423 98/20/17Ge SCR 199700578 199700578
15776 15776 38 423 423 98/20/19.01G STL an RR 198802483 198802483
15893 15893 19 423 423 98/20/17Gd SCR 199700592 199700592
15919 15919 4 423 423 98/20/20G ERL 199203305 199203305
17291 17291 1 423 423 98/20/19.03G STL an RR 198802671 198802671
19529 19529 33 423 423 98/20/03G STL an RR 199203155 199203155
22760 22760 39 423 423 98/20/19.02G STL an RR 199202768 199202768
23680 23680 26 423 423 98/20/22G STL an RR 199203187 199203187
23711 23711 20 423 423 98/20/15Gb MUE 199700614 199700614
24286 24286 29 423 423 98/20/23cG UEB an RR 199700641 199700641
25997 25997 17 423 423 98/20/17Gc SCR 199700589 199700589
26919 26919 25 423 423 98/20/14G ERL 199700309 199700309
27354 27354 8 423 423 98/20/08G UEB an FKOM 199700584 199700584
29695 29695 21 423 423 98/20/15Ga MUE 199700618 199700618
30037 30037 14 423 423 98/20/21G ERL 199203426 199203426
31128 31128 28 423 423 98/20/23aG UEB an RR 199700639 199700639
31220 31220 11 423 423 98/20/17Gb SCR 199700572 199700572
31647 31647 35 423 423 98/20/17Ga SCR 199700593 199700593
31911 31911 5 423 423 98/20/14Ga ZUS 199700570 199700570
32688 32688 27 423 423 98/20/07G KTS 199700638 199700638

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