Vorgaenge

20 rows where siz_nr = 293

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: laufnr_ges

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
1302 1302 9 293 293 94/45/11G   199202351 199202351
4765 4765 10 293 293 94/45/09cG   199202282 199202282
6978 6978 19 293 293 94/45/04G   199203019 199203019
8425 8425 18 293 293 94/45/06dG   199202372 199202372
10053 10053 7 293 293 94/45/14G   199202340 199202340
10145 10145 1 293 293 94/45/06aG   199202368 199202368
12081 12081 6 293 293 94/45/15G   199202347 199202347
12489 12489 8 293 293 94/45/13G   199202340 199202340
12791 12791 15 293 293 94/45/10G   199202288 199202288
13470 13470 3 293 293 94/45/07G UEB an RR 198800547 198800547
16755 16755 16 293 293 94/45/10Ga   199202379 199202379
16785 16785 14 293 293 94/45/03G   199203018 199203018
20208 20208 12 293 293 94/45/09aG   199202983 199202983
20793 20793 20 293 293 94/45/06bG   199202369 199202369
21554 21554 2 293 293 94/45/12G   199201784 199201784
22283 22283 11 293 293 94/45/09bG   199202983 199202983
24440 24440 13 293 293 94/45/06eG   199202367 199202367
29366 29366 17 293 293 94/45/08G   199203015 199203015
29963 29963 4 293 293 94/45/06cG   199202370 199202370
31293 31293 5 293 293 94/45/05G   198802692 198802692

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