Vorgaenge
49 rows where siz_nr = 372
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
413 | 413 | 49 | 372 372 | 199203932 199203932 | ||
810 | 810 | 44 | 372 372 | 199203917 199203917 | ||
1026 | 1026 | 5 | 372 372 | 199202952 199202952 | ||
1715 | 1715 | 15 | 372 372 | 199203942 199203942 | ||
2635 | 2635 | 4 | 372 372 | 199202952 199202952 | ||
3152 | 3152 | 53 | 372 372 | 199202853 199202853 | ||
3189 | 3189 | 51 | 372 372 | 199203026 199203026 | ||
3281 | 3281 | 3 | 372 372 | 198802356 198802356 | ||
3375 | 3375 | 24 | 372 372 | 199203903 199203903 | ||
4214 | 4214 | 9 | 372 372 | 199203931 199203931 | ||
4521 | 4521 | 19 | 372 372 | 199203925 199203925 | ||
4632 | 4632 | 34 | 372 372 | 199203895 199203895 | ||
4711 | 4711 | 50 | 372 372 | 199203940 199203940 | ||
5601 | 5601 | 48 | 372 372 | 199203924 199203924 | ||
6543 | 6543 | 7 | 372 372 | 199700020 199700020 | ||
6971 | 6971 | 30 | 372 372 | 199203076 199203076 | ||
7095 | 7095 | 47 | 372 372 | 199203013 199203013 | ||
7273 | 7273 | 11 | 372 372 | 199203936 199203936 | ||
8893 | 8893 | 36 | 372 372 | 199203911 199203911 | ||
9335 | 9335 | 33 | 372 372 | 199203002 199203002 | ||
9738 | 9738 | 39 | 372 372 | 199203112 199203112 | ||
10430 | 10430 | 32 | 372 372 | 199203913 199203913 | ||
11459 | 11459 | 35 | 372 372 | 199203933 199203933 | ||
13083 | 13083 | 29 | 372 372 | 199203076 199203076 | ||
13246 | 13246 | 14 | 372 372 | 199203941 199203941 | ||
14691 | 14691 | 17 | 372 372 | 199203948 199203948 | ||
15751 | 15751 | 46 | 372 372 | 199203013 199203013 | ||
16312 | 16312 | 20 | 372 372 | 199203926 199203926 | ||
16788 | 16788 | 1 | 372 372 | 198802418 198802418 | ||
18617 | 18617 | 26 | 372 372 | 199203947 199203947 | ||
18956 | 18956 | 27 | 372 372 | 199203919 199203919 | ||
19794 | 19794 | 22 | 372 372 | 199203892 199203892 | ||
21267 | 21267 | 18 | 372 372 | 199203922 199203922 | ||
21290 | 21290 | 8 | 372 372 | 199203930 199203930 | ||
21548 | 21548 | 2 | 372 372 | 199203915 199203915 | ||
21662 | 21662 | 6 | 372 372 | 199203920 199203920 | ||
21797 | 21797 | 10 | 372 372 | 199203934 199203934 | ||
23842 | 23842 | 45 | 372 372 | 199203255 199203255 | ||
24632 | 24632 | 38 | 372 372 | 199203112 199203112 | ||
25918 | 25918 | 16 | 372 372 | 199203935 199203935 | ||
26195 | 26195 | 37 | 372 372 | 199203916 199203916 | ||
26769 | 26769 | 28 | 372 372 | 199203921 199203921 | ||
26780 | 26780 | 21 | 372 372 | 199203891 199203891 | ||
27058 | 27058 | 41 | 372 372 | 199203573 199203573 | ||
27858 | 27858 | 25 | 372 372 | 199203946 199203946 | ||
28922 | 28922 | 40 | 372 372 | 199203562 199203562 | ||
30294 | 30294 | 31 | 372 372 | 199202997 199202997 | ||
32010 | 32010 | 43 | 372 372 | 199203896 199203896 | ||
32898 | 32898 | 52 | 372 372 | 199203945 199203945 |
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");