home / GrosserRat / Vorgaenge

Menu
  • Sign in with GitHub

Vorgaenge

39 rows where siz_nr = 424

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
421 421 17 424 424     199700618 199700618
569 569 1 424 424     199700596 199700596
1643 1643 3 424 424     199700522 199700522
3015 3015 24 424 424     199700595 199700595
3352 3352 7 424 424     199700597 199700597
4454 4454 38 424 424     199700640 199700640
4574 4574 32 424 424     199700641 199700641
5304 5304 41 424 424     199700583 199700583
5436 5436 40 424 424     199700604 199700604
6361 6361 39 424 424     199700579 199700579
6803 6803 21 424 424     199700622 199700622
9240 9240 9 424 424     199700600 199700600
9474 9474 25 424 424     199700609 199700609
9654 9654 31 424 424     199700639 199700639
10021 10021 26 424 424     199700613 199700613
10763 10763 34 424 424     199700580 199700580
11989 11989 29 424 424     199700625 199700625
12209 12209 15 424 424     199700616 199700616
13496 13496 20 424 424     199700621 199700621
14918 14918 4 424 424     199700165 199700165
15545 15545 8 424 424     199700598 199700598
15701 15701 30 424 424     199700638 199700638
15787 15787 13 424 424     199700605 199700605
16991 16991 14 424 424     199700614 199700614
18101 18101 19 424 424     199700620 199700620
18864 18864 10 424 424     199700601 199700601
19019 19019 12 424 424     199700603 199700603
19341 19341 18 424 424     199700619 199700619
19858 19858 2 424 424     199700617 199700617
20204 20204 37 424 424     199700612 199700612
20360 20360 36 424 424     199700624 199700624
24766 24766 33 424 424     199700626 199700626
25276 25276 23 424 424     199700608 199700608
27441 27441 5 424 424     199700610 199700610
27915 27915 11 424 424     199700602 199700602
28090 28090 22 424 424     199700623 199700623
28943 28943 28 424 424     199202988 199202988
30793 30793 35 424 424     199700594 199700594
31802 31802 27 424 424     199700611 199700611

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