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 = 38 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 ▲ |
|---|---|---|---|---|---|---|---|---|---|
| 34313368 | 34313368 | 28 | 17:54:10 | 30.01.20 | 1 | 4.9 | 38 38 | 30.01.20 17:54:10 | 2020-01-30 17:54:10+01:00 |
| 34313367 | 34313367 | 25 | 17:51:40 | 30.01.20 | 1 | 5.1 | 38 38 | 30.01.20 17:51:40 | 2020-01-30 17:51:40+01:00 |
| 34313366 | 34313366 | 21 | 17:49:58 | 30.01.20 | 1 | 4.6 | 38 38 | 30.01.20 17:49:58 | 2020-01-30 17:49:58+01:00 |
| 34313365 | 34313365 | 27 | 17:49:34 | 30.01.20 | 1 | 4.5 | 38 38 | 30.01.20 17:49:34 | 2020-01-30 17:49:34+01:00 |
| 34313364 | 34313364 | 19 | 17:48:41 | 30.01.20 | 1 | 5.0 | 38 38 | 30.01.20 17:48:41 | 2020-01-30 17:48:41+01:00 |
| 34313363 | 34313363 | 25 | 17:48:25 | 30.01.20 | 1 | 4.3 | 38 38 | 30.01.20 17:48:25 | 2020-01-30 17:48:25+01:00 |
| 34313362 | 34313362 | 15 | 17:47:42 | 30.01.20 | 1 | 5.1 | 38 38 | 30.01.20 17:47:42 | 2020-01-30 17:47:42+01:00 |
| 34313361 | 34313361 | 17 | 17:47:24 | 30.01.20 | 1 | 4.1 | 38 38 | 30.01.20 17:47:24 | 2020-01-30 17:47:24+01:00 |
| 34313360 | 34313360 | 17 | 17:47:21 | 30.01.20 | 1 | 4.0 | 38 38 | 30.01.20 17:47:21 | 2020-01-30 17:47:21+01:00 |
| 34313359 | 34313359 | 21 | 17:46:23 | 30.01.20 | 1 | 10.6 | 38 38 | 30.01.20 17:46:23 | 2020-01-30 17:46:23+01:00 |
| 34313358 | 34313358 | 16 | 17:45:59 | 30.01.20 | 1 | 2.2 | 38 38 | 30.01.20 17:45:59 | 2020-01-30 17:45:59+01:00 |
| 34313357 | 34313357 | 21 | 17:45:41 | 30.01.20 | 1 | 3.8 | 38 38 | 30.01.20 17:45:41 | 2020-01-30 17:45:41+01:00 |
| 34313356 | 34313356 | 22 | 17:45:39 | 30.01.20 | 1 | 4.9 | 38 38 | 30.01.20 17:45:39 | 2020-01-30 17:45:39+01:00 |
| 34313355 | 34313355 | 28 | 17:45:15 | 30.01.20 | 1 | 3.5 | 38 38 | 30.01.20 17:45:15 | 2020-01-30 17:45:15+01:00 |
| 34313354 | 34313354 | 21 | 17:45:11 | 30.01.20 | 1 | 6.6 | 38 38 | 30.01.20 17:45:11 | 2020-01-30 17:45:11+01:00 |
| 34313353 | 34313353 | 22 | 17:44:47 | 30.01.20 | 1 | 4.4 | 38 38 | 30.01.20 17:44:47 | 2020-01-30 17:44:47+01:00 |
| 34313352 | 34313352 | 27 | 17:44:30 | 30.01.20 | 1 | 3.4 | 38 38 | 30.01.20 17:44:30 | 2020-01-30 17:44:30+01:00 |
| 34313351 | 34313351 | 22 | 17:44:03 | 30.01.20 | 1 | 4.0 | 38 38 | 30.01.20 17:44:03 | 2020-01-30 17:44:03+01:00 |
| 34313350 | 34313350 | 24 | 17:42:27 | 30.01.20 | 1 | 4.3 | 38 38 | 30.01.20 17:42:27 | 2020-01-30 17:42:27+01:00 |
| 34313349 | 34313349 | 20 | 17:42:24 | 30.01.20 | 1 | 3.5 | 38 38 | 30.01.20 17:42:24 | 2020-01-30 17:42:24+01:00 |
| 34313348 | 34313348 | 15 | 17:42:21 | 30.01.20 | 1 | 4.0 | 38 38 | 30.01.20 17:42:21 | 2020-01-30 17:42:21+01:00 |
| 34313347 | 34313347 | 24 | 17:41:45 | 30.01.20 | 1 | 2.9 | 38 38 | 30.01.20 17:41:45 | 2020-01-30 17:41:45+01:00 |
| 34313346 | 34313346 | 10 | 17:40:43 | 30.01.20 | 1 | 1.8 | 38 38 | 30.01.20 17:40:43 | 2020-01-30 17:40:43+01:00 |
| 34313345 | 34313345 | 10 | 17:40:34 | 30.01.20 | 1 | 5.4 | 38 38 | 30.01.20 17:40:34 | 2020-01-30 17:40:34+01:00 |
| 34313344 | 34313344 | 14 | 17:40:30 | 30.01.20 | 1 | 2.9 | 38 38 | 30.01.20 17:40:30 | 2020-01-30 17:40:30+01:00 |
| 34313343 | 34313343 | 23 | 17:39:45 | 30.01.20 | 1 | 5.8 | 38 38 | 30.01.20 17:39:45 | 2020-01-30 17:39:45+01:00 |
| 34313342 | 34313342 | 27 | 17:39:34 | 30.01.20 | 1 | 3.4 | 38 38 | 30.01.20 17:39:34 | 2020-01-30 17:39:34+01:00 |
| 34313341 | 34313341 | 26 | 17:39:25 | 30.01.20 | 1 | 3.8 | 38 38 | 30.01.20 17:39:25 | 2020-01-30 17:39:25+01:00 |
| 34313340 | 34313340 | 28 | 17:39:21 | 30.01.20 | 1 | 5.1 | 38 38 | 30.01.20 17:39:21 | 2020-01-30 17:39:21+01:00 |
| 34313339 | 34313339 | 37 | 17:38:55 | 30.01.20 | 1 | 4.2 | 38 38 | 30.01.20 17:38:55 | 2020-01-30 17:38:55+01:00 |
| 34313338 | 34313338 | 26 | 17:38:40 | 30.01.20 | 1 | 3.5 | 38 38 | 30.01.20 17:38:40 | 2020-01-30 17:38:40+01:00 |
| 34313337 | 34313337 | 23 | 17:38:18 | 30.01.20 | 1 | 3.6 | 38 38 | 30.01.20 17:38:18 | 2020-01-30 17:38:18+01:00 |
| 34313336 | 34313336 | 23 | 17:37:16 | 30.01.20 | 1 | 3.1 | 38 38 | 30.01.20 17:37:16 | 2020-01-30 17:37:16+01:00 |
| 34313335 | 34313335 | 25 | 17:36:58 | 30.01.20 | 1 | 4.9 | 38 38 | 30.01.20 17:36:58 | 2020-01-30 17:36:58+01:00 |
| 34313334 | 34313334 | 36 | 17:36:42 | 30.01.20 | 1 | 4.3 | 38 38 | 30.01.20 17:36:42 | 2020-01-30 17:36:42+01:00 |
| 34313333 | 34313333 | 26 | 17:34:58 | 30.01.20 | 1 | 5.9 | 38 38 | 30.01.20 17:34:58 | 2020-01-30 17:34:58+01:00 |
| 34313332 | 34313332 | 25 | 17:34:39 | 30.01.20 | 1 | 3.8 | 38 38 | 30.01.20 17:34:39 | 2020-01-30 17:34:39+01:00 |
| 34313331 | 34313331 | 19 | 17:34:20 | 30.01.20 | 1 | 4.0 | 38 38 | 30.01.20 17:34:20 | 2020-01-30 17:34:20+01:00 |
| 34313330 | 34313330 | 16 | 17:34:04 | 30.01.20 | 1 | 1.4 | 38 38 | 30.01.20 17:34:04 | 2020-01-30 17:34:04+01:00 |
| 34313329 | 34313329 | 30 | 17:33:49 | 30.01.20 | 1 | 4.9 | 38 38 | 30.01.20 17:33:49 | 2020-01-30 17:33:49+01:00 |
| 34313328 | 34313328 | 30 | 17:33:05 | 30.01.20 | 1 | 4.8 | 38 38 | 30.01.20 17:33:05 | 2020-01-30 17:33:05+01:00 |
| 34313327 | 34313327 | 27 | 17:32:53 | 30.01.20 | 1 | 4.2 | 38 38 | 30.01.20 17:32:53 | 2020-01-30 17:32:53+01:00 |
| 34313326 | 34313326 | 20 | 17:32:28 | 30.01.20 | 1 | 1.6 | 38 38 | 30.01.20 17:32:28 | 2020-01-30 17:32:28+01:00 |
| 34313325 | 34313325 | 16 | 17:32:12 | 30.01.20 | 1 | 0.7 | 38 38 | 30.01.20 17:32:12 | 2020-01-30 17:32:12+01:00 |
| 34313324 | 34313324 | 26 | 17:30:04 | 30.01.20 | 1 | 10.6 | 38 38 | 30.01.20 17:30:04 | 2020-01-30 17:30:04+01:00 |
| 34313323 | 34313323 | 25 | 17:29:32 | 30.01.20 | 1 | 5.8 | 38 38 | 30.01.20 17:29:32 | 2020-01-30 17:29:32+01:00 |
| 34313322 | 34313322 | 27 | 17:29:05 | 30.01.20 | 1 | 6.1 | 38 38 | 30.01.20 17:29:05 | 2020-01-30 17:29:05+01:00 |
| 34313321 | 34313321 | 24 | 17:28:54 | 30.01.20 | 1 | 5.7 | 38 38 | 30.01.20 17:28:54 | 2020-01-30 17:28:54+01:00 |
| 34313320 | 34313320 | 27 | 17:28:02 | 30.01.20 | 1 | 4.5 | 38 38 | 30.01.20 17:28:02 | 2020-01-30 17:28:02+01:00 |
| 34313319 | 34313319 | 27 | 17:27:48 | 30.01.20 | 1 | 5.2 | 38 38 | 30.01.20 17:27:48 | 2020-01-30 17:27:48+01:00 |
| 34313318 | 34313318 | 21 | 17:27:17 | 30.01.20 | 1 | 4.5 | 38 38 | 30.01.20 17:27:17 | 2020-01-30 17:27:17+01:00 |
| 34313317 | 34313317 | 26 | 17:26:19 | 30.01.20 | 1 | 5.4 | 38 38 | 30.01.20 17:26:19 | 2020-01-30 17:26:19+01:00 |
| 34313316 | 34313316 | 24 | 17:26:08 | 30.01.20 | 1 | 4.6 | 38 38 | 30.01.20 17:26:08 | 2020-01-30 17:26:08+01:00 |
| 34313315 | 34313315 | 24 | 17:25:46 | 30.01.20 | 1 | 3.4 | 38 38 | 30.01.20 17:25:46 | 2020-01-30 17:25:46+01:00 |
| 34313314 | 34313314 | 22 | 17:25:28 | 30.01.20 | 1 | 5.8 | 38 38 | 30.01.20 17:25:28 | 2020-01-30 17:25:28+01:00 |
| 34313313 | 34313313 | 23 | 17:25:15 | 30.01.20 | 1 | 4.2 | 38 38 | 30.01.20 17:25:15 | 2020-01-30 17:25:15+01:00 |
| 34313312 | 34313312 | 18 | 17:24:59 | 30.01.20 | 1 | 1.5 | 38 38 | 30.01.20 17:24:59 | 2020-01-30 17:24:59+01:00 |
| 34313311 | 34313311 | 29 | 17:24:45 | 30.01.20 | 1 | 5.2 | 38 38 | 30.01.20 17:24:45 | 2020-01-30 17:24:45+01:00 |
| 34313310 | 34313310 | 32 | 17:24:18 | 30.01.20 | 1 | 2.1 | 38 38 | 30.01.20 17:24:18 | 2020-01-30 17:24:18+01:00 |
| 34313309 | 34313309 | 23 | 17:24:02 | 30.01.20 | 1 | 5.1 | 38 38 | 30.01.20 17:24:02 | 2020-01-30 17:24:02+01:00 |
| 34313308 | 34313308 | 25 | 17:24:00 | 30.01.20 | 1 | 4.9 | 38 38 | 30.01.20 17:24:00 | 2020-01-30 17:24:00+01:00 |
| 34313307 | 34313307 | 26 | 17:23:41 | 30.01.20 | 1 | 4.9 | 38 38 | 30.01.20 17:23:41 | 2020-01-30 17:23:41+01:00 |
| 34313306 | 34313306 | 24 | 17:22:48 | 30.01.20 | 1 | 4.8 | 38 38 | 30.01.20 17:22:48 | 2020-01-30 17:22:48+01:00 |
| 34313305 | 34313305 | 24 | 17:22:23 | 30.01.20 | 1 | 2.0 | 38 38 | 30.01.20 17:22:23 | 2020-01-30 17:22:23+01:00 |
| 34313304 | 34313304 | 28 | 17:22:10 | 30.01.20 | 1 | 4.5 | 38 38 | 30.01.20 17:22:10 | 2020-01-30 17:22:10+01:00 |
| 34313303 | 34313303 | 20 | 17:21:51 | 30.01.20 | 1 | 4.9 | 38 38 | 30.01.20 17:21:51 | 2020-01-30 17:21:51+01:00 |
| 34313302 | 34313302 | 23 | 17:20:29 | 30.01.20 | 1 | 2.9 | 38 38 | 30.01.20 17:20:29 | 2020-01-30 17:20:29+01:00 |
| 34313301 | 34313301 | 30 | 17:20:17 | 30.01.20 | 1 | 2.6 | 38 38 | 30.01.20 17:20:17 | 2020-01-30 17:20:17+01:00 |
| 34313300 | 34313300 | 27 | 17:19:04 | 30.01.20 | 1 | 2.9 | 38 38 | 30.01.20 17:19:04 | 2020-01-30 17:19:04+01:00 |
| 34313299 | 34313299 | 25 | 17:18:54 | 30.01.20 | 1 | 1.7 | 38 38 | 30.01.20 17:18:54 | 2020-01-30 17:18:54+01:00 |
| 34313298 | 34313298 | 22 | 17:17:55 | 30.01.20 | 1 | 6.1 | 38 38 | 30.01.20 17:17:55 | 2020-01-30 17:17:55+01:00 |
| 34313297 | 34313297 | 30 | 17:17:40 | 30.01.20 | 1 | 6.4 | 38 38 | 30.01.20 17:17:40 | 2020-01-30 17:17:40+01:00 |
| 34313296 | 34313296 | 19 | 17:16:47 | 30.01.20 | 1 | 8.0 | 38 38 | 30.01.20 17:16:47 | 2020-01-30 17:16:47+01:00 |
| 34313295 | 34313295 | 23 | 17:15:08 | 30.01.20 | 1 | 2.0 | 38 38 | 30.01.20 17:15:08 | 2020-01-30 17:15:08+01:00 |
| 34313294 | 34313294 | 23 | 17:14:19 | 30.01.20 | 1 | 3.6 | 38 38 | 30.01.20 17:14:19 | 2020-01-30 17:14:19+01:00 |
| 34313293 | 34313293 | 30 | 17:13:47 | 30.01.20 | 1 | 3.6 | 38 38 | 30.01.20 17:13:47 | 2020-01-30 17:13:47+01:00 |
| 34313292 | 34313292 | 23 | 17:12:23 | 30.01.20 | 1 | 3.1 | 38 38 | 30.01.20 17:12:23 | 2020-01-30 17:12:23+01:00 |
| 34313291 | 34313291 | 25 | 17:11:38 | 30.01.20 | 1 | 0.8 | 38 38 | 30.01.20 17:11:38 | 2020-01-30 17:11:38+01:00 |
| 34313290 | 34313290 | 20 | 17:10:59 | 30.01.20 | 1 | 4.1 | 38 38 | 30.01.20 17:10:59 | 2020-01-30 17:10:59+01:00 |
| 34313289 | 34313289 | 19 | 17:10:25 | 30.01.20 | 1 | 6.4 | 38 38 | 30.01.20 17:10:25 | 2020-01-30 17:10:25+01:00 |
| 34313288 | 34313288 | 31 | 17:09:53 | 30.01.20 | 1 | 4.6 | 38 38 | 30.01.20 17:09:53 | 2020-01-30 17:09:53+01:00 |
| 34313287 | 34313287 | 26 | 17:09:50 | 30.01.20 | 1 | 5.1 | 38 38 | 30.01.20 17:09:50 | 2020-01-30 17:09:50+01:00 |
| 34313286 | 34313286 | 24 | 17:09:44 | 30.01.20 | 1 | 1.3 | 38 38 | 30.01.20 17:09:44 | 2020-01-30 17:09:44+01:00 |
| 34313285 | 34313285 | 30 | 17:09:39 | 30.01.20 | 1 | 2.6 | 38 38 | 30.01.20 17:09:39 | 2020-01-30 17:09:39+01:00 |
| 34313284 | 34313284 | 21 | 17:09:35 | 30.01.20 | 1 | 5.3 | 38 38 | 30.01.20 17:09:35 | 2020-01-30 17:09:35+01:00 |
| 34313283 | 34313283 | 21 | 17:08:39 | 30.01.20 | 1 | 3.5 | 38 38 | 30.01.20 17:08:39 | 2020-01-30 17:08:39+01:00 |
| 34313282 | 34313282 | 17 | 17:08:25 | 30.01.20 | 1 | 2.3 | 38 38 | 30.01.20 17:08:25 | 2020-01-30 17:08:25+01:00 |
| 34313281 | 34313281 | 34 | 17:07:36 | 30.01.20 | 1 | 3.4 | 38 38 | 30.01.20 17:07:36 | 2020-01-30 17:07:36+01:00 |
| 34313280 | 34313280 | 31 | 17:07:12 | 30.01.20 | 1 | 6.2 | 38 38 | 30.01.20 17:07:12 | 2020-01-30 17:07:12+01:00 |
| 34313279 | 34313279 | 22 | 17:06:42 | 30.01.20 | 1 | 5.0 | 38 38 | 30.01.20 17:06:42 | 2020-01-30 17:06:42+01:00 |
| 34313278 | 34313278 | 23 | 17:06:37 | 30.01.20 | 1 | 4.5 | 38 38 | 30.01.20 17:06:37 | 2020-01-30 17:06:37+01:00 |
| 34313277 | 34313277 | 25 | 17:06:32 | 30.01.20 | 1 | 3.5 | 38 38 | 30.01.20 17:06:32 | 2020-01-30 17:06:32+01:00 |
| 34313276 | 34313276 | 28 | 17:06:08 | 30.01.20 | 1 | 4.5 | 38 38 | 30.01.20 17:06:08 | 2020-01-30 17:06:08+01:00 |
| 34313275 | 34313275 | 30 | 17:05:57 | 30.01.20 | 1 | 5.0 | 38 38 | 30.01.20 17:05:57 | 2020-01-30 17:05:57+01:00 |
| 34313274 | 34313274 | 22 | 17:05:36 | 30.01.20 | 1 | 3.6 | 38 38 | 30.01.20 17:05:36 | 2020-01-30 17:05:36+01:00 |
| 34313273 | 34313273 | 24 | 17:05:28 | 30.01.20 | 1 | 5.0 | 38 38 | 30.01.20 17:05:28 | 2020-01-30 17:05:28+01:00 |
| 34313272 | 34313272 | 26 | 17:04:44 | 30.01.20 | 1 | 2.6 | 38 38 | 30.01.20 17:04:44 | 2020-01-30 17:04:44+01:00 |
| 34313271 | 34313271 | 25 | 17:04:00 | 30.01.20 | 1 | 3.7 | 38 38 | 30.01.20 17:04:00 | 2020-01-30 17:04:00+01:00 |
| 34313270 | 34313270 | 23 | 17:02:59 | 30.01.20 | 1 | 3.4 | 38 38 | 30.01.20 17:02:59 | 2020-01-30 17:02:59+01:00 |
| 34313269 | 34313269 | 26 | 17:02:32 | 30.01.20 | 1 | 4.0 | 38 38 | 30.01.20 17:02:32 | 2020-01-30 17:02:32+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");