home / GrosserRat / Vorgaenge

Menu
  • Sign in with GitHub

Vorgaenge

23 rows where siz_nr = 489

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
478 478 14 489 489 00/06/18G ZUS 199701446 199701446
817 817 23 489 489 00/06/30bG UEB an RR 199701503 199701503
6231 6231 4 489 489 00/06/17G MUE 199701484 199701484
6308 6308 9 489 489 00/06/23.02G ERL 199202804 199202804
6883 6883 15 489 489 00/06/19G ZUS 199701445 199701445
7695 7695 6 489 489 00/06/23.04G ERL 198802462 198802462
8960 8960 22 489 489 00/06/28G STL an RR 199700515 199700515
10874 10874 12 489 489 00/06/22G ERL 199203946 199203946
13986 13986 13 489 489 00/06/23.06G ERL 199203882 199203882
16517 16517 10 489 489 00/06/27G ERL 199700396 199700396
17088 17088 21 489 489 00/06/23.01G ERL 199203308 199203308
17133 17133 8 489 489 00/06/23.03G ERL 198802423 198802423
18897 18897 2 489 489 00/06/23.07G ERL 199203161 199203161
20589 20589 20 489 489 00/06/21G ERL 199700636 199700636
20857 20857 7 489 489 00/06/25G ERL 199202764 199202764
22000 22000 17 489 489 00/06/29G ERL 199700303 199700303
22319 22319 3 489 489 00/06/16G ZUS 199701478 199701478
23999 23999 18 489 489 00/06/24G ERL 199700307 199700307
24173 24173 5 489 489 00/06/17Ga MUE 199701485 199701485
24184 24184 1 489 489 00/06/30aG UEB an RR 199701502 199701502
25358 25358 19 489 489 00/06/23.05G ERL 199203066 199203066
32160 32160 16 489 489 00/06/26G ERL 199203029 199203029
32598 32598 11 489 489 00/06/18Ga ERL 199700923 199700923

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