Vorgaenge
56 rows where siz_nr = 409
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
1400 | 1400 | 23 | 409 409 | 199700317 199700317 | ||
3252 | 3252 | 24 | 409 409 | 199700451 199700451 | ||
3759 | 3759 | 15 | 409 409 | 199700513 199700513 | ||
4642 | 4642 | 2 | 409 409 | 199700496 199700496 | ||
4973 | 4973 | 43 | 409 409 | 199700470 199700470 | ||
5044 | 5044 | 20 | 409 409 | 199700495 199700495 | ||
5816 | 5816 | 6 | 409 409 | 199700488 199700488 | ||
6436 | 6436 | 57 | 409 409 | 199700482 199700482 | ||
6793 | 6793 | 35 | 409 409 | 199700460 199700460 | ||
7591 | 7591 | 9 | 409 409 | 199203211 199203211 | ||
7646 | 7646 | 25 | 409 409 | 199700476 199700476 | ||
8593 | 8593 | 21 | 409 409 | 199700497 199700497 | ||
8985 | 8985 | 11 | 409 409 | 199700437 199700437 | ||
9036 | 9036 | 7 | 409 409 | 199700489 199700489 | ||
9628 | 9628 | 13 | 409 409 | 199700501 199700501 | ||
9902 | 9902 | 49 | 409 409 | 199700474 199700474 | ||
10028 | 10028 | 51 | 409 409 | 199700449 199700449 | ||
10055 | 10055 | 17 | 409 409 | 199700479 199700479 | ||
10914 | 10914 | 27 | 409 409 | 199700439 199700439 | ||
11205 | 11205 | 47 | 409 409 | 199700481 199700481 | ||
11717 | 11717 | 31 | 409 409 | 199700455 199700455 | ||
11998 | 11998 | 10 | 409 409 | 199700450 199700450 | ||
13372 | 13372 | 12 | 409 409 | 199700452 199700452 | ||
13668 | 13668 | 32 | 409 409 | 199700456 199700456 | ||
14744 | 14744 | 50 | 409 409 | 199700484 199700484 | ||
15241 | 15241 | 8 | 409 409 | 199700493 199700493 | ||
15910 | 15910 | 30 | 409 409 | 199700443 199700443 | ||
16328 | 16328 | 48 | 409 409 | 199700469 199700469 | ||
16666 | 16666 | 38 | 409 409 | 199700464 199700464 | ||
17610 | 17610 | 36 | 409 409 | 199700461 199700461 | ||
17719 | 17719 | 33 | 409 409 | 199700457 199700457 | ||
17823 | 17823 | 55 | 409 409 | 199700491 199700491 | ||
17835 | 17835 | 4 | 409 409 | 199700486 199700486 | ||
17900 | 17900 | 46 | 409 409 | 199700473 199700473 | ||
19855 | 19855 | 54 | 409 409 | 199700475 199700475 | ||
23860 | 23860 | 18 | 409 409 | 199700480 199700480 | ||
24204 | 24204 | 16 | 409 409 | 199700478 199700478 | ||
24419 | 24419 | 39 | 409 409 | 199700463 199700463 | ||
24934 | 24934 | 44 | 409 409 | 199700472 199700472 | ||
24972 | 24972 | 42 | 409 409 | 199700467 199700467 | ||
24990 | 24990 | 19 | 409 409 | 199700494 199700494 | ||
25609 | 25609 | 41 | 409 409 | 199700466 199700466 | ||
26569 | 26569 | 28 | 409 409 | 199700440 199700440 | ||
26753 | 26753 | 26 | 409 409 | 199700477 199700477 | ||
26839 | 26839 | 40 | 409 409 | 199700468 199700468 | ||
27345 | 27345 | 52 | 409 409 | 199700459 199700459 | ||
28040 | 28040 | 56 | 409 409 | 199700454 199700454 | ||
28469 | 28469 | 1 | 409 409 | 199700236 199700236 | ||
28533 | 28533 | 34 | 409 409 | 199700458 199700458 | ||
28726 | 28726 | 53 | 409 409 | 199700465 199700465 | ||
29179 | 29179 | 45 | 409 409 | 199700471 199700471 | ||
29560 | 29560 | 5 | 409 409 | 199700487 199700487 | ||
31267 | 31267 | 22 | 409 409 | 199700502 199700502 | ||
32178 | 32178 | 3 | 409 409 | 199700485 199700485 | ||
32568 | 32568 | 14 | 409 409 | 199700512 199700512 | ||
33046 | 33046 | 37 | 409 409 | 199700462 199700462 |
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");