Vorgaenge
33 rows where siz_nr = 290
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
735 | 735 | 21 | 290 290 | 199202986 199202986 | ||
1714 | 1714 | 10 | 290 290 | 199202284 199202284 | ||
4512 | 4512 | 3 | 290 290 | 199202972 199202972 | ||
5108 | 5108 | 27 | 290 290 | 199202363 199202363 | ||
6122 | 6122 | 30 | 290 290 | 199203003 199203003 | ||
7773 | 7773 | 18 | 290 290 | 199203000 199203000 | ||
9545 | 9545 | 4 | 290 290 | 199202377 199202377 | ||
10660 | 10660 | 29 | 290 290 | 199203002 199203002 | ||
13420 | 13420 | 7 | 290 290 | 199202981 199202981 | ||
14165 | 14165 | 5 | 290 290 | 199202376 199202376 | ||
14842 | 14842 | 22 | 290 290 | 199202987 199202987 | ||
16570 | 16570 | 17 | 290 290 | 199203299 199203299 | ||
17883 | 17883 | 23 | 290 290 | 199202988 199202988 | ||
18217 | 18217 | 6 | 290 290 | 199202979 199202979 | ||
18293 | 18293 | 31 | 290 290 | 199202989 199202989 | ||
18360 | 18360 | 15 | 290 290 | 199202996 199202996 | ||
18611 | 18611 | 24 | 290 290 | 199202360 199202360 | ||
18825 | 18825 | 12 | 290 290 | 199202375 199202375 | ||
19053 | 19053 | 25 | 290 290 | 199202362 199202362 | ||
19633 | 19633 | 11 | 290 290 | 199202366 199202366 | ||
19648 | 19648 | 8 | 290 290 | 199202286 199202286 | ||
19819 | 19819 | 1 | 290 290 | 199202430 199202430 | ||
20101 | 20101 | 20 | 290 290 | 199202623 199202623 | ||
20711 | 20711 | 16 | 290 290 | 199202997 199202997 | ||
21544 | 21544 | 2 | 290 290 | 199202998 199202998 | ||
25156 | 25156 | 32 | 290 290 | 199202361 199202361 | ||
28831 | 28831 | 13 | 290 290 | 199203270 199203270 | ||
29586 | 29586 | 9 | 290 290 | 199202283 199202283 | ||
30332 | 30332 | 14 | 290 290 | 199202995 199202995 | ||
31166 | 31166 | 26 | 290 290 | 199202990 199202990 | ||
31197 | 31197 | 19 | 290 290 | 199202365 199202365 | ||
31785 | 31785 | 33 | 290 290 | 199202337 199202337 | ||
32358 | 32358 | 28 | 290 290 | 199202991 199202991 |
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");