Vorgaenge

25 rows where siz_nr = 614

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: nummer, Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
408 408 3 614 614     200101493 200101493
2390 2390 11 614 614     200101542 200101542
3971 3971 21 614 614     199203368 199203368
4244 4244 14 614 614 04/23/04Ga Kenntnisnahme 200101564 200101564
5454 5454 6 614 614     200100344 200100344
7540 7540 17 614 614     200101552 200101552
10669 10669 12 614 614 04/23/03G Kenntnisnahme 200101547 200101547
10918 10918 9 614 614 04/23/02Gb Überweisung an Petitionskommission 200101546 200101546
11171 11171 5 614 614     200101331 200101331
13053 13053 10 614 614     200101545 200101545
14546 14546 11 614 614     200101541 200101541
14663 14663 10 614 614     200101544 200101544
15296 15296 7 614 614     200100951 200100951
16072 16072 13 614 614 04/23/05Ga Kenntnisnahme 200100885 200100885
19016 19016 16 614 614     200101556 200101556
19976 19976 8 614 614 04/23/01Ga Überweisung an BRK 200101539 200101539
21814 21814 1 614 614     200100846 200100846
22549 22549 20 614 614     199700463 199700463
22592 22592 19 614 614     200100509 200100509
23042 23042 2 614 614     200101139 200101139
29096 29096 2 614 614     199700775 199700775
29318 29318 4 614 614     199701855 199701855
30552 30552 6 614 614     200100343 200100343
32356 32356 15 614 614     200101494 200101494
33121 33121 18 614 614     200100476 200100476

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