home / GrosserRat / Vorgaenge

Menu
  • Sign in with GitHub

Vorgaenge

32 rows where siz_nr = 396

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
234 234 7 396 396 97/46/14G KTS 199700067 199700067
1439 1439 13 396 396 97/46/07G KTS 199700374 199700374
1898 1898 28 396 396 97/46/06G KTS 199700373 199700373
4202 4202 2 396 396 97/46/22G ERL 199203795 199203795
5781 5781 10 396 396 97/46/02G GEW 199700401 199700401
6343 6343 18 396 396 97/46/23G ZUS 199700255 199700255
6815 6815 11 396 396 97/46/20G KTS 199203929 199203929
7425 7425 5 396 396 97/46/19G KTS 199700071 199700071
9818 9818 21 396 396 97/46/22Gd ZUS 199700285 199700285
10704 10704 12 396 396 97/46/28G ZUS 199700142 199700142
10808 10808 19 396 396 97/46/27G UEB an GPK 199700316 199700316
11827 11827 23 396 396 97/46/26G ZUS 199700288 199700288
12376 12376 14 396 396 97/46/05G KTS 199700371 199700371
17361 17361 26 396 396 97/46/25G MUE 199700351 199700351
17566 17566 27 396 396 97/46/22Gc STL an RR 199203826 199203826
18254 18254 22 396 396 97/46/24G ZUS 199700335 199700335
18666 18666 8 396 396 97/46/01G GEW 199700399 199700399
18846 18846 24 396 396 97/46/16G KTS 199700358 199700358
20282 20282 4 396 396 97/46/13G STL an RR 199202514 199202514
20402 20402 6 396 396 97/46/15G KTS 199700378 199700378
20988 20988 20 396 396 97/46/10G STL an RR 199203168 199203168
21141 21141 30 396 396 97/46/22Gb ERL 199202860 199202860
23355 23355 15 396 396 97/46/04G KTS 199700372 199700372
24547 24547 17 396 396 97/46/17G KTS 199700389 199700389
24664 24664 9 396 396 97/46/03G GEW 199700400 199700400
24706 24706 32 396 396 97/46/11G STL an RR 198400502 198400502
25290 25290 1 396 396 97/46/12G STL an RR 198802244 198802244
26576 26576 31 396 396 97/46/22Ga STL an RR 199203006 199203006
27717 27717 3 396 396 97/46/09G STL an RR 199202764 199202764
28326 28326 25 396 396 97/46/08G KTS 199700355 199700355
29023 29023 16 396 396 97/46/21G UEB an PETK 199700380 199700380
30216 30216 29 396 396 97/46/18G KTS 199700388 199700388

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