Vorgaenge

51 rows where siz_nr = 426

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
38 38 19 426 426 98/23/11.17G UEB an STEK 199203760 199203760
1237 1237 37 426 426 98/23/11.06G UEB an STEK 199700109 199700109
1746 1746 47 426 426 98/23/17G SCR 199700624 199700624
2202 2202 51 426 426 98/23/11.02G UEB an STEK 199202859 199202859
2216 2216 22 426 426 98/23/17Gi SCR 199700600 199700600
2937 2937 32 426 426 98/23/17Gh SCR 199700619 199700619
3162 3162 5 426 426 98/23/11.03G UEB an STEK 199700233 199700233
5529 5529 34 426 426 98/23/17Gg SCR 199700621 199700621
5894 5894 29 426 426 98/23/15.03G UEB an RR 199700603 199700603
6263 6263 9 426 426 98/23/13G ZUS 199700535 199700535
6633 6633 27 426 426 98/23/06G KTS 199700633 199700633
6851 6851 45 426 426 98/23/12G KTS 199700594 199700594
8062 8062 38 426 426 98/23/11.12G UEB an STEK 199700305 199700305
8107 8107 14 426 426 98/23/11.08G UEB an STEK 199203665 199203665
8676 8676 1 426 426 98/23/11.05G UEB an STEK 199202956 199202956
9096 9096 35 426 426 98/23/17Gf SCR 199700622 199700622
9457 9457 42 426 426 98/23/09G KTS 199700663 199700663
10488 10488 7 426 426 98/23/11.04G UEB an STEK 199202636 199202636
10990 10990 44 426 426 98/23/08G KTS 199700662 199700662
11431 11431 16 426 426 98/23/11.13G UEB an STEK 199203218 199203218
11460 11460 30 426 426 98/23/15.05G NUE 199700605 199700605
12159 12159 23 426 426 98/23/15.01G NUE 199700601 199700601
13354 13354 26 426 426 98/23/19G ZUS 199700611 199700611
14921 14921 33 426 426 98/23/17Ge SCR 199700620 199700620
15113 15113 24 426 426 98/23/11G UEB an STEK 199700628 199700628
16335 16335 25 426 426 98/23/01G BUE 199700609 199700609
16446 16446 41 426 426 98/23/04G UEB an PETK 199700642 199700642
16864 16864 46 426 426 98/23/11.14G UEB an STEK 199203794 199203794
17615 17615 10 426 426 98/23/18G UEB an BESK 199700596 199700596
18052 18052 11 426 426 98/23/07G KTS 199700649 199700649
18115 18115 39 426 426 98/23/17Gd SCR 199700625 199700625
18713 18713 8 426 426 98/23/16G UEB an RR 199700271 199700271
19508 19508 6 426 426 98/23/11.01G UEB an STEK 199202629 199202629
19679 19679 17 426 426 98/23/18Gb UEB an BESK 199203700 199203700
19692 19692 40 426 426 98/23/03G UEB an PETK 199700661 199700661
20796 20796 49 426 426 98/23/15.04G UEB an RR 199700604 199700604
20855 20855 28 426 426 98/23/15.02G UEB an RR 199700602 199700602
20981 20981 21 426 426 98/23/17Gc SCR 199700598 199700598
21043 21043 48 426 426 98/23/02G ZUS 199700612 199700612
21778 21778 36 426 426 98/23/11.16G UEB an STEK 199203377 199203377
21888 21888 43 426 426 98/23/10G KTS 199700664 199700664
22163 22163 15 426 426 98/23/11.07G UEB an STEK 199203143 199203143
22268 22268 12 426 426 98/23/11.15G UEB an STEK 199203082 199203082
22805 22805 18 426 426 98/23/11.11G UEB an STEK 199203739 199203739
23737 23737 50 426 426 98/23/17Gb SCR 199700617 199700617
24115 24115 31 426 426 98/23/17Ga SCR 199700616 199700616
25203 25203 2 426 426 98/23/11.09G UEB an STEK 199700304 199700304
26537 26537 20 426 426 98/23/14.01G NUE 199700597 199700597
27235 27235 3 426 426 98/23/05G STL an RR 199202852 199202852
28427 28427 13 426 426 98/23/11.10G UEB an STEK 199203207 199203207
32897 32897 4 426 426 98/23/18Ga UEB an BESK 199700225 199700225

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