Einzelmessungen
- Datum
- Datum
- Datum_Zeit
- Datum und Uhrzeit als Text
- Fahrzeuglänge
- Vom Radar gemessene Fahrzeuglänge
- Geschwindigkeit
- Geschwindigkeit in km/h
- Messung-ID
- Laufnummer der Messung; eine Messung beinhaltet alle Fahrten eines Messgeräts an einem Standort
- Richtung ID
- ID der Richtung; In einer Messung werden i.d.R. Fahrten in zwei Richtungen gemessen.
- Timestamp
- Datum und Uhrzeit
- Zeit
- Uhrzeit (hh:mm:ss) der gemessenen Fahrt
4,661 rows where Messung-ID = 1127 sorted by Timestamp descending
This data as json, copyable, CSV (advanced)
Suggested facets: Datum, Timestamp (date)
| Link | rowid | Geschwindigkeit | Zeit | Datum | Richtung ID | Fahrzeuglänge | Messung-ID | Datum_Zeit | Timestamp ▲ |
|---|---|---|---|---|---|---|---|---|---|
| 2893551 | 2893551 | 32 | 05:51:14 | 15.01.26 | 1 | 4.5 | Dorfstrasse 1127 | 15.01.26 05:51:14 | 2026-01-15 05:51:14+01:00 |
| 2893550 | 2893550 | 24 | 05:47:50 | 15.01.26 | 1 | 1.8 | Dorfstrasse 1127 | 15.01.26 05:47:50 | 2026-01-15 05:47:50+01:00 |
| 2893549 | 2893549 | 28 | 05:39:40 | 15.01.26 | 1 | 1.5 | Dorfstrasse 1127 | 15.01.26 05:39:40 | 2026-01-15 05:39:40+01:00 |
| 2893548 | 2893548 | 26 | 05:27:47 | 15.01.26 | 1 | 4.3 | Dorfstrasse 1127 | 15.01.26 05:27:47 | 2026-01-15 05:27:47+01:00 |
| 2893547 | 2893547 | 22 | 05:26:57 | 15.01.26 | 1 | 1.4 | Dorfstrasse 1127 | 15.01.26 05:26:57 | 2026-01-15 05:26:57+01:00 |
| 2893546 | 2893546 | 19 | 05:21:15 | 15.01.26 | 1 | 4.7 | Dorfstrasse 1127 | 15.01.26 05:21:15 | 2026-01-15 05:21:15+01:00 |
| 2893545 | 2893545 | 17 | 05:20:03 | 15.01.26 | 1 | 4.6 | Dorfstrasse 1127 | 15.01.26 05:20:03 | 2026-01-15 05:20:03+01:00 |
| 2893544 | 2893544 | 19 | 05:10:46 | 15.01.26 | 1 | 4.3 | Dorfstrasse 1127 | 15.01.26 05:10:46 | 2026-01-15 05:10:46+01:00 |
| 2893543 | 2893543 | 18 | 04:49:53 | 15.01.26 | 1 | 5.2 | Dorfstrasse 1127 | 15.01.26 04:49:53 | 2026-01-15 04:49:53+01:00 |
| 2893542 | 2893542 | 29 | 04:34:49 | 15.01.26 | 1 | 1.8 | Dorfstrasse 1127 | 15.01.26 04:34:49 | 2026-01-15 04:34:49+01:00 |
| 2893541 | 2893541 | 16 | 04:33:28 | 15.01.26 | 1 | 3.9 | Dorfstrasse 1127 | 15.01.26 04:33:28 | 2026-01-15 04:33:28+01:00 |
| 2893540 | 2893540 | 32 | 04:02:48 | 15.01.26 | 1 | 2.7 | Dorfstrasse 1127 | 15.01.26 04:02:48 | 2026-01-15 04:02:48+01:00 |
| 2893539 | 2893539 | 20 | 01:25:21 | 15.01.26 | 1 | 4.2 | Dorfstrasse 1127 | 15.01.26 01:25:21 | 2026-01-15 01:25:21+01:00 |
| 2893538 | 2893538 | 27 | 00:36:42 | 15.01.26 | 1 | 3.7 | Dorfstrasse 1127 | 15.01.26 00:36:42 | 2026-01-15 00:36:42+01:00 |
| 2893537 | 2893537 | 18 | 00:25:11 | 15.01.26 | 1 | 4.2 | Dorfstrasse 1127 | 15.01.26 00:25:11 | 2026-01-15 00:25:11+01:00 |
| 2893536 | 2893536 | 23 | 00:15:58 | 15.01.26 | 1 | 4.8 | Dorfstrasse 1127 | 15.01.26 00:15:58 | 2026-01-15 00:15:58+01:00 |
| 2893535 | 2893535 | 26 | 23:46:56 | 14.01.26 | 1 | 4.2 | Dorfstrasse 1127 | 14.01.26 23:46:56 | 2026-01-14 23:46:56+01:00 |
| 2893534 | 2893534 | 22 | 23:44:52 | 14.01.26 | 1 | 1.5 | Dorfstrasse 1127 | 14.01.26 23:44:52 | 2026-01-14 23:44:52+01:00 |
| 2893533 | 2893533 | 18 | 23:41:51 | 14.01.26 | 1 | 4.8 | Dorfstrasse 1127 | 14.01.26 23:41:51 | 2026-01-14 23:41:51+01:00 |
| 2893532 | 2893532 | 20 | 23:37:02 | 14.01.26 | 1 | 1.2 | Dorfstrasse 1127 | 14.01.26 23:37:02 | 2026-01-14 23:37:02+01:00 |
| 2893531 | 2893531 | 24 | 23:08:09 | 14.01.26 | 1 | 1.7 | Dorfstrasse 1127 | 14.01.26 23:08:09 | 2026-01-14 23:08:09+01:00 |
| 2893530 | 2893530 | 22 | 23:03:35 | 14.01.26 | 1 | 4.3 | Dorfstrasse 1127 | 14.01.26 23:03:35 | 2026-01-14 23:03:35+01:00 |
| 2893529 | 2893529 | 16 | 22:57:42 | 14.01.26 | 1 | 4.1 | Dorfstrasse 1127 | 14.01.26 22:57:42 | 2026-01-14 22:57:42+01:00 |
| 2893528 | 2893528 | 30 | 22:56:55 | 14.01.26 | 1 | 4.1 | Dorfstrasse 1127 | 14.01.26 22:56:55 | 2026-01-14 22:56:55+01:00 |
| 2893527 | 2893527 | 20 | 22:56:50 | 14.01.26 | 1 | 5.1 | Dorfstrasse 1127 | 14.01.26 22:56:50 | 2026-01-14 22:56:50+01:00 |
| 2893526 | 2893526 | 22 | 22:55:24 | 14.01.26 | 1 | 3.9 | Dorfstrasse 1127 | 14.01.26 22:55:24 | 2026-01-14 22:55:24+01:00 |
| 2893525 | 2893525 | 22 | 22:52:01 | 14.01.26 | 1 | 5.1 | Dorfstrasse 1127 | 14.01.26 22:52:01 | 2026-01-14 22:52:01+01:00 |
| 2893524 | 2893524 | 27 | 22:46:11 | 14.01.26 | 1 | 4.7 | Dorfstrasse 1127 | 14.01.26 22:46:11 | 2026-01-14 22:46:11+01:00 |
| 2893523 | 2893523 | 24 | 22:27:14 | 14.01.26 | 1 | 5.1 | Dorfstrasse 1127 | 14.01.26 22:27:14 | 2026-01-14 22:27:14+01:00 |
| 2893522 | 2893522 | 25 | 22:25:36 | 14.01.26 | 1 | 4.4 | Dorfstrasse 1127 | 14.01.26 22:25:36 | 2026-01-14 22:25:36+01:00 |
| 2893521 | 2893521 | 29 | 22:23:56 | 14.01.26 | 1 | 4.4 | Dorfstrasse 1127 | 14.01.26 22:23:56 | 2026-01-14 22:23:56+01:00 |
| 2893520 | 2893520 | 24 | 22:11:17 | 14.01.26 | 1 | 4.7 | Dorfstrasse 1127 | 14.01.26 22:11:17 | 2026-01-14 22:11:17+01:00 |
| 2893519 | 2893519 | 28 | 22:03:28 | 14.01.26 | 1 | 4.5 | Dorfstrasse 1127 | 14.01.26 22:03:28 | 2026-01-14 22:03:28+01:00 |
| 2893518 | 2893518 | 26 | 22:00:51 | 14.01.26 | 1 | 4.6 | Dorfstrasse 1127 | 14.01.26 22:00:51 | 2026-01-14 22:00:51+01:00 |
| 2893517 | 2893517 | 19 | 21:47:24 | 14.01.26 | 1 | 3.8 | Dorfstrasse 1127 | 14.01.26 21:47:24 | 2026-01-14 21:47:24+01:00 |
| 2893516 | 2893516 | 22 | 21:45:37 | 14.01.26 | 1 | 1.0 | Dorfstrasse 1127 | 14.01.26 21:45:37 | 2026-01-14 21:45:37+01:00 |
| 2893515 | 2893515 | 19 | 21:38:46 | 14.01.26 | 1 | 5.1 | Dorfstrasse 1127 | 14.01.26 21:38:46 | 2026-01-14 21:38:46+01:00 |
| 2893514 | 2893514 | 23 | 21:37:28 | 14.01.26 | 1 | 5.0 | Dorfstrasse 1127 | 14.01.26 21:37:28 | 2026-01-14 21:37:28+01:00 |
| 2893513 | 2893513 | 40 | 21:36:41 | 14.01.26 | 1 | 5.0 | Dorfstrasse 1127 | 14.01.26 21:36:41 | 2026-01-14 21:36:41+01:00 |
| 2893512 | 2893512 | 20 | 21:33:17 | 14.01.26 | 1 | 4.5 | Dorfstrasse 1127 | 14.01.26 21:33:17 | 2026-01-14 21:33:17+01:00 |
| 2893511 | 2893511 | 14 | 21:08:57 | 14.01.26 | 1 | 0.8 | Dorfstrasse 1127 | 14.01.26 21:08:57 | 2026-01-14 21:08:57+01:00 |
| 2893510 | 2893510 | 24 | 21:04:45 | 14.01.26 | 1 | 4.4 | Dorfstrasse 1127 | 14.01.26 21:04:45 | 2026-01-14 21:04:45+01:00 |
| 2893509 | 2893509 | 29 | 21:04:28 | 14.01.26 | 1 | 4.4 | Dorfstrasse 1127 | 14.01.26 21:04:28 | 2026-01-14 21:04:28+01:00 |
| 2893508 | 2893508 | 10 | 20:49:42 | 14.01.26 | 1 | 5.0 | Dorfstrasse 1127 | 14.01.26 20:49:42 | 2026-01-14 20:49:42+01:00 |
| 2893507 | 2893507 | 22 | 20:47:23 | 14.01.26 | 1 | 4.1 | Dorfstrasse 1127 | 14.01.26 20:47:23 | 2026-01-14 20:47:23+01:00 |
| 2893506 | 2893506 | 21 | 20:44:09 | 14.01.26 | 1 | 4.7 | Dorfstrasse 1127 | 14.01.26 20:44:09 | 2026-01-14 20:44:09+01:00 |
| 2893505 | 2893505 | 21 | 20:37:50 | 14.01.26 | 1 | 4.2 | Dorfstrasse 1127 | 14.01.26 20:37:50 | 2026-01-14 20:37:50+01:00 |
| 2893504 | 2893504 | 20 | 20:27:52 | 14.01.26 | 1 | 5.5 | Dorfstrasse 1127 | 14.01.26 20:27:52 | 2026-01-14 20:27:52+01:00 |
| 2893503 | 2893503 | 23 | 20:27:32 | 14.01.26 | 1 | 4.0 | Dorfstrasse 1127 | 14.01.26 20:27:32 | 2026-01-14 20:27:32+01:00 |
| 2893502 | 2893502 | 26 | 20:26:15 | 14.01.26 | 1 | 4.5 | Dorfstrasse 1127 | 14.01.26 20:26:15 | 2026-01-14 20:26:15+01:00 |
| 2893501 | 2893501 | 22 | 20:23:06 | 14.01.26 | 1 | 4.5 | Dorfstrasse 1127 | 14.01.26 20:23:06 | 2026-01-14 20:23:06+01:00 |
| 2893500 | 2893500 | 26 | 20:04:04 | 14.01.26 | 1 | 5.0 | Dorfstrasse 1127 | 14.01.26 20:04:04 | 2026-01-14 20:04:04+01:00 |
| 2893499 | 2893499 | 23 | 19:58:00 | 14.01.26 | 1 | 1.4 | Dorfstrasse 1127 | 14.01.26 19:58:00 | 2026-01-14 19:58:00+01:00 |
| 2893498 | 2893498 | 26 | 19:55:14 | 14.01.26 | 1 | 4.4 | Dorfstrasse 1127 | 14.01.26 19:55:14 | 2026-01-14 19:55:14+01:00 |
| 2893497 | 2893497 | 9 | 19:53:37 | 14.01.26 | 1 | 0.9 | Dorfstrasse 1127 | 14.01.26 19:53:37 | 2026-01-14 19:53:37+01:00 |
| 2893496 | 2893496 | 18 | 19:49:45 | 14.01.26 | 1 | 5.0 | Dorfstrasse 1127 | 14.01.26 19:49:45 | 2026-01-14 19:49:45+01:00 |
| 2893495 | 2893495 | 7 | 19:48:35 | 14.01.26 | 1 | 5.0 | Dorfstrasse 1127 | 14.01.26 19:48:35 | 2026-01-14 19:48:35+01:00 |
| 2893494 | 2893494 | 7 | 19:48:34 | 14.01.26 | 1 | 4.9 | Dorfstrasse 1127 | 14.01.26 19:48:34 | 2026-01-14 19:48:34+01:00 |
| 2893493 | 2893493 | 19 | 19:46:15 | 14.01.26 | 1 | 4.9 | Dorfstrasse 1127 | 14.01.26 19:46:15 | 2026-01-14 19:46:15+01:00 |
| 2893492 | 2893492 | 37 | 19:42:58 | 14.01.26 | 1 | 4.2 | Dorfstrasse 1127 | 14.01.26 19:42:58 | 2026-01-14 19:42:58+01:00 |
| 2893491 | 2893491 | 23 | 19:42:48 | 14.01.26 | 1 | 1.7 | Dorfstrasse 1127 | 14.01.26 19:42:48 | 2026-01-14 19:42:48+01:00 |
| 2893490 | 2893490 | 15 | 19:38:44 | 14.01.26 | 1 | 4.2 | Dorfstrasse 1127 | 14.01.26 19:38:44 | 2026-01-14 19:38:44+01:00 |
| 2893489 | 2893489 | 17 | 19:37:38 | 14.01.26 | 1 | 4.4 | Dorfstrasse 1127 | 14.01.26 19:37:38 | 2026-01-14 19:37:38+01:00 |
| 2893488 | 2893488 | 21 | 19:35:31 | 14.01.26 | 1 | 5.0 | Dorfstrasse 1127 | 14.01.26 19:35:31 | 2026-01-14 19:35:31+01:00 |
| 2893487 | 2893487 | 11 | 19:35:01 | 14.01.26 | 1 | 3.2 | Dorfstrasse 1127 | 14.01.26 19:35:01 | 2026-01-14 19:35:01+01:00 |
| 2893486 | 2893486 | 10 | 19:30:49 | 14.01.26 | 1 | 3.6 | Dorfstrasse 1127 | 14.01.26 19:30:49 | 2026-01-14 19:30:49+01:00 |
| 2893485 | 2893485 | 25 | 19:22:49 | 14.01.26 | 1 | 4.3 | Dorfstrasse 1127 | 14.01.26 19:22:49 | 2026-01-14 19:22:49+01:00 |
| 2893484 | 2893484 | 25 | 19:19:14 | 14.01.26 | 1 | 4.2 | Dorfstrasse 1127 | 14.01.26 19:19:14 | 2026-01-14 19:19:14+01:00 |
| 2893483 | 2893483 | 17 | 19:16:30 | 14.01.26 | 1 | 3.1 | Dorfstrasse 1127 | 14.01.26 19:16:30 | 2026-01-14 19:16:30+01:00 |
| 2893482 | 2893482 | 18 | 19:08:34 | 14.01.26 | 1 | 4.7 | Dorfstrasse 1127 | 14.01.26 19:08:34 | 2026-01-14 19:08:34+01:00 |
| 2893481 | 2893481 | 14 | 19:05:55 | 14.01.26 | 1 | 4.9 | Dorfstrasse 1127 | 14.01.26 19:05:55 | 2026-01-14 19:05:55+01:00 |
| 2893480 | 2893480 | 22 | 19:04:56 | 14.01.26 | 1 | 4.5 | Dorfstrasse 1127 | 14.01.26 19:04:56 | 2026-01-14 19:04:56+01:00 |
| 2893479 | 2893479 | 19 | 18:59:54 | 14.01.26 | 1 | 3.6 | Dorfstrasse 1127 | 14.01.26 18:59:54 | 2026-01-14 18:59:54+01:00 |
| 2893478 | 2893478 | 15 | 18:52:08 | 14.01.26 | 1 | 6.4 | Dorfstrasse 1127 | 14.01.26 18:52:08 | 2026-01-14 18:52:08+01:00 |
| 2893477 | 2893477 | 23 | 18:49:41 | 14.01.26 | 1 | 4.2 | Dorfstrasse 1127 | 14.01.26 18:49:41 | 2026-01-14 18:49:41+01:00 |
| 2893476 | 2893476 | 26 | 18:47:42 | 14.01.26 | 1 | 4.9 | Dorfstrasse 1127 | 14.01.26 18:47:42 | 2026-01-14 18:47:42+01:00 |
| 2893475 | 2893475 | 16 | 18:46:15 | 14.01.26 | 1 | 3.8 | Dorfstrasse 1127 | 14.01.26 18:46:15 | 2026-01-14 18:46:15+01:00 |
| 2893474 | 2893474 | 15 | 18:45:15 | 14.01.26 | 1 | 1.6 | Dorfstrasse 1127 | 14.01.26 18:45:15 | 2026-01-14 18:45:15+01:00 |
| 2893473 | 2893473 | 25 | 18:43:48 | 14.01.26 | 1 | 4.7 | Dorfstrasse 1127 | 14.01.26 18:43:48 | 2026-01-14 18:43:48+01:00 |
| 2893472 | 2893472 | 21 | 18:37:39 | 14.01.26 | 1 | 4.9 | Dorfstrasse 1127 | 14.01.26 18:37:39 | 2026-01-14 18:37:39+01:00 |
| 2893471 | 2893471 | 21 | 18:37:16 | 14.01.26 | 1 | 4.8 | Dorfstrasse 1127 | 14.01.26 18:37:16 | 2026-01-14 18:37:16+01:00 |
| 2893470 | 2893470 | 25 | 18:34:48 | 14.01.26 | 1 | 5.0 | Dorfstrasse 1127 | 14.01.26 18:34:48 | 2026-01-14 18:34:48+01:00 |
| 2893469 | 2893469 | 17 | 18:34:16 | 14.01.26 | 1 | 1.0 | Dorfstrasse 1127 | 14.01.26 18:34:16 | 2026-01-14 18:34:16+01:00 |
| 2893468 | 2893468 | 26 | 18:34:05 | 14.01.26 | 1 | 3.8 | Dorfstrasse 1127 | 14.01.26 18:34:05 | 2026-01-14 18:34:05+01:00 |
| 2893467 | 2893467 | 23 | 18:33:13 | 14.01.26 | 1 | 3.9 | Dorfstrasse 1127 | 14.01.26 18:33:13 | 2026-01-14 18:33:13+01:00 |
| 2893466 | 2893466 | 16 | 18:26:03 | 14.01.26 | 1 | 4.8 | Dorfstrasse 1127 | 14.01.26 18:26:03 | 2026-01-14 18:26:03+01:00 |
| 2893465 | 2893465 | 25 | 18:24:03 | 14.01.26 | 1 | 4.4 | Dorfstrasse 1127 | 14.01.26 18:24:03 | 2026-01-14 18:24:03+01:00 |
| 2893464 | 2893464 | 15 | 18:22:29 | 14.01.26 | 1 | 4.8 | Dorfstrasse 1127 | 14.01.26 18:22:29 | 2026-01-14 18:22:29+01:00 |
| 2893463 | 2893463 | 23 | 18:21:46 | 14.01.26 | 1 | 1.5 | Dorfstrasse 1127 | 14.01.26 18:21:46 | 2026-01-14 18:21:46+01:00 |
| 2893462 | 2893462 | 13 | 18:20:20 | 14.01.26 | 1 | 8.2 | Dorfstrasse 1127 | 14.01.26 18:20:20 | 2026-01-14 18:20:20+01:00 |
| 2893461 | 2893461 | 14 | 18:17:24 | 14.01.26 | 1 | 8.5 | Dorfstrasse 1127 | 14.01.26 18:17:24 | 2026-01-14 18:17:24+01:00 |
| 2893460 | 2893460 | 20 | 18:16:58 | 14.01.26 | 1 | 4.8 | Dorfstrasse 1127 | 14.01.26 18:16:58 | 2026-01-14 18:16:58+01:00 |
| 2893459 | 2893459 | 21 | 18:13:25 | 14.01.26 | 1 | 1.2 | Dorfstrasse 1127 | 14.01.26 18:13:25 | 2026-01-14 18:13:25+01:00 |
| 2893458 | 2893458 | 14 | 18:10:22 | 14.01.26 | 1 | 4.8 | Dorfstrasse 1127 | 14.01.26 18:10:22 | 2026-01-14 18:10:22+01:00 |
| 2893457 | 2893457 | 14 | 18:09:43 | 14.01.26 | 1 | 0.9 | Dorfstrasse 1127 | 14.01.26 18:09:43 | 2026-01-14 18:09:43+01:00 |
| 2893456 | 2893456 | 16 | 18:08:20 | 14.01.26 | 1 | 4.7 | Dorfstrasse 1127 | 14.01.26 18:08:20 | 2026-01-14 18:08:20+01:00 |
| 2893455 | 2893455 | 20 | 18:04:29 | 14.01.26 | 1 | 1.6 | Dorfstrasse 1127 | 14.01.26 18:04:29 | 2026-01-14 18:04:29+01:00 |
| 2893454 | 2893454 | 24 | 18:02:51 | 14.01.26 | 1 | 4.0 | Dorfstrasse 1127 | 14.01.26 18:02:51 | 2026-01-14 18:02:51+01:00 |
| 2893453 | 2893453 | 27 | 18:00:22 | 14.01.26 | 1 | 5.5 | Dorfstrasse 1127 | 14.01.26 18:00:22 | 2026-01-14 18:00:22+01:00 |
| 2893452 | 2893452 | 20 | 17:57:33 | 14.01.26 | 1 | 4.7 | Dorfstrasse 1127 | 14.01.26 17:57:33 | 2026-01-14 17:57:33+01:00 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE Einzelmessungen (
Geschwindigkeit INTEGER,
Zeit TEXT,
Datum TEXT,
"Richtung ID" INTEGER,
Fahrzeuglänge REAL,
"Messung-ID" INTEGER,
Datum_Zeit TEXT,
Timestamp TEXT,
FOREIGN KEY("Messung-ID") REFERENCES Kennzahlen_pro_Standort("ID")
ON UPDATE CASCADE ON DELETE CASCADE
);
CREATE INDEX idx_Einzelmessungen_timestamp ON "Einzelmessungen" ("Timestamp");
CREATE INDEX idx_Einzelmessungen_richtung_id ON "Einzelmessungen" ("Richtung ID");
CREATE INDEX idx_Einzelmessungen_messung_id ON "Einzelmessungen" ("Messung-ID");
CREATE INDEX idx_Einzelmessungen_datum ON "Einzelmessungen" ("Datum");
CREATE INDEX idx_Einzelmessungen_geschwindigkeit ON "Einzelmessungen" ("Geschwindigkeit");