home / GrosserRat / Vorgaenge

Menu
  • Sign in with GitHub

Vorgaenge

50 rows where siz_nr = 344

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
216 216 42 344 344 96/11/24G MUE 199203492 199203492
480 480 1 344 344 96/11/22G ERL 199202957 199202957
696 696 8 344 344 96/11/13G ERL 198802524 198802524
799 799 17 344 344 96/11/24Gf MUE 199203483 199203483
2095 2095 49 344 344 96/11/23.02G UEB an RR 199203425 199203425
3984 3984 32 344 344 96/11/25G SCR 199203466 199203466
4212 4212 4 344 344 96/11/27G UEB an FIHK 198802678 198802678
5329 5329 40 344 344 96/11/05G STL an RR 199202963 199202963
5584 5584 14 344 344 96/11/25Gi SCR 199203472 199203472
7740 7740 12 344 344 96/11/27Ga UEB an FIHK 199202430 199202430
7970 7970 11 344 344 96/11/18G ERL 199202279 199202279
8948 8948 36 344 344 96/11/25Gh SCR 199203469 199203469
9162 9162 34 344 344 96/11/12G ZUS 199202423 199202423
9208 9208 50 344 344 96/11/12Ga ZUS 198800547 198800547
9802 9802 6 344 344 96/11/16G ERL 199202974 199202974
9888 9888 21 344 344 96/11/28G ZUS 199203522 199203522
10894 10894 16 344 344 96/11/24Ge MUE 199203478 199203478
12556 12556 28 344 344 96/11/23.05G UEB an RR 199203451 199203451
12675 12675 9 344 344 96/11/04G STL an RR 199202869 199202869
12700 12700 48 344 344 96/11/09G ZUS 199203475 199203475
14259 14259 33 344 344 96/11/25Gq SCR 199203468 199203468
14343 14343 45 344 344 96/11/25Gg SCR 199203436 199203436
15478 15478 5 344 344 96/11/19G ERL 199202350 199202350
15726 15726 2 344 344 96/11/14G ERL 199203442 199203442
16325 16325 39 344 344 96/11/25Gf SCR 199203430 199203430
16628 16628 30 344 344 96/11/25Ge SCR 199203463 199203463
17212 17212 10 344 344 96/11/21G ERL 199201870 199201870
17252 17252 31 344 344 96/11/25Gd SCR 199203465 199203465
18111 18111 46 344 344 96/11/23.06G UEB an RR 199203454 199203454
18325 18325 7 344 344 96/11/17G ERL 199203444 199203444
19275 19275 23 344 344 96/11/11G ZUS 199203476 199203476
19455 19455 19 344 344 96/11/01G KTS 199203501 199203501
19908 19908 26 344 344 96/11/23.04G UEB an RR 199203431 199203431
19967 19967 27 344 344 96/11/25Gc SCR 199203448 199203448
20980 20980 44 344 344 96/11/06G KTS 199203060 199203060
21270 21270 18 344 344 96/11/24Gd MUE 199203494 199203494
21963 21963 24 344 344 96/11/23.01G UEB an RR 199203426 199203426
22291 22291 22 344 344 96/11/02bG KTS 199203087 199203087
22710 22710 25 344 344 96/11/23.03G UEB an RR 199203427 199203427
23062 23062 37 344 344 96/11/08G KTS 199203506 199203506
23073 23073 13 344 344 96/11/07G KTS 199203446 199203446
23107 23107 38 344 344 96/11/15G ERL 199203070 199203070
26092 26092 15 344 344 96/11/24Gc MUE 199203473 199203473
26121 26121 47 344 344 96/11/25Gb SCR 199203484 199203484
29463 29463 41 344 344 96/11/02aG KTS 199203141 199203141
30512 30512 20 344 344 96/11/24Gb MUE 199203502 199203502
31146 31146 43 344 344 96/11/24Ga MUE 199203497 199203497
31188 31188 29 344 344 96/11/25Ga SCR 199203462 199203462
32193 32193 3 344 344 96/11/20G ERL 199202908 199202908
32341 32341 35 344 344 96/11/10G ZUS 199203477 199203477

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