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 ▲ |
|---|---|---|---|---|---|---|---|---|---|
| 13324777 | 13324777 | 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 |
| 13324776 | 13324776 | 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 |
| 13322012 | 13322012 | 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 |
| 13322011 | 13322011 | 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 |
| 13322010 | 13322010 | 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 |
| 13322009 | 13322009 | 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 |
| 13324775 | 13324775 | 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 |
| 13324774 | 13324774 | 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 |
| 13324773 | 13324773 | 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 |
| 13324772 | 13324772 | 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 |
| 13322008 | 13322008 | 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 |
| 13322007 | 13322007 | 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 |
| 13322006 | 13322006 | 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 |
| 13322005 | 13322005 | 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 |
| 13324771 | 13324771 | 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 |
| 13322004 | 13322004 | 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 |
| 13322003 | 13322003 | 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 |
| 13322002 | 13322002 | 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 |
| 13322001 | 13322001 | 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 |
| 13322000 | 13322000 | 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 |
| 13324770 | 13324770 | 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 |
| 13321999 | 13321999 | 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 |
| 13321998 | 13321998 | 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 |
| 13321997 | 13321997 | 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 |
| 13324769 | 13324769 | 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 |
| 13321996 | 13321996 | 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 |
| 13324768 | 13324768 | 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 |
| 13324766 | 13324766 | 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 |
| 13324767 | 13324767 | 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 |
| 13321995 | 13321995 | 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 |
| 13321994 | 13321994 | 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 |
| 13324765 | 13324765 | 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 |
| 13321993 | 13321993 | 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 |
| 13324764 | 13324764 | 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 |
| 13321992 | 13321992 | 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 |
| 13324763 | 13324763 | 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 |
| 13324762 | 13324762 | 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 |
| 13321991 | 13321991 | 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 |
| 13321990 | 13321990 | 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 |
| 13321989 | 13321989 | 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 |
| 13321988 | 13321988 | 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 |
| 13321987 | 13321987 | 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 |
| 13324761 | 13324761 | 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 |
| 13321986 | 13321986 | 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 |
| 13324760 | 13324760 | 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 |
| 13324759 | 13324759 | 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 |
| 13324758 | 13324758 | 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 |
| 13321985 | 13321985 | 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 |
| 13321984 | 13321984 | 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 |
| 13321983 | 13321983 | 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 |
| 13324756 | 13324756 | 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 |
| 13324757 | 13324757 | 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 |
| 13324755 | 13324755 | 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 |
| 13324754 | 13324754 | 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 |
| 13321982 | 13321982 | 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 |
| 13321981 | 13321981 | 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 |
| 13321980 | 13321980 | 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 |
| 13321979 | 13321979 | 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 |
| 13324753 | 13324753 | 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 |
| 13321978 | 13321978 | 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 |
| 13321977 | 13321977 | 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 |
| 13321976 | 13321976 | 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 |
| 13321975 | 13321975 | 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 |
| 13324752 | 13324752 | 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 |
| 13321974 | 13321974 | 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 |
| 13324751 | 13324751 | 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 |
| 13324750 | 13324750 | 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 |
| 13321973 | 13321973 | 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 |
| 13324749 | 13324749 | 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 |
| 13324748 | 13324748 | 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 |
| 13321972 | 13321972 | 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 |
| 13321971 | 13321971 | 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 |
| 13324747 | 13324747 | 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 |
| 13321970 | 13321970 | 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 |
| 13324746 | 13324746 | 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 |
| 13324745 | 13324745 | 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 |
| 13321969 | 13321969 | 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 |
| 13324744 | 13324744 | 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 |
| 13321968 | 13321968 | 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 |
| 13324743 | 13324743 | 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 |
| 13324742 | 13324742 | 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 |
| 13324741 | 13324741 | 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 |
| 13324740 | 13324740 | 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 |
| 13324739 | 13324739 | 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 |
| 13321967 | 13321967 | 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 |
| 13321966 | 13321966 | 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 |
| 13324736 | 13324736 | 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 |
| 13324737 | 13324737 | 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 |
| 13324738 | 13324738 | 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 |
| 13321965 | 13321965 | 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 |
| 13321964 | 13321964 | 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 |
| 13321963 | 13321963 | 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 |
| 13321962 | 13321962 | 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 |
| 13321961 | 13321961 | 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 |
| 13321960 | 13321960 | 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 |
| 13324735 | 13324735 | 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 |
| 13321959 | 13321959 | 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 |
| 13321958 | 13321958 | 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 |
| 13321957 | 13321957 | 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 |
| 13324734 | 13324734 | 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");