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 = 1083 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 ▲ |
|---|---|---|---|---|---|---|---|---|---|
| 674337 | 674337 | 18 | 04:42:13 | 03.10.25 | 1 | 1.0 | G. Wenk-Strasse 1083 | 03.10.25 04:42:13 | 2025-10-03 04:42:13+02:00 |
| 664389 | 664389 | 23 | 04:40:39 | 03.10.25 | 2 | 3.3 | G. Wenk-Strasse 1083 | 03.10.25 04:40:39 | 2025-10-03 04:40:39+02:00 |
| 674336 | 674336 | 22 | 04:31:42 | 03.10.25 | 1 | 3.5 | G. Wenk-Strasse 1083 | 03.10.25 04:31:42 | 2025-10-03 04:31:42+02:00 |
| 674335 | 674335 | 20 | 04:29:57 | 03.10.25 | 1 | 1.8 | G. Wenk-Strasse 1083 | 03.10.25 04:29:57 | 2025-10-03 04:29:57+02:00 |
| 674334 | 674334 | 18 | 04:05:16 | 03.10.25 | 1 | 0.5 | G. Wenk-Strasse 1083 | 03.10.25 04:05:16 | 2025-10-03 04:05:16+02:00 |
| 664388 | 664388 | 26 | 04:03:50 | 03.10.25 | 2 | 3.8 | G. Wenk-Strasse 1083 | 03.10.25 04:03:50 | 2025-10-03 04:03:50+02:00 |
| 674333 | 674333 | 13 | 04:01:27 | 03.10.25 | 1 | 5.2 | G. Wenk-Strasse 1083 | 03.10.25 04:01:27 | 2025-10-03 04:01:27+02:00 |
| 664387 | 664387 | 16 | 02:43:53 | 03.10.25 | 2 | 3.2 | G. Wenk-Strasse 1083 | 03.10.25 02:43:53 | 2025-10-03 02:43:53+02:00 |
| 674332 | 674332 | 18 | 02:41:36 | 03.10.25 | 1 | 4.3 | G. Wenk-Strasse 1083 | 03.10.25 02:41:36 | 2025-10-03 02:41:36+02:00 |
| 674331 | 674331 | 22 | 02:41:33 | 03.10.25 | 1 | 4.4 | G. Wenk-Strasse 1083 | 03.10.25 02:41:33 | 2025-10-03 02:41:33+02:00 |
| 664386 | 664386 | 14 | 02:35:09 | 03.10.25 | 2 | 5.1 | G. Wenk-Strasse 1083 | 03.10.25 02:35:09 | 2025-10-03 02:35:09+02:00 |
| 674330 | 674330 | 10 | 01:52:24 | 03.10.25 | 1 | 4.9 | G. Wenk-Strasse 1083 | 03.10.25 01:52:24 | 2025-10-03 01:52:24+02:00 |
| 664385 | 664385 | 20 | 01:21:09 | 03.10.25 | 2 | 3.9 | G. Wenk-Strasse 1083 | 03.10.25 01:21:09 | 2025-10-03 01:21:09+02:00 |
| 664384 | 664384 | 36 | 01:20:39 | 03.10.25 | 2 | 3.6 | G. Wenk-Strasse 1083 | 03.10.25 01:20:39 | 2025-10-03 01:20:39+02:00 |
| 674329 | 674329 | 21 | 01:10:28 | 03.10.25 | 1 | 3.2 | G. Wenk-Strasse 1083 | 03.10.25 01:10:28 | 2025-10-03 01:10:28+02:00 |
| 664383 | 664383 | 16 | 01:05:38 | 03.10.25 | 2 | 3.8 | G. Wenk-Strasse 1083 | 03.10.25 01:05:38 | 2025-10-03 01:05:38+02:00 |
| 674328 | 674328 | 21 | 00:59:01 | 03.10.25 | 1 | 3.9 | G. Wenk-Strasse 1083 | 03.10.25 00:59:01 | 2025-10-03 00:59:01+02:00 |
| 674327 | 674327 | 21 | 00:47:01 | 03.10.25 | 1 | 4.3 | G. Wenk-Strasse 1083 | 03.10.25 00:47:01 | 2025-10-03 00:47:01+02:00 |
| 674326 | 674326 | 34 | 00:45:49 | 03.10.25 | 1 | 3.6 | G. Wenk-Strasse 1083 | 03.10.25 00:45:49 | 2025-10-03 00:45:49+02:00 |
| 674325 | 674325 | 16 | 00:43:10 | 03.10.25 | 1 | 5.4 | G. Wenk-Strasse 1083 | 03.10.25 00:43:10 | 2025-10-03 00:43:10+02:00 |
| 674324 | 674324 | 28 | 00:42:02 | 03.10.25 | 1 | 4.6 | G. Wenk-Strasse 1083 | 03.10.25 00:42:02 | 2025-10-03 00:42:02+02:00 |
| 674323 | 674323 | 23 | 00:39:43 | 03.10.25 | 1 | 4.2 | G. Wenk-Strasse 1083 | 03.10.25 00:39:43 | 2025-10-03 00:39:43+02:00 |
| 674322 | 674322 | 25 | 00:18:52 | 03.10.25 | 1 | 4.1 | G. Wenk-Strasse 1083 | 03.10.25 00:18:52 | 2025-10-03 00:18:52+02:00 |
| 664382 | 664382 | 22 | 00:15:34 | 03.10.25 | 2 | 5.1 | G. Wenk-Strasse 1083 | 03.10.25 00:15:34 | 2025-10-03 00:15:34+02:00 |
| 674321 | 674321 | 24 | 23:51:33 | 02.10.25 | 1 | 5.5 | G. Wenk-Strasse 1083 | 02.10.25 23:51:33 | 2025-10-02 23:51:33+02:00 |
| 674320 | 674320 | 22 | 23:49:14 | 02.10.25 | 1 | 4.1 | G. Wenk-Strasse 1083 | 02.10.25 23:49:14 | 2025-10-02 23:49:14+02:00 |
| 674319 | 674319 | 26 | 23:48:16 | 02.10.25 | 1 | 4.1 | G. Wenk-Strasse 1083 | 02.10.25 23:48:16 | 2025-10-02 23:48:16+02:00 |
| 674318 | 674318 | 20 | 23:47:43 | 02.10.25 | 1 | 1.0 | G. Wenk-Strasse 1083 | 02.10.25 23:47:43 | 2025-10-02 23:47:43+02:00 |
| 664381 | 664381 | 25 | 23:42:35 | 02.10.25 | 2 | 4.2 | G. Wenk-Strasse 1083 | 02.10.25 23:42:35 | 2025-10-02 23:42:35+02:00 |
| 674317 | 674317 | 31 | 23:37:26 | 02.10.25 | 1 | 4.6 | G. Wenk-Strasse 1083 | 02.10.25 23:37:26 | 2025-10-02 23:37:26+02:00 |
| 674316 | 674316 | 36 | 23:37:18 | 02.10.25 | 1 | 4.2 | G. Wenk-Strasse 1083 | 02.10.25 23:37:18 | 2025-10-02 23:37:18+02:00 |
| 674315 | 674315 | 20 | 23:33:30 | 02.10.25 | 1 | 4.6 | G. Wenk-Strasse 1083 | 02.10.25 23:33:30 | 2025-10-02 23:33:30+02:00 |
| 664380 | 664380 | 15 | 23:29:16 | 02.10.25 | 2 | 3.4 | G. Wenk-Strasse 1083 | 02.10.25 23:29:16 | 2025-10-02 23:29:16+02:00 |
| 674314 | 674314 | 23 | 23:28:59 | 02.10.25 | 1 | 5.0 | G. Wenk-Strasse 1083 | 02.10.25 23:28:59 | 2025-10-02 23:28:59+02:00 |
| 674313 | 674313 | 25 | 23:28:58 | 02.10.25 | 1 | 0.5 | G. Wenk-Strasse 1083 | 02.10.25 23:28:58 | 2025-10-02 23:28:58+02:00 |
| 664379 | 664379 | 19 | 23:27:32 | 02.10.25 | 2 | 3.5 | G. Wenk-Strasse 1083 | 02.10.25 23:27:32 | 2025-10-02 23:27:32+02:00 |
| 664378 | 664378 | 22 | 23:27:23 | 02.10.25 | 2 | 3.3 | G. Wenk-Strasse 1083 | 02.10.25 23:27:23 | 2025-10-02 23:27:23+02:00 |
| 674312 | 674312 | 18 | 23:26:59 | 02.10.25 | 1 | 5.0 | G. Wenk-Strasse 1083 | 02.10.25 23:26:59 | 2025-10-02 23:26:59+02:00 |
| 664377 | 664377 | 21 | 23:18:31 | 02.10.25 | 2 | 3.9 | G. Wenk-Strasse 1083 | 02.10.25 23:18:31 | 2025-10-02 23:18:31+02:00 |
| 674311 | 674311 | 25 | 23:15:45 | 02.10.25 | 1 | 4.2 | G. Wenk-Strasse 1083 | 02.10.25 23:15:45 | 2025-10-02 23:15:45+02:00 |
| 674310 | 674310 | 21 | 23:10:21 | 02.10.25 | 1 | 5.2 | G. Wenk-Strasse 1083 | 02.10.25 23:10:21 | 2025-10-02 23:10:21+02:00 |
| 674309 | 674309 | 30 | 23:09:14 | 02.10.25 | 1 | 4.8 | G. Wenk-Strasse 1083 | 02.10.25 23:09:14 | 2025-10-02 23:09:14+02:00 |
| 674308 | 674308 | 17 | 23:03:07 | 02.10.25 | 1 | 4.7 | G. Wenk-Strasse 1083 | 02.10.25 23:03:07 | 2025-10-02 23:03:07+02:00 |
| 674307 | 674307 | 19 | 22:48:01 | 02.10.25 | 1 | 1.3 | G. Wenk-Strasse 1083 | 02.10.25 22:48:01 | 2025-10-02 22:48:01+02:00 |
| 674306 | 674306 | 22 | 22:46:28 | 02.10.25 | 1 | 4.7 | G. Wenk-Strasse 1083 | 02.10.25 22:46:28 | 2025-10-02 22:46:28+02:00 |
| 674305 | 674305 | 28 | 22:45:33 | 02.10.25 | 1 | 4.7 | G. Wenk-Strasse 1083 | 02.10.25 22:45:33 | 2025-10-02 22:45:33+02:00 |
| 674304 | 674304 | 24 | 22:35:20 | 02.10.25 | 1 | 4.2 | G. Wenk-Strasse 1083 | 02.10.25 22:35:20 | 2025-10-02 22:35:20+02:00 |
| 674303 | 674303 | 25 | 22:33:27 | 02.10.25 | 1 | 4.1 | G. Wenk-Strasse 1083 | 02.10.25 22:33:27 | 2025-10-02 22:33:27+02:00 |
| 674302 | 674302 | 23 | 22:30:52 | 02.10.25 | 1 | 0.9 | G. Wenk-Strasse 1083 | 02.10.25 22:30:52 | 2025-10-02 22:30:52+02:00 |
| 674301 | 674301 | 26 | 22:25:20 | 02.10.25 | 1 | 5.1 | G. Wenk-Strasse 1083 | 02.10.25 22:25:20 | 2025-10-02 22:25:20+02:00 |
| 674300 | 674300 | 20 | 22:23:45 | 02.10.25 | 1 | 5.6 | G. Wenk-Strasse 1083 | 02.10.25 22:23:45 | 2025-10-02 22:23:45+02:00 |
| 674299 | 674299 | 23 | 22:20:58 | 02.10.25 | 1 | 4.3 | G. Wenk-Strasse 1083 | 02.10.25 22:20:58 | 2025-10-02 22:20:58+02:00 |
| 674298 | 674298 | 26 | 22:17:59 | 02.10.25 | 1 | 3.7 | G. Wenk-Strasse 1083 | 02.10.25 22:17:59 | 2025-10-02 22:17:59+02:00 |
| 674297 | 674297 | 20 | 22:17:56 | 02.10.25 | 1 | 4.9 | G. Wenk-Strasse 1083 | 02.10.25 22:17:56 | 2025-10-02 22:17:56+02:00 |
| 674296 | 674296 | 23 | 22:16:09 | 02.10.25 | 1 | 1.4 | G. Wenk-Strasse 1083 | 02.10.25 22:16:09 | 2025-10-02 22:16:09+02:00 |
| 664376 | 664376 | 19 | 22:07:39 | 02.10.25 | 2 | 5.0 | G. Wenk-Strasse 1083 | 02.10.25 22:07:39 | 2025-10-02 22:07:39+02:00 |
| 674295 | 674295 | 28 | 22:05:05 | 02.10.25 | 1 | 4.3 | G. Wenk-Strasse 1083 | 02.10.25 22:05:05 | 2025-10-02 22:05:05+02:00 |
| 674294 | 674294 | 25 | 22:05:01 | 02.10.25 | 1 | 4.3 | G. Wenk-Strasse 1083 | 02.10.25 22:05:01 | 2025-10-02 22:05:01+02:00 |
| 664375 | 664375 | 14 | 22:04:40 | 02.10.25 | 2 | 3.5 | G. Wenk-Strasse 1083 | 02.10.25 22:04:40 | 2025-10-02 22:04:40+02:00 |
| 674293 | 674293 | 24 | 22:03:41 | 02.10.25 | 1 | 3.3 | G. Wenk-Strasse 1083 | 02.10.25 22:03:41 | 2025-10-02 22:03:41+02:00 |
| 674292 | 674292 | 23 | 22:02:50 | 02.10.25 | 1 | 4.4 | G. Wenk-Strasse 1083 | 02.10.25 22:02:50 | 2025-10-02 22:02:50+02:00 |
| 674291 | 674291 | 27 | 22:02:15 | 02.10.25 | 1 | 4.4 | G. Wenk-Strasse 1083 | 02.10.25 22:02:15 | 2025-10-02 22:02:15+02:00 |
| 664374 | 664374 | 25 | 22:00:57 | 02.10.25 | 2 | 3.9 | G. Wenk-Strasse 1083 | 02.10.25 22:00:57 | 2025-10-02 22:00:57+02:00 |
| 674290 | 674290 | 24 | 21:51:42 | 02.10.25 | 1 | 0.8 | G. Wenk-Strasse 1083 | 02.10.25 21:51:42 | 2025-10-02 21:51:42+02:00 |
| 674289 | 674289 | 24 | 21:46:49 | 02.10.25 | 1 | 4.3 | G. Wenk-Strasse 1083 | 02.10.25 21:46:49 | 2025-10-02 21:46:49+02:00 |
| 664373 | 664373 | 17 | 21:44:39 | 02.10.25 | 2 | 5.0 | G. Wenk-Strasse 1083 | 02.10.25 21:44:39 | 2025-10-02 21:44:39+02:00 |
| 674288 | 674288 | 27 | 21:41:06 | 02.10.25 | 1 | 1.2 | G. Wenk-Strasse 1083 | 02.10.25 21:41:06 | 2025-10-02 21:41:06+02:00 |
| 674287 | 674287 | 25 | 21:41:04 | 02.10.25 | 1 | 0.6 | G. Wenk-Strasse 1083 | 02.10.25 21:41:04 | 2025-10-02 21:41:04+02:00 |
| 664372 | 664372 | 16 | 21:34:38 | 02.10.25 | 2 | 5.0 | G. Wenk-Strasse 1083 | 02.10.25 21:34:38 | 2025-10-02 21:34:38+02:00 |
| 674286 | 674286 | 22 | 21:34:09 | 02.10.25 | 1 | 0.9 | G. Wenk-Strasse 1083 | 02.10.25 21:34:09 | 2025-10-02 21:34:09+02:00 |
| 674285 | 674285 | 28 | 21:33:02 | 02.10.25 | 1 | 5.0 | G. Wenk-Strasse 1083 | 02.10.25 21:33:02 | 2025-10-02 21:33:02+02:00 |
| 674284 | 674284 | 20 | 21:30:19 | 02.10.25 | 1 | 5.2 | G. Wenk-Strasse 1083 | 02.10.25 21:30:19 | 2025-10-02 21:30:19+02:00 |
| 664371 | 664371 | 22 | 21:29:16 | 02.10.25 | 2 | 3.7 | G. Wenk-Strasse 1083 | 02.10.25 21:29:16 | 2025-10-02 21:29:16+02:00 |
| 674283 | 674283 | 24 | 21:28:44 | 02.10.25 | 1 | 0.9 | G. Wenk-Strasse 1083 | 02.10.25 21:28:44 | 2025-10-02 21:28:44+02:00 |
| 674282 | 674282 | 20 | 21:23:57 | 02.10.25 | 1 | 4.1 | G. Wenk-Strasse 1083 | 02.10.25 21:23:57 | 2025-10-02 21:23:57+02:00 |
| 664370 | 664370 | 11 | 21:23:50 | 02.10.25 | 2 | 2.6 | G. Wenk-Strasse 1083 | 02.10.25 21:23:50 | 2025-10-02 21:23:50+02:00 |
| 664369 | 664369 | 22 | 21:23:32 | 02.10.25 | 2 | 4.8 | G. Wenk-Strasse 1083 | 02.10.25 21:23:32 | 2025-10-02 21:23:32+02:00 |
| 674281 | 674281 | 23 | 21:23:27 | 02.10.25 | 1 | 3.8 | G. Wenk-Strasse 1083 | 02.10.25 21:23:27 | 2025-10-02 21:23:27+02:00 |
| 674280 | 674280 | 25 | 21:22:00 | 02.10.25 | 1 | 4.1 | G. Wenk-Strasse 1083 | 02.10.25 21:22:00 | 2025-10-02 21:22:00+02:00 |
| 674279 | 674279 | 15 | 21:19:18 | 02.10.25 | 1 | 4.9 | G. Wenk-Strasse 1083 | 02.10.25 21:19:18 | 2025-10-02 21:19:18+02:00 |
| 664368 | 664368 | 18 | 21:18:52 | 02.10.25 | 2 | 3.7 | G. Wenk-Strasse 1083 | 02.10.25 21:18:52 | 2025-10-02 21:18:52+02:00 |
| 674278 | 674278 | 20 | 21:18:19 | 02.10.25 | 1 | 1.0 | G. Wenk-Strasse 1083 | 02.10.25 21:18:19 | 2025-10-02 21:18:19+02:00 |
| 674277 | 674277 | 21 | 21:16:15 | 02.10.25 | 1 | 4.8 | G. Wenk-Strasse 1083 | 02.10.25 21:16:15 | 2025-10-02 21:16:15+02:00 |
| 674276 | 674276 | 31 | 21:15:34 | 02.10.25 | 1 | 4.6 | G. Wenk-Strasse 1083 | 02.10.25 21:15:34 | 2025-10-02 21:15:34+02:00 |
| 674275 | 674275 | 25 | 21:14:28 | 02.10.25 | 1 | 4.1 | G. Wenk-Strasse 1083 | 02.10.25 21:14:28 | 2025-10-02 21:14:28+02:00 |
| 674274 | 674274 | 18 | 21:07:21 | 02.10.25 | 1 | 0.8 | G. Wenk-Strasse 1083 | 02.10.25 21:07:21 | 2025-10-02 21:07:21+02:00 |
| 674273 | 674273 | 25 | 21:07:12 | 02.10.25 | 1 | 5.1 | G. Wenk-Strasse 1083 | 02.10.25 21:07:12 | 2025-10-02 21:07:12+02:00 |
| 664367 | 664367 | 18 | 21:06:19 | 02.10.25 | 2 | 3.1 | G. Wenk-Strasse 1083 | 02.10.25 21:06:19 | 2025-10-02 21:06:19+02:00 |
| 674272 | 674272 | 20 | 21:02:36 | 02.10.25 | 1 | 5.6 | G. Wenk-Strasse 1083 | 02.10.25 21:02:36 | 2025-10-02 21:02:36+02:00 |
| 674271 | 674271 | 19 | 21:02:27 | 02.10.25 | 1 | 1.0 | G. Wenk-Strasse 1083 | 02.10.25 21:02:27 | 2025-10-02 21:02:27+02:00 |
| 674270 | 674270 | 12 | 21:00:15 | 02.10.25 | 1 | 1.7 | G. Wenk-Strasse 1083 | 02.10.25 21:00:15 | 2025-10-02 21:00:15+02:00 |
| 674269 | 674269 | 12 | 21:00:13 | 02.10.25 | 1 | 5.4 | G. Wenk-Strasse 1083 | 02.10.25 21:00:13 | 2025-10-02 21:00:13+02:00 |
| 674268 | 674268 | 30 | 20:57:21 | 02.10.25 | 1 | 4.0 | G. Wenk-Strasse 1083 | 02.10.25 20:57:21 | 2025-10-02 20:57:21+02:00 |
| 664366 | 664366 | 17 | 20:56:09 | 02.10.25 | 2 | 4.9 | G. Wenk-Strasse 1083 | 02.10.25 20:56:09 | 2025-10-02 20:56:09+02:00 |
| 674267 | 674267 | 36 | 20:54:09 | 02.10.25 | 1 | 4.6 | G. Wenk-Strasse 1083 | 02.10.25 20:54:09 | 2025-10-02 20:54:09+02:00 |
| 674266 | 674266 | 24 | 20:53:44 | 02.10.25 | 1 | 1.0 | G. Wenk-Strasse 1083 | 02.10.25 20:53:44 | 2025-10-02 20:53:44+02:00 |
| 664365 | 664365 | 23 | 20:53:27 | 02.10.25 | 2 | 4.9 | G. Wenk-Strasse 1083 | 02.10.25 20:53:27 | 2025-10-02 20:53:27+02:00 |
| 664364 | 664364 | 22 | 20:53:26 | 02.10.25 | 2 | 4.9 | G. Wenk-Strasse 1083 | 02.10.25 20:53:26 | 2025-10-02 20:53:26+02:00 |
| 674265 | 674265 | 30 | 20:50:31 | 02.10.25 | 1 | 1.5 | G. Wenk-Strasse 1083 | 02.10.25 20:50:31 | 2025-10-02 20:50:31+02:00 |
| 664363 | 664363 | 17 | 20:47:06 | 02.10.25 | 2 | 3.5 | G. Wenk-Strasse 1083 | 02.10.25 20:47:06 | 2025-10-02 20:47:06+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");