Vorgaenge
35 rows where siz_nr = 487
This data as json, copyable, CSV (advanced)
Suggested facets: Vermerk
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
76 | 76 | 21 | 487 487 | 00/06/13.05G | UEB an RR | 199701432 199701432 |
520 | 520 | 22 | 487 487 | 00/06/15G | SCR | 199701452 199701452 |
599 | 599 | 16 | 487 487 | 00/06/07G | UEB an RPLK | 199701461 199701461 |
1843 | 1843 | 10 | 487 487 | 00/06/06dG | KTS | 199701059 199701059 |
2725 | 2725 | 25 | 487 487 | 00/06/13.02G | UEB an RR | 199701418 199701418 |
3138 | 3138 | 30 | 487 487 | 00/06/15Gh | SCR | 199701454 199701454 |
3476 | 3476 | 35 | 487 487 | 00/06/15Gg | SCR | 199701448 199701448 |
4414 | 4414 | 27 | 487 487 | 00/06/05aG | STL an RR | 199203572 199203572 |
6491 | 6491 | 31 | 487 487 | 00/06/09G | GEW | 199701473 199701473 |
7814 | 7814 | 3 | 487 487 | 00/06/15Gf | SCR | 199701451 199701451 |
8398 | 8398 | 9 | 487 487 | 00/06/12G | MUE | 199701474 199701474 |
8796 | 8796 | 24 | 487 487 | 00/06/13.02Ga | UEB an RR | 199701417 199701417 |
10513 | 10513 | 8 | 487 487 | 00/06/10G | GEW | 199701472 199701472 |
10943 | 10943 | 34 | 487 487 | 00/06/15Ge | SCR | 199701450 199701450 |
12555 | 12555 | 20 | 487 487 | 00/06/13.07G | UEB an RR | 199701437 199701437 |
17303 | 17303 | 1 | 487 487 | 00/06/15Gd | SCR | 199701449 199701449 |
17738 | 17738 | 5 | 487 487 | 00/06/12Gb | MUE | 199701467 199701467 |
18267 | 18267 | 26 | 487 487 | 00/06/13.04G | UEB an RR | 199701419 199701419 |
18727 | 18727 | 28 | 487 487 | 00/06/13.08G | UEB an INTG | 199701438 199701438 |
21462 | 21462 | 15 | 487 487 | 00/06/04G | KTS | 199701447 199701447 |
21789 | 21789 | 12 | 487 487 | 00/06/06bG | KTS | 199701057 199701057 |
23443 | 23443 | 18 | 487 487 | 00/06/15Gc | SCR | 199701420 199701420 |
23523 | 23523 | 4 | 487 487 | 00/06/15Gb | SCR | 199701453 199701453 |
23827 | 23827 | 14 | 487 487 | 00/06/06cG | KTS | 199701032 199701032 |
24214 | 24214 | 32 | 487 487 | 00/06/12Ga | MUE | 199701481 199701481 |
25320 | 25320 | 7 | 487 487 | 00/06/03G | KTS | 199701475 199701475 |
25942 | 25942 | 11 | 487 487 | 00/06/06aG | KTS | 199701056 199701056 |
26697 | 26697 | 29 | 487 487 | 00/06/11G | ZUA | 199203629 199203629 |
27062 | 27062 | 19 | 487 487 | 00/06/14G | ERL | 199700957 199700957 |
27241 | 27241 | 17 | 487 487 | 00/06/05bG | STL an RR | 199203180 199203180 |
30154 | 30154 | 13 | 487 487 | 00/06/05bGa | KTS | 199700689 199700689 |
30890 | 30890 | 23 | 487 487 | 00/06/15Ga | SCR | 199701416 199701416 |
31291 | 31291 | 2 | 487 487 | 00/06/13.01G | UEB an RR | 199701463 199701463 |
32116 | 32116 | 6 | 487 487 | 00/06/02G | KTS | 199701466 199701466 |
32760 | 32760 | 33 | 487 487 | 00/06/13.06G | UEB an RR | 199701434 199701434 |
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");