home / GrosserRat / Vorgaenge

Menu
  • Sign in with GitHub

Vorgaenge

65 rows where siz_nr = 234

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
1978 1978 56 234 234 93/06/22G   198802291 198802291
2406 2406 61 234 234 93/06/21G   199201784 199201784
3091 3091 25 234 234 93/06/35bG   199202020 199202020
3423 3423 9 234 234 93/06/33G   198802669 198802669
3443 3443 28 234 234 93/06/12G   198802350 198802350
3663 3663 39 234 234 93/06/02G   199202745 199202745
3756 3756 19 234 234 93/06/25.03G   199202607 199202607
4009 4009 15 234 234 93/06/23G   199201785 199201785
4344 4344 6 234 234 93/06/14G   199202757 199202757
4383 4383 36 234 234 93/06/25.11G   199202732 199202732
4954 4954 21 234 234 93/06/25.06G   199202332 199202332
5087 5087 63 234 234 93/06/05G   199202747 199202747
6027 6027 20 234 234 93/06/25.04G   199202518 199202518
7077 7077 45 234 234 93/06/17G   199201743 199201743
8922 8922 55 234 234 93/06/25.05G UEB an RR 199202728 199202728
9898 9898 53 234 234 93/06/32G   198802339 198802339
10025 10025 31 234 234 93/06/27G   199201753 199201753
10274 10274 10 234 234 93/06/28G   198802694 198802694
10607 10607 65 234 234 93/06/20G   199201865 199201865
12317 12317 60 234 234 93/06/35aG   199202069 199202069
12401 12401 38 234 234 93/06/04G   199202741 199202741
13103 13103 52 234 234 93/06/19G   199201736 199201736
13293 13293 22 234 234 93/06/23Gc   199201789 199201789
14533 14533 17 234 234 93/06/26G   199201623 199201623
14879 14879 62 234 234 93/06/25.07G   199202450 199202450
15252 15252 18 234 234 93/06/25.01G   199202662 199202662
15470 15470 37 234 234 93/06/27Gc   199201757 199201757
15635 15635 42 234 234 93/06/20Gf   199202752 199202752
15703 15703 24 234 234 93/06/35cG   199201986 199201986
15740 15740 44 234 234 93/06/34.04G   198802499 198802499
16253 16253 8 234 234 93/06/34.03G   198802417 198802417
16942 16942 5 234 234 93/06/18G   199202756 199202756
17069 17069 48 234 234 93/06/31G   199201731 199201731
17898 17898 7 234 234 93/06/23Gb   199201788 199201788
18329 18329 11 234 234 93/06/22Gb   198802294 198802294
18505 18505 4 234 234 93/06/20Ge   199202755 199202755
19406 19406 26 234 234 93/06/25.02G UEB an RR 199202727 199202727
19850 19850 50 234 234 93/06/19Ga   199201735 199201735
19979 19979 49 234 234 93/06/30G   199201734 199201734
21189 21189 29 234 234 93/06/25.09G   199202220 199202220
21835 21835 27 234 234 93/06/11G   198400456 198400456
22238 22238 32 234 234 93/06/27Gb   199201752 199201752
22239 22239 41 234 234 93/06/20Gd   199202751 199202751
22530 22530 46 234 234 93/06/17Ga   199201742 199201742
22940 22940 35 234 234 93/06/25.08G UEB an RR 199202348 199202348
23201 23201 16 234 234 93/06/16G   199202759 199202759
23481 23481 59 234 234 93/06/15G   199201756 199201756
25114 25114 12 234 234 93/06/13G STL 198802423 198802423
25306 25306 2 234 234 93/06/08G   198802672 198802672
25596 25596 54 234 234 93/06/25.12G   199202303 199202303
25615 25615 13 234 234 93/06/03G   199202738 199202738
25727 25727 3 234 234 93/06/20Gc   199202754 199202754
25928 25928 33 234 234 93/06/25.10G   199202241 199202241
26758 26758 57 234 234 93/06/22Ga   198802269 198802269
26978 26978 23 234 234 93/06/35dG   199202112 199202112
27343 27343 40 234 234 93/06/20Gb   199202750 199202750
27377 27377 64 234 234 93/06/23Ga   199201759 199201759
27601 27601 43 234 234 93/06/20Ga   199202753 199202753
28151 28151 51 234 234 93/06/06G   199201748 199201748
29619 29619 58 234 234 93/06/09G STL an RR 198802419 198802419
29836 29836 30 234 234 93/06/10G   198802330 198802330
31727 31727 34 234 234 93/06/24.02G   199201840 199201840
32589 32589 47 234 234 93/06/29G   199201745 199201745
32599 32599 1 234 234 93/06/25.13G   199202733 199202733
33146 33146 14 234 234 93/06/27Ga   199201751 199201751

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