home / GrosserRat / Vorgaenge

Menu
  • Sign in with GitHub

Vorgaenge

35 rows where siz_nr = 487

✎ View and edit SQL

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

CSV options:

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");
Powered by Datasette · Queries took 1.2ms