Vorgaenge
65 rows where siz_nr = 336
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | nummer | siz_nr | beschlnr | Vermerk | laufnr_ges |
---|---|---|---|---|---|---|
127 | 127 | 30 | 336 336 | 199203417 199203417 | ||
775 | 775 | 67 | 336 336 | 199203367 199203367 | ||
1174 | 1174 | 12 | 336 336 | 199203398 199203398 | ||
2275 | 2275 | 51 | 336 336 | 199203394 199203394 | ||
2656 | 2656 | 38 | 336 336 | 199202992 199202992 | ||
3936 | 3936 | 68 | 336 336 | 199203379 199203379 | ||
3941 | 3941 | 62 | 336 336 | 199203397 199203397 | ||
4334 | 4334 | 61 | 336 336 | 199202483 199202483 | ||
4609 | 4609 | 29 | 336 336 | 199203416 199203416 | ||
4618 | 4618 | 66 | 336 336 | 199203393 199203393 | ||
4856 | 4856 | 48 | 336 336 | 199203389 199203389 | ||
4952 | 4952 | 65 | 336 336 | 199203137 199203137 | ||
5553 | 5553 | 13 | 336 336 | 199203401 199203401 | ||
5806 | 5806 | 46 | 336 336 | 199203377 199203377 | ||
6480 | 6480 | 43 | 336 336 | 199203371 199203371 | ||
6503 | 6503 | 42 | 336 336 | 199203370 199203370 | ||
6710 | 6710 | 52 | 336 336 | 199203380 199203380 | ||
6800 | 6800 | 55 | 336 336 | 199203356 199203356 | ||
7881 | 7881 | 57 | 336 336 | 199203369 199203369 | ||
8175 | 8175 | 10 | 336 336 | 199203212 199203212 | ||
8461 | 8461 | 63 | 336 336 | 199203375 199203375 | ||
9996 | 9996 | 5 | 336 336 | 199203432 199203432 | ||
10342 | 10342 | 47 | 336 336 | 199203378 199203378 | ||
10363 | 10363 | 69 | 336 336 | 199203373 199203373 | ||
10713 | 10713 | 4 | 336 336 | 199203395 199203395 | ||
11052 | 11052 | 37 | 336 336 | 199203435 199203435 | ||
11768 | 11768 | 23 | 336 336 | 199203413 199203413 | ||
11902 | 11902 | 35 | 336 336 | 199203433 199203433 | ||
12279 | 12279 | 8 | 336 336 | 199203363 199203363 | ||
13013 | 13013 | 49 | 336 336 | 199203390 199203390 | ||
14530 | 14530 | 60 | 336 336 | 199203422 199203422 | ||
14706 | 14706 | 32 | 336 336 | 199203419 199203419 | ||
14731 | 14731 | 14 | 336 336 | 199203402 199203402 | ||
15775 | 15775 | 64 | 336 336 | 199203382 199203382 | ||
16181 | 16181 | 25 | 336 336 | 199203392 199203392 | ||
16229 | 16229 | 34 | 336 336 | 199203421 199203421 | ||
16571 | 16571 | 33 | 336 336 | 199203420 199203420 | ||
17023 | 17023 | 22 | 336 336 | 199203412 199203412 | ||
17319 | 17319 | 20 | 336 336 | 199203409 199203409 | ||
17718 | 17718 | 28 | 336 336 | 199203415 199203415 | ||
18211 | 18211 | 15 | 336 336 | 199203404 199203404 | ||
19162 | 19162 | 2 | 336 336 | 199203423 199203423 | ||
19387 | 19387 | 11 | 336 336 | 199203399 199203399 | ||
19974 | 19974 | 7 | 336 336 | 199203365 199203365 | ||
20120 | 20120 | 59 | 336 336 | 199203385 199203385 | ||
20385 | 20385 | 53 | 336 336 | 199203383 199203383 | ||
20447 | 20447 | 3 | 336 336 | 199202969 199202969 | ||
20660 | 20660 | 40 | 336 336 | 199203400 199203400 | ||
22041 | 22041 | 24 | 336 336 | 199203414 199203414 | ||
23155 | 23155 | 36 | 336 336 | 199203434 199203434 | ||
23226 | 23226 | 1 | 336 336 | 199203403 199203403 | ||
23924 | 23924 | 9 | 336 336 | 199203368 199203368 | ||
25252 | 25252 | 41 | 336 336 | 199203384 199203384 | ||
25512 | 25512 | 39 | 336 336 | 199203396 199203396 | ||
26606 | 26606 | 56 | 336 336 | 199203366 199203366 | ||
26894 | 26894 | 58 | 336 336 | 199203381 199203381 | ||
27506 | 27506 | 50 | 336 336 | 199203391 199203391 | ||
27662 | 27662 | 31 | 336 336 | 199203418 199203418 | ||
28344 | 28344 | 26 | 336 336 | 199203147 199203147 | ||
28587 | 28587 | 27 | 336 336 | 199203164 199203164 | ||
28953 | 28953 | 54 | 336 336 | 199203274 199203274 | ||
29633 | 29633 | 19 | 336 336 | 199203408 199203408 | ||
31471 | 31471 | 6 | 336 336 | 198802591 198802591 | ||
32293 | 32293 | 21 | 336 336 | 199203410 199203410 | ||
32864 | 32864 | 45 | 336 336 | 199203374 199203374 |
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");