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 = 1034 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 ▲ |
|---|---|---|---|---|---|---|---|---|---|
| 3842279 | 3842279 | 13 | 07:48:41 | 23.06.25 | 1 | 4.2 | Metzerstrasse 1034 | 23.06.25 07:48:41 | 2025-06-23 07:48:41+02:00 |
| 3878360 | 3878360 | 21 | 07:48:36 | 23.06.25 | 2 | 2.5 | Metzerstrasse 1034 | 23.06.25 07:48:36 | 2025-06-23 07:48:36+02:00 |
| 3878359 | 3878359 | 28 | 07:48:33 | 23.06.25 | 2 | 1.0 | Metzerstrasse 1034 | 23.06.25 07:48:33 | 2025-06-23 07:48:33+02:00 |
| 3878358 | 3878358 | 22 | 07:48:08 | 23.06.25 | 2 | 1.2 | Metzerstrasse 1034 | 23.06.25 07:48:08 | 2025-06-23 07:48:08+02:00 |
| 3878357 | 3878357 | 25 | 07:48:05 | 23.06.25 | 2 | 1.4 | Metzerstrasse 1034 | 23.06.25 07:48:05 | 2025-06-23 07:48:05+02:00 |
| 3878356 | 3878356 | 38 | 07:47:59 | 23.06.25 | 2 | 2.0 | Metzerstrasse 1034 | 23.06.25 07:47:59 | 2025-06-23 07:47:59+02:00 |
| 3878355 | 3878355 | 23 | 07:47:09 | 23.06.25 | 2 | 1.2 | Metzerstrasse 1034 | 23.06.25 07:47:09 | 2025-06-23 07:47:09+02:00 |
| 3878354 | 3878354 | 25 | 07:47:07 | 23.06.25 | 2 | 2.1 | Metzerstrasse 1034 | 23.06.25 07:47:07 | 2025-06-23 07:47:07+02:00 |
| 3878353 | 3878353 | 21 | 07:47:05 | 23.06.25 | 2 | 2.1 | Metzerstrasse 1034 | 23.06.25 07:47:05 | 2025-06-23 07:47:05+02:00 |
| 3878352 | 3878352 | 21 | 07:47:03 | 23.06.25 | 2 | 3.0 | Metzerstrasse 1034 | 23.06.25 07:47:03 | 2025-06-23 07:47:03+02:00 |
| 3878351 | 3878351 | 16 | 07:46:40 | 23.06.25 | 2 | 1.5 | Metzerstrasse 1034 | 23.06.25 07:46:40 | 2025-06-23 07:46:40+02:00 |
| 3878350 | 3878350 | 25 | 07:46:36 | 23.06.25 | 2 | 5.9 | Metzerstrasse 1034 | 23.06.25 07:46:36 | 2025-06-23 07:46:36+02:00 |
| 3878349 | 3878349 | 24 | 07:46:33 | 23.06.25 | 2 | 1.7 | Metzerstrasse 1034 | 23.06.25 07:46:33 | 2025-06-23 07:46:33+02:00 |
| 3878348 | 3878348 | 23 | 07:46:31 | 23.06.25 | 2 | 1.0 | Metzerstrasse 1034 | 23.06.25 07:46:31 | 2025-06-23 07:46:31+02:00 |
| 3878347 | 3878347 | 20 | 07:46:27 | 23.06.25 | 2 | 1.6 | Metzerstrasse 1034 | 23.06.25 07:46:27 | 2025-06-23 07:46:27+02:00 |
| 3878346 | 3878346 | 18 | 07:46:25 | 23.06.25 | 2 | 2.7 | Metzerstrasse 1034 | 23.06.25 07:46:25 | 2025-06-23 07:46:25+02:00 |
| 3878345 | 3878345 | 13 | 07:46:23 | 23.06.25 | 2 | 2.1 | Metzerstrasse 1034 | 23.06.25 07:46:23 | 2025-06-23 07:46:23+02:00 |
| 3878344 | 3878344 | 17 | 07:45:26 | 23.06.25 | 2 | 1.8 | Metzerstrasse 1034 | 23.06.25 07:45:26 | 2025-06-23 07:45:26+02:00 |
| 3878343 | 3878343 | 21 | 07:45:22 | 23.06.25 | 2 | 2.3 | Metzerstrasse 1034 | 23.06.25 07:45:22 | 2025-06-23 07:45:22+02:00 |
| 3842278 | 3842278 | 22 | 07:45:07 | 23.06.25 | 1 | 3.5 | Metzerstrasse 1034 | 23.06.25 07:45:07 | 2025-06-23 07:45:07+02:00 |
| 3878342 | 3878342 | 25 | 07:45:06 | 23.06.25 | 2 | 16.3 | Metzerstrasse 1034 | 23.06.25 07:45:06 | 2025-06-23 07:45:06+02:00 |
| 3878341 | 3878341 | 28 | 07:45:00 | 23.06.25 | 2 | 1.8 | Metzerstrasse 1034 | 23.06.25 07:45:00 | 2025-06-23 07:45:00+02:00 |
| 3878340 | 3878340 | 25 | 07:44:58 | 23.06.25 | 2 | 0.9 | Metzerstrasse 1034 | 23.06.25 07:44:58 | 2025-06-23 07:44:58+02:00 |
| 3878339 | 3878339 | 25 | 07:44:56 | 23.06.25 | 2 | 1.2 | Metzerstrasse 1034 | 23.06.25 07:44:56 | 2025-06-23 07:44:56+02:00 |
| 3878338 | 3878338 | 24 | 07:44:53 | 23.06.25 | 2 | 1.8 | Metzerstrasse 1034 | 23.06.25 07:44:53 | 2025-06-23 07:44:53+02:00 |
| 3878337 | 3878337 | 25 | 07:44:49 | 23.06.25 | 2 | 1.8 | Metzerstrasse 1034 | 23.06.25 07:44:49 | 2025-06-23 07:44:49+02:00 |
| 3878336 | 3878336 | 32 | 07:44:44 | 23.06.25 | 2 | 2.0 | Metzerstrasse 1034 | 23.06.25 07:44:44 | 2025-06-23 07:44:44+02:00 |
| 3878335 | 3878335 | 27 | 07:44:41 | 23.06.25 | 2 | 2.7 | Metzerstrasse 1034 | 23.06.25 07:44:41 | 2025-06-23 07:44:41+02:00 |
| 3878334 | 3878334 | 27 | 07:44:38 | 23.06.25 | 2 | 3.4 | Metzerstrasse 1034 | 23.06.25 07:44:38 | 2025-06-23 07:44:38+02:00 |
| 3878333 | 3878333 | 23 | 07:44:35 | 23.06.25 | 2 | 2.1 | Metzerstrasse 1034 | 23.06.25 07:44:35 | 2025-06-23 07:44:35+02:00 |
| 3878332 | 3878332 | 17 | 07:44:33 | 23.06.25 | 2 | 1.9 | Metzerstrasse 1034 | 23.06.25 07:44:33 | 2025-06-23 07:44:33+02:00 |
| 3878331 | 3878331 | 15 | 07:43:47 | 23.06.25 | 2 | 2.6 | Metzerstrasse 1034 | 23.06.25 07:43:47 | 2025-06-23 07:43:47+02:00 |
| 3878330 | 3878330 | 21 | 07:43:45 | 23.06.25 | 2 | 0.9 | Metzerstrasse 1034 | 23.06.25 07:43:45 | 2025-06-23 07:43:45+02:00 |
| 3878329 | 3878329 | 22 | 07:43:43 | 23.06.25 | 2 | 3.6 | Metzerstrasse 1034 | 23.06.25 07:43:43 | 2025-06-23 07:43:43+02:00 |
| 3878328 | 3878328 | 15 | 07:43:40 | 23.06.25 | 2 | 2.3 | Metzerstrasse 1034 | 23.06.25 07:43:40 | 2025-06-23 07:43:40+02:00 |
| 3842277 | 3842277 | 28 | 07:43:16 | 23.06.25 | 1 | 10.6 | Metzerstrasse 1034 | 23.06.25 07:43:16 | 2025-06-23 07:43:16+02:00 |
| 3878327 | 3878327 | 25 | 07:43:13 | 23.06.25 | 2 | 0.7 | Metzerstrasse 1034 | 23.06.25 07:43:13 | 2025-06-23 07:43:13+02:00 |
| 3878326 | 3878326 | 31 | 07:43:11 | 23.06.25 | 2 | 1.7 | Metzerstrasse 1034 | 23.06.25 07:43:11 | 2025-06-23 07:43:11+02:00 |
| 3878325 | 3878325 | 30 | 07:43:09 | 23.06.25 | 2 | 1.9 | Metzerstrasse 1034 | 23.06.25 07:43:09 | 2025-06-23 07:43:09+02:00 |
| 3878324 | 3878324 | 29 | 07:43:07 | 23.06.25 | 2 | 2.1 | Metzerstrasse 1034 | 23.06.25 07:43:07 | 2025-06-23 07:43:07+02:00 |
| 3878323 | 3878323 | 22 | 07:43:02 | 23.06.25 | 2 | 1.1 | Metzerstrasse 1034 | 23.06.25 07:43:02 | 2025-06-23 07:43:02+02:00 |
| 3878322 | 3878322 | 20 | 07:43:00 | 23.06.25 | 2 | 3.7 | Metzerstrasse 1034 | 23.06.25 07:43:00 | 2025-06-23 07:43:00+02:00 |
| 3878321 | 3878321 | 17 | 07:42:57 | 23.06.25 | 2 | 2.3 | Metzerstrasse 1034 | 23.06.25 07:42:57 | 2025-06-23 07:42:57+02:00 |
| 3878320 | 3878320 | 16 | 07:42:55 | 23.06.25 | 2 | 2.3 | Metzerstrasse 1034 | 23.06.25 07:42:55 | 2025-06-23 07:42:55+02:00 |
| 3878319 | 3878319 | 13 | 07:42:26 | 23.06.25 | 2 | 1.4 | Metzerstrasse 1034 | 23.06.25 07:42:26 | 2025-06-23 07:42:26+02:00 |
| 3842276 | 3842276 | 27 | 07:42:24 | 23.06.25 | 1 | 2.2 | Metzerstrasse 1034 | 23.06.25 07:42:24 | 2025-06-23 07:42:24+02:00 |
| 3878318 | 3878318 | 18 | 07:42:22 | 23.06.25 | 2 | 1.2 | Metzerstrasse 1034 | 23.06.25 07:42:22 | 2025-06-23 07:42:22+02:00 |
| 3878317 | 3878317 | 24 | 07:42:17 | 23.06.25 | 2 | 1.1 | Metzerstrasse 1034 | 23.06.25 07:42:17 | 2025-06-23 07:42:17+02:00 |
| 3878316 | 3878316 | 20 | 07:42:15 | 23.06.25 | 2 | 2.3 | Metzerstrasse 1034 | 23.06.25 07:42:15 | 2025-06-23 07:42:15+02:00 |
| 3878315 | 3878315 | 18 | 07:42:12 | 23.06.25 | 2 | 3.5 | Metzerstrasse 1034 | 23.06.25 07:42:12 | 2025-06-23 07:42:12+02:00 |
| 3878314 | 3878314 | 26 | 07:41:22 | 23.06.25 | 2 | 14.1 | Metzerstrasse 1034 | 23.06.25 07:41:22 | 2025-06-23 07:41:22+02:00 |
| 3878313 | 3878313 | 30 | 07:41:15 | 23.06.25 | 2 | 2.1 | Metzerstrasse 1034 | 23.06.25 07:41:15 | 2025-06-23 07:41:15+02:00 |
| 3878312 | 3878312 | 29 | 07:41:13 | 23.06.25 | 2 | 1.0 | Metzerstrasse 1034 | 23.06.25 07:41:13 | 2025-06-23 07:41:13+02:00 |
| 3878311 | 3878311 | 27 | 07:41:12 | 23.06.25 | 2 | 4.7 | Metzerstrasse 1034 | 23.06.25 07:41:12 | 2025-06-23 07:41:12+02:00 |
| 3878310 | 3878310 | 23 | 07:41:09 | 23.06.25 | 2 | 1.7 | Metzerstrasse 1034 | 23.06.25 07:41:09 | 2025-06-23 07:41:09+02:00 |
| 3878309 | 3878309 | 20 | 07:41:07 | 23.06.25 | 2 | 2.2 | Metzerstrasse 1034 | 23.06.25 07:41:07 | 2025-06-23 07:41:07+02:00 |
| 3878308 | 3878308 | 18 | 07:40:59 | 23.06.25 | 2 | 1.7 | Metzerstrasse 1034 | 23.06.25 07:40:59 | 2025-06-23 07:40:59+02:00 |
| 3878307 | 3878307 | 13 | 07:40:28 | 23.06.25 | 2 | 2.0 | Metzerstrasse 1034 | 23.06.25 07:40:28 | 2025-06-23 07:40:28+02:00 |
| 3878306 | 3878306 | 17 | 07:40:23 | 23.06.25 | 2 | 1.1 | Metzerstrasse 1034 | 23.06.25 07:40:23 | 2025-06-23 07:40:23+02:00 |
| 3878305 | 3878305 | 16 | 07:40:21 | 23.06.25 | 2 | 1.1 | Metzerstrasse 1034 | 23.06.25 07:40:21 | 2025-06-23 07:40:21+02:00 |
| 3878304 | 3878304 | 12 | 07:40:17 | 23.06.25 | 2 | 2.0 | Metzerstrasse 1034 | 23.06.25 07:40:17 | 2025-06-23 07:40:17+02:00 |
| 3842275 | 3842275 | 33 | 07:39:52 | 23.06.25 | 1 | 2.3 | Metzerstrasse 1034 | 23.06.25 07:39:52 | 2025-06-23 07:39:52+02:00 |
| 3878303 | 3878303 | 22 | 07:39:10 | 23.06.25 | 2 | 2.1 | Metzerstrasse 1034 | 23.06.25 07:39:10 | 2025-06-23 07:39:10+02:00 |
| 3878302 | 3878302 | 27 | 07:39:08 | 23.06.25 | 2 | 1.9 | Metzerstrasse 1034 | 23.06.25 07:39:08 | 2025-06-23 07:39:08+02:00 |
| 3878301 | 3878301 | 24 | 07:39:04 | 23.06.25 | 2 | 15.7 | Metzerstrasse 1034 | 23.06.25 07:39:04 | 2025-06-23 07:39:04+02:00 |
| 3842274 | 3842274 | 30 | 07:38:56 | 23.06.25 | 1 | 2.2 | Metzerstrasse 1034 | 23.06.25 07:38:56 | 2025-06-23 07:38:56+02:00 |
| 3842273 | 3842273 | 25 | 07:38:42 | 23.06.25 | 1 | 2.8 | Metzerstrasse 1034 | 23.06.25 07:38:42 | 2025-06-23 07:38:42+02:00 |
| 3842272 | 3842272 | 34 | 07:38:03 | 23.06.25 | 1 | 17.3 | Metzerstrasse 1034 | 23.06.25 07:38:03 | 2025-06-23 07:38:03+02:00 |
| 3878300 | 3878300 | 33 | 07:37:36 | 23.06.25 | 2 | 2.4 | Metzerstrasse 1034 | 23.06.25 07:37:36 | 2025-06-23 07:37:36+02:00 |
| 3878299 | 3878299 | 28 | 07:37:33 | 23.06.25 | 2 | 14.0 | Metzerstrasse 1034 | 23.06.25 07:37:33 | 2025-06-23 07:37:33+02:00 |
| 3842271 | 3842271 | 42 | 07:36:41 | 23.06.25 | 1 | 1.9 | Metzerstrasse 1034 | 23.06.25 07:36:41 | 2025-06-23 07:36:41+02:00 |
| 3842270 | 3842270 | 42 | 07:36:40 | 23.06.25 | 1 | 0.8 | Metzerstrasse 1034 | 23.06.25 07:36:40 | 2025-06-23 07:36:40+02:00 |
| 3878298 | 3878298 | 13 | 07:36:27 | 23.06.25 | 2 | 4.9 | Metzerstrasse 1034 | 23.06.25 07:36:27 | 2025-06-23 07:36:27+02:00 |
| 3842269 | 3842269 | 29 | 07:36:08 | 23.06.25 | 1 | 3.0 | Metzerstrasse 1034 | 23.06.25 07:36:08 | 2025-06-23 07:36:08+02:00 |
| 3842268 | 3842268 | 29 | 07:36:06 | 23.06.25 | 1 | 4.3 | Metzerstrasse 1034 | 23.06.25 07:36:06 | 2025-06-23 07:36:06+02:00 |
| 3878297 | 3878297 | 20 | 07:36:04 | 23.06.25 | 2 | 1.4 | Metzerstrasse 1034 | 23.06.25 07:36:04 | 2025-06-23 07:36:04+02:00 |
| 3878296 | 3878296 | 18 | 07:35:19 | 23.06.25 | 2 | 1.6 | Metzerstrasse 1034 | 23.06.25 07:35:19 | 2025-06-23 07:35:19+02:00 |
| 3878295 | 3878295 | 24 | 07:35:17 | 23.06.25 | 2 | 2.2 | Metzerstrasse 1034 | 23.06.25 07:35:17 | 2025-06-23 07:35:17+02:00 |
| 3842267 | 3842267 | 29 | 07:35:06 | 23.06.25 | 1 | 2.5 | Metzerstrasse 1034 | 23.06.25 07:35:06 | 2025-06-23 07:35:06+02:00 |
| 3842266 | 3842266 | 30 | 07:35:03 | 23.06.25 | 1 | 3.7 | Metzerstrasse 1034 | 23.06.25 07:35:03 | 2025-06-23 07:35:03+02:00 |
| 3842265 | 3842265 | 45 | 07:34:56 | 23.06.25 | 1 | 2.3 | Metzerstrasse 1034 | 23.06.25 07:34:56 | 2025-06-23 07:34:56+02:00 |
| 3878294 | 3878294 | 26 | 07:34:50 | 23.06.25 | 2 | 1.8 | Metzerstrasse 1034 | 23.06.25 07:34:50 | 2025-06-23 07:34:50+02:00 |
| 3878293 | 3878293 | 24 | 07:34:41 | 23.06.25 | 2 | 1.3 | Metzerstrasse 1034 | 23.06.25 07:34:41 | 2025-06-23 07:34:41+02:00 |
| 3842264 | 3842264 | 31 | 07:34:25 | 23.06.25 | 1 | 15.6 | Metzerstrasse 1034 | 23.06.25 07:34:25 | 2025-06-23 07:34:25+02:00 |
| 3878292 | 3878292 | 31 | 07:34:18 | 23.06.25 | 2 | 1.0 | Metzerstrasse 1034 | 23.06.25 07:34:18 | 2025-06-23 07:34:18+02:00 |
| 3878291 | 3878291 | 32 | 07:34:14 | 23.06.25 | 2 | 2.2 | Metzerstrasse 1034 | 23.06.25 07:34:14 | 2025-06-23 07:34:14+02:00 |
| 3878290 | 3878290 | 35 | 07:34:12 | 23.06.25 | 2 | 1.6 | Metzerstrasse 1034 | 23.06.25 07:34:12 | 2025-06-23 07:34:12+02:00 |
| 3878289 | 3878289 | 31 | 07:34:09 | 23.06.25 | 2 | 1.2 | Metzerstrasse 1034 | 23.06.25 07:34:09 | 2025-06-23 07:34:09+02:00 |
| 3878288 | 3878288 | 27 | 07:34:07 | 23.06.25 | 2 | 1.0 | Metzerstrasse 1034 | 23.06.25 07:34:07 | 2025-06-23 07:34:07+02:00 |
| 3878287 | 3878287 | 26 | 07:34:06 | 23.06.25 | 2 | 2.3 | Metzerstrasse 1034 | 23.06.25 07:34:06 | 2025-06-23 07:34:06+02:00 |
| 3878286 | 3878286 | 26 | 07:34:02 | 23.06.25 | 2 | 1.6 | Metzerstrasse 1034 | 23.06.25 07:34:02 | 2025-06-23 07:34:02+02:00 |
| 3878285 | 3878285 | 27 | 07:34:00 | 23.06.25 | 2 | 1.9 | Metzerstrasse 1034 | 23.06.25 07:34:00 | 2025-06-23 07:34:00+02:00 |
| 3878284 | 3878284 | 25 | 07:33:58 | 23.06.25 | 2 | 1.6 | Metzerstrasse 1034 | 23.06.25 07:33:58 | 2025-06-23 07:33:58+02:00 |
| 3878283 | 3878283 | 18 | 07:33:56 | 23.06.25 | 2 | 1.1 | Metzerstrasse 1034 | 23.06.25 07:33:56 | 2025-06-23 07:33:56+02:00 |
| 3878282 | 3878282 | 16 | 07:33:53 | 23.06.25 | 2 | 1.6 | Metzerstrasse 1034 | 23.06.25 07:33:53 | 2025-06-23 07:33:53+02:00 |
| 3878281 | 3878281 | 18 | 07:33:10 | 23.06.25 | 2 | 4.4 | Metzerstrasse 1034 | 23.06.25 07:33:10 | 2025-06-23 07:33:10+02:00 |
| 3878280 | 3878280 | 29 | 07:33:04 | 23.06.25 | 2 | 1.8 | Metzerstrasse 1034 | 23.06.25 07:33:04 | 2025-06-23 07:33:04+02:00 |
| 3842263 | 3842263 | 27 | 07:33:02 | 23.06.25 | 1 | 2.1 | Metzerstrasse 1034 | 23.06.25 07:33:02 | 2025-06-23 07:33:02+02:00 |
| 3878279 | 3878279 | 12 | 07:32:55 | 23.06.25 | 2 | 3.4 | Metzerstrasse 1034 | 23.06.25 07:32:55 | 2025-06-23 07:32:55+02:00 |
| 3878278 | 3878278 | 16 | 07:32:51 | 23.06.25 | 2 | 7.9 | Metzerstrasse 1034 | 23.06.25 07:32:51 | 2025-06-23 07:32:51+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");