Vorgaenge

59 rows where siz_nr = 94

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
67 67 16 94 94 89/06/17G   198800499 198800499
732 732 36 94 94 89/06/04G   198800990 198800990
1354 1354 28 94 94 89/06/21.09G   198800969 198800969
1989 1989 33 94 94 89/06/21.25G   198800985 198800985
2284 2284 39 94 94 89/06/12G   198800994 198800994
2855 2855 15 94 94 89/06/21.05G   198800963 198800963
3657 3657 51 94 94 89/06/21.07G   198800967 198800967
4108 4108 23 94 94 89/06/18.04G   198400305 198400305
4274 4274 25 94 94 89/06/21.12G   198800964 198800964
5470 5470 30 94 94 89/06/21.22G   198800982 198800982
6056 6056 20 94 94 89/06/18.02G   198800685 198800685
6926 6926 50 94 94 89/06/21.04G   198800962 198800962
8213 8213 19 94 94 89/06/18.06G   198400180 198400180
8229 8229 58 94 94 89/06/21.16G   198800986 198800986
8508 8508 7 94 94 89/06/02G   198800941 198800941
8792 8792 14 94 94 89/06/21.03G   198800961 198800961
8953 8953 43 94 94 89/06/22.06G   198801001 198801001
9124 9124 12 94 94 89/06/21.01G   198800958 198800958
9622 9622 56 94 94 89/06/01.03G   198800955 198800955
9683 9683 60 94 94 89/06/18.03G   198400222 198400222
9784 9784 54 94 94 89/06/21.14G   198800971 198800971
10642 10642 52 94 94 89/06/22.05G   198801000 198801000
10700 10700 44 94 94 89/06/23G   198801002 198801002
10994 10994 9 94 94 89/06/11G   198800946 198800946
12019 12019 45 94 94 89/06/21.10G   198800972 198800972
12212 12212 47 94 94 89/06/21.18G   198800975 198800975
13752 13752 53 94 94 89/06/18.01G   198400304 198400304
13805 13805 2 94 94 89/06/22.03G   198800998 198800998
14198 14198 41 94 94 89/06/22.02G   198800997 198800997
14283 14283 13 94 94 89/06/21.02G   198800959 198800959
14723 14723 22 94 94 89/06/16G   198800626 198800626
15052 15052 18 94 94 89/06/15G   198400177 198400177
15374 15374 5 94 94 89/10/06.02G   198800746 198800746
16354 16354 34 94 94 89/06/21.08G   198800987 198800987
17916 17916 40 94 94 89/06/22.01G   198800996 198800996
18043 18043 26 94 94 89/06/21.06G   198800965 198800965
18586 18586 21 94 94 89/06/08G   198800625 198800625
18708 18708 8 94 94 89/06/01.01G   198800943 198800943
19135 19135 1 94 94 89/06/09G   198800792 198800792
19434 19434 37 94 94 89/06/03G   198800991 198800991
20088 20088 49 94 94 89/06/21.15G   198800978 198800978
20821 20821 32 94 94 89/06/21.24G   198800984 198800984
20871 20871 57 94 94 89/06/21.20G   198800979 198800979
21944 21944 42 94 94 89/06/22.04G   198800999 198800999
22392 22392 4 94 94 89/06/19 G   198800598 198800598
22518 22518 29 94 94 89/06/21.21G   198800981 198800981
22591 22591 3 94 94 89/06/20G   198800602 198800602
23143 23143 48 94 94 89/06/21.19G   198800977 198800977
23914 23914 46 94 94 89/06/21.17G   198800974 198800974
24798 24798 24 94 94 89/06/14G   198800627 198800627
25096 25096 59 94 94 89/06/10G   198800992 198800992
25293 25293 27 94 94 89/06/21.13G   198800968 198800968
25608 25608 10 94 94 89/06/01.02G   198800953 198800953
27766 27766 55 94 94 89/06/23Ga   198800615 198800615
30099 30099 6 94 94 89/06/07G   198800940 198800940
31201 31201 35 94 94 89/06/05G   198800989 198800989
31646 31646 17 94 94 89/06/18.05G   198800501 198800501
32174 32174 11 94 94 89/06/21.11G   198800957 198800957
32348 32348 31 94 94 89/06/21.23G   198800983 198800983

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