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
1,851 rows where Messung-ID = 1023 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 ▲ |
|---|---|---|---|---|---|---|---|---|---|
| 4536299 | 4536299 | 11 | 10:06:27 | 02.06.25 | 1 | 0.9 | Paradieshofstrasse 1023 | 02.06.25 10:06:27 | 2025-06-02 10:06:27+02:00 |
| 4536298 | 4536298 | 12 | 10:06:13 | 02.06.25 | 1 | 3.8 | Paradieshofstrasse 1023 | 02.06.25 10:06:13 | 2025-06-02 10:06:13+02:00 |
| 4536297 | 4536297 | 17 | 10:05:09 | 02.06.25 | 1 | 4.4 | Paradieshofstrasse 1023 | 02.06.25 10:05:09 | 2025-06-02 10:05:09+02:00 |
| 4536296 | 4536296 | 25 | 10:03:57 | 02.06.25 | 1 | 4.6 | Paradieshofstrasse 1023 | 02.06.25 10:03:57 | 2025-06-02 10:03:57+02:00 |
| 4536295 | 4536295 | 26 | 10:03:53 | 02.06.25 | 1 | 4.1 | Paradieshofstrasse 1023 | 02.06.25 10:03:53 | 2025-06-02 10:03:53+02:00 |
| 4536294 | 4536294 | 15 | 10:02:49 | 02.06.25 | 1 | 4.4 | Paradieshofstrasse 1023 | 02.06.25 10:02:49 | 2025-06-02 10:02:49+02:00 |
| 4536293 | 4536293 | 19 | 10:00:47 | 02.06.25 | 1 | 4.9 | Paradieshofstrasse 1023 | 02.06.25 10:00:47 | 2025-06-02 10:00:47+02:00 |
| 4536292 | 4536292 | 25 | 09:59:18 | 02.06.25 | 1 | 4.5 | Paradieshofstrasse 1023 | 02.06.25 09:59:18 | 2025-06-02 09:59:18+02:00 |
| 4536291 | 4536291 | 25 | 09:56:41 | 02.06.25 | 1 | 3.3 | Paradieshofstrasse 1023 | 02.06.25 09:56:41 | 2025-06-02 09:56:41+02:00 |
| 4536289 | 4536289 | 13 | 09:53:08 | 02.06.25 | 1 | 4.3 | Paradieshofstrasse 1023 | 02.06.25 09:53:08 | 2025-06-02 09:53:08+02:00 |
| 4536290 | 4536290 | 13 | 09:53:08 | 02.06.25 | 1 | 4.3 | Paradieshofstrasse 1023 | 02.06.25 09:53:08 | 2025-06-02 09:53:08+02:00 |
| 4536288 | 4536288 | 12 | 09:49:25 | 02.06.25 | 1 | 4.3 | Paradieshofstrasse 1023 | 02.06.25 09:49:25 | 2025-06-02 09:49:25+02:00 |
| 4536287 | 4536287 | 13 | 09:49:24 | 02.06.25 | 1 | 4.3 | Paradieshofstrasse 1023 | 02.06.25 09:49:24 | 2025-06-02 09:49:24+02:00 |
| 4536286 | 4536286 | 18 | 09:48:28 | 02.06.25 | 1 | 4.3 | Paradieshofstrasse 1023 | 02.06.25 09:48:28 | 2025-06-02 09:48:28+02:00 |
| 4536285 | 4536285 | 20 | 09:48:27 | 02.06.25 | 1 | 4.3 | Paradieshofstrasse 1023 | 02.06.25 09:48:27 | 2025-06-02 09:48:27+02:00 |
| 4536284 | 4536284 | 26 | 09:44:15 | 02.06.25 | 1 | 4.3 | Paradieshofstrasse 1023 | 02.06.25 09:44:15 | 2025-06-02 09:44:15+02:00 |
| 4536283 | 4536283 | 21 | 09:43:33 | 02.06.25 | 1 | 4.3 | Paradieshofstrasse 1023 | 02.06.25 09:43:33 | 2025-06-02 09:43:33+02:00 |
| 4536282 | 4536282 | 28 | 09:42:03 | 02.06.25 | 1 | 3.5 | Paradieshofstrasse 1023 | 02.06.25 09:42:03 | 2025-06-02 09:42:03+02:00 |
| 4536281 | 4536281 | 23 | 09:40:59 | 02.06.25 | 1 | 3.8 | Paradieshofstrasse 1023 | 02.06.25 09:40:59 | 2025-06-02 09:40:59+02:00 |
| 4536280 | 4536280 | 23 | 09:35:26 | 02.06.25 | 1 | 4.3 | Paradieshofstrasse 1023 | 02.06.25 09:35:26 | 2025-06-02 09:35:26+02:00 |
| 4536279 | 4536279 | 27 | 09:33:09 | 02.06.25 | 1 | 3.6 | Paradieshofstrasse 1023 | 02.06.25 09:33:09 | 2025-06-02 09:33:09+02:00 |
| 4536278 | 4536278 | 19 | 09:18:28 | 02.06.25 | 1 | 4.3 | Paradieshofstrasse 1023 | 02.06.25 09:18:28 | 2025-06-02 09:18:28+02:00 |
| 4536277 | 4536277 | 10 | 09:15:46 | 02.06.25 | 1 | 6.0 | Paradieshofstrasse 1023 | 02.06.25 09:15:46 | 2025-06-02 09:15:46+02:00 |
| 4536276 | 4536276 | 27 | 08:40:00 | 02.06.25 | 1 | 3.0 | Paradieshofstrasse 1023 | 02.06.25 08:40:00 | 2025-06-02 08:40:00+02:00 |
| 4536275 | 4536275 | 17 | 08:18:52 | 02.06.25 | 1 | 4.2 | Paradieshofstrasse 1023 | 02.06.25 08:18:52 | 2025-06-02 08:18:52+02:00 |
| 4536274 | 4536274 | 17 | 08:18:51 | 02.06.25 | 1 | 3.6 | Paradieshofstrasse 1023 | 02.06.25 08:18:51 | 2025-06-02 08:18:51+02:00 |
| 4536273 | 4536273 | 25 | 07:33:57 | 02.06.25 | 1 | 3.3 | Paradieshofstrasse 1023 | 02.06.25 07:33:57 | 2025-06-02 07:33:57+02:00 |
| 4536272 | 4536272 | 17 | 07:33:13 | 02.06.25 | 1 | 4.2 | Paradieshofstrasse 1023 | 02.06.25 07:33:13 | 2025-06-02 07:33:13+02:00 |
| 4536271 | 4536271 | 29 | 07:32:57 | 02.06.25 | 1 | 3.9 | Paradieshofstrasse 1023 | 02.06.25 07:32:57 | 2025-06-02 07:32:57+02:00 |
| 4536270 | 4536270 | 21 | 07:21:46 | 02.06.25 | 1 | 0.5 | Paradieshofstrasse 1023 | 02.06.25 07:21:46 | 2025-06-02 07:21:46+02:00 |
| 4536268 | 4536268 | 23 | 07:11:21 | 02.06.25 | 1 | 0.7 | Paradieshofstrasse 1023 | 02.06.25 07:11:21 | 2025-06-02 07:11:21+02:00 |
| 4536269 | 4536269 | 24 | 07:11:21 | 02.06.25 | 1 | 4.2 | Paradieshofstrasse 1023 | 02.06.25 07:11:21 | 2025-06-02 07:11:21+02:00 |
| 4536267 | 4536267 | 19 | 07:08:28 | 02.06.25 | 1 | 0.8 | Paradieshofstrasse 1023 | 02.06.25 07:08:28 | 2025-06-02 07:08:28+02:00 |
| 4536266 | 4536266 | 21 | 06:44:31 | 02.06.25 | 1 | 2.0 | Paradieshofstrasse 1023 | 02.06.25 06:44:31 | 2025-06-02 06:44:31+02:00 |
| 4536265 | 4536265 | 23 | 06:43:44 | 02.06.25 | 1 | 1.4 | Paradieshofstrasse 1023 | 02.06.25 06:43:44 | 2025-06-02 06:43:44+02:00 |
| 4536264 | 4536264 | 25 | 06:36:04 | 02.06.25 | 1 | 3.5 | Paradieshofstrasse 1023 | 02.06.25 06:36:04 | 2025-06-02 06:36:04+02:00 |
| 4536262 | 4536262 | 15 | 06:31:13 | 02.06.25 | 1 | 1.9 | Paradieshofstrasse 1023 | 02.06.25 06:31:13 | 2025-06-02 06:31:13+02:00 |
| 4536263 | 4536263 | 18 | 06:31:13 | 02.06.25 | 1 | 4.2 | Paradieshofstrasse 1023 | 02.06.25 06:31:13 | 2025-06-02 06:31:13+02:00 |
| 4536261 | 4536261 | 24 | 06:24:28 | 02.06.25 | 1 | 3.7 | Paradieshofstrasse 1023 | 02.06.25 06:24:28 | 2025-06-02 06:24:28+02:00 |
| 4536260 | 4536260 | 21 | 06:07:19 | 02.06.25 | 1 | 4.2 | Paradieshofstrasse 1023 | 02.06.25 06:07:19 | 2025-06-02 06:07:19+02:00 |
| 4536259 | 4536259 | 31 | 05:52:38 | 02.06.25 | 1 | 4.1 | Paradieshofstrasse 1023 | 02.06.25 05:52:38 | 2025-06-02 05:52:38+02:00 |
| 4536258 | 4536258 | 17 | 21:18:33 | 01.06.25 | 1 | 4.2 | Paradieshofstrasse 1023 | 01.06.25 21:18:33 | 2025-06-01 21:18:33+02:00 |
| 4536257 | 4536257 | 23 | 19:45:55 | 01.06.25 | 1 | 4.4 | Paradieshofstrasse 1023 | 01.06.25 19:45:55 | 2025-06-01 19:45:55+02:00 |
| 4536256 | 4536256 | 23 | 19:41:06 | 01.06.25 | 1 | 5.0 | Paradieshofstrasse 1023 | 01.06.25 19:41:06 | 2025-06-01 19:41:06+02:00 |
| 4536255 | 4536255 | 16 | 19:33:01 | 01.06.25 | 1 | 4.2 | Paradieshofstrasse 1023 | 01.06.25 19:33:01 | 2025-06-01 19:33:01+02:00 |
| 4536254 | 4536254 | 25 | 19:31:50 | 01.06.25 | 1 | 4.2 | Paradieshofstrasse 1023 | 01.06.25 19:31:50 | 2025-06-01 19:31:50+02:00 |
| 4536253 | 4536253 | 5 | 19:19:49 | 01.06.25 | 1 | 0.8 | Paradieshofstrasse 1023 | 01.06.25 19:19:49 | 2025-06-01 19:19:49+02:00 |
| 4536252 | 4536252 | 23 | 19:16:56 | 01.06.25 | 1 | 3.8 | Paradieshofstrasse 1023 | 01.06.25 19:16:56 | 2025-06-01 19:16:56+02:00 |
| 4536251 | 4536251 | 38 | 19:02:07 | 01.06.25 | 1 | 4.1 | Paradieshofstrasse 1023 | 01.06.25 19:02:07 | 2025-06-01 19:02:07+02:00 |
| 4536250 | 4536250 | 23 | 18:53:37 | 01.06.25 | 1 | 4.5 | Paradieshofstrasse 1023 | 01.06.25 18:53:37 | 2025-06-01 18:53:37+02:00 |
| 4536249 | 4536249 | 18 | 18:51:21 | 01.06.25 | 1 | 4.1 | Paradieshofstrasse 1023 | 01.06.25 18:51:21 | 2025-06-01 18:51:21+02:00 |
| 4536248 | 4536248 | 26 | 18:23:31 | 01.06.25 | 1 | 1.0 | Paradieshofstrasse 1023 | 01.06.25 18:23:31 | 2025-06-01 18:23:31+02:00 |
| 4536247 | 4536247 | 19 | 17:39:16 | 01.06.25 | 1 | 0.5 | Paradieshofstrasse 1023 | 01.06.25 17:39:16 | 2025-06-01 17:39:16+02:00 |
| 4536246 | 4536246 | 25 | 16:56:09 | 01.06.25 | 1 | 4.2 | Paradieshofstrasse 1023 | 01.06.25 16:56:09 | 2025-06-01 16:56:09+02:00 |
| 4536245 | 4536245 | 15 | 16:53:58 | 01.06.25 | 1 | 4.2 | Paradieshofstrasse 1023 | 01.06.25 16:53:58 | 2025-06-01 16:53:58+02:00 |
| 4536244 | 4536244 | 27 | 16:36:12 | 01.06.25 | 1 | 1.5 | Paradieshofstrasse 1023 | 01.06.25 16:36:12 | 2025-06-01 16:36:12+02:00 |
| 4536243 | 4536243 | 13 | 15:27:32 | 01.06.25 | 1 | 4.2 | Paradieshofstrasse 1023 | 01.06.25 15:27:32 | 2025-06-01 15:27:32+02:00 |
| 4536242 | 4536242 | 35 | 15:18:55 | 01.06.25 | 1 | 4.1 | Paradieshofstrasse 1023 | 01.06.25 15:18:55 | 2025-06-01 15:18:55+02:00 |
| 4536241 | 4536241 | 28 | 15:15:34 | 01.06.25 | 1 | 4.1 | Paradieshofstrasse 1023 | 01.06.25 15:15:34 | 2025-06-01 15:15:34+02:00 |
| 4536240 | 4536240 | 31 | 14:55:50 | 01.06.25 | 1 | 1.7 | Paradieshofstrasse 1023 | 01.06.25 14:55:50 | 2025-06-01 14:55:50+02:00 |
| 4536239 | 4536239 | 34 | 14:04:51 | 01.06.25 | 1 | 0.5 | Paradieshofstrasse 1023 | 01.06.25 14:04:51 | 2025-06-01 14:04:51+02:00 |
| 4536238 | 4536238 | 29 | 13:14:11 | 01.06.25 | 1 | 4.1 | Paradieshofstrasse 1023 | 01.06.25 13:14:11 | 2025-06-01 13:14:11+02:00 |
| 4536237 | 4536237 | 29 | 12:38:37 | 01.06.25 | 1 | 2.1 | Paradieshofstrasse 1023 | 01.06.25 12:38:37 | 2025-06-01 12:38:37+02:00 |
| 4536236 | 4536236 | 18 | 11:02:45 | 01.06.25 | 1 | 2.5 | Paradieshofstrasse 1023 | 01.06.25 11:02:45 | 2025-06-01 11:02:45+02:00 |
| 4536235 | 4536235 | 17 | 10:01:13 | 01.06.25 | 1 | 4.1 | Paradieshofstrasse 1023 | 01.06.25 10:01:13 | 2025-06-01 10:01:13+02:00 |
| 4536234 | 4536234 | 30 | 05:49:11 | 01.06.25 | 1 | 4.1 | Paradieshofstrasse 1023 | 01.06.25 05:49:11 | 2025-06-01 05:49:11+02:00 |
| 4536233 | 4536233 | 29 | 23:31:58 | 31.05.25 | 1 | 4.1 | Paradieshofstrasse 1023 | 31.05.25 23:31:58 | 2025-05-31 23:31:58+02:00 |
| 4536232 | 4536232 | 20 | 22:28:13 | 31.05.25 | 1 | 4.1 | Paradieshofstrasse 1023 | 31.05.25 22:28:13 | 2025-05-31 22:28:13+02:00 |
| 4536231 | 4536231 | 21 | 22:28:12 | 31.05.25 | 1 | 4.1 | Paradieshofstrasse 1023 | 31.05.25 22:28:12 | 2025-05-31 22:28:12+02:00 |
| 4536230 | 4536230 | 23 | 22:26:51 | 31.05.25 | 1 | 4.1 | Paradieshofstrasse 1023 | 31.05.25 22:26:51 | 2025-05-31 22:26:51+02:00 |
| 4536229 | 4536229 | 20 | 20:58:02 | 31.05.25 | 1 | 0.7 | Paradieshofstrasse 1023 | 31.05.25 20:58:02 | 2025-05-31 20:58:02+02:00 |
| 4536228 | 4536228 | 28 | 19:19:48 | 31.05.25 | 1 | 4.1 | Paradieshofstrasse 1023 | 31.05.25 19:19:48 | 2025-05-31 19:19:48+02:00 |
| 4536227 | 4536227 | 28 | 19:19:47 | 31.05.25 | 1 | 1.0 | Paradieshofstrasse 1023 | 31.05.25 19:19:47 | 2025-05-31 19:19:47+02:00 |
| 4536226 | 4536226 | 25 | 18:18:18 | 31.05.25 | 1 | 4.0 | Paradieshofstrasse 1023 | 31.05.25 18:18:18 | 2025-05-31 18:18:18+02:00 |
| 4536225 | 4536225 | 27 | 17:46:01 | 31.05.25 | 1 | 3.6 | Paradieshofstrasse 1023 | 31.05.25 17:46:01 | 2025-05-31 17:46:01+02:00 |
| 4536224 | 4536224 | 5 | 17:13:00 | 31.05.25 | 1 | 4.0 | Paradieshofstrasse 1023 | 31.05.25 17:13:00 | 2025-05-31 17:13:00+02:00 |
| 4536223 | 4536223 | 7 | 17:12:58 | 31.05.25 | 1 | 4.0 | Paradieshofstrasse 1023 | 31.05.25 17:12:58 | 2025-05-31 17:12:58+02:00 |
| 4536222 | 4536222 | 28 | 17:12:14 | 31.05.25 | 1 | 4.6 | Paradieshofstrasse 1023 | 31.05.25 17:12:14 | 2025-05-31 17:12:14+02:00 |
| 4536221 | 4536221 | 33 | 17:11:46 | 31.05.25 | 1 | 4.3 | Paradieshofstrasse 1023 | 31.05.25 17:11:46 | 2025-05-31 17:11:46+02:00 |
| 4536220 | 4536220 | 29 | 17:07:28 | 31.05.25 | 1 | 4.5 | Paradieshofstrasse 1023 | 31.05.25 17:07:28 | 2025-05-31 17:07:28+02:00 |
| 4536219 | 4536219 | 26 | 17:04:49 | 31.05.25 | 1 | 4.1 | Paradieshofstrasse 1023 | 31.05.25 17:04:49 | 2025-05-31 17:04:49+02:00 |
| 4536218 | 4536218 | 24 | 17:02:03 | 31.05.25 | 1 | 4.3 | Paradieshofstrasse 1023 | 31.05.25 17:02:03 | 2025-05-31 17:02:03+02:00 |
| 4536217 | 4536217 | 18 | 16:59:56 | 31.05.25 | 1 | 2.3 | Paradieshofstrasse 1023 | 31.05.25 16:59:56 | 2025-05-31 16:59:56+02:00 |
| 4536216 | 4536216 | 17 | 16:52:45 | 31.05.25 | 1 | 4.0 | Paradieshofstrasse 1023 | 31.05.25 16:52:45 | 2025-05-31 16:52:45+02:00 |
| 4536215 | 4536215 | 44 | 16:50:03 | 31.05.25 | 1 | 1.5 | Paradieshofstrasse 1023 | 31.05.25 16:50:03 | 2025-05-31 16:50:03+02:00 |
| 4536214 | 4536214 | 32 | 16:46:36 | 31.05.25 | 1 | 4.2 | Paradieshofstrasse 1023 | 31.05.25 16:46:36 | 2025-05-31 16:46:36+02:00 |
| 4536213 | 4536213 | 14 | 16:46:01 | 31.05.25 | 1 | 4.0 | Paradieshofstrasse 1023 | 31.05.25 16:46:01 | 2025-05-31 16:46:01+02:00 |
| 4536212 | 4536212 | 19 | 16:45:53 | 31.05.25 | 1 | 3.9 | Paradieshofstrasse 1023 | 31.05.25 16:45:53 | 2025-05-31 16:45:53+02:00 |
| 4536211 | 4536211 | 16 | 16:43:04 | 31.05.25 | 1 | 3.4 | Paradieshofstrasse 1023 | 31.05.25 16:43:04 | 2025-05-31 16:43:04+02:00 |
| 4536210 | 4536210 | 19 | 16:41:34 | 31.05.25 | 1 | 1.2 | Paradieshofstrasse 1023 | 31.05.25 16:41:34 | 2025-05-31 16:41:34+02:00 |
| 4536209 | 4536209 | 33 | 16:38:57 | 31.05.25 | 1 | 4.5 | Paradieshofstrasse 1023 | 31.05.25 16:38:57 | 2025-05-31 16:38:57+02:00 |
| 4536208 | 4536208 | 37 | 16:32:09 | 31.05.25 | 1 | 4.4 | Paradieshofstrasse 1023 | 31.05.25 16:32:09 | 2025-05-31 16:32:09+02:00 |
| 4536207 | 4536207 | 35 | 16:29:49 | 31.05.25 | 1 | 1.9 | Paradieshofstrasse 1023 | 31.05.25 16:29:49 | 2025-05-31 16:29:49+02:00 |
| 4536206 | 4536206 | 23 | 16:20:24 | 31.05.25 | 1 | 4.1 | Paradieshofstrasse 1023 | 31.05.25 16:20:24 | 2025-05-31 16:20:24+02:00 |
| 4536205 | 4536205 | 27 | 16:15:59 | 31.05.25 | 1 | 3.9 | Paradieshofstrasse 1023 | 31.05.25 16:15:59 | 2025-05-31 16:15:59+02:00 |
| 4536204 | 4536204 | 17 | 16:10:03 | 31.05.25 | 1 | 3.9 | Paradieshofstrasse 1023 | 31.05.25 16:10:03 | 2025-05-31 16:10:03+02:00 |
| 4536203 | 4536203 | 8 | 16:05:48 | 31.05.25 | 1 | 3.9 | Paradieshofstrasse 1023 | 31.05.25 16:05:48 | 2025-05-31 16:05:48+02:00 |
| 4536202 | 4536202 | 21 | 16:04:22 | 31.05.25 | 1 | 4.0 | Paradieshofstrasse 1023 | 31.05.25 16:04:22 | 2025-05-31 16:04:22+02:00 |
| 4536201 | 4536201 | 28 | 16:00:55 | 31.05.25 | 1 | 5.5 | Paradieshofstrasse 1023 | 31.05.25 16:00:55 | 2025-05-31 16:00:55+02:00 |
| 4536200 | 4536200 | 31 | 15:46:33 | 31.05.25 | 1 | 1.5 | Paradieshofstrasse 1023 | 31.05.25 15:46:33 | 2025-05-31 15:46:33+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");