Vorgaenge
51 rows where siz_nr = 491
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
1407 | 1407 | 43 | 491 491 | 199701508 199701508 | ||
1496 | 1496 | 4 | 491 491 | 199701487 199701487 | ||
1957 | 1957 | 33 | 491 491 | 199203335 199203335 | ||
2986 | 2986 | 19 | 491 491 | 199701516 199701516 | ||
3045 | 3045 | 45 | 491 491 | 199701527 199701527 | ||
3211 | 3211 | 47 | 491 491 | 199701493 199701493 | ||
3748 | 3748 | 39 | 491 491 | 199701494 199701494 | ||
4427 | 4427 | 7 | 491 491 | 199701495 199701495 | ||
4541 | 4541 | 2 | 491 491 | 199701488 199701488 | ||
4961 | 4961 | 41 | 491 491 | 199701387 199701387 | ||
5486 | 5486 | 11 | 491 491 | 199701486 199701486 | ||
5577 | 5577 | 10 | 491 491 | 199701515 199701515 | ||
6571 | 6571 | 28 | 491 491 | 199701498 199701498 | ||
8926 | 8926 | 32 | 491 491 | 199203334 199203334 | ||
9133 | 9133 | 49 | 491 491 | 199700988 199700988 | ||
9360 | 9360 | 3 | 491 491 | 199701507 199701507 | ||
10349 | 10349 | 23 | 491 491 | 199701522 199701522 | ||
10729 | 10729 | 16 | 491 491 | 199701511 199701511 | ||
10900 | 10900 | 5 | 491 491 | 199701525 199701525 | ||
11055 | 11055 | 36 | 491 491 | 199203669 199203669 | ||
11545 | 11545 | 34 | 491 491 | 199203088 199203088 | ||
11766 | 11766 | 37 | 491 491 | 199202846 199202846 | ||
15279 | 15279 | 40 | 491 491 | 199701330 199701330 | ||
15995 | 15995 | 26 | 491 491 | 199701529 199701529 | ||
16164 | 16164 | 8 | 491 491 | 199701496 199701496 | ||
16850 | 16850 | 48 | 491 491 | 199701490 199701490 | ||
18504 | 18504 | 27 | 491 491 | 199701489 199701489 | ||
19416 | 19416 | 12 | 491 491 | 199701505 199701505 | ||
19645 | 19645 | 6 | 491 491 | 199701492 199701492 | ||
19892 | 19892 | 46 | 491 491 | 199700398 199700398 | ||
20804 | 20804 | 14 | 491 491 | 199701509 199701509 | ||
21307 | 21307 | 20 | 491 491 | 199701518 199701518 | ||
21831 | 21831 | 24 | 491 491 | 199701523 199701523 | ||
22402 | 22402 | 29 | 491 491 | 199701497 199701497 | ||
23878 | 23878 | 50 | 491 491 | 199701513 199701513 | ||
24574 | 24574 | 18 | 491 491 | 199701514 199701514 | ||
24964 | 24964 | 51 | 491 491 | 199701501 199701501 | ||
25564 | 25564 | 52 | 491 491 | 199701476 199701476 | ||
26324 | 26324 | 35 | 491 491 | 199700687 199700687 | ||
26479 | 26479 | 22 | 491 491 | 199701521 199701521 | ||
26737 | 26737 | 25 | 491 491 | 199701524 199701524 | ||
27653 | 27653 | 38 | 491 491 | 199700196 199700196 | ||
27963 | 27963 | 17 | 491 491 | 199701512 199701512 | ||
28512 | 28512 | 21 | 491 491 | 199701519 199701519 | ||
30072 | 30072 | 42 | 491 491 | 199701504 199701504 | ||
31050 | 31050 | 44 | 491 491 | 199701517 199701517 | ||
31063 | 31063 | 1 | 491 491 | 199701545 199701545 | ||
31164 | 31164 | 15 | 491 491 | 199701510 199701510 | ||
31217 | 31217 | 9 | 491 491 | 199701491 199701491 | ||
32047 | 32047 | 30 | 491 491 | 199701500 199701500 | ||
32270 | 32270 | 31 | 491 491 | 199202540 199202540 |
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");