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
8,220 rows where Messung-ID = 1132 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 ▲ |
|---|---|---|---|---|---|---|---|---|---|
| 2883631 | 2883631 | 26 | 04:18:52 | 24.01.26 | 2 | 4.4 | Inselstrasse 1132 | 24.01.26 04:18:52 | 2026-01-24 04:18:52+01:00 |
| 2883630 | 2883630 | 34 | 03:51:35 | 24.01.26 | 2 | 4.6 | Inselstrasse 1132 | 24.01.26 03:51:35 | 2026-01-24 03:51:35+01:00 |
| 2888890 | 2888890 | 21 | 03:47:44 | 24.01.26 | 1 | 4.7 | Inselstrasse 1132 | 24.01.26 03:47:44 | 2026-01-24 03:47:44+01:00 |
| 2883629 | 2883629 | 22 | 03:43:44 | 24.01.26 | 2 | 4.4 | Inselstrasse 1132 | 24.01.26 03:43:44 | 2026-01-24 03:43:44+01:00 |
| 2888889 | 2888889 | 25 | 03:42:21 | 24.01.26 | 1 | 3.8 | Inselstrasse 1132 | 24.01.26 03:42:21 | 2026-01-24 03:42:21+01:00 |
| 2883628 | 2883628 | 26 | 03:39:43 | 24.01.26 | 2 | 4.7 | Inselstrasse 1132 | 24.01.26 03:39:43 | 2026-01-24 03:39:43+01:00 |
| 2888888 | 2888888 | 21 | 03:16:03 | 24.01.26 | 1 | 5.4 | Inselstrasse 1132 | 24.01.26 03:16:03 | 2026-01-24 03:16:03+01:00 |
| 2888887 | 2888887 | 27 | 03:14:57 | 24.01.26 | 1 | 3.8 | Inselstrasse 1132 | 24.01.26 03:14:57 | 2026-01-24 03:14:57+01:00 |
| 2888886 | 2888886 | 19 | 03:08:39 | 24.01.26 | 1 | 4.4 | Inselstrasse 1132 | 24.01.26 03:08:39 | 2026-01-24 03:08:39+01:00 |
| 2888885 | 2888885 | 30 | 03:00:55 | 24.01.26 | 1 | 4.2 | Inselstrasse 1132 | 24.01.26 03:00:55 | 2026-01-24 03:00:55+01:00 |
| 2888884 | 2888884 | 9 | 03:00:15 | 24.01.26 | 1 | 2.9 | Inselstrasse 1132 | 24.01.26 03:00:15 | 2026-01-24 03:00:15+01:00 |
| 2883627 | 2883627 | 28 | 02:59:16 | 24.01.26 | 2 | 4.0 | Inselstrasse 1132 | 24.01.26 02:59:16 | 2026-01-24 02:59:16+01:00 |
| 2888883 | 2888883 | 29 | 02:57:47 | 24.01.26 | 1 | 4.0 | Inselstrasse 1132 | 24.01.26 02:57:47 | 2026-01-24 02:57:47+01:00 |
| 2888882 | 2888882 | 27 | 02:51:14 | 24.01.26 | 1 | 4.5 | Inselstrasse 1132 | 24.01.26 02:51:14 | 2026-01-24 02:51:14+01:00 |
| 2888881 | 2888881 | 20 | 02:45:52 | 24.01.26 | 1 | 4.8 | Inselstrasse 1132 | 24.01.26 02:45:52 | 2026-01-24 02:45:52+01:00 |
| 2888880 | 2888880 | 25 | 02:44:36 | 24.01.26 | 1 | 4.8 | Inselstrasse 1132 | 24.01.26 02:44:36 | 2026-01-24 02:44:36+01:00 |
| 2888879 | 2888879 | 33 | 02:43:52 | 24.01.26 | 1 | 4.6 | Inselstrasse 1132 | 24.01.26 02:43:52 | 2026-01-24 02:43:52+01:00 |
| 2888878 | 2888878 | 29 | 02:36:27 | 24.01.26 | 1 | 4.1 | Inselstrasse 1132 | 24.01.26 02:36:27 | 2026-01-24 02:36:27+01:00 |
| 2888877 | 2888877 | 14 | 02:36:06 | 24.01.26 | 1 | 4.8 | Inselstrasse 1132 | 24.01.26 02:36:06 | 2026-01-24 02:36:06+01:00 |
| 2888876 | 2888876 | 31 | 02:23:31 | 24.01.26 | 1 | 7.3 | Inselstrasse 1132 | 24.01.26 02:23:31 | 2026-01-24 02:23:31+01:00 |
| 2888875 | 2888875 | 23 | 02:13:05 | 24.01.26 | 1 | 4.4 | Inselstrasse 1132 | 24.01.26 02:13:05 | 2026-01-24 02:13:05+01:00 |
| 2883626 | 2883626 | 26 | 02:02:59 | 24.01.26 | 2 | 4.7 | Inselstrasse 1132 | 24.01.26 02:02:59 | 2026-01-24 02:02:59+01:00 |
| 2888874 | 2888874 | 27 | 02:02:31 | 24.01.26 | 1 | 4.7 | Inselstrasse 1132 | 24.01.26 02:02:31 | 2026-01-24 02:02:31+01:00 |
| 2883625 | 2883625 | 9 | 01:39:31 | 24.01.26 | 2 | 1.6 | Inselstrasse 1132 | 24.01.26 01:39:31 | 2026-01-24 01:39:31+01:00 |
| 2888873 | 2888873 | 25 | 01:36:58 | 24.01.26 | 1 | 4.6 | Inselstrasse 1132 | 24.01.26 01:36:58 | 2026-01-24 01:36:58+01:00 |
| 2888872 | 2888872 | 12 | 01:36:32 | 24.01.26 | 1 | 3.2 | Inselstrasse 1132 | 24.01.26 01:36:32 | 2026-01-24 01:36:32+01:00 |
| 2888871 | 2888871 | 23 | 01:35:17 | 24.01.26 | 1 | 4.5 | Inselstrasse 1132 | 24.01.26 01:35:17 | 2026-01-24 01:35:17+01:00 |
| 2888870 | 2888870 | 8 | 01:31:02 | 24.01.26 | 1 | 2.4 | Inselstrasse 1132 | 24.01.26 01:31:02 | 2026-01-24 01:31:02+01:00 |
| 2883624 | 2883624 | 24 | 01:26:11 | 24.01.26 | 2 | 4.1 | Inselstrasse 1132 | 24.01.26 01:26:11 | 2026-01-24 01:26:11+01:00 |
| 2888869 | 2888869 | 9 | 01:23:39 | 24.01.26 | 1 | 2.7 | Inselstrasse 1132 | 24.01.26 01:23:39 | 2026-01-24 01:23:39+01:00 |
| 2883623 | 2883623 | 23 | 01:20:46 | 24.01.26 | 2 | 5.0 | Inselstrasse 1132 | 24.01.26 01:20:46 | 2026-01-24 01:20:46+01:00 |
| 2888868 | 2888868 | 22 | 01:16:39 | 24.01.26 | 1 | 4.7 | Inselstrasse 1132 | 24.01.26 01:16:39 | 2026-01-24 01:16:39+01:00 |
| 2888867 | 2888867 | 24 | 01:10:14 | 24.01.26 | 1 | 3.9 | Inselstrasse 1132 | 24.01.26 01:10:14 | 2026-01-24 01:10:14+01:00 |
| 2883622 | 2883622 | 31 | 01:06:02 | 24.01.26 | 2 | 4.5 | Inselstrasse 1132 | 24.01.26 01:06:02 | 2026-01-24 01:06:02+01:00 |
| 2888866 | 2888866 | 28 | 01:03:48 | 24.01.26 | 1 | 4.7 | Inselstrasse 1132 | 24.01.26 01:03:48 | 2026-01-24 01:03:48+01:00 |
| 2888865 | 2888865 | 30 | 01:01:15 | 24.01.26 | 1 | 3.9 | Inselstrasse 1132 | 24.01.26 01:01:15 | 2026-01-24 01:01:15+01:00 |
| 2888864 | 2888864 | 16 | 00:59:18 | 24.01.26 | 1 | 3.5 | Inselstrasse 1132 | 24.01.26 00:59:18 | 2026-01-24 00:59:18+01:00 |
| 2888863 | 2888863 | 9 | 00:56:19 | 24.01.26 | 1 | 3.5 | Inselstrasse 1132 | 24.01.26 00:56:19 | 2026-01-24 00:56:19+01:00 |
| 2883621 | 2883621 | 28 | 00:53:45 | 24.01.26 | 2 | 4.2 | Inselstrasse 1132 | 24.01.26 00:53:45 | 2026-01-24 00:53:45+01:00 |
| 2888862 | 2888862 | 37 | 00:44:24 | 24.01.26 | 1 | 5.0 | Inselstrasse 1132 | 24.01.26 00:44:24 | 2026-01-24 00:44:24+01:00 |
| 2888861 | 2888861 | 25 | 00:42:57 | 24.01.26 | 1 | 4.5 | Inselstrasse 1132 | 24.01.26 00:42:57 | 2026-01-24 00:42:57+01:00 |
| 2888860 | 2888860 | 16 | 00:40:59 | 24.01.26 | 1 | 3.8 | Inselstrasse 1132 | 24.01.26 00:40:59 | 2026-01-24 00:40:59+01:00 |
| 2888859 | 2888859 | 21 | 00:33:37 | 24.01.26 | 1 | 4.3 | Inselstrasse 1132 | 24.01.26 00:33:37 | 2026-01-24 00:33:37+01:00 |
| 2883620 | 2883620 | 29 | 00:28:27 | 24.01.26 | 2 | 4.1 | Inselstrasse 1132 | 24.01.26 00:28:27 | 2026-01-24 00:28:27+01:00 |
| 2888858 | 2888858 | 5 | 00:28:22 | 24.01.26 | 1 | 4.8 | Inselstrasse 1132 | 24.01.26 00:28:22 | 2026-01-24 00:28:22+01:00 |
| 2888857 | 2888857 | 15 | 00:28:21 | 24.01.26 | 1 | 5.4 | Inselstrasse 1132 | 24.01.26 00:28:21 | 2026-01-24 00:28:21+01:00 |
| 2888856 | 2888856 | 18 | 00:24:23 | 24.01.26 | 1 | 4.8 | Inselstrasse 1132 | 24.01.26 00:24:23 | 2026-01-24 00:24:23+01:00 |
| 2888855 | 2888855 | 23 | 00:23:33 | 24.01.26 | 1 | 4.2 | Inselstrasse 1132 | 24.01.26 00:23:33 | 2026-01-24 00:23:33+01:00 |
| 2888854 | 2888854 | 15 | 00:19:09 | 24.01.26 | 1 | 4.2 | Inselstrasse 1132 | 24.01.26 00:19:09 | 2026-01-24 00:19:09+01:00 |
| 2888853 | 2888853 | 16 | 00:19:08 | 24.01.26 | 1 | 4.6 | Inselstrasse 1132 | 24.01.26 00:19:08 | 2026-01-24 00:19:08+01:00 |
| 2888852 | 2888852 | 28 | 00:15:11 | 24.01.26 | 1 | 4.8 | Inselstrasse 1132 | 24.01.26 00:15:11 | 2026-01-24 00:15:11+01:00 |
| 2888851 | 2888851 | 18 | 00:14:57 | 24.01.26 | 1 | 5.1 | Inselstrasse 1132 | 24.01.26 00:14:57 | 2026-01-24 00:14:57+01:00 |
| 2888850 | 2888850 | 29 | 00:13:04 | 24.01.26 | 1 | 4.7 | Inselstrasse 1132 | 24.01.26 00:13:04 | 2026-01-24 00:13:04+01:00 |
| 2888849 | 2888849 | 35 | 00:12:57 | 24.01.26 | 1 | 4.5 | Inselstrasse 1132 | 24.01.26 00:12:57 | 2026-01-24 00:12:57+01:00 |
| 2888848 | 2888848 | 25 | 00:09:14 | 24.01.26 | 1 | 1.7 | Inselstrasse 1132 | 24.01.26 00:09:14 | 2026-01-24 00:09:14+01:00 |
| 2888847 | 2888847 | 16 | 00:08:37 | 24.01.26 | 1 | 4.8 | Inselstrasse 1132 | 24.01.26 00:08:37 | 2026-01-24 00:08:37+01:00 |
| 2888846 | 2888846 | 24 | 00:08:20 | 24.01.26 | 1 | 4.1 | Inselstrasse 1132 | 24.01.26 00:08:20 | 2026-01-24 00:08:20+01:00 |
| 2888845 | 2888845 | 18 | 00:04:40 | 24.01.26 | 1 | 4.5 | Inselstrasse 1132 | 24.01.26 00:04:40 | 2026-01-24 00:04:40+01:00 |
| 2883619 | 2883619 | 22 | 00:00:40 | 24.01.26 | 2 | 5.0 | Inselstrasse 1132 | 24.01.26 00:00:40 | 2026-01-24 00:00:40+01:00 |
| 2888844 | 2888844 | 22 | 23:59:42 | 23.01.26 | 1 | 4.8 | Inselstrasse 1132 | 23.01.26 23:59:42 | 2026-01-23 23:59:42+01:00 |
| 2888843 | 2888843 | 24 | 23:58:51 | 23.01.26 | 1 | 3.9 | Inselstrasse 1132 | 23.01.26 23:58:51 | 2026-01-23 23:58:51+01:00 |
| 2888842 | 2888842 | 15 | 23:52:14 | 23.01.26 | 1 | 4.8 | Inselstrasse 1132 | 23.01.26 23:52:14 | 2026-01-23 23:52:14+01:00 |
| 2888841 | 2888841 | 28 | 23:50:36 | 23.01.26 | 1 | 4.2 | Inselstrasse 1132 | 23.01.26 23:50:36 | 2026-01-23 23:50:36+01:00 |
| 2888840 | 2888840 | 27 | 23:50:16 | 23.01.26 | 1 | 4.7 | Inselstrasse 1132 | 23.01.26 23:50:16 | 2026-01-23 23:50:16+01:00 |
| 2883618 | 2883618 | 27 | 23:46:56 | 23.01.26 | 2 | 4.7 | Inselstrasse 1132 | 23.01.26 23:46:56 | 2026-01-23 23:46:56+01:00 |
| 2888839 | 2888839 | 18 | 23:46:12 | 23.01.26 | 1 | 4.1 | Inselstrasse 1132 | 23.01.26 23:46:12 | 2026-01-23 23:46:12+01:00 |
| 2888838 | 2888838 | 35 | 23:43:32 | 23.01.26 | 1 | 4.7 | Inselstrasse 1132 | 23.01.26 23:43:32 | 2026-01-23 23:43:32+01:00 |
| 2888837 | 2888837 | 32 | 23:42:31 | 23.01.26 | 1 | 4.1 | Inselstrasse 1132 | 23.01.26 23:42:31 | 2026-01-23 23:42:31+01:00 |
| 2883617 | 2883617 | 14 | 23:42:22 | 23.01.26 | 2 | 1.8 | Inselstrasse 1132 | 23.01.26 23:42:22 | 2026-01-23 23:42:22+01:00 |
| 2888836 | 2888836 | 21 | 23:34:52 | 23.01.26 | 1 | 4.6 | Inselstrasse 1132 | 23.01.26 23:34:52 | 2026-01-23 23:34:52+01:00 |
| 2888835 | 2888835 | 38 | 23:31:02 | 23.01.26 | 1 | 2.2 | Inselstrasse 1132 | 23.01.26 23:31:02 | 2026-01-23 23:31:02+01:00 |
| 2888834 | 2888834 | 16 | 23:26:00 | 23.01.26 | 1 | 4.7 | Inselstrasse 1132 | 23.01.26 23:26:00 | 2026-01-23 23:26:00+01:00 |
| 2883616 | 2883616 | 10 | 23:23:54 | 23.01.26 | 2 | 2.0 | Inselstrasse 1132 | 23.01.26 23:23:54 | 2026-01-23 23:23:54+01:00 |
| 2883615 | 2883615 | 23 | 23:22:53 | 23.01.26 | 2 | 4.2 | Inselstrasse 1132 | 23.01.26 23:22:53 | 2026-01-23 23:22:53+01:00 |
| 2883614 | 2883614 | 10 | 23:22:36 | 23.01.26 | 2 | 1.7 | Inselstrasse 1132 | 23.01.26 23:22:36 | 2026-01-23 23:22:36+01:00 |
| 2888833 | 2888833 | 17 | 23:22:05 | 23.01.26 | 1 | 9.7 | Inselstrasse 1132 | 23.01.26 23:22:05 | 2026-01-23 23:22:05+01:00 |
| 2888832 | 2888832 | 18 | 23:20:21 | 23.01.26 | 1 | 8.3 | Inselstrasse 1132 | 23.01.26 23:20:21 | 2026-01-23 23:20:21+01:00 |
| 2883613 | 2883613 | 18 | 23:20:18 | 23.01.26 | 2 | 4.1 | Inselstrasse 1132 | 23.01.26 23:20:18 | 2026-01-23 23:20:18+01:00 |
| 2888831 | 2888831 | 20 | 23:20:14 | 23.01.26 | 1 | 4.6 | Inselstrasse 1132 | 23.01.26 23:20:14 | 2026-01-23 23:20:14+01:00 |
| 2883612 | 2883612 | 20 | 23:11:49 | 23.01.26 | 2 | 4.6 | Inselstrasse 1132 | 23.01.26 23:11:49 | 2026-01-23 23:11:49+01:00 |
| 2888830 | 2888830 | 16 | 23:11:48 | 23.01.26 | 1 | 1.4 | Inselstrasse 1132 | 23.01.26 23:11:48 | 2026-01-23 23:11:48+01:00 |
| 2888829 | 2888829 | 19 | 23:10:21 | 23.01.26 | 1 | 1.2 | Inselstrasse 1132 | 23.01.26 23:10:21 | 2026-01-23 23:10:21+01:00 |
| 2888828 | 2888828 | 24 | 23:08:28 | 23.01.26 | 1 | 5.1 | Inselstrasse 1132 | 23.01.26 23:08:28 | 2026-01-23 23:08:28+01:00 |
| 2888827 | 2888827 | 30 | 23:08:22 | 23.01.26 | 1 | 4.8 | Inselstrasse 1132 | 23.01.26 23:08:22 | 2026-01-23 23:08:22+01:00 |
| 2883611 | 2883611 | 19 | 23:07:40 | 23.01.26 | 2 | 4.6 | Inselstrasse 1132 | 23.01.26 23:07:40 | 2026-01-23 23:07:40+01:00 |
| 2883610 | 2883610 | 28 | 23:07:20 | 23.01.26 | 2 | 4.5 | Inselstrasse 1132 | 23.01.26 23:07:20 | 2026-01-23 23:07:20+01:00 |
| 2888826 | 2888826 | 22 | 23:07:18 | 23.01.26 | 1 | 4.7 | Inselstrasse 1132 | 23.01.26 23:07:18 | 2026-01-23 23:07:18+01:00 |
| 2888825 | 2888825 | 26 | 23:06:20 | 23.01.26 | 1 | 4.6 | Inselstrasse 1132 | 23.01.26 23:06:20 | 2026-01-23 23:06:20+01:00 |
| 2888824 | 2888824 | 34 | 23:04:38 | 23.01.26 | 1 | 5.0 | Inselstrasse 1132 | 23.01.26 23:04:38 | 2026-01-23 23:04:38+01:00 |
| 2883609 | 2883609 | 7 | 23:02:15 | 23.01.26 | 2 | 4.6 | Inselstrasse 1132 | 23.01.26 23:02:15 | 2026-01-23 23:02:15+01:00 |
| 2883608 | 2883608 | 20 | 22:58:12 | 23.01.26 | 2 | 4.6 | Inselstrasse 1132 | 23.01.26 22:58:12 | 2026-01-23 22:58:12+01:00 |
| 2888823 | 2888823 | 31 | 22:56:45 | 23.01.26 | 1 | 4.4 | Inselstrasse 1132 | 23.01.26 22:56:45 | 2026-01-23 22:56:45+01:00 |
| 2888822 | 2888822 | 24 | 22:55:38 | 23.01.26 | 1 | 4.4 | Inselstrasse 1132 | 23.01.26 22:55:38 | 2026-01-23 22:55:38+01:00 |
| 2883607 | 2883607 | 25 | 22:53:12 | 23.01.26 | 2 | 4.2 | Inselstrasse 1132 | 23.01.26 22:53:12 | 2026-01-23 22:53:12+01:00 |
| 2883606 | 2883606 | 23 | 22:49:10 | 23.01.26 | 2 | 4.4 | Inselstrasse 1132 | 23.01.26 22:49:10 | 2026-01-23 22:49:10+01:00 |
| 2888821 | 2888821 | 27 | 22:48:29 | 23.01.26 | 1 | 4.6 | Inselstrasse 1132 | 23.01.26 22:48:29 | 2026-01-23 22:48:29+01:00 |
| 2883605 | 2883605 | 22 | 22:47:16 | 23.01.26 | 2 | 4.5 | Inselstrasse 1132 | 23.01.26 22:47:16 | 2026-01-23 22:47:16+01:00 |
| 2883604 | 2883604 | 14 | 22:46:53 | 23.01.26 | 2 | 4.6 | Inselstrasse 1132 | 23.01.26 22:46:53 | 2026-01-23 22:46:53+01:00 |
| 2883603 | 2883603 | 24 | 22:45:40 | 23.01.26 | 2 | 5.1 | Inselstrasse 1132 | 23.01.26 22:45:40 | 2026-01-23 22:45:40+01:00 |
| 2883602 | 2883602 | 16 | 22:45:17 | 23.01.26 | 2 | 4.4 | Inselstrasse 1132 | 23.01.26 22:45:17 | 2026-01-23 22:45:17+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");