Vorgaenge

26 rows where siz_nr = 556

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
714 714 23 556 556 02/02/34G NUE 200100383 200100383
5042 5042 17 556 556 02/02/34Gl ZUR 200100373 200100373
5138 5138 6 556 556 02/02/43G ERL 199701368 199701368
5335 5335 15 556 556 02/02/34Gk NUE 200100370 200100370
7024 7024 16 556 556 02/02/34Gj NUE 200100371 200100371
7895 7895 5 556 556 02/02/37G ERL 199701394 199701394
8735 8735 2 556 556 02/02/38G ERL 199701662 199701662
9757 9757 24 556 556 02/02/34Gi NUE 200100384 200100384
11887 11887 7 556 556 02/02/44G ERL 199701243 199701243
13324 13324 3 556 556 02/02/41G ERL 199203180 199203180
13748 13748 25 556 556 02/02/37Ga NEI 200100014 200100014
16541 16541 4 556 556 02/02/42G ERL 199203826 199203826
16761 16761 1 556 556 02/02/34Gh ZUR 200100372 200100372
16866 16866 10 556 556 02/02/44Ga ERL 199701278 199701278
17786 17786 22 556 556 02/02/34Gg NUE 200100378 200100378
17847 17847 21 556 556 02/02/34Gf NUE 200100377 200100377
19464 19464 18 556 556 02/02/34Ge ZUR 200100374 200100374
20695 20695 20 556 556 02/02/34Gd NUE 200100376 200100376
21724 21724 9 556 556 02/02/40G ERL 199700197 199700197
23326 23326 26 556 556 02/02/45G ERL 199701369 199701369
24707 24707 8 556 556 02/02/39G ERL 199701019 199701019
24876 24876 13 556 556 02/02/34Gc NUE 200100368 200100368
25367 25367 12 556 556 02/02/35G ZUS 200100294 200100294
26808 26808 19 556 556 02/02/34Gb NUE 200100375 200100375
30421 30421 14 556 556 02/02/34Ga NUE 200100369 200100369
32408 32408 11 556 556 02/02/36G ZUS 200100332 200100332

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