home / GrosserRat / Vorgaenge

Menu
  • Sign in with GitHub

Vorgaenge

10 rows where siz_nr = 1088

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
37750 37750 2 1088 1088 21/06/6.4G Überweisung an JSSK 200110688 200110688
37751 37751 3 1088 1088 21/06/6.5G Überweisung an PetKo 200110689 200110689
37761 37761 1 1088 1088 21/06/6.3G Überweisung an JSSK 200110643 200110643
37762 37762 4 1088 1088 21/06/6.22G Kenntnisnahme 200110670 200110670
37763 37763 5 1088 1088 21/06/6.23G Kenntnisnahme 200110671 200110671
37764 37764 6 1088 1088 21/06/6.24G Kenntnisnahme 200110672 200110672
37765 37765 7 1088 1088 21/06/6.25G Kenntnisnahme 200110673 200110673
37766 37766 8 1088 1088 21/06/6.26G stehen lassen 200109347 200109347
37767 37767 9 1088 1088 21/06/6.27G Kenntnisnahme 200110560 200110560
37768 37768 10 1088 1088 21/06/6.28G Kenntnisnahme 200110563 200110563

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