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 = 1016 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 ▲ |
|---|---|---|---|---|---|---|---|---|---|
| 4618794 | 4618794 | 58 | 02:54:32 | 11.05.25 | 2 | 4.7 | Wanderstrasse 1016 | 11.05.25 02:54:32 | 2025-05-11 02:54:32+02:00 |
| 4618793 | 4618793 | 54 | 02:51:57 | 11.05.25 | 2 | 4.4 | Wanderstrasse 1016 | 11.05.25 02:51:57 | 2025-05-11 02:51:57+02:00 |
| 4618792 | 4618792 | 45 | 02:51:24 | 11.05.25 | 2 | 4.9 | Wanderstrasse 1016 | 11.05.25 02:51:24 | 2025-05-11 02:51:24+02:00 |
| 4618791 | 4618791 | 44 | 02:49:26 | 11.05.25 | 2 | 3.1 | Wanderstrasse 1016 | 11.05.25 02:49:26 | 2025-05-11 02:49:26+02:00 |
| 4652847 | 4652847 | 36 | 02:48:55 | 11.05.25 | 1 | 5.6 | Wanderstrasse 1016 | 11.05.25 02:48:55 | 2025-05-11 02:48:55+02:00 |
| 4652846 | 4652846 | 60 | 02:47:55 | 11.05.25 | 1 | 4.9 | Wanderstrasse 1016 | 11.05.25 02:47:55 | 2025-05-11 02:47:55+02:00 |
| 4652845 | 4652845 | 14 | 02:46:58 | 11.05.25 | 1 | 2.3 | Wanderstrasse 1016 | 11.05.25 02:46:58 | 2025-05-11 02:46:58+02:00 |
| 4618790 | 4618790 | 51 | 02:44:23 | 11.05.25 | 2 | 4.6 | Wanderstrasse 1016 | 11.05.25 02:44:23 | 2025-05-11 02:44:23+02:00 |
| 4652844 | 4652844 | 45 | 02:43:59 | 11.05.25 | 1 | 4.7 | Wanderstrasse 1016 | 11.05.25 02:43:59 | 2025-05-11 02:43:59+02:00 |
| 4618789 | 4618789 | 35 | 02:43:53 | 11.05.25 | 2 | 4.5 | Wanderstrasse 1016 | 11.05.25 02:43:53 | 2025-05-11 02:43:53+02:00 |
| 4618788 | 4618788 | 62 | 02:41:51 | 11.05.25 | 2 | 4.7 | Wanderstrasse 1016 | 11.05.25 02:41:51 | 2025-05-11 02:41:51+02:00 |
| 4618787 | 4618787 | 44 | 02:41:31 | 11.05.25 | 2 | 4.4 | Wanderstrasse 1016 | 11.05.25 02:41:31 | 2025-05-11 02:41:31+02:00 |
| 4652843 | 4652843 | 24 | 02:39:43 | 11.05.25 | 1 | 4.3 | Wanderstrasse 1016 | 11.05.25 02:39:43 | 2025-05-11 02:39:43+02:00 |
| 4618786 | 4618786 | 46 | 02:39:08 | 11.05.25 | 2 | 4.1 | Wanderstrasse 1016 | 11.05.25 02:39:08 | 2025-05-11 02:39:08+02:00 |
| 4618785 | 4618785 | 36 | 02:37:07 | 11.05.25 | 2 | 5.1 | Wanderstrasse 1016 | 11.05.25 02:37:07 | 2025-05-11 02:37:07+02:00 |
| 4652842 | 4652842 | 51 | 02:34:26 | 11.05.25 | 1 | 4.0 | Wanderstrasse 1016 | 11.05.25 02:34:26 | 2025-05-11 02:34:26+02:00 |
| 4652841 | 4652841 | 41 | 02:31:45 | 11.05.25 | 1 | 4.9 | Wanderstrasse 1016 | 11.05.25 02:31:45 | 2025-05-11 02:31:45+02:00 |
| 4652840 | 4652840 | 47 | 02:30:53 | 11.05.25 | 1 | 4.9 | Wanderstrasse 1016 | 11.05.25 02:30:53 | 2025-05-11 02:30:53+02:00 |
| 4618784 | 4618784 | 41 | 02:29:17 | 11.05.25 | 2 | 4.0 | Wanderstrasse 1016 | 11.05.25 02:29:17 | 2025-05-11 02:29:17+02:00 |
| 4618783 | 4618783 | 44 | 02:28:52 | 11.05.25 | 2 | 4.7 | Wanderstrasse 1016 | 11.05.25 02:28:52 | 2025-05-11 02:28:52+02:00 |
| 4618782 | 4618782 | 18 | 02:28:38 | 11.05.25 | 2 | 0.7 | Wanderstrasse 1016 | 11.05.25 02:28:38 | 2025-05-11 02:28:38+02:00 |
| 4652839 | 4652839 | 27 | 02:28:36 | 11.05.25 | 1 | 4.2 | Wanderstrasse 1016 | 11.05.25 02:28:36 | 2025-05-11 02:28:36+02:00 |
| 4618781 | 4618781 | 25 | 02:27:39 | 11.05.25 | 2 | 9.2 | Wanderstrasse 1016 | 11.05.25 02:27:39 | 2025-05-11 02:27:39+02:00 |
| 4618780 | 4618780 | 42 | 02:26:00 | 11.05.25 | 2 | 13.1 | Wanderstrasse 1016 | 11.05.25 02:26:00 | 2025-05-11 02:26:00+02:00 |
| 4618779 | 4618779 | 43 | 02:21:40 | 11.05.25 | 2 | 4.6 | Wanderstrasse 1016 | 11.05.25 02:21:40 | 2025-05-11 02:21:40+02:00 |
| 4618778 | 4618778 | 39 | 02:20:20 | 11.05.25 | 2 | 5.4 | Wanderstrasse 1016 | 11.05.25 02:20:20 | 2025-05-11 02:20:20+02:00 |
| 4618777 | 4618777 | 47 | 02:20:00 | 11.05.25 | 2 | 3.5 | Wanderstrasse 1016 | 11.05.25 02:20:00 | 2025-05-11 02:20:00+02:00 |
| 4652838 | 4652838 | 26 | 02:15:00 | 11.05.25 | 1 | 4.6 | Wanderstrasse 1016 | 11.05.25 02:15:00 | 2025-05-11 02:15:00+02:00 |
| 4618776 | 4618776 | 44 | 02:14:33 | 11.05.25 | 2 | 4.2 | Wanderstrasse 1016 | 11.05.25 02:14:33 | 2025-05-11 02:14:33+02:00 |
| 4618775 | 4618775 | 52 | 02:13:30 | 11.05.25 | 2 | 5.7 | Wanderstrasse 1016 | 11.05.25 02:13:30 | 2025-05-11 02:13:30+02:00 |
| 4618774 | 4618774 | 51 | 02:13:06 | 11.05.25 | 2 | 4.4 | Wanderstrasse 1016 | 11.05.25 02:13:06 | 2025-05-11 02:13:06+02:00 |
| 4652837 | 4652837 | 32 | 02:11:20 | 11.05.25 | 1 | 4.8 | Wanderstrasse 1016 | 11.05.25 02:11:20 | 2025-05-11 02:11:20+02:00 |
| 4618773 | 4618773 | 59 | 02:08:10 | 11.05.25 | 2 | 3.8 | Wanderstrasse 1016 | 11.05.25 02:08:10 | 2025-05-11 02:08:10+02:00 |
| 4618772 | 4618772 | 38 | 02:07:34 | 11.05.25 | 2 | 4.3 | Wanderstrasse 1016 | 11.05.25 02:07:34 | 2025-05-11 02:07:34+02:00 |
| 4618771 | 4618771 | 44 | 02:07:03 | 11.05.25 | 2 | 4.6 | Wanderstrasse 1016 | 11.05.25 02:07:03 | 2025-05-11 02:07:03+02:00 |
| 4618770 | 4618770 | 27 | 02:03:39 | 11.05.25 | 2 | 4.9 | Wanderstrasse 1016 | 11.05.25 02:03:39 | 2025-05-11 02:03:39+02:00 |
| 4652836 | 4652836 | 31 | 02:03:34 | 11.05.25 | 1 | 3.5 | Wanderstrasse 1016 | 11.05.25 02:03:34 | 2025-05-11 02:03:34+02:00 |
| 4618769 | 4618769 | 40 | 02:03:29 | 11.05.25 | 2 | 4.6 | Wanderstrasse 1016 | 11.05.25 02:03:29 | 2025-05-11 02:03:29+02:00 |
| 4618768 | 4618768 | 43 | 02:01:38 | 11.05.25 | 2 | 3.8 | Wanderstrasse 1016 | 11.05.25 02:01:38 | 2025-05-11 02:01:38+02:00 |
| 4618767 | 4618767 | 38 | 02:00:52 | 11.05.25 | 2 | 4.9 | Wanderstrasse 1016 | 11.05.25 02:00:52 | 2025-05-11 02:00:52+02:00 |
| 4618766 | 4618766 | 45 | 02:00:18 | 11.05.25 | 2 | 4.1 | Wanderstrasse 1016 | 11.05.25 02:00:18 | 2025-05-11 02:00:18+02:00 |
| 4618765 | 4618765 | 57 | 02:00:07 | 11.05.25 | 2 | 3.6 | Wanderstrasse 1016 | 11.05.25 02:00:07 | 2025-05-11 02:00:07+02:00 |
| 4618764 | 4618764 | 37 | 01:59:38 | 11.05.25 | 2 | 4.6 | Wanderstrasse 1016 | 11.05.25 01:59:38 | 2025-05-11 01:59:38+02:00 |
| 4618763 | 4618763 | 44 | 01:59:10 | 11.05.25 | 2 | 4.0 | Wanderstrasse 1016 | 11.05.25 01:59:10 | 2025-05-11 01:59:10+02:00 |
| 4652835 | 4652835 | 38 | 01:58:10 | 11.05.25 | 1 | 12.1 | Wanderstrasse 1016 | 11.05.25 01:58:10 | 2025-05-11 01:58:10+02:00 |
| 4652834 | 4652834 | 47 | 01:56:45 | 11.05.25 | 1 | 4.8 | Wanderstrasse 1016 | 11.05.25 01:56:45 | 2025-05-11 01:56:45+02:00 |
| 4618762 | 4618762 | 43 | 01:53:36 | 11.05.25 | 2 | 3.7 | Wanderstrasse 1016 | 11.05.25 01:53:36 | 2025-05-11 01:53:36+02:00 |
| 4652833 | 4652833 | 40 | 01:53:20 | 11.05.25 | 1 | 4.6 | Wanderstrasse 1016 | 11.05.25 01:53:20 | 2025-05-11 01:53:20+02:00 |
| 4652832 | 4652832 | 41 | 01:53:10 | 11.05.25 | 1 | 4.7 | Wanderstrasse 1016 | 11.05.25 01:53:10 | 2025-05-11 01:53:10+02:00 |
| 4652831 | 4652831 | 40 | 01:52:41 | 11.05.25 | 1 | 3.9 | Wanderstrasse 1016 | 11.05.25 01:52:41 | 2025-05-11 01:52:41+02:00 |
| 4618761 | 4618761 | 47 | 01:47:56 | 11.05.25 | 2 | 4.7 | Wanderstrasse 1016 | 11.05.25 01:47:56 | 2025-05-11 01:47:56+02:00 |
| 4652830 | 4652830 | 43 | 01:45:10 | 11.05.25 | 1 | 4.5 | Wanderstrasse 1016 | 11.05.25 01:45:10 | 2025-05-11 01:45:10+02:00 |
| 4652829 | 4652829 | 45 | 01:43:01 | 11.05.25 | 1 | 4.6 | Wanderstrasse 1016 | 11.05.25 01:43:01 | 2025-05-11 01:43:01+02:00 |
| 4618760 | 4618760 | 40 | 01:41:57 | 11.05.25 | 2 | 3.5 | Wanderstrasse 1016 | 11.05.25 01:41:57 | 2025-05-11 01:41:57+02:00 |
| 4618759 | 4618759 | 42 | 01:41:53 | 11.05.25 | 2 | 4.0 | Wanderstrasse 1016 | 11.05.25 01:41:53 | 2025-05-11 01:41:53+02:00 |
| 4652828 | 4652828 | 45 | 01:37:09 | 11.05.25 | 1 | 4.4 | Wanderstrasse 1016 | 11.05.25 01:37:09 | 2025-05-11 01:37:09+02:00 |
| 4618758 | 4618758 | 48 | 01:35:58 | 11.05.25 | 2 | 4.6 | Wanderstrasse 1016 | 11.05.25 01:35:58 | 2025-05-11 01:35:58+02:00 |
| 4618757 | 4618757 | 49 | 01:35:55 | 11.05.25 | 2 | 3.9 | Wanderstrasse 1016 | 11.05.25 01:35:55 | 2025-05-11 01:35:55+02:00 |
| 4618756 | 4618756 | 53 | 01:35:14 | 11.05.25 | 2 | 5.2 | Wanderstrasse 1016 | 11.05.25 01:35:14 | 2025-05-11 01:35:14+02:00 |
| 4618755 | 4618755 | 48 | 01:30:17 | 11.05.25 | 2 | 4.0 | Wanderstrasse 1016 | 11.05.25 01:30:17 | 2025-05-11 01:30:17+02:00 |
| 4618754 | 4618754 | 42 | 01:29:59 | 11.05.25 | 2 | 4.0 | Wanderstrasse 1016 | 11.05.25 01:29:59 | 2025-05-11 01:29:59+02:00 |
| 4618753 | 4618753 | 35 | 01:29:13 | 11.05.25 | 2 | 3.7 | Wanderstrasse 1016 | 11.05.25 01:29:13 | 2025-05-11 01:29:13+02:00 |
| 4618752 | 4618752 | 44 | 01:27:27 | 11.05.25 | 2 | 4.7 | Wanderstrasse 1016 | 11.05.25 01:27:27 | 2025-05-11 01:27:27+02:00 |
| 4618751 | 4618751 | 48 | 01:27:22 | 11.05.25 | 2 | 5.2 | Wanderstrasse 1016 | 11.05.25 01:27:22 | 2025-05-11 01:27:22+02:00 |
| 4618750 | 4618750 | 39 | 01:26:28 | 11.05.25 | 2 | 12.7 | Wanderstrasse 1016 | 11.05.25 01:26:28 | 2025-05-11 01:26:28+02:00 |
| 4652827 | 4652827 | 48 | 01:22:09 | 11.05.25 | 1 | 0.9 | Wanderstrasse 1016 | 11.05.25 01:22:09 | 2025-05-11 01:22:09+02:00 |
| 4618749 | 4618749 | 47 | 01:22:05 | 11.05.25 | 2 | 4.2 | Wanderstrasse 1016 | 11.05.25 01:22:05 | 2025-05-11 01:22:05+02:00 |
| 4618748 | 4618748 | 32 | 01:20:03 | 11.05.25 | 2 | 3.9 | Wanderstrasse 1016 | 11.05.25 01:20:03 | 2025-05-11 01:20:03+02:00 |
| 4618747 | 4618747 | 46 | 01:19:51 | 11.05.25 | 2 | 4.6 | Wanderstrasse 1016 | 11.05.25 01:19:51 | 2025-05-11 01:19:51+02:00 |
| 4618746 | 4618746 | 48 | 01:19:49 | 11.05.25 | 2 | 4.3 | Wanderstrasse 1016 | 11.05.25 01:19:49 | 2025-05-11 01:19:49+02:00 |
| 4618745 | 4618745 | 46 | 01:19:21 | 11.05.25 | 2 | 3.7 | Wanderstrasse 1016 | 11.05.25 01:19:21 | 2025-05-11 01:19:21+02:00 |
| 4618744 | 4618744 | 20 | 01:18:46 | 11.05.25 | 2 | 8.5 | Wanderstrasse 1016 | 11.05.25 01:18:46 | 2025-05-11 01:18:46+02:00 |
| 4618743 | 4618743 | 41 | 01:17:31 | 11.05.25 | 2 | 3.6 | Wanderstrasse 1016 | 11.05.25 01:17:31 | 2025-05-11 01:17:31+02:00 |
| 4618742 | 4618742 | 55 | 01:16:46 | 11.05.25 | 2 | 4.0 | Wanderstrasse 1016 | 11.05.25 01:16:46 | 2025-05-11 01:16:46+02:00 |
| 4618741 | 4618741 | 49 | 01:15:57 | 11.05.25 | 2 | 4.6 | Wanderstrasse 1016 | 11.05.25 01:15:57 | 2025-05-11 01:15:57+02:00 |
| 4618740 | 4618740 | 46 | 01:15:52 | 11.05.25 | 2 | 4.3 | Wanderstrasse 1016 | 11.05.25 01:15:52 | 2025-05-11 01:15:52+02:00 |
| 4652826 | 4652826 | 19 | 01:15:12 | 11.05.25 | 1 | 0.7 | Wanderstrasse 1016 | 11.05.25 01:15:12 | 2025-05-11 01:15:12+02:00 |
| 4652825 | 4652825 | 44 | 01:14:10 | 11.05.25 | 1 | 4.7 | Wanderstrasse 1016 | 11.05.25 01:14:10 | 2025-05-11 01:14:10+02:00 |
| 4652824 | 4652824 | 53 | 01:11:17 | 11.05.25 | 1 | 4.4 | Wanderstrasse 1016 | 11.05.25 01:11:17 | 2025-05-11 01:11:17+02:00 |
| 4618739 | 4618739 | 44 | 01:10:43 | 11.05.25 | 2 | 4.5 | Wanderstrasse 1016 | 11.05.25 01:10:43 | 2025-05-11 01:10:43+02:00 |
| 4618738 | 4618738 | 50 | 01:07:00 | 11.05.25 | 2 | 3.9 | Wanderstrasse 1016 | 11.05.25 01:07:00 | 2025-05-11 01:07:00+02:00 |
| 4618737 | 4618737 | 56 | 01:05:50 | 11.05.25 | 2 | 4.9 | Wanderstrasse 1016 | 11.05.25 01:05:50 | 2025-05-11 01:05:50+02:00 |
| 4618736 | 4618736 | 50 | 01:05:33 | 11.05.25 | 2 | 4.0 | Wanderstrasse 1016 | 11.05.25 01:05:33 | 2025-05-11 01:05:33+02:00 |
| 4618735 | 4618735 | 41 | 01:04:51 | 11.05.25 | 2 | 3.9 | Wanderstrasse 1016 | 11.05.25 01:04:51 | 2025-05-11 01:04:51+02:00 |
| 4618734 | 4618734 | 44 | 01:04:05 | 11.05.25 | 2 | 3.0 | Wanderstrasse 1016 | 11.05.25 01:04:05 | 2025-05-11 01:04:05+02:00 |
| 4618733 | 4618733 | 26 | 01:04:03 | 11.05.25 | 2 | 0.7 | Wanderstrasse 1016 | 11.05.25 01:04:03 | 2025-05-11 01:04:03+02:00 |
| 4618732 | 4618732 | 42 | 01:03:32 | 11.05.25 | 2 | 4.0 | Wanderstrasse 1016 | 11.05.25 01:03:32 | 2025-05-11 01:03:32+02:00 |
| 4618731 | 4618731 | 46 | 01:03:06 | 11.05.25 | 2 | 4.1 | Wanderstrasse 1016 | 11.05.25 01:03:06 | 2025-05-11 01:03:06+02:00 |
| 4618730 | 4618730 | 43 | 01:02:30 | 11.05.25 | 2 | 4.5 | Wanderstrasse 1016 | 11.05.25 01:02:30 | 2025-05-11 01:02:30+02:00 |
| 4618729 | 4618729 | 48 | 01:01:08 | 11.05.25 | 2 | 4.6 | Wanderstrasse 1016 | 11.05.25 01:01:08 | 2025-05-11 01:01:08+02:00 |
| 4618728 | 4618728 | 42 | 00:59:02 | 11.05.25 | 2 | 4.5 | Wanderstrasse 1016 | 11.05.25 00:59:02 | 2025-05-11 00:59:02+02:00 |
| 4652823 | 4652823 | 39 | 00:57:41 | 11.05.25 | 1 | 11.8 | Wanderstrasse 1016 | 11.05.25 00:57:41 | 2025-05-11 00:57:41+02:00 |
| 4652822 | 4652822 | 29 | 00:56:42 | 11.05.25 | 1 | 4.4 | Wanderstrasse 1016 | 11.05.25 00:56:42 | 2025-05-11 00:56:42+02:00 |
| 4618727 | 4618727 | 40 | 00:56:33 | 11.05.25 | 2 | 4.2 | Wanderstrasse 1016 | 11.05.25 00:56:33 | 2025-05-11 00:56:33+02:00 |
| 4618726 | 4618726 | 28 | 00:56:29 | 11.05.25 | 2 | 4.2 | Wanderstrasse 1016 | 11.05.25 00:56:29 | 2025-05-11 00:56:29+02:00 |
| 4618725 | 4618725 | 48 | 00:56:02 | 11.05.25 | 2 | 4.5 | Wanderstrasse 1016 | 11.05.25 00:56:02 | 2025-05-11 00:56:02+02:00 |
| 4618724 | 4618724 | 47 | 00:54:59 | 11.05.25 | 2 | 5.1 | Wanderstrasse 1016 | 11.05.25 00:54:59 | 2025-05-11 00:54:59+02:00 |
| 4652821 | 4652821 | 43 | 00:54:01 | 11.05.25 | 1 | 4.8 | Wanderstrasse 1016 | 11.05.25 00:54:01 | 2025-05-11 00:54:01+02:00 |
| 4618723 | 4618723 | 15 | 00:53:00 | 11.05.25 | 2 | 2.2 | Wanderstrasse 1016 | 11.05.25 00:53:00 | 2025-05-11 00:53:00+02:00 |
| 4652820 | 4652820 | 54 | 00:50:55 | 11.05.25 | 1 | 4.6 | Wanderstrasse 1016 | 11.05.25 00:50:55 | 2025-05-11 00:50: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");