home / GrosserRat / Vorgaenge

Menu
  • Sign in with GitHub

Vorgaenge

34 rows where siz_nr = 744

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: nummer, Vermerk

Link rowid ▼ nummer siz_nr beschlnr Vermerk laufnr_ges
1955 1955 18 744 744     200104000 200104000
2026 2026 11 744 744     200104234 200104234
2893 2893 9 744 744     200104247 200104247
3028 3028 24 744 744 10/05/2.24G stehen lassen 199700776 199700776
4684 4684 13 744 744     200103976 200103976
6213 6213 4 744 744 10/05/2.4G Überweisung an BKK 200104217 200104217
7541 7541 1 744 744     200104178 200104178
8518 8518 19 744 744     200103981 200103981
10377 10377 26 744 744 10/05/2.26G Kenntnisnahme 200104094 200104094
11412 11412 18 744 744     200103146 200103146
11470 11470 10 744 744     200104240 200104240
11767 11767 3 744 744     200104191 200104191
11840 11840 8 744 744 10/05/2.8G Überweisung an BRK 200104230 200104230
12305 12305 10 744 744     200104244 200104244
15417 15417 17 744 744     200103682 200103682
15604 15604 14 744 744     200103974 200103974
17574 17574 20 744 744     200103988 200103988
17833 17833 15 744 744     200103120 200103120
18170 18170 5 744 744     200104218 200104218
18784 18784 23 744 744 10/05/2.23G Kenntnisnahme 200104232 200104232
20052 20052 7 744 744 10/05/2.7G Überweisung an BRK 200104231 200104231
21015 21015 17 744 744     200104004 200104004
21578 21578 10 744 744     200104237 200104237
22140 22140 2 744 744     200103991 200103991
22505 22505 28 744 744 10/05/2.28G Kenntnisnahme 200104194 200104194
23100 23100 22 744 744 10/05/2.22G Kenntnisnahme 200104220 200104220
25742 25742 10 744 744     200104243 200104243
27318 27318 10 744 744     200104236 200104236
28292 28292 6 744 744 10/05/2.6G Überweisung an PetKo 200104197 200104197
29719 29719 21 744 744     200103954 200103954
30074 30074 12 744 744     200103975 200103975
31294 31294 16 744 744     200103147 200103147
31671 31671 25 744 744 10/05/2.25G stehen lassen 200103109 200103109
32099 32099 27 744 744 10/05/2.27G Kenntnisnahme 200104110 200104110

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