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 = 1007 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 ▲ |
|---|---|---|---|---|---|---|---|---|---|
| 5074747 | 5074747 | 30 | 06:14:55 | 21.04.25 | 1 | 16.1 | Fasanenstrasse 1007 | 21.04.25 06:14:55 | 2025-04-21 06:14:55+02:00 |
| 5074746 | 5074746 | 39 | 06:13:58 | 21.04.25 | 1 | 1.8 | Fasanenstrasse 1007 | 21.04.25 06:13:58 | 2025-04-21 06:13:58+02:00 |
| 5074745 | 5074745 | 56 | 06:10:54 | 21.04.25 | 1 | 1.6 | Fasanenstrasse 1007 | 21.04.25 06:10:54 | 2025-04-21 06:10:54+02:00 |
| 5117395 | 5117395 | 50 | 06:10:23 | 21.04.25 | 2 | 2.2 | Fasanenstrasse 1007 | 21.04.25 06:10:23 | 2025-04-21 06:10:23+02:00 |
| 5074744 | 5074744 | 39 | 06:09:06 | 21.04.25 | 1 | 1.1 | Fasanenstrasse 1007 | 21.04.25 06:09:06 | 2025-04-21 06:09:06+02:00 |
| 5117394 | 5117394 | 45 | 06:08:48 | 21.04.25 | 2 | 1.1 | Fasanenstrasse 1007 | 21.04.25 06:08:48 | 2025-04-21 06:08:48+02:00 |
| 5117393 | 5117393 | 46 | 06:07:38 | 21.04.25 | 2 | 2.1 | Fasanenstrasse 1007 | 21.04.25 06:07:38 | 2025-04-21 06:07:38+02:00 |
| 5117392 | 5117392 | 64 | 06:05:47 | 21.04.25 | 2 | 1.4 | Fasanenstrasse 1007 | 21.04.25 06:05:47 | 2025-04-21 06:05:47+02:00 |
| 5117391 | 5117391 | 39 | 06:04:59 | 21.04.25 | 2 | 2.4 | Fasanenstrasse 1007 | 21.04.25 06:04:59 | 2025-04-21 06:04:59+02:00 |
| 5074743 | 5074743 | 43 | 06:03:19 | 21.04.25 | 1 | 1.1 | Fasanenstrasse 1007 | 21.04.25 06:03:19 | 2025-04-21 06:03:19+02:00 |
| 5074742 | 5074742 | 39 | 06:02:27 | 21.04.25 | 1 | 9.6 | Fasanenstrasse 1007 | 21.04.25 06:02:27 | 2025-04-21 06:02:27+02:00 |
| 5117390 | 5117390 | 54 | 05:59:31 | 21.04.25 | 2 | 1.2 | Fasanenstrasse 1007 | 21.04.25 05:59:31 | 2025-04-21 05:59:31+02:00 |
| 5074741 | 5074741 | 48 | 05:58:56 | 21.04.25 | 1 | 1.2 | Fasanenstrasse 1007 | 21.04.25 05:58:56 | 2025-04-21 05:58:56+02:00 |
| 5117389 | 5117389 | 46 | 05:58:36 | 21.04.25 | 2 | 1.3 | Fasanenstrasse 1007 | 21.04.25 05:58:36 | 2025-04-21 05:58:36+02:00 |
| 5074740 | 5074740 | 38 | 05:56:59 | 21.04.25 | 1 | 1.6 | Fasanenstrasse 1007 | 21.04.25 05:56:59 | 2025-04-21 05:56:59+02:00 |
| 5117388 | 5117388 | 50 | 05:53:07 | 21.04.25 | 2 | 3.1 | Fasanenstrasse 1007 | 21.04.25 05:53:07 | 2025-04-21 05:53:07+02:00 |
| 5117387 | 5117387 | 47 | 05:52:31 | 21.04.25 | 2 | 1.9 | Fasanenstrasse 1007 | 21.04.25 05:52:31 | 2025-04-21 05:52:31+02:00 |
| 5117386 | 5117386 | 46 | 05:48:58 | 21.04.25 | 2 | 2.6 | Fasanenstrasse 1007 | 21.04.25 05:48:58 | 2025-04-21 05:48:58+02:00 |
| 5074739 | 5074739 | 52 | 05:48:39 | 21.04.25 | 1 | 2.2 | Fasanenstrasse 1007 | 21.04.25 05:48:39 | 2025-04-21 05:48:39+02:00 |
| 5117385 | 5117385 | 42 | 05:47:40 | 21.04.25 | 2 | 2.5 | Fasanenstrasse 1007 | 21.04.25 05:47:40 | 2025-04-21 05:47:40+02:00 |
| 5074738 | 5074738 | 48 | 05:46:40 | 21.04.25 | 1 | 0.9 | Fasanenstrasse 1007 | 21.04.25 05:46:40 | 2025-04-21 05:46:40+02:00 |
| 5074737 | 5074737 | 33 | 05:46:09 | 21.04.25 | 1 | 1.3 | Fasanenstrasse 1007 | 21.04.25 05:46:09 | 2025-04-21 05:46:09+02:00 |
| 5074736 | 5074736 | 52 | 05:42:48 | 21.04.25 | 1 | 1.9 | Fasanenstrasse 1007 | 21.04.25 05:42:48 | 2025-04-21 05:42:48+02:00 |
| 5074735 | 5074735 | 46 | 05:42:19 | 21.04.25 | 1 | 3.1 | Fasanenstrasse 1007 | 21.04.25 05:42:19 | 2025-04-21 05:42:19+02:00 |
| 5117384 | 5117384 | 59 | 05:42:09 | 21.04.25 | 2 | 2.2 | Fasanenstrasse 1007 | 21.04.25 05:42:09 | 2025-04-21 05:42:09+02:00 |
| 5074734 | 5074734 | 32 | 05:39:24 | 21.04.25 | 1 | 1.1 | Fasanenstrasse 1007 | 21.04.25 05:39:24 | 2025-04-21 05:39:24+02:00 |
| 5117383 | 5117383 | 50 | 05:38:27 | 21.04.25 | 2 | 2.5 | Fasanenstrasse 1007 | 21.04.25 05:38:27 | 2025-04-21 05:38:27+02:00 |
| 5074733 | 5074733 | 49 | 05:36:44 | 21.04.25 | 1 | 2.4 | Fasanenstrasse 1007 | 21.04.25 05:36:44 | 2025-04-21 05:36:44+02:00 |
| 5074732 | 5074732 | 45 | 05:35:50 | 21.04.25 | 1 | 1.3 | Fasanenstrasse 1007 | 21.04.25 05:35:50 | 2025-04-21 05:35:50+02:00 |
| 5074731 | 5074731 | 48 | 05:35:45 | 21.04.25 | 1 | 0.9 | Fasanenstrasse 1007 | 21.04.25 05:35:45 | 2025-04-21 05:35:45+02:00 |
| 5074730 | 5074730 | 49 | 05:34:59 | 21.04.25 | 1 | 1.8 | Fasanenstrasse 1007 | 21.04.25 05:34:59 | 2025-04-21 05:34:59+02:00 |
| 5074729 | 5074729 | 42 | 05:34:56 | 21.04.25 | 1 | 1.4 | Fasanenstrasse 1007 | 21.04.25 05:34:56 | 2025-04-21 05:34:56+02:00 |
| 5074728 | 5074728 | 53 | 05:30:15 | 21.04.25 | 1 | 0.8 | Fasanenstrasse 1007 | 21.04.25 05:30:15 | 2025-04-21 05:30:15+02:00 |
| 5117382 | 5117382 | 64 | 05:21:07 | 21.04.25 | 2 | 1.5 | Fasanenstrasse 1007 | 21.04.25 05:21:07 | 2025-04-21 05:21:07+02:00 |
| 5074727 | 5074727 | 37 | 05:20:37 | 21.04.25 | 1 | 1.0 | Fasanenstrasse 1007 | 21.04.25 05:20:37 | 2025-04-21 05:20:37+02:00 |
| 5117381 | 5117381 | 45 | 05:17:57 | 21.04.25 | 2 | 2.3 | Fasanenstrasse 1007 | 21.04.25 05:17:57 | 2025-04-21 05:17:57+02:00 |
| 5117380 | 5117380 | 44 | 05:17:37 | 21.04.25 | 2 | 2.3 | Fasanenstrasse 1007 | 21.04.25 05:17:37 | 2025-04-21 05:17:37+02:00 |
| 5117379 | 5117379 | 43 | 05:16:29 | 21.04.25 | 2 | 2.0 | Fasanenstrasse 1007 | 21.04.25 05:16:29 | 2025-04-21 05:16:29+02:00 |
| 5074726 | 5074726 | 42 | 05:15:33 | 21.04.25 | 1 | 0.9 | Fasanenstrasse 1007 | 21.04.25 05:15:33 | 2025-04-21 05:15:33+02:00 |
| 5117378 | 5117378 | 43 | 05:14:14 | 21.04.25 | 2 | 1.7 | Fasanenstrasse 1007 | 21.04.25 05:14:14 | 2025-04-21 05:14:14+02:00 |
| 5117377 | 5117377 | 48 | 05:12:07 | 21.04.25 | 2 | 1.8 | Fasanenstrasse 1007 | 21.04.25 05:12:07 | 2025-04-21 05:12:07+02:00 |
| 5117376 | 5117376 | 35 | 05:11:30 | 21.04.25 | 2 | 2.8 | Fasanenstrasse 1007 | 21.04.25 05:11:30 | 2025-04-21 05:11:30+02:00 |
| 5074725 | 5074725 | 40 | 05:08:39 | 21.04.25 | 1 | 2.6 | Fasanenstrasse 1007 | 21.04.25 05:08:39 | 2025-04-21 05:08:39+02:00 |
| 5117375 | 5117375 | 39 | 05:08:25 | 21.04.25 | 2 | 2.3 | Fasanenstrasse 1007 | 21.04.25 05:08:25 | 2025-04-21 05:08:25+02:00 |
| 5117374 | 5117374 | 45 | 05:07:23 | 21.04.25 | 2 | 3.3 | Fasanenstrasse 1007 | 21.04.25 05:07:23 | 2025-04-21 05:07:23+02:00 |
| 5117373 | 5117373 | 54 | 05:05:05 | 21.04.25 | 2 | 1.2 | Fasanenstrasse 1007 | 21.04.25 05:05:05 | 2025-04-21 05:05:05+02:00 |
| 5074724 | 5074724 | 38 | 05:04:49 | 21.04.25 | 1 | 9.8 | Fasanenstrasse 1007 | 21.04.25 05:04:49 | 2025-04-21 05:04:49+02:00 |
| 5117372 | 5117372 | 50 | 04:58:38 | 21.04.25 | 2 | 3.0 | Fasanenstrasse 1007 | 21.04.25 04:58:38 | 2025-04-21 04:58:38+02:00 |
| 5117371 | 5117371 | 51 | 04:58:13 | 21.04.25 | 2 | 2.5 | Fasanenstrasse 1007 | 21.04.25 04:58:13 | 2025-04-21 04:58:13+02:00 |
| 5117370 | 5117370 | 45 | 04:58:10 | 21.04.25 | 2 | 3.0 | Fasanenstrasse 1007 | 21.04.25 04:58:10 | 2025-04-21 04:58:10+02:00 |
| 5117369 | 5117369 | 59 | 04:56:17 | 21.04.25 | 2 | 1.9 | Fasanenstrasse 1007 | 21.04.25 04:56:17 | 2025-04-21 04:56:17+02:00 |
| 5074723 | 5074723 | 51 | 04:55:46 | 21.04.25 | 1 | 2.0 | Fasanenstrasse 1007 | 21.04.25 04:55:46 | 2025-04-21 04:55:46+02:00 |
| 5074722 | 5074722 | 45 | 04:53:40 | 21.04.25 | 1 | 1.2 | Fasanenstrasse 1007 | 21.04.25 04:53:40 | 2025-04-21 04:53:40+02:00 |
| 5117368 | 5117368 | 43 | 04:53:38 | 21.04.25 | 2 | 2.5 | Fasanenstrasse 1007 | 21.04.25 04:53:38 | 2025-04-21 04:53:38+02:00 |
| 5074721 | 5074721 | 46 | 04:53:25 | 21.04.25 | 1 | 1.8 | Fasanenstrasse 1007 | 21.04.25 04:53:25 | 2025-04-21 04:53:25+02:00 |
| 5074720 | 5074720 | 56 | 04:50:20 | 21.04.25 | 1 | 2.2 | Fasanenstrasse 1007 | 21.04.25 04:50:20 | 2025-04-21 04:50:20+02:00 |
| 5074719 | 5074719 | 43 | 04:49:57 | 21.04.25 | 1 | 1.0 | Fasanenstrasse 1007 | 21.04.25 04:49:57 | 2025-04-21 04:49:57+02:00 |
| 5117367 | 5117367 | 53 | 04:47:43 | 21.04.25 | 2 | 2.1 | Fasanenstrasse 1007 | 21.04.25 04:47:43 | 2025-04-21 04:47:43+02:00 |
| 5074718 | 5074718 | 50 | 04:45:36 | 21.04.25 | 1 | 1.4 | Fasanenstrasse 1007 | 21.04.25 04:45:36 | 2025-04-21 04:45:36+02:00 |
| 5074717 | 5074717 | 44 | 04:45:34 | 21.04.25 | 1 | 1.1 | Fasanenstrasse 1007 | 21.04.25 04:45:34 | 2025-04-21 04:45:34+02:00 |
| 5074716 | 5074716 | 52 | 04:45:15 | 21.04.25 | 1 | 1.0 | Fasanenstrasse 1007 | 21.04.25 04:45:15 | 2025-04-21 04:45:15+02:00 |
| 5074715 | 5074715 | 45 | 04:44:08 | 21.04.25 | 1 | 1.5 | Fasanenstrasse 1007 | 21.04.25 04:44:08 | 2025-04-21 04:44:08+02:00 |
| 5117366 | 5117366 | 35 | 04:42:08 | 21.04.25 | 2 | 2.9 | Fasanenstrasse 1007 | 21.04.25 04:42:08 | 2025-04-21 04:42:08+02:00 |
| 5117365 | 5117365 | 47 | 04:41:11 | 21.04.25 | 2 | 2.0 | Fasanenstrasse 1007 | 21.04.25 04:41:11 | 2025-04-21 04:41:11+02:00 |
| 5074714 | 5074714 | 59 | 04:40:38 | 21.04.25 | 1 | 0.9 | Fasanenstrasse 1007 | 21.04.25 04:40:38 | 2025-04-21 04:40:38+02:00 |
| 5074713 | 5074713 | 47 | 04:36:44 | 21.04.25 | 1 | 1.0 | Fasanenstrasse 1007 | 21.04.25 04:36:44 | 2025-04-21 04:36:44+02:00 |
| 5074712 | 5074712 | 40 | 04:36:03 | 21.04.25 | 1 | 1.4 | Fasanenstrasse 1007 | 21.04.25 04:36:03 | 2025-04-21 04:36:03+02:00 |
| 5117364 | 5117364 | 47 | 04:34:46 | 21.04.25 | 2 | 3.4 | Fasanenstrasse 1007 | 21.04.25 04:34:46 | 2025-04-21 04:34:46+02:00 |
| 5117363 | 5117363 | 41 | 04:34:20 | 21.04.25 | 2 | 1.7 | Fasanenstrasse 1007 | 21.04.25 04:34:20 | 2025-04-21 04:34:20+02:00 |
| 5074711 | 5074711 | 50 | 04:33:53 | 21.04.25 | 1 | 1.9 | Fasanenstrasse 1007 | 21.04.25 04:33:53 | 2025-04-21 04:33:53+02:00 |
| 5074710 | 5074710 | 29 | 04:31:58 | 21.04.25 | 1 | 3.0 | Fasanenstrasse 1007 | 21.04.25 04:31:58 | 2025-04-21 04:31:58+02:00 |
| 5074709 | 5074709 | 50 | 04:31:21 | 21.04.25 | 1 | 1.7 | Fasanenstrasse 1007 | 21.04.25 04:31:21 | 2025-04-21 04:31:21+02:00 |
| 5074708 | 5074708 | 48 | 04:30:30 | 21.04.25 | 1 | 1.7 | Fasanenstrasse 1007 | 21.04.25 04:30:30 | 2025-04-21 04:30:30+02:00 |
| 5117362 | 5117362 | 64 | 04:27:57 | 21.04.25 | 2 | 1.9 | Fasanenstrasse 1007 | 21.04.25 04:27:57 | 2025-04-21 04:27:57+02:00 |
| 5074707 | 5074707 | 50 | 04:27:04 | 21.04.25 | 1 | 1.0 | Fasanenstrasse 1007 | 21.04.25 04:27:04 | 2025-04-21 04:27:04+02:00 |
| 5117361 | 5117361 | 45 | 04:25:33 | 21.04.25 | 2 | 0.9 | Fasanenstrasse 1007 | 21.04.25 04:25:33 | 2025-04-21 04:25:33+02:00 |
| 5117360 | 5117360 | 44 | 04:24:24 | 21.04.25 | 2 | 2.0 | Fasanenstrasse 1007 | 21.04.25 04:24:24 | 2025-04-21 04:24:24+02:00 |
| 5117359 | 5117359 | 51 | 04:20:55 | 21.04.25 | 2 | 1.8 | Fasanenstrasse 1007 | 21.04.25 04:20:55 | 2025-04-21 04:20:55+02:00 |
| 5117358 | 5117358 | 46 | 04:20:41 | 21.04.25 | 2 | 2.6 | Fasanenstrasse 1007 | 21.04.25 04:20:41 | 2025-04-21 04:20:41+02:00 |
| 5117357 | 5117357 | 48 | 04:20:38 | 21.04.25 | 2 | 2.6 | Fasanenstrasse 1007 | 21.04.25 04:20:38 | 2025-04-21 04:20:38+02:00 |
| 5117356 | 5117356 | 56 | 04:20:01 | 21.04.25 | 2 | 2.6 | Fasanenstrasse 1007 | 21.04.25 04:20:01 | 2025-04-21 04:20:01+02:00 |
| 5117355 | 5117355 | 56 | 04:19:59 | 21.04.25 | 2 | 2.2 | Fasanenstrasse 1007 | 21.04.25 04:19:59 | 2025-04-21 04:19:59+02:00 |
| 5074706 | 5074706 | 36 | 04:19:18 | 21.04.25 | 1 | 1.5 | Fasanenstrasse 1007 | 21.04.25 04:19:18 | 2025-04-21 04:19:18+02:00 |
| 5117354 | 5117354 | 29 | 04:17:44 | 21.04.25 | 2 | 2.5 | Fasanenstrasse 1007 | 21.04.25 04:17:44 | 2025-04-21 04:17:44+02:00 |
| 5074705 | 5074705 | 41 | 04:16:59 | 21.04.25 | 1 | 1.1 | Fasanenstrasse 1007 | 21.04.25 04:16:59 | 2025-04-21 04:16:59+02:00 |
| 5074704 | 5074704 | 47 | 04:16:53 | 21.04.25 | 1 | 0.9 | Fasanenstrasse 1007 | 21.04.25 04:16:53 | 2025-04-21 04:16:53+02:00 |
| 5117353 | 5117353 | 48 | 04:16:30 | 21.04.25 | 2 | 2.1 | Fasanenstrasse 1007 | 21.04.25 04:16:30 | 2025-04-21 04:16:30+02:00 |
| 5074703 | 5074703 | 41 | 04:15:07 | 21.04.25 | 1 | 2.2 | Fasanenstrasse 1007 | 21.04.25 04:15:07 | 2025-04-21 04:15:07+02:00 |
| 5117352 | 5117352 | 47 | 04:12:29 | 21.04.25 | 2 | 2.5 | Fasanenstrasse 1007 | 21.04.25 04:12:29 | 2025-04-21 04:12:29+02:00 |
| 5117351 | 5117351 | 47 | 04:10:27 | 21.04.25 | 2 | 1.4 | Fasanenstrasse 1007 | 21.04.25 04:10:27 | 2025-04-21 04:10:27+02:00 |
| 5074702 | 5074702 | 40 | 04:06:25 | 21.04.25 | 1 | 2.0 | Fasanenstrasse 1007 | 21.04.25 04:06:25 | 2025-04-21 04:06:25+02:00 |
| 5117350 | 5117350 | 45 | 03:56:38 | 21.04.25 | 2 | 0.8 | Fasanenstrasse 1007 | 21.04.25 03:56:38 | 2025-04-21 03:56:38+02:00 |
| 5117349 | 5117349 | 51 | 03:56:33 | 21.04.25 | 2 | 1.6 | Fasanenstrasse 1007 | 21.04.25 03:56:33 | 2025-04-21 03:56:33+02:00 |
| 5074701 | 5074701 | 47 | 03:54:19 | 21.04.25 | 1 | 2.1 | Fasanenstrasse 1007 | 21.04.25 03:54:19 | 2025-04-21 03:54:19+02:00 |
| 5117348 | 5117348 | 41 | 03:53:52 | 21.04.25 | 2 | 3.7 | Fasanenstrasse 1007 | 21.04.25 03:53:52 | 2025-04-21 03:53:52+02:00 |
| 5074700 | 5074700 | 45 | 03:53:11 | 21.04.25 | 1 | 1.6 | Fasanenstrasse 1007 | 21.04.25 03:53:11 | 2025-04-21 03:53:11+02:00 |
| 5117347 | 5117347 | 48 | 03:52:19 | 21.04.25 | 2 | 2.4 | Fasanenstrasse 1007 | 21.04.25 03:52:19 | 2025-04-21 03:52:19+02:00 |
| 5074699 | 5074699 | 49 | 03:51:22 | 21.04.25 | 1 | 1.7 | Fasanenstrasse 1007 | 21.04.25 03:51:22 | 2025-04-21 03:51:22+02:00 |
| 5074698 | 5074698 | 48 | 03:50:24 | 21.04.25 | 1 | 2.1 | Fasanenstrasse 1007 | 21.04.25 03:50:24 | 2025-04-21 03:50:24+02:00 |
| 5074697 | 5074697 | 50 | 03:50:17 | 21.04.25 | 1 | 1.4 | Fasanenstrasse 1007 | 21.04.25 03:50:17 | 2025-04-21 03:50:17+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");