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 ▲ |
|---|---|---|---|---|---|---|---|---|---|
| 29720972 | 29720972 | 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 |
| 29720971 | 29720971 | 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 |
| 29718207 | 29718207 | 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 |
| 29718206 | 29718206 | 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 |
| 29718205 | 29718205 | 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 |
| 29718204 | 29718204 | 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 |
| 29720970 | 29720970 | 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 |
| 29720969 | 29720969 | 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 |
| 29720968 | 29720968 | 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 |
| 29720967 | 29720967 | 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 |
| 29718203 | 29718203 | 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 |
| 29718202 | 29718202 | 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 |
| 29718201 | 29718201 | 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 |
| 29718200 | 29718200 | 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 |
| 29720966 | 29720966 | 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 |
| 29718199 | 29718199 | 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 |
| 29718198 | 29718198 | 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 |
| 29718197 | 29718197 | 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 |
| 29718196 | 29718196 | 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 |
| 29718195 | 29718195 | 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 |
| 29720965 | 29720965 | 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 |
| 29718194 | 29718194 | 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 |
| 29718193 | 29718193 | 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 |
| 29718192 | 29718192 | 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 |
| 29720964 | 29720964 | 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 |
| 29718191 | 29718191 | 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 |
| 29720963 | 29720963 | 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 |
| 29720961 | 29720961 | 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 |
| 29720962 | 29720962 | 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 |
| 29718190 | 29718190 | 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 |
| 29718189 | 29718189 | 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 |
| 29720960 | 29720960 | 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 |
| 29718188 | 29718188 | 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 |
| 29720959 | 29720959 | 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 |
| 29718187 | 29718187 | 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 |
| 29720958 | 29720958 | 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 |
| 29720957 | 29720957 | 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 |
| 29718186 | 29718186 | 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 |
| 29718185 | 29718185 | 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 |
| 29718184 | 29718184 | 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 |
| 29718183 | 29718183 | 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 |
| 29718182 | 29718182 | 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 |
| 29720956 | 29720956 | 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 |
| 29718181 | 29718181 | 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 |
| 29720955 | 29720955 | 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 |
| 29720954 | 29720954 | 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 |
| 29720953 | 29720953 | 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 |
| 29718180 | 29718180 | 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 |
| 29718179 | 29718179 | 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 |
| 29718178 | 29718178 | 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 |
| 29720951 | 29720951 | 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 |
| 29720952 | 29720952 | 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 |
| 29720950 | 29720950 | 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 |
| 29720949 | 29720949 | 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 |
| 29718177 | 29718177 | 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 |
| 29718176 | 29718176 | 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 |
| 29718175 | 29718175 | 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 |
| 29718174 | 29718174 | 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 |
| 29720948 | 29720948 | 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 |
| 29718173 | 29718173 | 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 |
| 29718172 | 29718172 | 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 |
| 29718171 | 29718171 | 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 |
| 29718170 | 29718170 | 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 |
| 29720947 | 29720947 | 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 |
| 29718169 | 29718169 | 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 |
| 29720946 | 29720946 | 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 |
| 29720945 | 29720945 | 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 |
| 29718168 | 29718168 | 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 |
| 29720944 | 29720944 | 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 |
| 29720943 | 29720943 | 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 |
| 29718167 | 29718167 | 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 |
| 29718166 | 29718166 | 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 |
| 29720942 | 29720942 | 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 |
| 29718165 | 29718165 | 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 |
| 29720941 | 29720941 | 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 |
| 29720940 | 29720940 | 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 |
| 29718164 | 29718164 | 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 |
| 29720939 | 29720939 | 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 |
| 29718163 | 29718163 | 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 |
| 29720938 | 29720938 | 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 |
| 29720937 | 29720937 | 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 |
| 29720936 | 29720936 | 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 |
| 29720935 | 29720935 | 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 |
| 29720934 | 29720934 | 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 |
| 29718162 | 29718162 | 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 |
| 29718161 | 29718161 | 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 |
| 29720931 | 29720931 | 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 |
| 29720932 | 29720932 | 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 |
| 29720933 | 29720933 | 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 |
| 29718160 | 29718160 | 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 |
| 29718159 | 29718159 | 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 |
| 29718158 | 29718158 | 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 |
| 29718157 | 29718157 | 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 |
| 29718156 | 29718156 | 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 |
| 29718155 | 29718155 | 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 |
| 29720930 | 29720930 | 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 |
| 29718154 | 29718154 | 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 |
| 29718153 | 29718153 | 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 |
| 29718152 | 29718152 | 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 |
| 29720929 | 29720929 | 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");