Vorgaenge
33 rows where siz_nr = 175
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
745 | 745 | 12 | 175 175 | 91/23/26G | 198801969 198801969 | |
4975 | 4975 | 29 | 175 175 | 91/23/24G | 198801770 198801770 | |
6316 | 6316 | 15 | 175 175 | 91/23/09G | 198801977 198801977 | |
7716 | 7716 | 3 | 175 175 | 91/23/21G | 198000067 198000067 | |
11505 | 11505 | 20 | 175 175 | 91/23/10G | 198801995 198801995 | |
11702 | 11702 | 31 | 175 175 | 91/23/21Ge | 198000065 198000065 | |
11846 | 11846 | 11 | 175 175 | 91/23/25G | 198801428 198801428 | |
12056 | 12056 | 21 | 175 175 | 91/23/12G | 198801991 198801991 | |
12281 | 12281 | 19 | 175 175 | 91/23/13G | 198801630 198801630 | |
16684 | 16684 | 1 | 175 175 | 91/23/21Gd | 198400383 198400383 | |
16938 | 16938 | 6 | 175 175 | 91/23/05G | 198801774 198801774 | |
17265 | 17265 | 4 | 175 175 | 91/23/21Gc | 198400474 198400474 | |
18426 | 18426 | 28 | 175 175 | 91/23/14G | 198801782 198801782 | |
20341 | 20341 | 18 | 175 175 | 91/23/22G | 198801755 198801755 | |
20556 | 20556 | 26 | 175 175 | 91/23/11G | 198801569 198801569 | |
20823 | 20823 | 24 | 175 175 | 91/23/27bG | 198802535 198802535 | |
20854 | 20854 | 30 | 175 175 | 91/23/18G | 198801778 198801778 | |
22301 | 22301 | 27 | 175 175 | 91/23/04G | 198801572 198801572 | |
22524 | 22524 | 5 | 175 175 | 91/23/06G | 198801773 198801773 | |
22535 | 22535 | 13 | 175 175 | 91/2307G | 198801976 198801976 | |
22565 | 22565 | 7 | 175 175 | 91/23/16G | 198801779 198801779 | |
22638 | 22638 | 10 | 175 175 | 91/23/23G | 198801766 198801766 | |
23638 | 23638 | 32 | 175 175 | 91/23/19G | 198801339 198801339 | |
24927 | 24927 | 33 | 175 175 | 91/23/21Gb | 198000064 198000064 | |
26541 | 26541 | 2 | 175 175 | 91/23/25Ga | 198400306 198400306 | |
26646 | 26646 | 25 | 175 175 | 91/23/27cG | 198802536 198802536 | |
26733 | 26733 | 8 | 175 175 | 91/23/17G | 198801780 198801780 | |
26766 | 26766 | 9 | 175 175 | 91/23/15G | 198801781 198801781 | |
28504 | 28504 | 16 | 175 175 | 91/23/21Ga | 198801978 198801978 | |
29517 | 29517 | 14 | 175 175 | 91/23/08G | 198802522 198802522 | |
30220 | 30220 | 17 | 175 175 | 91/23/04Ga | 198801927 198801927 | |
30801 | 30801 | 23 | 175 175 | 91/23/27aG | 198801994 198801994 | |
31335 | 31335 | 22 | 175 175 | 91/23/20G | 198802531 198802531 |
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");