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
6,266 rows where Messung-ID = 1084 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 ▲ |
|---|---|---|---|---|---|---|---|---|---|
| 680603 | 680603 | 22 | 07:03:43 | 03.10.25 | 2 | 3.7 | Grienstrasse 1084 | 03.10.25 07:03:43 | 2025-10-03 07:03:43+02:00 |
| 680602 | 680602 | 23 | 07:00:03 | 03.10.25 | 2 | 4.7 | Grienstrasse 1084 | 03.10.25 07:00:03 | 2025-10-03 07:00:03+02:00 |
| 677838 | 677838 | 25 | 06:58:54 | 03.10.25 | 1 | 7.1 | Grienstrasse 1084 | 03.10.25 06:58:54 | 2025-10-03 06:58:54+02:00 |
| 677837 | 677837 | 21 | 06:40:36 | 03.10.25 | 1 | 3.7 | Grienstrasse 1084 | 03.10.25 06:40:36 | 2025-10-03 06:40:36+02:00 |
| 677836 | 677836 | 17 | 06:30:58 | 03.10.25 | 1 | 5.9 | Grienstrasse 1084 | 03.10.25 06:30:58 | 2025-10-03 06:30:58+02:00 |
| 677835 | 677835 | 19 | 06:29:02 | 03.10.25 | 1 | 0.6 | Grienstrasse 1084 | 03.10.25 06:29:02 | 2025-10-03 06:29:02+02:00 |
| 680601 | 680601 | 19 | 06:19:44 | 03.10.25 | 2 | 3.8 | Grienstrasse 1084 | 03.10.25 06:19:44 | 2025-10-03 06:19:44+02:00 |
| 680600 | 680600 | 18 | 06:12:10 | 03.10.25 | 2 | 3.7 | Grienstrasse 1084 | 03.10.25 06:12:10 | 2025-10-03 06:12:10+02:00 |
| 680599 | 680599 | 21 | 06:09:52 | 03.10.25 | 2 | 3.6 | Grienstrasse 1084 | 03.10.25 06:09:52 | 2025-10-03 06:09:52+02:00 |
| 680598 | 680598 | 24 | 06:08:10 | 03.10.25 | 2 | 6.1 | Grienstrasse 1084 | 03.10.25 06:08:10 | 2025-10-03 06:08:10+02:00 |
| 677834 | 677834 | 21 | 06:08:00 | 03.10.25 | 1 | 7.6 | Grienstrasse 1084 | 03.10.25 06:08:00 | 2025-10-03 06:08:00+02:00 |
| 677833 | 677833 | 20 | 06:07:57 | 03.10.25 | 1 | 2.0 | Grienstrasse 1084 | 03.10.25 06:07:57 | 2025-10-03 06:07:57+02:00 |
| 677832 | 677832 | 41 | 06:07:49 | 03.10.25 | 1 | 5.2 | Grienstrasse 1084 | 03.10.25 06:07:49 | 2025-10-03 06:07:49+02:00 |
| 677831 | 677831 | 26 | 06:06:38 | 03.10.25 | 1 | 2.1 | Grienstrasse 1084 | 03.10.25 06:06:38 | 2025-10-03 06:06:38+02:00 |
| 680597 | 680597 | 29 | 06:03:52 | 03.10.25 | 2 | 3.8 | Grienstrasse 1084 | 03.10.25 06:03:52 | 2025-10-03 06:03:52+02:00 |
| 677830 | 677830 | 15 | 05:10:50 | 03.10.25 | 1 | 0.8 | Grienstrasse 1084 | 03.10.25 05:10:50 | 2025-10-03 05:10:50+02:00 |
| 677829 | 677829 | 27 | 02:59:16 | 03.10.25 | 1 | 4.1 | Grienstrasse 1084 | 03.10.25 02:59:16 | 2025-10-03 02:59:16+02:00 |
| 677828 | 677828 | 21 | 02:57:11 | 03.10.25 | 1 | 7.2 | Grienstrasse 1084 | 03.10.25 02:57:11 | 2025-10-03 02:57:11+02:00 |
| 677827 | 677827 | 20 | 02:04:54 | 03.10.25 | 1 | 8.5 | Grienstrasse 1084 | 03.10.25 02:04:54 | 2025-10-03 02:04:54+02:00 |
| 677826 | 677826 | 26 | 02:01:53 | 03.10.25 | 1 | 3.0 | Grienstrasse 1084 | 03.10.25 02:01:53 | 2025-10-03 02:01:53+02:00 |
| 680596 | 680596 | 23 | 01:59:18 | 03.10.25 | 2 | 3.2 | Grienstrasse 1084 | 03.10.25 01:59:18 | 2025-10-03 01:59:18+02:00 |
| 677825 | 677825 | 33 | 01:24:30 | 03.10.25 | 1 | 5.1 | Grienstrasse 1084 | 03.10.25 01:24:30 | 2025-10-03 01:24:30+02:00 |
| 677824 | 677824 | 30 | 01:11:14 | 03.10.25 | 1 | 4.1 | Grienstrasse 1084 | 03.10.25 01:11:14 | 2025-10-03 01:11:14+02:00 |
| 677823 | 677823 | 22 | 01:03:02 | 03.10.25 | 1 | 5.0 | Grienstrasse 1084 | 03.10.25 01:03:02 | 2025-10-03 01:03:02+02:00 |
| 680595 | 680595 | 8 | 00:52:13 | 03.10.25 | 2 | 4.7 | Grienstrasse 1084 | 03.10.25 00:52:13 | 2025-10-03 00:52:13+02:00 |
| 677822 | 677822 | 19 | 00:43:38 | 03.10.25 | 1 | 5.8 | Grienstrasse 1084 | 03.10.25 00:43:38 | 2025-10-03 00:43:38+02:00 |
| 680594 | 680594 | 17 | 00:32:07 | 03.10.25 | 2 | 4.6 | Grienstrasse 1084 | 03.10.25 00:32:07 | 2025-10-03 00:32:07+02:00 |
| 680592 | 680592 | 18 | 00:32:06 | 03.10.25 | 2 | 4.6 | Grienstrasse 1084 | 03.10.25 00:32:06 | 2025-10-03 00:32:06+02:00 |
| 680593 | 680593 | 18 | 00:32:06 | 03.10.25 | 2 | 4.6 | Grienstrasse 1084 | 03.10.25 00:32:06 | 2025-10-03 00:32:06+02:00 |
| 677821 | 677821 | 20 | 00:31:28 | 03.10.25 | 1 | 8.2 | Grienstrasse 1084 | 03.10.25 00:31:28 | 2025-10-03 00:31:28+02:00 |
| 677820 | 677820 | 21 | 00:30:11 | 03.10.25 | 1 | 4.9 | Grienstrasse 1084 | 03.10.25 00:30:11 | 2025-10-03 00:30:11+02:00 |
| 680591 | 680591 | 20 | 00:17:47 | 03.10.25 | 2 | 4.0 | Grienstrasse 1084 | 03.10.25 00:17:47 | 2025-10-03 00:17:47+02:00 |
| 677819 | 677819 | 21 | 00:15:09 | 03.10.25 | 1 | 8.0 | Grienstrasse 1084 | 03.10.25 00:15:09 | 2025-10-03 00:15:09+02:00 |
| 680590 | 680590 | 7 | 23:57:13 | 02.10.25 | 2 | 4.6 | Grienstrasse 1084 | 02.10.25 23:57:13 | 2025-10-02 23:57:13+02:00 |
| 677818 | 677818 | 29 | 23:44:56 | 02.10.25 | 1 | 4.6 | Grienstrasse 1084 | 02.10.25 23:44:56 | 2025-10-02 23:44:56+02:00 |
| 680589 | 680589 | 26 | 23:20:15 | 02.10.25 | 2 | 4.4 | Grienstrasse 1084 | 02.10.25 23:20:15 | 2025-10-02 23:20:15+02:00 |
| 680588 | 680588 | 24 | 23:06:45 | 02.10.25 | 2 | 3.6 | Grienstrasse 1084 | 02.10.25 23:06:45 | 2025-10-02 23:06:45+02:00 |
| 677817 | 677817 | 20 | 22:58:39 | 02.10.25 | 1 | 7.8 | Grienstrasse 1084 | 02.10.25 22:58:39 | 2025-10-02 22:58:39+02:00 |
| 677816 | 677816 | 22 | 22:54:13 | 02.10.25 | 1 | 9.1 | Grienstrasse 1084 | 02.10.25 22:54:13 | 2025-10-02 22:54:13+02:00 |
| 677815 | 677815 | 19 | 22:49:53 | 02.10.25 | 1 | 0.8 | Grienstrasse 1084 | 02.10.25 22:49:53 | 2025-10-02 22:49:53+02:00 |
| 677814 | 677814 | 23 | 22:45:55 | 02.10.25 | 1 | 6.6 | Grienstrasse 1084 | 02.10.25 22:45:55 | 2025-10-02 22:45:55+02:00 |
| 677813 | 677813 | 19 | 22:41:56 | 02.10.25 | 1 | 7.2 | Grienstrasse 1084 | 02.10.25 22:41:56 | 2025-10-02 22:41:56+02:00 |
| 680587 | 680587 | 9 | 22:27:44 | 02.10.25 | 2 | 4.6 | Grienstrasse 1084 | 02.10.25 22:27:44 | 2025-10-02 22:27:44+02:00 |
| 677812 | 677812 | 25 | 22:13:22 | 02.10.25 | 1 | 4.0 | Grienstrasse 1084 | 02.10.25 22:13:22 | 2025-10-02 22:13:22+02:00 |
| 680586 | 680586 | 18 | 22:04:35 | 02.10.25 | 2 | 3.7 | Grienstrasse 1084 | 02.10.25 22:04:35 | 2025-10-02 22:04:35+02:00 |
| 680585 | 680585 | 24 | 22:02:32 | 02.10.25 | 2 | 4.0 | Grienstrasse 1084 | 02.10.25 22:02:32 | 2025-10-02 22:02:32+02:00 |
| 680584 | 680584 | 21 | 21:58:07 | 02.10.25 | 2 | 3.8 | Grienstrasse 1084 | 02.10.25 21:58:07 | 2025-10-02 21:58:07+02:00 |
| 677811 | 677811 | 24 | 21:54:02 | 02.10.25 | 1 | 4.9 | Grienstrasse 1084 | 02.10.25 21:54:02 | 2025-10-02 21:54:02+02:00 |
| 677810 | 677810 | 16 | 21:53:42 | 02.10.25 | 1 | 6.3 | Grienstrasse 1084 | 02.10.25 21:53:42 | 2025-10-02 21:53:42+02:00 |
| 677809 | 677809 | 22 | 21:50:48 | 02.10.25 | 1 | 4.9 | Grienstrasse 1084 | 02.10.25 21:50:48 | 2025-10-02 21:50:48+02:00 |
| 680582 | 680582 | 17 | 21:50:36 | 02.10.25 | 2 | 4.5 | Grienstrasse 1084 | 02.10.25 21:50:36 | 2025-10-02 21:50:36+02:00 |
| 680583 | 680583 | 18 | 21:50:36 | 02.10.25 | 2 | 4.5 | Grienstrasse 1084 | 02.10.25 21:50:36 | 2025-10-02 21:50:36+02:00 |
| 680581 | 680581 | 10 | 21:50:14 | 02.10.25 | 2 | 4.5 | Grienstrasse 1084 | 02.10.25 21:50:14 | 2025-10-02 21:50:14+02:00 |
| 680580 | 680580 | 10 | 21:50:13 | 02.10.25 | 2 | 9.5 | Grienstrasse 1084 | 02.10.25 21:50:13 | 2025-10-02 21:50:13+02:00 |
| 677808 | 677808 | 18 | 21:49:42 | 02.10.25 | 1 | 0.8 | Grienstrasse 1084 | 02.10.25 21:49:42 | 2025-10-02 21:49:42+02:00 |
| 677807 | 677807 | 26 | 21:37:36 | 02.10.25 | 1 | 4.0 | Grienstrasse 1084 | 02.10.25 21:37:36 | 2025-10-02 21:37:36+02:00 |
| 677806 | 677806 | 28 | 21:37:07 | 02.10.25 | 1 | 0.7 | Grienstrasse 1084 | 02.10.25 21:37:07 | 2025-10-02 21:37:07+02:00 |
| 677805 | 677805 | 20 | 21:35:55 | 02.10.25 | 1 | 6.4 | Grienstrasse 1084 | 02.10.25 21:35:55 | 2025-10-02 21:35:55+02:00 |
| 680579 | 680579 | 25 | 21:31:03 | 02.10.25 | 2 | 3.7 | Grienstrasse 1084 | 02.10.25 21:31:03 | 2025-10-02 21:31:03+02:00 |
| 677804 | 677804 | 10 | 21:19:23 | 02.10.25 | 1 | 6.3 | Grienstrasse 1084 | 02.10.25 21:19:23 | 2025-10-02 21:19:23+02:00 |
| 677803 | 677803 | 11 | 21:19:20 | 02.10.25 | 1 | 1.2 | Grienstrasse 1084 | 02.10.25 21:19:20 | 2025-10-02 21:19:20+02:00 |
| 677802 | 677802 | 32 | 21:15:57 | 02.10.25 | 1 | 5.4 | Grienstrasse 1084 | 02.10.25 21:15:57 | 2025-10-02 21:15:57+02:00 |
| 677801 | 677801 | 10 | 21:09:24 | 02.10.25 | 1 | 1.4 | Grienstrasse 1084 | 02.10.25 21:09:24 | 2025-10-02 21:09:24+02:00 |
| 680578 | 680578 | 20 | 21:06:11 | 02.10.25 | 2 | 4.1 | Grienstrasse 1084 | 02.10.25 21:06:11 | 2025-10-02 21:06:11+02:00 |
| 677800 | 677800 | 28 | 21:05:46 | 02.10.25 | 1 | 4.2 | Grienstrasse 1084 | 02.10.25 21:05:46 | 2025-10-02 21:05:46+02:00 |
| 680577 | 680577 | 12 | 21:03:21 | 02.10.25 | 2 | 4.8 | Grienstrasse 1084 | 02.10.25 21:03:21 | 2025-10-02 21:03:21+02:00 |
| 680576 | 680576 | 22 | 21:01:45 | 02.10.25 | 2 | 4.5 | Grienstrasse 1084 | 02.10.25 21:01:45 | 2025-10-02 21:01:45+02:00 |
| 677799 | 677799 | 20 | 20:56:02 | 02.10.25 | 1 | 5.4 | Grienstrasse 1084 | 02.10.25 20:56:02 | 2025-10-02 20:56:02+02:00 |
| 680575 | 680575 | 35 | 20:54:34 | 02.10.25 | 2 | 3.8 | Grienstrasse 1084 | 02.10.25 20:54:34 | 2025-10-02 20:54:34+02:00 |
| 680574 | 680574 | 20 | 20:49:10 | 02.10.25 | 2 | 3.7 | Grienstrasse 1084 | 02.10.25 20:49:10 | 2025-10-02 20:49:10+02:00 |
| 677798 | 677798 | 24 | 20:48:12 | 02.10.25 | 1 | 4.2 | Grienstrasse 1084 | 02.10.25 20:48:12 | 2025-10-02 20:48:12+02:00 |
| 677797 | 677797 | 21 | 20:41:32 | 02.10.25 | 1 | 6.9 | Grienstrasse 1084 | 02.10.25 20:41:32 | 2025-10-02 20:41:32+02:00 |
| 680573 | 680573 | 23 | 20:40:26 | 02.10.25 | 2 | 3.2 | Grienstrasse 1084 | 02.10.25 20:40:26 | 2025-10-02 20:40:26+02:00 |
| 677796 | 677796 | 9 | 20:32:14 | 02.10.25 | 1 | 4.7 | Grienstrasse 1084 | 02.10.25 20:32:14 | 2025-10-02 20:32:14+02:00 |
| 680572 | 680572 | 22 | 20:19:24 | 02.10.25 | 2 | 3.9 | Grienstrasse 1084 | 02.10.25 20:19:24 | 2025-10-02 20:19:24+02:00 |
| 680571 | 680571 | 13 | 20:18:08 | 02.10.25 | 2 | 6.2 | Grienstrasse 1084 | 02.10.25 20:18:08 | 2025-10-02 20:18:08+02:00 |
| 677795 | 677795 | 9 | 20:17:09 | 02.10.25 | 1 | 0.9 | Grienstrasse 1084 | 02.10.25 20:17:09 | 2025-10-02 20:17:09+02:00 |
| 680570 | 680570 | 29 | 20:15:26 | 02.10.25 | 2 | 3.5 | Grienstrasse 1084 | 02.10.25 20:15:26 | 2025-10-02 20:15:26+02:00 |
| 677794 | 677794 | 17 | 20:10:14 | 02.10.25 | 1 | 6.3 | Grienstrasse 1084 | 02.10.25 20:10:14 | 2025-10-02 20:10:14+02:00 |
| 680569 | 680569 | 21 | 20:08:56 | 02.10.25 | 2 | 3.9 | Grienstrasse 1084 | 02.10.25 20:08:56 | 2025-10-02 20:08:56+02:00 |
| 680568 | 680568 | 26 | 20:08:49 | 02.10.25 | 2 | 7.9 | Grienstrasse 1084 | 02.10.25 20:08:49 | 2025-10-02 20:08:49+02:00 |
| 680567 | 680567 | 25 | 20:07:24 | 02.10.25 | 2 | 4.5 | Grienstrasse 1084 | 02.10.25 20:07:24 | 2025-10-02 20:07:24+02:00 |
| 680566 | 680566 | 24 | 20:07:23 | 02.10.25 | 2 | 6.4 | Grienstrasse 1084 | 02.10.25 20:07:23 | 2025-10-02 20:07:23+02:00 |
| 680565 | 680565 | 14 | 20:03:46 | 02.10.25 | 2 | 4.5 | Grienstrasse 1084 | 02.10.25 20:03:46 | 2025-10-02 20:03:46+02:00 |
| 677793 | 677793 | 19 | 20:03:14 | 02.10.25 | 1 | 5.6 | Grienstrasse 1084 | 02.10.25 20:03:14 | 2025-10-02 20:03:14+02:00 |
| 677792 | 677792 | 9 | 20:01:47 | 02.10.25 | 1 | 4.5 | Grienstrasse 1084 | 02.10.25 20:01:47 | 2025-10-02 20:01:47+02:00 |
| 680562 | 680562 | 34 | 20:01:24 | 02.10.25 | 2 | 5.9 | Grienstrasse 1084 | 02.10.25 20:01:24 | 2025-10-02 20:01:24+02:00 |
| 680563 | 680563 | 33 | 20:01:24 | 02.10.25 | 2 | 4.5 | Grienstrasse 1084 | 02.10.25 20:01:24 | 2025-10-02 20:01:24+02:00 |
| 680564 | 680564 | 34 | 20:01:24 | 02.10.25 | 2 | 4.5 | Grienstrasse 1084 | 02.10.25 20:01:24 | 2025-10-02 20:01:24+02:00 |
| 677791 | 677791 | 16 | 19:59:39 | 02.10.25 | 1 | 7.6 | Grienstrasse 1084 | 02.10.25 19:59:39 | 2025-10-02 19:59:39+02:00 |
| 677790 | 677790 | 26 | 19:57:40 | 02.10.25 | 1 | 1.0 | Grienstrasse 1084 | 02.10.25 19:57:40 | 2025-10-02 19:57:40+02:00 |
| 677789 | 677789 | 22 | 19:56:41 | 02.10.25 | 1 | 1.1 | Grienstrasse 1084 | 02.10.25 19:56:41 | 2025-10-02 19:56:41+02:00 |
| 677788 | 677788 | 16 | 19:56:36 | 02.10.25 | 1 | 2.0 | Grienstrasse 1084 | 02.10.25 19:56:36 | 2025-10-02 19:56:36+02:00 |
| 677787 | 677787 | 25 | 19:55:21 | 02.10.25 | 1 | 1.8 | Grienstrasse 1084 | 02.10.25 19:55:21 | 2025-10-02 19:55:21+02:00 |
| 677786 | 677786 | 26 | 19:50:38 | 02.10.25 | 1 | 1.0 | Grienstrasse 1084 | 02.10.25 19:50:38 | 2025-10-02 19:50:38+02:00 |
| 680561 | 680561 | 10 | 19:49:06 | 02.10.25 | 2 | 4.5 | Grienstrasse 1084 | 02.10.25 19:49:06 | 2025-10-02 19:49:06+02:00 |
| 677785 | 677785 | 21 | 19:48:37 | 02.10.25 | 1 | 5.0 | Grienstrasse 1084 | 02.10.25 19:48:37 | 2025-10-02 19:48:37+02:00 |
| 677784 | 677784 | 22 | 19:48:33 | 02.10.25 | 1 | 3.6 | Grienstrasse 1084 | 02.10.25 19:48:33 | 2025-10-02 19:48:33+02:00 |
| 677783 | 677783 | 19 | 19:48:06 | 02.10.25 | 1 | 4.9 | Grienstrasse 1084 | 02.10.25 19:48:06 | 2025-10-02 19:48:06+02:00 |
| 680560 | 680560 | 22 | 19:47:55 | 02.10.25 | 2 | 5.5 | Grienstrasse 1084 | 02.10.25 19:47:55 | 2025-10-02 19:47:55+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");