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
>10,000 rows count all where Messung-ID = 1075 sorted by Timestamp descending
This data as json, copyable, CSV (advanced)
Suggested facets: Timestamp (date)
| Link | rowid | Geschwindigkeit | Zeit | Datum | Richtung ID | Fahrzeuglänge | Messung-ID | Datum_Zeit | Timestamp ▲ |
|---|---|---|---|---|---|---|---|---|---|
| 1272565 | 1272565 | 12 | 08:58:00 | 15.09.25 | 1 | 1.5 | Autobahn A2 1075 | 15.09.25 08:58:00 | 2025-09-15 08:58:00+02:00 |
| 1272564 | 1272564 | 57 | 08:57:57 | 15.09.25 | 1 | 6.4 | Autobahn A2 1075 | 15.09.25 08:57:57 | 2025-09-15 08:57:57+02:00 |
| 1272562 | 1272562 | 57 | 08:57:54 | 15.09.25 | 1 | 2.9 | Autobahn A2 1075 | 15.09.25 08:57:54 | 2025-09-15 08:57:54+02:00 |
| 1272563 | 1272563 | 50 | 08:57:54 | 15.09.25 | 1 | 0.9 | Autobahn A2 1075 | 15.09.25 08:57:54 | 2025-09-15 08:57:54+02:00 |
| 1272561 | 1272561 | 59 | 08:57:52 | 15.09.25 | 1 | 13.7 | Autobahn A2 1075 | 15.09.25 08:57:52 | 2025-09-15 08:57:52+02:00 |
| 1272560 | 1272560 | 69 | 08:57:51 | 15.09.25 | 1 | 3.1 | Autobahn A2 1075 | 15.09.25 08:57:51 | 2025-09-15 08:57:51+02:00 |
| 1272559 | 1272559 | 10 | 08:57:49 | 15.09.25 | 1 | 1.6 | Autobahn A2 1075 | 15.09.25 08:57:49 | 2025-09-15 08:57:49+02:00 |
| 1272558 | 1272558 | 66 | 08:57:46 | 15.09.25 | 1 | 19.2 | Autobahn A2 1075 | 15.09.25 08:57:46 | 2025-09-15 08:57:46+02:00 |
| 1272557 | 1272557 | 71 | 08:57:45 | 15.09.25 | 1 | 1.1 | Autobahn A2 1075 | 15.09.25 08:57:45 | 2025-09-15 08:57:45+02:00 |
| 1272556 | 1272556 | 74 | 08:57:44 | 15.09.25 | 1 | 4.3 | Autobahn A2 1075 | 15.09.25 08:57:44 | 2025-09-15 08:57:44+02:00 |
| 1272555 | 1272555 | 72 | 08:57:41 | 15.09.25 | 1 | 8.0 | Autobahn A2 1075 | 15.09.25 08:57:41 | 2025-09-15 08:57:41+02:00 |
| 1272554 | 1272554 | 59 | 08:57:40 | 15.09.25 | 1 | 10.0 | Autobahn A2 1075 | 15.09.25 08:57:40 | 2025-09-15 08:57:40+02:00 |
| 1272553 | 1272553 | 75 | 08:57:39 | 15.09.25 | 1 | 3.8 | Autobahn A2 1075 | 15.09.25 08:57:39 | 2025-09-15 08:57:39+02:00 |
| 1272552 | 1272552 | 68 | 08:57:38 | 15.09.25 | 1 | 13.8 | Autobahn A2 1075 | 15.09.25 08:57:38 | 2025-09-15 08:57:38+02:00 |
| 1272551 | 1272551 | 76 | 08:57:37 | 15.09.25 | 1 | 4.3 | Autobahn A2 1075 | 15.09.25 08:57:37 | 2025-09-15 08:57:37+02:00 |
| 1272550 | 1272550 | 17 | 08:57:33 | 15.09.25 | 1 | 0.9 | Autobahn A2 1075 | 15.09.25 08:57:33 | 2025-09-15 08:57:33+02:00 |
| 1272549 | 1272549 | 69 | 08:57:32 | 15.09.25 | 1 | 4.6 | Autobahn A2 1075 | 15.09.25 08:57:32 | 2025-09-15 08:57:32+02:00 |
| 1272548 | 1272548 | 38 | 08:57:31 | 15.09.25 | 1 | 0.5 | Autobahn A2 1075 | 15.09.25 08:57:31 | 2025-09-15 08:57:31+02:00 |
| 1272547 | 1272547 | 65 | 08:57:30 | 15.09.25 | 1 | 3.2 | Autobahn A2 1075 | 15.09.25 08:57:30 | 2025-09-15 08:57:30+02:00 |
| 1272546 | 1272546 | 75 | 08:57:29 | 15.09.25 | 1 | 1.8 | Autobahn A2 1075 | 15.09.25 08:57:29 | 2025-09-15 08:57:29+02:00 |
| 1272545 | 1272545 | 68 | 08:57:25 | 15.09.25 | 1 | 19.5 | Autobahn A2 1075 | 15.09.25 08:57:25 | 2025-09-15 08:57:25+02:00 |
| 1272544 | 1272544 | 74 | 08:57:23 | 15.09.25 | 1 | 3.5 | Autobahn A2 1075 | 15.09.25 08:57:23 | 2025-09-15 08:57:23+02:00 |
| 1272543 | 1272543 | 66 | 08:57:22 | 15.09.25 | 1 | 19.2 | Autobahn A2 1075 | 15.09.25 08:57:22 | 2025-09-15 08:57:22+02:00 |
| 1272542 | 1272542 | 63 | 08:57:19 | 15.09.25 | 1 | 18.5 | Autobahn A2 1075 | 15.09.25 08:57:19 | 2025-09-15 08:57:19+02:00 |
| 1272540 | 1272540 | 72 | 08:57:16 | 15.09.25 | 1 | 4.5 | Autobahn A2 1075 | 15.09.25 08:57:16 | 2025-09-15 08:57:16+02:00 |
| 1272541 | 1272541 | 78 | 08:57:16 | 15.09.25 | 1 | 4.1 | Autobahn A2 1075 | 15.09.25 08:57:16 | 2025-09-15 08:57:16+02:00 |
| 1272539 | 1272539 | 79 | 08:57:14 | 15.09.25 | 1 | 4.6 | Autobahn A2 1075 | 15.09.25 08:57:14 | 2025-09-15 08:57:14+02:00 |
| 1272538 | 1272538 | 71 | 08:57:13 | 15.09.25 | 1 | 0.6 | Autobahn A2 1075 | 15.09.25 08:57:13 | 2025-09-15 08:57:13+02:00 |
| 1272537 | 1272537 | 61 | 08:57:12 | 15.09.25 | 1 | 20.3 | Autobahn A2 1075 | 15.09.25 08:57:12 | 2025-09-15 08:57:12+02:00 |
| 1272536 | 1272536 | 79 | 08:57:10 | 15.09.25 | 1 | 3.4 | Autobahn A2 1075 | 15.09.25 08:57:10 | 2025-09-15 08:57:10+02:00 |
| 1272535 | 1272535 | 66 | 08:57:08 | 15.09.25 | 1 | 12.2 | Autobahn A2 1075 | 15.09.25 08:57:08 | 2025-09-15 08:57:08+02:00 |
| 1272534 | 1272534 | 62 | 08:57:06 | 15.09.25 | 1 | 8.8 | Autobahn A2 1075 | 15.09.25 08:57:06 | 2025-09-15 08:57:06+02:00 |
| 1272533 | 1272533 | 56 | 08:57:05 | 15.09.25 | 1 | 2.5 | Autobahn A2 1075 | 15.09.25 08:57:05 | 2025-09-15 08:57:05+02:00 |
| 1272532 | 1272532 | 54 | 08:57:00 | 15.09.25 | 1 | 21.3 | Autobahn A2 1075 | 15.09.25 08:57:00 | 2025-09-15 08:57:00+02:00 |
| 1272531 | 1272531 | 56 | 08:56:59 | 15.09.25 | 1 | 9.5 | Autobahn A2 1075 | 15.09.25 08:56:59 | 2025-09-15 08:56:59+02:00 |
| 1272530 | 1272530 | 55 | 08:56:57 | 15.09.25 | 1 | 6.3 | Autobahn A2 1075 | 15.09.25 08:56:57 | 2025-09-15 08:56:57+02:00 |
| 1272529 | 1272529 | 55 | 08:56:56 | 15.09.25 | 1 | 9.5 | Autobahn A2 1075 | 15.09.25 08:56:56 | 2025-09-15 08:56:56+02:00 |
| 1272528 | 1272528 | 69 | 08:56:55 | 15.09.25 | 1 | 2.0 | Autobahn A2 1075 | 15.09.25 08:56:55 | 2025-09-15 08:56:55+02:00 |
| 1272527 | 1272527 | 81 | 08:56:54 | 15.09.25 | 1 | 5.5 | Autobahn A2 1075 | 15.09.25 08:56:54 | 2025-09-15 08:56:54+02:00 |
| 1272526 | 1272526 | 84 | 08:56:53 | 15.09.25 | 1 | 3.3 | Autobahn A2 1075 | 15.09.25 08:56:53 | 2025-09-15 08:56:53+02:00 |
| 1272525 | 1272525 | 77 | 08:56:52 | 15.09.25 | 1 | 0.8 | Autobahn A2 1075 | 15.09.25 08:56:52 | 2025-09-15 08:56:52+02:00 |
| 1272524 | 1272524 | 72 | 08:56:50 | 15.09.25 | 1 | 3.8 | Autobahn A2 1075 | 15.09.25 08:56:50 | 2025-09-15 08:56:50+02:00 |
| 1272523 | 1272523 | 83 | 08:56:49 | 15.09.25 | 1 | 2.0 | Autobahn A2 1075 | 15.09.25 08:56:49 | 2025-09-15 08:56:49+02:00 |
| 1272522 | 1272522 | 83 | 08:56:47 | 15.09.25 | 1 | 5.0 | Autobahn A2 1075 | 15.09.25 08:56:47 | 2025-09-15 08:56:47+02:00 |
| 1272521 | 1272521 | 72 | 08:56:45 | 15.09.25 | 1 | 4.7 | Autobahn A2 1075 | 15.09.25 08:56:45 | 2025-09-15 08:56:45+02:00 |
| 1272520 | 1272520 | 71 | 08:56:40 | 15.09.25 | 1 | 5.4 | Autobahn A2 1075 | 15.09.25 08:56:40 | 2025-09-15 08:56:40+02:00 |
| 1272519 | 1272519 | 69 | 08:56:37 | 15.09.25 | 1 | 5.4 | Autobahn A2 1075 | 15.09.25 08:56:37 | 2025-09-15 08:56:37+02:00 |
| 1272518 | 1272518 | 65 | 08:56:35 | 15.09.25 | 1 | 4.1 | Autobahn A2 1075 | 15.09.25 08:56:35 | 2025-09-15 08:56:35+02:00 |
| 1272517 | 1272517 | 72 | 08:56:34 | 15.09.25 | 1 | 6.0 | Autobahn A2 1075 | 15.09.25 08:56:34 | 2025-09-15 08:56:34+02:00 |
| 1272516 | 1272516 | 74 | 08:56:33 | 15.09.25 | 1 | 2.4 | Autobahn A2 1075 | 15.09.25 08:56:33 | 2025-09-15 08:56:33+02:00 |
| 1272515 | 1272515 | 62 | 08:56:32 | 15.09.25 | 1 | 6.7 | Autobahn A2 1075 | 15.09.25 08:56:32 | 2025-09-15 08:56:32+02:00 |
| 1272514 | 1272514 | 66 | 08:56:30 | 15.09.25 | 1 | 12.0 | Autobahn A2 1075 | 15.09.25 08:56:30 | 2025-09-15 08:56:30+02:00 |
| 1272513 | 1272513 | 76 | 08:56:29 | 15.09.25 | 1 | 2.3 | Autobahn A2 1075 | 15.09.25 08:56:29 | 2025-09-15 08:56:29+02:00 |
| 1272512 | 1272512 | 80 | 08:56:28 | 15.09.25 | 1 | 6.1 | Autobahn A2 1075 | 15.09.25 08:56:28 | 2025-09-15 08:56:28+02:00 |
| 1272510 | 1272510 | 90 | 08:56:27 | 15.09.25 | 1 | 4.2 | Autobahn A2 1075 | 15.09.25 08:56:27 | 2025-09-15 08:56:27+02:00 |
| 1272511 | 1272511 | 68 | 08:56:27 | 15.09.25 | 1 | 1.2 | Autobahn A2 1075 | 15.09.25 08:56:27 | 2025-09-15 08:56:27+02:00 |
| 1272509 | 1272509 | 68 | 08:56:24 | 15.09.25 | 1 | 5.5 | Autobahn A2 1075 | 15.09.25 08:56:24 | 2025-09-15 08:56:24+02:00 |
| 1272508 | 1272508 | 74 | 08:56:23 | 15.09.25 | 1 | 7.5 | Autobahn A2 1075 | 15.09.25 08:56:23 | 2025-09-15 08:56:23+02:00 |
| 1272507 | 1272507 | 72 | 08:56:22 | 15.09.25 | 1 | 4.6 | Autobahn A2 1075 | 15.09.25 08:56:22 | 2025-09-15 08:56:22+02:00 |
| 1272506 | 1272506 | 59 | 08:56:21 | 15.09.25 | 1 | 1.6 | Autobahn A2 1075 | 15.09.25 08:56:21 | 2025-09-15 08:56:21+02:00 |
| 1272505 | 1272505 | 70 | 08:56:20 | 15.09.25 | 1 | 3.3 | Autobahn A2 1075 | 15.09.25 08:56:20 | 2025-09-15 08:56:20+02:00 |
| 1272504 | 1272504 | 67 | 08:56:19 | 15.09.25 | 1 | 13.4 | Autobahn A2 1075 | 15.09.25 08:56:19 | 2025-09-15 08:56:19+02:00 |
| 1272503 | 1272503 | 80 | 08:56:18 | 15.09.25 | 1 | 5.9 | Autobahn A2 1075 | 15.09.25 08:56:18 | 2025-09-15 08:56:18+02:00 |
| 1272501 | 1272501 | 71 | 08:56:17 | 15.09.25 | 1 | 5.0 | Autobahn A2 1075 | 15.09.25 08:56:17 | 2025-09-15 08:56:17+02:00 |
| 1272502 | 1272502 | 79 | 08:56:17 | 15.09.25 | 1 | 1.7 | Autobahn A2 1075 | 15.09.25 08:56:17 | 2025-09-15 08:56:17+02:00 |
| 1272500 | 1272500 | 71 | 08:56:16 | 15.09.25 | 1 | 4.5 | Autobahn A2 1075 | 15.09.25 08:56:16 | 2025-09-15 08:56:16+02:00 |
| 1272499 | 1272499 | 71 | 08:56:15 | 15.09.25 | 1 | 19.0 | Autobahn A2 1075 | 15.09.25 08:56:15 | 2025-09-15 08:56:15+02:00 |
| 1272498 | 1272498 | 69 | 08:56:10 | 15.09.25 | 1 | 4.0 | Autobahn A2 1075 | 15.09.25 08:56:10 | 2025-09-15 08:56:10+02:00 |
| 1272497 | 1272497 | 81 | 08:56:09 | 15.09.25 | 1 | 8.5 | Autobahn A2 1075 | 15.09.25 08:56:09 | 2025-09-15 08:56:09+02:00 |
| 1272496 | 1272496 | 61 | 08:56:07 | 15.09.25 | 1 | 5.4 | Autobahn A2 1075 | 15.09.25 08:56:07 | 2025-09-15 08:56:07+02:00 |
| 1272495 | 1272495 | 61 | 08:56:06 | 15.09.25 | 1 | 11.3 | Autobahn A2 1075 | 15.09.25 08:56:06 | 2025-09-15 08:56:06+02:00 |
| 1272494 | 1272494 | 67 | 08:56:04 | 15.09.25 | 1 | 1.7 | Autobahn A2 1075 | 15.09.25 08:56:04 | 2025-09-15 08:56:04+02:00 |
| 1272493 | 1272493 | 62 | 08:56:03 | 15.09.25 | 1 | 6.8 | Autobahn A2 1075 | 15.09.25 08:56:03 | 2025-09-15 08:56:03+02:00 |
| 1272492 | 1272492 | 68 | 08:56:02 | 15.09.25 | 1 | 3.9 | Autobahn A2 1075 | 15.09.25 08:56:02 | 2025-09-15 08:56:02+02:00 |
| 1272491 | 1272491 | 63 | 08:56:00 | 15.09.25 | 1 | 5.2 | Autobahn A2 1075 | 15.09.25 08:56:00 | 2025-09-15 08:56:00+02:00 |
| 1272490 | 1272490 | 64 | 08:55:59 | 15.09.25 | 1 | 19.6 | Autobahn A2 1075 | 15.09.25 08:55:59 | 2025-09-15 08:55:59+02:00 |
| 1272488 | 1272488 | 80 | 08:55:57 | 15.09.25 | 1 | 1.8 | Autobahn A2 1075 | 15.09.25 08:55:57 | 2025-09-15 08:55:57+02:00 |
| 1272489 | 1272489 | 83 | 08:55:57 | 15.09.25 | 1 | 4.5 | Autobahn A2 1075 | 15.09.25 08:55:57 | 2025-09-15 08:55:57+02:00 |
| 1272487 | 1272487 | 83 | 08:55:56 | 15.09.25 | 1 | 4.0 | Autobahn A2 1075 | 15.09.25 08:55:56 | 2025-09-15 08:55:56+02:00 |
| 1272486 | 1272486 | 63 | 08:55:54 | 15.09.25 | 1 | 7.0 | Autobahn A2 1075 | 15.09.25 08:55:54 | 2025-09-15 08:55:54+02:00 |
| 1272485 | 1272485 | 64 | 08:55:53 | 15.09.25 | 1 | 19.2 | Autobahn A2 1075 | 15.09.25 08:55:53 | 2025-09-15 08:55:53+02:00 |
| 1272484 | 1272484 | 74 | 08:55:51 | 15.09.25 | 1 | 0.5 | Autobahn A2 1075 | 15.09.25 08:55:51 | 2025-09-15 08:55:51+02:00 |
| 1272483 | 1272483 | 78 | 08:55:50 | 15.09.25 | 1 | 1.1 | Autobahn A2 1075 | 15.09.25 08:55:50 | 2025-09-15 08:55:50+02:00 |
| 1272482 | 1272482 | 71 | 08:55:49 | 15.09.25 | 1 | 1.3 | Autobahn A2 1075 | 15.09.25 08:55:49 | 2025-09-15 08:55:49+02:00 |
| 1272481 | 1272481 | 67 | 08:55:48 | 15.09.25 | 1 | 3.8 | Autobahn A2 1075 | 15.09.25 08:55:48 | 2025-09-15 08:55:48+02:00 |
| 1272480 | 1272480 | 73 | 08:55:46 | 15.09.25 | 1 | 4.4 | Autobahn A2 1075 | 15.09.25 08:55:46 | 2025-09-15 08:55:46+02:00 |
| 1272479 | 1272479 | 75 | 08:55:45 | 15.09.25 | 1 | 1.6 | Autobahn A2 1075 | 15.09.25 08:55:45 | 2025-09-15 08:55:45+02:00 |
| 1272478 | 1272478 | 66 | 08:55:41 | 15.09.25 | 1 | 2.2 | Autobahn A2 1075 | 15.09.25 08:55:41 | 2025-09-15 08:55:41+02:00 |
| 1272477 | 1272477 | 65 | 08:55:40 | 15.09.25 | 1 | 6.1 | Autobahn A2 1075 | 15.09.25 08:55:40 | 2025-09-15 08:55:40+02:00 |
| 1272476 | 1272476 | 63 | 08:55:38 | 15.09.25 | 1 | 11.8 | Autobahn A2 1075 | 15.09.25 08:55:38 | 2025-09-15 08:55:38+02:00 |
| 1272474 | 1272474 | 76 | 08:55:35 | 15.09.25 | 1 | 2.3 | Autobahn A2 1075 | 15.09.25 08:55:35 | 2025-09-15 08:55:35+02:00 |
| 1272475 | 1272475 | 71 | 08:55:35 | 15.09.25 | 1 | 0.7 | Autobahn A2 1075 | 15.09.25 08:55:35 | 2025-09-15 08:55:35+02:00 |
| 1272473 | 1272473 | 60 | 08:55:34 | 15.09.25 | 1 | 2.2 | Autobahn A2 1075 | 15.09.25 08:55:34 | 2025-09-15 08:55:34+02:00 |
| 1272472 | 1272472 | 74 | 08:55:33 | 15.09.25 | 1 | 19.1 | Autobahn A2 1075 | 15.09.25 08:55:33 | 2025-09-15 08:55:33+02:00 |
| 1272471 | 1272471 | 67 | 08:55:30 | 15.09.25 | 1 | 15.7 | Autobahn A2 1075 | 15.09.25 08:55:30 | 2025-09-15 08:55:30+02:00 |
| 1272470 | 1272470 | 72 | 08:55:29 | 15.09.25 | 1 | 1.4 | Autobahn A2 1075 | 15.09.25 08:55:29 | 2025-09-15 08:55:29+02:00 |
| 1272468 | 1272468 | 67 | 08:55:25 | 15.09.25 | 1 | 4.8 | Autobahn A2 1075 | 15.09.25 08:55:25 | 2025-09-15 08:55:25+02:00 |
| 1272469 | 1272469 | 57 | 08:55:25 | 15.09.25 | 1 | 5.1 | Autobahn A2 1075 | 15.09.25 08:55:25 | 2025-09-15 08:55:25+02:00 |
| 1272467 | 1272467 | 54 | 08:55:24 | 15.09.25 | 1 | 3.7 | Autobahn A2 1075 | 15.09.25 08:55:24 | 2025-09-15 08:55:24+02:00 |
| 1272466 | 1272466 | 59 | 08:55:22 | 15.09.25 | 1 | 5.0 | Autobahn A2 1075 | 15.09.25 08:55:22 | 2025-09-15 08:55:22+02: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");