home / GrosserRat / Vorgaenge

Menu
  • Sign in with GitHub

Vorgaenge

42 rows where siz_nr = 662

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: nummer, Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
1371 1371 9 662 662     199700251 199700251
1566 1566 26 662 662 06/26/2.26G Kenntnisnahme 200102520 200102520
1739 1739 27 662 662 06/26/2.27G Kenntnisnahme 200102521 200102521
2559 2559 11 662 662 06/26/2.11G Überweisung an FKom 200102472 200102472
2641 2641 5 662 662     200102483 200102483
3253 3253 15 662 662     200102497 200102497
3334 3334 12 662 662 06/26/2.12G Überweisung an FKom 200102471 200102471
4647 4647 9 662 662     200100768 200100768
5562 5562 28 662 662 06/26/2.16G Überweisung an WAK 200102518 200102518
5597 5597 3 662 662     200102474 200102474
6897 6897 19 662 662 06/26/2.19G Kenntnisnahme 200102507 200102507
7031 7031 21 662 662 06/26/2.21G Überweisung an FKom 200102486 200102486
7783 7783 16 662 662 06/26/2.21Ga Kenntnisnahme 200102495 200102495
8547 8547 25 662 662 06/26/2.25G Kenntnisnahme 200102515 200102515
9502 9502 9 662 662     200102108 200102108
9635 9635 24 662 662     200101951 200101951
11374 11374 9 662 662     199701158 199701158
12080 12080 8 662 662     200102257 200102257
13663 13663 15 662 662     200102498 200102498
15915 15915 9 662 662     200100767 200100767
16492 16492 15 662 662     200102493 200102493
18020 18020 22 662 662     199701796 199701796
18054 18054 20 662 662 06/26/2.20G Kenntnisnahme 200101927 200101927
18414 18414 9 662 662     200101192 200101192
19070 19070 6 662 662     200102432 200102432
19568 19568 9 662 662     200100612 200100612
20491 20491 10 662 662 06/26/2.10G Überweisung an FKom 200102464 200102464
20573 20573 15 662 662     200102496 200102496
21949 21949 7 662 662     200102499 200102499
22825 22825 18 662 662 06/26/2.23G Kenntnisnahme 200102506 200102506
25352 25352 15 662 662     200102500 200102500
25435 25435 23 662 662     200101565 200101565
26229 26229 17 662 662 06/26./2.22G Kenntnisnahme 200102504 200102504
28084 28084 1 662 662     200102194 200102194
28355 28355 15 662 662     200102502 200102502
28834 28834 14 662 662 06/26/2.14G Überweisung an BKK 200102510 200102510
29273 29273 13 662 662 06/26/2.13G Überweisung an BRK 200102509 200102509
30806 30806 2 662 662     200102473 200102473
30938 30938 15 662 662     200102494 200102494
31395 31395 9 662 662     199701432 199701432
31451 31451 4 662 662     200102489 200102489
31842 31842 8 662 662     200100092 200100092

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