Vorgaenge

22 rows where siz_nr = 177

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
1160 1160 6 177 177 91/26/03G   198801784 198801784
1565 1565 16 177 177 91/26/15G   198802546 198802546
4146 4146 8 177 177 91/26/10G   198802009 198802009
4567 4567 3 177 177 91/26/16G   198801769 198801769
5397 5397 13 177 177 91/26/17G   198801756 198801756
5924 5924 19 177 177 91/26/12G   198801627 198801627
6899 6899 1 177 177 91/26/04G   198000094 198000094
12359 12359 2 177 177 91/26/18G   198801785 198801785
12365 12365 14 177 177 91/26/11G   198802002 198802002
14142 14142 17 177 177 91/26/23G   198801996 198801996
14504 14504 11 177 177 91/26/07G   198801736 198801736
14897 14897 9 177 177 91/26/05G   198801792 198801792
16035 16035 21 177 177 91/26/20G   198801763 198801763
18232 18232 10 177 177 91/26/08G   198801735 198801735
19596 19596 5 177 177 91/26/22G   198801776 198801776
22898 22898 20 177 177 91/26/04Ga   198802248 198802248
24009 24009 7 177 177 91/26/21G   198801786 198801786
24685 24685 4 177 177 91/26/06G   198801775 198801775
24946 24946 18 177 177 91/26/09G   198801727 198801727
27387 27387 12 177 177 91/26/19G   198801746 198801746
28211 28211 15 177 177 91/26/13G   198802003 198802003
31880 31880 22 177 177 91/26/14G   198400291 198400291

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");