Vorgaenge
41 rows where siz_nr = 1243
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
43461 | 43461 | 1 | 1243 1243 | 200113698 200113698 | ||
43462 | 43462 | 2 | 1243 1243 | 200113854 200113854 | ||
43463 | 43463 | 3 | 1243 1243 | 200113855 200113855 | ||
43464 | 43464 | 4 | 1243 1243 | 200113856 200113856 | ||
43465 | 43465 | 5 | 1243 1243 | 200113870 200113870 | ||
43466 | 43466 | 6 | 1243 1243 | 200113871 200113871 | ||
43467 | 43467 | 7 | 1243 1243 | 200113877 200113877 | ||
43468 | 43468 | 8 | 1243 1243 | 200113878 200113878 | ||
43469 | 43469 | 9 | 1243 1243 | 200113880 200113880 | ||
43470 | 43470 | 10 | 1243 1243 | 200113909 200113909 | ||
43471 | 43471 | 11 | 1243 1243 | 200113910 200113910 | ||
43472 | 43472 | 12 | 1243 1243 | 200113911 200113911 | ||
43473 | 43473 | 13 | 1243 1243 | 200113876 200113876 | ||
43474 | 43474 | 14 | 1243 1243 | 200113891 200113891 | ||
43475 | 43475 | 15 | 1243 1243 | 200113895 200113895 | ||
43476 | 43476 | 16 | 1243 1243 | 200113898 200113898 | ||
43477 | 43477 | 17 | 1243 1243 | 200113900 200113900 | ||
43478 | 43478 | 18 | 1243 1243 | 200113901 200113901 | ||
43479 | 43479 | 19 | 1243 1243 | 200113903 200113903 | ||
43480 | 43480 | 20 | 1243 1243 | 200113859 200113859 | ||
43481 | 43481 | 21 | 1243 1243 | 200113915 200113915 | ||
43482 | 43482 | 22 | 1243 1243 | 200113916 200113916 | ||
43483 | 43483 | 23 | 1243 1243 | 200113917 200113917 | ||
43484 | 43484 | 24 | 1243 1243 | 200113924 200113924 | ||
43485 | 43485 | 25 | 1243 1243 | 200113925 200113925 | ||
43486 | 43486 | 26 | 1243 1243 | 200113926 200113926 | ||
43487 | 43487 | 27 | 1243 1243 | 200113927 200113927 | ||
43488 | 43488 | 28 | 1243 1243 | 200113928 200113928 | ||
43489 | 43489 | 29 | 1243 1243 | 200113933 200113933 | ||
43490 | 43490 | 30 | 1243 1243 | 200113944 200113944 | ||
43491 | 43491 | 31 | 1243 1243 | 200113559 200113559 | ||
43492 | 43492 | 32 | 1243 1243 | 200113980 200113980 | ||
43493 | 43493 | 33 | 1243 1243 | 200113981 200113981 | ||
43502 | 43502 | 34 | 1243 1243 | 200113990 200113990 | ||
43522 | 43522 | 35 | 1243 1243 | 200113992 200113992 | ||
43525 | 43525 | 36 | 1243 1243 | 200113210 200113210 | ||
43526 | 43526 | 37 | 1243 1243 | 200113692 200113692 | ||
43527 | 43527 | 38 | 1243 1243 | 200113837 200113837 | ||
43528 | 43528 | 39 | 1243 1243 | 200114003 200114003 | ||
43529 | 43529 | 40 | 1243 1243 | 200114004 200114004 | ||
43531 | 43531 | 41 | 1243 1243 | 200113890 200113890 |
Advanced export
JSON shape: default, array, newline-delimited
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");