home / GrosserRat / Vorgaenge

Menu
  • Sign in with GitHub

Vorgaenge

53 rows where siz_nr = 509

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
1082 1082 42 509 509 00/42/06G UEB an PETK 199701740 199701740
1359 1359 7 509 509 00/42/20G SCR 199701690 199701690
1763 1763 30 509 509 00/42/01G BUE 199701716 199701716
1952 1952 2 509 509 00/42/13G ZUS 199701738 199701738
2958 2958 12 509 509 00/42/15.01G URS an RR 199701673 199701673
3108 3108 32 509 509 00/42/14G MUE 199701767 199701767
3215 3215 5 509 509 00/42/16.07G UEB an RR 199701686 199701686
3650 3650 35 509 509 00/42/18G ERL 199701311 199701311
5001 5001 49 509 509 00/42/16.03G UEB an RR 199701675 199701675
5337 5337 29 509 509 00/42/02G GES 199202932 199202932
5656 5656 18 509 509 00/42/20Gi SCR 199701724 199701724
6769 6769 9 509 509 00/42/16.12G NUE 199701702 199701702
7045 7045 37 509 509 00/42/02Gd GES 199700764 199700764
8146 8146 40 509 509 00/42/02Gc GES 199700316 199700316
8528 8528 41 509 509 00/42/16.06G UEB an RR 199701687 199701687
9143 9143 23 509 509 00/42/02Gb GES 199701739 199701739
9249 9249 53 509 509 00/42/15.02G ZUR 199701678 199701678
9630 9630 17 509 509 00/42/20Gh SCR 199701723 199701723
9962 9962 10 509 509 00/42/20Gg SCR 199701699 199701699
11274 11274 52 509 509 00/42/07G UEB an PETK 199701748 199701748
11529 11529 45 509 509 00/42/16.09G UEB an RR 199701691 199701691
12032 12032 51 509 509 00/42/16.11G NUE 199701701 199701701
12518 12518 46 509 509 00/42/14Ga MUE 199701770 199701770
13561 13561 38 509 509 00/42/17G ERL 199700172 199700172
14574 14574 16 509 509 00/42/04G UEB an WAK 199701722 199701722
14948 14948 8 509 509 00/42/16.10G NUE 199701700 199701700
16447 16447 14 509 509 00/42/11G GEW 199701714 199701714
16659 16659 15 509 509 00/42/11T GEW 199701714 199701714
17444 17444 39 509 509 00/42/10aG KTS 199701109 199701109
18028 18028 31 509 509 00/42/08G KTS 199701743 199701743
18255 18255 50 509 509 00/42/16.05G UEB an RR 199701685 199701685
18653 18653 28 509 509 00/42/12G ZUS 199701683 199701683
18809 18809 24 509 509 00/42/05G UEB an PETK 199701741 199701741
19566 19566 4 509 509 00/42/16.08G UEB an RR 199701688 199701688
20222 20222 13 509 509 00/42/20Gf SCR 199701636 199701636
20826 20826 3 509 509 00/42/16.04G UEB an RR 199701684 199701684
22998 22998 21 509 509 00/42/20Ge SCR 199701733 199701733
23480 23480 25 509 509 00/42/09dG STL an RR 198000101 198000101
25671 25671 47 509 509 00/42/03G KTS 199701704 199701704
26164 26164 11 509 509 00/42/16.01G UEB an RR 199701672 199701672
26434 26434 34 509 509 00/42/19G UEB an RR 199701341 199701341
26883 26883 27 509 509 00/42/02Ga GES 199701469 199701469
27286 27286 19 509 509 00/42/20Gd SCR 199701726 199701726
27498 27498 20 509 509 00/42/20Gc SCR 199701727 199701727
28118 28118 26 509 509 00/42/10bG KTS 199701468 199701468
28478 28478 43 509 509 00/42/09cG STL an WAK 199700645 199700645
30448 30448 1 509 509 00/42/16.02G UEB an RR 199701674 199701674
30895 30895 36 509 509 00/42/21G ERL 199701029 199701029
31373 31373 48 509 509 00/42/09bG STL an RR 199700627 199700627
31669 31669 44 509 509 00/42/01Ga BUE 199701717 199701717
32520 32520 6 509 509 00/42/20Gb SCR 199701689 199701689
32747 32747 33 509 509 00/42/09aG STL an RR 199203312 199203312
32946 32946 22 509 509 00/42/20Ga SCR 199701732 199701732

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