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 = 49 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 ▲ |
|---|---|---|---|---|---|---|---|---|---|
| 35041717 | 35041717 | 7 | 14:24:54 | 14.10.19 | 2 | 5.0 | 49 49 | 14.10.19 14:24:54 | 2019-10-14 14:24:54+02:00 |
| 35051477 | 35051477 | 33 | 23:56:00 | 12.10.19 | 2 | 6.3 | 49 49 | 12.10.19 23:56:00 | 2019-10-12 23:56:00+02:00 |
| 35061875 | 35061875 | 24 | 23:55:21 | 12.10.19 | 1 | 10.5 | 49 49 | 12.10.19 23:55:21 | 2019-10-12 23:55:21+02:00 |
| 35061874 | 35061874 | 34 | 23:49:15 | 12.10.19 | 1 | 6.3 | 49 49 | 12.10.19 23:49:15 | 2019-10-12 23:49:15+02:00 |
| 35051476 | 35051476 | 31 | 23:47:47 | 12.10.19 | 2 | 5.3 | 49 49 | 12.10.19 23:47:47 | 2019-10-12 23:47:47+02:00 |
| 35051475 | 35051475 | 28 | 23:47:10 | 12.10.19 | 2 | 2.0 | 49 49 | 12.10.19 23:47:10 | 2019-10-12 23:47:10+02:00 |
| 35061873 | 35061873 | 15 | 23:44:57 | 12.10.19 | 1 | 6.1 | 49 49 | 12.10.19 23:44:57 | 2019-10-12 23:44:57+02:00 |
| 35051474 | 35051474 | 25 | 23:44:32 | 12.10.19 | 2 | 10.2 | 49 49 | 12.10.19 23:44:32 | 2019-10-12 23:44:32+02:00 |
| 35061872 | 35061872 | 33 | 23:39:57 | 12.10.19 | 1 | 6.3 | 49 49 | 12.10.19 23:39:57 | 2019-10-12 23:39:57+02:00 |
| 35051473 | 35051473 | 25 | 23:38:36 | 12.10.19 | 2 | 6.0 | 49 49 | 12.10.19 23:38:36 | 2019-10-12 23:38:36+02:00 |
| 35051472 | 35051472 | 28 | 23:33:28 | 12.10.19 | 2 | 5.7 | 49 49 | 12.10.19 23:33:28 | 2019-10-12 23:33:28+02:00 |
| 35051471 | 35051471 | 24 | 23:27:07 | 12.10.19 | 2 | 6.7 | 49 49 | 12.10.19 23:27:07 | 2019-10-12 23:27:07+02:00 |
| 35061871 | 35061871 | 22 | 23:24:59 | 12.10.19 | 1 | 10.3 | 49 49 | 12.10.19 23:24:59 | 2019-10-12 23:24:59+02:00 |
| 35051470 | 35051470 | 25 | 23:14:13 | 12.10.19 | 2 | 10.0 | 49 49 | 12.10.19 23:14:13 | 2019-10-12 23:14:13+02:00 |
| 35061870 | 35061870 | 28 | 23:10:30 | 12.10.19 | 1 | 7.9 | 49 49 | 12.10.19 23:10:30 | 2019-10-12 23:10:30+02:00 |
| 35061869 | 35061869 | 36 | 23:10:07 | 12.10.19 | 1 | 6.3 | 49 49 | 12.10.19 23:10:07 | 2019-10-12 23:10:07+02:00 |
| 35061868 | 35061868 | 25 | 23:07:55 | 12.10.19 | 1 | 6.3 | 49 49 | 12.10.19 23:07:55 | 2019-10-12 23:07:55+02:00 |
| 35061867 | 35061867 | 16 | 23:07:49 | 12.10.19 | 1 | 5.5 | 49 49 | 12.10.19 23:07:49 | 2019-10-12 23:07:49+02:00 |
| 35061866 | 35061866 | 28 | 23:03:34 | 12.10.19 | 1 | 7.1 | 49 49 | 12.10.19 23:03:34 | 2019-10-12 23:03:34+02:00 |
| 35061865 | 35061865 | 27 | 23:02:29 | 12.10.19 | 1 | 7.0 | 49 49 | 12.10.19 23:02:29 | 2019-10-12 23:02:29+02:00 |
| 35061864 | 35061864 | 35 | 23:00:18 | 12.10.19 | 1 | 6.2 | 49 49 | 12.10.19 23:00:18 | 2019-10-12 23:00:18+02:00 |
| 35061863 | 35061863 | 36 | 23:00:17 | 12.10.19 | 1 | 5.4 | 49 49 | 12.10.19 23:00:17 | 2019-10-12 23:00:17+02:00 |
| 35061862 | 35061862 | 22 | 22:57:27 | 12.10.19 | 1 | 10.8 | 49 49 | 12.10.19 22:57:27 | 2019-10-12 22:57:27+02:00 |
| 35051469 | 35051469 | 33 | 22:56:53 | 12.10.19 | 2 | 6.6 | 49 49 | 12.10.19 22:56:53 | 2019-10-12 22:56:53+02:00 |
| 35061861 | 35061861 | 20 | 22:56:19 | 12.10.19 | 1 | 5.4 | 49 49 | 12.10.19 22:56:19 | 2019-10-12 22:56:19+02:00 |
| 35051468 | 35051468 | 19 | 22:46:25 | 12.10.19 | 2 | 4.9 | 49 49 | 12.10.19 22:46:25 | 2019-10-12 22:46:25+02:00 |
| 35051467 | 35051467 | 24 | 22:44:12 | 12.10.19 | 2 | 9.6 | 49 49 | 12.10.19 22:44:12 | 2019-10-12 22:44:12+02:00 |
| 35051466 | 35051466 | 31 | 22:38:28 | 12.10.19 | 2 | 6.4 | 49 49 | 12.10.19 22:38:28 | 2019-10-12 22:38:28+02:00 |
| 35061860 | 35061860 | 27 | 22:36:01 | 12.10.19 | 1 | 6.3 | 49 49 | 12.10.19 22:36:01 | 2019-10-12 22:36:01+02:00 |
| 35051465 | 35051465 | 33 | 22:34:12 | 12.10.19 | 2 | 6.5 | 49 49 | 12.10.19 22:34:12 | 2019-10-12 22:34:12+02:00 |
| 35051464 | 35051464 | 23 | 22:33:49 | 12.10.19 | 2 | 2.1 | 49 49 | 12.10.19 22:33:49 | 2019-10-12 22:33:49+02:00 |
| 35061859 | 35061859 | 30 | 22:33:03 | 12.10.19 | 1 | 6.8 | 49 49 | 12.10.19 22:33:03 | 2019-10-12 22:33:03+02:00 |
| 35061858 | 35061858 | 25 | 22:31:56 | 12.10.19 | 1 | 4.1 | 49 49 | 12.10.19 22:31:56 | 2019-10-12 22:31:56+02:00 |
| 35051463 | 35051463 | 35 | 22:31:02 | 12.10.19 | 2 | 5.3 | 49 49 | 12.10.19 22:31:02 | 2019-10-12 22:31:02+02:00 |
| 35061857 | 35061857 | 23 | 22:26:03 | 12.10.19 | 1 | 10.4 | 49 49 | 12.10.19 22:26:03 | 2019-10-12 22:26:03+02:00 |
| 35061856 | 35061856 | 28 | 22:25:46 | 12.10.19 | 1 | 7.2 | 49 49 | 12.10.19 22:25:46 | 2019-10-12 22:25:46+02:00 |
| 35051462 | 35051462 | 19 | 22:25:29 | 12.10.19 | 2 | 2.6 | 49 49 | 12.10.19 22:25:29 | 2019-10-12 22:25:29+02:00 |
| 35061855 | 35061855 | 20 | 22:19:40 | 12.10.19 | 1 | 5.4 | 49 49 | 12.10.19 22:19:40 | 2019-10-12 22:19:40+02:00 |
| 35051461 | 35051461 | 23 | 22:14:41 | 12.10.19 | 2 | 9.2 | 49 49 | 12.10.19 22:14:41 | 2019-10-12 22:14:41+02:00 |
| 35051460 | 35051460 | 34 | 22:14:08 | 12.10.19 | 2 | 6.3 | 49 49 | 12.10.19 22:14:08 | 2019-10-12 22:14:08+02:00 |
| 35061854 | 35061854 | 36 | 22:13:53 | 12.10.19 | 1 | 7.3 | 49 49 | 12.10.19 22:13:53 | 2019-10-12 22:13:53+02:00 |
| 35051459 | 35051459 | 26 | 22:13:51 | 12.10.19 | 2 | 6.0 | 49 49 | 12.10.19 22:13:51 | 2019-10-12 22:13:51+02:00 |
| 35061853 | 35061853 | 8 | 22:08:21 | 12.10.19 | 1 | 5.4 | 49 49 | 12.10.19 22:08:21 | 2019-10-12 22:08:21+02:00 |
| 35051458 | 35051458 | 29 | 22:08:14 | 12.10.19 | 2 | 6.2 | 49 49 | 12.10.19 22:08:14 | 2019-10-12 22:08:14+02:00 |
| 35051457 | 35051457 | 19 | 22:07:16 | 12.10.19 | 2 | 6.1 | 49 49 | 12.10.19 22:07:16 | 2019-10-12 22:07:16+02:00 |
| 35051456 | 35051456 | 25 | 22:07:02 | 12.10.19 | 2 | 6.1 | 49 49 | 12.10.19 22:07:02 | 2019-10-12 22:07:02+02:00 |
| 35061852 | 35061852 | 19 | 22:05:06 | 12.10.19 | 1 | 6.0 | 49 49 | 12.10.19 22:05:06 | 2019-10-12 22:05:06+02:00 |
| 35051455 | 35051455 | 27 | 22:02:55 | 12.10.19 | 2 | 5.2 | 49 49 | 12.10.19 22:02:55 | 2019-10-12 22:02:55+02:00 |
| 35061851 | 35061851 | 21 | 22:02:09 | 12.10.19 | 1 | 5.3 | 49 49 | 12.10.19 22:02:09 | 2019-10-12 22:02:09+02:00 |
| 35051454 | 35051454 | 37 | 21:59:32 | 12.10.19 | 2 | 6.8 | 49 49 | 12.10.19 21:59:32 | 2019-10-12 21:59:32+02:00 |
| 35061850 | 35061850 | 14 | 21:57:46 | 12.10.19 | 1 | 5.3 | 49 49 | 12.10.19 21:57:46 | 2019-10-12 21:57:46+02:00 |
| 35061849 | 35061849 | 15 | 21:57:45 | 12.10.19 | 1 | 5.3 | 49 49 | 12.10.19 21:57:45 | 2019-10-12 21:57:45+02:00 |
| 35051453 | 35051453 | 30 | 21:56:58 | 12.10.19 | 2 | 6.1 | 49 49 | 12.10.19 21:56:58 | 2019-10-12 21:56:58+02:00 |
| 35061848 | 35061848 | 22 | 21:55:29 | 12.10.19 | 1 | 10.7 | 49 49 | 12.10.19 21:55:29 | 2019-10-12 21:55:29+02:00 |
| 35051452 | 35051452 | 26 | 21:51:08 | 12.10.19 | 2 | 6.0 | 49 49 | 12.10.19 21:51:08 | 2019-10-12 21:51:08+02:00 |
| 35051451 | 35051451 | 21 | 21:45:53 | 12.10.19 | 2 | 11.1 | 49 49 | 12.10.19 21:45:53 | 2019-10-12 21:45:53+02:00 |
| 35061847 | 35061847 | 27 | 21:42:29 | 12.10.19 | 1 | 6.4 | 49 49 | 12.10.19 21:42:29 | 2019-10-12 21:42:29+02:00 |
| 35061846 | 35061846 | 30 | 21:38:44 | 12.10.19 | 1 | 5.8 | 49 49 | 12.10.19 21:38:44 | 2019-10-12 21:38:44+02:00 |
| 35051450 | 35051450 | 36 | 21:38:37 | 12.10.19 | 2 | 5.3 | 49 49 | 12.10.19 21:38:37 | 2019-10-12 21:38:37+02:00 |
| 35051449 | 35051449 | 31 | 21:34:26 | 12.10.19 | 2 | 6.5 | 49 49 | 12.10.19 21:34:26 | 2019-10-12 21:34:26+02:00 |
| 35051448 | 35051448 | 27 | 21:34:02 | 12.10.19 | 2 | 5.5 | 49 49 | 12.10.19 21:34:02 | 2019-10-12 21:34:02+02:00 |
| 35061845 | 35061845 | 29 | 21:32:31 | 12.10.19 | 1 | 6.9 | 49 49 | 12.10.19 21:32:31 | 2019-10-12 21:32:31+02:00 |
| 35051447 | 35051447 | 31 | 21:31:15 | 12.10.19 | 2 | 6.0 | 49 49 | 12.10.19 21:31:15 | 2019-10-12 21:31:15+02:00 |
| 35061844 | 35061844 | 23 | 21:30:07 | 12.10.19 | 1 | 7.9 | 49 49 | 12.10.19 21:30:07 | 2019-10-12 21:30:07+02:00 |
| 35061843 | 35061843 | 33 | 21:28:32 | 12.10.19 | 1 | 5.9 | 49 49 | 12.10.19 21:28:32 | 2019-10-12 21:28:32+02:00 |
| 35051446 | 35051446 | 25 | 21:27:32 | 12.10.19 | 2 | 6.5 | 49 49 | 12.10.19 21:27:32 | 2019-10-12 21:27:32+02:00 |
| 35061842 | 35061842 | 22 | 21:26:42 | 12.10.19 | 1 | 10.3 | 49 49 | 12.10.19 21:26:42 | 2019-10-12 21:26:42+02:00 |
| 35061841 | 35061841 | 22 | 21:23:37 | 12.10.19 | 1 | 5.3 | 49 49 | 12.10.19 21:23:37 | 2019-10-12 21:23:37+02:00 |
| 35051445 | 35051445 | 32 | 21:20:09 | 12.10.19 | 2 | 6.1 | 49 49 | 12.10.19 21:20:09 | 2019-10-12 21:20:09+02:00 |
| 35061840 | 35061840 | 36 | 21:18:22 | 12.10.19 | 1 | 6.1 | 49 49 | 12.10.19 21:18:22 | 2019-10-12 21:18:22+02:00 |
| 35061839 | 35061839 | 17 | 21:17:28 | 12.10.19 | 1 | 5.2 | 49 49 | 12.10.19 21:17:28 | 2019-10-12 21:17:28+02:00 |
| 35051444 | 35051444 | 28 | 21:16:36 | 12.10.19 | 2 | 6.5 | 49 49 | 12.10.19 21:16:36 | 2019-10-12 21:16:36+02:00 |
| 35051443 | 35051443 | 25 | 21:14:24 | 12.10.19 | 2 | 5.5 | 49 49 | 12.10.19 21:14:24 | 2019-10-12 21:14:24+02:00 |
| 35051442 | 35051442 | 23 | 21:14:18 | 12.10.19 | 2 | 10.1 | 49 49 | 12.10.19 21:14:18 | 2019-10-12 21:14:18+02:00 |
| 35051441 | 35051441 | 31 | 21:05:59 | 12.10.19 | 2 | 6.3 | 49 49 | 12.10.19 21:05:59 | 2019-10-12 21:05:59+02:00 |
| 35061838 | 35061838 | 37 | 21:03:09 | 12.10.19 | 1 | 6.5 | 49 49 | 12.10.19 21:03:09 | 2019-10-12 21:03:09+02:00 |
| 35061837 | 35061837 | 28 | 21:02:52 | 12.10.19 | 1 | 6.6 | 49 49 | 12.10.19 21:02:52 | 2019-10-12 21:02:52+02:00 |
| 35051440 | 35051440 | 24 | 20:55:57 | 12.10.19 | 2 | 5.7 | 49 49 | 12.10.19 20:55:57 | 2019-10-12 20:55:57+02:00 |
| 35061836 | 35061836 | 23 | 20:55:56 | 12.10.19 | 1 | 10.5 | 49 49 | 12.10.19 20:55:56 | 2019-10-12 20:55:56+02:00 |
| 35051439 | 35051439 | 30 | 20:55:08 | 12.10.19 | 2 | 5.6 | 49 49 | 12.10.19 20:55:08 | 2019-10-12 20:55:08+02:00 |
| 35051438 | 35051438 | 23 | 20:53:35 | 12.10.19 | 2 | 5.2 | 49 49 | 12.10.19 20:53:35 | 2019-10-12 20:53:35+02:00 |
| 35061835 | 35061835 | 28 | 20:52:45 | 12.10.19 | 1 | 6.2 | 49 49 | 12.10.19 20:52:45 | 2019-10-12 20:52:45+02:00 |
| 35051437 | 35051437 | 24 | 20:47:10 | 12.10.19 | 2 | 5.8 | 49 49 | 12.10.19 20:47:10 | 2019-10-12 20:47:10+02:00 |
| 35051436 | 35051436 | 20 | 20:45:53 | 12.10.19 | 2 | 2.3 | 49 49 | 12.10.19 20:45:53 | 2019-10-12 20:45:53+02:00 |
| 35051435 | 35051435 | 27 | 20:45:12 | 12.10.19 | 2 | 9.6 | 49 49 | 12.10.19 20:45:12 | 2019-10-12 20:45:12+02:00 |
| 35051434 | 35051434 | 40 | 20:44:31 | 12.10.19 | 2 | 6.5 | 49 49 | 12.10.19 20:44:31 | 2019-10-12 20:44:31+02:00 |
| 35061834 | 35061834 | 29 | 20:37:34 | 12.10.19 | 1 | 5.6 | 49 49 | 12.10.19 20:37:34 | 2019-10-12 20:37:34+02:00 |
| 35051433 | 35051433 | 31 | 20:36:43 | 12.10.19 | 2 | 6.7 | 49 49 | 12.10.19 20:36:43 | 2019-10-12 20:36:43+02:00 |
| 35051432 | 35051432 | 32 | 20:35:01 | 12.10.19 | 2 | 5.6 | 49 49 | 12.10.19 20:35:01 | 2019-10-12 20:35:01+02:00 |
| 35051431 | 35051431 | 32 | 20:32:15 | 12.10.19 | 2 | 6.9 | 49 49 | 12.10.19 20:32:15 | 2019-10-12 20:32:15+02:00 |
| 35061833 | 35061833 | 23 | 20:32:08 | 12.10.19 | 1 | 5.7 | 49 49 | 12.10.19 20:32:08 | 2019-10-12 20:32:08+02:00 |
| 35061832 | 35061832 | 29 | 20:29:46 | 12.10.19 | 1 | 5.2 | 49 49 | 12.10.19 20:29:46 | 2019-10-12 20:29:46+02:00 |
| 35051430 | 35051430 | 23 | 20:28:16 | 12.10.19 | 2 | 5.2 | 49 49 | 12.10.19 20:28:16 | 2019-10-12 20:28:16+02:00 |
| 35061831 | 35061831 | 26 | 20:26:07 | 12.10.19 | 1 | 10.5 | 49 49 | 12.10.19 20:26:07 | 2019-10-12 20:26:07+02:00 |
| 35051429 | 35051429 | 28 | 20:24:36 | 12.10.19 | 2 | 6.1 | 49 49 | 12.10.19 20:24:36 | 2019-10-12 20:24:36+02:00 |
| 35051428 | 35051428 | 27 | 20:24:08 | 12.10.19 | 2 | 5.6 | 49 49 | 12.10.19 20:24:08 | 2019-10-12 20:24:08+02:00 |
| 35061830 | 35061830 | 13 | 20:23:52 | 12.10.19 | 1 | 5.2 | 49 49 | 12.10.19 20:23:52 | 2019-10-12 20:23:52+02:00 |
| 35061829 | 35061829 | 32 | 20:23:14 | 12.10.19 | 1 | 6.2 | 49 49 | 12.10.19 20:23:14 | 2019-10-12 20:23:14+02:00 |
| 35061828 | 35061828 | 20 | 20:18:52 | 12.10.19 | 1 | 6.3 | 49 49 | 12.10.19 20:18:52 | 2019-10-12 20:18:52+02:00 |
| 35051427 | 35051427 | 33 | 20:16:24 | 12.10.19 | 2 | 7.0 | 49 49 | 12.10.19 20:16:24 | 2019-10-12 20:16:24+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");