home / GrosserRat / Vorgaenge

Menu
  • Sign in with GitHub

Vorgaenge

62 rows where siz_nr = 232

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
742 742 52 232 232 93/01/04G   199201733 199201733
757 757 38 232 232 93/01/36G   198801920 198801920
1035 1035 60 232 232 93/01/39G   198802396 198802396
1288 1288 33 232 232 93/01/06G   199202731 199202731
1609 1609 10 232 232 93/01/37G   198400529 198400529
2815 2815 41 232 232 93/01/14G   199201715 199201715
3009 3009 19 232 232 93/01/17G   199201699 199201699
3470 3470 61 232 232 93/01/31G   198802259 198802259
3867 3867 56 232 232 93/01/12G   199201717 199201717
4372 4372 39 232 232 93/01/15G   199201714 199201714
5215 5215 2 232 232 93/01/42G   198802375 198802375
5632 5632 6 232 232 93/01/45G   198400479 198400479
5654 5654 24 232 232 93/01/24.05G   199201945 199201945
6718 6718 54 232 232 93/01/41G   198802341 198802341
6880 6880 8 232 232 93/01/22G   198400452 198400452
6976 6976 29 232 232 93/01/46G   198802409 198802409
7823 7823 13 232 232 93/01/26.04G   198802286 198802286
8526 8526 7 232 232 93/01/38G   198400481 198400481
8632 8632 36 232 232 93/01/48G   199201883 199201883
8751 8751 18 232 232 93/01/08G   198802388 198802388
10361 10361 42 232 232 93/01/34G   198400526 198400526
10695 10695 5 232 232 93/01/26.01G   198802271 198802271
10715 10715 9 232 232 93/01/32.03G   198802288 198802288
10799 10799 58 232 232 93/01/24.17G   199202252 199202252
10898 10898 17 232 232 93/01/19G   198802673 198802673
11439 11439 43 232 232 93/01/26bG   199201662 199201662
11602 11602 12 232 232 93/01/07aG   198802693 198802693
12516 12516 31 232 232 93/01/03G   199202740 199202740
13793 13793 62 232 232 93/01/43G   198802225 198802225
14095 14095 21 232 232 93/01/32.02G   198400524 198400524
14265 14265 3 232 232 93/01/23G   198802304 198802304
14377 14377 35 232 232 93/01/07bG   198802659 198802659
14799 14799 59 232 232 93/01/29G   198802491 198802491
15274 15274 23 232 232 93/01/24.04G UEB an RR 199202721 199202721
15505 15505 30 232 232 93/01/24.18G   199202251 199202251
16930 16930 32 232 232 93/01/05G   199202730 199202730
17131 17131 49 232 232 93/01/32.01G   198000106 198000106
17676 17676 16 232 232 93/01/09G   198802661 198802661
17831 17831 22 232 232 93/01/11G   199202737 199202737
17910 17910 53 232 232 93/01/10aG   198802637 198802637
17920 17920 51 232 232 93/01/35G   198802360 198802360
18066 18066 25 232 232 93/01/24.02G   199202436 199202436
18100 18100 4 232 232 93/01/40G   198802302 198802302
18930 18930 44 232 232 93/01/44G   198802359 198802359
19118 19118 46 232 232 93/01/21G   198802334 198802334
19582 19582 11 232 232 93/01/20G   198400436 198400436
20685 20685 50 232 232 93/01/47G   199201746 199201746
21472 21472 48 232 232 93/01/13G   199201709 199201709
22919 22919 47 232 232 93/01/25G   198802335 198802335
22970 22970 57 232 232 93/01/10bG   199201744 199201744
23172 23172 15 232 232 93/01/26.03G   198802285 198802285
23699 23699 14 232 232 93/01/26.02G   198802282 198802282
24234 24234 28 232 232 93/01/24.01G UEB an RR 199202716 199202716
24981 24981 55 232 232 93/01/16G   199201696 199201696
27009 27009 37 232 232 93/01/33G   198802500 198802500
28833 28833 20 232 232 93/01/28G   198400523 198400523
29064 29064 27 232 232 93/01/30G   198802503 198802503
30841 30841 34 232 232 93/01/24.16G   199202250 199202250
31278 31278 26 232 232 93/01/24.03G   199201848 199201848
31413 31413 45 232 232 93/01/07cG   199201741 199201741
31677 31677 40 232 232 93/01/18G   199201718 199201718
31782 31782 1 232 232 93/01/27G   198802266 198802266

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