Vorgaenge
33 rows where siz_nr = 294
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
579 | 579 | 33 | 294 294 | 199202469 199202469 | ||
1518 | 1518 | 32 | 294 294 | 199203019 199203019 | ||
2218 | 2218 | 5 | 294 294 | 199203008 199203008 | ||
2984 | 2984 | 19 | 294 294 | 199202393 199202393 | ||
3017 | 3017 | 21 | 294 294 | 199203020 199203020 | ||
4245 | 4245 | 4 | 294 294 | 199203007 199203007 | ||
5737 | 5737 | 31 | 294 294 | 199203013 199203013 | ||
8228 | 8228 | 11 | 294 294 | 199202378 199202378 | ||
8965 | 8965 | 28 | 294 294 | 199202386 199202386 | ||
9858 | 9858 | 14 | 294 294 | 199203015 199203015 | ||
10826 | 10826 | 6 | 294 294 | 199203009 199203009 | ||
11002 | 11002 | 13 | 294 294 | 199202379 199202379 | ||
11151 | 11151 | 1 | 294 294 | 199202983 199202983 | ||
11701 | 11701 | 23 | 294 294 | 199203443 199203443 | ||
12774 | 12774 | 2 | 294 294 | 199203021 199203021 | ||
13343 | 13343 | 18 | 294 294 | 199202295 199202295 | ||
14753 | 14753 | 3 | 294 294 | 199202689 199202689 | ||
16870 | 16870 | 25 | 294 294 | 199202572 199202572 | ||
17126 | 17126 | 20 | 294 294 | 199202389 199202389 | ||
18252 | 18252 | 8 | 294 294 | 199203011 199203011 | ||
20450 | 20450 | 12 | 294 294 | 199202288 199202288 | ||
24827 | 24827 | 10 | 294 294 | 199202293 199202293 | ||
25225 | 25225 | 7 | 294 294 | 199203010 199203010 | ||
25848 | 25848 | 22 | 294 294 | 199203022 199203022 | ||
26430 | 26430 | 9 | 294 294 | 199203012 199203012 | ||
26965 | 26965 | 29 | 294 294 | 199203005 199203005 | ||
27931 | 27931 | 27 | 294 294 | 199202394 199202394 | ||
28221 | 28221 | 16 | 294 294 | 199202385 199202385 | ||
29152 | 29152 | 17 | 294 294 | 199203018 199203018 | ||
30124 | 30124 | 24 | 294 294 | 199203028 199203028 | ||
30205 | 30205 | 26 | 294 294 | 199203004 199203004 | ||
30443 | 30443 | 15 | 294 294 | 199203017 199203017 | ||
30467 | 30467 | 30 | 294 294 | 199203006 199203006 |
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");