Vorgaenge
40 rows where siz_nr = 421
This data as json, copyable, CSV (advanced)
Suggested facets: Vermerk
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
627 | 627 | 28 | 421 421 | 98/17/13G | MUE | 199700591 199700591 |
1167 | 1167 | 33 | 421 421 | 98/17/05cG | KTS | 199700163 199700163 |
3953 | 3953 | 10 | 421 421 | 98/17/14.02G | UEB an RR | 199700531 199700531 |
4069 | 4069 | 15 | 421 421 | 98/17/13Gd | MUE | 199700587 199700587 |
5471 | 5471 | 20 | 421 421 | 98/17/16G | SCR | 199700545 199700545 |
7514 | 7514 | 12 | 421 421 | 98/17/07G | GEW | 199700568 199700568 |
8289 | 8289 | 30 | 421 421 | 98/17/05aG | KTS | 199700115 199700115 |
8889 | 8889 | 34 | 421 421 | 98/17/08G | GEW | 199700527 199700527 |
10172 | 10172 | 38 | 421 421 | 98/17/16Gg | SCR | 199700554 199700554 |
12818 | 12818 | 11 | 421 421 | 98/17/05bG | KTS | 199700164 199700164 |
12997 | 12997 | 5 | 421 421 | 98/17/19G | ZUS | 199700547 199700547 |
13427 | 13427 | 39 | 421 421 | 98/17/15G | UEB an RR | 199203932 199203932 |
13861 | 13861 | 6 | 421 421 | 98/17/20G | ZUS | 199700556 199700556 |
15792 | 15792 | 7 | 421 421 | 98/17/17G | ERL | 199202661 199202661 |
16268 | 16268 | 27 | 421 421 | 98/17/16Gf | SCR | 199700567 199700567 |
17058 | 17058 | 18 | 421 421 | 98/17/14.04G | UEB an RR | 199700537 199700537 |
17369 | 17369 | 4 | 421 421 | 98/17/21G | ZUS | 199700564 199700564 |
17575 | 17575 | 37 | 421 421 | 98/17/16Ge | SCR | 199700544 199700544 |
18905 | 18905 | 17 | 421 421 | 98/17/14.01G | UEB an RR | 199700532 199700532 |
18915 | 18915 | 13 | 421 421 | 98/17/11G | KTS | 199700573 199700573 |
19127 | 19127 | 24 | 421 421 | 98/17/13Gc | MUE | 199700558 199700558 |
21108 | 21108 | 16 | 421 421 | 98/17/14.03G | UEB an RR | 199700533 199700533 |
21203 | 21203 | 26 | 421 421 | 98/17/16Gd | SCR | 199700566 199700566 |
22786 | 22786 | 19 | 421 421 | 98/17/14.05G | UEB an RR | 199700538 199700538 |
23308 | 23308 | 32 | 421 421 | 98/17/18G | ZUA | 199700569 199700569 |
23458 | 23458 | 22 | 421 421 | 98/17/16Gc | SCR | 199700552 199700552 |
23932 | 23932 | 21 | 421 421 | 98/17/16Gb | SCR | 199700549 199700549 |
24392 | 24392 | 9 | 421 421 | 98/17/07Ga | GEW | 199700526 199700526 |
25592 | 25592 | 31 | 421 421 | 98/17/05cGa | KTS | 199700210 199700210 |
25865 | 25865 | 1 | 421 421 | 98/17/04aG | KTS | 199202870 199202870 |
26163 | 26163 | 2 | 421 421 | 98/17/12G | UEB an JUGK | 199700557 199700557 |
27794 | 27794 | 29 | 421 421 | 98/17/06G | GEW | 199700606 199700606 |
27939 | 27939 | 3 | 421 421 | 98/17/10G | ZUS | 199700555 199700555 |
28415 | 28415 | 23 | 421 421 | 98/17/16Ga | SCR | 199700553 199700553 |
29123 | 29123 | 14 | 421 421 | 98/17/13Gb | MUE | 199700586 199700586 |
32202 | 32202 | 36 | 421 421 | 98/17/04bG | KTS | 199700069 199700069 |
32424 | 32424 | 40 | 421 421 | 98/17/09G | ZUS | 199700543 199700543 |
32500 | 32500 | 25 | 421 421 | 98/17/13Ga | MUE | 199700563 199700563 |
32551 | 32551 | 8 | 421 421 | 98/17/04bGa | KTS | 199203588 199203588 |
32857 | 32857 | 35 | 421 421 | 98/17/03G | STL an RR | 199202963 199202963 |
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");