Vorgaenge

57 rows where siz_nr = 435

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
22 22 13 435 435 98/42/34G   199203509 199203509
468 468 2 435 435 98/42/22G   199700766 199700766
975 975 44 435 435 98/42/08G KTS 199700673 199700673
1415 1415 53 435 435 98/42/02G KTS 199700810 199700810
1461 1461 48 435 435 98/42/07G KTS 199700797 199700797
1721 1721 30 435 435 98/42/33G SCR 199700732 199700732
1778 1778 7 435 435 98/42/19G ZUS 199700768 199700768
2447 2447 3 435 435 98/42/12G ZUS 199700723 199700723
2913 2913 23 435 435 98/42/33Gp SCR 199700705 199700705
3584 3584 54 435 435 98/42/33Go SCR 199700668 199700668
3661 3661 36 435 435 98/42/15G MUE 199700801 199700801
4081 4081 57 435 435 98/42/11G ZUS 199700716 199700716
6130 6130 1 435 435 98/42/35G STL an RR 198000101 198000101
6166 6166 37 435 435 98/42/15Gb MUE 199700802 199700802
7759 7759 46 435 435 98/42/18G ZUS 199700730 199700730
7830 7830 35 435 435 98/42/09G GEW 199700796 199700796
8136 8136 16 435 435 98/42/33Gn SCR 199700683 199700683
8554 8554 51 435 435 98/42/33Gm SCR 199700726 199700726
9299 9299 17 435 435 98/42/33Gl SCR 199700684 199700684
9811 9811 15 435 435 98/42/13G UEB an RR 199700701 199700701
9987 9987 56 435 435 98/42/25G   199700738 199700738
10256 10256 14 435 435 98/42/37G   199203513 199203513
10681 10681 11 435 435 98/42/24G   199700783 199700783
12118 12118 27 435 435 98/42/33Gk SCR 199700725 199700725
12417 12417 43 435 435 98/42/23bG   199700256 199700256
12517 12517 9 435 435 98/42/14G ZUS 199700765 199700765
12534 12534 12 435 435 98/42/29Ga   199203480 199203480
12669 12669 20 435 435 98/42/33Gj SCR 199700746 199700746
13131 13131 25 435 435 98/42/33Gi SCR 199700714 199700714
13518 13518 18 435 435 98/42/32.01G UEB an RR 199700695 199700695
15154 15154 29 435 435 98/42/33Gh SCR 199700728 199700728
15198 15198 52 435 435 98/42/15Ga MUE 199700799 199700799
15393 15393 4 435 435 98/42/23aG   199700722 199700722
15611 15611 39 435 435 98/42/36Ga   199203431 199203431
16137 16137 26 435 435 98/42/32.04G UEB an RR 199700729 199700729
16520 16520 21 435 435 98/42/33Gg SCR 199700747 199700747
16724 16724 28 435 435 98/42/33Gf SCR 199700727 199700727
16916 16916 42 435 435 98/42/31Ga   199203566 199203566
16979 16979 31 435 435 98/42/33Ge SCR 199700742 199700742
17097 17097 50 435 435 98/42/32.03G UEB an RR 199700758 199700758
18689 18689 22 435 435 98/42/33Gd SCR 199700749 199700749
19396 19396 8 435 435 98/42/17G ZUS 199700767 199700767
20236 20236 40 435 435 98/42/26Ga   199700699 199700699
21838 21838 10 435 435 98/42/16G ZUS 199700765 199700765
22297 22297 55 435 435 98/42/28Ga   199700557 199700557
22767 22767 5 435 435 98/42/27G   199700753 199700753
23753 23753 6 435 435 98/42/04G KTS 199700736 199700736
24302 24302 32 435 435 98/42/06G STL an RR 199203253 199203253
24611 24611 24 435 435 98/42/33Gc SCR 199700713 199700713
25473 25473 34 435 435 98/42/10G ZUS 199700792 199700792
26299 26299 41 435 435 98/42/30G   199203451 199203451
28244 28244 49 435 435 98/42/19.02G ERL 199700208 199700208
29913 29913 45 435 435 98/42/33Gb SCR 199700682 199700682
30017 30017 33 435 435 98/42/03G UEB an PETK 199700771 199700771
31178 31178 19 435 435 98/42/32.02G UEB an RR 199700704 199700704
32034 32034 38 435 435 98/42/19.01G ERL 199203765 199203765
32802 32802 47 435 435 98/42/33Ga SCR 199700744 199700744

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