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
5,659 rows where Messung-ID = 32 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 ▲ |
|---|---|---|---|---|---|---|---|---|---|
| 34316466 | 34316466 | 38 | 19:43:09 | 23.01.20 | 1 | 4.6 | 32 32 | 23.01.20 19:43:09 | 2020-01-23 19:43:09+01:00 |
| 34316465 | 34316465 | 30 | 19:39:57 | 23.01.20 | 1 | 8.1 | 32 32 | 23.01.20 19:39:57 | 2020-01-23 19:39:57+01:00 |
| 34319027 | 34319027 | 38 | 19:31:10 | 23.01.20 | 2 | 4.0 | 32 32 | 23.01.20 19:31:10 | 2020-01-23 19:31:10+01:00 |
| 34319026 | 34319026 | 29 | 19:31:07 | 23.01.20 | 2 | 4.1 | 32 32 | 23.01.20 19:31:07 | 2020-01-23 19:31:07+01:00 |
| 34316464 | 34316464 | 29 | 19:30:51 | 23.01.20 | 1 | 4.4 | 32 32 | 23.01.20 19:30:51 | 2020-01-23 19:30:51+01:00 |
| 34316463 | 34316463 | 34 | 19:30:04 | 23.01.20 | 1 | 4.5 | 32 32 | 23.01.20 19:30:04 | 2020-01-23 19:30:04+01:00 |
| 34319025 | 34319025 | 33 | 19:27:14 | 23.01.20 | 2 | 4.9 | 32 32 | 23.01.20 19:27:14 | 2020-01-23 19:27:14+01:00 |
| 34316462 | 34316462 | 31 | 19:22:41 | 23.01.20 | 1 | 3.5 | 32 32 | 23.01.20 19:22:41 | 2020-01-23 19:22:41+01:00 |
| 34319024 | 34319024 | 42 | 19:17:47 | 23.01.20 | 2 | 4.4 | 32 32 | 23.01.20 19:17:47 | 2020-01-23 19:17:47+01:00 |
| 34319023 | 34319023 | 36 | 19:15:01 | 23.01.20 | 2 | 4.2 | 32 32 | 23.01.20 19:15:01 | 2020-01-23 19:15:01+01:00 |
| 34316461 | 34316461 | 36 | 19:14:56 | 23.01.20 | 1 | 4.2 | 32 32 | 23.01.20 19:14:56 | 2020-01-23 19:14:56+01:00 |
| 34316460 | 34316460 | 29 | 19:09:54 | 23.01.20 | 1 | 5.0 | 32 32 | 23.01.20 19:09:54 | 2020-01-23 19:09:54+01:00 |
| 34319022 | 34319022 | 39 | 19:07:31 | 23.01.20 | 2 | 4.7 | 32 32 | 23.01.20 19:07:31 | 2020-01-23 19:07:31+01:00 |
| 34316459 | 34316459 | 35 | 19:06:14 | 23.01.20 | 1 | 5.0 | 32 32 | 23.01.20 19:06:14 | 2020-01-23 19:06:14+01:00 |
| 34316458 | 34316458 | 36 | 18:58:57 | 23.01.20 | 1 | 4.7 | 32 32 | 23.01.20 18:58:57 | 2020-01-23 18:58:57+01:00 |
| 34319021 | 34319021 | 35 | 18:58:00 | 23.01.20 | 2 | 4.1 | 32 32 | 23.01.20 18:58:00 | 2020-01-23 18:58:00+01:00 |
| 34316457 | 34316457 | 34 | 18:57:12 | 23.01.20 | 1 | 7.9 | 32 32 | 23.01.20 18:57:12 | 2020-01-23 18:57:12+01:00 |
| 34316456 | 34316456 | 38 | 18:55:44 | 23.01.20 | 1 | 4.9 | 32 32 | 23.01.20 18:55:44 | 2020-01-23 18:55:44+01:00 |
| 34316455 | 34316455 | 40 | 18:52:52 | 23.01.20 | 1 | 4.5 | 32 32 | 23.01.20 18:52:52 | 2020-01-23 18:52:52+01:00 |
| 34316454 | 34316454 | 34 | 18:50:38 | 23.01.20 | 1 | 5.6 | 32 32 | 23.01.20 18:50:38 | 2020-01-23 18:50:38+01:00 |
| 34319020 | 34319020 | 37 | 18:48:46 | 23.01.20 | 2 | 3.9 | 32 32 | 23.01.20 18:48:46 | 2020-01-23 18:48:46+01:00 |
| 34319019 | 34319019 | 30 | 18:48:11 | 23.01.20 | 2 | 4.0 | 32 32 | 23.01.20 18:48:11 | 2020-01-23 18:48:11+01:00 |
| 34316453 | 34316453 | 33 | 18:47:17 | 23.01.20 | 1 | 4.4 | 32 32 | 23.01.20 18:47:17 | 2020-01-23 18:47:17+01:00 |
| 34319018 | 34319018 | 35 | 18:46:19 | 23.01.20 | 2 | 4.5 | 32 32 | 23.01.20 18:46:19 | 2020-01-23 18:46:19+01:00 |
| 34319017 | 34319017 | 36 | 18:45:28 | 23.01.20 | 2 | 4.5 | 32 32 | 23.01.20 18:45:28 | 2020-01-23 18:45:28+01:00 |
| 34316452 | 34316452 | 20 | 18:44:56 | 23.01.20 | 1 | 0.7 | 32 32 | 23.01.20 18:44:56 | 2020-01-23 18:44:56+01:00 |
| 34319016 | 34319016 | 37 | 18:42:29 | 23.01.20 | 2 | 4.3 | 32 32 | 23.01.20 18:42:29 | 2020-01-23 18:42:29+01:00 |
| 34319015 | 34319015 | 30 | 18:38:15 | 23.01.20 | 2 | 3.3 | 32 32 | 23.01.20 18:38:15 | 2020-01-23 18:38:15+01:00 |
| 34319014 | 34319014 | 28 | 18:35:15 | 23.01.20 | 2 | 5.2 | 32 32 | 23.01.20 18:35:15 | 2020-01-23 18:35:15+01:00 |
| 34319013 | 34319013 | 31 | 18:34:48 | 23.01.20 | 2 | 4.0 | 32 32 | 23.01.20 18:34:48 | 2020-01-23 18:34:48+01:00 |
| 34319012 | 34319012 | 35 | 18:33:30 | 23.01.20 | 2 | 3.7 | 32 32 | 23.01.20 18:33:30 | 2020-01-23 18:33:30+01:00 |
| 34319011 | 34319011 | 40 | 18:27:18 | 23.01.20 | 2 | 3.9 | 32 32 | 23.01.20 18:27:18 | 2020-01-23 18:27:18+01:00 |
| 34316451 | 34316451 | 35 | 18:26:16 | 23.01.20 | 1 | 3.8 | 32 32 | 23.01.20 18:26:16 | 2020-01-23 18:26:16+01:00 |
| 34316450 | 34316450 | 39 | 18:25:48 | 23.01.20 | 1 | 0.6 | 32 32 | 23.01.20 18:25:48 | 2020-01-23 18:25:48+01:00 |
| 34316449 | 34316449 | 43 | 18:25:45 | 23.01.20 | 1 | 5.1 | 32 32 | 23.01.20 18:25:45 | 2020-01-23 18:25:45+01:00 |
| 34319010 | 34319010 | 48 | 18:25:26 | 23.01.20 | 2 | 5.0 | 32 32 | 23.01.20 18:25:26 | 2020-01-23 18:25:26+01:00 |
| 34319009 | 34319009 | 39 | 18:24:19 | 23.01.20 | 2 | 4.4 | 32 32 | 23.01.20 18:24:19 | 2020-01-23 18:24:19+01:00 |
| 34316448 | 34316448 | 30 | 18:23:47 | 23.01.20 | 1 | 4.0 | 32 32 | 23.01.20 18:23:47 | 2020-01-23 18:23:47+01:00 |
| 34316447 | 34316447 | 34 | 18:23:43 | 23.01.20 | 1 | 3.8 | 32 32 | 23.01.20 18:23:43 | 2020-01-23 18:23:43+01:00 |
| 34319008 | 34319008 | 35 | 18:23:07 | 23.01.20 | 2 | 4.2 | 32 32 | 23.01.20 18:23:07 | 2020-01-23 18:23:07+01:00 |
| 34316446 | 34316446 | 28 | 18:22:31 | 23.01.20 | 1 | 4.5 | 32 32 | 23.01.20 18:22:31 | 2020-01-23 18:22:31+01:00 |
| 34316445 | 34316445 | 30 | 18:22:12 | 23.01.20 | 1 | 3.4 | 32 32 | 23.01.20 18:22:12 | 2020-01-23 18:22:12+01:00 |
| 34316444 | 34316444 | 29 | 18:21:21 | 23.01.20 | 1 | 3.0 | 32 32 | 23.01.20 18:21:21 | 2020-01-23 18:21:21+01:00 |
| 34319007 | 34319007 | 31 | 18:21:19 | 23.01.20 | 2 | 5.0 | 32 32 | 23.01.20 18:21:19 | 2020-01-23 18:21:19+01:00 |
| 34316443 | 34316443 | 38 | 18:20:52 | 23.01.20 | 1 | 4.1 | 32 32 | 23.01.20 18:20:52 | 2020-01-23 18:20:52+01:00 |
| 34319006 | 34319006 | 40 | 18:13:42 | 23.01.20 | 2 | 4.4 | 32 32 | 23.01.20 18:13:42 | 2020-01-23 18:13:42+01:00 |
| 34316442 | 34316442 | 25 | 18:11:38 | 23.01.20 | 1 | 3.8 | 32 32 | 23.01.20 18:11:38 | 2020-01-23 18:11:38+01:00 |
| 34319005 | 34319005 | 25 | 18:11:37 | 23.01.20 | 2 | 4.4 | 32 32 | 23.01.20 18:11:37 | 2020-01-23 18:11:37+01:00 |
| 34319004 | 34319004 | 31 | 18:08:44 | 23.01.20 | 2 | 4.3 | 32 32 | 23.01.20 18:08:44 | 2020-01-23 18:08:44+01:00 |
| 34319003 | 34319003 | 38 | 18:08:36 | 23.01.20 | 2 | 4.9 | 32 32 | 23.01.20 18:08:36 | 2020-01-23 18:08:36+01:00 |
| 34316441 | 34316441 | 34 | 18:07:30 | 23.01.20 | 1 | 5.9 | 32 32 | 23.01.20 18:07:30 | 2020-01-23 18:07:30+01:00 |
| 34316440 | 34316440 | 35 | 18:07:06 | 23.01.20 | 1 | 5.4 | 32 32 | 23.01.20 18:07:06 | 2020-01-23 18:07:06+01:00 |
| 34319002 | 34319002 | 34 | 18:06:13 | 23.01.20 | 2 | 4.8 | 32 32 | 23.01.20 18:06:13 | 2020-01-23 18:06:13+01:00 |
| 34319001 | 34319001 | 37 | 18:06:05 | 23.01.20 | 2 | 5.7 | 32 32 | 23.01.20 18:06:05 | 2020-01-23 18:06:05+01:00 |
| 34319000 | 34319000 | 48 | 18:04:37 | 23.01.20 | 2 | 3.7 | 32 32 | 23.01.20 18:04:37 | 2020-01-23 18:04:37+01:00 |
| 34318999 | 34318999 | 39 | 18:03:42 | 23.01.20 | 2 | 5.1 | 32 32 | 23.01.20 18:03:42 | 2020-01-23 18:03:42+01:00 |
| 34316439 | 34316439 | 43 | 18:02:15 | 23.01.20 | 1 | 5.9 | 32 32 | 23.01.20 18:02:15 | 2020-01-23 18:02:15+01:00 |
| 34318998 | 34318998 | 36 | 17:59:53 | 23.01.20 | 2 | 4.7 | 32 32 | 23.01.20 17:59:53 | 2020-01-23 17:59:53+01:00 |
| 34318997 | 34318997 | 35 | 17:58:33 | 23.01.20 | 2 | 4.0 | 32 32 | 23.01.20 17:58:33 | 2020-01-23 17:58:33+01:00 |
| 34316438 | 34316438 | 35 | 17:57:47 | 23.01.20 | 1 | 5.3 | 32 32 | 23.01.20 17:57:47 | 2020-01-23 17:57:47+01:00 |
| 34318996 | 34318996 | 37 | 17:57:21 | 23.01.20 | 2 | 4.0 | 32 32 | 23.01.20 17:57:21 | 2020-01-23 17:57:21+01:00 |
| 34318995 | 34318995 | 32 | 17:57:04 | 23.01.20 | 2 | 5.2 | 32 32 | 23.01.20 17:57:04 | 2020-01-23 17:57:04+01:00 |
| 34318994 | 34318994 | 38 | 17:54:15 | 23.01.20 | 2 | 4.5 | 32 32 | 23.01.20 17:54:15 | 2020-01-23 17:54:15+01:00 |
| 34318993 | 34318993 | 43 | 17:52:08 | 23.01.20 | 2 | 4.2 | 32 32 | 23.01.20 17:52:08 | 2020-01-23 17:52:08+01:00 |
| 34316437 | 34316437 | 40 | 17:51:30 | 23.01.20 | 1 | 5.0 | 32 32 | 23.01.20 17:51:30 | 2020-01-23 17:51:30+01:00 |
| 34318992 | 34318992 | 34 | 17:49:47 | 23.01.20 | 2 | 4.6 | 32 32 | 23.01.20 17:49:47 | 2020-01-23 17:49:47+01:00 |
| 34318991 | 34318991 | 39 | 17:47:55 | 23.01.20 | 2 | 4.3 | 32 32 | 23.01.20 17:47:55 | 2020-01-23 17:47:55+01:00 |
| 34318990 | 34318990 | 25 | 17:47:46 | 23.01.20 | 2 | 4.0 | 32 32 | 23.01.20 17:47:46 | 2020-01-23 17:47:46+01:00 |
| 34316436 | 34316436 | 38 | 17:44:55 | 23.01.20 | 1 | 5.2 | 32 32 | 23.01.20 17:44:55 | 2020-01-23 17:44:55+01:00 |
| 34316435 | 34316435 | 37 | 17:44:40 | 23.01.20 | 1 | 6.0 | 32 32 | 23.01.20 17:44:40 | 2020-01-23 17:44:40+01:00 |
| 34316434 | 34316434 | 35 | 17:42:11 | 23.01.20 | 1 | 5.5 | 32 32 | 23.01.20 17:42:11 | 2020-01-23 17:42:11+01:00 |
| 34318989 | 34318989 | 35 | 17:39:58 | 23.01.20 | 2 | 4.0 | 32 32 | 23.01.20 17:39:58 | 2020-01-23 17:39:58+01:00 |
| 34316433 | 34316433 | 44 | 17:38:38 | 23.01.20 | 1 | 6.5 | 32 32 | 23.01.20 17:38:38 | 2020-01-23 17:38:38+01:00 |
| 34318988 | 34318988 | 30 | 17:37:51 | 23.01.20 | 2 | 4.4 | 32 32 | 23.01.20 17:37:51 | 2020-01-23 17:37:51+01:00 |
| 34316432 | 34316432 | 38 | 17:37:21 | 23.01.20 | 1 | 5.9 | 32 32 | 23.01.20 17:37:21 | 2020-01-23 17:37:21+01:00 |
| 34316431 | 34316431 | 39 | 17:34:43 | 23.01.20 | 1 | 5.1 | 32 32 | 23.01.20 17:34:43 | 2020-01-23 17:34:43+01:00 |
| 34316430 | 34316430 | 36 | 17:34:27 | 23.01.20 | 1 | 5.9 | 32 32 | 23.01.20 17:34:27 | 2020-01-23 17:34:27+01:00 |
| 34318987 | 34318987 | 40 | 17:33:28 | 23.01.20 | 2 | 3.9 | 32 32 | 23.01.20 17:33:28 | 2020-01-23 17:33:28+01:00 |
| 34316429 | 34316429 | 34 | 17:33:08 | 23.01.20 | 1 | 5.5 | 32 32 | 23.01.20 17:33:08 | 2020-01-23 17:33:08+01:00 |
| 34316428 | 34316428 | 38 | 17:33:05 | 23.01.20 | 1 | 5.5 | 32 32 | 23.01.20 17:33:05 | 2020-01-23 17:33:05+01:00 |
| 34316427 | 34316427 | 35 | 17:33:02 | 23.01.20 | 1 | 6.0 | 32 32 | 23.01.20 17:33:02 | 2020-01-23 17:33:02+01:00 |
| 34316426 | 34316426 | 42 | 17:32:32 | 23.01.20 | 1 | 4.5 | 32 32 | 23.01.20 17:32:32 | 2020-01-23 17:32:32+01:00 |
| 34316425 | 34316425 | 41 | 17:32:14 | 23.01.20 | 1 | 5.8 | 32 32 | 23.01.20 17:32:14 | 2020-01-23 17:32:14+01:00 |
| 34318986 | 34318986 | 30 | 17:31:21 | 23.01.20 | 2 | 3.4 | 32 32 | 23.01.20 17:31:21 | 2020-01-23 17:31:21+01:00 |
| 34316424 | 34316424 | 33 | 17:30:07 | 23.01.20 | 1 | 5.6 | 32 32 | 23.01.20 17:30:07 | 2020-01-23 17:30:07+01:00 |
| 34316423 | 34316423 | 23 | 17:28:42 | 23.01.20 | 1 | 3.9 | 32 32 | 23.01.20 17:28:42 | 2020-01-23 17:28:42+01:00 |
| 34318985 | 34318985 | 36 | 17:28:33 | 23.01.20 | 2 | 4.2 | 32 32 | 23.01.20 17:28:33 | 2020-01-23 17:28:33+01:00 |
| 34316422 | 34316422 | 34 | 17:28:02 | 23.01.20 | 1 | 8.0 | 32 32 | 23.01.20 17:28:02 | 2020-01-23 17:28:02+01:00 |
| 34316421 | 34316421 | 38 | 17:27:39 | 23.01.20 | 1 | 5.9 | 32 32 | 23.01.20 17:27:39 | 2020-01-23 17:27:39+01:00 |
| 34316420 | 34316420 | 25 | 17:27:05 | 23.01.20 | 1 | 9.1 | 32 32 | 23.01.20 17:27:05 | 2020-01-23 17:27:05+01:00 |
| 34316419 | 34316419 | 42 | 17:25:09 | 23.01.20 | 1 | 6.1 | 32 32 | 23.01.20 17:25:09 | 2020-01-23 17:25:09+01:00 |
| 34316418 | 34316418 | 37 | 17:24:18 | 23.01.20 | 1 | 5.8 | 32 32 | 23.01.20 17:24:18 | 2020-01-23 17:24:18+01:00 |
| 34318984 | 34318984 | 31 | 17:22:41 | 23.01.20 | 2 | 4.9 | 32 32 | 23.01.20 17:22:41 | 2020-01-23 17:22:41+01:00 |
| 34318983 | 34318983 | 44 | 17:22:27 | 23.01.20 | 2 | 5.1 | 32 32 | 23.01.20 17:22:27 | 2020-01-23 17:22:27+01:00 |
| 34316417 | 34316417 | 36 | 17:22:04 | 23.01.20 | 1 | 5.6 | 32 32 | 23.01.20 17:22:04 | 2020-01-23 17:22:04+01:00 |
| 34316416 | 34316416 | 33 | 17:21:58 | 23.01.20 | 1 | 6.5 | 32 32 | 23.01.20 17:21:58 | 2020-01-23 17:21:58+01:00 |
| 34318982 | 34318982 | 37 | 17:17:56 | 23.01.20 | 2 | 4.1 | 32 32 | 23.01.20 17:17:56 | 2020-01-23 17:17:56+01:00 |
| 34316415 | 34316415 | 36 | 17:14:25 | 23.01.20 | 1 | 5.6 | 32 32 | 23.01.20 17:14:25 | 2020-01-23 17:14:25+01:00 |
| 34316414 | 34316414 | 35 | 17:14:15 | 23.01.20 | 1 | 5.4 | 32 32 | 23.01.20 17:14:15 | 2020-01-23 17:14:15+01:00 |
| 34316413 | 34316413 | 35 | 17:11:08 | 23.01.20 | 1 | 5.6 | 32 32 | 23.01.20 17:11:08 | 2020-01-23 17:11:08+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");