home / GrosserRat / Vorgaenge

Menu
  • Sign in with GitHub

Vorgaenge

33 rows where siz_nr = 294

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
579 579 33 294 294     199202469 199202469
1518 1518 32 294 294     199203019 199203019
2218 2218 5 294 294     199203008 199203008
2984 2984 19 294 294     199202393 199202393
3017 3017 21 294 294     199203020 199203020
4245 4245 4 294 294     199203007 199203007
5737 5737 31 294 294     199203013 199203013
8228 8228 11 294 294     199202378 199202378
8965 8965 28 294 294     199202386 199202386
9858 9858 14 294 294     199203015 199203015
10826 10826 6 294 294     199203009 199203009
11002 11002 13 294 294     199202379 199202379
11151 11151 1 294 294     199202983 199202983
11701 11701 23 294 294     199203443 199203443
12774 12774 2 294 294     199203021 199203021
13343 13343 18 294 294     199202295 199202295
14753 14753 3 294 294     199202689 199202689
16870 16870 25 294 294     199202572 199202572
17126 17126 20 294 294     199202389 199202389
18252 18252 8 294 294     199203011 199203011
20450 20450 12 294 294     199202288 199202288
24827 24827 10 294 294     199202293 199202293
25225 25225 7 294 294     199203010 199203010
25848 25848 22 294 294     199203022 199203022
26430 26430 9 294 294     199203012 199203012
26965 26965 29 294 294     199203005 199203005
27931 27931 27 294 294     199202394 199202394
28221 28221 16 294 294     199202385 199202385
29152 29152 17 294 294     199203018 199203018
30124 30124 24 294 294     199203028 199203028
30205 30205 26 294 294     199203004 199203004
30443 30443 15 294 294     199203017 199203017
30467 30467 30 294 294     199203006 199203006

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