Vorgaenge
32 rows where siz_nr = 396
This data as json, copyable, CSV (advanced)
Suggested facets: Vermerk
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
234 | 234 | 7 | 396 396 | 97/46/14G | KTS | 199700067 199700067 |
1439 | 1439 | 13 | 396 396 | 97/46/07G | KTS | 199700374 199700374 |
1898 | 1898 | 28 | 396 396 | 97/46/06G | KTS | 199700373 199700373 |
4202 | 4202 | 2 | 396 396 | 97/46/22G | ERL | 199203795 199203795 |
5781 | 5781 | 10 | 396 396 | 97/46/02G | GEW | 199700401 199700401 |
6343 | 6343 | 18 | 396 396 | 97/46/23G | ZUS | 199700255 199700255 |
6815 | 6815 | 11 | 396 396 | 97/46/20G | KTS | 199203929 199203929 |
7425 | 7425 | 5 | 396 396 | 97/46/19G | KTS | 199700071 199700071 |
9818 | 9818 | 21 | 396 396 | 97/46/22Gd | ZUS | 199700285 199700285 |
10704 | 10704 | 12 | 396 396 | 97/46/28G | ZUS | 199700142 199700142 |
10808 | 10808 | 19 | 396 396 | 97/46/27G | UEB an GPK | 199700316 199700316 |
11827 | 11827 | 23 | 396 396 | 97/46/26G | ZUS | 199700288 199700288 |
12376 | 12376 | 14 | 396 396 | 97/46/05G | KTS | 199700371 199700371 |
17361 | 17361 | 26 | 396 396 | 97/46/25G | MUE | 199700351 199700351 |
17566 | 17566 | 27 | 396 396 | 97/46/22Gc | STL an RR | 199203826 199203826 |
18254 | 18254 | 22 | 396 396 | 97/46/24G | ZUS | 199700335 199700335 |
18666 | 18666 | 8 | 396 396 | 97/46/01G | GEW | 199700399 199700399 |
18846 | 18846 | 24 | 396 396 | 97/46/16G | KTS | 199700358 199700358 |
20282 | 20282 | 4 | 396 396 | 97/46/13G | STL an RR | 199202514 199202514 |
20402 | 20402 | 6 | 396 396 | 97/46/15G | KTS | 199700378 199700378 |
20988 | 20988 | 20 | 396 396 | 97/46/10G | STL an RR | 199203168 199203168 |
21141 | 21141 | 30 | 396 396 | 97/46/22Gb | ERL | 199202860 199202860 |
23355 | 23355 | 15 | 396 396 | 97/46/04G | KTS | 199700372 199700372 |
24547 | 24547 | 17 | 396 396 | 97/46/17G | KTS | 199700389 199700389 |
24664 | 24664 | 9 | 396 396 | 97/46/03G | GEW | 199700400 199700400 |
24706 | 24706 | 32 | 396 396 | 97/46/11G | STL an RR | 198400502 198400502 |
25290 | 25290 | 1 | 396 396 | 97/46/12G | STL an RR | 198802244 198802244 |
26576 | 26576 | 31 | 396 396 | 97/46/22Ga | STL an RR | 199203006 199203006 |
27717 | 27717 | 3 | 396 396 | 97/46/09G | STL an RR | 199202764 199202764 |
28326 | 28326 | 25 | 396 396 | 97/46/08G | KTS | 199700355 199700355 |
29023 | 29023 | 16 | 396 396 | 97/46/21G | UEB an PETK | 199700380 199700380 |
30216 | 30216 | 29 | 396 396 | 97/46/18G | KTS | 199700388 199700388 |
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");