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 = 1075 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 ▲ |
|---|---|---|---|---|---|---|---|---|---|
| 4085250 | 4085250 | 12 | 08:58:00 | 15.09.25 | 1 | 1.5 | Autobahn A2 1075 | 15.09.25 08:58:00 | 2025-09-15 08:58:00+02:00 |
| 4085249 | 4085249 | 57 | 08:57:57 | 15.09.25 | 1 | 6.4 | Autobahn A2 1075 | 15.09.25 08:57:57 | 2025-09-15 08:57:57+02:00 |
| 4085247 | 4085247 | 57 | 08:57:54 | 15.09.25 | 1 | 2.9 | Autobahn A2 1075 | 15.09.25 08:57:54 | 2025-09-15 08:57:54+02:00 |
| 4085248 | 4085248 | 50 | 08:57:54 | 15.09.25 | 1 | 0.9 | Autobahn A2 1075 | 15.09.25 08:57:54 | 2025-09-15 08:57:54+02:00 |
| 4085246 | 4085246 | 59 | 08:57:52 | 15.09.25 | 1 | 13.7 | Autobahn A2 1075 | 15.09.25 08:57:52 | 2025-09-15 08:57:52+02:00 |
| 4085245 | 4085245 | 69 | 08:57:51 | 15.09.25 | 1 | 3.1 | Autobahn A2 1075 | 15.09.25 08:57:51 | 2025-09-15 08:57:51+02:00 |
| 4085244 | 4085244 | 10 | 08:57:49 | 15.09.25 | 1 | 1.6 | Autobahn A2 1075 | 15.09.25 08:57:49 | 2025-09-15 08:57:49+02:00 |
| 4085243 | 4085243 | 66 | 08:57:46 | 15.09.25 | 1 | 19.2 | Autobahn A2 1075 | 15.09.25 08:57:46 | 2025-09-15 08:57:46+02:00 |
| 4085242 | 4085242 | 71 | 08:57:45 | 15.09.25 | 1 | 1.1 | Autobahn A2 1075 | 15.09.25 08:57:45 | 2025-09-15 08:57:45+02:00 |
| 4085241 | 4085241 | 74 | 08:57:44 | 15.09.25 | 1 | 4.3 | Autobahn A2 1075 | 15.09.25 08:57:44 | 2025-09-15 08:57:44+02:00 |
| 4085240 | 4085240 | 72 | 08:57:41 | 15.09.25 | 1 | 8.0 | Autobahn A2 1075 | 15.09.25 08:57:41 | 2025-09-15 08:57:41+02:00 |
| 4085239 | 4085239 | 59 | 08:57:40 | 15.09.25 | 1 | 10.0 | Autobahn A2 1075 | 15.09.25 08:57:40 | 2025-09-15 08:57:40+02:00 |
| 4085238 | 4085238 | 75 | 08:57:39 | 15.09.25 | 1 | 3.8 | Autobahn A2 1075 | 15.09.25 08:57:39 | 2025-09-15 08:57:39+02:00 |
| 4085237 | 4085237 | 68 | 08:57:38 | 15.09.25 | 1 | 13.8 | Autobahn A2 1075 | 15.09.25 08:57:38 | 2025-09-15 08:57:38+02:00 |
| 4085236 | 4085236 | 76 | 08:57:37 | 15.09.25 | 1 | 4.3 | Autobahn A2 1075 | 15.09.25 08:57:37 | 2025-09-15 08:57:37+02:00 |
| 4085235 | 4085235 | 17 | 08:57:33 | 15.09.25 | 1 | 0.9 | Autobahn A2 1075 | 15.09.25 08:57:33 | 2025-09-15 08:57:33+02:00 |
| 4085234 | 4085234 | 69 | 08:57:32 | 15.09.25 | 1 | 4.6 | Autobahn A2 1075 | 15.09.25 08:57:32 | 2025-09-15 08:57:32+02:00 |
| 4085233 | 4085233 | 38 | 08:57:31 | 15.09.25 | 1 | 0.5 | Autobahn A2 1075 | 15.09.25 08:57:31 | 2025-09-15 08:57:31+02:00 |
| 4085232 | 4085232 | 65 | 08:57:30 | 15.09.25 | 1 | 3.2 | Autobahn A2 1075 | 15.09.25 08:57:30 | 2025-09-15 08:57:30+02:00 |
| 4085231 | 4085231 | 75 | 08:57:29 | 15.09.25 | 1 | 1.8 | Autobahn A2 1075 | 15.09.25 08:57:29 | 2025-09-15 08:57:29+02:00 |
| 4085230 | 4085230 | 68 | 08:57:25 | 15.09.25 | 1 | 19.5 | Autobahn A2 1075 | 15.09.25 08:57:25 | 2025-09-15 08:57:25+02:00 |
| 4085229 | 4085229 | 74 | 08:57:23 | 15.09.25 | 1 | 3.5 | Autobahn A2 1075 | 15.09.25 08:57:23 | 2025-09-15 08:57:23+02:00 |
| 4085228 | 4085228 | 66 | 08:57:22 | 15.09.25 | 1 | 19.2 | Autobahn A2 1075 | 15.09.25 08:57:22 | 2025-09-15 08:57:22+02:00 |
| 4085227 | 4085227 | 63 | 08:57:19 | 15.09.25 | 1 | 18.5 | Autobahn A2 1075 | 15.09.25 08:57:19 | 2025-09-15 08:57:19+02:00 |
| 4085225 | 4085225 | 72 | 08:57:16 | 15.09.25 | 1 | 4.5 | Autobahn A2 1075 | 15.09.25 08:57:16 | 2025-09-15 08:57:16+02:00 |
| 4085226 | 4085226 | 78 | 08:57:16 | 15.09.25 | 1 | 4.1 | Autobahn A2 1075 | 15.09.25 08:57:16 | 2025-09-15 08:57:16+02:00 |
| 4085224 | 4085224 | 79 | 08:57:14 | 15.09.25 | 1 | 4.6 | Autobahn A2 1075 | 15.09.25 08:57:14 | 2025-09-15 08:57:14+02:00 |
| 4085223 | 4085223 | 71 | 08:57:13 | 15.09.25 | 1 | 0.6 | Autobahn A2 1075 | 15.09.25 08:57:13 | 2025-09-15 08:57:13+02:00 |
| 4085222 | 4085222 | 61 | 08:57:12 | 15.09.25 | 1 | 20.3 | Autobahn A2 1075 | 15.09.25 08:57:12 | 2025-09-15 08:57:12+02:00 |
| 4085221 | 4085221 | 79 | 08:57:10 | 15.09.25 | 1 | 3.4 | Autobahn A2 1075 | 15.09.25 08:57:10 | 2025-09-15 08:57:10+02:00 |
| 4085220 | 4085220 | 66 | 08:57:08 | 15.09.25 | 1 | 12.2 | Autobahn A2 1075 | 15.09.25 08:57:08 | 2025-09-15 08:57:08+02:00 |
| 4085219 | 4085219 | 62 | 08:57:06 | 15.09.25 | 1 | 8.8 | Autobahn A2 1075 | 15.09.25 08:57:06 | 2025-09-15 08:57:06+02:00 |
| 4085218 | 4085218 | 56 | 08:57:05 | 15.09.25 | 1 | 2.5 | Autobahn A2 1075 | 15.09.25 08:57:05 | 2025-09-15 08:57:05+02:00 |
| 4085217 | 4085217 | 54 | 08:57:00 | 15.09.25 | 1 | 21.3 | Autobahn A2 1075 | 15.09.25 08:57:00 | 2025-09-15 08:57:00+02:00 |
| 4085216 | 4085216 | 56 | 08:56:59 | 15.09.25 | 1 | 9.5 | Autobahn A2 1075 | 15.09.25 08:56:59 | 2025-09-15 08:56:59+02:00 |
| 4085215 | 4085215 | 55 | 08:56:57 | 15.09.25 | 1 | 6.3 | Autobahn A2 1075 | 15.09.25 08:56:57 | 2025-09-15 08:56:57+02:00 |
| 4085214 | 4085214 | 55 | 08:56:56 | 15.09.25 | 1 | 9.5 | Autobahn A2 1075 | 15.09.25 08:56:56 | 2025-09-15 08:56:56+02:00 |
| 4085213 | 4085213 | 69 | 08:56:55 | 15.09.25 | 1 | 2.0 | Autobahn A2 1075 | 15.09.25 08:56:55 | 2025-09-15 08:56:55+02:00 |
| 4085212 | 4085212 | 81 | 08:56:54 | 15.09.25 | 1 | 5.5 | Autobahn A2 1075 | 15.09.25 08:56:54 | 2025-09-15 08:56:54+02:00 |
| 4085211 | 4085211 | 84 | 08:56:53 | 15.09.25 | 1 | 3.3 | Autobahn A2 1075 | 15.09.25 08:56:53 | 2025-09-15 08:56:53+02:00 |
| 4085210 | 4085210 | 77 | 08:56:52 | 15.09.25 | 1 | 0.8 | Autobahn A2 1075 | 15.09.25 08:56:52 | 2025-09-15 08:56:52+02:00 |
| 4085209 | 4085209 | 72 | 08:56:50 | 15.09.25 | 1 | 3.8 | Autobahn A2 1075 | 15.09.25 08:56:50 | 2025-09-15 08:56:50+02:00 |
| 4085208 | 4085208 | 83 | 08:56:49 | 15.09.25 | 1 | 2.0 | Autobahn A2 1075 | 15.09.25 08:56:49 | 2025-09-15 08:56:49+02:00 |
| 4085207 | 4085207 | 83 | 08:56:47 | 15.09.25 | 1 | 5.0 | Autobahn A2 1075 | 15.09.25 08:56:47 | 2025-09-15 08:56:47+02:00 |
| 4085206 | 4085206 | 72 | 08:56:45 | 15.09.25 | 1 | 4.7 | Autobahn A2 1075 | 15.09.25 08:56:45 | 2025-09-15 08:56:45+02:00 |
| 4085205 | 4085205 | 71 | 08:56:40 | 15.09.25 | 1 | 5.4 | Autobahn A2 1075 | 15.09.25 08:56:40 | 2025-09-15 08:56:40+02:00 |
| 4085204 | 4085204 | 69 | 08:56:37 | 15.09.25 | 1 | 5.4 | Autobahn A2 1075 | 15.09.25 08:56:37 | 2025-09-15 08:56:37+02:00 |
| 4085203 | 4085203 | 65 | 08:56:35 | 15.09.25 | 1 | 4.1 | Autobahn A2 1075 | 15.09.25 08:56:35 | 2025-09-15 08:56:35+02:00 |
| 4085202 | 4085202 | 72 | 08:56:34 | 15.09.25 | 1 | 6.0 | Autobahn A2 1075 | 15.09.25 08:56:34 | 2025-09-15 08:56:34+02:00 |
| 4085201 | 4085201 | 74 | 08:56:33 | 15.09.25 | 1 | 2.4 | Autobahn A2 1075 | 15.09.25 08:56:33 | 2025-09-15 08:56:33+02:00 |
| 4085200 | 4085200 | 62 | 08:56:32 | 15.09.25 | 1 | 6.7 | Autobahn A2 1075 | 15.09.25 08:56:32 | 2025-09-15 08:56:32+02:00 |
| 4085199 | 4085199 | 66 | 08:56:30 | 15.09.25 | 1 | 12.0 | Autobahn A2 1075 | 15.09.25 08:56:30 | 2025-09-15 08:56:30+02:00 |
| 4085198 | 4085198 | 76 | 08:56:29 | 15.09.25 | 1 | 2.3 | Autobahn A2 1075 | 15.09.25 08:56:29 | 2025-09-15 08:56:29+02:00 |
| 4085197 | 4085197 | 80 | 08:56:28 | 15.09.25 | 1 | 6.1 | Autobahn A2 1075 | 15.09.25 08:56:28 | 2025-09-15 08:56:28+02:00 |
| 4085195 | 4085195 | 90 | 08:56:27 | 15.09.25 | 1 | 4.2 | Autobahn A2 1075 | 15.09.25 08:56:27 | 2025-09-15 08:56:27+02:00 |
| 4085196 | 4085196 | 68 | 08:56:27 | 15.09.25 | 1 | 1.2 | Autobahn A2 1075 | 15.09.25 08:56:27 | 2025-09-15 08:56:27+02:00 |
| 4085194 | 4085194 | 68 | 08:56:24 | 15.09.25 | 1 | 5.5 | Autobahn A2 1075 | 15.09.25 08:56:24 | 2025-09-15 08:56:24+02:00 |
| 4085193 | 4085193 | 74 | 08:56:23 | 15.09.25 | 1 | 7.5 | Autobahn A2 1075 | 15.09.25 08:56:23 | 2025-09-15 08:56:23+02:00 |
| 4085192 | 4085192 | 72 | 08:56:22 | 15.09.25 | 1 | 4.6 | Autobahn A2 1075 | 15.09.25 08:56:22 | 2025-09-15 08:56:22+02:00 |
| 4085191 | 4085191 | 59 | 08:56:21 | 15.09.25 | 1 | 1.6 | Autobahn A2 1075 | 15.09.25 08:56:21 | 2025-09-15 08:56:21+02:00 |
| 4085190 | 4085190 | 70 | 08:56:20 | 15.09.25 | 1 | 3.3 | Autobahn A2 1075 | 15.09.25 08:56:20 | 2025-09-15 08:56:20+02:00 |
| 4085189 | 4085189 | 67 | 08:56:19 | 15.09.25 | 1 | 13.4 | Autobahn A2 1075 | 15.09.25 08:56:19 | 2025-09-15 08:56:19+02:00 |
| 4085188 | 4085188 | 80 | 08:56:18 | 15.09.25 | 1 | 5.9 | Autobahn A2 1075 | 15.09.25 08:56:18 | 2025-09-15 08:56:18+02:00 |
| 4085186 | 4085186 | 71 | 08:56:17 | 15.09.25 | 1 | 5.0 | Autobahn A2 1075 | 15.09.25 08:56:17 | 2025-09-15 08:56:17+02:00 |
| 4085187 | 4085187 | 79 | 08:56:17 | 15.09.25 | 1 | 1.7 | Autobahn A2 1075 | 15.09.25 08:56:17 | 2025-09-15 08:56:17+02:00 |
| 4085185 | 4085185 | 71 | 08:56:16 | 15.09.25 | 1 | 4.5 | Autobahn A2 1075 | 15.09.25 08:56:16 | 2025-09-15 08:56:16+02:00 |
| 4085184 | 4085184 | 71 | 08:56:15 | 15.09.25 | 1 | 19.0 | Autobahn A2 1075 | 15.09.25 08:56:15 | 2025-09-15 08:56:15+02:00 |
| 4085183 | 4085183 | 69 | 08:56:10 | 15.09.25 | 1 | 4.0 | Autobahn A2 1075 | 15.09.25 08:56:10 | 2025-09-15 08:56:10+02:00 |
| 4085182 | 4085182 | 81 | 08:56:09 | 15.09.25 | 1 | 8.5 | Autobahn A2 1075 | 15.09.25 08:56:09 | 2025-09-15 08:56:09+02:00 |
| 4085181 | 4085181 | 61 | 08:56:07 | 15.09.25 | 1 | 5.4 | Autobahn A2 1075 | 15.09.25 08:56:07 | 2025-09-15 08:56:07+02:00 |
| 4085180 | 4085180 | 61 | 08:56:06 | 15.09.25 | 1 | 11.3 | Autobahn A2 1075 | 15.09.25 08:56:06 | 2025-09-15 08:56:06+02:00 |
| 4085179 | 4085179 | 67 | 08:56:04 | 15.09.25 | 1 | 1.7 | Autobahn A2 1075 | 15.09.25 08:56:04 | 2025-09-15 08:56:04+02:00 |
| 4085178 | 4085178 | 62 | 08:56:03 | 15.09.25 | 1 | 6.8 | Autobahn A2 1075 | 15.09.25 08:56:03 | 2025-09-15 08:56:03+02:00 |
| 4085177 | 4085177 | 68 | 08:56:02 | 15.09.25 | 1 | 3.9 | Autobahn A2 1075 | 15.09.25 08:56:02 | 2025-09-15 08:56:02+02:00 |
| 4085176 | 4085176 | 63 | 08:56:00 | 15.09.25 | 1 | 5.2 | Autobahn A2 1075 | 15.09.25 08:56:00 | 2025-09-15 08:56:00+02:00 |
| 4085175 | 4085175 | 64 | 08:55:59 | 15.09.25 | 1 | 19.6 | Autobahn A2 1075 | 15.09.25 08:55:59 | 2025-09-15 08:55:59+02:00 |
| 4085173 | 4085173 | 80 | 08:55:57 | 15.09.25 | 1 | 1.8 | Autobahn A2 1075 | 15.09.25 08:55:57 | 2025-09-15 08:55:57+02:00 |
| 4085174 | 4085174 | 83 | 08:55:57 | 15.09.25 | 1 | 4.5 | Autobahn A2 1075 | 15.09.25 08:55:57 | 2025-09-15 08:55:57+02:00 |
| 4085172 | 4085172 | 83 | 08:55:56 | 15.09.25 | 1 | 4.0 | Autobahn A2 1075 | 15.09.25 08:55:56 | 2025-09-15 08:55:56+02:00 |
| 4085171 | 4085171 | 63 | 08:55:54 | 15.09.25 | 1 | 7.0 | Autobahn A2 1075 | 15.09.25 08:55:54 | 2025-09-15 08:55:54+02:00 |
| 4085170 | 4085170 | 64 | 08:55:53 | 15.09.25 | 1 | 19.2 | Autobahn A2 1075 | 15.09.25 08:55:53 | 2025-09-15 08:55:53+02:00 |
| 4085169 | 4085169 | 74 | 08:55:51 | 15.09.25 | 1 | 0.5 | Autobahn A2 1075 | 15.09.25 08:55:51 | 2025-09-15 08:55:51+02:00 |
| 4085168 | 4085168 | 78 | 08:55:50 | 15.09.25 | 1 | 1.1 | Autobahn A2 1075 | 15.09.25 08:55:50 | 2025-09-15 08:55:50+02:00 |
| 4085167 | 4085167 | 71 | 08:55:49 | 15.09.25 | 1 | 1.3 | Autobahn A2 1075 | 15.09.25 08:55:49 | 2025-09-15 08:55:49+02:00 |
| 4085166 | 4085166 | 67 | 08:55:48 | 15.09.25 | 1 | 3.8 | Autobahn A2 1075 | 15.09.25 08:55:48 | 2025-09-15 08:55:48+02:00 |
| 4085165 | 4085165 | 73 | 08:55:46 | 15.09.25 | 1 | 4.4 | Autobahn A2 1075 | 15.09.25 08:55:46 | 2025-09-15 08:55:46+02:00 |
| 4085164 | 4085164 | 75 | 08:55:45 | 15.09.25 | 1 | 1.6 | Autobahn A2 1075 | 15.09.25 08:55:45 | 2025-09-15 08:55:45+02:00 |
| 4085163 | 4085163 | 66 | 08:55:41 | 15.09.25 | 1 | 2.2 | Autobahn A2 1075 | 15.09.25 08:55:41 | 2025-09-15 08:55:41+02:00 |
| 4085162 | 4085162 | 65 | 08:55:40 | 15.09.25 | 1 | 6.1 | Autobahn A2 1075 | 15.09.25 08:55:40 | 2025-09-15 08:55:40+02:00 |
| 4085161 | 4085161 | 63 | 08:55:38 | 15.09.25 | 1 | 11.8 | Autobahn A2 1075 | 15.09.25 08:55:38 | 2025-09-15 08:55:38+02:00 |
| 4085159 | 4085159 | 76 | 08:55:35 | 15.09.25 | 1 | 2.3 | Autobahn A2 1075 | 15.09.25 08:55:35 | 2025-09-15 08:55:35+02:00 |
| 4085160 | 4085160 | 71 | 08:55:35 | 15.09.25 | 1 | 0.7 | Autobahn A2 1075 | 15.09.25 08:55:35 | 2025-09-15 08:55:35+02:00 |
| 4085158 | 4085158 | 60 | 08:55:34 | 15.09.25 | 1 | 2.2 | Autobahn A2 1075 | 15.09.25 08:55:34 | 2025-09-15 08:55:34+02:00 |
| 4085157 | 4085157 | 74 | 08:55:33 | 15.09.25 | 1 | 19.1 | Autobahn A2 1075 | 15.09.25 08:55:33 | 2025-09-15 08:55:33+02:00 |
| 4085156 | 4085156 | 67 | 08:55:30 | 15.09.25 | 1 | 15.7 | Autobahn A2 1075 | 15.09.25 08:55:30 | 2025-09-15 08:55:30+02:00 |
| 4085155 | 4085155 | 72 | 08:55:29 | 15.09.25 | 1 | 1.4 | Autobahn A2 1075 | 15.09.25 08:55:29 | 2025-09-15 08:55:29+02:00 |
| 4085153 | 4085153 | 67 | 08:55:25 | 15.09.25 | 1 | 4.8 | Autobahn A2 1075 | 15.09.25 08:55:25 | 2025-09-15 08:55:25+02:00 |
| 4085154 | 4085154 | 57 | 08:55:25 | 15.09.25 | 1 | 5.1 | Autobahn A2 1075 | 15.09.25 08:55:25 | 2025-09-15 08:55:25+02:00 |
| 4085152 | 4085152 | 54 | 08:55:24 | 15.09.25 | 1 | 3.7 | Autobahn A2 1075 | 15.09.25 08:55:24 | 2025-09-15 08:55:24+02:00 |
| 4085151 | 4085151 | 59 | 08:55:22 | 15.09.25 | 1 | 5.0 | Autobahn A2 1075 | 15.09.25 08:55:22 | 2025-09-15 08:55:22+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");