Vorgaenge
35 rows where siz_nr = 371
This data as json, copyable, CSV (advanced)
Suggested facets: Vermerk
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
379 | 379 | 28 | 371 371 | 97/02/12G | VOL | 199203913 199203913 |
1752 | 1752 | 26 | 371 371 | 97/02/06G | KTS | 199203933 199203933 |
2399 | 2399 | 9 | 371 371 | 97/02/21G | ERL | 198400489 198400489 |
2507 | 2507 | 16 | 371 371 | 97/02/21Gi | ZUA | 199202561 199202561 |
2699 | 2699 | 18 | 371 371 | 97/02/20G | MUE | 199203926 199203926 |
4430 | 4430 | 25 | 371 371 | 97/02/11G | VOL | 199203910 199203910 |
4840 | 4840 | 6 | 371 371 | 97/02/21Gh | ERL | 198802315 198802315 |
5244 | 5244 | 30 | 371 371 | 97/02/03.03G | STL an RR | 198802419 198802419 |
5647 | 5647 | 34 | 371 371 | 97/02/04.03G | STL an RR | 198000097 198000097 |
7277 | 7277 | 1 | 371 371 | 97/02/21Gg | ERL | 199203894 199203894 |
7746 | 7746 | 10 | 371 371 | 97/02/04.04G | STL an RR | 198400491 198400491 |
9093 | 9093 | 24 | 371 371 | 97/02/20Ga | MUE | 199203921 199203921 |
10399 | 10399 | 27 | 371 371 | 97/02/16G | ZUS | 199203911 199203911 |
11685 | 11685 | 33 | 371 371 | 97/02/18G | ZUA | 199203915 199203915 |
11932 | 11932 | 20 | 371 371 | 97/02/03.01G | STL an RR | 199202200 199202200 |
13023 | 13023 | 7 | 371 371 | 97/02/21Gf | ERL | 199202562 199202562 |
13992 | 13992 | 14 | 371 371 | 97/02/04.01G | STL an RR | 199202778 199202778 |
14703 | 14703 | 8 | 371 371 | 97/02/04.02G | STL an RR | 198000096 198000096 |
17014 | 17014 | 22 | 371 371 | 97/02/09G | KTS | 199203892 199203892 |
17191 | 17191 | 12 | 371 371 | 97/02/21Ge | ERL | 198802435 198802435 |
20393 | 20393 | 11 | 371 371 | 97/02/03.02G | STL an RR | 199201621 199201621 |
20886 | 20886 | 4 | 371 371 | 97/02/21Gd | STL an RR | 198802256 198802256 |
21629 | 21629 | 23 | 371 371 | 97/02/14G | NZU | 199203903 199203903 |
22010 | 22010 | 21 | 371 371 | 97/02/07G | UEB an GVK | 199203891 199203891 |
22040 | 22040 | 5 | 371 371 | 97/02/05G | STL an RR | 199202930 199202930 |
22133 | 22133 | 31 | 371 371 | 97/02/08G | UEB an GVK | 199203932 199203932 |
23396 | 23396 | 17 | 371 371 | 97/02/10G | KTS | 199203936 199203936 |
23495 | 23495 | 13 | 371 371 | 97/02/02G | STL an RR | 199202781 199202781 |
24435 | 24435 | 35 | 371 371 | 97/02/21Gc | ERL | 198000086 198000086 |
24759 | 24759 | 29 | 371 371 | 97/02/17G | ERL | 199203370 199203370 |
24900 | 24900 | 32 | 371 371 | 97/02/15G | ZUS | 199203890 199203890 |
27449 | 27449 | 2 | 371 371 | 97/02/19G | ERL | 198400441 198400441 |
28597 | 28597 | 19 | 371 371 | 97/02/13G | UEB an RR | 199203930 199203930 |
31415 | 31415 | 3 | 371 371 | 97/02/21Gb | ERL | 198400451 198400451 |
32482 | 32482 | 15 | 371 371 | 97/02/21Ga | ZUA | 199201837 199201837 |
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");