home / GrosserRat / Vorgaenge

Menu
  • Sign in with GitHub

Vorgaenge

37 rows where siz_nr = 506

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
576 576 12 506 506 00/37/09G KTS 199701676 199701676
1219 1219 7 506 506 00/37/21G MUE 199701709 199701709
2032 2032 1 506 506 00/37/07G UEB an PETK 199701679 199701679
2685 2685 15 506 506 00/37/16G ZUS 199701693 199701693
3297 3297 11 506 506 00/37/08G KTS 199701680 199701680
3915 3915 3 506 506 00/37/06G KTS 199701682 199701682
5360 5360 4 506 506 00/37/04G KTS 199701708 199701708
6737 6737 27 506 506 00/37/10aG STL an RR 199700603 199700603
7130 7130 19 506 506 00/37/17G UEB an RPLK 199701667 199701667
7250 7250 30 506 506 00/37/25G ERL 199700647 199700647
7812 7812 35 506 506 00/37/22G ZUS 199700612 199700612
8658 8658 26 506 506 00/37/27G ERL 199700416 199700416
11187 11187 22 506 506 00/37/02G GES an KANZ 199701706 199701706
12152 12152 9 506 506 00/37/21Gf MUE 199701719 199701719
12344 12344 20 506 506 00/37/14G ZUS 199701683 199701683
12925 12925 14 506 506 00/37/03G KTS 199701715 199701715
13419 13419 25 506 506 00/37/27Ga ERL 199700415 199700415
14264 14264 2 506 506 00/37/28G ERL 199700656 199700656
17138 17138 33 506 506 00/37/11G KTS 199701589 199701589
17668 17668 6 506 506 00/37/21Ge MUE 199701670 199701670
18795 18795 34 506 506 00/37/12G BUE 199701692 199701692
19297 19297 28 506 506 00/37/19G ERL 199203173 199203173
19838 19838 29 506 506 00/37/24G ERL 199700857 199700857
22619 22619 23 506 506 00/37/10bG STL an RR 199700531 199700531
23813 23813 18 506 506 00/37/18G ZUS 199701705 199701705
23879 23879 10 506 506 00/37/21Gd MUE 199701721 199701721
24094 24094 16 506 506 00/37/05G UEB an RPLK 199701697 199701697
25478 25478 21 506 506 00/37/19Ga ZUS 199701707 199701707
25624 25624 36 506 506 00/37/21Gc MUE 199701725 199701725
27313 27313 8 506 506 00/37/21Gb MUE 199701710 199701710
27368 27368 5 506 506 00/37/17Ga UEB an RPLK 199701585 199701585
27921 27921 37 506 506 00/37/21Ga MUE 199701681 199701681
28673 28673 24 506 506 00/37/26G ERL 199700147 199700147
29099 29099 13 506 506 00/37/15G ZUS 199701677 199701677
29390 29390 17 506 506 00/37/23G ZUS 199701694 199701694
29966 29966 32 506 506 00/37/13G GEW 199701703 199701703
33086 33086 31 506 506 00/37/20G ZUS 199701696 199701696

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