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
7,210 rows where Messung-ID = 1131 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 ▲ |
|---|---|---|---|---|---|---|---|---|---|
| 2797245 | 2797245 | 18 | 13:41:32 | 27.01.26 | 2 | 1.2 | Wiesenstrasse 1131 | 27.01.26 13:41:32 | 2026-01-27 13:41:32+01:00 |
| 2797244 | 2797244 | 26 | 13:38:28 | 27.01.26 | 2 | 4.9 | Wiesenstrasse 1131 | 27.01.26 13:38:28 | 2026-01-27 13:38:28+01:00 |
| 2797243 | 2797243 | 17 | 13:37:12 | 27.01.26 | 2 | 5.3 | Wiesenstrasse 1131 | 27.01.26 13:37:12 | 2026-01-27 13:37:12+01:00 |
| 2801301 | 2801301 | 14 | 13:35:55 | 27.01.26 | 1 | 5.4 | Wiesenstrasse 1131 | 27.01.26 13:35:55 | 2026-01-27 13:35:55+01:00 |
| 2801300 | 2801300 | 29 | 13:34:33 | 27.01.26 | 1 | 4.7 | Wiesenstrasse 1131 | 27.01.26 13:34:33 | 2026-01-27 13:34:33+01:00 |
| 2797242 | 2797242 | 24 | 13:32:24 | 27.01.26 | 2 | 1.4 | Wiesenstrasse 1131 | 27.01.26 13:32:24 | 2026-01-27 13:32:24+01:00 |
| 2801299 | 2801299 | 23 | 13:32:02 | 27.01.26 | 1 | 5.4 | Wiesenstrasse 1131 | 27.01.26 13:32:02 | 2026-01-27 13:32:02+01:00 |
| 2797241 | 2797241 | 16 | 13:29:13 | 27.01.26 | 2 | 1.7 | Wiesenstrasse 1131 | 27.01.26 13:29:13 | 2026-01-27 13:29:13+01:00 |
| 2797240 | 2797240 | 20 | 13:28:57 | 27.01.26 | 2 | 5.3 | Wiesenstrasse 1131 | 27.01.26 13:28:57 | 2026-01-27 13:28:57+01:00 |
| 2797239 | 2797239 | 14 | 13:27:49 | 27.01.26 | 2 | 4.8 | Wiesenstrasse 1131 | 27.01.26 13:27:49 | 2026-01-27 13:27:49+01:00 |
| 2801298 | 2801298 | 16 | 13:27:33 | 27.01.26 | 1 | 5.3 | Wiesenstrasse 1131 | 27.01.26 13:27:33 | 2026-01-27 13:27:33+01:00 |
| 2797238 | 2797238 | 22 | 13:23:03 | 27.01.26 | 2 | 1.7 | Wiesenstrasse 1131 | 27.01.26 13:23:03 | 2026-01-27 13:23:03+01:00 |
| 2801297 | 2801297 | 28 | 13:22:57 | 27.01.26 | 1 | 7.4 | Wiesenstrasse 1131 | 27.01.26 13:22:57 | 2026-01-27 13:22:57+01:00 |
| 2801296 | 2801296 | 12 | 13:22:37 | 27.01.26 | 1 | 3.3 | Wiesenstrasse 1131 | 27.01.26 13:22:37 | 2026-01-27 13:22:37+01:00 |
| 2797237 | 2797237 | 22 | 13:22:30 | 27.01.26 | 2 | 5.2 | Wiesenstrasse 1131 | 27.01.26 13:22:30 | 2026-01-27 13:22:30+01:00 |
| 2801295 | 2801295 | 26 | 13:22:15 | 27.01.26 | 1 | 4.9 | Wiesenstrasse 1131 | 27.01.26 13:22:15 | 2026-01-27 13:22:15+01:00 |
| 2801294 | 2801294 | 17 | 13:21:39 | 27.01.26 | 1 | 5.3 | Wiesenstrasse 1131 | 27.01.26 13:21:39 | 2026-01-27 13:21:39+01:00 |
| 2797236 | 2797236 | 17 | 13:21:34 | 27.01.26 | 2 | 3.9 | Wiesenstrasse 1131 | 27.01.26 13:21:34 | 2026-01-27 13:21:34+01:00 |
| 2801293 | 2801293 | 21 | 13:20:44 | 27.01.26 | 1 | 4.5 | Wiesenstrasse 1131 | 27.01.26 13:20:44 | 2026-01-27 13:20:44+01:00 |
| 2801292 | 2801292 | 16 | 13:18:54 | 27.01.26 | 1 | 5.3 | Wiesenstrasse 1131 | 27.01.26 13:18:54 | 2026-01-27 13:18:54+01:00 |
| 2797235 | 2797235 | 19 | 13:18:33 | 27.01.26 | 2 | 4.4 | Wiesenstrasse 1131 | 27.01.26 13:18:33 | 2026-01-27 13:18:33+01:00 |
| 2797234 | 2797234 | 17 | 13:18:29 | 27.01.26 | 2 | 5.1 | Wiesenstrasse 1131 | 27.01.26 13:18:29 | 2026-01-27 13:18:29+01:00 |
| 2801291 | 2801291 | 23 | 13:17:51 | 27.01.26 | 1 | 4.3 | Wiesenstrasse 1131 | 27.01.26 13:17:51 | 2026-01-27 13:17:51+01:00 |
| 2797233 | 2797233 | 21 | 13:17:27 | 27.01.26 | 2 | 4.1 | Wiesenstrasse 1131 | 27.01.26 13:17:27 | 2026-01-27 13:17:27+01:00 |
| 2797232 | 2797232 | 17 | 13:17:16 | 27.01.26 | 2 | 2.0 | Wiesenstrasse 1131 | 27.01.26 13:17:16 | 2026-01-27 13:17:16+01:00 |
| 2801290 | 2801290 | 22 | 13:16:21 | 27.01.26 | 1 | 5.2 | Wiesenstrasse 1131 | 27.01.26 13:16:21 | 2026-01-27 13:16:21+01:00 |
| 2797231 | 2797231 | 18 | 13:16:16 | 27.01.26 | 2 | 2.1 | Wiesenstrasse 1131 | 27.01.26 13:16:16 | 2026-01-27 13:16:16+01:00 |
| 2797230 | 2797230 | 18 | 13:15:43 | 27.01.26 | 2 | 7.0 | Wiesenstrasse 1131 | 27.01.26 13:15:43 | 2026-01-27 13:15:43+01:00 |
| 2801289 | 2801289 | 26 | 13:14:09 | 27.01.26 | 1 | 4.7 | Wiesenstrasse 1131 | 27.01.26 13:14:09 | 2026-01-27 13:14:09+01:00 |
| 2797229 | 2797229 | 23 | 13:11:43 | 27.01.26 | 2 | 0.9 | Wiesenstrasse 1131 | 27.01.26 13:11:43 | 2026-01-27 13:11:43+01:00 |
| 2801288 | 2801288 | 17 | 13:10:11 | 27.01.26 | 1 | 5.8 | Wiesenstrasse 1131 | 27.01.26 13:10:11 | 2026-01-27 13:10:11+01:00 |
| 2797228 | 2797228 | 14 | 13:08:34 | 27.01.26 | 2 | 4.6 | Wiesenstrasse 1131 | 27.01.26 13:08:34 | 2026-01-27 13:08:34+01:00 |
| 2801287 | 2801287 | 9 | 13:07:48 | 27.01.26 | 1 | 5.2 | Wiesenstrasse 1131 | 27.01.26 13:07:48 | 2026-01-27 13:07:48+01:00 |
| 2801286 | 2801286 | 18 | 13:07:12 | 27.01.26 | 1 | 5.2 | Wiesenstrasse 1131 | 27.01.26 13:07:12 | 2026-01-27 13:07:12+01:00 |
| 2797227 | 2797227 | 20 | 13:06:38 | 27.01.26 | 2 | 5.0 | Wiesenstrasse 1131 | 27.01.26 13:06:38 | 2026-01-27 13:06:38+01:00 |
| 2801285 | 2801285 | 19 | 13:04:40 | 27.01.26 | 1 | 5.1 | Wiesenstrasse 1131 | 27.01.26 13:04:40 | 2026-01-27 13:04:40+01:00 |
| 2801284 | 2801284 | 27 | 13:03:12 | 27.01.26 | 1 | 5.1 | Wiesenstrasse 1131 | 27.01.26 13:03:12 | 2026-01-27 13:03:12+01:00 |
| 2801283 | 2801283 | 18 | 13:02:38 | 27.01.26 | 1 | 3.1 | Wiesenstrasse 1131 | 27.01.26 13:02:38 | 2026-01-27 13:02:38+01:00 |
| 2801282 | 2801282 | 21 | 13:01:57 | 27.01.26 | 1 | 4.6 | Wiesenstrasse 1131 | 27.01.26 13:01:57 | 2026-01-27 13:01:57+01:00 |
| 2801281 | 2801281 | 15 | 13:01:52 | 27.01.26 | 1 | 5.1 | Wiesenstrasse 1131 | 27.01.26 13:01:52 | 2026-01-27 13:01:52+01:00 |
| 2801280 | 2801280 | 22 | 13:01:23 | 27.01.26 | 1 | 5.1 | Wiesenstrasse 1131 | 27.01.26 13:01:23 | 2026-01-27 13:01:23+01:00 |
| 2801279 | 2801279 | 22 | 12:57:47 | 27.01.26 | 1 | 5.1 | Wiesenstrasse 1131 | 27.01.26 12:57:47 | 2026-01-27 12:57:47+01:00 |
| 2797226 | 2797226 | 22 | 12:55:29 | 27.01.26 | 2 | 4.5 | Wiesenstrasse 1131 | 27.01.26 12:55:29 | 2026-01-27 12:55:29+01:00 |
| 2801278 | 2801278 | 17 | 12:54:58 | 27.01.26 | 1 | 5.0 | Wiesenstrasse 1131 | 27.01.26 12:54:58 | 2026-01-27 12:54:58+01:00 |
| 2801277 | 2801277 | 18 | 12:53:11 | 27.01.26 | 1 | 5.0 | Wiesenstrasse 1131 | 27.01.26 12:53:11 | 2026-01-27 12:53:11+01:00 |
| 2797225 | 2797225 | 34 | 12:50:49 | 27.01.26 | 2 | 5.0 | Wiesenstrasse 1131 | 27.01.26 12:50:49 | 2026-01-27 12:50:49+01:00 |
| 2801276 | 2801276 | 38 | 12:50:00 | 27.01.26 | 1 | 4.1 | Wiesenstrasse 1131 | 27.01.26 12:50:00 | 2026-01-27 12:50:00+01:00 |
| 2801275 | 2801275 | 17 | 12:48:25 | 27.01.26 | 1 | 5.0 | Wiesenstrasse 1131 | 27.01.26 12:48:25 | 2026-01-27 12:48:25+01:00 |
| 2801274 | 2801274 | 33 | 12:47:35 | 27.01.26 | 1 | 4.8 | Wiesenstrasse 1131 | 27.01.26 12:47:35 | 2026-01-27 12:47:35+01:00 |
| 2801273 | 2801273 | 24 | 12:47:11 | 27.01.26 | 1 | 5.0 | Wiesenstrasse 1131 | 27.01.26 12:47:11 | 2026-01-27 12:47:11+01:00 |
| 2797224 | 2797224 | 21 | 12:44:46 | 27.01.26 | 2 | 4.9 | Wiesenstrasse 1131 | 27.01.26 12:44:46 | 2026-01-27 12:44:46+01:00 |
| 2797223 | 2797223 | 17 | 12:43:15 | 27.01.26 | 2 | 1.3 | Wiesenstrasse 1131 | 27.01.26 12:43:15 | 2026-01-27 12:43:15+01:00 |
| 2801272 | 2801272 | 14 | 12:42:44 | 27.01.26 | 1 | 4.3 | Wiesenstrasse 1131 | 27.01.26 12:42:44 | 2026-01-27 12:42:44+01:00 |
| 2797222 | 2797222 | 25 | 12:42:28 | 27.01.26 | 2 | 4.9 | Wiesenstrasse 1131 | 27.01.26 12:42:28 | 2026-01-27 12:42:28+01:00 |
| 2801271 | 2801271 | 23 | 12:42:13 | 27.01.26 | 1 | 5.6 | Wiesenstrasse 1131 | 27.01.26 12:42:13 | 2026-01-27 12:42:13+01:00 |
| 2797221 | 2797221 | 22 | 12:40:35 | 27.01.26 | 2 | 1.1 | Wiesenstrasse 1131 | 27.01.26 12:40:35 | 2026-01-27 12:40:35+01:00 |
| 2801270 | 2801270 | 15 | 12:39:33 | 27.01.26 | 1 | 4.9 | Wiesenstrasse 1131 | 27.01.26 12:39:33 | 2026-01-27 12:39:33+01:00 |
| 2801269 | 2801269 | 19 | 12:39:26 | 27.01.26 | 1 | 4.9 | Wiesenstrasse 1131 | 27.01.26 12:39:26 | 2026-01-27 12:39:26+01:00 |
| 2801268 | 2801268 | 12 | 12:38:13 | 27.01.26 | 1 | 4.9 | Wiesenstrasse 1131 | 27.01.26 12:38:13 | 2026-01-27 12:38:13+01:00 |
| 2801267 | 2801267 | 20 | 12:37:28 | 27.01.26 | 1 | 2.6 | Wiesenstrasse 1131 | 27.01.26 12:37:28 | 2026-01-27 12:37:28+01:00 |
| 2797220 | 2797220 | 24 | 12:35:44 | 27.01.26 | 2 | 4.3 | Wiesenstrasse 1131 | 27.01.26 12:35:44 | 2026-01-27 12:35:44+01:00 |
| 2801266 | 2801266 | 10 | 12:35:11 | 27.01.26 | 1 | 4.9 | Wiesenstrasse 1131 | 27.01.26 12:35:11 | 2026-01-27 12:35:11+01:00 |
| 2797219 | 2797219 | 19 | 12:33:15 | 27.01.26 | 2 | 4.8 | Wiesenstrasse 1131 | 27.01.26 12:33:15 | 2026-01-27 12:33:15+01:00 |
| 2801265 | 2801265 | 19 | 12:30:36 | 27.01.26 | 1 | 4.8 | Wiesenstrasse 1131 | 27.01.26 12:30:36 | 2026-01-27 12:30:36+01:00 |
| 2801264 | 2801264 | 12 | 12:29:57 | 27.01.26 | 1 | 5.3 | Wiesenstrasse 1131 | 27.01.26 12:29:57 | 2026-01-27 12:29:57+01:00 |
| 2797218 | 2797218 | 16 | 12:28:45 | 27.01.26 | 2 | 4.7 | Wiesenstrasse 1131 | 27.01.26 12:28:45 | 2026-01-27 12:28:45+01:00 |
| 2801263 | 2801263 | 20 | 12:26:35 | 27.01.26 | 1 | 4.8 | Wiesenstrasse 1131 | 27.01.26 12:26:35 | 2026-01-27 12:26:35+01:00 |
| 2797217 | 2797217 | 24 | 12:24:31 | 27.01.26 | 2 | 1.5 | Wiesenstrasse 1131 | 27.01.26 12:24:31 | 2026-01-27 12:24:31+01:00 |
| 2797216 | 2797216 | 19 | 12:23:01 | 27.01.26 | 2 | 4.7 | Wiesenstrasse 1131 | 27.01.26 12:23:01 | 2026-01-27 12:23:01+01:00 |
| 2801262 | 2801262 | 15 | 12:22:18 | 27.01.26 | 1 | 4.8 | Wiesenstrasse 1131 | 27.01.26 12:22:18 | 2026-01-27 12:22:18+01:00 |
| 2801261 | 2801261 | 16 | 12:21:58 | 27.01.26 | 1 | 3.1 | Wiesenstrasse 1131 | 27.01.26 12:21:58 | 2026-01-27 12:21:58+01:00 |
| 2801260 | 2801260 | 13 | 12:17:38 | 27.01.26 | 1 | 4.7 | Wiesenstrasse 1131 | 27.01.26 12:17:38 | 2026-01-27 12:17:38+01:00 |
| 2797215 | 2797215 | 24 | 12:14:31 | 27.01.26 | 2 | 1.2 | Wiesenstrasse 1131 | 27.01.26 12:14:31 | 2026-01-27 12:14:31+01:00 |
| 2801259 | 2801259 | 18 | 12:14:18 | 27.01.26 | 1 | 4.7 | Wiesenstrasse 1131 | 27.01.26 12:14:18 | 2026-01-27 12:14:18+01:00 |
| 2801258 | 2801258 | 25 | 12:13:41 | 27.01.26 | 1 | 7.4 | Wiesenstrasse 1131 | 27.01.26 12:13:41 | 2026-01-27 12:13:41+01:00 |
| 2797214 | 2797214 | 22 | 12:11:45 | 27.01.26 | 2 | 4.9 | Wiesenstrasse 1131 | 27.01.26 12:11:45 | 2026-01-27 12:11:45+01:00 |
| 2797213 | 2797213 | 26 | 12:07:44 | 27.01.26 | 2 | 1.7 | Wiesenstrasse 1131 | 27.01.26 12:07:44 | 2026-01-27 12:07:44+01:00 |
| 2801257 | 2801257 | 22 | 12:05:47 | 27.01.26 | 1 | 4.4 | Wiesenstrasse 1131 | 27.01.26 12:05:47 | 2026-01-27 12:05:47+01:00 |
| 2797212 | 2797212 | 18 | 12:05:36 | 27.01.26 | 2 | 1.1 | Wiesenstrasse 1131 | 27.01.26 12:05:36 | 2026-01-27 12:05:36+01:00 |
| 2797211 | 2797211 | 32 | 12:03:57 | 27.01.26 | 2 | 4.6 | Wiesenstrasse 1131 | 27.01.26 12:03:57 | 2026-01-27 12:03:57+01:00 |
| 2797210 | 2797210 | 16 | 12:03:29 | 27.01.26 | 2 | 0.7 | Wiesenstrasse 1131 | 27.01.26 12:03:29 | 2026-01-27 12:03:29+01:00 |
| 2797209 | 2797209 | 22 | 12:03:24 | 27.01.26 | 2 | 4.6 | Wiesenstrasse 1131 | 27.01.26 12:03:24 | 2026-01-27 12:03:24+01:00 |
| 2801256 | 2801256 | 31 | 12:01:26 | 27.01.26 | 1 | 4.6 | Wiesenstrasse 1131 | 27.01.26 12:01:26 | 2026-01-27 12:01:26+01:00 |
| 2797208 | 2797208 | 23 | 11:58:37 | 27.01.26 | 2 | 4.6 | Wiesenstrasse 1131 | 27.01.26 11:58:37 | 2026-01-27 11:58:37+01:00 |
| 2797207 | 2797207 | 24 | 11:56:54 | 27.01.26 | 2 | 1.4 | Wiesenstrasse 1131 | 27.01.26 11:56:54 | 2026-01-27 11:56:54+01:00 |
| 2801255 | 2801255 | 16 | 11:54:48 | 27.01.26 | 1 | 4.7 | Wiesenstrasse 1131 | 27.01.26 11:54:48 | 2026-01-27 11:54:48+01:00 |
| 2801254 | 2801254 | 20 | 11:54:04 | 27.01.26 | 1 | 4.2 | Wiesenstrasse 1131 | 27.01.26 11:54:04 | 2026-01-27 11:54:04+01:00 |
| 2801253 | 2801253 | 14 | 11:52:01 | 27.01.26 | 1 | 4.7 | Wiesenstrasse 1131 | 27.01.26 11:52:01 | 2026-01-27 11:52:01+01:00 |
| 2797206 | 2797206 | 18 | 11:50:26 | 27.01.26 | 2 | 0.6 | Wiesenstrasse 1131 | 27.01.26 11:50:26 | 2026-01-27 11:50:26+01:00 |
| 2797205 | 2797205 | 18 | 11:47:50 | 27.01.26 | 2 | 16.6 | Wiesenstrasse 1131 | 27.01.26 11:47:50 | 2026-01-27 11:47:50+01:00 |
| 2801252 | 2801252 | 27 | 11:45:40 | 27.01.26 | 1 | 4.5 | Wiesenstrasse 1131 | 27.01.26 11:45:40 | 2026-01-27 11:45:40+01:00 |
| 2801251 | 2801251 | 14 | 11:45:35 | 27.01.26 | 1 | 4.7 | Wiesenstrasse 1131 | 27.01.26 11:45:35 | 2026-01-27 11:45:35+01:00 |
| 2801250 | 2801250 | 15 | 11:44:10 | 27.01.26 | 1 | 4.7 | Wiesenstrasse 1131 | 27.01.26 11:44:10 | 2026-01-27 11:44:10+01:00 |
| 2801249 | 2801249 | 19 | 11:43:06 | 27.01.26 | 1 | 4.7 | Wiesenstrasse 1131 | 27.01.26 11:43:06 | 2026-01-27 11:43:06+01:00 |
| 2797204 | 2797204 | 20 | 11:43:00 | 27.01.26 | 2 | 1.5 | Wiesenstrasse 1131 | 27.01.26 11:43:00 | 2026-01-27 11:43:00+01:00 |
| 2801248 | 2801248 | 27 | 11:42:05 | 27.01.26 | 1 | 7.3 | Wiesenstrasse 1131 | 27.01.26 11:42:05 | 2026-01-27 11:42:05+01:00 |
| 2801247 | 2801247 | 18 | 11:39:32 | 27.01.26 | 1 | 4.1 | Wiesenstrasse 1131 | 27.01.26 11:39:32 | 2026-01-27 11:39:32+01:00 |
| 2801246 | 2801246 | 7 | 11:38:31 | 27.01.26 | 1 | 4.6 | Wiesenstrasse 1131 | 27.01.26 11:38:31 | 2026-01-27 11:38:31+01:00 |
| 2801245 | 2801245 | 6 | 11:38:30 | 27.01.26 | 1 | 0.9 | Wiesenstrasse 1131 | 27.01.26 11:38:30 | 2026-01-27 11:38:30+01:00 |
| 2797203 | 2797203 | 14 | 11:38:16 | 27.01.26 | 2 | 4.5 | Wiesenstrasse 1131 | 27.01.26 11:38:16 | 2026-01-27 11:38:16+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");