Vorgaenge

40 rows where siz_nr = 198

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
312 312 30 198 198 92/07/11G   198802132 198802132
1227 1227 12 198 198 92/07/13G   198802180 198802180
1515 1515 28 198 198 92/07/07aG   198801889 198801889
2299 2299 9 198 198 92/07/13Ge   198802183 198802183
3766 3766 24 198 198 92/07/07fG   198802069 198802069
4901 4901 19 198 198 92/07/09G   198801593 198801593
6171 6171 15 198 198 92/07/07dG   198400250 198400250
6425 6425 27 198 198 92/07/04.1G   198400518 198400518
6868 6868 22 198 198 92/07/07gG   198801176 198801176
6921 6921 17 198 198 92/07/21aG   198802672 198802672
7138 7138 39 198 198 92/07/20G   198801737 198801737
10314 10314 33 198 198 92/07/17G   198802139 198802139
10782 10782 6 198 198 92/07/19G   198400174 198400174
11966 11966 25 198 198 92/07/14G   198802086 198802086
12862 12862 20 198 198 92/07/12G   198801868 198801868
13236 13236 29 198 198 92/07/16G   198802140 198802140
13845 13845 26 198 198 92/07/02G   198802458 198802458
14389 14389 5 198 198 92/07/03G   198400467 198400467
16806 16806 40 198 198 92/07/14Gc   198400429 198400429
18177 18177 35 198 198 92/07/18G   198802138 198802138
18507 18507 14 198 198 92/07/15G   198802176 198802176
19583 19583 13 198 198 92/07/13Gd   198802181 198802181
19902 19902 7 198 198 92/07/05aG   198801239 198801239
20358 20358 38 198 198 92/07/07eG   198801108 198801108
23735 23735 16 198 198 92/07/21bG   198802203 198802203
24636 24636 37 198 198 92/07/12Gb   198801870 198801870
25376 25376 4 198 198 92/07/05bG   198801013 198801013
25565 25565 34 198 198 92/07/04.2G   198801134 198801134
27526 27526 31 198 198 92/07/11Ga   198802133 198802133
27579 27579 18 198 198 92/07/08G   198802142 198802142
27987 27987 8 198 198 92/07/13Gc   198802182 198802182
28423 28423 10 198 198 92/07/13Gb   198802184 198802184
28892 28892 32 198 198 92/07/06G   198802134 198802134
29120 29120 1 198 198 92/07/14Gb   198802273 198802273
29346 29346 21 198 198 92/07/12Ga   198801869 198801869
29884 29884 36 198 198 92/07/07cG   198801712 198801712
30070 30070 11 198 198 92/07/10G   198802667 198802667
30594 30594 3 198 198 92/07/14Ga   198802224 198802224
31163 31163 2 198 198 92/07/13Ga   198802185 198802185
32853 32853 23 198 198 92/07/07bG   198801947 198801947

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