Vorgaenge
57 rows where siz_nr = 375
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
157 | 157 | 51 | 375 375 | 199700008 199700008 | ||
688 | 688 | 21 | 375 375 | 199700067 199700067 | ||
1779 | 1779 | 4 | 375 375 | 199700009 199700009 | ||
1783 | 1783 | 38 | 375 375 | 199203943 199203943 | ||
2082 | 2082 | 53 | 375 375 | 199700069 199700069 | ||
2387 | 2387 | 48 | 375 375 | 199700068 199700068 | ||
2446 | 2446 | 57 | 375 375 | 199700062 199700062 | ||
3420 | 3420 | 59 | 375 375 | 199203944 199203944 | ||
5477 | 5477 | 30 | 375 375 | 199700001 199700001 | ||
6125 | 6125 | 19 | 375 375 | 199700065 199700065 | ||
6161 | 6161 | 46 | 375 375 | 199700060 199700060 | ||
6513 | 6513 | 14 | 375 375 | 199700057 199700057 | ||
6661 | 6661 | 41 | 375 375 | 199203539 199203539 | ||
7978 | 7978 | 55 | 375 375 | 199700050 199700050 | ||
8463 | 8463 | 1 | 375 375 | 199202824 199202824 | ||
9286 | 9286 | 47 | 375 375 | 199700064 199700064 | ||
9660 | 9660 | 31 | 375 375 | 199700002 199700002 | ||
10582 | 10582 | 22 | 375 375 | 199700067 199700067 | ||
10612 | 10612 | 3 | 375 375 | 199203488 199203488 | ||
10871 | 10871 | 28 | 375 375 | 199700024 199700024 | ||
10876 | 10876 | 9 | 375 375 | 199700049 199700049 | ||
11369 | 11369 | 39 | 375 375 | 199700010 199700010 | ||
12254 | 12254 | 26 | 375 375 | 199700018 199700018 | ||
12677 | 12677 | 52 | 375 375 | 199700069 199700069 | ||
13240 | 13240 | 7 | 375 375 | 199700047 199700047 | ||
13916 | 13916 | 33 | 375 375 | 199700004 199700004 | ||
14977 | 14977 | 12 | 375 375 | 199700053 199700053 | ||
18321 | 18321 | 16 | 375 375 | 199700059 199700059 | ||
18669 | 18669 | 8 | 375 375 | 199700048 199700048 | ||
19111 | 19111 | 13 | 375 375 | 199700054 199700054 | ||
19235 | 19235 | 5 | 375 375 | 199700012 199700012 | ||
19950 | 19950 | 27 | 375 375 | 199700022 199700022 | ||
20920 | 20920 | 35 | 375 375 | 199700021 199700021 | ||
21209 | 21209 | 25 | 375 375 | 199700017 199700017 | ||
21227 | 21227 | 36 | 375 375 | 199700013 199700013 | ||
21915 | 21915 | 18 | 375 375 | 199700063 199700063 | ||
22148 | 22148 | 34 | 375 375 | 199700006 199700006 | ||
22396 | 22396 | 42 | 375 375 | 199203918 199203918 | ||
22550 | 22550 | 11 | 375 375 | 199700052 199700052 | ||
22725 | 22725 | 6 | 375 375 | 199203344 199203344 | ||
22887 | 22887 | 17 | 375 375 | 199700061 199700061 | ||
24300 | 24300 | 10 | 375 375 | 199700051 199700051 | ||
24512 | 24512 | 32 | 375 375 | 199700003 199700003 | ||
26519 | 26519 | 15 | 375 375 | 199700058 199700058 | ||
26932 | 26932 | 50 | 375 375 | 199700008 199700008 | ||
27767 | 27767 | 45 | 375 375 | 199203756 199203756 | ||
27947 | 27947 | 58 | 375 375 | 199203196 199203196 | ||
28216 | 28216 | 23 | 375 375 | 199700073 199700073 | ||
28903 | 28903 | 29 | 375 375 | 199700016 199700016 | ||
28914 | 28914 | 40 | 375 375 | 199203537 199203537 | ||
29027 | 29027 | 44 | 375 375 | 199700005 199700005 | ||
29972 | 29972 | 37 | 375 375 | 199700011 199700011 | ||
30092 | 30092 | 24 | 375 375 | 199700071 199700071 | ||
30702 | 30702 | 49 | 375 375 | 199700056 199700056 | ||
30802 | 30802 | 56 | 375 375 | 199700055 199700055 | ||
32143 | 32143 | 43 | 375 375 | 199203535 199203535 | ||
32901 | 32901 | 20 | 375 375 | 199700066 199700066 |
Advanced export
JSON shape: default, array, newline-delimited
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");