home / GrosserRat / Vorgaenge

Menu
  • Sign in with GitHub

Vorgaenge

51 rows where siz_nr = 76

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
135 135 4 76 76 88/37/13G   198802223 198802223
571 571 24 76 76 88/37/14pG   198400273 198400273
1556 1556 27 76 76 88/37/15G   198800561 198800561
2124 2124 37 76 76 88/37/18G   198800665 198800665
2233 2233 3 76 76 88/37/14dG   198400149 198400149
5341 5341 12 76 76 88/37/14bG   198400268 198400268
5668 5668 28 76 76 88/37/14jG   198400276 198400276
6522 6522 38 76 76 88/37/05G   198800496 198800496
6932 6932 46 76 76 88/37/24gG   198800655 198800655
7953 7953 17 76 76 88/37/24dG   198800652 198800652
7989 7989 48 76 76 88/37/01G   198800663 198800663
8050 8050 43 76 76 88/37/14hG   198400274 198400274
8058 8058 32 76 76 88/37/04G   198800565 198800565
9258 9258 10 76 76 88/37/01Gb   198800532 198800532
10433 10433 44 76 76 88/37/11G   199201546 199201546
11130 11130 6 76 76 88/37/09G   198800513 198800513
11572 11572 36 76 76 88/37/03G   198800664 198800664
13223 13223 35 76 76 88/37/18Ga   198800673 198800673
13456 13456 47 76 76 88/37/14fG   198400172 198400172
14137 14137 5 76 76 88/37/06G   198800511 198800511
15796 15796 34 76 76 88/37/14mG   198400279 198400279
15986 15986 2 76 76 88/37/14oG   198400182 198400182
18002 18002 1 76 76 88/37/14cG   198400195 198400195
18735 18735 22 76 76 88/37/23G   198800555 198800555
18973 18973 30 76 76 88/37/14kG   198400281 198400281
19425 19425 31 76 76 88/37/01Ga   198800661 198800661
19632 19632 49 76 76 88/37/14eG   198400262 198400262
19690 19690 42 76 76 88/37/24hG   198800656 198800656
21506 21506 51 76 76 88/37/14nG   198400147 198400147
21718 21718 13 76 76 88/37/14gG   198400270 198400270
21865 21865 8 76 76 88/37/08G   198800516 198800516
22220 22220 39 76 76 88/37/05Ga   198800496 198800496
22750 22750 29 76 76 88/37/20G   198400122 198400122
23524 23524 9 76 76 88/37/14lG   198400221 198400221
24236 24236 26 76 76 88/37/14iG   198400275 198400275
24656 24656 50 76 76 88/37/19G   198800490 198800490
26050 26050 23 76 76 88/37/22G   198800559 198800559
27039 27039 11 76 76 88/37/10G   198800536 198800536
27453 27453 33 76 76 88/37/04Ga   198800566 198800566
28315 28315 21 76 76 88/37/14aG   198400233 198400233
28574 28574 19 76 76 88/37/24fG   198800654 198800654
29578 29578 25 76 76 88/37/16G   198800560 198800560
29707 29707 16 76 76 88/37/24aG   198800650 198800650
29710 29710 41 76 76 88/37/24cG   198800651 198800651
29764 29764 7 76 76 88/37/07G   198800515 198800515
29952 29952 18 76 76 88/37/24eG   198800653 198800653
30953 30953 20 76 76 88/37/21G   198000031 198000031
30969 30969 14 76 76 88/37/12G   199201547 199201547
31603 31603 40 76 76 88/37/24iG   198800674 198800674
32186 32186 45 76 76 88/35/18   198800648 198800648
32799 32799 15 76 76 88/37/24bG   198800649 198800649

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