home / GrosserRat / Vorgaenge

Menu
  • Sign in with GitHub

Vorgaenge

35 rows where siz_nr = 371

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
379 379 28 371 371 97/02/12G VOL 199203913 199203913
1752 1752 26 371 371 97/02/06G KTS 199203933 199203933
2399 2399 9 371 371 97/02/21G ERL 198400489 198400489
2507 2507 16 371 371 97/02/21Gi ZUA 199202561 199202561
2699 2699 18 371 371 97/02/20G MUE 199203926 199203926
4430 4430 25 371 371 97/02/11G VOL 199203910 199203910
4840 4840 6 371 371 97/02/21Gh ERL 198802315 198802315
5244 5244 30 371 371 97/02/03.03G STL an RR 198802419 198802419
5647 5647 34 371 371 97/02/04.03G STL an RR 198000097 198000097
7277 7277 1 371 371 97/02/21Gg ERL 199203894 199203894
7746 7746 10 371 371 97/02/04.04G STL an RR 198400491 198400491
9093 9093 24 371 371 97/02/20Ga MUE 199203921 199203921
10399 10399 27 371 371 97/02/16G ZUS 199203911 199203911
11685 11685 33 371 371 97/02/18G ZUA 199203915 199203915
11932 11932 20 371 371 97/02/03.01G STL an RR 199202200 199202200
13023 13023 7 371 371 97/02/21Gf ERL 199202562 199202562
13992 13992 14 371 371 97/02/04.01G STL an RR 199202778 199202778
14703 14703 8 371 371 97/02/04.02G STL an RR 198000096 198000096
17014 17014 22 371 371 97/02/09G KTS 199203892 199203892
17191 17191 12 371 371 97/02/21Ge ERL 198802435 198802435
20393 20393 11 371 371 97/02/03.02G STL an RR 199201621 199201621
20886 20886 4 371 371 97/02/21Gd STL an RR 198802256 198802256
21629 21629 23 371 371 97/02/14G NZU 199203903 199203903
22010 22010 21 371 371 97/02/07G UEB an GVK 199203891 199203891
22040 22040 5 371 371 97/02/05G STL an RR 199202930 199202930
22133 22133 31 371 371 97/02/08G UEB an GVK 199203932 199203932
23396 23396 17 371 371 97/02/10G KTS 199203936 199203936
23495 23495 13 371 371 97/02/02G STL an RR 199202781 199202781
24435 24435 35 371 371 97/02/21Gc ERL 198000086 198000086
24759 24759 29 371 371 97/02/17G ERL 199203370 199203370
24900 24900 32 371 371 97/02/15G ZUS 199203890 199203890
27449 27449 2 371 371 97/02/19G ERL 198400441 198400441
28597 28597 19 371 371 97/02/13G UEB an RR 199203930 199203930
31415 31415 3 371 371 97/02/21Gb ERL 198400451 198400451
32482 32482 15 371 371 97/02/21Ga ZUA 199201837 199201837

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