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 ▲ |
|---|---|---|---|---|---|---|---|---|---|
| 14190405 | 14190405 | 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 |
| 14190404 | 14190404 | 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 |
| 14190402 | 14190402 | 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 |
| 14190403 | 14190403 | 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 |
| 14190401 | 14190401 | 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 |
| 14190400 | 14190400 | 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 |
| 14190399 | 14190399 | 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 |
| 14190398 | 14190398 | 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 |
| 14190397 | 14190397 | 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 |
| 14190396 | 14190396 | 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 |
| 14190395 | 14190395 | 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 |
| 14190394 | 14190394 | 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 |
| 14190393 | 14190393 | 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 |
| 14190392 | 14190392 | 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 |
| 14190391 | 14190391 | 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 |
| 14190390 | 14190390 | 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 |
| 14190389 | 14190389 | 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 |
| 14190388 | 14190388 | 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 |
| 14190387 | 14190387 | 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 |
| 14190386 | 14190386 | 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 |
| 14190385 | 14190385 | 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 |
| 14190384 | 14190384 | 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 |
| 14190383 | 14190383 | 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 |
| 14190382 | 14190382 | 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 |
| 14190380 | 14190380 | 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 |
| 14190381 | 14190381 | 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 |
| 14190379 | 14190379 | 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 |
| 14190378 | 14190378 | 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 |
| 14190377 | 14190377 | 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 |
| 14190376 | 14190376 | 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 |
| 14190375 | 14190375 | 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 |
| 14190374 | 14190374 | 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 |
| 14190373 | 14190373 | 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 |
| 14190372 | 14190372 | 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 |
| 14190371 | 14190371 | 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 |
| 14190370 | 14190370 | 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 |
| 14190369 | 14190369 | 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 |
| 14190368 | 14190368 | 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 |
| 14190367 | 14190367 | 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 |
| 14190366 | 14190366 | 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 |
| 14190365 | 14190365 | 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 |
| 14190364 | 14190364 | 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 |
| 14190363 | 14190363 | 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 |
| 14190362 | 14190362 | 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 |
| 14190361 | 14190361 | 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 |
| 14190360 | 14190360 | 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 |
| 14190359 | 14190359 | 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 |
| 14190358 | 14190358 | 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 |
| 14190357 | 14190357 | 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 |
| 14190356 | 14190356 | 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 |
| 14190355 | 14190355 | 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 |
| 14190354 | 14190354 | 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 |
| 14190353 | 14190353 | 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 |
| 14190352 | 14190352 | 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 |
| 14190350 | 14190350 | 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 |
| 14190351 | 14190351 | 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 |
| 14190349 | 14190349 | 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 |
| 14190348 | 14190348 | 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 |
| 14190347 | 14190347 | 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 |
| 14190346 | 14190346 | 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 |
| 14190345 | 14190345 | 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 |
| 14190344 | 14190344 | 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 |
| 14190343 | 14190343 | 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 |
| 14190341 | 14190341 | 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 |
| 14190342 | 14190342 | 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 |
| 14190340 | 14190340 | 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 |
| 14190339 | 14190339 | 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 |
| 14190338 | 14190338 | 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 |
| 14190337 | 14190337 | 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 |
| 14190336 | 14190336 | 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 |
| 14190335 | 14190335 | 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 |
| 14190334 | 14190334 | 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 |
| 14190333 | 14190333 | 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 |
| 14190332 | 14190332 | 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 |
| 14190331 | 14190331 | 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 |
| 14190330 | 14190330 | 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 |
| 14190328 | 14190328 | 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 |
| 14190329 | 14190329 | 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 |
| 14190327 | 14190327 | 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 |
| 14190326 | 14190326 | 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 |
| 14190325 | 14190325 | 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 |
| 14190324 | 14190324 | 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 |
| 14190323 | 14190323 | 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 |
| 14190322 | 14190322 | 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 |
| 14190321 | 14190321 | 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 |
| 14190320 | 14190320 | 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 |
| 14190319 | 14190319 | 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 |
| 14190318 | 14190318 | 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 |
| 14190317 | 14190317 | 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 |
| 14190316 | 14190316 | 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 |
| 14190314 | 14190314 | 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 |
| 14190315 | 14190315 | 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 |
| 14190313 | 14190313 | 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 |
| 14190312 | 14190312 | 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 |
| 14190311 | 14190311 | 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 |
| 14190310 | 14190310 | 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 |
| 14190308 | 14190308 | 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 |
| 14190309 | 14190309 | 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 |
| 14190307 | 14190307 | 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 |
| 14190306 | 14190306 | 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");