Vorgaenge

35 rows where siz_nr = 519

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
117 117 23 519 519 00/50/13G ERL 199700731 199700731
2271 2271 31 519 519 00/50/09G RÜR an RR 199202093 199202093
2670 2670 6 519 519 00/50/09Gg RÜR an RR 199202936 199202936
3450 3450 24 519 519 00/50/17G ERL 199700279 199700279
4355 4355 7 519 519 00/50/21aG UEB an RR 199701859 199701859
4438 4438 16 519 519 00/50/16.06G UEB an RR 199701799 199701799
4524 4524 3 519 519 00/50/21cG UEB an RR 199701861 199701861
4983 4983 29 519 519 00/50/20G SCR 199701809 199701809
5174 5174 22 519 519 00/50/14G ERL 199701244 199701244
5679 5679 15 519 519 00/50/16.04G UEB an RR 199701784 199701784
5754 5754 35 519 519 00/50/08G ZUS 199701776 199701776
6270 6270 17 519 519 00/50/16.07G UEB an RR 199701802 199701802
7007 7007 12 519 519 00/50/20Gd SCR 199701765 199701765
7685 7685 8 519 519 00/50/21bG UEB an RR 199701860 199701860
9123 9123 13 519 519 00/50/16.01G UEB an RR 199701766 199701766
12131 12131 2 519 519 00/50/16.08G UEB an RR 199701801 199701801
12435 12435 14 519 519 00/50/16.02G UEB an RR 199701782 199701782
13164 13164 20 519 519 00/50/09Gf RÜR an RR 198802477 198802477
13440 13440 10 519 519 00/50/09Ge RÜR an RR 198802355 198802355
14695 14695 19 519 519 00/50/09Gd RÜR an RR 199701028 199701028
14784 14784 30 519 519 00/50/16.05G UEB an RR 199701798 199701798
15821 15821 18 519 519 00/50/09Gc RÜR an RR 199203944 199203944
16691 16691 26 519 519 00/50/12G ERL 199700829 199700829
19128 19128 5 519 519 00/50/10G ZUE 199701813 199701813
19995 19995 27 519 519 00/50/19G ERL 199700835 199700835
20295 20295 25 519 519 00/50/15G ERL 199701285 199701285
21247 21247 11 519 519 00/50/20Gc SCR 199701811 199701811
22489 22489 21 519 519 00/50/09Gb RÜR an RR 198802377 198802377
24212 24212 4 519 519 00/50/21dG UEB an RR 199701862 199701862
24727 24727 1 519 519 00/50/11G NUE 199701664 199701664
24933 24933 28 519 519 00/50/18G ERL 199700681 199700681
25044 25044 32 519 519 00/50/20Gb SCR 199701812 199701812
29451 29451 33 519 519 00/50/09Ga RÜR an RR 198802478 198802478
30410 30410 34 519 519 00/50/20Ga SCR 199701781 199701781
32489 32489 9 519 519 00/50/07G ZUS 199701830 199701830

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