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
9,575 rows where Messung-ID = 22 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 ▲ |
|---|---|---|---|---|---|---|---|---|---|
| 36329986 | 36329986 | 20 | 08:52:00 | 18.03.19 | 1 | 4.9 | 22 22 | 18.03.19 08:52:00 | 2019-03-18 08:52:00+01:00 |
| 36329985 | 36329985 | 25 | 08:51:06 | 18.03.19 | 1 | 6.1 | 22 22 | 18.03.19 08:51:06 | 2019-03-18 08:51:06+01:00 |
| 36329984 | 36329984 | 26 | 08:50:09 | 18.03.19 | 1 | 4.7 | 22 22 | 18.03.19 08:50:09 | 2019-03-18 08:50:09+01:00 |
| 36329983 | 36329983 | 22 | 08:50:04 | 18.03.19 | 1 | 6.0 | 22 22 | 18.03.19 08:50:04 | 2019-03-18 08:50:04+01:00 |
| 36322979 | 36322979 | 15 | 08:49:55 | 18.03.19 | 2 | 2.7 | 22 22 | 18.03.19 08:49:55 | 2019-03-18 08:49:55+01:00 |
| 36329982 | 36329982 | 22 | 08:49:28 | 18.03.19 | 1 | 9.7 | 22 22 | 18.03.19 08:49:28 | 2019-03-18 08:49:28+01:00 |
| 36329981 | 36329981 | 24 | 08:49:25 | 18.03.19 | 1 | 4.1 | 22 22 | 18.03.19 08:49:25 | 2019-03-18 08:49:25+01:00 |
| 36322978 | 36322978 | 35 | 08:48:21 | 18.03.19 | 2 | 7.2 | 22 22 | 18.03.19 08:48:21 | 2019-03-18 08:48:21+01:00 |
| 36329980 | 36329980 | 29 | 08:47:43 | 18.03.19 | 1 | 5.6 | 22 22 | 18.03.19 08:47:43 | 2019-03-18 08:47:43+01:00 |
| 36329979 | 36329979 | 25 | 08:47:23 | 18.03.19 | 1 | 6.0 | 22 22 | 18.03.19 08:47:23 | 2019-03-18 08:47:23+01:00 |
| 36329978 | 36329978 | 34 | 08:45:31 | 18.03.19 | 1 | 5.7 | 22 22 | 18.03.19 08:45:31 | 2019-03-18 08:45:31+01:00 |
| 36322977 | 36322977 | 39 | 08:45:05 | 18.03.19 | 2 | 5.4 | 22 22 | 18.03.19 08:45:05 | 2019-03-18 08:45:05+01:00 |
| 36329977 | 36329977 | 28 | 08:43:57 | 18.03.19 | 1 | 4.8 | 22 22 | 18.03.19 08:43:57 | 2019-03-18 08:43:57+01:00 |
| 36329976 | 36329976 | 27 | 08:43:40 | 18.03.19 | 1 | 5.6 | 22 22 | 18.03.19 08:43:40 | 2019-03-18 08:43:40+01:00 |
| 36329975 | 36329975 | 26 | 08:42:40 | 18.03.19 | 1 | 4.8 | 22 22 | 18.03.19 08:42:40 | 2019-03-18 08:42:40+01:00 |
| 36329974 | 36329974 | 26 | 08:42:36 | 18.03.19 | 1 | 9.7 | 22 22 | 18.03.19 08:42:36 | 2019-03-18 08:42:36+01:00 |
| 36322976 | 36322976 | 33 | 08:41:44 | 18.03.19 | 2 | 4.1 | 22 22 | 18.03.19 08:41:44 | 2019-03-18 08:41:44+01:00 |
| 36329973 | 36329973 | 32 | 08:38:35 | 18.03.19 | 1 | 4.8 | 22 22 | 18.03.19 08:38:35 | 2019-03-18 08:38:35+01:00 |
| 36322975 | 36322975 | 29 | 08:36:03 | 18.03.19 | 2 | 4.9 | 22 22 | 18.03.19 08:36:03 | 2019-03-18 08:36:03+01:00 |
| 36329972 | 36329972 | 30 | 08:35:32 | 18.03.19 | 1 | 5.1 | 22 22 | 18.03.19 08:35:32 | 2019-03-18 08:35:32+01:00 |
| 36329971 | 36329971 | 29 | 08:33:41 | 18.03.19 | 1 | 5.6 | 22 22 | 18.03.19 08:33:41 | 2019-03-18 08:33:41+01:00 |
| 36329970 | 36329970 | 15 | 08:33:17 | 18.03.19 | 1 | 5.1 | 22 22 | 18.03.19 08:33:17 | 2019-03-18 08:33:17+01:00 |
| 36329969 | 36329969 | 26 | 08:32:51 | 18.03.19 | 1 | 5.5 | 22 22 | 18.03.19 08:32:51 | 2019-03-18 08:32:51+01:00 |
| 36329968 | 36329968 | 24 | 08:32:23 | 18.03.19 | 1 | 4.3 | 22 22 | 18.03.19 08:32:23 | 2019-03-18 08:32:23+01:00 |
| 36329967 | 36329967 | 28 | 08:32:06 | 18.03.19 | 1 | 6.7 | 22 22 | 18.03.19 08:32:06 | 2019-03-18 08:32:06+01:00 |
| 36322974 | 36322974 | 33 | 08:29:30 | 18.03.19 | 2 | 4.8 | 22 22 | 18.03.19 08:29:30 | 2019-03-18 08:29:30+01:00 |
| 36329966 | 36329966 | 30 | 08:27:11 | 18.03.19 | 1 | 5.9 | 22 22 | 18.03.19 08:27:11 | 2019-03-18 08:27:11+01:00 |
| 36329965 | 36329965 | 28 | 08:26:54 | 18.03.19 | 1 | 7.4 | 22 22 | 18.03.19 08:26:54 | 2019-03-18 08:26:54+01:00 |
| 36329964 | 36329964 | 24 | 08:24:52 | 18.03.19 | 1 | 4.7 | 22 22 | 18.03.19 08:24:52 | 2019-03-18 08:24:52+01:00 |
| 36329963 | 36329963 | 20 | 08:24:21 | 18.03.19 | 1 | 4.0 | 22 22 | 18.03.19 08:24:21 | 2019-03-18 08:24:21+01:00 |
| 36329962 | 36329962 | 28 | 08:24:03 | 18.03.19 | 1 | 2.9 | 22 22 | 18.03.19 08:24:03 | 2019-03-18 08:24:03+01:00 |
| 36329961 | 36329961 | 19 | 08:23:11 | 18.03.19 | 1 | 4.0 | 22 22 | 18.03.19 08:23:11 | 2019-03-18 08:23:11+01:00 |
| 36329960 | 36329960 | 33 | 08:20:55 | 18.03.19 | 1 | 6.1 | 22 22 | 18.03.19 08:20:55 | 2019-03-18 08:20:55+01:00 |
| 36329959 | 36329959 | 27 | 08:19:51 | 18.03.19 | 1 | 6.0 | 22 22 | 18.03.19 08:19:51 | 2019-03-18 08:19:51+01:00 |
| 36329958 | 36329958 | 20 | 08:19:22 | 18.03.19 | 1 | 1.1 | 22 22 | 18.03.19 08:19:22 | 2019-03-18 08:19:22+01:00 |
| 36329957 | 36329957 | 21 | 08:17:53 | 18.03.19 | 1 | 4.0 | 22 22 | 18.03.19 08:17:53 | 2019-03-18 08:17:53+01:00 |
| 36329956 | 36329956 | 17 | 08:16:06 | 18.03.19 | 1 | 1.1 | 22 22 | 18.03.19 08:16:06 | 2019-03-18 08:16:06+01:00 |
| 36329955 | 36329955 | 33 | 08:15:40 | 18.03.19 | 1 | 4.9 | 22 22 | 18.03.19 08:15:40 | 2019-03-18 08:15:40+01:00 |
| 36329954 | 36329954 | 28 | 08:15:27 | 18.03.19 | 1 | 4.8 | 22 22 | 18.03.19 08:15:27 | 2019-03-18 08:15:27+01:00 |
| 36329953 | 36329953 | 25 | 08:13:59 | 18.03.19 | 1 | 4.5 | 22 22 | 18.03.19 08:13:59 | 2019-03-18 08:13:59+01:00 |
| 36329952 | 36329952 | 31 | 08:13:52 | 18.03.19 | 1 | 12.4 | 22 22 | 18.03.19 08:13:52 | 2019-03-18 08:13:52+01:00 |
| 36329951 | 36329951 | 33 | 08:11:57 | 18.03.19 | 1 | 4.0 | 22 22 | 18.03.19 08:11:57 | 2019-03-18 08:11:57+01:00 |
| 36322973 | 36322973 | 35 | 08:09:56 | 18.03.19 | 2 | 5.4 | 22 22 | 18.03.19 08:09:56 | 2019-03-18 08:09:56+01:00 |
| 36329950 | 36329950 | 27 | 08:09:51 | 18.03.19 | 1 | 3.5 | 22 22 | 18.03.19 08:09:51 | 2019-03-18 08:09:51+01:00 |
| 36329949 | 36329949 | 19 | 08:09:02 | 18.03.19 | 1 | 1.3 | 22 22 | 18.03.19 08:09:02 | 2019-03-18 08:09:02+01:00 |
| 36329948 | 36329948 | 26 | 08:04:54 | 18.03.19 | 1 | 4.0 | 22 22 | 18.03.19 08:04:54 | 2019-03-18 08:04:54+01:00 |
| 36322972 | 36322972 | 39 | 08:04:35 | 18.03.19 | 2 | 4.5 | 22 22 | 18.03.19 08:04:35 | 2019-03-18 08:04:35+01:00 |
| 36329947 | 36329947 | 33 | 08:01:31 | 18.03.19 | 1 | 5.7 | 22 22 | 18.03.19 08:01:31 | 2019-03-18 08:01:31+01:00 |
| 36329946 | 36329946 | 28 | 08:01:28 | 18.03.19 | 1 | 4.7 | 22 22 | 18.03.19 08:01:28 | 2019-03-18 08:01:28+01:00 |
| 36329945 | 36329945 | 30 | 08:01:18 | 18.03.19 | 1 | 5.1 | 22 22 | 18.03.19 08:01:18 | 2019-03-18 08:01:18+01:00 |
| 36322971 | 36322971 | 31 | 07:55:48 | 18.03.19 | 2 | 4.9 | 22 22 | 18.03.19 07:55:48 | 2019-03-18 07:55:48+01:00 |
| 36329944 | 36329944 | 24 | 07:54:15 | 18.03.19 | 1 | 4.3 | 22 22 | 18.03.19 07:54:15 | 2019-03-18 07:54:15+01:00 |
| 36329943 | 36329943 | 26 | 07:52:51 | 18.03.19 | 1 | 1.4 | 22 22 | 18.03.19 07:52:51 | 2019-03-18 07:52:51+01:00 |
| 36329942 | 36329942 | 37 | 07:49:17 | 18.03.19 | 1 | 5.6 | 22 22 | 18.03.19 07:49:17 | 2019-03-18 07:49:17+01:00 |
| 36322970 | 36322970 | 33 | 07:47:09 | 18.03.19 | 2 | 3.9 | 22 22 | 18.03.19 07:47:09 | 2019-03-18 07:47:09+01:00 |
| 36329941 | 36329941 | 13 | 07:46:50 | 18.03.19 | 1 | 5.4 | 22 22 | 18.03.19 07:46:50 | 2019-03-18 07:46:50+01:00 |
| 36329940 | 36329940 | 33 | 07:46:09 | 18.03.19 | 1 | 4.3 | 22 22 | 18.03.19 07:46:09 | 2019-03-18 07:46:09+01:00 |
| 36329939 | 36329939 | 40 | 07:45:40 | 18.03.19 | 1 | 3.9 | 22 22 | 18.03.19 07:45:40 | 2019-03-18 07:45:40+01:00 |
| 36329938 | 36329938 | 21 | 07:43:34 | 18.03.19 | 1 | 1.1 | 22 22 | 18.03.19 07:43:34 | 2019-03-18 07:43:34+01:00 |
| 36322969 | 36322969 | 35 | 07:42:12 | 18.03.19 | 2 | 5.7 | 22 22 | 18.03.19 07:42:12 | 2019-03-18 07:42:12+01:00 |
| 36329937 | 36329937 | 39 | 07:40:30 | 18.03.19 | 1 | 3.4 | 22 22 | 18.03.19 07:40:30 | 2019-03-18 07:40:30+01:00 |
| 36329936 | 36329936 | 29 | 07:40:18 | 18.03.19 | 1 | 5.0 | 22 22 | 18.03.19 07:40:18 | 2019-03-18 07:40:18+01:00 |
| 36329935 | 36329935 | 29 | 07:38:06 | 18.03.19 | 1 | 5.2 | 22 22 | 18.03.19 07:38:06 | 2019-03-18 07:38:06+01:00 |
| 36329934 | 36329934 | 29 | 07:37:39 | 18.03.19 | 1 | 5.1 | 22 22 | 18.03.19 07:37:39 | 2019-03-18 07:37:39+01:00 |
| 36322968 | 36322968 | 35 | 07:30:00 | 18.03.19 | 2 | 3.9 | 22 22 | 18.03.19 07:30:00 | 2019-03-18 07:30:00+01:00 |
| 36329933 | 36329933 | 31 | 07:29:26 | 18.03.19 | 1 | 7.1 | 22 22 | 18.03.19 07:29:26 | 2019-03-18 07:29:26+01:00 |
| 36322967 | 36322967 | 36 | 07:26:49 | 18.03.19 | 2 | 5.0 | 22 22 | 18.03.19 07:26:49 | 2019-03-18 07:26:49+01:00 |
| 36329932 | 36329932 | 16 | 07:22:06 | 18.03.19 | 1 | 2.6 | 22 22 | 18.03.19 07:22:06 | 2019-03-18 07:22:06+01:00 |
| 36329931 | 36329931 | 12 | 07:19:24 | 18.03.19 | 1 | 2.2 | 22 22 | 18.03.19 07:19:24 | 2019-03-18 07:19:24+01:00 |
| 36322966 | 36322966 | 37 | 07:16:23 | 18.03.19 | 2 | 5.2 | 22 22 | 18.03.19 07:16:23 | 2019-03-18 07:16:23+01:00 |
| 36329930 | 36329930 | 29 | 07:12:58 | 18.03.19 | 1 | 5.7 | 22 22 | 18.03.19 07:12:58 | 2019-03-18 07:12:58+01:00 |
| 36329929 | 36329929 | 34 | 07:11:58 | 18.03.19 | 1 | 5.4 | 22 22 | 18.03.19 07:11:58 | 2019-03-18 07:11:58+01:00 |
| 36329928 | 36329928 | 26 | 07:10:14 | 18.03.19 | 1 | 5.9 | 22 22 | 18.03.19 07:10:14 | 2019-03-18 07:10:14+01:00 |
| 36329927 | 36329927 | 18 | 07:10:11 | 18.03.19 | 1 | 4.9 | 22 22 | 18.03.19 07:10:11 | 2019-03-18 07:10:11+01:00 |
| 36329926 | 36329926 | 27 | 07:09:40 | 18.03.19 | 1 | 1.7 | 22 22 | 18.03.19 07:09:40 | 2019-03-18 07:09:40+01:00 |
| 36322965 | 36322965 | 33 | 06:59:29 | 18.03.19 | 2 | 4.7 | 22 22 | 18.03.19 06:59:29 | 2019-03-18 06:59:29+01:00 |
| 36322964 | 36322964 | 36 | 06:58:19 | 18.03.19 | 2 | 4.6 | 22 22 | 18.03.19 06:58:19 | 2019-03-18 06:58:19+01:00 |
| 36329925 | 36329925 | 37 | 06:45:33 | 18.03.19 | 1 | 5.2 | 22 22 | 18.03.19 06:45:33 | 2019-03-18 06:45:33+01:00 |
| 36329924 | 36329924 | 32 | 06:40:42 | 18.03.19 | 1 | 2.4 | 22 22 | 18.03.19 06:40:42 | 2019-03-18 06:40:42+01:00 |
| 36329923 | 36329923 | 27 | 06:35:24 | 18.03.19 | 1 | 5.6 | 22 22 | 18.03.19 06:35:24 | 2019-03-18 06:35:24+01:00 |
| 36322963 | 36322963 | 17 | 06:30:43 | 18.03.19 | 2 | 5.3 | 22 22 | 18.03.19 06:30:43 | 2019-03-18 06:30:43+01:00 |
| 36329922 | 36329922 | 16 | 06:30:10 | 18.03.19 | 1 | 3.7 | 22 22 | 18.03.19 06:30:10 | 2019-03-18 06:30:10+01:00 |
| 36329921 | 36329921 | 35 | 05:41:48 | 18.03.19 | 1 | 5.9 | 22 22 | 18.03.19 05:41:48 | 2019-03-18 05:41:48+01:00 |
| 36329920 | 36329920 | 27 | 05:40:17 | 18.03.19 | 1 | 5.6 | 22 22 | 18.03.19 05:40:17 | 2019-03-18 05:40:17+01:00 |
| 36329919 | 36329919 | 26 | 05:35:04 | 18.03.19 | 1 | 5.5 | 22 22 | 18.03.19 05:35:04 | 2019-03-18 05:35:04+01:00 |
| 36329918 | 36329918 | 25 | 05:31:15 | 18.03.19 | 1 | 5.4 | 22 22 | 18.03.19 05:31:15 | 2019-03-18 05:31:15+01:00 |
| 36329917 | 36329917 | 30 | 02:56:25 | 18.03.19 | 1 | 4.9 | 22 22 | 18.03.19 02:56:25 | 2019-03-18 02:56:25+01:00 |
| 36329916 | 36329916 | 39 | 01:55:44 | 18.03.19 | 1 | 5.9 | 22 22 | 18.03.19 01:55:44 | 2019-03-18 01:55:44+01:00 |
| 36329915 | 36329915 | 25 | 00:38:21 | 18.03.19 | 1 | 5.6 | 22 22 | 18.03.19 00:38:21 | 2019-03-18 00:38:21+01:00 |
| 36329914 | 36329914 | 18 | 00:38:04 | 18.03.19 | 1 | 3.9 | 22 22 | 18.03.19 00:38:04 | 2019-03-18 00:38:04+01:00 |
| 36329913 | 36329913 | 23 | 00:27:03 | 18.03.19 | 1 | 6.3 | 22 22 | 18.03.19 00:27:03 | 2019-03-18 00:27:03+01:00 |
| 36322962 | 36322962 | 40 | 00:16:26 | 18.03.19 | 2 | 4.9 | 22 22 | 18.03.19 00:16:26 | 2019-03-18 00:16:26+01:00 |
| 36329912 | 36329912 | 26 | 00:05:36 | 18.03.19 | 1 | 3.3 | 22 22 | 18.03.19 00:05:36 | 2019-03-18 00:05:36+01:00 |
| 36329911 | 36329911 | 28 | 00:05:33 | 18.03.19 | 1 | 5.1 | 22 22 | 18.03.19 00:05:33 | 2019-03-18 00:05:33+01:00 |
| 36322961 | 36322961 | 26 | 00:04:32 | 18.03.19 | 2 | 1.2 | 22 22 | 18.03.19 00:04:32 | 2019-03-18 00:04:32+01:00 |
| 36322960 | 36322960 | 26 | 00:04:27 | 18.03.19 | 2 | 4.8 | 22 22 | 18.03.19 00:04:27 | 2019-03-18 00:04:27+01:00 |
| 36329910 | 36329910 | 19 | 00:02:56 | 18.03.19 | 1 | 4.5 | 22 22 | 18.03.19 00:02:56 | 2019-03-18 00:02:56+01:00 |
| 36329909 | 36329909 | 28 | 00:02:30 | 18.03.19 | 1 | 7.0 | 22 22 | 18.03.19 00:02:30 | 2019-03-18 00:02:30+01:00 |
| 36329908 | 36329908 | 30 | 00:01:04 | 18.03.19 | 1 | 4.9 | 22 22 | 18.03.19 00:01:04 | 2019-03-18 00:01:04+01:00 |
| 36322959 | 36322959 | 26 | 23:58:22 | 17.03.19 | 2 | 4.1 | 22 22 | 17.03.19 23:58:22 | 2019-03-17 23:58:22+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");