Vorgaenge
41 rows where siz_nr = 275
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
125 | 125 | 23 | 275 275 | 199202131 199202131 | ||
702 | 702 | 15 | 275 275 | 199202915 199202915 | ||
1253 | 1253 | 3 | 275 275 | 199202203 199202203 | ||
3034 | 3034 | 9 | 275 275 | 199202926 199202926 | ||
3240 | 3240 | 29 | 275 275 | 199202944 199202944 | ||
4156 | 4156 | 7 | 275 275 | 199202924 199202924 | ||
7939 | 7939 | 26 | 275 275 | 199202136 199202136 | ||
8042 | 8042 | 4 | 275 275 | 199202264 199202264 | ||
9149 | 9149 | 2 | 275 275 | 199202919 199202919 | ||
10449 | 10449 | 19 | 275 275 | 199202938 199202938 | ||
11223 | 11223 | 16 | 275 275 | 199202323 199202323 | ||
11744 | 11744 | 38 | 275 275 | 199202149 199202149 | ||
12298 | 12298 | 17 | 275 275 | 199202148 199202148 | ||
12567 | 12567 | 6 | 275 275 | 199202154 199202154 | ||
12878 | 12878 | 20 | 275 275 | 199202938 199202938 | ||
12968 | 12968 | 30 | 275 275 | 199202372 199202372 | ||
13736 | 13736 | 22 | 275 275 | 199202937 199202937 | ||
13896 | 13896 | 10 | 275 275 | 199202150 199202150 | ||
14989 | 14989 | 31 | 275 275 | 199202940 199202940 | ||
15074 | 15074 | 14 | 275 275 | 199202914 199202914 | ||
15745 | 15745 | 1 | 275 275 | 199202368 199202368 | ||
15790 | 15790 | 33 | 275 275 | 199202085 199202085 | ||
17084 | 17084 | 35 | 275 275 | 199202943 199202943 | ||
17740 | 17740 | 24 | 275 275 | 199202669 199202669 | ||
17814 | 17814 | 11 | 275 275 | 199202155 199202155 | ||
17879 | 17879 | 37 | 275 275 | 199202923 199202923 | ||
21088 | 21088 | 27 | 275 275 | 199202142 199202142 | ||
21174 | 21174 | 41 | 275 275 | 199202402 199202402 | ||
21793 | 21793 | 18 | 275 275 | 199202243 199202243 | ||
21853 | 21853 | 39 | 275 275 | 199202132 199202132 | ||
22100 | 22100 | 28 | 275 275 | 199202922 199202922 | ||
24817 | 24817 | 12 | 275 275 | 199202927 199202927 | ||
25009 | 25009 | 40 | 275 275 | 199202143 199202143 | ||
25502 | 25502 | 8 | 275 275 | 199202925 199202925 | ||
27100 | 27100 | 5 | 275 275 | 199202156 199202156 | ||
27335 | 27335 | 34 | 275 275 | 199202107 199202107 | ||
28885 | 28885 | 25 | 275 275 | 199202941 199202941 | ||
29579 | 29579 | 32 | 275 275 | 199202942 199202942 | ||
30882 | 30882 | 13 | 275 275 | 199202913 199202913 | ||
32154 | 32154 | 36 | 275 275 | 199202921 199202921 | ||
32283 | 32283 | 21 | 275 275 | 199202939 199202939 |
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");